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 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

1020: --in the notification even if none of the updates were successful - so get the
1021: --first assignment id and use it to get the project id.
1022: --l_success_assignment_id_tbl only has successful assignments
1023:
1024: IF l_project_id IS NULL or l_project_id = FND_API.G_MISS_NUM THEN
1025:
1026: SELECT project_id
1027: INTO l_project_id
1028: FROM pa_project_assignments

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

1397: aname => 'ASSIGNMENT_NAME');
1398:
1399: --if the attribute has been updated then
1400: --append to x_document to display the Updated Information region in the wf notification
1401: IF l_assignment_name <> FND_API.G_MISS_CHAR AND l_assignment_name IS NOT NULL THEN
1402: x_document := x_document||get_translated_attr_name('ASSIGNMENT_NAME')||' - '||l_assignment_name||'
';
1403: END IF;
1404:
1405: l_wf_assignment_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1436:
1437: --if the attribute has been updated then
1438: --append to x_document to display the Updated Information region in the wf notification
1439: --get the name as we will only have the code as the field is a poplist on the page
1440: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN
1441: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN
1442: SELECT meaning INTO l_staffing_priority_name
1443: FROM pa_lookups
1444: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'

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

1437: --if the attribute has been updated then
1438: --append to x_document to display the Updated Information region in the wf notification
1439: --get the name as we will only have the code as the field is a poplist on the page
1440: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN
1441: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN
1442: SELECT meaning INTO l_staffing_priority_name
1443: FROM pa_lookups
1444: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
1445: AND lookup_code = l_staffing_priority_code;

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

1469:
1470: --if the attribute has been updated then
1471: --append to x_document to display the Updated Information region in the wf notification
1472: --get the name as we will only have the code as the field is a poplist on the page
1473: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN
1474: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN
1475: SELECT name INTO l_project_subteam_name
1476: FROM pa_project_subteams
1477: WHERE project_subteam_id = l_project_subteam_id;

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

1470: --if the attribute has been updated then
1471: --append to x_document to display the Updated Information region in the wf notification
1472: --get the name as we will only have the code as the field is a poplist on the page
1473: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN
1474: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN
1475: SELECT name INTO l_project_subteam_name
1476: FROM pa_project_subteams
1477: WHERE project_subteam_id = l_project_subteam_id;
1478: END IF;

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

1486:
1487: --if the attribute has been updated then
1488: --append to x_document to display the Updated Information region in the wf notification
1489: --get the meaning as we will not have it as the field is a poplist on the page
1490: IF l_extension_possible <> FND_API.G_MISS_CHAR AND l_extension_possible IS NOT NULL THEN
1491: SELECT meaning INTO l_extension_possible_meaning
1492: FROM fnd_lookups
1493: WHERE lookup_type='YES_NO'
1494: AND lookup_code = l_extension_possible;

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

1500: aname => 'MIN_RESOURCE_JOB_LEVEL');
1501:
1502: --if the attribute has been updated then
1503: --append to x_document to display the Updated Information region in the wf notification
1504: IF l_min_resource_job_level <> FND_API.G_MISS_NUM AND l_min_resource_job_level IS NOT NULL THEN
1505: x_document := x_document||get_translated_attr_name('MIN_RESOURCE_JOB_LEVEL')||' - '||l_min_resource_job_level||'
';
1506: END IF;
1507:
1508: l_max_resource_job_level := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1510: aname => 'MAX_RESOURCE_JOB_LEVEL');
1511:
1512: --if the attribute has been updated then
1513: --append to x_document to display the Updated Information region in the wf notification
1514: IF l_max_resource_job_level <> FND_API.G_MISS_NUM AND l_max_resource_job_level IS NOT NULL THEN
1515: x_document := x_document||get_translated_attr_name('MAX_RESOURCE_JOB_LEVEL')||' - '||l_max_resource_job_level||'
';
1516: END IF;
1517:
1518: -- FP.L Development

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

