DBA Data[Home] [Help]

APPS.PA_SCH_EXCEPT_HIST_PKG dependencies on PA_PLSQL_DATATYPES

Line 20: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 21: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 22: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 23: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 24: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 25: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 26: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 27: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 28: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 29: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 30: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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;

Line 31: l_change_hours_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;
35: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 32: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 33: l_change_calendar_id 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;

Line 34: l_monday_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;

Line 35: l_tuesday_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;

Line 36: l_wednesday_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;

Line 37: l_thursday_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:

Line 38: l_friday_hours 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:
42:

Line 39: l_saturday_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:
43: BEGIN

Line 40: l_sunday_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
44: