eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SCH_EXCEPT_PKG dependencies on PA_PLSQL_DATATYPES

Line 34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;

30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
33: IS
34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;

31: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
33: IS
34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

32: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
33: IS
34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

33: IS
34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

34: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

35: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;

Line 40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

36: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

37: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;

38: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;

Line 43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;

39: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;

40: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;

41: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;

42: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;

43: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;

Line 48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;

46: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;

47: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;

48: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

49: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

50: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;

51: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
59:

Line 56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;

52: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
59:
60: BEGIN

Line 57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;

53: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
59:
60: BEGIN
61: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;

54: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
55: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
56: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
57: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
58: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
59:
60: BEGIN
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:

Line 334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;

330: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
331: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
332: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
333: IS
334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;
335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;

331: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
332: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
333: IS
334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;
335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;

332: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
333: IS
334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;
335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

333: IS
334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;
335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;

334: l_exceptrowid PA_PLSQL_DATATYPES.RowidTabTyp;
335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

335: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;

336: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;

Line 341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

337: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

338: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;

339: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;

Line 344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;

340: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;

341: l_exception_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;

342: l_duration_shift_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;

343: l_duration_shift_unit_code PA_PLSQL_DATATYPES.Char30TabTyp;
344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;

Line 348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;

344: l_number_of_shift PA_PLSQL_DATATYPES.NumTabTyp;
345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;

Line 349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

345: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;

346: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;

347: l_resource_calendar_percent PA_PLSQL_DATATYPES.NumTabTyp;
348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;

348: l_non_working_day_flag PA_PLSQL_DATATYPES.Char1TabTyp;
349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;

349: l_change_hours_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

350: l_change_calendar_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;

351: -- l_change_calendar_name PA_PLSQL_DATATYPES.Char30TabTyp;
352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;

Line 356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;

352: l_change_calendar_id PA_PLSQL_DATATYPES.NumTabTyp;
353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
360:

Line 357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;

353: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
360:
361: BEGIN

Line 358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;

354: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
360:
361: BEGIN
362:

Line 359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;

355: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
356: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
357: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
358: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
359: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
360:
361: BEGIN
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 660: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;

656: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
657: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
658: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
659: IS
660: l_schedule_exception_id PA_PLSQL_DATATYPES.IdTabTyp;
661:
662: BEGIN
663:
664: x_return_status := FND_API.G_RET_STS_SUCCESS;