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 146: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;

142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);
145: ----Added following folloeing for bug 6199871 ------------------------
146: l_apprvl_status_code PA_PROJECT_ASSIGNMENTS.APPRVL_STATUS_CODE%TYPE;
147: l_change_id NUMBER;
148: l_record_version_number NUMBER;
149: l_return_status VARCHAR2(1);
150: l_msg_count NUMBER;

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

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

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

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

Line 738: UPDATE pa_project_assignments

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

Line 775: l_project_id pa_project_assignments.project_id%TYPE;

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

Line 776: l_start_date pa_project_assignments.start_date%TYPE;

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

Line 777: l_end_date pa_project_assignments.end_date%TYPE;

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

Line 1028: FROM pa_project_assignments

1024: IF l_project_id IS NULL or l_project_id = FND_API.G_MISS_NUM THEN
1025:
1026: SELECT project_id
1027: INTO l_project_id
1028: FROM pa_project_assignments
1029: WHERE assignment_id = l_assignment_id_tbl(1);
1030:
1031: END IF;
1032:

Line 1196: --FROM pa_project_assignments_v

1192:
1193: -- Commented for Perf fix 4918687 SQL ID 14910597
1194: --cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1195: --SELECT fcst_tp_amount_type_name
1196: --FROM pa_project_assignments_v
1197: --WHERE assignment_id = p_asg_id;
1198:
1199: -- Added for Perf fix 4918687 SQL ID 14910597
1200: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS

Line 1202: FROM pa_project_assignments asgn, pa_lookups lkup

1198:
1199: -- Added for Perf fix 4918687 SQL ID 14910597
1200: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1201: SELECT lkup.meaning fcst_tp_amount_type_name
1202: FROM pa_project_assignments asgn, pa_lookups lkup
1203: WHERE lkup.lookup_type(+) = 'TP_AMOUNT_TYPE'
1204: AND asgn.fcst_tp_amount_type = lkup.lookup_code(+)
1205: AND asgn.assignment_id = p_asg_id;
1206:

Line 1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;

1212: l_action VARCHAR2(30);
1213: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;

Line 1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;

1213: l_success_assignment_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;

Line 1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;

1214: l_single_obj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1222: l_project_id NUMBER;

Line 1219: l_status_code pa_project_assignments.status_code%TYPE;

1215: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1222: l_project_id NUMBER;
1223: l_project_role_id NUMBER;

Line 1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;

1216: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1222: l_project_id NUMBER;
1223: l_project_role_id NUMBER;
1224: l_role_list_id NUMBER;

Line 1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;

1217: l_wf_assignment_type pa_project_assignments.assignment_type%TYPE;
1218: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1219: l_status_code pa_project_assignments.status_code%TYPE;
1220: l_multiple_status_flag pa_project_assignments.multiple_status_flag%TYPE;
1221: l_staffing_priority_code pa_project_assignments.staffing_priority_code%TYPE;
1222: l_project_id NUMBER;
1223: l_project_role_id NUMBER;
1224: l_role_list_id NUMBER;
1225: l_project_subteam_id NUMBER;

Line 1226: l_description pa_project_assignments.description%TYPE;

1222: l_project_id NUMBER;
1223: l_project_role_id NUMBER;
1224: l_role_list_id NUMBER;
1225: l_project_subteam_id NUMBER;
1226: l_description pa_project_assignments.description%TYPE;
1227: l_append_description_flag VARCHAR2(1);
1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;

Line 1228: l_start_date pa_project_assignments.start_date%TYPE;

1224: l_role_list_id NUMBER;
1225: l_project_subteam_id NUMBER;
1226: l_description pa_project_assignments.description%TYPE;
1227: l_append_description_flag VARCHAR2(1);
1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

Line 1229: l_end_date pa_project_assignments.end_date%TYPE;

1225: l_project_subteam_id NUMBER;
1226: l_description pa_project_assignments.description%TYPE;
1227: l_append_description_flag VARCHAR2(1);
1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1233: l_additional_information pa_project_assignments.additional_information%TYPE;

Line 1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;

1226: l_description pa_project_assignments.description%TYPE;
1227: l_append_description_flag VARCHAR2(1);
1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1233: l_additional_information pa_project_assignments.additional_information%TYPE;
1234: l_append_information_flag VARCHAR2(1);

Line 1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

1227: l_append_description_flag VARCHAR2(1);
1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1233: l_additional_information pa_project_assignments.additional_information%TYPE;
1234: l_append_information_flag VARCHAR2(1);
1235: l_location_id NUMBER;

Line 1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

1228: l_start_date pa_project_assignments.start_date%TYPE;
1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1233: l_additional_information pa_project_assignments.additional_information%TYPE;
1234: l_append_information_flag VARCHAR2(1);
1235: l_location_id NUMBER;
1236: l_work_type_id NUMBER;

Line 1233: l_additional_information pa_project_assignments.additional_information%TYPE;

1229: l_end_date pa_project_assignments.end_date%TYPE;
1230: l_extension_possible pa_project_assignments.extension_possible%TYPE;
1231: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1232: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1233: l_additional_information pa_project_assignments.additional_information%TYPE;
1234: l_append_information_flag VARCHAR2(1);
1235: l_location_id NUMBER;
1236: l_work_type_id NUMBER;
1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;

Line 1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;

1233: l_additional_information pa_project_assignments.additional_information%TYPE;
1234: l_append_information_flag VARCHAR2(1);
1235: l_location_id NUMBER;
1236: l_work_type_id NUMBER;
1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1238: l_calendar_id NUMBER;
1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;

Line 1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;

1235: l_location_id NUMBER;
1236: l_work_type_id NUMBER;
1237: l_calendar_type pa_project_assignments.calendar_type%TYPE;
1238: l_calendar_id NUMBER;
1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;
1242: l_project_subteam_name pa_project_subteams.name%TYPE;
1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;

1248: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1249: l_location_country_code pa_locations.country_code%TYPE;
1250: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1251: l_work_type_name pa_work_types_vl.name%TYPE;
1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;

Line 1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;

1249: l_location_country_code pa_locations.country_code%TYPE;
1250: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1251: l_work_type_name pa_work_types_vl.name%TYPE;
1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;

Line 1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;

1250: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1251: l_work_type_name pa_work_types_vl.name%TYPE;
1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;

Line 1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;

1251: l_work_type_name pa_work_types_vl.name%TYPE;
1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;

Line 1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;

1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;

Line 1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;

1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;

Line 1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;

1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

Line 1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;

1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;

Line 1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;

1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;

Line 1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;

Line 1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;

1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;

Line 1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;

1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1269: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1270: l_fcst_job_id NUMBER;

Line 1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;

1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1269: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1270: l_fcst_job_id NUMBER;
1271: l_fcst_job_group_id NUMBER;

Line 1269: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;

1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1269: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1270: l_fcst_job_id NUMBER;
1271: l_fcst_job_group_id NUMBER;
1272: l_expenditure_org_id NUMBER;
1273: l_expenditure_organization_id NUMBER;

Line 1274: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;

1270: l_fcst_job_id NUMBER;
1271: l_fcst_job_group_id NUMBER;
1272: l_expenditure_org_id NUMBER;
1273: l_expenditure_organization_id NUMBER;
1274: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
1275: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1276: l_fcst_job_name per_jobs.name%TYPE;
1277: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
1278: l_expenditure_org_name per_organization_units.name%TYPE;

Line 1275: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1271: l_fcst_job_group_id NUMBER;
1272: l_expenditure_org_id NUMBER;
1273: l_expenditure_organization_id NUMBER;
1274: l_expenditure_type_class pa_project_assignments.expenditure_type_class%TYPE;
1275: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1276: l_fcst_job_name per_jobs.name%TYPE;
1277: l_fcst_job_group_name per_job_groups.displayed_name%TYPE;
1278: l_expenditure_org_name per_organization_units.name%TYPE;
1279: l_exp_organization_name per_organization_units.name%TYPE;

Line 1339: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE;

1335: l_submitter_resp_id NUMBER;
1336: l_submitter_resp_appl_id NUMBER;
1337: l_calendar_display VARCHAR2(60);
1338: -- FP.L Development
1339: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE;
1340: l_staffing_owner_name per_people_f.full_name%TYPE;
1341:
1342: BEGIN
1343:

Line 2280: UPDATE pa_project_assignments

2276: --to 'Y' on the newly created assignment in order to prevent updates
2277: --until the approval process is complete.
2278: IF l_success_assignment_id_tbl(1) IS NOT NULL AND l_action <> G_SAVE THEN
2279:
2280: UPDATE pa_project_assignments
2281: SET mass_wf_in_progress_flag = 'Y'
2282: WHERE assignment_id = l_success_assignment_id_tbl(1);
2283:
2284: END IF;

Line 2423: FROM pa_project_assignments

2419: --for approval and this is not a mass assignment. (If it is a mass assignment
2420: --not is not submitted then the flag will not already be set to 'Y'
2421: IF (l_assignment_type IS NULL OR l_assignment_type = FND_API.G_MISS_CHAR) THEN
2422: SELECT assignment_type INTO l_assignment_type
2423: FROM pa_project_assignments
2424: WHERE assignment_id = l_single_obj_id_tbl(1);
2425: END IF;
2426: 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
2427:

Line 2428: UPDATE pa_project_assignments

2424: WHERE assignment_id = l_single_obj_id_tbl(1);
2425: END IF;
2426: 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
2427:
2428: UPDATE pa_project_assignments
2429: SET mass_wf_in_progress_flag = 'N'
2430: WHERE assignment_id = l_single_obj_id_tbl(1);
2431:
2432: END IF;

Line 2577: pa_project_assignments asgmt

2573: l_approver1_name_tbl,
2574: l_approver2_id_tbl,
2575: l_approver2_name_tbl
2576: FROM pa_wf_process_details wf,
2577: pa_project_assignments asgmt
2578: WHERE wf.item_type = p_item_type
2579: AND wf.item_key = p_item_key
2580: AND wf.process_status_code = 'S'
2581: AND decode(l_mode, G_MASS_ASGMT, object_id2, object_id1) = asgmt.assignment_id

Line 2674: UPDATE pa_project_assignments

2670: aname => 'CONFLICT_GROUP_ID');
2671:
2672: --set mass_wf_in_progress_flag = 'N' for those assignments to be canceled
2673: --or reverted.
2674: UPDATE pa_project_assignments
2675: SET mass_wf_in_progress_flag = 'N'
2676: WHERE assignment_id IN
2677: (SELECT distinct assignment_id
2678: FROM pa_assignment_conflict_hist

Line 2709: p_assignment_id IN pa_project_assignments.assignment_id%TYPE)

2705: END Revert_Cancel_Overcom_Items;
2706:
2707: --this function is not currently used.
2708: FUNCTION Is_Asgmt_Revert_Or_Cancel(p_conflict_group_id IN NUMBER,
2709: p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
2710: RETURN BOOLEAN IS
2711:
2712: l_resolve_con_action_code pa_lookups.meaning%TYPE;
2713:

Line 2815: UPDATE pa_project_assignments

2811: itemkey => p_item_key,
2812: aname => 'MODE');
2813:
2814:
2815: UPDATE pa_project_assignments
2816: SET mass_wf_in_progress_flag = 'N'
2817: WHERE assignment_id IN
2818: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2819: FROM pa_wf_process_details

Line 2853: l_assignment_id pa_project_assignments.assignment_id%TYPE;

2849: l_mode VARCHAR2(30);
2850: l_error_item_type VARCHAR2(30);
2851: l_error_item_key NUMBER;
2852: l_submitter_user_id NUMBER;
2853: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2854: l_resource_id pa_resources_denorm.resource_id%TYPE;
2855: l_return_status VARCHAR2(1);
2856: l_project_id pa_projects_all.project_id%TYPE;
2857: TYPE object_id_tbl IS TABLE OF NUMBER

Line 2898: UPDATE pa_project_assignments

2894: AND item_key = l_error_item_key
2895: AND process_status_code = 'P'; --'P' for pending
2896:
2897: --set mass_wf_in_progress_flag='N' for the aborted items.
2898: UPDATE pa_project_assignments
2899: SET mass_wf_in_progress_flag = 'N'
2900: WHERE assignment_id IN
2901: (SELECT decode(l_mode, G_MASS_ASGMT, object_id2, object_id1)
2902: FROM pa_wf_process_details