APPS.PJI_TIME_C dependencies on PJI_TIME_CAL_PERIOD

Line 604: INSERT INTO pji_time_cal_period(cal_period_id

600: AND adjustment_period_flag='N'
601: AND (start_date < p_earliest_start_date
602: OR end_date > p_latest_end_date);
603:
604: INSERT INTO pji_time_cal_period(cal_period_id
605: , cal_qtr_id
606: , calendar_id
607: , SEQUENCE
608: , NAME

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

630:
631: l_no_rows_inserted := SQL%rowcount;
632:
633: IF g_debug_flag = 'Y' THEN
634: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_PERIOD table.');
635: END IF;
636:
637: IF l_no_rows_inserted > 0 THEN
638: SELECT MIN(start_date), MAX(end_date)

Line 640: FROM pji_time_cal_period

636:
637: IF l_no_rows_inserted > 0 THEN
638: SELECT MIN(start_date), MAX(end_date)
639: INTO l_min_date, l_max_date
640: FROM pji_time_cal_period
641: WHERE (start_date < p_earliest_start_date
642: OR end_date > p_latest_end_date)
643: AND calendar_id = p_calendar_id;
644:

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

687: END IF;
688: EXCEPTION
689: WHEN DUP_VAL_ON_INDEX THEN
690: IF g_debug_flag = 'Y' THEN
691: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_PERIOD table.');
692: END IF;
693: RETURN FALSE;
694: END LOAD_CAL_PERIOD;
695:

Line 1248: FROM pji_time_cal_period period

1244: , l_year_start_date
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

Line 1286: , PJI_TIME_CAL_PERIOD period

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
1290: AND period.start_date > p_earliest_start_date;

Line 1323: , PJI_TIME_CAL_PERIOD period

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
1327: AND qtr.calendar_id = p_calendar_id

Line 1362: FROM PJI_TIME_CAL_PERIOD newprd

1358: , SYSDATE
1359: , g_user_id
1360: , g_user_id
1361: , g_login_id
1362: FROM PJI_TIME_CAL_PERIOD newprd
1363: , PJI_TIME_CAL_PERIOD oldprd
1364: WHERE 1=1
1365: AND newprd.end_date < l_period_start_date
1366: AND newprd.start_date >= l_qtr_start_date

Line 1363: , PJI_TIME_CAL_PERIOD oldprd

1359: , g_user_id
1360: , g_user_id
1361: , g_login_id
1362: FROM PJI_TIME_CAL_PERIOD newprd
1363: , PJI_TIME_CAL_PERIOD oldprd
1364: WHERE 1=1
1365: AND newprd.end_date < l_period_start_date
1366: AND newprd.start_date >= l_qtr_start_date
1367: AND newprd.calendar_id = p_calendar_id

Line 1393: , pji_time_cal_period period

1389: , period.end_date period_end_date
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

Line 1426: FROM PJI_TIME_CAL_PERIOD

1422: , SYSDATE
1423: , g_user_id
1424: , g_user_id
1425: , g_login_id
1426: FROM PJI_TIME_CAL_PERIOD
1427: WHERE start_date >= extr_rec.qtr_start_date
1428: AND start_date <= extr_rec.period_start_date
1429: AND end_date < extr_rec.report_date
1430: AND calendar_id = p_calendar_id

Line 1444: FROM PJI_TIME_CAL_PERIOD

1440: , SYSDATE
1441: , g_user_id
1442: , g_user_id
1443: , g_login_id
1444: FROM PJI_TIME_CAL_PERIOD
1445: WHERE start_date >= extr_rec.qtr_start_date
1446: AND start_date <= extr_rec.period_start_date
1447: AND end_date >= extr_rec.report_date
1448: AND calendar_id = p_calendar_id;