1525: aname => 'STAFFING_OWNER_NAME');
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: IF l_staffing_owner_name <> FND_API.G_MISS_CHAR AND l_staffing_owner_name IS NOT NULL THEN
1530: x_document := x_document||get_translated_attr_name('STAFFING_OWNER')||' - '||l_staffing_owner_name||'
';
1531: END IF;
1532:
1533: l_description := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1535: aname => 'DESCRIPTION');
1536:
1537: --if the attribute has been updated then
1538: --append to x_document to display the Updated Information region in the wf notification
1539: IF l_description <> FND_API.G_MISS_CHAR AND l_description IS NOT NULL THEN
1540: x_document := x_document||get_translated_attr_name('DESCRIPTION')||' - '||l_description||'
';
1541: END IF;
1542:
1543: l_append_description_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1549: aname => 'ADDITIONAL_INFORMATION');
1550:
1551: --if the attribute has been updated then
1552: --append to x_document to display the Updated Information region in the wf notification
1553: IF l_additional_information <> FND_API.G_MISS_CHAR AND l_additional_information IS NOT NULL THEN
1554: x_document := x_document||get_translated_attr_name('ADDITIONAL_INFORMATION')||' - '||l_additional_information||'
';
1555: END IF;
1556:
1557: l_append_information_flag := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1564: x_start_date := l_start_date;
1565:
1566: --if the attribute has been updated then
1567: --append to x_document to display the Updated Information region in the wf notification
1568: IF l_start_date <> FND_API.G_MISS_DATE AND l_start_date IS NOT NULL THEN
1569: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_start_date||'
';
1570: END IF;
1571:
1572: l_end_date := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

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

1576: x_end_date := l_end_date;
1577:
1578: --if the attribute has been updated then
1579: --append to x_document to display the Updated Information region in the wf notification
1580: IF l_end_date <> FND_API.G_MISS_DATE AND l_end_date IS NOT NULL THEN
1581: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_end_date||'
';
1582: END IF;
1583:
1584: l_location_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

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

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

1600: aname => 'LOCATION_REGION');
1601:
1602: --if the attribute has been updated then
1603: --append to x_document to display the Updated Information region in the wf notification
1604: IF l_location_region <> FND_API.G_MISS_CHAR AND l_location_region IS NOT NULL THEN
1605: x_document := x_document||get_translated_attr_name('LOCATION_REGION')||' - '||l_location_region||'
';
1606: END IF;
1607:
1608: l_location_country_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1610: aname => 'LOCATION_COUNTRY_NAME');
1611:
1612: --if the attribute has been updated then
1613: --append to x_document to display the Updated Information region in the wf notification
1614: IF l_location_country_name <> FND_API.G_MISS_CHAR AND l_location_country_name IS NOT NULL THEN
1615: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_location_country_name||'
';
1616: END IF;
1617:
1618: l_location_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1649:
1650: --if the attribute has been updated then
1651: --append to x_document to display the Updated Information region in the wf notification
1652: --get the meaning as we will not have it as the field is a poplist on the page
1653: IF l_expense_owner <> FND_API.G_MISS_CHAR AND l_expense_owner IS NOT NULL THEN
1654: SELECT meaning INTO l_expense_owner_meaning
1655: FROM pa_lookups
1656: WHERE lookup_type = 'EXPENSE_OWNER_TYPE'
1657: AND lookup_code = l_expense_owner;

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

1663: aname => 'EXPENSE_LIMIT');
1664:
1665: --if the attribute has been updated then
1666: --append to x_document to display the Updated Information region in the wf notification
1667: IF l_expense_limit <> FND_API.G_MISS_NUM AND l_expense_limit IS NOT NULL THEN
1668: x_document := x_document||get_translated_attr_name('EXPENSE_LIMIT')||' - '||l_expense_limit||'
';
1669: END IF;
1670:
1671: l_expense_limit_currency_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1677: aname => 'COMP_MATCH_WEIGHTING');
1678:
1679: --if the attribute has been updated then
1680: --append to x_document to display the Updated Information region in the wf notification
1681: IF l_comp_match_weighting <> FND_API.G_MISS_NUM AND l_comp_match_weighting IS NOT NULL THEN
1682: x_document := x_document||get_translated_attr_name('COMP_MATCH_WEIGHTING')||' - '||l_comp_match_weighting||'
';
1683: END IF;
1684:
1685: l_avail_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1687: aname => 'AVAIL_MATCH_WEIGHTING');
1688:
1689: --if the attribute has been updated then
1690: --append to x_document to display the Updated Information region in the wf notification
1691: IF l_avail_match_weighting <> FND_API.G_MISS_NUM AND l_avail_match_weighting IS NOT NULL THEN
1692: x_document := x_document||get_translated_attr_name('AVAIL_MATCH_WEIGHTING')||' - '||l_avail_match_weighting||'
';
1693: END IF;
1694:
1695: l_job_level_match_weighting := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1697: aname => 'JOB_LEVEL_MATCH_WEIGHTING');
1698:
1699: --if the attribute has been updated then
1700: --append to x_document to display the Updated Information region in the wf notification
1701: IF l_job_level_match_weighting <> FND_API.G_MISS_NUM AND l_job_level_match_weighting IS NOT NULL THEN
1702: x_document := x_document||get_translated_attr_name('JOB_LEVEL_MATCH_WEIGHTING')||' - '||l_job_level_match_weighting||'
';
1703: END IF;
1704:
1705: l_search_min_availability := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1707: aname => 'SEARCH_MIN_AVAILABILITY');
1708:
1709: --if the attribute has been updated then
1710: --append to x_document to display the Updated Information region in the wf notification
1711: IF l_search_min_availability <> FND_API.G_MISS_NUM AND l_search_min_availability IS NOT NULL THEN
1712: x_document := x_document||get_translated_attr_name('SEARCH_MIN_AVAILABILITY')||' - '||l_search_min_availability||'
';
1713: END IF;
1714:
1715: l_search_country_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1721: aname => 'SEARCH_COUNTRY_NAME');
1722:
1723: --if the attribute has been updated then
1724: --append to x_document to display the Updated Information region in the wf notification
1725: IF l_search_country_name <> FND_API.G_MISS_CHAR AND l_search_country_name IS NOT NULL THEN
1726: x_document := x_document||get_translated_attr_name('LOCATION_COUNTRY_NAME')||' - '||l_search_country_name||'
';
1727: END IF;
1728:
1729: l_search_exp_org_struct_ver_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

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

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

1749: aname => 'SEARCH_EXP_START_ORG_NAME');
1750:
1751: --if the attribute has been updated then
1752: --append to x_document to display the Updated Information region in the wf notification
1753: IF l_search_exp_start_org_name <> FND_API.G_MISS_CHAR AND l_search_exp_start_org_name IS NOT NULL THEN
1754: x_document := x_document||get_translated_attr_name('SEARCH_EXP_START_ORG_NAME')||' - '||l_search_exp_start_org_name||'
';
1755: END IF;
1756:
1757: l_search_min_candidate_score := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1759: aname => 'SEARCH_MIN_CANDIDATE_SCORE');
1760:
1761: --if the attribute has been updated then
1762: --append to x_document to display the Updated Information region in the wf notification
1763: IF l_search_min_candidate_score <> FND_API.G_MISS_NUM AND l_search_min_candidate_score IS NOT NULL THEN
1764: x_document := x_document||get_translated_attr_name('SEARCH_MIN_CANDIDATE_SCORE')||' - '||l_search_min_candidate_score||'
';
1765: END IF;
1766:
1767: L_ENABLE_AUTO_CAND_NOM_FLAG := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1769: aname => 'ENABLE_AUTO_CAND_NOM_FLAG');
1770:
1771: --if the attribute has been updated then
1772: --append to x_document to display the Updated Information region in the wf notification
1773: IF L_ENABLE_AUTO_CAND_NOM_FLAG <> FND_API.G_MISS_CHAR AND L_ENABLE_AUTO_CAND_NOM_FLAG IS NOT NULL THEN
1774: SELECT meaning INTO L_ENABLE_AUTO_CAND_NOM_MEANING
1775: FROM fnd_lookups
1776: WHERE lookup_type='YES_NO'
1777: AND lookup_code = L_ENABLE_AUTO_CAND_NOM_FLAG;

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

1790:
1791: --if the attribute has been updated then
1792: --append to x_document to display the Updated Information region in the wf notification
1793: --get the name as we will not have it as the field is a poplist on the page
1794: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN
1795: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN
1796: SELECT name INTO l_work_type_name
1797: FROM pa_work_types_vl
1798: WHERE work_type_id = l_work_type_id;

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

1791: --if the attribute has been updated then
1792: --append to x_document to display the Updated Information region in the wf notification
1793: --get the name as we will not have it as the field is a poplist on the page
1794: IF l_work_type_id <> FND_API.G_MISS_NUM AND l_work_type_id IS NOT NULL THEN
1795: IF l_work_type_name = FND_API.G_MISS_CHAR OR l_work_type_name IS NULL THEN
1796: SELECT name INTO l_work_type_name
1797: FROM pa_work_types_vl
1798: WHERE work_type_id = l_work_type_id;
1799: END IF;

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

1806:
1807: --if the attribute has been updated then
1808: --append to x_document to display the Updated Information region in the wf notification
1809: --get the meaning as we will not have it as the field is a poplist on the page
1810: IF l_fcst_tp_amount_type <> FND_API.G_MISS_CHAR AND l_fcst_tp_amount_type IS NOT NULL THEN
1811: SELECT meaning INTO l_fcst_tp_amount_type_meaning
1812: FROM pa_lookups
1813: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1814: AND lookup_code = l_fcst_tp_amount_type;

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

1824: aname => 'FCST_JOB_NAME');
1825:
1826: --if the attribute has been updated then
1827: --append to x_document to display the Updated Information region in the wf notification
1828: IF l_fcst_job_name <> FND_API.G_MISS_CHAR AND l_fcst_job_name IS NOT NULL THEN
1829: x_document := x_document||get_translated_attr_name('FCST_JOB_NAME')||' - '||l_fcst_job_name||'
';
1830: END IF;
1831:
1832: l_fcst_job_group_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1838: aname => 'FCST_JOB_GROUP_NAME');
1839:
1840: --if the attribute has been updated then
1841: --append to x_document to display the Updated Information region in the wf notification
1842: IF l_fcst_job_group_name <> FND_API.G_MISS_CHAR AND l_fcst_job_group_name IS NOT NULL THEN
1843: x_document := x_document||get_translated_attr_name('FCST_JOB_GROUP_NAME')||' - '||l_fcst_job_group_name||'
';
1844: END IF;
1845:
1846: l_expenditure_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1852: aname => 'EXPENDITURE_ORG_NAME');
1853:
1854: --if the attribute has been updated then
1855: --append to x_document to display the Updated Information region in the wf notification
1856: IF l_expenditure_org_name <> FND_API.G_MISS_CHAR AND l_expenditure_org_name IS NOT NULL THEN
1857: x_document := x_document||get_translated_attr_name('EXPENDITURE_ORG_NAME')||' - '||l_expenditure_org_name||'
';
1858: END IF;
1859:
1860: l_expenditure_organization_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1866: aname => 'EXP_ORGANIZATION_NAME');
1867:
1868: --if the attribute has been updated then
1869: --append to x_document to display the Updated Information region in the wf notification
1870: IF l_exp_organization_name <> FND_API.G_MISS_CHAR AND l_exp_organization_name IS NOT NULL THEN
1871: x_document := x_document||get_translated_attr_name('EXP_ORGANIZATION_NAME')||' - '||l_exp_organization_name||'
';
1872: END IF;
1873:
1874: l_expenditure_type_class := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

1880: aname => 'EXPENDITURE_TYPE');
1881:
1882: --if the attribute has been updated then
1883: --append to x_document to display the Updated Information region in the wf notification
1884: IF l_expenditure_type <> FND_API.G_MISS_CHAR AND l_expenditure_type IS NOT NULL THEN
1885: x_document := x_document||get_translated_attr_name('EXPENDITURE_TYPE')||' - '||l_expenditure_type||'
';
1886: END IF;
1887:
1888:

Line 1903: IF l_change_start_date <> FND_API.G_MISS_DATE THEN

1899:
1900: IF l_exception_type_code = 'CHANGE_DURATION' THEN
1901: --if the attribute has been updated then
1902: --append to x_document to display the Updated Information region in the wf notification
1903: IF l_change_start_date <> FND_API.G_MISS_DATE THEN
1904: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date||'
';
1905: END IF;
1906: END IF;
1907:

Line 1915: IF l_change_end_date <> FND_API.G_MISS_DATE THEN

1911:
1912: IF l_exception_type_code = 'CHANGE_DURATION' THEN
1913: --if the attribute has been updated then
1914: --append to x_document to display the Updated Information region in the wf notification
1915: IF l_change_end_date <> FND_API.G_MISS_DATE THEN
1916: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date||'
';
1917: END IF;
1918: END IF;
1919:

Line 1924: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN

1920: l_change_rqmt_status_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
1921: itemkey => p_item_key,
1922: aname => 'CHANGE_RQMT_STATUS_CODE');
1923:
1924: IF l_change_rqmt_status_code <> FND_API.G_MISS_CHAR THEN
1925:
1926: SELECT project_status_name INTO l_project_status_name
1927: FROM pa_project_statuses
1928: WHERE project_status_code = l_change_rqmt_status_code

Line 1942: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN

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: --get the name as we will only have the code as the field is a poplist on the page
1942: IF l_change_asgmt_status_code <> FND_API.G_MISS_CHAR THEN
1943: SELECT project_status_name INTO l_project_status_name
1944: FROM pa_project_statuses
1945: WHERE project_status_code = l_change_asgmt_status_code
1946: AND status_type='STAFFED_ASGMT' ;

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

1970: aname => 'CHANGE_START_DATE'||j);
1971:
1972: --if the attribute has been updated then
1973: --append to x_document to display the Updated Information region in the wf notification
1974: IF l_change_start_date_tbl(j) <> FND_API.G_MISS_DATE THEN
1975: x_document := x_document||get_translated_attr_name('START_DATE')||' - '||l_change_start_date_tbl(j)||'
';
1976: END IF;
1977:
1978: l_change_end_date_tbl(j) := WF_ENGINE.GetItemAttrDate(itemtype => p_item_type,

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

1980: aname => 'CHANGE_END_DATE'||j);
1981:
1982: --if the attribute has been updated then
1983: --append to x_document to display the Updated Information region in the wf notification
1984: IF l_change_end_date_tbl(j) <> FND_API.G_MISS_DATE THEN
1985: x_document := x_document||get_translated_attr_name('END_DATE')||' - '||l_change_end_date_tbl(j)||'
';
1986: END IF;
1987:
1988: l_monday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

1990: aname => 'MONDAY_HOURS'||j);
1991:
1992: --if the attribute has been updated then
1993: --append to x_document to display the Updated Information region in the wf notification
1994: IF l_monday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_monday_hours_tbl(j) IS NOT NULL THEN
1995: x_document := x_document||get_translated_attr_name('MONDAY_HOURS')||' - '||l_monday_hours_tbl(j)||'
';
1996: END IF;
1997:
1998: l_tuesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2000: aname => 'TUESDAY_HOURS'||j);
2001:
2002: --if the attribute has been updated then
2003: --append to x_document to display the Updated Information region in the wf notification
2004: IF l_tuesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_tuesday_hours_tbl(j) IS NOT NULL THEN
2005: x_document := x_document||get_translated_attr_name('TUESDAY_HOURS')||' - '||l_tuesday_hours_tbl(j)||'
';
2006: END IF;
2007:
2008: l_wednesday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2010: aname => 'WEDNESDAY_HOURS'||j);
2011:
2012: --if the attribute has been updated then
2013: --append to x_document to display the Updated Information region in the wf notification
2014: IF l_wednesday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_wednesday_hours_tbl(j) IS NOT NULL THEN
2015: x_document := x_document||get_translated_attr_name('WEDNESDAY_HOURS')||' - '||l_wednesday_hours_tbl(j)||'
';
2016: END IF;
2017:
2018: l_thursday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2020: aname => 'THURSDAY_HOURS'||j);
2021:
2022: --if the attribute has been updated then
2023: --append to x_document to display the Updated Information region in the wf notification
2024: IF l_thursday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_thursday_hours_tbl(j) IS NOT NULL THEN
2025: x_document := x_document||get_translated_attr_name('THURSDAY_HOURS')||' - '||l_thursday_hours_tbl(j)||'
';
2026: END IF;
2027:
2028: l_friday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2030: aname => 'FRIDAY_HOURS'||j);
2031:
2032: --if the attribute has been updated then
2033: --append to x_document to display the Updated Information region in the wf notification
2034: IF l_friday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_friday_hours_tbl(j) IS NOT NULL THEN
2035: x_document := x_document||get_translated_attr_name('FRIDAY_HOURS')||' - '||l_friday_hours_tbl(j)||'
';
2036: END IF;
2037:
2038: l_saturday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2040: aname => 'SATURDAY_HOURS'||j);
2041:
2042: --if the attribute has been updated then
2043: --append to x_document to display the Updated Information region in the wf notification
2044: IF l_saturday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_saturday_hours_tbl(j) IS NOT NULL THEN
2045: x_document := x_document||get_translated_attr_name('SATURDAY_HOURS')||' - '||l_saturday_hours_tbl(j)||'
';
2046: END IF;
2047:
2048: l_sunday_hours_tbl(j) := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2050: aname => 'SUNDAY_HOURS'||j);
2051:
2052: --if the attribute has been updated then
2053: --append to x_document to display the Updated Information region in the wf notification
2054: IF l_sunday_hours_tbl(j) <> FND_API.G_MISS_NUM AND l_sunday_hours_tbl(j) IS NOT NULL THEN
2055: x_document := x_document||get_translated_attr_name('SUNDAY_HOURS')||' - '||l_sunday_hours_tbl(j)||'
';
2056: END IF;
2057:
2058: END LOOP;

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

2071: aname => 'HRS_PER_DAY');
2072:
2073: --if the attribute has been updated then
2074: --append to x_document to display the Updated Information region in the wf notification
2075: IF l_hrs_per_day <> FND_API.G_MISS_NUM AND l_hrs_per_day IS NOT NULL THEN
2076: x_document := x_document||get_translated_attr_name('HRS_PER_DAY')||' - '||l_hrs_per_day||'
';
2077: END IF;
2078:
2079: l_change_calendar_type_code := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,

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

2083: l_change_calendar_name := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
2084: itemkey => p_item_key,
2085: aname => 'CHANGE_CALENDAR_NAME');
2086:
2087: IF l_change_calendar_name <> FND_API.G_MISS_CHAR and l_change_calendar_name IS NOT NULL THEN
2088: l_calendar_display := ': '||l_change_calendar_name;
2089: END IF;
2090:
2091: l_change_calendar_id := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,

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

2097: aname => 'CALENDAR_PERCENT');
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_calendar_percent <> FND_API.G_MISS_NUM AND l_calendar_percent IS NOT NULL THEN
2102: 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||'
';
2103: END IF;
2104:
2105:

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

2114: l_num_of_shift := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2115: itemkey => p_item_key,
2116: aname => 'NUM_OF_SHIFT');
2117:
2118: IF l_num_of_shift <> FND_API.G_MISS_NUM AND l_num_of_shift IS NOT NULL THEN
2119: 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)||'
';
2120: END IF;
2121:
2122: ELSIF l_mode = G_MASS_UPDATE_COMPETENCIES THEN

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

