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_CAL_RPT_STRUCT

Line 1215: -- entries in PJI_TIME_CAL_RPT_STRUCT table.

1211:
1212: ---------------------------------------------------
1213: -- PRIVATE PROCEDURE load_time_cal_rpt_struct
1214: -- This procedure incrementally maintains
1215: -- entries in PJI_TIME_CAL_RPT_STRUCT table.
1216: ---------------------------------------------------
1217: PROCEDURE LOAD_TIME_CAL_RPT_STRUCT ( p_calendar_id NUMBER
1218: , p_earliest_start_date DATE
1219: , p_min_date DATE

Line 1261: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1257: IF g_debug_flag = 'Y' THEN
1258: pji_utils.write2log('Creating prior year records for time periods after the current year.');
1259: END IF;
1260:
1261: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1262: (calendar_id
1263: , calendar_type
1264: , report_date
1265: , time_id

Line 1298: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1294: IF g_debug_flag = 'Y' THEN
1295: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');
1296: END IF;
1297:
1298: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1299: (calendar_id
1300: , calendar_type
1301: , report_date
1302: , time_id

Line 1338: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1334: IF g_debug_flag = 'Y' THEN
1335: pji_utils.write2log('Creating prior period records for time periods records after current periods.');
1336: END IF;
1337:
1338: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1339: (calendar_id
1340: , calendar_type
1341: , report_date
1342: , time_id

Line 1402: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1398: AND TO_NUMBER(LPAD(p_calendar_id,3,'0')||period_year||quarter_num||DECODE(LENGTH(period_num),1,'0'||period_num, period_num)) = period.cal_period_id
1399: AND period.cal_qtr_id = qtr.cal_qtr_id
1400: AND qtr.cal_year_id = YEAR.cal_year_id)
1401: LOOP
1402: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1403: (calendar_id
1404: , calendar_type
1405: , report_date
1406: , time_id

Line 1452: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1448: AND calendar_id = p_calendar_id;
1449:
1450: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1451:
1452: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1453: (calendar_id
1454: , calendar_type
1455: , report_date
1456: , time_id

Line 1502: INSERT INTO PJI_TIME_CAL_RPT_STRUCT

1498: AND calendar_id = p_calendar_id;
1499:
1500: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1501:
1502: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1503: (calendar_id
1504: , calendar_type
1505: , report_date
1506: , time_id

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

1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1547:
1548: IF g_debug_flag = 'Y' THEN
1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1550: END IF;
1551:
1552: END LOOP;
1553: END LOAD_TIME_CAL_RPT_STRUCT;