to access record type in a record pl/sql
Hi
Im trying to query a record type in a procedure. here below is the code and error
Code:
CREATE OR REPLACE PACKAGE APPS.xx_suppliers
IS
TYPE supp_attr IS RECORD (p_attribute1 ap_invoices_all.attribute1%TYPE
,p_attribute2 ap_invoices_all.attribute2%TYPE
,p_attribute3 ap_invoices_all.attribute3%TYPE
,p_attribute4 ap_invoices_all.attribute4%TYPE);
TYPE xx_supp_contacts IS RECORD
(
p_contact_id number
, p_contact_role_id number
, p_attributes supp_attr );
TYPE contacts_tb IS TABLE OF xx_supp_contacts ;
TYPE supp_details IS RECORD
(
p_vendor_id ap_suppliers.vendor_id%TYPE