APPS.ASO_BI_POPULATE_APPR_FACTS dependencies on ASO_BI_UTIL_PVT

Line 38: ASO_BI_UTIL_PVT.INIT;

34:
35: -- Initialize
36: BIS_COLLECTION_UTILITIES.debug('Initialization');
37:
38: ASO_BI_UTIL_PVT.INIT;
39:
40: -- Truncate the processing tables
41: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
42:

Line 43: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');

39:
40: -- Truncate the processing tables
41: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
42:
43: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
44:
45: --As this is a initial load the Base Fact Table is assumed to be empty
46: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_F');
47: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_RUL_F');

Line 46: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_F');

42:
43: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
44:
45: --As this is a initial load the Base Fact Table is assumed to be empty
46: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_F');
47: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_RUL_F');
48:
49: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
50: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 - ONE_SECOND;

Line 47: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_RUL_F');

43: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
44:
45: --As this is a initial load the Base Fact Table is assumed to be empty
46: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_F');
47: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_APR_RUL_F');
48:
49: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
50: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 - ONE_SECOND;
51:

Line 132: ASO_BI_UTIL_PVT.INIT;

128:
129: -- Initialize
130: BIS_COLLECTION_UTILITIES.debug('Initialization');
131:
132: ASO_BI_UTIL_PVT.INIT;
133:
134: -- Truncate the processing tables
135: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
136: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');

Line 136: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');

132: ASO_BI_UTIL_PVT.INIT;
133:
134: -- Truncate the processing tables
135: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
136: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
137:
138: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
139: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 - ONE_SECOND;
140: