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

Line 353: fii_util.start_timer;

349:
350: /* Population of GL Calendar Day */
351:
352: edw_log.put_line('Pushing Calendar Day');
353: fii_util.start_timer;
354:
355: OPEN gl_date_cursor;
356:
357: LOOP

Line 475: fii_util.stop_timer;

471: commit;
472:
473: END LOOP;
474:
475: fii_util.stop_timer;
476: fii_util.print_timer('Process Time');
477: edw_log.put_line(' ');
478:
479: CLOSE gl_date_cursor;

Line 476: fii_util.print_timer('Process Time');

472:
473: END LOOP;
474:
475: fii_util.stop_timer;
476: fii_util.print_timer('Process Time');
477: edw_log.put_line(' ');
478:
479: CLOSE gl_date_cursor;
480:

Line 485: fii_util.start_timer;

481:
482:
483: edw_log.put_line('Pushing Future Calendar Days');
484:
485: fii_util.start_timer;
486:
487:
488: OPEN gl_future_date_cursor;
489:

Line 575: fii_util.stop_timer;

571:
572: END LOOP;
573:
574:
575: fii_util.stop_timer;
576: fii_util.print_timer('Process Time');
577: edw_log.put_line(' ');
578:
579: CLOSE gl_future_date_cursor;

Line 576: fii_util.print_timer('Process Time');

572: END LOOP;
573:
574:
575: fii_util.stop_timer;
576: fii_util.print_timer('Process Time');
577: edw_log.put_line(' ');
578:
579: CLOSE gl_future_date_cursor;
580:

Line 586: fii_util.start_timer;

582:
583: /* Population of PA Calendar Day */
584:
585: edw_log.put_line('Pushing PA Calendar Day');
586: fii_util.start_timer;
587:
588: OPEN pa_date_cursor;
589:
590: LOOP

Line 664: fii_util.stop_timer;

660:
661: END LOOP;
662:
663: commit;
664: fii_util.stop_timer;
665: fii_util.print_timer('Process Time');
666: edw_log.put_line(' ');
667:
668: CLOSE pa_date_cursor;

Line 665: fii_util.print_timer('Process Time');

661: END LOOP;
662:
663: commit;
664: fii_util.stop_timer;
665: fii_util.print_timer('Process Time');
666: edw_log.put_line(' ');
667:
668: CLOSE pa_date_cursor;
669:

Line 674: fii_util.start_timer;

670:
671: /* Population of PA Period push down */
672:
673: edw_log.put_line('Pushing PA Period push down');
674: fii_util.start_timer;
675:
676: OPEN pa_period_cursor;
677:
678: LOOP

Line 741: fii_util.stop_timer;

737:
738: END LOOP;
739:
740: commit;
741: fii_util.stop_timer;
742: fii_util.print_timer('Process Time');
743: edw_log.put_line(' ');
744:
745: CLOSE pa_period_cursor;

Line 742: fii_util.print_timer('Process Time');

738: END LOOP;
739:
740: commit;
741: fii_util.stop_timer;
742: fii_util.print_timer('Process Time');
743: edw_log.put_line(' ');
744:
745: CLOSE pa_period_cursor;
746:

Line 751: fii_util.start_timer;

747:
748: /* Population of GL Period push down*/
749:
750: edw_log.put_line('Pushing GL Period push down to Calendar Day');
751: fii_util.start_timer;
752:
753: OPEN cal_period_cursor;
754:
755: LOOP

Line 815: fii_util.stop_timer;

811:
812: END LOOP;
813:
814: commit;
815: fii_util.stop_timer;
816: fii_util.print_timer('Process Time');
817: edw_log.put_line(' ');
818:
819: CLOSE cal_period_cursor;

Line 816: fii_util.print_timer('Process Time');

812: END LOOP;
813:
814: commit;
815: fii_util.stop_timer;
816: fii_util.print_timer('Process Time');
817: edw_log.put_line(' ');
818:
819: CLOSE cal_period_cursor;
820:

Line 829: fii_util.start_timer;

825:
826: /* Population of PA Period */
827:
828: edw_log.put_line('Pushing PA Period');
829: fii_util.start_timer;
830:
831: OPEN pa_period_cursor;
832:
833: LOOP

Line 872: fii_util.stop_timer;

868:
869: END LOOP;
870:
871: commit;
872: fii_util.stop_timer;
873: fii_util.print_timer('Process Time');
874: edw_log.put_line(' ');
875:
876: CLOSE pa_period_cursor;

Line 873: fii_util.print_timer('Process Time');

869: END LOOP;
870:
871: commit;
872: fii_util.stop_timer;
873: fii_util.print_timer('Process Time');
874: edw_log.put_line(' ');
875:
876: CLOSE pa_period_cursor;
877:

Line 882: fii_util.start_timer;

878:
879: /* Population of GL Period pushed down to PA period level*/
880:
881: edw_log.put_line('Pushing GL Period push down to PA Period');
882: fii_util.start_timer;
883:
884: OPEN cal_period_cursor;
885:
886: LOOP

Line 927: fii_util.stop_timer;

923:
924: END LOOP;
925:
926: commit;
927: fii_util.stop_timer;
928: fii_util.print_timer('Process Time');
929: edw_log.put_line(' ');
930:
931: CLOSE cal_period_cursor;

Line 928: fii_util.print_timer('Process Time');

924: END LOOP;
925:
926: commit;
927: fii_util.stop_timer;
928: fii_util.print_timer('Process Time');
929: edw_log.put_line(' ');
930:
931: CLOSE cal_period_cursor;
932:

Line 939: fii_util.start_timer;

935: -- Populating GL Period Level
936: -- --------------------------------------------------
937:
938: edw_log.put_line('Pushing GL Period');
939: fii_util.start_timer;
940:
941: OPEN cal_period_cursor;
942:
943: LOOP

Line 984: fii_util.stop_timer;

980:
981: END LOOP;
982:
983: commit;
984: fii_util.stop_timer;
985: fii_util.print_timer('Process Time');
986: edw_log.put_line(' ');
987:
988: CLOSE cal_period_cursor;

Line 985: fii_util.print_timer('Process Time');

981: END LOOP;
982:
983: commit;
984: fii_util.stop_timer;
985: fii_util.print_timer('Process Time');
986: edw_log.put_line(' ');
987:
988: CLOSE cal_period_cursor;
989:

Line 995: fii_util.start_timer;

991: -- Populating GL Quarter Level
992: -- --------------------------------------------------
993:
994: edw_log.put_line('Pushing GL Quarter');
995: fii_util.start_timer;
996: l_quarter_name:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
997:
998: OPEN gl_quarters;
999:

Line 1041: fii_util.stop_timer;

1037:
1038: END LOOP;
1039:
1040: commit;
1041: fii_util.stop_timer;
1042: fii_util.print_timer('Process Time');
1043: edw_log.put_line(' ');
1044:
1045: CLOSE gl_quarters;

Line 1042: fii_util.print_timer('Process Time');

1038: END LOOP;
1039:
1040: commit;
1041: fii_util.stop_timer;
1042: fii_util.print_timer('Process Time');
1043: edw_log.put_line(' ');
1044:
1045: CLOSE gl_quarters;
1046:

Line 1053: fii_util.start_timer;

1049: -- Populating GL Year Level
1050: -- --------------------------------------------------
1051:
1052: edw_log.put_line('Pushing GL Year');
1053: fii_util.start_timer;
1054:
1055: OPEN gl_years;
1056:
1057: LOOP

Line 1095: fii_util.stop_timer;

1091: l_row_year := l_row_year + 1;
1092: END LOOP;
1093:
1094: commit;
1095: fii_util.stop_timer;
1096: fii_util.print_timer('Process Time');
1097: edw_log.put_line(' ');
1098:
1099: CLOSE gl_years;

Line 1096: fii_util.print_timer('Process Time');

1092: END LOOP;
1093:
1094: commit;
1095: fii_util.stop_timer;
1096: fii_util.print_timer('Process Time');
1097: edw_log.put_line(' ');
1098:
1099: CLOSE gl_years;
1100:

Line 1107: fii_util.start_timer;

1103: -- Populating GL Calendar Name Level
1104: -- --------------------------------------------------
1105:
1106: edw_log.put_line('Pushing GL Calendar Name');
1107: fii_util.start_timer;
1108:
1109: insert into EDW_TIME_CAL_NAME_LSTG(
1110: CAL_NAME_PK ,
1111: ALL_FK,

Line 1137: fii_util.stop_timer;

1133: where sob.period_set_name = sets.period_set_name;
1134:
1135: l_row_name:=l_row_name+sql%rowcount;
1136: commit;
1137: fii_util.stop_timer;
1138: fii_util.print_timer('Process Time');
1139: edw_log.put_line(' ');
1140:
1141: -- -----------------------------------------------------------------------------

Line 1138: fii_util.print_timer('Process Time');

1134:
1135: l_row_name:=l_row_name+sql%rowcount;
1136: commit;
1137: fii_util.stop_timer;
1138: fii_util.print_timer('Process Time');
1139: edw_log.put_line(' ');
1140:
1141: -- -----------------------------------------------------------------------------
1142: -- Write result to log file

Line 1171: fii_util.start_timer;

1167: edw_log.put_line('===========================');
1168:
1169: /* Population of Enterprise Calendar Period */
1170: edw_log.put_line('Pushing Enterprise Calendar Period');
1171: fii_util.start_timer;
1172:
1173: INSERT INTO EDW_TIME_EP_CAL_PERIOD_LSTG
1174: (CAL_PERIOD_PK,
1175: CAL_QTR_FK,

Line 1200: fii_util.stop_timer;

1196: and period_type = l_period_type
1197: and adjustment_period_flag='N';
1198:
1199: l_row_ep_cal_period:=l_row_ep_cal_period+sql%rowcount;
1200: fii_util.stop_timer;
1201: fii_util.print_timer('Process Time');
1202: edw_log.put_line(' ');
1203:
1204: /* Population of Enterprise Calendar Quarter */

Line 1201: fii_util.print_timer('Process Time');

1197: and adjustment_period_flag='N';
1198:
1199: l_row_ep_cal_period:=l_row_ep_cal_period+sql%rowcount;
1200: fii_util.stop_timer;
1201: fii_util.print_timer('Process Time');
1202: edw_log.put_line(' ');
1203:
1204: /* Population of Enterprise Calendar Quarter */
1205:

Line 1207: fii_util.start_timer;

1203:
1204: /* Population of Enterprise Calendar Quarter */
1205:
1206: edw_log.put_line('Pushing Enterprise Calendar Quarter');
1207: fii_util.start_timer;
1208: l_quarter_name:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
1209:
1210: INSERT INTO EDW_TIME_EP_CAL_QTR_LSTG
1211: (CAL_QTR_PK,

Line 1236: fii_util.stop_timer;

1232: and adjustment_period_flag='N'
1233: group by period_year, quarter_num;
1234:
1235: l_row_ep_cal_qtr:=l_row_ep_cal_qtr+sql%rowcount;
1236: fii_util.stop_timer;
1237: fii_util.print_timer('Process Time');
1238: edw_log.put_line(' ');
1239:
1240: /* Population of Enterprise Calendar Year */

Line 1237: fii_util.print_timer('Process Time');

1233: group by period_year, quarter_num;
1234:
1235: l_row_ep_cal_qtr:=l_row_ep_cal_qtr+sql%rowcount;
1236: fii_util.stop_timer;
1237: fii_util.print_timer('Process Time');
1238: edw_log.put_line(' ');
1239:
1240: /* Population of Enterprise Calendar Year */
1241:

Line 1243: fii_util.start_timer;

1239:
1240: /* Population of Enterprise Calendar Year */
1241:
1242: edw_log.put_line('Pushing Enterprise Calendar Year');
1243: fii_util.start_timer;
1244:
1245: INSERT INTO EDW_TIME_EP_CAL_YEAR_LSTG
1246: (CAL_YEAR_PK,
1247: CAL_NAME_FK,

Line 1271: fii_util.stop_timer;

1267: and adjustment_period_flag='N'
1268: group by period_year;
1269:
1270: l_row_ep_cal_year:=l_row_ep_cal_year+sql%rowcount;
1271: fii_util.stop_timer;
1272: fii_util.print_timer('Process Time');
1273: edw_log.put_line(' ');
1274:
1275: /* Population of Enterprise Calendar Name */

Line 1272: fii_util.print_timer('Process Time');

1268: group by period_year;
1269:
1270: l_row_ep_cal_year:=l_row_ep_cal_year+sql%rowcount;
1271: fii_util.stop_timer;
1272: fii_util.print_timer('Process Time');
1273: edw_log.put_line(' ');
1274:
1275: /* Population of Enterprise Calendar Name */
1276:

Line 1278: fii_util.start_timer;

1274:
1275: /* Population of Enterprise Calendar Name */
1276:
1277: edw_log.put_line('Pushing Enterprise Calendar Name');
1278: fii_util.start_timer;
1279:
1280: INSERT INTO EDW_TIME_EP_CAL_NAME_LSTG
1281: (CAL_NAME_PK,
1282: ALL_FK,

Line 1305: fii_util.stop_timer;

1301: FROM gl_period_sets sets
1302: WHERE sets.period_set_name = l_period_set_name;
1303:
1304: l_row_ep_cal_name:=l_row_ep_cal_name+sql%rowcount;
1305: fii_util.stop_timer;
1306: fii_util.print_timer('Process Time');
1307: edw_log.put_line(' ');
1308:
1309: -- -----------------------------------------------------------------------------

Line 1306: fii_util.print_timer('Process Time');

1302: WHERE sets.period_set_name = l_period_set_name;
1303:
1304: l_row_ep_cal_name:=l_row_ep_cal_name+sql%rowcount;
1305: fii_util.stop_timer;
1306: fii_util.print_timer('Process Time');
1307: edw_log.put_line(' ');
1308:
1309: -- -----------------------------------------------------------------------------
1310: -- Write result to log file