DBA Data[Home] [Help]

APPS.ASO_BI_POPULATE_FACTS dependencies on ASO_BI_QUOTE_FACT_PVT

Line 644: ASO_BI_QUOTE_FACT_PVT.Populate_Quote_Ids(

640: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
641: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
642: END IF;
643:
644: ASO_BI_QUOTE_FACT_PVT.Populate_Quote_Ids(
645: p_from_date => l_from_date,
646: p_to_date => l_to_date) ;
647:
648: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 680: ASO_BI_QUOTE_FACT_PVT.Register_Jobs;

676: Return;
677: END IF;
678: BIS_COLLECTION_UTILITIES.put_line('Valid Currency Setup Exists. ');
679:
680: ASO_BI_QUOTE_FACT_PVT.Register_Jobs;
681:
682: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
683: BIS_COLLECTION_UTILITIES.Debug('Done Registering Jobs');
684: BIS_COLLECTION_UTILITIES.Debug('Launch Workers');

Line 716: ASO_BI_QUOTE_FACT_PVT.Populate_Data;

712:
713: Return;
714: END IF;
715: BIS_COLLECTION_UTILITIES.put_line('Populating Data in to fact table ');
716: ASO_BI_QUOTE_FACT_PVT.Populate_Data;
717: BIS_COLLECTION_UTILITIES.put_line('Truncating Staging table ');
718:
719: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');
720:

Line 852: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(

848: BIS_COLLECTION_UTILITIES.Debug('Start populating ASO_BI_QUOTE_IDS: ' ||
849: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
850: END IF;
851:
852: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(
853: p_from_date => l_from_date,
854: p_to_date => l_to_date) ;
855:
856: BIS_COLLECTION_UTILITIES.put_line('Quote Ids Table Populated');

Line 888: ASO_BI_QUOTE_FACT_PVT.InitiLoad_QotHdr;

884:
885: Return;
886: END IF;
887: BIS_COLLECTION_UTILITIES.put_line('Currency Rates Table Populated');
888: ASO_BI_QUOTE_FACT_PVT.InitiLoad_QotHdr;
889: BIS_COLLECTION_UTILITIES.put_line('Quote Headers Table Populated');
890: BIS_COLLECTION_UTILITIES.wrapup(
891: p_status => TRUE ,
892: p_count => 0,

Line 1033: ASO_BI_QUOTE_FACT_PVT.Populate_Quote_Ids(

1029: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
1030: END IF;
1031:
1032: --Get the quote ids that have changed in the given time range
1033: ASO_BI_QUOTE_FACT_PVT.Populate_Quote_Ids(
1034: p_from_date => l_from_date,
1035: p_to_date => l_to_date) ;
1036: BIS_COLLECTION_UTILITIES.put_line('Quote Ids Table Populated');
1037: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 1275: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(

1271: TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
1272: END IF;
1273: BIS_COLLECTION_UTILITIES.put_line(' Collect the changed quote header ids, quote numbers');
1274: -- collect the changed quote header ids, quote numbers
1275: ASO_BI_QUOTE_FACT_PVT.InitLoad_Quote_Ids(
1276: p_from_date => l_from_date,
1277: p_to_date => l_to_date) ;
1278:
1279: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN