eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_BI_POPULATE_FACTS dependencies on ASO_BI_LINE_FACT_PVT

Line 1043: ASO_BI_LINE_FACT_PVT.Populate_Quote_Line_Ids;

1039: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
1040: END IF;
1041:
1042: --Get the quote lines corresponding to the quotes changed in the time period
1043: ASO_BI_LINE_FACT_PVT.Populate_Quote_Line_Ids;
1044:
1045: /* Populate Currency Rates Table*/
1046: SELECT COUNT(*) INTO l_curr_count
1047: FROM ASO_BI_CURRENCY_RATES

Line 1080: ASO_BI_LINE_FACT_PVT.Register_Line_Jobs;

1076: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1077: BIS_COLLECTION_UTILITIES.Debug('Registering Line Jobs');
1078: END IF;
1079: --Register the jobs for lines by looking up ASO_BI_LINE_IDS table
1080: ASO_BI_LINE_FACT_PVT.Register_Line_Jobs;
1081:
1082: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1083: BIS_COLLECTION_UTILITIES.Debug('Done Registering Jobs');
1084: BIS_COLLECTION_UTILITIES.Debug('Launch '|| p_worker_no || ' Workers');

Line 1118: ASO_BI_LINE_FACT_PVT.Cleanup_Line_Data;

1114: Return;
1115: END IF;
1116: BIS_COLLECTION_UTILITIES.put_line('Quote Lines Staging Table Populated');
1117: --To Clean any deleted or updated lines from ASO_BI_QUOTE_LINES_ALL
1118: ASO_BI_LINE_FACT_PVT.Cleanup_Line_Data;
1119:
1120: --Merges data from the staging to the ASO_BI_QUOTE_LINES_ALL
1121: ASO_BI_LINE_FACT_PVT.Populate_Line_Data;
1122: BIS_COLLECTION_UTILITIES.put_line('Quote Line Fact Table Populated');

Line 1121: ASO_BI_LINE_FACT_PVT.Populate_Line_Data;

1117: --To Clean any deleted or updated lines from ASO_BI_QUOTE_LINES_ALL
1118: ASO_BI_LINE_FACT_PVT.Cleanup_Line_Data;
1119:
1120: --Merges data from the staging to the ASO_BI_QUOTE_LINES_ALL
1121: ASO_BI_LINE_FACT_PVT.Populate_Line_Data;
1122: BIS_COLLECTION_UTILITIES.put_line('Quote Line Fact Table Populated');
1123:
1124: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1125: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

Line 1290: ASO_BI_LINE_FACT_PVT.initLoad_Quote_Line_ids;

1286: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
1287: END IF;
1288: BIS_COLLECTION_UTILITIES.put_line('Quote Header Id Table Populated');
1289: -- collect the changed quote lines ids
1290: ASO_BI_LINE_FACT_PVT.initLoad_Quote_Line_ids;
1291: BIS_COLLECTION_UTILITIES.put_line('Quote Line Id Table Populated');
1292: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1293: BIS_COLLECTION_UTILITIES.Debug('End populating ASO_BI_LINE_IDS: ' ||
1294: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));

Line 1332: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLineStg;

1328: BIS_COLLECTION_UTILITIES.put_line('Currency rate Table Populated');
1329: BIS_COLLECTION_UTILITIES.put_line(' load qot line staging table');
1330:
1331: -- load qot line staging table
1332: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLineStg;
1333: BIS_COLLECTION_UTILITIES.put_line('Quote Line Staging Table Populated');
1334:
1335: -- Populate the Quote Lines table
1336: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLine;

Line 1336: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLine;

1332: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLineStg;
1333: BIS_COLLECTION_UTILITIES.put_line('Quote Line Staging Table Populated');
1334:
1335: -- Populate the Quote Lines table
1336: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLine;
1337: BIS_COLLECTION_UTILITIES.put_line('Quote Line Fact Table Populated');
1338:
1339: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1340: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');