2152: aname => 'RATING_LEVEL_ID'||i);
2153:
2154: --if rating level id is not null then get the actual rating level
2155: --in order to display on the wf notification.
2156: IF l_rating_level_id_tbl(i) <> FND_API.G_MISS_NUM AND l_rating_level_id_tbl(i) IS NOT NULL THEN
2157: SELECT step_value INTO l_rating_level
2158: FROM per_rating_levels_v
2159: WHERE rating_level_id = l_rating_level_id_tbl(i);
2160: END IF;

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

2164: aname => 'MANDATORY_FLAG'||i);
2165:
2166: --if mandatory_flag is not null then get the meaning
2167: --in order to display on the wf notification.
2168: IF l_mandatory_flag_tbl(i) <> FND_API.G_MISS_CHAR AND l_mandatory_flag_tbl(i) IS NOT NULL THEN
2169: SELECT meaning INTO l_mandatory_flag_meaning
2170: FROM fnd_lookups
2171: WHERE lookup_type = 'YES_NO'
2172: AND lookup_code = l_mandatory_flag_tbl(i);

Line 2250: p_init_msg_list => FND_API.G_TRUE ,

2246: p_location_country_name => l_location_country_name ,
2247: p_location_country_code => l_location_country_code ,
2248: p_calendar_name => l_calendar_name ,
2249: p_work_type_name => l_work_type_name ,
2250: p_init_msg_list => FND_API.G_TRUE ,
2251: p_commit => FND_API.G_TRUE ,
2252: p_validate_only => FND_API.G_FALSE ,
2253: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2254: x_return_status => l_return_status,

Line 2251: p_commit => FND_API.G_TRUE ,

2247: p_location_country_code => l_location_country_code ,
2248: p_calendar_name => l_calendar_name ,
2249: p_work_type_name => l_work_type_name ,
2250: p_init_msg_list => FND_API.G_TRUE ,
2251: p_commit => FND_API.G_TRUE ,
2252: p_validate_only => FND_API.G_FALSE ,
2253: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2254: x_return_status => l_return_status,
2255: x_msg_count => l_msg_count,

Line 2252: p_validate_only => FND_API.G_FALSE ,

2248: p_calendar_name => l_calendar_name ,
2249: p_work_type_name => l_work_type_name ,
2250: p_init_msg_list => FND_API.G_TRUE ,
2251: p_commit => FND_API.G_TRUE ,
2252: p_validate_only => FND_API.G_FALSE ,
2253: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2254: x_return_status => l_return_status,
2255: x_msg_count => l_msg_count,
2256: x_msg_data => l_msg_data

Line 2328: p_commit => FND_API.G_TRUE ,

2324: p_search_min_candidate_score => l_search_min_candidate_score,
2325: p_enable_auto_cand_nom_flag => l_enable_auto_cand_nom_flag,
2326: p_staffing_owner_person_id => l_staffing_owner_person_id,
2327: p_staffing_owner_name => l_staffing_owner_name,
2328: p_commit => FND_API.G_TRUE ,
2329: p_validate_only => FND_API.G_FALSE ,
2330: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2331: x_return_status => l_return_status,
2332: x_msg_count => l_msg_count,

Line 2329: p_validate_only => FND_API.G_FALSE ,

2325: p_enable_auto_cand_nom_flag => l_enable_auto_cand_nom_flag,
2326: p_staffing_owner_person_id => l_staffing_owner_person_id,
2327: p_staffing_owner_name => l_staffing_owner_name,
2328: p_commit => FND_API.G_TRUE ,
2329: p_validate_only => FND_API.G_FALSE ,
2330: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2331: x_return_status => l_return_status,
2332: x_msg_count => l_msg_count,
2333: x_msg_data => l_msg_data);

Line 2346: p_commit => FND_API.G_TRUE ,

2342: p_competence_name_tbl => l_competence_name_tbl,
2343: p_competence_alias_tbl => l_competence_alias_tbl,
2344: p_rating_level_id_tbl => l_rating_level_id_tbl,
2345: p_mandatory_flag_tbl => l_mandatory_flag_tbl,
2346: p_commit => FND_API.G_TRUE ,
2347: p_validate_only => FND_API.G_FALSE ,
2348: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2349: x_return_status => l_return_status,
2350: x_msg_count => l_msg_count,

