3024: AND ((p_exception_id IS NULL) OR
3025: (schedule_exception_id = p_exception_id))
3026: ORDER BY schedule_exception_id;
3027:
3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3025: (schedule_exception_id = p_exception_id))
3026: ORDER BY schedule_exception_id;
3027:
3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3033: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3026: ORDER BY schedule_exception_id;
3027:
3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3033: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3034: l_I NUMBER;
3027:
3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3033: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3034: l_I NUMBER;
3035: l_p_start_id NUMBER;
3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3033: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3034: l_I NUMBER;
3035: l_p_start_id NUMBER;
3036: l_p_end_id NUMBER;
3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3033: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3034: l_I NUMBER;
3035: l_p_start_id NUMBER;
3036: l_p_end_id NUMBER;
3037: l_apply_schedule_changes BOOLEAN;
3416: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3417: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3418: IS
3419:
3420: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
3421: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
3424: l_msg_index_out NUMBER;
3417: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3418: IS
3419:
3420: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
3421: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
3424: l_msg_index_out NUMBER;
3425: l_data varchar2(2000) ;-- 4537865
3418: IS
3419:
3420: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
3421: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
3424: l_msg_index_out NUMBER;
3425: l_data varchar2(2000) ;-- 4537865
3426: BEGIN
3419:
3420: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
3421: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
3424: l_msg_index_out NUMBER;
3425: l_data varchar2(2000) ;-- 4537865
3426: BEGIN
3427: PA_SCHEDULE_UTILS.log_message(1,'Start of the create_calendar_schedule API ... ');
3938: l_thursday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3939: l_friday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3940: l_saturday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3941: l_sunday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3942: l_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3943: l_date DATE;
3944: l_counter NUMBER := 1;
3945: l_changes_done BOOLEAN := false;
3946: l_call_change_work_pattern BOOLEAN := false;