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_UTIL_PVT

Line 153: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_CURRENCY_RATES');

149: );
150: END IF;
151: COMMIT;
152: BIS_COLLECTION_UTILITIES.put_line('Currency Rates Table Populated Successfully!');
153: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_CURRENCY_RATES');
154: BIS_COLLECTION_UTILITIES.put_line('Currency Rates Table Analyzed');
155: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
156: BIS_COLLECTION_UTILITIES.Debug('End of Populate Currency Rates');
157: END IF;

Line 242: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

238: p_to_currency => rate_record.to_currency,
239: p_date => rate_record.exchange_date);
240: END IF;
241: END LOOP;
242: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
243: RETURN -1;
244: End If;
245: Return 1;
246: Else -- check missing primary/secondary currency rates

Line 301: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

297: p_date => rate_record.exchange_date);
298: END IF;
299: END IF;
300: END LOOP;
301: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
302: RETURN -1;
303: End If;
304: Return 1;
305: End If;

Line 415: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

411: p_date => rate_record.exchange_date);
412: END IF;
413: END IF;
414: END LOOP;
415: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
416: RETURN -1;
417: ELSE --'PFS' check primary, functional and secondary missing currency
418: BIS_COLLECTION_UTILITIES.put_line_out('Missing Primary Currency/Functional/Secondary Currency Rates Found!');
419: BIS_COLLECTION_UTILITIES.put_line('Missing Primary Currency/Functional/Secondary Currency Rates Found!');

Line 474: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

470: p_date => rate_record.exchange_date);
471: END IF;
472: END IF;
473: END LOOP;
474: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
475: RETURN -1;
476: END IF;
477: End If;
478:

Line 587: ASO_BI_UTIL_PVT.INIT;

583: -- Initialize
584: BIS_COLLECTION_UTILITIES.debug('Initialization');
585: END IF;
586:
587: ASO_BI_UTIL_PVT.INIT;
588:
589: g_prim_currency := bis_common_parameters.get_currency_code;
590: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
591:

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

612: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
613: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
614: END IF;
615:
616: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
617: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
618:
619: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
620: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -

Line 617: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');

613: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
614: END IF;
615:
616: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
617: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
618:
619: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
620: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -
621: ONE_SECOND;

Line 719: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');

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:
721: BIS_COLLECTION_UTILITIES.wrapup(
722: p_status => TRUE ,
723: p_count => 0,

Line 734: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

730: retcode := -1;
731:
732: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
733:
734: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
735:
736: BIS_COLLECTION_UTILITIES.wrapup(
737: p_status => FALSE ,
738: p_message => sqlerrm,

Line 749: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');

745: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
746: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Facts:'||errbuf);
747: END IF;
748:
749: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');
750: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
751:
752: BIS_COLLECTION_UTILITIES.wrapup(
753: p_status => FALSE ,

Line 750: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

746: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Facts:'||errbuf);
747: END IF;
748:
749: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');
750: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
751:
752: BIS_COLLECTION_UTILITIES.wrapup(
753: p_status => FALSE ,
754: p_message => sqlerrm,

Line 796: ASO_BI_UTIL_PVT.INIT;

792: BIS_COLLECTION_UTILITIES.debug('Initialization');
793: END IF;
794:
795: -- Initialize
796: ASO_BI_UTIL_PVT.INIT;
797:
798: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
799: l_list(2) := 'BIS_PRIMARY_RATE_TYPE';
800: /* Check seondary global currency is implemeneted */

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

818: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
819: END IF;
820:
821: -- Truncate the processing tables
822: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
823: --As this is a initial load the Base Fact Table is assumed to be empty
824: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_ALL');
825:
826: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));

Line 824: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_ALL');

820:
821: -- Truncate the processing tables
822: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
823: --As this is a initial load the Base Fact Table is assumed to be empty
824: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_ALL');
825:
826: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
827: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -
828: ONE_SECOND;

Line 903: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

899: retcode := -1;
900:
901: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
902:
903: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
904:
905: BIS_COLLECTION_UTILITIES.wrapup(
906: p_status => FALSE ,
907: p_message => sqlerrm,

Line 919: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

915: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of Quote Hdr Fact:'
916: ||errbuf);
917: END IF;
918:
919: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
920:
921: BIS_COLLECTION_UTILITIES.wrapup(
922: p_status => FALSE ,
923: p_message => sqlerrm,

Line 964: ASO_BI_UTIL_PVT.INIT;

960: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
961: BIS_COLLECTION_UTILITIES.debug('Initialization started ');
962: END IF;
963: BIS_COLLECTION_UTILITIES.put_line('Initialization started ');
964: ASO_BI_UTIL_PVT.INIT;
965:
966: g_prim_currency := bis_common_parameters.get_currency_code;
967: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
968:

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

996: 'Cleaning up the tables before processing starts.');
997: END IF;
998:
999: -- Truncate all the temp tables
1000: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1004:

Line 1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

997: END IF;
998:
999: -- Truncate all the temp tables
1000: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1004:
1005: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');

998:
999: -- Truncate all the temp tables
1000: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1004:
1005: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
1006: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -

Line 1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');

999: -- Truncate all the temp tables
1000: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1004:
1005: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
1006: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -
1007: ONE_SECOND;

Line 1124: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

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');
1126:
1127: BIS_COLLECTION_UTILITIES.wrapup(
1128: p_status => TRUE ,

Line 1125: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

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');
1126:
1127: BIS_COLLECTION_UTILITIES.wrapup(
1128: p_status => TRUE ,
1129: p_count => 0,

Line 1140: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1136: retcode := -1;
1137:
1138: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
1139:
1140: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1141:
1142: BIS_COLLECTION_UTILITIES.wrapup(
1143: p_status => FALSE ,
1144: p_message => sqlerrm,

Line 1154: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

1150: errbuf := sqlerrm;
1151: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1152: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Lines Fact:'||errbuf);
1153: END IF;
1154: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1155: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1156:
1157: BIS_COLLECTION_UTILITIES.wrapup(
1158: p_status => FALSE ,

Line 1155: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1151: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1152: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Lines Fact:'||errbuf);
1153: END IF;
1154: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1155: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1156:
1157: BIS_COLLECTION_UTILITIES.wrapup(
1158: p_status => FALSE ,
1159: p_message => sqlerrm,

Line 1210: ASO_BI_UTIL_PVT.INIT;

1206: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1207: BIS_COLLECTION_UTILITIES.debug('Initialization');
1208: END IF;
1209: BIS_COLLECTION_UTILITIES.put_line('Initialization');
1210: ASO_BI_UTIL_PVT.INIT;
1211:
1212: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
1213: l_list(2) := 'BIS_PRIMARY_RATE_TYPE';
1214: l_list(3) := 'BIS_TREASURY_RATE_TYPE';

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

1235: 'Cleaning up the tables before processing starts.');
1236: END IF;
1237: BIS_COLLECTION_UTILITIES.put_line('Cleaning up the tables before processing starts.');
1238:
1239: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1240: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1241: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1242: -- As this is a initial load the Base Fact Table is assumed to be empty
1243: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_ALL');

Line 1240: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

1236: END IF;
1237: BIS_COLLECTION_UTILITIES.put_line('Cleaning up the tables before processing starts.');
1238:
1239: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1240: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1241: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1242: -- As this is a initial load the Base Fact Table is assumed to be empty
1243: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_ALL');
1244:

Line 1241: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');

1237: BIS_COLLECTION_UTILITIES.put_line('Cleaning up the tables before processing starts.');
1238:
1239: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1240: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1241: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1242: -- As this is a initial load the Base Fact Table is assumed to be empty
1243: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_ALL');
1244:
1245: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1243: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_ALL');

1239: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1240: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1241: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1242: -- As this is a initial load the Base Fact Table is assumed to be empty
1243: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_ALL');
1244:
1245: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
1246: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -
1247: ONE_SECOND;

Line 1339: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

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');
1341:
1342: BIS_COLLECTION_UTILITIES.wrapup(
1343: p_status => TRUE ,

Line 1340: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

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');
1341:
1342: BIS_COLLECTION_UTILITIES.wrapup(
1343: p_status => TRUE ,
1344: p_count => 0,

Line 1355: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1351: WHEN G_PROFILE_NOT_SET THEN -- PROFILE NOT SET exception
1352: retcode := -1;
1353:
1354: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
1355: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1356:
1357: BIS_COLLECTION_UTILITIES.wrapup(
1358: p_status => FALSE ,
1359: p_message => sqlerrm,

Line 1370: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');

1366: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1367: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of Quote Line Fact:'
1368: ||errbuf);
1369: END IF;
1370: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1371: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1372:
1373: BIS_COLLECTION_UTILITIES.wrapup(
1374: p_status => FALSE ,

Line 1371: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1367: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of Quote Line Fact:'
1368: ||errbuf);
1369: END IF;
1370: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1371: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1372:
1373: BIS_COLLECTION_UTILITIES.wrapup(
1374: p_status => FALSE ,
1375: p_message => sqlerrm,