APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANY_SITES

Line 22: TYPE companySites IS TABLE of msc_company_sites.company_site_name%TYPE;

18:
19:
20: -- ===== Data types for Bulk Collections ====
21: TYPE companyNames IS TABLE of msc_companies.company_name%TYPE;
22: TYPE companySites IS TABLE of msc_company_sites.company_site_name%TYPE;
23: -- TYPE customerClassCodes IS TABLE of msc_companies.customer_class_code%TYPE;
24: -- TYPE calendarCodes IS TABLE of msc_companies.calendar_code%TYPE;
25: TYPE number_arr IS TABLE OF NUMBER;
26: TYPE date_arr IS TABLE OF DATE;

Line 29: TYPE locationCodes IS TABLE OF msc_company_sites.location%TYPE;

25: TYPE number_arr IS TABLE OF NUMBER;
26: TYPE date_arr IS TABLE OF DATE;
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;

Line 42: TYPE addressLines IS TABLE OF msc_company_sites.address1%TYPE;

38: TYPE descriptions IS TABLE OF msc_item_customers.description%TYPE;
39: TYPE uomCodes IS TABLE OF msc_item_customers.uom_code%TYPE;
40: TYPE plannerCodes IS TABLE OF msc_item_customers.planner_code%TYPE;
41: TYPE deliveryCalCodes IS TABLE OF msc_item_suppliers.delivery_calendar_code%TYPE;
42: TYPE addressLines IS TABLE OF msc_company_sites.address1%TYPE;
43: TYPE counties IS TABLE OF msc_st_trading_partner_sites.county%TYPE;
44: TYPE provinces IS TABLE OF msc_st_trading_partner_sites.province%TYPE;
45: TYPE users IS TABLE OF fnd_user.user_name%TYPE;
46: