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.PJI_TIME_C dependencies on PJI_TIME_RPT_STRUCT

Line 890: -- entries in PJI_TIME_RPT_STRUCT table.

886:
887: ---------------------------------------------------
888: -- PRIVATE PROCEDURE load_time_rpt_struct
889: -- This procedure incrementally maintains
890: -- entries in PJI_TIME_RPT_STRUCT table.
891: ---------------------------------------------------
892: PROCEDURE LOAD_TIME_RPT_STRUCT IS
893: l_no_rows_inserted NUMBER;
894: l_year_start_date DATE;

Line 931: INSERT INTO PJI_TIME_RPT_STRUCT

927: IF g_debug_flag = 'Y' THEN
928: pji_utils.write2log('Creating prior year records for time periods after the current year.');
929: END IF;
930:
931: INSERT INTO PJI_TIME_RPT_STRUCT
932: (calendar_id
933: , calendar_type
934: , report_date
935: , time_id

Line 966: INSERT INTO PJI_TIME_RPT_STRUCT

962: IF g_debug_flag = 'Y' THEN
963: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');
964: END IF;
965:
966: INSERT INTO PJI_TIME_RPT_STRUCT
967: (calendar_id
968: , calendar_type
969: , report_date
970: , time_id

Line 1004: INSERT INTO PJI_TIME_RPT_STRUCT

1000: IF g_debug_flag = 'Y' THEN
1001: pji_utils.write2log('Creating prior period records for time periods records after current periods.');
1002: END IF;
1003:
1004: INSERT INTO PJI_TIME_RPT_STRUCT
1005: (calendar_id
1006: , calendar_type
1007: , report_date
1008: , time_id

Line 1065: INSERT INTO PJI_TIME_RPT_STRUCT

1061: AND TO_NUMBER(extr.period_year||extr.quarter_num||DECODE(LENGTH(extr.period_num),1,'0'||extr.period_num, extr.period_num)) = period.ent_period_id
1062: AND period.ent_qtr_id = qtr.ent_qtr_id
1063: AND qtr.ent_year_id = YEAR.ent_year_id)
1064: LOOP
1065: INSERT INTO PJI_TIME_RPT_STRUCT
1066: (calendar_id
1067: , calendar_type
1068: , report_date
1069: , time_id

Line 1113: INSERT INTO PJI_TIME_RPT_STRUCT

1109: AND end_date >= extr_rec.report_date;
1110:
1111: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1112:
1113: INSERT INTO PJI_TIME_RPT_STRUCT
1114: (calendar_id
1115: , calendar_type
1116: , report_date
1117: , time_id

Line 1161: INSERT INTO PJI_TIME_RPT_STRUCT

1157: AND end_date >= extr_rec.report_date;
1158:
1159: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1160:
1161: INSERT INTO PJI_TIME_RPT_STRUCT
1162: (calendar_id
1163: , calendar_type
1164: , report_date
1165: , time_id

Line 1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1202:
1203: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1204:
1205: IF g_debug_flag = 'Y' THEN
1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1207: END IF;
1208:
1209: END LOOP;
1210: END LOAD_TIME_RPT_STRUCT;