eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MASS_ASGMT_TRX dependencies on FND_API

Line 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 16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

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'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

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

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'
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

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 32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 34: ,p_project_subteam_name IN pa_project_subteams.name%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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

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

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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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

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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 37: ,p_project_role_name IN pa_project_role_types.meaning%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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

Line 38: ,p_location_city IN pa_locations.city%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
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

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

35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

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

36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

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

37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

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

38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%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

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

39: ,p_location_region IN pa_locations.region%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

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 61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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 63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

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 65: ,p_search_exp_start_org_name IN hr_organization_units.name%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
69: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --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 69: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR --FP.L Development

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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 70: ,p_fcst_job_name IN per_jobs.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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

Line 72: ,p_expenditure_org_name IN per_organization_units.name%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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

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

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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

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
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

72: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

73: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

74: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
75: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
76: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
77: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
78: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
79: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
80: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
81: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
82: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

85: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

86: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

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

87: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

88: ,p_non_working_day_flag IN VARCHAR2 := 'N'
89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

89: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

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

90: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

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

91: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

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

92: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

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

93: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
94: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

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

98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl

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

99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl

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

105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
108: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
109: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865
111: )
112: IS
113:

Line 158: x_return_status := FND_API.G_RET_STS_SUCCESS;

154: */
155: BEGIN
156:
157: --initialize return status to Success
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159:
160: -- Setting thresold value to run the process in background
161: l_save_threshold := wf_engine.threshold;
162:

Line 207: IF p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM THEN

203:
204: --if project id is not passed (could only happen when adding a delivery or
205: --an admin assignment from the resource context) then get the project id
206: --from the project number. Project number is required.
207: IF p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM THEN
208: SELECT project_id INTO l_project_id
209: FROM pa_projects_all
210: WHERE segment1 = p_project_number;
211: ELSE

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

752: -- Set the excetption Message and the stack
753: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'pa_mass_asgmt_trx.start_mass_asgmt_trx_wf'
754: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
755: --
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: RAISE;
758:
759: END start_mass_asgmt_trx_wf;
760:

Line 1080: IF l_project_id IS NULL or l_project_id = FND_API.G_MISS_NUM THEN

1076: --in the notification even if none of the updates were successful - so get the
1077: --first assignment id and use it to get the project id.
1078: --l_success_assignment_id_tbl only has successful assignments
1079:
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

Line 1458: IF l_assignment_name <> FND_API.G_MISS_CHAR AND l_assignment_name IS NOT NULL THEN

1454: aname => 'ASSIGNMENT_NAME');
1455:
1456: --if the attribute has been updated then
1457: --append to x_document to display the Updated Information region in the wf notification
1458: IF l_assignment_name <> FND_API.G_MISS_CHAR AND l_assignment_name IS NOT NULL THEN
1459: x_document := x_document||get_translated_attr_name('ASSIGNMENT_NAME')||' - '||l_assignment_name||'
';
1460: END IF;
1461:
1462: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1497: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN

1493:
1494: --if the attribute has been updated then
1495: --append to x_document to display the Updated Information region in the wf notification
1496: --get the name as we will only have the code as the field is a poplist on the page
1497: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN
1498: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN
1499: SELECT meaning INTO l_staffing_priority_name
1500: FROM pa_lookups
1501: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'

Line 1498: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN

1494: --if the attribute has been updated then
1495: --append to x_document to display the Updated Information region in the wf notification
1496: --get the name as we will only have the code as the field is a poplist on the page
1497: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN
1498: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN
1499: SELECT meaning INTO l_staffing_priority_name
1500: FROM pa_lookups
1501: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
1502: AND lookup_code = l_staffing_priority_code;

Line 1530: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN

1526:
1527: --if the attribute has been updated then
1528: --append to x_document to display the Updated Information region in the wf notification
1529: --get the name as we will only have the code as the field is a poplist on the page
1530: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN
1531: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN
1532: SELECT name INTO l_project_subteam_name
1533: FROM pa_project_subteams
1534: WHERE project_subteam_id = l_project_subteam_id;

Line 1531: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN

1527: --if the attribute has been updated then
1528: --append to x_document to display the Updated Information region in the wf notification
1529: --get the name as we will only have the code as the field is a poplist on the page
1530: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN
1531: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN
1532: SELECT name INTO l_project_subteam_name
1533: FROM pa_project_subteams
1534: WHERE project_subteam_id = l_project_subteam_id;
1535: END IF;

Line 1547: IF l_extension_possible <> FND_API.G_MISS_CHAR AND l_extension_possible IS NOT NULL THEN

1543:
1544: --if the attribute has been updated then
1545: --append to x_document to display the Updated Information region in the wf notification
1546: --get the meaning as we will not have it as the field is a poplist on the page
1547: IF l_extension_possible <> FND_API.G_MISS_CHAR AND l_extension_possible IS NOT NULL THEN
1548: SELECT meaning INTO l_extension_possible_meaning
1549: FROM fnd_lookups
1550: WHERE lookup_type='YES_NO'
1551: AND lookup_code = l_extension_possible;

