APPS.PA_ASSIGNMENTS_HISTORY_PKG dependencies on PA_ASSIGNMENTS_HISTORY

Line 1: PACKAGE BODY PA_ASSIGNMENTS_HISTORY_PKG AS

1: PACKAGE BODY PA_ASSIGNMENTS_HISTORY_PKG AS
2: /*$Header: PARAAPKB.pls 120.1 2005/08/19 16:47:02 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM

Line 5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM

1: PACKAGE BODY PA_ASSIGNMENTS_HISTORY_PKG AS
2: /*$Header: PARAAPKB.pls 120.1 2005/08/19 16:47:02 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

Line 6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR

2: /*$Header: PARAAPKB.pls 120.1 2005/08/19 16:47:02 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM

Line 7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM

3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

Line 8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR

4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

Line 9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM

6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM

Line 12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

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

9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM

Line 14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM

11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR

Line 17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM

13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR

Line 18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

Line 19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM

15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE

Line 20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR

16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR

17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE

19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM

Line 24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM

20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR

21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM

23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

Line 30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR

26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM

27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR

30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM

Line 35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM

31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

Line 36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

Line 37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

Line 38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM

34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM

Line 41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR

Line 42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR

39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

Line 44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM

40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR

41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

Line 46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM

42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR

Line 47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

Line 48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR

44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR

46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM

Line 54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM

51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR

52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE

Line 57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM

53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM

Line 60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE

56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

Line 61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM

Line 62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR

58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM

Line 63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM

59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

Line 64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

Line 65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM

61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

Line 66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM

62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM

Line 67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM

66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR

67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR

68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR

69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR

70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR

71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR

72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR

73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR

74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR

75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR

76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR

77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR

78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */

Line 83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR

79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM

Line 84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR

80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR

Line 85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR

81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */

Line 90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM

86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR

87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: )

Line 93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895

89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: )
96: IS
97:

Line 102: INSERT INTO pa_assignments_history

