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: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 637: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE

633: -- P_Project_Id NUMBER YES project id of the associated calendar
634: PROCEDURE mass_update_schedule
635: ( p_project_id IN NUMBER
636: ,p_exception_type_code IN VARCHAR2
637: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE
638: ,p_change_start_date IN DATE := NULL
639: ,p_change_end_date IN DATE := NULL
640: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
641: ,p_change_asgmt_status_code IN VARCHAR2 := NULL

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

640: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
641: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
642: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
644: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

641: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
642: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
644: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

642: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
644: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
650: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

643: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
644: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
650: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

644: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
650: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_non_working_day_flag IN VARCHAR2 := 'N'
652: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

645: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
650: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_non_working_day_flag IN VARCHAR2 := 'N'
652: ,p_change_hours_type_code IN VARCHAR2 := NULL
653: ,p_hrs_per_day IN NUMBER := NULL

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

646: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
647: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
648: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
649: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
650: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_non_working_day_flag IN VARCHAR2 := 'N'
652: ,p_change_hours_type_code IN VARCHAR2 := NULL
653: ,p_hrs_per_day IN NUMBER := NULL
654: ,p_calendar_percent IN NUMBER := NULL

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

660: ,p_number_of_shift IN NUMBER := NULL
661: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
662: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
663: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
664: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
665: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
666: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
667: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
668: IS

Line 684: l_success_assignment_id_tbl system.pa_num_tbl_type := p_assignment_id_array;

680: l_return_status VARCHAR2(50);
681: l_return_code VARCHAR2(30);
682: l_rownum NUMBER;
683: l_privilege VARCHAR2(30);
684: l_success_assignment_id_tbl system.pa_num_tbl_type := p_assignment_id_array;
685: l_last_row_flag VARCHAR2(1);
686:
687: -- To get information for the gieven assignment
688: CURSOR get_asgmt_info_csr(l_assignment_id IN NUMBER) IS

Line 3443: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,

3439: p_asgn_end_date IN DATE := NULL ,
3440: p_start_date IN date := NULL ,
3441: -- p_end_date IN date := NULL ,
3442: p_assignment_status_code IN varchar2 := NULL ,
3443: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,
3444: p_prev_call_timeline_st_date IN DATE ,
3445: p_prev_call_timeline_end_date IN DATE ,
3446: x_call_timeline_st_date OUT NOCOPY Date , --File.Sql.39 bug 4440895
3447: x_call_timeline_end_date OUT NOCOPY Date , --File.Sql.39 bug 4440895

Line 4608: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

4604: -- Parameters :
4605: --
4606:
4607: PROCEDURE Populate_work_pattern_table (
4608: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
4609: p_assgn_range_start_date IN DATE := NULL ,
4610: p_assgn_range_end_date IN DATE := NULL ,
4611: p_display_start_date IN DATE ,
4612: p_status_code IN VARCHAR2 := NULL ,