Line 1561: IF l_min_resource_job_level <> FND_API.G_MISS_NUM AND l_min_resource_job_level IS NOT NULL THEN

1557: aname => 'MIN_RESOURCE_JOB_LEVEL');
1558:
1559: --if the attribute has been updated then
1560: --append to x_document to display the Updated Information region in the wf notification
1561: IF l_min_resource_job_level <> FND_API.G_MISS_NUM AND l_min_resource_job_level IS NOT NULL THEN
1562: x_document := x_document||get_translated_attr_name('MIN_RESOURCE_JOB_LEVEL')||' - '||l_min_resource_job_level||'
';
1563: END IF;
1564:
1565: l_max_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1571: IF l_max_resource_job_level <> FND_API.G_MISS_NUM AND l_max_resource_job_level IS NOT NULL THEN

1567: aname => 'MAX_RESOURCE_JOB_LEVEL');
1568:
1569: --if the attribute has been updated then
1570: --append to x_document to display the Updated Information region in the wf notification
1571: IF l_max_resource_job_level <> FND_API.G_MISS_NUM AND l_max_resource_job_level IS NOT NULL THEN
1572: x_document := x_document||get_translated_attr_name('MAX_RESOURCE_JOB_LEVEL')||' - '||l_max_resource_job_level||'
';
1573: END IF;
1574:
1575: -- FP.L Development

Line 1586: IF l_staffing_owner_name <> FND_API.G_MISS_CHAR AND l_staffing_owner_name IS NOT NULL THEN

1582: aname => 'STAFFING_OWNER_NAME');
1583:
1584: --if the attribute has been updated then
1585: --append to x_document to display the Updated Information region in the wf notification
1586: IF l_staffing_owner_name <> FND_API.G_MISS_CHAR AND l_staffing_owner_name IS NOT NULL THEN
1587: x_document := x_document||get_translated_attr_name('STAFFING_OWNER')||' - '||l_staffing_owner_name||'
';
1588: END IF;
1589:
1590: l_description := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1596: IF l_description <> FND_API.G_MISS_CHAR AND l_description IS NOT NULL THEN

1592: aname => 'DESCRIPTION');
1593:
1594: --if the attribute has been updated then
1595: --append to x_document to display the Updated Information region in the wf notification
1596: IF l_description <> FND_API.G_MISS_CHAR AND l_description IS NOT NULL THEN
1597: x_document := x_document||get_translated_attr_name('DESCRIPTION')||' - '||l_description||'
';
1598: END IF;
1599:
1600: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1610: IF l_additional_information <> FND_API.G_MISS_CHAR AND l_additional_information IS NOT NULL THEN

1606: aname => 'ADDITIONAL_INFORMATION');
1607:
1608: --if the attribute has been updated then
1609: --append to x_document to display the Updated Information region in the wf notification
1610: IF l_additional_information <> FND_API.G_MISS_CHAR AND l_additional_information IS NOT NULL THEN
1611: x_document := x_document||get_translated_attr_name('ADDITIONAL_INFORMATION')||' - '||l_additional_information||'
';
1612: END IF;
1613:
1614: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1625: IF l_start_date <> FND_API.G_MISS_DATE AND l_start_date IS NOT NULL THEN

1621: x_start_date := l_start_date;
1622:
1623: --if the attribute has been updated then
1624: --append to x_document to display the Updated Information region in the wf notification
1625: IF l_start_date <> FND_API.G_MISS_DATE AND l_start_date IS NOT NULL THEN
1626: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_start_date||'
';
1627: END IF;
1628:
1629: l_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

Line 1637: IF l_end_date <> FND_API.G_MISS_DATE AND l_end_date IS NOT NULL THEN

1633: x_end_date := l_end_date;
1634:
1635: --if the attribute has been updated then
1636: --append to x_document to display the Updated Information region in the wf notification
1637: IF l_end_date <> FND_API.G_MISS_DATE AND l_end_date IS NOT NULL THEN
1638: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_end_date||'
';
1639: END IF;
1640:
1641: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1651: IF l_location_city <> FND_API.G_MISS_CHAR AND l_location_city IS NOT NULL THEN

1647: aname => 'LOCATION_CITY');
1648:
1649: --if the attribute has been updated then
1650: --append to x_document to display the Updated Information region in the wf notification
1651: IF l_location_city <> FND_API.G_MISS_CHAR AND l_location_city IS NOT NULL THEN
1652: x_document := x_document||get_translated_attr_name('LOCATION_CITY')||' - '||l_location_city||'
';
1653: END IF;
1654:
1655: l_location_region := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1661: IF l_location_region <> FND_API.G_MISS_CHAR AND l_location_region IS NOT NULL THEN

1657: aname => 'LOCATION_REGION');
1658:
1659: --if the attribute has been updated then
1660: --append to x_document to display the Updated Information region in the wf notification
1661: IF l_location_region <> FND_API.G_MISS_CHAR AND l_location_region IS NOT NULL THEN
1662: x_document := x_document||get_translated_attr_name('LOCATION_REGION')||' - '||l_location_region||'
';
1663: END IF;
1664:
1665: l_location_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1671: IF l_location_country_name <> FND_API.G_MISS_CHAR AND l_location_country_name IS NOT NULL THEN

1667: aname => 'LOCATION_COUNTRY_NAME');
1668:
1669: --if the attribute has been updated then
1670: --append to x_document to display the Updated Information region in the wf notification
1671: IF l_location_country_name <> FND_API.G_MISS_CHAR AND l_location_country_name IS NOT NULL THEN
1672: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_location_country_name||'
';
1673: END IF;
1674:
1675: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1710: IF l_expense_owner <> FND_API.G_MISS_CHAR AND l_expense_owner IS NOT NULL THEN

1706:
1707: --if the attribute has been updated then
1708: --append to x_document to display the Updated Information region in the wf notification
1709: --get the meaning as we will not have it as the field is a poplist on the page
1710: IF l_expense_owner <> FND_API.G_MISS_CHAR AND l_expense_owner IS NOT NULL THEN
1711: SELECT meaning INTO l_expense_owner_meaning
1712: FROM pa_lookups
1713: WHERE lookup_type = 'EXPENSE_OWNER_TYPE'
1714: AND lookup_code = l_expense_owner;

Line 1724: IF l_expense_limit <> FND_API.G_MISS_NUM AND l_expense_limit IS NOT NULL THEN

1720: aname => 'EXPENSE_LIMIT');
1721:
1722: --if the attribute has been updated then
1723: --append to x_document to display the Updated Information region in the wf notification
1724: IF l_expense_limit <> FND_API.G_MISS_NUM AND l_expense_limit IS NOT NULL THEN
1725: x_document := x_document||get_translated_attr_name('EXPENSE_LIMIT')||' - '||l_expense_limit||'
';
1726: END IF;
1727:
1728: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1738: IF l_comp_match_weighting <> FND_API.G_MISS_NUM AND l_comp_match_weighting IS NOT NULL THEN

1734: aname => 'COMP_MATCH_WEIGHTING');
1735:
1736: --if the attribute has been updated then
1737: --append to x_document to display the Updated Information region in the wf notification
1738: IF l_comp_match_weighting <> FND_API.G_MISS_NUM AND l_comp_match_weighting IS NOT NULL THEN
1739: x_document := x_document||get_translated_attr_name('COMP_MATCH_WEIGHTING')||' - '||l_comp_match_weighting||'
';
1740: END IF;
1741:
1742: l_avail_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1748: IF l_avail_match_weighting <> FND_API.G_MISS_NUM AND l_avail_match_weighting IS NOT NULL THEN

1744: aname => 'AVAIL_MATCH_WEIGHTING');
1745:
1746: --if the attribute has been updated then
1747: --append to x_document to display the Updated Information region in the wf notification
1748: IF l_avail_match_weighting <> FND_API.G_MISS_NUM AND l_avail_match_weighting IS NOT NULL THEN
1749: x_document := x_document||get_translated_attr_name('AVAIL_MATCH_WEIGHTING')||' - '||l_avail_match_weighting||'
';
1750: END IF;
1751:
1752: l_job_level_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1758: IF l_job_level_match_weighting <> FND_API.G_MISS_NUM AND l_job_level_match_weighting IS NOT NULL THEN

1754: aname => 'JOB_LEVEL_MATCH_WEIGHTING');
1755:
1756: --if the attribute has been updated then
1757: --append to x_document to display the Updated Information region in the wf notification
1758: IF l_job_level_match_weighting <> FND_API.G_MISS_NUM AND l_job_level_match_weighting IS NOT NULL THEN
1759: x_document := x_document||get_translated_attr_name('JOB_LEVEL_MATCH_WEIGHTING')||' - '||l_job_level_match_weighting||'
';
1760: END IF;
1761:
1762: l_search_min_availability := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1768: IF l_search_min_availability <> FND_API.G_MISS_NUM AND l_search_min_availability IS NOT NULL THEN

1764: aname => 'SEARCH_MIN_AVAILABILITY');
1765:
1766: --if the attribute has been updated then
1767: --append to x_document to display the Updated Information region in the wf notification
1768: IF l_search_min_availability <> FND_API.G_MISS_NUM AND l_search_min_availability IS NOT NULL THEN
1769: x_document := x_document||get_translated_attr_name('SEARCH_MIN_AVAILABILITY')||' - '||l_search_min_availability||'
';
1770: END IF;
1771:
1772: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1782: IF l_search_country_name <> FND_API.G_MISS_CHAR AND l_search_country_name IS NOT NULL THEN

