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_QTR

Line 724: FROM pji_time_cal_qtr

720: l_start_qtr_id
721: , l_end_qtr_id
722: , l_earliest_qtr_end_date
723: , l_latest_qtr_start_date
724: FROM pji_time_cal_qtr
725: WHERE 1=1
726: AND calendar_id = p_calendar_id
727: AND (p_earliest_start_date BETWEEN start_date AND end_date)
728: OR (p_latest_end_date BETWEEN start_date AND end_date);

Line 737: DELETE FROM pji_time_cal_qtr

733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;
735: END IF;
736:
737: DELETE FROM pji_time_cal_qtr
738: WHERE cal_qtr_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year||quarter_num FROM pji_time_extr_tmp);
739:
740: l_no_rows_deleted := SQL%rowcount;
741:

Line 743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');

739:
740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr

Line 744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');

740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr
748: (cal_qtr_id

Line 747: INSERT INTO pji_time_cal_qtr

743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr
748: (cal_qtr_id
749: , cal_year_id
750: , calendar_id
751: , SEQUENCE

Line 784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');

780:
781: l_no_rows_inserted := SQL%rowcount;
782:
783: IF g_debug_flag = 'Y' THEN
784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');
785: END IF;
786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN

Line 790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');

786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN
789: IF g_debug_flag = 'Y' THEN
790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');
791: END IF;
792: END LOAD_CAL_QUARTER;
793:
794: ---------------------------------------------------

Line 1249: , pji_time_cal_qtr qtr

1245: , l_qtr_end_date
1246: , l_period_end_date
1247: , l_year_end_date
1248: FROM pji_time_cal_period period
1249: , pji_time_cal_qtr qtr
1250: , pji_time_cal_year yr
1251: WHERE 1=1
1252: AND period.calendar_id = p_calendar_id
1253: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1322: FROM PJI_TIME_CAL_QTR qtr

1318: , SYSDATE
1319: , g_user_id
1320: , g_user_id
1321: , g_login_id
1322: FROM PJI_TIME_CAL_QTR qtr
1323: , PJI_TIME_CAL_PERIOD period
1324: WHERE 1=1
1325: AND qtr.end_date < l_qtr_start_date
1326: AND qtr.start_date >= l_year_start_date

Line 1394: , pji_time_cal_qtr qtr

1390: , qtr.end_date qtr_end_date
1391: , YEAR.end_date year_end_date
1392: FROM pji_time_extr_tmp extr
1393: , pji_time_cal_period period
1394: , pji_time_cal_qtr qtr
1395: , pji_time_cal_year YEAR
1396: WHERE 1=1
1397: AND period.calendar_id = p_calendar_id
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

Line 1476: FROM PJI_TIME_CAL_QTR

1472: , SYSDATE
1473: , g_user_id
1474: , g_user_id
1475: , g_login_id
1476: FROM PJI_TIME_CAL_QTR
1477: WHERE start_date >= extr_rec.year_start_date
1478: AND start_date <= extr_rec.qtr_start_date
1479: AND end_date < extr_rec.report_date
1480: AND calendar_id = p_calendar_id

Line 1494: FROM PJI_TIME_CAL_QTR

1490: , SYSDATE
1491: , g_user_id
1492: , g_user_id
1493: , g_login_id
1494: FROM PJI_TIME_CAL_QTR
1495: WHERE start_date >= extr_rec.year_start_date
1496: AND start_date <= extr_rec.qtr_start_date
1497: AND end_date >= extr_rec.report_date
1498: AND calendar_id = p_calendar_id;