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_YEAR

Line 699: -- entries in PJI_TIME_CAL_YEAR.

695:
696: ---------------------------------------------------
697: -- PRIVATE PROCEDURE load_cal_qtr
698: -- This procedure incrementally maintains quarter
699: -- entries in PJI_TIME_CAL_YEAR.
700: ---------------------------------------------------
701: PROCEDURE LOAD_CAL_QUARTER(p_calendar_id NUMBER
702: , p_earliest_start_date DATE
703: , p_latest_end_date DATE

Line 797: -- entries in PJI_TIME_CAL_YEAR.

793:
794: ---------------------------------------------------
795: -- PRIVATE PROCEDURE load_cal_year
796: -- This procedure incrementally maintains year
797: -- entries in PJI_TIME_CAL_YEAR.
798: ---------------------------------------------------
799: PROCEDURE LOAD_CAL_YEAR(p_calendar_id NUMBER
800: , p_earliest_start_date DATE
801: , p_latest_end_date DATE

Line 821: FROM pji_time_cal_year

817: l_start_yr_id
818: , l_end_yr_id
819: , l_earliest_yr_end_date
820: , l_latest_yr_start_date
821: FROM pji_time_cal_year
822: WHERE 1=1
823: AND calendar_id = p_calendar_id
824: AND (g_earliest_start_date BETWEEN start_date AND end_date)
825: OR (g_latest_end_date BETWEEN start_date AND end_date);

Line 835: DELETE FROM pji_time_cal_year

831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;
833: END IF;
834:
835: DELETE FROM pji_time_cal_year
836: WHERE cal_year_id in (SELECT DISTINCT LPAD(p_calendar_id,3,'0')||period_year from pji_time_extr_tmp);
837:
838: l_no_rows_deleted := SQL%rowcount;
839:

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

837:
838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR

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

838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR
846: (cal_year_id

Line 845: INSERT INTO PJI_TIME_CAL_YEAR

841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR
846: (cal_year_id
847: , calendar_id
848: , SEQUENCE
849: , NAME

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

873:
874: l_no_rows_inserted := SQL%rowcount;
875:
876: IF g_debug_flag = 'Y' THEN
877: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_YEAR table.');
878: END IF;
879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN

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

879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN
882: IF g_debug_flag = 'Y' THEN
883: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_YEAR table.');
884: END IF;
885: END LOAD_CAL_YEAR;
886:
887: ---------------------------------------------------

Line 1250: , pji_time_cal_year yr

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
1254: AND qtr.cal_year_id = yr.cal_year_id

Line 1285: FROM PJI_TIME_CAL_YEAR year

1281: , SYSDATE
1282: , g_user_id
1283: , g_user_id
1284: , g_login_id
1285: FROM PJI_TIME_CAL_YEAR year
1286: , PJI_TIME_CAL_PERIOD period
1287: WHERE year.end_date < l_year_start_date
1288: AND year.calendar_id = p_calendar_id
1289: AND period.calendar_id = p_calendar_id

Line 1395: , pji_time_cal_year YEAR

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
1399: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1526: FROM PJI_TIME_CAL_YEAR

1522: , SYSDATE
1523: , g_user_id
1524: , g_user_id
1525: , g_login_id
1526: FROM PJI_TIME_CAL_YEAR
1527: WHERE extr_rec.report_date BETWEEN start_date AND end_date
1528: AND calendar_id = p_calendar_id
1529: UNION ALL
1530: SELECT

Line 1542: FROM PJI_TIME_CAL_YEAR

1538: , SYSDATE
1539: , g_user_id
1540: , g_user_id
1541: , g_login_id
1542: FROM PJI_TIME_CAL_YEAR
1543: WHERE end_date < extr_rec.report_date
1544: AND calendar_id = p_calendar_id;
1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;