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.ISC_DBI_BSA_OBJECTS_C dependencies on FII_UTIL

Line 81: fii_util.start_timer;

77: return(-1);
78: end if;
79:
80: bis_collection_utilities.put_line('Truncating the temp tables');
81: fii_util.start_timer;
82:
83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
85:

Line 86: fii_util.stop_timer;

82:
83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
85:
86: fii_util.stop_timer;
87: fii_util.print_timer('Truncated the temp tables in');
88: bis_collection_utilities.put_line(' ');
89:
90: return(1);

Line 87: fii_util.print_timer('Truncated the temp tables in');

83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
85:
86: fii_util.stop_timer;
87: fii_util.print_timer('Truncated the temp tables in');
88: bis_collection_utilities.put_line(' ');
89:
90: return(1);
91:

Line 108: fii_util.start_timer;

104:
105: l_bsa_count := 0;
106:
107: bis_collection_utilities.put_line('Identifying blanket sales agreements');
108: fii_util.start_timer;
109:
110: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_tmp_bsa_order_lines f (
111: order_line_id,
112: order_line_header_id,

Line 226: fii_util.stop_timer;

222: and book.unit_selling_price(+) <> 0
223: and book.charge_periodicity_code(+) is null;
224:
225: l_bsa_count := sql%rowcount;
226: fii_util.stop_timer;
227: fii_util.print_timer('Identified ' || l_bsa_count || ' blanket sales agreement in');
228: commit;
229:
230: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (

Line 227: fii_util.print_timer('Identified ' || l_bsa_count || ' blanket sales agreement in');

223: and book.charge_periodicity_code(+) is null;
224:
225: l_bsa_count := sql%rowcount;
226: fii_util.stop_timer;
227: fii_util.print_timer('Identified ' || l_bsa_count || ' blanket sales agreement in');
228: commit;
229:
230: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (
231: from_currency,

Line 357: fii_util.start_timer;

353: l_line lines_missing_date%rowtype;
354:
355: begin
356:
357: fii_util.start_timer;
358:
359: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');
360: select /*+ PARALLEL(tmp) */
361: min(time_activation_date_id), max(time_activation_date_id),

Line 376: fii_util.stop_timer;

372: l_max := greatest(l_max_act_date,
373: nvl(l_max_exp_date,l_max_act_date),
374: nvl(l_max_trm_date, l_max_act_date));
375:
376: fii_util.stop_timer;
377: fii_util.print_timer('Retrieved the time boundary in ');
378:
379: fii_util.start_timer;
380:

Line 377: fii_util.print_timer('Retrieved the time boundary in ');

373: nvl(l_max_exp_date,l_max_act_date),
374: nvl(l_max_trm_date, l_max_act_date));
375:
376: fii_util.stop_timer;
377: fii_util.print_timer('Retrieved the time boundary in ');
378:
379: fii_util.start_timer;
380:
381: bis_collection_utilities.put_line_out(' ');

Line 379: fii_util.start_timer;

375:
376: fii_util.stop_timer;
377: fii_util.print_timer('Retrieved the time boundary in ');
378:
379: fii_util.start_timer;
380:
381: bis_collection_utilities.put_line_out(' ');
382: bis_collection_utilities.put_line_out(' ');
383: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);

Line 427: fii_util.stop_timer;

423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
424: bis_collection_utilities.put_line(' ');
425: end if;
426:
427: fii_util.stop_timer;
428: fii_util.print_timer('Completed time continuity check in');
429:
430: return(1);
431:

Line 428: fii_util.print_timer('Completed time continuity check in');

424: bis_collection_utilities.put_line(' ');
425: end if;
426:
427: fii_util.stop_timer;
428: fii_util.print_timer('Completed time continuity check in');
429:
430: return(1);
431:
432: exception

Line 456: fii_util.start_timer;

452: l_dangling := 0;
453:
454: bis_collection_utilities.put_line(' ');
455: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
456: fii_util.start_timer;
457:
458: l_miss_conv := REPORT_MISSING_RATE;
459:
460: fii_util.stop_timer;

Line 460: fii_util.stop_timer;

456: fii_util.start_timer;
457:
458: l_miss_conv := REPORT_MISSING_RATE;
459:
460: fii_util.stop_timer;
461: fii_util.print_timer('Completed missing currency check in');
462:
463: if (l_miss_conv = -1) then
464: return(-1);

Line 461: fii_util.print_timer('Completed missing currency check in');

457:
458: l_miss_conv := REPORT_MISSING_RATE;
459:
460: fii_util.stop_timer;
461: fii_util.print_timer('Completed missing currency check in');
462:
463: if (l_miss_conv = -1) then
464: return(-1);
465: elsif (l_miss_conv > 0) then

Line 504: fii_util.start_timer;

500: begin
501:
502: bis_collection_utilities.put_line(' ');
503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');
504: fii_util.start_timer;
505:
506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (
507: order_line_id,
508: order_line_header_id,

Line 625: fii_util.stop_timer;

621: and tmp.h_start_date_active between sg.start_date and sg.end_date
622: and tmp.sold_to_org_id = cust_acct.cust_account_id;
623:
624: l_bsa_count := sql%rowcount;
625: fii_util.stop_timer;
626: fii_util.print_timer('Inserted '|| l_bsa_count ||' rows into isc_dbi_bsa_order_lines_f in');
627:
628: commit;
629:

Line 626: fii_util.print_timer('Inserted '|| l_bsa_count ||' rows into isc_dbi_bsa_order_lines_f in');

622: and tmp.sold_to_org_id = cust_acct.cust_account_id;
623:
624: l_bsa_count := sql%rowcount;
625: fii_util.stop_timer;
626: fii_util.print_timer('Inserted '|| l_bsa_count ||' rows into isc_dbi_bsa_order_lines_f in');
627:
628: commit;
629:
630: return(l_bsa_count);

Line 645: fii_util.start_timer;

641:
642: begin
643:
644: bis_collection_utilities.put_line('Truncating the temp tables');
645: fii_util.start_timer;
646:
647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
649:

Line 650: fii_util.stop_timer;

646:
647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
649:
650: fii_util.stop_timer;
651: fii_util.print_timer('Truncated the temp tables in');
652: bis_collection_utilities.put_line(' ');
653:
654: bis_collection_utilities.wrapup(

Line 651: fii_util.print_timer('Truncated the temp tables in');

647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
649:
650: fii_util.stop_timer;
651: fii_util.print_timer('Truncated the temp tables in');
652: bis_collection_utilities.put_line(' ');
653:
654: bis_collection_utilities.wrapup(
655: true,

Line 718: fii_util.start_timer;

714:
715: elsif (l_row_count = 0) then
716: bis_collection_utilities.put_line(' ');
717: bis_collection_utilities.put_line('Truncating the fact tables');
718: fii_util.start_timer;
719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
721:
722: fii_util.stop_timer;

Line 722: fii_util.stop_timer;

718: fii_util.start_timer;
719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
721:
722: fii_util.stop_timer;
723: fii_util.print_timer('Truncated the fact tables in');
724: g_row_count := 0;
725:
726: else

Line 723: fii_util.print_timer('Truncated the fact tables in');

719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
721:
722: fii_util.stop_timer;
723: fii_util.print_timer('Truncated the fact tables in');
724: g_row_count := 0;
725:
726: else
727: bis_collection_utilities.put_line(' ');

Line 729: fii_util.start_timer;

725:
726: else
727: bis_collection_utilities.put_line(' ');
728: bis_collection_utilities.put_line('Analyzing temp tables');
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,
732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
733: fnd_stats.gather_table_stats(ownname => g_isc_schema,

Line 736: fii_util.stop_timer;

732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
733: fnd_stats.gather_table_stats(ownname => g_isc_schema,
734: tabname => 'ISC_CURR_BSA_ORDER_LINES');
735:
736: fii_util.stop_timer;
737: fii_util.print_timer('Analyzed the temp tables in ');
738:
739: if (DANGLING_CHECK_INIT = -1) then
740: raise l_failure;

Line 737: fii_util.print_timer('Analyzed the temp tables in ');

733: fnd_stats.gather_table_stats(ownname => g_isc_schema,
734: tabname => 'ISC_CURR_BSA_ORDER_LINES');
735:
736: fii_util.stop_timer;
737: fii_util.print_timer('Analyzed the temp tables in ');
738:
739: if (DANGLING_CHECK_INIT = -1) then
740: raise l_failure;
741: end if;

Line 745: fii_util.start_timer;

741: end if;
742:
743: bis_collection_utilities.put_line(' ');
744: bis_collection_utilities.put_line('Truncating the fact tables');
745: fii_util.start_timer;
746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
748:
749: fii_util.stop_timer;

Line 749: fii_util.stop_timer;

745: fii_util.start_timer;
746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
748:
749: fii_util.stop_timer;
750: fii_util.print_timer('Truncated the fact tables in');
751:
752: g_row_count := INSERT_FACT;
753:

Line 750: fii_util.print_timer('Truncated the fact tables in');

746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
748:
749: fii_util.stop_timer;
750: fii_util.print_timer('Truncated the fact tables in');
751:
752: g_row_count := INSERT_FACT;
753:
754: if (g_row_count = -1) then

Line 816: fii_util.start_timer;

812: -- analyze log table
813:
814: -- delete obsoleted records from base summary
815:
816: fii_util.start_timer;
817:
818: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_tmp_bsa_order_lines f (
819: order_line_id,
820: order_line_header_id,

Line 933: fii_util.stop_timer;

929: and book.ordered_quantity(+) <> 0
930: and book.unit_selling_price(+) <> 0
931: and book.charge_periodicity_code(+) is null;
932:
933: fii_util.stop_timer;
934: fii_util.print_timer('Identified '|| sql%rowcount || ' blanket sales agreement in');
935: commit;
936:
937: fii_util.start_timer;

Line 934: fii_util.print_timer('Identified '|| sql%rowcount || ' blanket sales agreement in');

930: and book.unit_selling_price(+) <> 0
931: and book.charge_periodicity_code(+) is null;
932:
933: fii_util.stop_timer;
934: fii_util.print_timer('Identified '|| sql%rowcount || ' blanket sales agreement in');
935: commit;
936:
937: fii_util.start_timer;
938:

Line 937: fii_util.start_timer;

933: fii_util.stop_timer;
934: fii_util.print_timer('Identified '|| sql%rowcount || ' blanket sales agreement in');
935: commit;
936:
937: fii_util.start_timer;
938:
939: insert /*+ APPEND */ into isc_curr_bsa_order_lines f (
940: from_currency,
941: conversion_date,

Line 954: fii_util.stop_timer;

950: fii_currency.get_global_rate_secondary(transactional_curr_code, time_activation_date_id)) rate2
951: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
952: from isc_dbi_tmp_bsa_order_lines tmp);
953:
954: fii_util.stop_timer;
955: fii_util.print_timer('Retrieved '||sql%rowcount||' currency rates in');
956: commit;
957:
958: fii_util.start_timer;

Line 955: fii_util.print_timer('Retrieved '||sql%rowcount||' currency rates in');

951: from (select /*+ PARALLEL(tmp) */ distinct transactional_curr_code, time_activation_date_id
952: from isc_dbi_tmp_bsa_order_lines tmp);
953:
954: fii_util.stop_timer;
955: fii_util.print_timer('Retrieved '||sql%rowcount||' currency rates in');
956: commit;
957:
958: fii_util.start_timer;
959:

Line 958: fii_util.start_timer;

954: fii_util.stop_timer;
955: fii_util.print_timer('Retrieved '||sql%rowcount||' currency rates in');
956: commit;
957:
958: fii_util.start_timer;
959:
960: update isc_dbi_tmp_bsa_order_lines set batch_id = ceil(rownum/g_batch_size);
961: l_total := sql%rowcount;
962: commit;

Line 964: fii_util.stop_timer;

960: update isc_dbi_tmp_bsa_order_lines set batch_id = ceil(rownum/g_batch_size);
961: l_total := sql%rowcount;
962: commit;
963:
964: fii_util.stop_timer;
965: fii_util.print_timer('Updated the batch id for '|| l_total || ' rows in');
966:
967: return(l_total);
968:

Line 965: fii_util.print_timer('Updated the batch id for '|| l_total || ' rows in');

961: l_total := sql%rowcount;
962: commit;
963:
964: fii_util.stop_timer;
965: fii_util.print_timer('Updated the batch id for '|| l_total || ' rows in');
966:
967: return(l_total);
968:
969: exception

Line 1012: fii_util.start_timer;

1008: l_line lines_missing_date%rowtype;
1009:
1010: begin
1011:
1012: fii_util.start_timer;
1013:
1014: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');
1015: select /*+ PARALLEL(tmp) */
1016: min(time_activation_date_id), max(time_activation_date_id),

Line 1031: fii_util.stop_timer;

1027: l_max := greatest(l_max_act_date,
1028: nvl(l_max_exp_date,l_max_act_date),
1029: nvl(l_max_trm_date, l_max_act_date));
1030:
1031: fii_util.stop_timer;
1032: fii_util.print_timer('Retrieved the time boundary in ');
1033:
1034: fii_util.start_timer;
1035:

Line 1032: fii_util.print_timer('Retrieved the time boundary in ');

1028: nvl(l_max_exp_date,l_max_act_date),
1029: nvl(l_max_trm_date, l_max_act_date));
1030:
1031: fii_util.stop_timer;
1032: fii_util.print_timer('Retrieved the time boundary in ');
1033:
1034: fii_util.start_timer;
1035:
1036: bis_collection_utilities.put_line_out(' ');

Line 1034: fii_util.start_timer;

1030:
1031: fii_util.stop_timer;
1032: fii_util.print_timer('Retrieved the time boundary in ');
1033:
1034: fii_util.start_timer;
1035:
1036: bis_collection_utilities.put_line_out(' ');
1037: bis_collection_utilities.put_line_out(' ');
1038: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);

Line 1082: fii_util.stop_timer;

1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
1079: bis_collection_utilities.put_line(' ');
1080: end if;
1081:
1082: fii_util.stop_timer;
1083: fii_util.print_timer('Completed time continuity check in');
1084:
1085: return(1);
1086:

Line 1083: fii_util.print_timer('Completed time continuity check in');

1079: bis_collection_utilities.put_line(' ');
1080: end if;
1081:
1082: fii_util.stop_timer;
1083: fii_util.print_timer('Completed time continuity check in');
1084:
1085: return(1);
1086:
1087: exception

Line 1109: fii_util.start_timer;

1105: l_dangling := 0;
1106:
1107: bis_collection_utilities.put_line(' ');
1108: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
1109: fii_util.start_timer;
1110:
1111: l_miss_conv := REPORT_MISSING_RATE;
1112:
1113: fii_util.stop_timer;

Line 1113: fii_util.stop_timer;

1109: fii_util.start_timer;
1110:
1111: l_miss_conv := REPORT_MISSING_RATE;
1112:
1113: fii_util.stop_timer;
1114: fii_util.print_timer('Completed missing currency check in');
1115:
1116: if (l_miss_conv = -1) then
1117: return(-1);

Line 1114: fii_util.print_timer('Completed missing currency check in');

1110:
1111: l_miss_conv := REPORT_MISSING_RATE;
1112:
1113: fii_util.stop_timer;
1114: fii_util.print_timer('Completed missing currency check in');
1115:
1116: if (l_miss_conv = -1) then
1117: return(-1);
1118: elsif (l_miss_conv > 0) then

Line 1190: fii_util.start_timer;

1186: l_total := 0;
1187: l_date := to_date('01/01/0001','DD/MM/YYYY');
1188:
1189: for v_batch_id in 1..p_batch loop
1190: fii_util.start_timer;
1191: bis_collection_utilities.put_line('Merging batch '||v_batch_id);
1192:
1193: l_count := 0;
1194:

Line 1439: fii_util.stop_timer;

1435: l_count := sql%rowcount;
1436: l_total := l_total + l_count;
1437: commit;
1438:
1439: fii_util.stop_timer;
1440: fii_util.print_timer('Merged '||l_count|| ' rows in ');
1441:
1442: end loop;
1443:

Line 1440: fii_util.print_timer('Merged '||l_count|| ' rows in ');

1436: l_total := l_total + l_count;
1437: commit;
1438:
1439: fii_util.stop_timer;
1440: fii_util.print_timer('Merged '||l_count|| ' rows in ');
1441:
1442: end loop;
1443:
1444: return(l_total);

Line 1500: fii_util.start_timer;

1496: else
1497:
1498: bis_collection_utilities.put_line(' ');
1499: bis_collection_utilities.put_line('Analyzing temp tables');
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,

Line 1507: fii_util.stop_timer;

1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');
1506:
1507: fii_util.stop_timer;
1508: fii_util.print_timer('Analyzed the temp tables in ');
1509:
1510: if (DANGLING_CHECK_ICRL = -1) then
1511: raise l_failure;

Line 1508: fii_util.print_timer('Analyzed the temp tables in ');

1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');
1506:
1507: fii_util.stop_timer;
1508: fii_util.print_timer('Analyzed the temp tables in ');
1509:
1510: if (DANGLING_CHECK_ICRL = -1) then
1511: raise l_failure;
1512: end if;