DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULE_GLOB

Line 2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2551: AND ((p_exception_id IS NULL) OR
2552: (schedule_exception_id = p_exception_id))
2553: ORDER BY schedule_exception_id;
2554:
2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

Line 2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;

2552: (schedule_exception_id = p_exception_id))
2553: ORDER BY schedule_exception_id;
2554:
2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

Line 2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;

2553: ORDER BY schedule_exception_id;
2554:
2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2561: l_I NUMBER;

Line 2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2554:
2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2561: l_I NUMBER;
2562: l_p_start_id NUMBER;

Line 2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2555: l_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2561: l_I NUMBER;
2562: l_p_start_id NUMBER;
2563: l_p_end_id NUMBER;

Line 2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2556: l_sch_except_record_tab PA_SCHEDULE_GLOB.SchExceptTabTyp;
2557: l_sch_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
2558: l_chg_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2559: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2560: l_del_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2561: l_I NUMBER;
2562: l_p_start_id NUMBER;
2563: l_p_end_id NUMBER;
2564: l_apply_schedule_changes BOOLEAN;

Line 2940: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;

2936: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2937: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2938: IS
2939:
2940: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
2941: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2942: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
2944: l_msg_index_out NUMBER;

Line 2941: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2937: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2938: IS
2939:
2940: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
2941: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2942: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
2944: l_msg_index_out NUMBER;
2945: l_data varchar2(2000) ;-- 4537865

Line 2942: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2938: IS
2939:
2940: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
2941: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2942: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
2944: l_msg_index_out NUMBER;
2945: l_data varchar2(2000) ;-- 4537865
2946: BEGIN

Line 2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;

2939:
2940: l_x_cal_record_tab PA_SCHEDULE_GLOB.CalendarTabTyp;
2941: l_schedule_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2942: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
2944: l_msg_index_out NUMBER;
2945: l_data varchar2(2000) ;-- 4537865
2946: BEGIN
2947: PA_SCHEDULE_UTILS.log_message(1,'Start of the create_calendar_schedule API ... ');

Line 3462: l_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

3458: l_thursday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3459: l_friday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3460: l_saturday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3461: l_sunday_hours PA_PLSQL_DATATYPES.IdTabTyp;
3462: l_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3463: l_date DATE;
3464: l_counter NUMBER := 1;
3465: l_changes_done BOOLEAN := false;
3466: l_call_change_work_pattern BOOLEAN := false;