1778: aname => 'SEARCH_COUNTRY_NAME');
1779:
1780: --if the attribute has been updated then
1781: --append to x_document to display the Updated Information region in the wf notification
1782: IF l_search_country_name <> FND_API.G_MISS_CHAR AND l_search_country_name IS NOT NULL THEN
1783: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_search_country_name||'
';
1784: END IF;
1785:
1786: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1796: IF l_search_exp_org_hier_name <> FND_API.G_MISS_CHAR AND l_search_exp_org_hier_name IS NOT NULL THEN

1792: aname => 'SEARCH_EXP_ORG_HIER_NAME');
1793:
1794: --if the attribute has been updated then
1795: --append to x_document to display the Updated Information region in the wf notification
1796: IF l_search_exp_org_hier_name <> FND_API.G_MISS_CHAR AND l_search_exp_org_hier_name IS NOT NULL THEN
1797: x_document := x_document||get_translated_attr_name('SEARCH_EXP_ORG_HIER_NAME')||' - '||l_search_exp_org_hier_name||'
';
1798: END IF;
1799:
1800: l_search_exp_start_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1810: IF l_search_exp_start_org_name <> FND_API.G_MISS_CHAR AND l_search_exp_start_org_name IS NOT NULL THEN

1806: aname => 'SEARCH_EXP_START_ORG_NAME');
1807:
1808: --if the attribute has been updated then
1809: --append to x_document to display the Updated Information region in the wf notification
1810: IF l_search_exp_start_org_name <> FND_API.G_MISS_CHAR AND l_search_exp_start_org_name IS NOT NULL THEN
1811: x_document := x_document||get_translated_attr_name('SEARCH_EXP_START_ORG_NAME')||' - '||l_search_exp_start_org_name||'
';
1812: END IF;
1813:
1814: l_search_min_candidate_score := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1820: IF l_search_min_candidate_score <> FND_API.G_MISS_NUM AND l_search_min_candidate_score IS NOT NULL THEN

1816: aname => 'SEARCH_MIN_CANDIDATE_SCORE');
1817:
1818: --if the attribute has been updated then
1819: --append to x_document to display the Updated Information region in the wf notification
1820: IF l_search_min_candidate_score <> FND_API.G_MISS_NUM AND l_search_min_candidate_score IS NOT NULL THEN
1821: x_document := x_document||get_translated_attr_name('SEARCH_MIN_CANDIDATE_SCORE')||' - '||l_search_min_candidate_score||'
';
1822: END IF;
1823:
1824: L_ENABLE_AUTO_CAND_NOM_FLAG := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1830: IF L_ENABLE_AUTO_CAND_NOM_FLAG <> FND_API.G_MISS_CHAR AND L_ENABLE_AUTO_CAND_NOM_FLAG IS NOT NULL THEN

1826: aname => 'ENABLE_AUTO_CAND_NOM_FLAG');
1827:
1828: --if the attribute has been updated then
1829: --append to x_document to display the Updated Information region in the wf notification
1830: IF L_ENABLE_AUTO_CAND_NOM_FLAG <> FND_API.G_MISS_CHAR AND L_ENABLE_AUTO_CAND_NOM_FLAG IS NOT NULL THEN
1831: SELECT meaning INTO L_ENABLE_AUTO_CAND_NOM_MEANING
1832: FROM fnd_lookups
1833: WHERE lookup_type='YES_NO'
1834: AND lookup_code = L_ENABLE_AUTO_CAND_NOM_FLAG;

Line 1851: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN

1847:
1848: --if the attribute has been updated then
1849: --append to x_document to display the Updated Information region in the wf notification
1850: --get the name as we will not have it as the field is a poplist on the page
1851: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN
1852: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN
1853: SELECT name INTO l_work_type_name
1854: FROM pa_work_types_vl
1855: WHERE work_type_id = l_work_type_id;

Line 1852: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN

1848: --if the attribute has been updated then
1849: --append to x_document to display the Updated Information region in the wf notification
1850: --get the name as we will not have it as the field is a poplist on the page
1851: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN
1852: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN
1853: SELECT name INTO l_work_type_name
1854: FROM pa_work_types_vl
1855: WHERE work_type_id = l_work_type_id;
1856: END IF;

Line 1867: IF l_fcst_tp_amount_type <> FND_API.G_MISS_CHAR AND l_fcst_tp_amount_type IS NOT NULL THEN

1863:
1864: --if the attribute has been updated then
1865: --append to x_document to display the Updated Information region in the wf notification
1866: --get the meaning as we will not have it as the field is a poplist on the page
1867: IF l_fcst_tp_amount_type <> FND_API.G_MISS_CHAR AND l_fcst_tp_amount_type IS NOT NULL THEN
1868: SELECT meaning INTO l_fcst_tp_amount_type_meaning
1869: FROM pa_lookups
1870: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1871: AND lookup_code = l_fcst_tp_amount_type;

Line 1885: IF l_fcst_job_name <> FND_API.G_MISS_CHAR AND l_fcst_job_name IS NOT NULL THEN