98: BEGIN
99:
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: INSERT INTO pa_assignments_history
103: (assignment_id,
104: assignment_name,
105: assignment_type,
106: multiple_status_flag,

Line 201: pa_assignments_history_s.NEXTVAL,

197: DECODE(p_assignment_name, FND_API.G_MISS_CHAR, NULL, p_assignment_name),
198: DECODE(p_assignment_type, FND_API.G_MISS_CHAR, NULL, p_assignment_type),
199: DECODE(p_multiple_status_flag, FND_API.G_MISS_CHAR, NULL, p_multiple_status_flag),
200: DECODE(p_record_version_number, FND_API.G_MISS_NUM, NULL, p_record_version_number),
201: pa_assignments_history_s.NEXTVAL,
202: DECODE(p_apprvl_status_code, FND_API.G_MISS_CHAR, NULL, p_apprvl_status_code),
203: DECODE(p_status_code, FND_API.G_MISS_CHAR, NULL, p_status_code),
204: DECODE(p_staffing_priority_code, FND_API.G_MISS_CHAR, NULL, p_staffing_priority_code),
205: DECODE(p_staffing_owner_person_id, FND_API.G_MISS_NUM, NULL, p_staffing_owner_person_id),

Line 294: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row'

290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: -- Set the exception Message and the stack
294: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row'
295: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: RAISE;
298: END Insert_Row;

Line 303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE

299:
300:
301: PROCEDURE Update_Row
302: ( p_assignment_row_id IN ROWID :=NULL
303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR

Line 304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL

300:
301: PROCEDURE Update_Row
302: ( p_assignment_row_id IN ROWID :=NULL
303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR

Line 305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL

301: PROCEDURE Update_Row
302: ( p_assignment_row_id IN ROWID :=NULL
303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

Line 306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM

302: ( p_assignment_row_id IN ROWID :=NULL
303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

Line 307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR

303: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

Line 308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR

304: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

305: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

306: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM

Line 311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR

307: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

308: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

309: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM

310: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR

Line 315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM

311: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR

Line 316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM

312: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

Line 317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM

313: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE

Line 318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR

314: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR

315: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE

316: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

Line 321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE

317: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM

Line 322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM

318: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR

319: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM

320: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM

Line 325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM

321: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

322: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

323: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM

324: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

Line 329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR

325: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM

326: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

327: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

328: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR

329: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM

Line 334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM

330: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

Line 335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

331: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

Line 336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

332: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

Line 337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM

333: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

334: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

335: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM

Line 340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

336: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR

Line 341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

337: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM

Line 342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR

338: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

Line 343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM

339: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

Line 344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR

340: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

Line 345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM

341: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

342: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

343: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

344: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR

345: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR

346: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR

347: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR

348: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR

349: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR

350: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR

351: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR

352: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR

353: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR

354: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR

355: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR

356: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR

357: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
365: /* Added 2 columns for 3051110 */

Line 362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR

358: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
365: /* Added 2 columns for 3051110 */
366: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM

Line 363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR

359: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
365: /* Added 2 columns for 3051110 */
366: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
367: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR

Line 364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR

360: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
361: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
362: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
363: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
364: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
365: /* Added 2 columns for 3051110 */
366: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
367: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
368: /* Added 2 columns for 3041583 */

Line 369: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM

365: /* Added 2 columns for 3051110 */
366: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
367: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
368: /* Added 2 columns for 3041583 */
369: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
370: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
371: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
372: )IS
373:

Line 370: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR

366: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
367: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
368: /* Added 2 columns for 3041583 */
369: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
370: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
371: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
372: )IS
373:
374:

Line 380: FROM pa_assignments_history

376:
377:
378: CURSOR get_row_id IS
379: SELECT rowid
380: FROM pa_assignments_history
381: WHERE assignment_id = p_assignment_id
382: AND last_approved_flag = nvl(p_last_approved_flag, last_approved_flag)
383: AND change_id = nvl(p_change_id, change_id);
384:

Line 392: FROM pa_assignments_history

388:
389: /*
390: -- Lock the row first
391: SELECT rowid INTO l_row_id
392: FROM pa_assignments_history
393: WHERE assignment_id = p_assignment_id
394: OR rowid = p_assignment_row_id
395: FOR UPDATE NOWAIT;
396: */

Line 413: UPDATE pa_assignments_history

409:
410: END IF;
411:
412:
413: UPDATE pa_assignments_history
414: SET assignment_name = DECODE(p_assignment_name, FND_API.G_MISS_CHAR, assignment_name, p_assignment_name),
415: assignment_type = DECODE(p_assignment_type, FND_API.G_MISS_CHAR, assignment_type, p_assignment_type),
416: change_id = DECODE(p_change_id, NULL, change_id, p_change_id),
417: last_approved_flag = DECODE(p_last_approved_flag,NULL, last_approved_flag, p_last_approved_flag),

Line 496: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Update_Row'

492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- Set the exception Message and the stack
496: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Update_Row'
497: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
499: RAISE;
500: END Update_Row;

Line 505: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE

501:
502:
503: PROCEDURE Delete_Row
504: ( p_assignment_row_id IN ROWID :=NULL
505: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
506: ,p_change_id IN pa_assignments_history.change_id%TYPE := NULL
507: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := NULL
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: )

Line 506: ,p_change_id IN pa_assignments_history.change_id%TYPE := NULL

502:
503: PROCEDURE Delete_Row
504: ( p_assignment_row_id IN ROWID :=NULL
505: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
506: ,p_change_id IN pa_assignments_history.change_id%TYPE := NULL
507: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := NULL
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: )
510: IS

Line 507: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := NULL

503: PROCEDURE Delete_Row
504: ( p_assignment_row_id IN ROWID :=NULL
505: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
506: ,p_change_id IN pa_assignments_history.change_id%TYPE := NULL
507: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := NULL
508: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
509: )
510: IS
511:

Line 522: FROM pa_assignments_history

518:
519: /*
520: -- Lock the Assignment;
521: SELECT rowid INTO l_row_id
522: FROM pa_assignments_history
523: WHERE assignment_id = p_assignment_id
524: FOR UPDATE NOWAIT;
525: */
526: DELETE FROM pa_assignments_history

Line 526: DELETE FROM pa_assignments_history

522: FROM pa_assignments_history
523: WHERE assignment_id = p_assignment_id
524: FOR UPDATE NOWAIT;
525: */
526: DELETE FROM pa_assignments_history
527: WHERE assignment_id = p_assignment_id
528: AND nvl (p_last_approved_flag, last_approved_flag)=last_approved_flag
529: OR rowid = p_assignment_row_id
530: AND nvl(p_change_id, change_id) = change_id;

Line 546: -- PA_Error_Utils.Set_Error_Stack('PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row');

542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: -- Set the current program unit name in the error stack
546: -- PA_Error_Utils.Set_Error_Stack('PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row');
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row'

544: WHEN OTHERS THEN
545: -- Set the current program unit name in the error stack
546: -- PA_Error_Utils.Set_Error_Stack('PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row');
547: -- Set the exception Message and the stack
548: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row'
549: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551: RAISE;
552: END Delete_Row;

Line 557: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE

553:
554:
555:
556: PROCEDURE Delete_By_Assignment
557: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE
558: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
559: )
560: IS
561:

Line 569: FROM pa_assignments_history

565:
566: /*
567: -- Lock the Assignment;
568: SELECT rowid INTO l_row_id
569: FROM pa_assignments_history
570: WHERE assignment_id = p_assignment_id
571: FOR UPDATE NOWAIT;
572: */
573: DELETE FROM pa_assignments_history

Line 573: DELETE FROM pa_assignments_history

569: FROM pa_assignments_history
570: WHERE assignment_id = p_assignment_id
571: FOR UPDATE NOWAIT;
572: */
573: DELETE FROM pa_assignments_history
574: WHERE assignment_id = p_assignment_id;
575: --
576: /* IF (SQL%NOTFOUND) THEN
577:

Line 593: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_By_Assignment'

589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: -- Set the exception Message and the stack
593: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENTS_HISTORY_PKG.Delete_By_Assignment'
594: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
596: RAISE;
597: END Delete_By_Assignment;

Line 601: END PA_ASSIGNMENTS_HISTORY_PKG;

597: END Delete_By_Assignment;
598:
599: --
600: --
601: END PA_ASSIGNMENTS_HISTORY_PKG;