DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULE_GLOB

Line 3028: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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;

Line 3029: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;

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;

Line 3030: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;

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;

Line 3031: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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;

Line 3032: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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;

Line 3033: l_del_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;
3037: l_apply_schedule_changes BOOLEAN;

Line 3420: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;

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;

Line 3421: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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

Line 3422: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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

Line 3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;

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 ... ');

Line 3942: l_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

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;