Line 2347: p_validate_only => FND_API.G_FALSE ,

2343: p_competence_alias_tbl => l_competence_alias_tbl,
2344: p_rating_level_id_tbl => l_rating_level_id_tbl,
2345: p_mandatory_flag_tbl => l_mandatory_flag_tbl,
2346: p_commit => FND_API.G_TRUE ,
2347: p_validate_only => FND_API.G_FALSE ,
2348: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2349: x_return_status => l_return_status,
2350: x_msg_count => l_msg_count,
2351: x_msg_data => l_msg_data);

Line 2373: p_commit => FND_API.G_TRUE ,

2369: p_fcst_job_name => l_fcst_job_name ,
2370: p_fcst_job_group_name => l_fcst_job_group_name ,
2371: p_expenditure_org_name => l_expenditure_org_name ,
2372: p_exp_organization_name => l_exp_organization_name ,
2373: p_commit => FND_API.G_TRUE ,
2374: p_validate_only => FND_API.G_FALSE ,
2375: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2376: x_return_status => l_return_status,
2377: x_msg_count => l_msg_count,

Line 2374: p_validate_only => FND_API.G_FALSE ,

2370: p_fcst_job_group_name => l_fcst_job_group_name ,
2371: p_expenditure_org_name => l_expenditure_org_name ,
2372: p_exp_organization_name => l_exp_organization_name ,
2373: p_commit => FND_API.G_TRUE ,
2374: p_validate_only => FND_API.G_FALSE ,
2375: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2376: x_return_status => l_return_status,
2377: x_msg_count => l_msg_count,
2378: x_msg_data => l_msg_data);

Line 2410: p_commit => FND_API.G_TRUE ,

2406: p_change_calendar_id => l_change_calendar_id ,
2407: p_duration_shift_type_code => l_duration_shift_type_code ,
2408: p_duration_shift_unit_code => l_duration_shift_unit_code ,
2409: p_number_of_shift => l_num_of_shift ,
2410: p_commit => FND_API.G_TRUE ,
2411: x_success_assignment_id_tbl => l_success_assignment_id_tbl,
2412: x_return_status => l_return_status,
2413: x_msg_count => l_msg_count,
2414: x_msg_data => l_msg_data);

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

2417:
2418: --set the mass_wf_in_progress_flag to 'N' if the assignments will not be submitted
2419: --for approval and this is not a mass assignment. (If it is a mass assignment
2420: --not is not submitted then the flag will not already be set to 'Y'
2421: IF (l_assignment_type IS NULL OR l_assignment_type = FND_API.G_MISS_CHAR) THEN
2422: SELECT assignment_type INTO l_assignment_type
2423: FROM pa_project_assignments
2424: WHERE assignment_id = l_single_obj_id_tbl(1);
2425: END IF;

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

2471: -- Get the project_id from project_number and return the project_id
2472: -- This handles the case when user performs Mass Assignment Creation
2473: -- (Add Delivery/Admin Assignment) by entering the project number
2474: -- without using the LOV
2475: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2476: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2477:
2478: select project_id into l_project_id
2479: from pa_projects_all

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

2472: -- This handles the case when user performs Mass Assignment Creation
2473: -- (Add Delivery/Admin Assignment) by entering the project number
2474: -- without using the LOV
2475: IF l_mode = G_MASS_ASGMT AND (l_project_id IS NULL OR l_project_id = FND_API.G_MISS_NUM)
2476: AND l_project_number IS NOT NULL AND l_project_number <> FND_API.G_MISS_CHAR THEN
2477:
2478: select project_id into l_project_id
2479: from pa_projects_all
2480: where segment1 = l_project_number;

Line 2942: p_commit => FND_API.G_FALSE,

2938: p_source_identifier2 => l_error_item_key,
2939: p_context1 => l_project_id,
2940: p_context2 => l_assignment_id,
2941: p_context3 => l_resource_id,
2942: p_commit => FND_API.G_FALSE,
2943: x_return_status => l_return_status);
2944:
2945: END LOOP;
2946: