APPS.PJI_TIME_C dependencies on PJI_TIME_CAL_EXTR_INFO

Line 171: FROM pji_time_cal_extr_info

167: , NVL(latest_end_date,TRUNC(SYSDATE))
168: INTO
169: g_earliest_start_date
170: , g_latest_end_date
171: FROM pji_time_cal_extr_info
172: WHERE calendar_id = -1;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: g_cal_info_exists:='N';

Line 339: INSERT INTO pji_time_cal_extr_info

335: BEGIN
336: IF g_debug_flag = 'Y' THEN
337: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
338: END IF;
339: INSERT INTO pji_time_cal_extr_info
340: (calendar_id, earliest_start_date,
341: latest_end_date, creation_date,
342: last_update_date, last_updated_by,
343: created_by, last_update_login)

Line 351: UPDATE pji_time_cal_extr_info

347: WHEN DUP_VAL_ON_INDEX THEN
348: IF g_debug_flag = 'Y' THEN
349: pji_utils.write2log('Duplicate records. Now trying to update the record...');
350: END IF;
351: UPDATE pji_time_cal_extr_info
352: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
353: , latest_end_date = GREATEST(l_max_date, latest_end_date)
354: WHERE calendar_id = -1;
355: g_cal_info_exists:='Y';

Line 358: UPDATE pji_time_cal_extr_info

354: WHERE calendar_id = -1;
355: g_cal_info_exists:='Y';
356: END;
357: ELSE
358: UPDATE pji_time_cal_extr_info
359: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
360: , latest_end_date = GREATEST(l_max_date, latest_end_date)
361: WHERE calendar_id = -1;
362: END IF;

Line 652: INSERT INTO pji_time_cal_extr_info

648: BEGIN
649: IF g_debug_flag = 'Y' THEN
650: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
651: END IF;
652: INSERT INTO pji_time_cal_extr_info
653: (calendar_id, earliest_start_date,
654: latest_end_date, creation_date,
655: last_update_date, last_updated_by,
656: created_by, last_update_login)

Line 664: UPDATE pji_time_cal_extr_info

660: WHEN DUP_VAL_ON_INDEX THEN
661: IF g_debug_flag = 'Y' THEN
662: pji_utils.write2log('Duplicate records. Now trying to update the record...');
663: END IF;
664: UPDATE pji_time_cal_extr_info
665: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
666: , latest_end_date = GREATEST(l_max_date, latest_end_date)
667: WHERE calendar_id = p_calendar_id;
668: END;

Line 670: UPDATE pji_time_cal_extr_info

666: , latest_end_date = GREATEST(l_max_date, latest_end_date)
667: WHERE calendar_id = p_calendar_id;
668: END;
669: ELSE
670: UPDATE pji_time_cal_extr_info
671: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
672: , latest_end_date = GREATEST(l_max_date, latest_end_date)
673: WHERE calendar_id = p_calendar_id;
674: END IF;

Line 1619: , PJI_TIME_CAL_EXTR_INFO info

1615: , l_earliest_start_dates_tbl
1616: , l_latest_end_dates_tbl
1617: , l_cal_info_exists_tbl
1618: FROM pa_time_cal_name cal /* Modified for bug 12979524 */
1619: , PJI_TIME_CAL_EXTR_INFO info
1620: WHERE 1=1
1621: AND cal.calendar_id = info.calendar_id (+)
1622: AND cal.calendar_id = NVL(l_calendar_id,cal.calendar_id)
1623: AND cal.period_set_name = NVL(p_period_set_name,cal.period_set_name)