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_SCHEDULE_PUB dependencies on PA_NUM_TBL_TYPE

Line 28: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL

24: ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE
25: ,p_exception_type_code IN VARCHAR2
26: ,p_record_version_number IN NUMBER := NULL
27: ,p_assignment_id IN NUMBER := NULL
28: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
29: ,p_change_start_date IN DATE := NULL
30: ,p_change_end_date IN DATE := NULL
31: ,p_requirement_status_code IN VARCHAR2 := NULL
32: ,p_assignment_status_code IN VARCHAR2 := NULL

Line 53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

49: ,p_number_of_shift IN NUMBER := NULL
50: ,p_last_row_flag IN VARCHAR2 := 'Y'
51: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
52: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

50: ,p_last_row_flag IN VARCHAR2 := 'Y'
51: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
52: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

51: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
52: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

52: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
60: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

53: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
60: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
61: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

54: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
60: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
61: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
62: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033

Line 59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

55: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
56: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
57: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
58: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
59: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
60: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
61: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
62: ,p_called_by_proj_party IN VARCHAR2 := 'N' -- Added for Bug 6631033
63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

406:
407: /* Bug 7693634 Start */
408:
409: PROCEDURE update_schedule_bulk
410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

409: PROCEDURE update_schedule_bulk
410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895
426: IS
427:
428: l_err_msg_code fnd_new_messages.message_name%TYPE;

Line 444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;

440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
443:
444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
445: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
446: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
447: --Bug#9817752 start
448: l_assignment_type pa_project_assignments.assignment_type%TYPE :=NULL ;

Line 636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

632:
633:
634:
635: PROCEDURE update_new_schedule_bulk
636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

635: PROCEDURE update_new_schedule_bulk
636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895

Line 651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
655: )

Line 653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
655: )
656:
657: IS

Line 676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;

672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
675:
676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
677: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
678: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
679:
680:

Line 1105: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE

1101: -- P_Project_Id NUMBER YES project id of the associated calendar
1102: PROCEDURE mass_update_schedule
1103: ( p_project_id IN NUMBER
1104: ,p_exception_type_code IN VARCHAR2
1105: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE
1106: ,p_change_start_date IN DATE := NULL
1107: ,p_change_end_date IN DATE := NULL
1108: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
1109: ,p_change_asgmt_status_code IN VARCHAR2 := NULL

Line 1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1108: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
1109: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
1110: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1111: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1109: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
1110: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1111: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1110: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1111: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1111: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1119: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1112: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1119: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1120: ,p_change_hours_type_code IN VARCHAR2 := NULL

Line 1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1113: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1119: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1120: ,p_change_hours_type_code IN VARCHAR2 := NULL
1121: ,p_hrs_per_day IN NUMBER := NULL

Line 1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

1114: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1116: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1117: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1118: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1119: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1120: ,p_change_hours_type_code IN VARCHAR2 := NULL
1121: ,p_hrs_per_day IN NUMBER := NULL
1122: ,p_calendar_percent IN NUMBER := NULL

Line 1132: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */

1128: ,p_number_of_shift IN NUMBER := NULL
1129: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1130: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1131: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1132: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
1133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1135: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1136: IS

Line 1152: l_success_assignment_id_tbl system.pa_num_tbl_type := p_assignment_id_array;

1148: l_return_status VARCHAR2(50);
1149: l_return_code VARCHAR2(30);
1150: l_rownum NUMBER;
1151: l_privilege VARCHAR2(30);
1152: l_success_assignment_id_tbl system.pa_num_tbl_type := p_assignment_id_array;
1153: l_last_row_flag VARCHAR2(1);
1154:
1155: -- To get information for the gieven assignment
1156: CURSOR get_asgmt_info_csr(l_assignment_id IN NUMBER) IS

Line 3923: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,

3919: p_asgn_end_date IN DATE := NULL ,
3920: p_start_date IN date := NULL ,
3921: -- p_end_date IN date := NULL ,
3922: p_assignment_status_code IN varchar2 := NULL ,
3923: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,
3924: p_prev_call_timeline_st_date IN DATE ,
3925: p_prev_call_timeline_end_date IN DATE ,
3926: x_call_timeline_st_date OUT NOCOPY Date , --File.Sql.39 bug 4440895
3927: x_call_timeline_end_date OUT NOCOPY Date , --File.Sql.39 bug 4440895

Line 5088: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

5084: -- Parameters :
5085: --
5086:
5087: PROCEDURE Populate_work_pattern_table (
5088: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
5089: p_assgn_range_start_date IN DATE := NULL ,
5090: p_assgn_range_end_date IN DATE := NULL ,
5091: p_display_start_date IN DATE ,
5092: p_status_code IN VARCHAR2 := NULL ,