16: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
18: IS
19:
20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
17: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
18: IS
19:
20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
18: IS
19:
20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
19:
20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
31: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
33: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
41:
34: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
41:
42:
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
41:
42:
43: BEGIN
36: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
37: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
38: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
41:
42:
43: BEGIN
44: