34: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36: p_total_hours IN NUMBER DEFAULT NULL) --Bug 5126919
37: IS
38: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
35: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36: p_total_hours IN NUMBER DEFAULT NULL) --Bug 5126919
37: IS
38: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
36: p_total_hours IN NUMBER DEFAULT NULL) --Bug 5126919
37: IS
38: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
37: IS
38: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
38: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
39: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
40: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
41: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
42: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
43: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
44: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
52: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
45: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
52: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53:
46: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
52: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53:
54: --Bug 5126919
47: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
52: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53:
54: --Bug 5126919
55: l_rounded_total NUMBER;
48: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
49: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
50: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
51: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
52: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
53:
54: --Bug 5126919
55: l_rounded_total NUMBER;
56: l_last_rec_index NUMBER;
710: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
711: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
713: IS
714: l_schrowid PA_PLSQL_DATATYPES.RowidTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
711: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
712: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
713: IS
714: l_schrowid PA_PLSQL_DATATYPES.RowidTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
712: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
713: IS
714: l_schrowid PA_PLSQL_DATATYPES.RowidTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
713: IS
714: l_schrowid PA_PLSQL_DATATYPES.RowidTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
714: l_schrowid PA_PLSQL_DATATYPES.RowidTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
715: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
716: l_calendar_id PA_PLSQL_DATATYPES.IdTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
717: l_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
718: l_project_id PA_PLSQL_DATATYPES.IdTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
719: l_schedule_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
720: l_assignment_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
721: l_start_date PA_PLSQL_DATATYPES.DateTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
722: l_end_date PA_PLSQL_DATATYPES.DateTabTyp;
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
730:
723: l_monday_hours PA_PLSQL_DATATYPES.NumTabTyp;
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
730:
731: BEGIN
724: l_tuesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
730:
731: BEGIN
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
725: l_wednesday_hours PA_PLSQL_DATATYPES.NumTabTyp;
726: l_thursday_hours PA_PLSQL_DATATYPES.NumTabTyp;
727: l_friday_hours PA_PLSQL_DATATYPES.NumTabTyp;
728: l_saturday_hours PA_PLSQL_DATATYPES.NumTabTyp;
729: l_sunday_hours PA_PLSQL_DATATYPES.NumTabTyp;
730:
731: BEGIN
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
957: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
958: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
959: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
960: IS
961: l_schedule_id PA_PLSQL_DATATYPES.IdTabTyp;
962:
963: BEGIN
964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965: