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 PA_PROJECT_ASSIGNMENTS

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

5: (p_mode IN VARCHAR2
6: ,p_action IN VARCHAR2
7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

6: ,p_action IN VARCHAR2
7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

7: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

8: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

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

9: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

10: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

11: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'

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

14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'

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

19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

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

23: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

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

24: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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

25: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

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

26: ,p_append_information_flag IN VARCHAR2 := 'N'
27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

27: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
28: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
29: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
42: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

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

41: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
42: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

42: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

45: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

46: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

47: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

48: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

49: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

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

50: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

51: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

52: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

53: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

54: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

55: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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

56: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

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

58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

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

60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
68: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development

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

62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
68: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
69: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
70: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
68: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
69: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
70: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
68: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM --FP.L Development
69: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development
70: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
71: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
72: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 147: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);
145: /* Commented for bug 9114634
146: ----Added following folloeing for bug 6199871 ------------------------
147: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
148: l_change_id NUMBER;
149: l_record_version_number NUMBER;
150: l_return_status VARCHAR2(1);
151: l_msg_count NUMBER;

Line 179: -- 'pa_project_assignments' for the Given Assignment id.

175: -- Bug Ref # 6199871
176: -- Changing Approval Status to Submitted for each Assignment
177: -- Record version Id is passes as 1,as it will be populated inside
178: -- the API to the correct one which is queried from
179: -- 'pa_project_assignments' for the Given Assignment id.
180: ---------------------------------------------------------------------------
181: IF p_assignment_id_tbl.COUNT > 0 THEN
182: FOR i IN p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST LOOP
183: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(

Line 736: --in pa_project_assignments. This is a bulk update for all assignments being updated.

732: --Setting the original value
733: wf_engine.threshold := l_save_threshold;
734:
735: --if this is a mass update then set the mass_wf_in_progress_flag to 'Y'
736: --in pa_project_assignments. This is a bulk update for all assignments being updated.
737: IF p_mode <> G_MASS_ASGMT THEN
738:
739: FORALL i in p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST
740: UPDATE pa_project_assignments

Line 740: UPDATE pa_project_assignments

736: --in pa_project_assignments. This is a bulk update for all assignments being updated.
737: IF p_mode <> G_MASS_ASGMT THEN
738:
739: FORALL i in p_assignment_id_tbl.FIRST .. p_assignment_id_tbl.LAST
740: UPDATE pa_project_assignments
741: SET mass_wf_in_progress_flag = 'Y'
742: WHERE assignment_id = p_assignment_id_tbl(i);
743:
744: END IF;

Line 777: l_project_id pa_project_assignments.project_id%TYPE;

773: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;
779: l_end_date pa_project_assignments.end_date%TYPE;
780: l_project_name pa_projects_all.name%TYPE;
781: l_project_number pa_projects_all.segment1%TYPE;

Line 778: l_start_date pa_project_assignments.start_date%TYPE;

774: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;
779: l_end_date pa_project_assignments.end_date%TYPE;
780: l_project_name pa_projects_all.name%TYPE;
781: l_project_number pa_projects_all.segment1%TYPE;
782: l_success_assignments NUMBER := 0;

Line 779: l_end_date pa_project_assignments.end_date%TYPE;

775: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
776: l_asgmt_overcom_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
777: l_project_id pa_project_assignments.project_id%TYPE;
778: l_start_date pa_project_assignments.start_date%TYPE;
779: l_end_date pa_project_assignments.end_date%TYPE;
780: l_project_name pa_projects_all.name%TYPE;
781: l_project_number pa_projects_all.segment1%TYPE;
782: l_success_assignments NUMBER := 0;
783: l_failure_assignments NUMBER := 0;

Line 819: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

815: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
816: l_calling_page VARCHAR2(30);
817:
818: ----Added following code for bug 6199871 and 9114634-----------------------
819: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
820: l_change_id NUMBER;
821: l_record_version_number NUMBER;
822: l_note_to_all_approvers VARCHAR(2000);
823: l_success_assignment_id_tbl2 SYSTEM.pa_num_tbl_type ;

Line 1030: pa_project_assignments ppa

1026: if l_success_assignments > 0 THEN
1027: -- bug#9464279
1028: SELECT pmt.assignment_id BULK COLLECT INTO l_success_assignment_id_tbl2
1029: FROM pa_mass_txn_asgmt_success_v pmt,
1030: pa_project_assignments ppa
1031: WHERE pmt.item_type = p_item_type
1032: AND pmt.item_key= p_item_key
1033: and pmt.assignment_id= ppa.assignment_id
1034: and ppa.assignment_type in ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT');

Line 1041: -- 'pa_project_assignments' for the Given Assignment id.

1037: -- Bug Ref # 6199871
1038: -- Changing Approval Status to Submitted for each Assignment
1039: -- Record version Id is passes as 1,as it will be populated inside
1040: -- the API to the correct one which is queried from
1041: -- 'pa_project_assignments' for the Given Assignment id.
1042: ---------------------------------------------------------------------------
1043: IF l_success_assignment_id_tbl2.COUNT > 0 THEN
1044: FOR i IN l_success_assignment_id_tbl2.FIRST .. l_success_assignment_id_tbl2.LAST LOOP
1045: PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status(

Line 1084: FROM pa_project_assignments

1080: IF l_project_id IS NULL or l_project_id = FND_API.G_MISS_NUM THEN
1081:
1082: SELECT project_id
1083: INTO l_project_id
1084: FROM pa_project_assignments
1085: WHERE assignment_id = l_assignment_id_tbl(1);
1086:
1087: END IF;
1088:

Line 1253: --FROM pa_project_assignments_v

1249:
1250: -- Commented for Perf fix 4918687 SQL ID 14910597
1251: --cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1252: --SELECT fcst_tp_amount_type_name
1253: --FROM pa_project_assignments_v
1254: --WHERE assignment_id = p_asg_id;
1255:
1256: -- Added for Perf fix 4918687 SQL ID 14910597
1257: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS

Line 1259: FROM pa_project_assignments asgn, pa_lookups lkup

1255:
1256: -- Added for Perf fix 4918687 SQL ID 14910597
1257: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1258: SELECT lkup.meaning fcst_tp_amount_type_name
1259: FROM pa_project_assignments asgn, pa_lookups lkup
1260: WHERE lkup.lookup_type(+) = 'TP_AMOUNT_TYPE'
1261: AND asgn.fcst_tp_amount_type = lkup.lookup_code(+)
1262: AND asgn.assignment_id = p_asg_id;
1263:

Line 1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;

1269: l_action VARCHAR2(30);
1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;

Line 1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;

1270: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;

Line 1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;

1271: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1279: l_project_id NUMBER;

Line 1276: l_status_code pa_project_assignments.status_code%TYPE;

1272: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1279: l_project_id NUMBER;
1280: l_project_role_id NUMBER;

Line 1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;

1273: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1279: l_project_id NUMBER;
1280: l_project_role_id NUMBER;
1281: l_role_list_id NUMBER;

Line 1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;

1274: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1275: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1276: l_status_code pa_project_assignments.status_code%TYPE;
1277: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1278: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1279: l_project_id NUMBER;
1280: l_project_role_id NUMBER;
1281: l_role_list_id NUMBER;
1282: l_project_subteam_id NUMBER;

Line 1283: l_description pa_project_assignments.description%TYPE;

1279: l_project_id NUMBER;
1280: l_project_role_id NUMBER;
1281: l_role_list_id NUMBER;
1282: l_project_subteam_id NUMBER;
1283: l_description pa_project_assignments.description%TYPE;
1284: l_append_description_flag VARCHAR2(1);
1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;

Line 1285: l_start_date pa_project_assignments.start_date%TYPE;

1281: l_role_list_id NUMBER;
1282: l_project_subteam_id NUMBER;
1283: l_description pa_project_assignments.description%TYPE;
1284: l_append_description_flag VARCHAR2(1);
1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

Line 1286: l_end_date pa_project_assignments.end_date%TYPE;

1282: l_project_subteam_id NUMBER;
1283: l_description pa_project_assignments.description%TYPE;
1284: l_append_description_flag VARCHAR2(1);
1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1290: l_additional_information pa_project_assignments.additional_information%TYPE;

Line 1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;

1283: l_description pa_project_assignments.description%TYPE;
1284: l_append_description_flag VARCHAR2(1);
1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1290: l_additional_information pa_project_assignments.additional_information%TYPE;
1291: l_append_information_flag VARCHAR2(1);

Line 1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

1284: l_append_description_flag VARCHAR2(1);
1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1290: l_additional_information pa_project_assignments.additional_information%TYPE;
1291: l_append_information_flag VARCHAR2(1);
1292: l_location_id NUMBER;

Line 1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

1285: l_start_date pa_project_assignments.start_date%TYPE;
1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1290: l_additional_information pa_project_assignments.additional_information%TYPE;
1291: l_append_information_flag VARCHAR2(1);
1292: l_location_id NUMBER;
1293: l_work_type_id NUMBER;

Line 1290: l_additional_information pa_project_assignments.additional_information%TYPE;

1286: l_end_date pa_project_assignments.end_date%TYPE;
1287: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1288: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1289: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1290: l_additional_information pa_project_assignments.additional_information%TYPE;
1291: l_append_information_flag VARCHAR2(1);
1292: l_location_id NUMBER;
1293: l_work_type_id NUMBER;
1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;

Line 1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;

1290: l_additional_information pa_project_assignments.additional_information%TYPE;
1291: l_append_information_flag VARCHAR2(1);
1292: l_location_id NUMBER;
1293: l_work_type_id NUMBER;
1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1295: l_calendar_id NUMBER;
1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;

Line 1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;

1292: l_location_id NUMBER;
1293: l_work_type_id NUMBER;
1294: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1295: l_calendar_id NUMBER;
1296: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;
1299: l_project_subteam_name pa_project_subteams.name%TYPE;
1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;

1305: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1306: l_location_country_code pa_locations.country_code%TYPE;
1307: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;

Line 1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;

1306: l_location_country_code pa_locations.country_code%TYPE;
1307: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;

Line 1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;

1307: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;

Line 1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;

1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;

Line 1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;

1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;

Line 1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;

1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;

Line 1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;

1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

Line 1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;

1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;

Line 1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;

1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1314: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;

Line 1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

1315: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1316: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;

Line 1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;

1317: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1318: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;

Line 1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;

1319: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1326: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1327: l_fcst_job_id NUMBER;

Line 1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;

1320: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1326: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1327: l_fcst_job_id NUMBER;
1328: l_fcst_job_group_id NUMBER;

Line 1326: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;

1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1326: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1327: l_fcst_job_id NUMBER;
1328: l_fcst_job_group_id NUMBER;
1329: l_expenditure_org_id NUMBER;
1330: l_expenditure_organization_id NUMBER;

Line 1331: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;

1327: l_fcst_job_id NUMBER;
1328: l_fcst_job_group_id NUMBER;
1329: l_expenditure_org_id NUMBER;
1330: l_expenditure_organization_id NUMBER;
1331: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
1332: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1333: l_fcst_job_name per_jobs.name%TYPE;
1334: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
1335: l_expenditure_org_name per_organization_units.name%TYPE;

Line 1332: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1328: l_fcst_job_group_id NUMBER;
1329: l_expenditure_org_id NUMBER;
1330: l_expenditure_organization_id NUMBER;
1331: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
1332: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1333: l_fcst_job_name per_jobs.name%TYPE;
1334: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
1335: l_expenditure_org_name per_organization_units.name%TYPE;
1336: l_exp_organization_name per_organization_units.name%TYPE;

Line 1396: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE;

1392: l_submitter_resp_id NUMBER;
1393: l_submitter_resp_appl_id NUMBER;
1394: l_calendar_display VARCHAR2(60);
1395: -- FP.L Development
1396: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE;
1397: l_staffing_owner_name per_people_f.full_name%TYPE;
1398:
1399: BEGIN
1400:

Line 2337: UPDATE pa_project_assignments

2333: --to 'Y' on the newly created assignment in order to prevent updates
2334: --until the approval process is complete.
2335: IF l_success_assignment_id_tbl(1) IS NOT NULL AND l_action <> G_SAVE THEN
2336:
2337: UPDATE pa_project_assignments
2338: SET mass_wf_in_progress_flag = 'Y'
2339: WHERE assignment_id = l_success_assignment_id_tbl(1);
2340:
2341: END IF;

Line 2480: FROM pa_project_assignments

2476: --for approval and this is not a mass assignment. (If it is a mass assignment
2477: --not is not submitted then the flag will not already be set to 'Y'
2478: IF (l_assignment_type IS NULL OR l_assignment_type = FND_API.G_MISS_CHAR) THEN
2479: SELECT assignment_type INTO l_assignment_type
2480: FROM pa_project_assignments
2481: WHERE assignment_id = l_single_obj_id_tbl(1);
2482: END IF;
2483: IF (l_action = G_SAVE OR l_success_assignment_id_tbl(1) IS NULL OR l_assignment_type = 'OPEN_ASSIGNMENT') AND l_mode <> G_MASS_ASGMT THEN
2484:

Line 2485: UPDATE pa_project_assignments

2481: WHERE assignment_id = l_single_obj_id_tbl(1);
2482: END IF;
2483: IF (l_action = G_SAVE OR l_success_assignment_id_tbl(1) IS NULL OR l_assignment_type = 'OPEN_ASSIGNMENT') AND l_mode <> G_MASS_ASGMT THEN
2484:
2485: UPDATE pa_project_assignments
2486: SET mass_wf_in_progress_flag = 'N'
2487: WHERE assignment_id = l_single_obj_id_tbl(1);
2488:
2489: END IF;

Line 2634: pa_project_assignments asgmt

2630: l_approver1_name_tbl,
2631: l_approver2_id_tbl,
2632: l_approver2_name_tbl
2633: FROM pa_wf_process_details wf,
2634: pa_project_assignments asgmt
2635: WHERE wf.item_type = p_item_type
2636: AND wf.item_key = p_item_key
2637: AND wf.process_status_code = 'S'
2638: AND decode(l_mode, G_MASS_ASGMT, object_id2, object_id1) = asgmt.assignment_id

Line 2733: UPDATE pa_project_assignments

2729: aname => 'CONFLICT_GROUP_ID');
2730:
2731: --set mass_wf_in_progress_flag = 'N' for those assignments to be canceled
2732: --or reverted.
2733: UPDATE pa_project_assignments
2734: SET mass_wf_in_progress_flag = 'N'
2735: WHERE assignment_id IN
2736: (SELECT distinct assignment_id
2737: FROM pa_assignment_conflict_hist

Line 2768: p_assignment_id IN pa_project_assignments.assignment_id%TYPE)

2764: END Revert_Cancel_Overcom_Items;
2765:
2766: --this function is not currently used.
2767: FUNCTION Is_Asgmt_Revert_Or_Cancel(p_conflict_group_id IN NUMBER,
2768: p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
2769: RETURN BOOLEAN IS
2770:
2771: l_resolve_con_action_code pa_lookups.meaning%TYPE;
2772:

Line 2874: UPDATE pa_project_assignments

2870: itemkey => p_item_key,
2871: aname => 'MODE');
2872:
2873:
2874: UPDATE pa_project_assignments
2875: SET mass_wf_in_progress_flag = 'N'
2876: WHERE assignment_id IN
2877: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2878: FROM pa_wf_process_details

Line 2912: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2908: l_mode VARCHAR2(30);
2909: l_error_item_type VARCHAR2(30);
2910: l_error_item_key NUMBER;
2911: l_submitter_user_id NUMBER;
2912: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2913: l_resource_id pa_resources_denorm.resource_id%TYPE;
2914: l_return_status VARCHAR2(1);
2915: l_project_id pa_projects_all.project_id%TYPE;
2916: TYPE object_id_tbl IS TABLE OF NUMBER

Line 2957: UPDATE pa_project_assignments

2953: AND item_key = l_error_item_key
2954: AND process_status_code = 'P'; --'P' for pending
2955:
2956: --set mass_wf_in_progress_flag='N' for the aborted items.
2957: UPDATE pa_project_assignments
2958: SET mass_wf_in_progress_flag = 'N'
2959: WHERE assignment_id IN
2960: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2961: FROM pa_wf_process_details