PL/SQL (MOSC)

MOSC Banner

[Error] PLS-00302 : PLS-00302: component must be declared

edited Oct 8, 2015 10:33AM in PL/SQL (MOSC) 8 commentsAnswered ✓

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

   , p_vendor_name               ap_suppliers.vendor_name%TYPE

   , p_attributes           supp_attr

   , p_contacts                   contacts_tb  );

PROCEDURE s_details (            p_begin_supp_id     IN OUT NUMBER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center