27: TYPE char3_arr IS TABLE OF VARCHAR2(3);
28: TYPE char_arr IS TABLE OF VARCHAR2(1);
29: TYPE locationCodes IS TABLE OF msc_company_sites.location%TYPE;
30:
31: TYPE partnerAddresses IS TABLE OF msc_trading_partner_sites.partner_address%TYPE;
32: TYPE countries IS TABLE OF msc_trading_partner_sites.country%TYPE;
33: TYPE states IS TABLE OF msc_trading_partner_sites.state%TYPE;
34: TYPE cities IS TABLE OF msc_trading_partner_sites.city%TYPE;
35: TYPE postalCodes IS TABLE OF msc_trading_partner_sites.postal_code%TYPE;
28: TYPE char_arr IS TABLE OF VARCHAR2(1);
29: TYPE locationCodes IS TABLE OF msc_company_sites.location%TYPE;
30:
31: TYPE partnerAddresses IS TABLE OF msc_trading_partner_sites.partner_address%TYPE;
32: TYPE countries IS TABLE OF msc_trading_partner_sites.country%TYPE;
33: TYPE states IS TABLE OF msc_trading_partner_sites.state%TYPE;
34: TYPE cities IS TABLE OF msc_trading_partner_sites.city%TYPE;
35: TYPE postalCodes IS TABLE OF msc_trading_partner_sites.postal_code%TYPE;
36: TYPE items IS TABLE OF msc_system_items.item_name%TYPE;
29: TYPE locationCodes IS TABLE OF msc_company_sites.location%TYPE;
30:
31: TYPE partnerAddresses IS TABLE OF msc_trading_partner_sites.partner_address%TYPE;
32: TYPE countries IS TABLE OF msc_trading_partner_sites.country%TYPE;
33: TYPE states IS TABLE OF msc_trading_partner_sites.state%TYPE;
34: TYPE cities IS TABLE OF msc_trading_partner_sites.city%TYPE;
35: TYPE postalCodes IS TABLE OF msc_trading_partner_sites.postal_code%TYPE;
36: TYPE items IS TABLE OF msc_system_items.item_name%TYPE;
37: TYPE rowids IS TABLE OF VARCHAR2(100);
30:
31: TYPE partnerAddresses IS TABLE OF msc_trading_partner_sites.partner_address%TYPE;
32: TYPE countries IS TABLE OF msc_trading_partner_sites.country%TYPE;
33: TYPE states IS TABLE OF msc_trading_partner_sites.state%TYPE;
34: TYPE cities IS TABLE OF msc_trading_partner_sites.city%TYPE;
35: TYPE postalCodes IS TABLE OF msc_trading_partner_sites.postal_code%TYPE;
36: TYPE items IS TABLE OF msc_system_items.item_name%TYPE;
37: TYPE rowids IS TABLE OF VARCHAR2(100);
38: TYPE descriptions IS TABLE OF msc_item_customers.description%TYPE;
31: TYPE partnerAddresses IS TABLE OF msc_trading_partner_sites.partner_address%TYPE;
32: TYPE countries IS TABLE OF msc_trading_partner_sites.country%TYPE;
33: TYPE states IS TABLE OF msc_trading_partner_sites.state%TYPE;
34: TYPE cities IS TABLE OF msc_trading_partner_sites.city%TYPE;
35: TYPE postalCodes IS TABLE OF msc_trading_partner_sites.postal_code%TYPE;
36: TYPE items IS TABLE OF msc_system_items.item_name%TYPE;
37: TYPE rowids IS TABLE OF VARCHAR2(100);
38: TYPE descriptions IS TABLE OF msc_item_customers.description%TYPE;
39: TYPE uomCodes IS TABLE OF msc_item_customers.uom_code%TYPE;