1881: aname => 'FCST_JOB_NAME');
1882:
1883: --if the attribute has been updated then
1884: --append to x_document to display the Updated Information region in the wf notification
1885: IF l_fcst_job_name <> FND_API.G_MISS_CHAR AND l_fcst_job_name IS NOT NULL THEN
1886: x_document := x_document||get_translated_attr_name('FCST_JOB_NAME')||' - '||l_fcst_job_name||'
';
1887: END IF;
1888:
1889: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1899: IF l_fcst_job_group_name <> FND_API.G_MISS_CHAR AND l_fcst_job_group_name IS NOT NULL THEN

1895: aname => 'FCST_JOB_GROUP_NAME');
1896:
1897: --if the attribute has been updated then
1898: --append to x_document to display the Updated Information region in the wf notification
1899: IF l_fcst_job_group_name <> FND_API.G_MISS_CHAR AND l_fcst_job_group_name IS NOT NULL THEN
1900: x_document := x_document||get_translated_attr_name('FCST_JOB_GROUP_NAME')||' - '||l_fcst_job_group_name||'
';
1901: END IF;
1902:
1903: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1913: IF l_expenditure_org_name <> FND_API.G_MISS_CHAR AND l_expenditure_org_name IS NOT NULL THEN

1909: aname => 'EXPENDITURE_ORG_NAME');
1910:
1911: --if the attribute has been updated then
1912: --append to x_document to display the Updated Information region in the wf notification
1913: IF l_expenditure_org_name <> FND_API.G_MISS_CHAR AND l_expenditure_org_name IS NOT NULL THEN
1914: x_document := x_document||get_translated_attr_name('EXPENDITURE_ORG_NAME')||' - '||l_expenditure_org_name||'
';
1915: END IF;
1916:
1917: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 1927: IF l_exp_organization_name <> FND_API.G_MISS_CHAR AND l_exp_organization_name IS NOT NULL THEN

1923: aname => 'EXP_ORGANIZATION_NAME');
1924:
1925: --if the attribute has been updated then
1926: --append to x_document to display the Updated Information region in the wf notification
1927: IF l_exp_organization_name <> FND_API.G_MISS_CHAR AND l_exp_organization_name IS NOT NULL THEN
1928: x_document := x_document||get_translated_attr_name('EXP_ORGANIZATION_NAME')||' - '||l_exp_organization_name||'
';
1929: END IF;
1930:
1931: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 1941: IF l_expenditure_type <> FND_API.G_MISS_CHAR AND l_expenditure_type IS NOT NULL THEN

1937: aname => 'EXPENDITURE_TYPE');
1938:
1939: --if the attribute has been updated then
1940: --append to x_document to display the Updated Information region in the wf notification
1941: IF l_expenditure_type <> FND_API.G_MISS_CHAR AND l_expenditure_type IS NOT NULL THEN
1942: x_document := x_document||get_translated_attr_name('EXPENDITURE_TYPE')||' - '||l_expenditure_type||'
';
1943: END IF;
1944:
1945:

Line 1960: IF l_change_start_date <> FND_API.G_MISS_DATE THEN

1956:
1957: IF l_exception_type_code = 'CHANGE_DURATION' THEN
1958: --if the attribute has been updated then
1959: --append to x_document to display the Updated Information region in the wf notification
1960: IF l_change_start_date <> FND_API.G_MISS_DATE THEN
1961: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date||'
';
1962: END IF;
1963: END IF;
1964:

Line 1972: IF l_change_end_date <> FND_API.G_MISS_DATE THEN

1968:
1969: IF l_exception_type_code = 'CHANGE_DURATION' THEN
1970: --if the attribute has been updated then
1971: --append to x_document to display the Updated Information region in the wf notification
1972: IF l_change_end_date <> FND_API.G_MISS_DATE THEN
1973: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date||'
';
1974: END IF;
1975: END IF;
1976:

Line 1981: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN

1977: l_change_rqmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1978: itemkey => p_item_key,
1979: aname => 'CHANGE_RQMT_STATUS_CODE');
1980:
1981: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN
1982:
1983: SELECT project_status_name INTO l_project_status_name
1984: FROM pa_project_statuses
1985: WHERE project_status_code = l_change_rqmt_status_code

Line 1999: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN

1995:
1996: --if the attribute has been updated then
1997: --append to x_document to display the Updated Information region in the wf notification
1998: --get the name as we will only have the code as the field is a poplist on the page
1999: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN
2000: SELECT project_status_name INTO l_project_status_name
2001: FROM pa_project_statuses
2002: WHERE project_status_code = l_change_asgmt_status_code
2003: AND status_type='STAFFED_ASGMT' ;

Line 2031: IF l_change_start_date_tbl(j) <> FND_API.G_MISS_DATE THEN

2027: aname => 'CHANGE_START_DATE'||j);
2028:
2029: --if the attribute has been updated then
2030: --append to x_document to display the Updated Information region in the wf notification
2031: IF l_change_start_date_tbl(j) <> FND_API.G_MISS_DATE THEN
2032: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date_tbl(j)||'
';
2033: END IF;
2034:
2035: l_change_end_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

Line 2041: IF l_change_end_date_tbl(j) <> FND_API.G_MISS_DATE THEN

2037: aname => 'CHANGE_END_DATE'||j);
2038:
2039: --if the attribute has been updated then
2040: --append to x_document to display the Updated Information region in the wf notification
2041: IF l_change_end_date_tbl(j) <> FND_API.G_MISS_DATE THEN
2042: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date_tbl(j)||'
';
2043: END IF;
2044:
2045: l_monday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2051: IF l_monday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_monday_hours_tbl(j) IS NOT NULL THEN

2047: aname => 'MONDAY_HOURS'||j);
2048:
2049: --if the attribute has been updated then
2050: --append to x_document to display the Updated Information region in the wf notification
2051: IF l_monday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_monday_hours_tbl(j) IS NOT NULL THEN
2052: x_document := x_document||get_translated_attr_name('MONDAY_HOURS')||' - '||l_monday_hours_tbl(j)||'
';
2053: END IF;
2054:
2055: l_tuesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2061: IF l_tuesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_tuesday_hours_tbl(j) IS NOT NULL THEN

2057: aname => 'TUESDAY_HOURS'||j);
2058:
2059: --if the attribute has been updated then
2060: --append to x_document to display the Updated Information region in the wf notification
2061: IF l_tuesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_tuesday_hours_tbl(j) IS NOT NULL THEN
2062: x_document := x_document||get_translated_attr_name('TUESDAY_HOURS')||' - '||l_tuesday_hours_tbl(j)||'
';
2063: END IF;
2064:
2065: l_wednesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2071: IF l_wednesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_wednesday_hours_tbl(j) IS NOT NULL THEN

2067: aname => 'WEDNESDAY_HOURS'||j);
2068:
2069: --if the attribute has been updated then
2070: --append to x_document to display the Updated Information region in the wf notification
2071: IF l_wednesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_wednesday_hours_tbl(j) IS NOT NULL THEN
2072: x_document := x_document||get_translated_attr_name('WEDNESDAY_HOURS')||' - '||l_wednesday_hours_tbl(j)||'
';
2073: END IF;
2074:
2075: l_thursday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2081: IF l_thursday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_thursday_hours_tbl(j) IS NOT NULL THEN

2077: aname => 'THURSDAY_HOURS'||j);
2078:
2079: --if the attribute has been updated then
2080: --append to x_document to display the Updated Information region in the wf notification
2081: IF l_thursday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_thursday_hours_tbl(j) IS NOT NULL THEN
2082: x_document := x_document||get_translated_attr_name('THURSDAY_HOURS')||' - '||l_thursday_hours_tbl(j)||'
';
2083: END IF;
2084:
2085: l_friday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2091: IF l_friday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_friday_hours_tbl(j) IS NOT NULL THEN

2087: aname => 'FRIDAY_HOURS'||j);
2088:
2089: --if the attribute has been updated then
2090: --append to x_document to display the Updated Information region in the wf notification
2091: IF l_friday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_friday_hours_tbl(j) IS NOT NULL THEN
2092: x_document := x_document||get_translated_attr_name('FRIDAY_HOURS')||' - '||l_friday_hours_tbl(j)||'
';
2093: END IF;
2094:
2095: l_saturday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2101: IF l_saturday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_saturday_hours_tbl(j) IS NOT NULL THEN

2097: aname => 'SATURDAY_HOURS'||j);
2098:
2099: --if the attribute has been updated then
2100: --append to x_document to display the Updated Information region in the wf notification
2101: IF l_saturday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_saturday_hours_tbl(j) IS NOT NULL THEN
2102: x_document := x_document||get_translated_attr_name('SATURDAY_HOURS')||' - '||l_saturday_hours_tbl(j)||'
';
2103: END IF;
2104:
2105: l_sunday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2111: IF l_sunday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_sunday_hours_tbl(j) IS NOT NULL THEN

2107: aname => 'SUNDAY_HOURS'||j);
2108:
2109: --if the attribute has been updated then
2110: --append to x_document to display the Updated Information region in the wf notification
2111: IF l_sunday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_sunday_hours_tbl(j) IS NOT NULL THEN
2112: x_document := x_document||get_translated_attr_name('SUNDAY_HOURS')||' - '||l_sunday_hours_tbl(j)||'
';
2113: END IF;
2114:
2115: END LOOP;

Line 2132: IF l_hrs_per_day <> FND_API.G_MISS_NUM AND l_hrs_per_day IS NOT NULL THEN

2128: aname => 'HRS_PER_DAY');
2129:
2130: --if the attribute has been updated then
2131: --append to x_document to display the Updated Information region in the wf notification
2132: IF l_hrs_per_day <> FND_API.G_MISS_NUM AND l_hrs_per_day IS NOT NULL THEN
2133: x_document := x_document||get_translated_attr_name('HRS_PER_DAY')||' - '||l_hrs_per_day||'
';
2134: END IF;
2135:
2136: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

Line 2144: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN

2140: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2141: itemkey => p_item_key,
2142: aname => 'CHANGE_CALENDAR_NAME');
2143:
2144: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN
2145: l_calendar_display := ': '||l_change_calendar_name;
2146: END IF;
2147:
2148: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

Line 2158: IF l_calendar_percent <> FND_API.G_MISS_NUM AND l_calendar_percent IS NOT NULL THEN

2154: aname => 'CALENDAR_PERCENT');
2155:
2156: --if the attribute has been updated then
2157: --append to x_document to display the Updated Information region in the wf notification
2158: IF l_calendar_percent <> FND_API.G_MISS_NUM AND l_calendar_percent IS NOT NULL THEN
2159: x_document := x_document||get_translated_attr_name('CALENDAR_PERCENT')||': '||get_translated_attr_name(l_change_calendar_type_code||'_CALENDAR')||l_calendar_display||' - '||l_calendar_percent||'
';
2160: END IF;
2161:
2162:

Line 2175: IF l_num_of_shift <> FND_API.G_MISS_NUM AND l_num_of_shift IS NOT NULL THEN

2171: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2172: itemkey => p_item_key,
2173: aname => 'NUM_OF_SHIFT');
2174:
2175: IF l_num_of_shift <> FND_API.G_MISS_NUM AND l_num_of_shift IS NOT NULL THEN
2176: x_document := x_document||get_translated_attr_name('NUM_OF_SHIFT')||' '||l_num_of_shift||' '||get_translated_attr_name(l_duration_shift_unit_code)||' '||get_translated_attr_name(l_duration_shift_type_code)||'
';
2177: END IF;
2178:
2179: ELSIF l_mode = G_MASS_UPDATE_COMPETENCIES THEN

Line 2213: IF l_rating_level_id_tbl(i) <> FND_API.G_MISS_NUM AND l_rating_level_id_tbl(i) IS NOT NULL THEN

2209: aname => 'RATING_LEVEL_ID'||i);
2210:
2211: --if rating level id is not null then get the actual rating level
2212: --in order to display on the wf notification.
2213: IF l_rating_level_id_tbl(i) <> FND_API.G_MISS_NUM AND l_rating_level_id_tbl(i) IS NOT NULL THEN
2214: SELECT step_value INTO l_rating_level
2215: FROM per_rating_levels_v
2216: WHERE rating_level_id = l_rating_level_id_tbl(i);
2217: END IF;

Line 2225: IF l_mandatory_flag_tbl(i) <> FND_API.G_MISS_CHAR AND l_mandatory_flag_tbl(i) IS NOT NULL THEN

2221: aname => 'MANDATORY_FLAG'||i);
2222:
2223: --if mandatory_flag is not null then get the meaning
2224: --in order to display on the wf notification.
2225: IF l_mandatory_flag_tbl(i) <> FND_API.G_MISS_CHAR AND l_mandatory_flag_tbl(i) IS NOT NULL THEN
2226: SELECT meaning INTO l_mandatory_flag_meaning
2227: FROM fnd_lookups
2228: WHERE lookup_type = 'YES_NO'
2229: AND lookup_code = l_mandatory_flag_tbl(i);

Line 2307: p_init_msg_list => FND_API.G_TRUE ,

2303: p_location_country_name => l_location_country_name ,
2304: p_location_country_code => l_location_country_code ,
2305: p_calendar_name => l_calendar_name ,
2306: p_work_type_name => l_work_type_name ,
2307: p_init_msg_list => FND_API.G_TRUE ,
2308: p_commit => FND_API.G_TRUE ,
2309: p_validate_only => FND_API.G_FALSE ,
2310: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2311: x_return_status => l_return_status,

Line 2308: p_commit => FND_API.G_TRUE ,

2304: p_location_country_code => l_location_country_code ,
2305: p_calendar_name => l_calendar_name ,
2306: p_work_type_name => l_work_type_name ,
2307: p_init_msg_list => FND_API.G_TRUE ,
2308: p_commit => FND_API.G_TRUE ,
2309: p_validate_only => FND_API.G_FALSE ,
2310: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2311: x_return_status => l_return_status,
2312: x_msg_count => l_msg_count,

Line 2309: p_validate_only => FND_API.G_FALSE ,

2305: p_calendar_name => l_calendar_name ,
2306: p_work_type_name => l_work_type_name ,
2307: p_init_msg_list => FND_API.G_TRUE ,
2308: p_commit => FND_API.G_TRUE ,
2309: p_validate_only => FND_API.G_FALSE ,
2310: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2311: x_return_status => l_return_status,
2312: x_msg_count => l_msg_count,
2313: x_msg_data => l_msg_data

Line 2385: p_commit => FND_API.G_TRUE ,

2381: p_search_min_candidate_score => l_search_min_candidate_score,
2382: p_enable_auto_cand_nom_flag => l_enable_auto_cand_nom_flag,
2383: p_staffing_owner_person_id => l_staffing_owner_person_id,
2384: p_staffing_owner_name => l_staffing_owner_name,
2385: p_commit => FND_API.G_TRUE ,
2386: p_validate_only => FND_API.G_FALSE ,
2387: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2388: x_return_status => l_return_status,
2389: x_msg_count => l_msg_count,

Line 2386: p_validate_only => FND_API.G_FALSE ,

2382: p_enable_auto_cand_nom_flag => l_enable_auto_cand_nom_flag,
2383: p_staffing_owner_person_id => l_staffing_owner_person_id,
2384: p_staffing_owner_name => l_staffing_owner_name,
2385: p_commit => FND_API.G_TRUE ,
2386: p_validate_only => FND_API.G_FALSE ,
2387: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2388: x_return_status => l_return_status,
2389: x_msg_count => l_msg_count,
2390: x_msg_data => l_msg_data);

Line 2403: p_commit => FND_API.G_TRUE ,

2399: p_competence_name_tbl => l_competence_name_tbl,
2400: p_competence_alias_tbl => l_competence_alias_tbl,
2401: p_rating_level_id_tbl => l_rating_level_id_tbl,
2402: p_mandatory_flag_tbl => l_mandatory_flag_tbl,
2403: p_commit => FND_API.G_TRUE ,
2404: p_validate_only => FND_API.G_FALSE ,
2405: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2406: x_return_status => l_return_status,
2407: x_msg_count => l_msg_count,

Line 2404: p_validate_only => FND_API.G_FALSE ,

2400: p_competence_alias_tbl => l_competence_alias_tbl,
2401: p_rating_level_id_tbl => l_rating_level_id_tbl,
2402: p_mandatory_flag_tbl => l_mandatory_flag_tbl,
2403: p_commit => FND_API.G_TRUE ,
2404: p_validate_only => FND_API.G_FALSE ,
2405: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2406: x_return_status => l_return_status,
2407: x_msg_count => l_msg_count,
2408: x_msg_data => l_msg_data);

Line 2430: p_commit => FND_API.G_TRUE ,

2426: p_fcst_job_name => l_fcst_job_name ,
2427: p_fcst_job_group_name => l_fcst_job_group_name ,
2428: p_expenditure_org_name => l_expenditure_org_name ,
2429: p_exp_organization_name => l_exp_organization_name ,
2430: p_commit => FND_API.G_TRUE ,
2431: p_validate_only => FND_API.G_FALSE ,
2432: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2433: x_return_status => l_return_status,
2434: x_msg_count => l_msg_count,

Line 2431: p_validate_only => FND_API.G_FALSE ,

2427: p_fcst_job_group_name => l_fcst_job_group_name ,
2428: p_expenditure_org_name => l_expenditure_org_name ,
2429: p_exp_organization_name => l_exp_organization_name ,
2430: p_commit => FND_API.G_TRUE ,
2431: p_validate_only => FND_API.G_FALSE ,
2432: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2433: x_return_status => l_return_status,
2434: x_msg_count => l_msg_count,
2435: x_msg_data => l_msg_data);

Line 2467: p_commit => FND_API.G_TRUE ,

2463: p_change_calendar_id => l_change_calendar_id ,
2464: p_duration_shift_type_code => l_duration_shift_type_code ,
2465: p_duration_shift_unit_code => l_duration_shift_unit_code ,
2466: p_number_of_shift => l_num_of_shift ,
2467: p_commit => FND_API.G_TRUE ,
2468: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2469: x_return_status => l_return_status,
2470: x_msg_count => l_msg_count,
2471: x_msg_data => l_msg_data);

Line 2478: IF (l_assignment_type IS NULL OR l_assignment_type = FND_API.G_MISS_CHAR) THEN

2474:
2475: --set the mass_wf_in_progress_flag to 'N' if the assignments will not be submitted
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;

Line 2532: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)

2528: -- Get the project_id from project_number and return the project_id
2529: -- This handles the case when user performs Mass Assignment Creation
2530: -- (Add Delivery/Admin Assignment) by entering the project number
2531: -- without using the LOV
2532: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2533: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2534:
2535: select project_id into l_project_id
2536: from pa_projects_all

Line 2533: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN

2529: -- This handles the case when user performs Mass Assignment Creation
2530: -- (Add Delivery/Admin Assignment) by entering the project number
2531: -- without using the LOV
2532: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2533: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2534:
2535: select project_id into l_project_id
2536: from pa_projects_all
2537: where segment1 = l_project_number;

Line 3001: p_commit => FND_API.G_FALSE,

2997: p_source_identifier2 => l_error_item_key,
2998: p_context1 => l_project_id,
2999: p_context2 => l_assignment_id,
3000: p_context3 => l_resource_id,
3001: p_commit => FND_API.G_FALSE,
3002: x_return_status => l_return_status);
3003:
3004: END LOOP;
3005: