APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANIES

Line 21: TYPE companyNames IS TABLE of msc_companies.company_name%TYPE;

17: USER_AND_COMPANY CONSTANT NUMBER := 3;
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;

Line 23: -- TYPE customerClassCodes IS TABLE of msc_companies.customer_class_code%TYPE;

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;
27: TYPE char3_arr IS TABLE OF VARCHAR2(3);

Line 24: -- TYPE calendarCodes IS TABLE of msc_companies.calendar_code%TYPE;

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;
27: TYPE char3_arr IS TABLE OF VARCHAR2(3);
28: TYPE char_arr IS TABLE OF VARCHAR2(1);