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_MASS_ASGMT_TRX dependencies on FND_API

Line 30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

26: (p_mode IN VARCHAR2
27: ,p_action IN VARCHAR2
28: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

27: ,p_action IN VARCHAR2
28: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

28: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

29: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

30: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

31: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

Line 36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

32: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'

Line 37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

33: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

34: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

35: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
36: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

37: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

38: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

39: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'

Line 44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

40: ,p_append_description_flag IN VARCHAR2 := 'N'
41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

Line 45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

41: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

42: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
43: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

Line 48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

44: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

Line 49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

45: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

Line 50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

46: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

Line 51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM

47: ,p_append_information_flag IN VARCHAR2 := 'N'
48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

Line 52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

48: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

49: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

50: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

51: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

52: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

53: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

54: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

55: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

56: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

57: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

58: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

Line 63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

59: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

60: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

61: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

62: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

63: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

Line 68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

64: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

Line 69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

65: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

Line 70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

66: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

Line 71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

67: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

68: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

69: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

70: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

71: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

72: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

73: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

74: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

75: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

Line 80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

76: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

77: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

78: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

79: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

80: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR

Line 85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

81: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development

Line 86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

82: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development

Line 87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

83: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR

84: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development

85: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development

86: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

87: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

88: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE := FND_API.G_MISS_CHAR
89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

Line 93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

89: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

Line 94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

90: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

91: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

92: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

93: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

94: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

95: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
97: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
98: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
99: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
100: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
101: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
102: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
103: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

106: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

107: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

Line 112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

108: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

109: ,p_non_working_day_flag IN VARCHAR2 := 'N'
110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

110: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

Line 115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

111: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

Line 116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

112: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

Line 117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

113: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

Line 118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

114: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
115: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

Line 123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl

Line 124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

Line 130: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
129: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
130: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
131: ,x_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
132: );
133:
134: PROCEDURE mass_asgmt_trx_wf