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

APPS.PA_PROJECT_ASSIGNMENTS_PKG dependencies on PA_PROJECT_ASSIGNMENTS

Line 1: PACKAGE BODY pa_project_assignments_pkg AS

1: PACKAGE BODY pa_project_assignments_pkg AS
2: /*$Header: PARAPKGB.pls 120.1 2005/08/19 16:47:19 mwasowic noship $*/
3: --
4:
5: PROCEDURE Insert_Row

Line 6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

2: /*$Header: PARAPKGB.pls 120.1 2005/08/19 16:47:19 mwasowic noship $*/
3: --
4:
5: PROCEDURE Insert_Row
6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

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

3: --
4:
5: PROCEDURE Insert_Row
6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

4:
5: PROCEDURE Insert_Row
6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

5: PROCEDURE Insert_Row
6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM

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

6: ( p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

7: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

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

8: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM

9: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

10: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR

Line 15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

11: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

12: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

13: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR

14: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

15: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

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

16: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

17: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

18: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

19: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

20: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

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

21: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

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

22: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM

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

23: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

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

24: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

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

25: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM

26: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
34: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

27: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
34: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
35: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

28: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
34: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
35: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
36: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

29: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
34: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
35: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
36: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
37: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

30: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
31: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
32: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
33: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
34: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
35: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
36: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
37: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
38: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

37: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
38: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
39: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
40: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

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

38: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
39: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
40: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

39: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
40: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

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

40: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

41: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

42: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

43: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

44: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

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

45: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

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

46: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

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

47: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

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

48: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

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

49: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

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

50: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development

Line 55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

51: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development

Line 56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

52: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM

Line 57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

53: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

Line 58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development

54: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development

55: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

Line 60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM

56: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development

Line 61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

57: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development

Line 62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

58: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- FP.L Development
59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

59: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- FP.L Development
60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR

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

60: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development

61: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR

62: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR

63: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

64: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM -- FP.L Development
65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

65: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR

66: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR

67: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR

68: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR

69: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR

70: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR

71: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR

72: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR

73: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR

74: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
82: /* Added 2 columns for 3051110 */

Line 79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR

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

Line 80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR

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

Line 81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR

77: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
82: /* Added 2 columns for 3051110 */
83: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
85: ,p_number_of_requirements IN NUMBER := 1

Line 83: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM

79: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
82: /* Added 2 columns for 3051110 */
83: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
85: ,p_number_of_requirements IN NUMBER := 1
86: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
87: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

Line 84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR

80: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
82: /* Added 2 columns for 3051110 */
83: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
85: ,p_number_of_requirements IN NUMBER := 1
86: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
87: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
88: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895

Line 87: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

83: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
85: ,p_number_of_requirements IN NUMBER := 1
86: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
87: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
88: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: )
91: IS

Line 88: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895

84: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
85: ,p_number_of_requirements IN NUMBER := 1
86: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
87: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
88: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: )
91: IS
92:

Line 93: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE

89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: )
91: IS
92:
93: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE
94: INDEX BY BINARY_INTEGER;
95: l_assignment_id assignment_id;
96: TYPE assignment_name IS TABLE OF pa_project_assignments.assignment_name%TYPE
97: INDEX BY BINARY_INTEGER;

Line 96: TYPE assignment_name IS TABLE OF pa_project_assignments.assignment_name%TYPE

92:
93: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE
94: INDEX BY BINARY_INTEGER;
95: l_assignment_id assignment_id;
96: TYPE assignment_name IS TABLE OF pa_project_assignments.assignment_name%TYPE
97: INDEX BY BINARY_INTEGER;
98: l_assignment_name assignment_name;
99: TYPE assignment_number IS TABLE OF pa_project_assignments.assignment_number%TYPE
100: INDEX BY BINARY_INTEGER;

Line 99: TYPE assignment_number IS TABLE OF pa_project_assignments.assignment_number%TYPE

95: l_assignment_id assignment_id;
96: TYPE assignment_name IS TABLE OF pa_project_assignments.assignment_name%TYPE
97: INDEX BY BINARY_INTEGER;
98: l_assignment_name assignment_name;
99: TYPE assignment_number IS TABLE OF pa_project_assignments.assignment_number%TYPE
100: INDEX BY BINARY_INTEGER;
101: l_assignment_number assignment_number;
102: TYPE assignment_type IS TABLE OF pa_project_assignments.assignment_type%TYPE
103: INDEX BY BINARY_INTEGER;

Line 102: TYPE assignment_type IS TABLE OF pa_project_assignments.assignment_type%TYPE

98: l_assignment_name assignment_name;
99: TYPE assignment_number IS TABLE OF pa_project_assignments.assignment_number%TYPE
100: INDEX BY BINARY_INTEGER;
101: l_assignment_number assignment_number;
102: TYPE assignment_type IS TABLE OF pa_project_assignments.assignment_type%TYPE
103: INDEX BY BINARY_INTEGER;
104: l_assignment_type assignment_type;
105: TYPE multiple_status_flag IS TABLE OF pa_project_assignments.multiple_status_flag%TYPE
106: INDEX BY BINARY_INTEGER;

Line 105: TYPE multiple_status_flag IS TABLE OF pa_project_assignments.multiple_status_flag%TYPE

101: l_assignment_number assignment_number;
102: TYPE assignment_type IS TABLE OF pa_project_assignments.assignment_type%TYPE
103: INDEX BY BINARY_INTEGER;
104: l_assignment_type assignment_type;
105: TYPE multiple_status_flag IS TABLE OF pa_project_assignments.multiple_status_flag%TYPE
106: INDEX BY BINARY_INTEGER;
107: l_multiple_status_flag multiple_status_flag;
108: TYPE apprvl_status_code IS TABLE OF pa_project_assignments.apprvl_status_code%TYPE
109: INDEX BY BINARY_INTEGER;

Line 108: TYPE apprvl_status_code IS TABLE OF pa_project_assignments.apprvl_status_code%TYPE

104: l_assignment_type assignment_type;
105: TYPE multiple_status_flag IS TABLE OF pa_project_assignments.multiple_status_flag%TYPE
106: INDEX BY BINARY_INTEGER;
107: l_multiple_status_flag multiple_status_flag;
108: TYPE apprvl_status_code IS TABLE OF pa_project_assignments.apprvl_status_code%TYPE
109: INDEX BY BINARY_INTEGER;
110: l_apprvl_status_code apprvl_status_code;
111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE
112: INDEX BY BINARY_INTEGER;

Line 111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE

107: l_multiple_status_flag multiple_status_flag;
108: TYPE apprvl_status_code IS TABLE OF pa_project_assignments.apprvl_status_code%TYPE
109: INDEX BY BINARY_INTEGER;
110: l_apprvl_status_code apprvl_status_code;
111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE
112: INDEX BY BINARY_INTEGER;
113: l_status_code status_code;
114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE
115: INDEX BY BINARY_INTEGER;

Line 114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE

110: l_apprvl_status_code apprvl_status_code;
111: TYPE status_code IS TABLE OF pa_project_assignments.status_code%TYPE
112: INDEX BY BINARY_INTEGER;
113: l_status_code status_code;
114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE
115: INDEX BY BINARY_INTEGER;
116: l_staffing_priority_code staffing_priority_code;
117: TYPE project_id IS TABLE OF pa_project_assignments.project_id%TYPE
118: INDEX BY BINARY_INTEGER;

Line 117: TYPE project_id IS TABLE OF pa_project_assignments.project_id%TYPE

113: l_status_code status_code;
114: TYPE staffing_priority_code IS TABLE OF pa_project_assignments.staffing_priority_code%TYPE
115: INDEX BY BINARY_INTEGER;
116: l_staffing_priority_code staffing_priority_code;
117: TYPE project_id IS TABLE OF pa_project_assignments.project_id%TYPE
118: INDEX BY BINARY_INTEGER;
119: l_project_id project_id;
120: TYPE assignment_template_id IS TABLE OF pa_project_assignments.assignment_template_id%TYPE
121: INDEX BY BINARY_INTEGER;

Line 120: TYPE assignment_template_id IS TABLE OF pa_project_assignments.assignment_template_id%TYPE

116: l_staffing_priority_code staffing_priority_code;
117: TYPE project_id IS TABLE OF pa_project_assignments.project_id%TYPE
118: INDEX BY BINARY_INTEGER;
119: l_project_id project_id;
120: TYPE assignment_template_id IS TABLE OF pa_project_assignments.assignment_template_id%TYPE
121: INDEX BY BINARY_INTEGER;
122: l_assignment_template_id assignment_template_id;
123: TYPE project_role_id IS TABLE OF pa_project_assignments.project_role_id%TYPE
124: INDEX BY BINARY_INTEGER;

Line 123: TYPE project_role_id IS TABLE OF pa_project_assignments.project_role_id%TYPE

119: l_project_id project_id;
120: TYPE assignment_template_id IS TABLE OF pa_project_assignments.assignment_template_id%TYPE
121: INDEX BY BINARY_INTEGER;
122: l_assignment_template_id assignment_template_id;
123: TYPE project_role_id IS TABLE OF pa_project_assignments.project_role_id%TYPE
124: INDEX BY BINARY_INTEGER;
125: l_project_role_id project_role_id;
126: TYPE resource_id IS TABLE OF pa_project_assignments.resource_id%TYPE
127: INDEX BY BINARY_INTEGER;

Line 126: TYPE resource_id IS TABLE OF pa_project_assignments.resource_id%TYPE

122: l_assignment_template_id assignment_template_id;
123: TYPE project_role_id IS TABLE OF pa_project_assignments.project_role_id%TYPE
124: INDEX BY BINARY_INTEGER;
125: l_project_role_id project_role_id;
126: TYPE resource_id IS TABLE OF pa_project_assignments.resource_id%TYPE
127: INDEX BY BINARY_INTEGER;
128: l_resource_id resource_id;
129: TYPE project_party_id IS TABLE OF pa_project_assignments.project_party_id%TYPE
130: INDEX BY BINARY_INTEGER;

Line 129: TYPE project_party_id IS TABLE OF pa_project_assignments.project_party_id%TYPE

125: l_project_role_id project_role_id;
126: TYPE resource_id IS TABLE OF pa_project_assignments.resource_id%TYPE
127: INDEX BY BINARY_INTEGER;
128: l_resource_id resource_id;
129: TYPE project_party_id IS TABLE OF pa_project_assignments.project_party_id%TYPE
130: INDEX BY BINARY_INTEGER;
131: l_project_party_id project_party_id;
132: TYPE description IS TABLE OF pa_project_assignments.description%TYPE
133: INDEX BY BINARY_INTEGER;

Line 132: TYPE description IS TABLE OF pa_project_assignments.description%TYPE

128: l_resource_id resource_id;
129: TYPE project_party_id IS TABLE OF pa_project_assignments.project_party_id%TYPE
130: INDEX BY BINARY_INTEGER;
131: l_project_party_id project_party_id;
132: TYPE description IS TABLE OF pa_project_assignments.description%TYPE
133: INDEX BY BINARY_INTEGER;
134: l_description description;
135: TYPE note_to_approver IS TABLE OF pa_project_assignments.note_to_approver%TYPE
136: INDEX BY BINARY_INTEGER;

Line 135: TYPE note_to_approver IS TABLE OF pa_project_assignments.note_to_approver%TYPE

131: l_project_party_id project_party_id;
132: TYPE description IS TABLE OF pa_project_assignments.description%TYPE
133: INDEX BY BINARY_INTEGER;
134: l_description description;
135: TYPE note_to_approver IS TABLE OF pa_project_assignments.note_to_approver%TYPE
136: INDEX BY BINARY_INTEGER;
137: l_note_to_approver note_to_approver;
138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE
139: INDEX BY BINARY_INTEGER;

Line 138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE

134: l_description description;
135: TYPE note_to_approver IS TABLE OF pa_project_assignments.note_to_approver%TYPE
136: INDEX BY BINARY_INTEGER;
137: l_note_to_approver note_to_approver;
138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE
139: INDEX BY BINARY_INTEGER;
140: l_start_date start_date;
141: TYPE end_date IS TABLE OF pa_project_assignments.end_date%TYPE
142: INDEX BY BINARY_INTEGER;

Line 141: TYPE end_date IS TABLE OF pa_project_assignments.end_date%TYPE

137: l_note_to_approver note_to_approver;
138: TYPE start_date IS TABLE OF pa_project_assignments.start_date%TYPE
139: INDEX BY BINARY_INTEGER;
140: l_start_date start_date;
141: TYPE end_date IS TABLE OF pa_project_assignments.end_date%TYPE
142: INDEX BY BINARY_INTEGER;
143: l_end_date end_date;
144: TYPE assignment_effort IS TABLE OF pa_project_assignments.assignment_effort%TYPE
145: INDEX BY BINARY_INTEGER;

Line 144: TYPE assignment_effort IS TABLE OF pa_project_assignments.assignment_effort%TYPE

140: l_start_date start_date;
141: TYPE end_date IS TABLE OF pa_project_assignments.end_date%TYPE
142: INDEX BY BINARY_INTEGER;
143: l_end_date end_date;
144: TYPE assignment_effort IS TABLE OF pa_project_assignments.assignment_effort%TYPE
145: INDEX BY BINARY_INTEGER;
146: l_assignment_effort assignment_effort;
147: TYPE extension_possible IS TABLE OF pa_project_assignments.extension_possible%TYPE
148: INDEX BY BINARY_INTEGER;

Line 147: TYPE extension_possible IS TABLE OF pa_project_assignments.extension_possible%TYPE

143: l_end_date end_date;
144: TYPE assignment_effort IS TABLE OF pa_project_assignments.assignment_effort%TYPE
145: INDEX BY BINARY_INTEGER;
146: l_assignment_effort assignment_effort;
147: TYPE extension_possible IS TABLE OF pa_project_assignments.extension_possible%TYPE
148: INDEX BY BINARY_INTEGER;
149: l_extension_possible extension_possible;
150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE
151: INDEX BY BINARY_INTEGER;

Line 150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE

146: l_assignment_effort assignment_effort;
147: TYPE extension_possible IS TABLE OF pa_project_assignments.extension_possible%TYPE
148: INDEX BY BINARY_INTEGER;
149: l_extension_possible extension_possible;
150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE
151: INDEX BY BINARY_INTEGER;
152: l_source_assignment_id source_assignment_id;
153: TYPE min_resource_job_level IS TABLE OF pa_project_assignments.min_resource_job_level%TYPE
154: INDEX BY BINARY_INTEGER;

Line 153: TYPE min_resource_job_level IS TABLE OF pa_project_assignments.min_resource_job_level%TYPE

149: l_extension_possible extension_possible;
150: TYPE source_assignment_id IS TABLE OF pa_project_assignments.source_assignment_id%TYPE
151: INDEX BY BINARY_INTEGER;
152: l_source_assignment_id source_assignment_id;
153: TYPE min_resource_job_level IS TABLE OF pa_project_assignments.min_resource_job_level%TYPE
154: INDEX BY BINARY_INTEGER;
155: l_min_resource_job_level min_resource_job_level;
156: TYPE max_resource_job_level IS TABLE OF pa_project_assignments.max_resource_job_level%TYPE
157: INDEX BY BINARY_INTEGER;

Line 156: TYPE max_resource_job_level IS TABLE OF pa_project_assignments.max_resource_job_level%TYPE

152: l_source_assignment_id source_assignment_id;
153: TYPE min_resource_job_level IS TABLE OF pa_project_assignments.min_resource_job_level%TYPE
154: INDEX BY BINARY_INTEGER;
155: l_min_resource_job_level min_resource_job_level;
156: TYPE max_resource_job_level IS TABLE OF pa_project_assignments.max_resource_job_level%TYPE
157: INDEX BY BINARY_INTEGER;
158: l_max_resource_job_level max_resource_job_level;
159: TYPE additional_information IS TABLE OF pa_project_assignments.additional_information%TYPE
160: INDEX BY BINARY_INTEGER;

Line 159: TYPE additional_information IS TABLE OF pa_project_assignments.additional_information%TYPE

155: l_min_resource_job_level min_resource_job_level;
156: TYPE max_resource_job_level IS TABLE OF pa_project_assignments.max_resource_job_level%TYPE
157: INDEX BY BINARY_INTEGER;
158: l_max_resource_job_level max_resource_job_level;
159: TYPE additional_information IS TABLE OF pa_project_assignments.additional_information%TYPE
160: INDEX BY BINARY_INTEGER;
161: l_additional_information additional_information;
162: TYPE work_type_id IS TABLE OF pa_project_assignments.work_type_id%TYPE
163: INDEX BY BINARY_INTEGER;

Line 162: TYPE work_type_id IS TABLE OF pa_project_assignments.work_type_id%TYPE

158: l_max_resource_job_level max_resource_job_level;
159: TYPE additional_information IS TABLE OF pa_project_assignments.additional_information%TYPE
160: INDEX BY BINARY_INTEGER;
161: l_additional_information additional_information;
162: TYPE work_type_id IS TABLE OF pa_project_assignments.work_type_id%TYPE
163: INDEX BY BINARY_INTEGER;
164: l_work_type_id work_type_id;
165: TYPE revenue_currency_code IS TABLE OF pa_project_assignments.revenue_currency_code%TYPE
166: INDEX BY BINARY_INTEGER;

Line 165: TYPE revenue_currency_code IS TABLE OF pa_project_assignments.revenue_currency_code%TYPE

161: l_additional_information additional_information;
162: TYPE work_type_id IS TABLE OF pa_project_assignments.work_type_id%TYPE
163: INDEX BY BINARY_INTEGER;
164: l_work_type_id work_type_id;
165: TYPE revenue_currency_code IS TABLE OF pa_project_assignments.revenue_currency_code%TYPE
166: INDEX BY BINARY_INTEGER;
167: l_revenue_currency_code revenue_currency_code;
168: TYPE revenue_bill_rate IS TABLE OF pa_project_assignments.revenue_bill_rate%TYPE
169: INDEX BY BINARY_INTEGER;

Line 168: TYPE revenue_bill_rate IS TABLE OF pa_project_assignments.revenue_bill_rate%TYPE

164: l_work_type_id work_type_id;
165: TYPE revenue_currency_code IS TABLE OF pa_project_assignments.revenue_currency_code%TYPE
166: INDEX BY BINARY_INTEGER;
167: l_revenue_currency_code revenue_currency_code;
168: TYPE revenue_bill_rate IS TABLE OF pa_project_assignments.revenue_bill_rate%TYPE
169: INDEX BY BINARY_INTEGER;
170: l_revenue_bill_rate revenue_bill_rate;
171:
172: TYPE markup_percent IS TABLE OF pa_project_assignments.markup_percent%TYPE

Line 172: TYPE markup_percent IS TABLE OF pa_project_assignments.markup_percent%TYPE

168: TYPE revenue_bill_rate IS TABLE OF pa_project_assignments.revenue_bill_rate%TYPE
169: INDEX BY BINARY_INTEGER;
170: l_revenue_bill_rate revenue_bill_rate;
171:
172: TYPE markup_percent IS TABLE OF pa_project_assignments.markup_percent%TYPE
173: INDEX BY BINARY_INTEGER;
174: l_markup_percent markup_percent;
175:
176: TYPE expense_owner IS TABLE OF pa_project_assignments.expense_owner%TYPE

Line 176: TYPE expense_owner IS TABLE OF pa_project_assignments.expense_owner%TYPE

172: TYPE markup_percent IS TABLE OF pa_project_assignments.markup_percent%TYPE
173: INDEX BY BINARY_INTEGER;
174: l_markup_percent markup_percent;
175:
176: TYPE expense_owner IS TABLE OF pa_project_assignments.expense_owner%TYPE
177: INDEX BY BINARY_INTEGER;
178: l_expense_owner expense_owner;
179: TYPE expense_limit IS TABLE OF pa_project_assignments.expense_limit%TYPE
180: INDEX BY BINARY_INTEGER;

Line 179: TYPE expense_limit IS TABLE OF pa_project_assignments.expense_limit%TYPE

175:
176: TYPE expense_owner IS TABLE OF pa_project_assignments.expense_owner%TYPE
177: INDEX BY BINARY_INTEGER;
178: l_expense_owner expense_owner;
179: TYPE expense_limit IS TABLE OF pa_project_assignments.expense_limit%TYPE
180: INDEX BY BINARY_INTEGER;
181: l_expense_limit expense_limit;
182: TYPE expense_limit_currency_code IS TABLE OF pa_project_assignments.expense_limit_currency_code%TYPE
183: INDEX BY BINARY_INTEGER;

Line 182: TYPE expense_limit_currency_code IS TABLE OF pa_project_assignments.expense_limit_currency_code%TYPE

178: l_expense_owner expense_owner;
179: TYPE expense_limit IS TABLE OF pa_project_assignments.expense_limit%TYPE
180: INDEX BY BINARY_INTEGER;
181: l_expense_limit expense_limit;
182: TYPE expense_limit_currency_code IS TABLE OF pa_project_assignments.expense_limit_currency_code%TYPE
183: INDEX BY BINARY_INTEGER;
184: l_expense_limit_currency_code expense_limit_currency_code;
185: TYPE fcst_tp_amount_type IS TABLE OF pa_project_assignments.fcst_tp_amount_type%TYPE
186: INDEX BY BINARY_INTEGER;

Line 185: TYPE fcst_tp_amount_type IS TABLE OF pa_project_assignments.fcst_tp_amount_type%TYPE

181: l_expense_limit expense_limit;
182: TYPE expense_limit_currency_code IS TABLE OF pa_project_assignments.expense_limit_currency_code%TYPE
183: INDEX BY BINARY_INTEGER;
184: l_expense_limit_currency_code expense_limit_currency_code;
185: TYPE fcst_tp_amount_type IS TABLE OF pa_project_assignments.fcst_tp_amount_type%TYPE
186: INDEX BY BINARY_INTEGER;
187: l_fcst_tp_amount_type fcst_tp_amount_type;
188: TYPE fcst_job_id IS TABLE OF pa_project_assignments.fcst_job_id%TYPE
189: INDEX BY BINARY_INTEGER;

Line 188: TYPE fcst_job_id IS TABLE OF pa_project_assignments.fcst_job_id%TYPE

184: l_expense_limit_currency_code expense_limit_currency_code;
185: TYPE fcst_tp_amount_type IS TABLE OF pa_project_assignments.fcst_tp_amount_type%TYPE
186: INDEX BY BINARY_INTEGER;
187: l_fcst_tp_amount_type fcst_tp_amount_type;
188: TYPE fcst_job_id IS TABLE OF pa_project_assignments.fcst_job_id%TYPE
189: INDEX BY BINARY_INTEGER;
190: l_fcst_job_id fcst_job_id;
191: TYPE fcst_job_group_id IS TABLE OF pa_project_assignments.fcst_job_group_id%TYPE
192: INDEX BY BINARY_INTEGER;

Line 191: TYPE fcst_job_group_id IS TABLE OF pa_project_assignments.fcst_job_group_id%TYPE

187: l_fcst_tp_amount_type fcst_tp_amount_type;
188: TYPE fcst_job_id IS TABLE OF pa_project_assignments.fcst_job_id%TYPE
189: INDEX BY BINARY_INTEGER;
190: l_fcst_job_id fcst_job_id;
191: TYPE fcst_job_group_id IS TABLE OF pa_project_assignments.fcst_job_group_id%TYPE
192: INDEX BY BINARY_INTEGER;
193: l_fcst_job_group_id fcst_job_group_id;
194: TYPE expenditure_org_id IS TABLE OF pa_project_assignments.expenditure_org_id%TYPE
195: INDEX BY BINARY_INTEGER;

Line 194: TYPE expenditure_org_id IS TABLE OF pa_project_assignments.expenditure_org_id%TYPE

190: l_fcst_job_id fcst_job_id;
191: TYPE fcst_job_group_id IS TABLE OF pa_project_assignments.fcst_job_group_id%TYPE
192: INDEX BY BINARY_INTEGER;
193: l_fcst_job_group_id fcst_job_group_id;
194: TYPE expenditure_org_id IS TABLE OF pa_project_assignments.expenditure_org_id%TYPE
195: INDEX BY BINARY_INTEGER;
196: l_expenditure_org_id expenditure_org_id;
197: TYPE expenditure_organization_id IS TABLE OF pa_project_assignments.expenditure_organization_id%TYPE
198: INDEX BY BINARY_INTEGER;

Line 197: TYPE expenditure_organization_id IS TABLE OF pa_project_assignments.expenditure_organization_id%TYPE

193: l_fcst_job_group_id fcst_job_group_id;
194: TYPE expenditure_org_id IS TABLE OF pa_project_assignments.expenditure_org_id%TYPE
195: INDEX BY BINARY_INTEGER;
196: l_expenditure_org_id expenditure_org_id;
197: TYPE expenditure_organization_id IS TABLE OF pa_project_assignments.expenditure_organization_id%TYPE
198: INDEX BY BINARY_INTEGER;
199: l_expenditure_organization_id expenditure_organization_id;
200: TYPE expenditure_type_class IS TABLE OF pa_project_assignments.expenditure_type_class%TYPE
201: INDEX BY BINARY_INTEGER;

Line 200: TYPE expenditure_type_class IS TABLE OF pa_project_assignments.expenditure_type_class%TYPE

196: l_expenditure_org_id expenditure_org_id;
197: TYPE expenditure_organization_id IS TABLE OF pa_project_assignments.expenditure_organization_id%TYPE
198: INDEX BY BINARY_INTEGER;
199: l_expenditure_organization_id expenditure_organization_id;
200: TYPE expenditure_type_class IS TABLE OF pa_project_assignments.expenditure_type_class%TYPE
201: INDEX BY BINARY_INTEGER;
202: l_expenditure_type_class expenditure_type_class;
203: TYPE expenditure_type IS TABLE OF pa_project_assignments.expenditure_type%TYPE
204: INDEX BY BINARY_INTEGER;

Line 203: TYPE expenditure_type IS TABLE OF pa_project_assignments.expenditure_type%TYPE

199: l_expenditure_organization_id expenditure_organization_id;
200: TYPE expenditure_type_class IS TABLE OF pa_project_assignments.expenditure_type_class%TYPE
201: INDEX BY BINARY_INTEGER;
202: l_expenditure_type_class expenditure_type_class;
203: TYPE expenditure_type IS TABLE OF pa_project_assignments.expenditure_type%TYPE
204: INDEX BY BINARY_INTEGER;
205: l_expenditure_type expenditure_type;
206: TYPE location_id IS TABLE OF pa_project_assignments.location_id%TYPE
207: INDEX BY BINARY_INTEGER;

Line 206: TYPE location_id IS TABLE OF pa_project_assignments.location_id%TYPE

202: l_expenditure_type_class expenditure_type_class;
203: TYPE expenditure_type IS TABLE OF pa_project_assignments.expenditure_type%TYPE
204: INDEX BY BINARY_INTEGER;
205: l_expenditure_type expenditure_type;
206: TYPE location_id IS TABLE OF pa_project_assignments.location_id%TYPE
207: INDEX BY BINARY_INTEGER;
208: l_location_id location_id;
209: TYPE calendar_type IS TABLE OF pa_project_assignments.calendar_type%TYPE
210: INDEX BY BINARY_INTEGER;

Line 209: TYPE calendar_type IS TABLE OF pa_project_assignments.calendar_type%TYPE

205: l_expenditure_type expenditure_type;
206: TYPE location_id IS TABLE OF pa_project_assignments.location_id%TYPE
207: INDEX BY BINARY_INTEGER;
208: l_location_id location_id;
209: TYPE calendar_type IS TABLE OF pa_project_assignments.calendar_type%TYPE
210: INDEX BY BINARY_INTEGER;
211: l_calendar_type calendar_type;
212: TYPE calendar_id IS TABLE OF pa_project_assignments.calendar_id%TYPE
213: INDEX BY BINARY_INTEGER;

Line 212: TYPE calendar_id IS TABLE OF pa_project_assignments.calendar_id%TYPE

208: l_location_id location_id;
209: TYPE calendar_type IS TABLE OF pa_project_assignments.calendar_type%TYPE
210: INDEX BY BINARY_INTEGER;
211: l_calendar_type calendar_type;
212: TYPE calendar_id IS TABLE OF pa_project_assignments.calendar_id%TYPE
213: INDEX BY BINARY_INTEGER;
214: l_calendar_id calendar_id;
215: TYPE resource_calendar_percent IS TABLE OF pa_project_assignments.resource_calendar_percent%TYPE
216: INDEX BY BINARY_INTEGER;

Line 215: TYPE resource_calendar_percent IS TABLE OF pa_project_assignments.resource_calendar_percent%TYPE

211: l_calendar_type calendar_type;
212: TYPE calendar_id IS TABLE OF pa_project_assignments.calendar_id%TYPE
213: INDEX BY BINARY_INTEGER;
214: l_calendar_id calendar_id;
215: TYPE resource_calendar_percent IS TABLE OF pa_project_assignments.resource_calendar_percent%TYPE
216: INDEX BY BINARY_INTEGER;
217: l_resource_calendar_percent resource_calendar_percent;
218: TYPE no_of_active_candidates IS TABLE OF pa_project_assignments.no_of_active_candidates%TYPE
219: INDEX BY BINARY_INTEGER;

Line 218: TYPE no_of_active_candidates IS TABLE OF pa_project_assignments.no_of_active_candidates%TYPE

214: l_calendar_id calendar_id;
215: TYPE resource_calendar_percent IS TABLE OF pa_project_assignments.resource_calendar_percent%TYPE
216: INDEX BY BINARY_INTEGER;
217: l_resource_calendar_percent resource_calendar_percent;
218: TYPE no_of_active_candidates IS TABLE OF pa_project_assignments.no_of_active_candidates%TYPE
219: INDEX BY BINARY_INTEGER;
220: l_no_of_active_candidates no_of_active_candidates;
221:
222: TYPE comp_match_weighting IS TABLE OF pa_project_assignments.competence_match_weighting%TYPE

Line 222: TYPE comp_match_weighting IS TABLE OF pa_project_assignments.competence_match_weighting%TYPE

218: TYPE no_of_active_candidates IS TABLE OF pa_project_assignments.no_of_active_candidates%TYPE
219: INDEX BY BINARY_INTEGER;
220: l_no_of_active_candidates no_of_active_candidates;
221:
222: TYPE comp_match_weighting IS TABLE OF pa_project_assignments.competence_match_weighting%TYPE
223: INDEX BY BINARY_INTEGER;
224: l_comp_match_weighting comp_match_weighting;
225:
226: TYPE avail_match_weighting IS TABLE OF pa_project_assignments.availability_match_weighting%TYPE

Line 226: TYPE avail_match_weighting IS TABLE OF pa_project_assignments.availability_match_weighting%TYPE

222: TYPE comp_match_weighting IS TABLE OF pa_project_assignments.competence_match_weighting%TYPE
223: INDEX BY BINARY_INTEGER;
224: l_comp_match_weighting comp_match_weighting;
225:
226: TYPE avail_match_weighting IS TABLE OF pa_project_assignments.availability_match_weighting%TYPE
227: INDEX BY BINARY_INTEGER;
228: l_avail_match_weighting avail_match_weighting;
229:
230: TYPE job_level_match_weighting IS TABLE OF pa_project_assignments.job_level_match_weighting%TYPE

Line 230: TYPE job_level_match_weighting IS TABLE OF pa_project_assignments.job_level_match_weighting%TYPE

226: TYPE avail_match_weighting IS TABLE OF pa_project_assignments.availability_match_weighting%TYPE
227: INDEX BY BINARY_INTEGER;
228: l_avail_match_weighting avail_match_weighting;
229:
230: TYPE job_level_match_weighting IS TABLE OF pa_project_assignments.job_level_match_weighting%TYPE
231: INDEX BY BINARY_INTEGER;
232: l_job_level_match_weighting job_level_match_weighting;
233:
234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE

Line 234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE

230: TYPE job_level_match_weighting IS TABLE OF pa_project_assignments.job_level_match_weighting%TYPE
231: INDEX BY BINARY_INTEGER;
232: l_job_level_match_weighting job_level_match_weighting;
233:
234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE
235: INDEX BY BINARY_INTEGER;
236: l_search_min_availability search_min_availability;
237:
238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE

Line 238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE

234: TYPE search_min_availability IS TABLE OF pa_project_assignments.search_min_availability%TYPE
235: INDEX BY BINARY_INTEGER;
236: l_search_min_availability search_min_availability;
237:
238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE
239: INDEX BY BINARY_INTEGER;
240: l_search_country_code search_country_code;
241:
242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE

Line 242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE

238: TYPE search_country_code IS TABLE OF pa_project_assignments.search_country_code%TYPE
239: INDEX BY BINARY_INTEGER;
240: l_search_country_code search_country_code;
241:
242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE
243: INDEX BY BINARY_INTEGER;
244: l_search_exp_org_struct_ver_id search_exp_org_struct_ver_id;
245:
246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE

Line 246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE

242: TYPE search_exp_org_struct_ver_id IS TABLE OF pa_project_assignments.search_exp_org_struct_ver_id%TYPE
243: INDEX BY BINARY_INTEGER;
244: l_search_exp_org_struct_ver_id search_exp_org_struct_ver_id;
245:
246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE
247: INDEX BY BINARY_INTEGER;
248: l_search_exp_start_org_id search_exp_start_org_id;
249:
250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE

Line 250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE

246: TYPE search_exp_start_org_id IS TABLE OF pa_project_assignments.search_exp_start_org_id%TYPE
247: INDEX BY BINARY_INTEGER;
248: l_search_exp_start_org_id search_exp_start_org_id;
249:
250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE
251: INDEX BY BINARY_INTEGER;
252: l_search_min_candidate_score search_min_candidate_score;
253:
254: TYPE enable_auto_cand_nom_flag IS TABLE OF pa_project_assignments.enable_auto_cand_nom_flag%TYPE

Line 254: TYPE enable_auto_cand_nom_flag IS TABLE OF pa_project_assignments.enable_auto_cand_nom_flag%TYPE

250: TYPE search_min_candidate_score IS TABLE OF pa_project_assignments.search_min_candidate_score%TYPE
251: INDEX BY BINARY_INTEGER;
252: l_search_min_candidate_score search_min_candidate_score;
253:
254: TYPE enable_auto_cand_nom_flag IS TABLE OF pa_project_assignments.enable_auto_cand_nom_flag%TYPE
255: INDEX BY BINARY_INTEGER;
256: l_enable_auto_cand_nom_flag enable_auto_cand_nom_flag;
257:
258:

Line 259: TYPE bill_rate_override IS TABLE OF pa_project_assignments.bill_rate_override%TYPE

255: INDEX BY BINARY_INTEGER;
256: l_enable_auto_cand_nom_flag enable_auto_cand_nom_flag;
257:
258:
259: TYPE bill_rate_override IS TABLE OF pa_project_assignments.bill_rate_override%TYPE
260: INDEX BY BINARY_INTEGER;
261: l_bill_rate_override bill_rate_override;
262:
263:

Line 264: TYPE bill_rate_curr_override IS TABLE OF pa_project_assignments.bill_rate_curr_override%TYPE

260: INDEX BY BINARY_INTEGER;
261: l_bill_rate_override bill_rate_override;
262:
263:
264: TYPE bill_rate_curr_override IS TABLE OF pa_project_assignments.bill_rate_curr_override%TYPE
265: INDEX BY BINARY_INTEGER;
266: l_bill_rate_curr_override bill_rate_curr_override;
267:
268: TYPE markup_percent_override IS TABLE OF pa_project_assignments.markup_percent_override%TYPE

Line 268: TYPE markup_percent_override IS TABLE OF pa_project_assignments.markup_percent_override%TYPE

264: TYPE bill_rate_curr_override IS TABLE OF pa_project_assignments.bill_rate_curr_override%TYPE
265: INDEX BY BINARY_INTEGER;
266: l_bill_rate_curr_override bill_rate_curr_override;
267:
268: TYPE markup_percent_override IS TABLE OF pa_project_assignments.markup_percent_override%TYPE
269: INDEX BY BINARY_INTEGER;
270: l_markup_percent_override markup_percent_override;
271:
272: -- FP.L Development

Line 273: TYPE discount_percentage IS TABLE OF pa_project_assignments.discount_percentage%TYPE

269: INDEX BY BINARY_INTEGER;
270: l_markup_percent_override markup_percent_override;
271:
272: -- FP.L Development
273: TYPE discount_percentage IS TABLE OF pa_project_assignments.discount_percentage%TYPE
274: INDEX BY BINARY_INTEGER;
275: l_discount_percentage discount_percentage;
276:
277: -- FP.L Development

Line 278: TYPE rate_disc_reason_code IS TABLE OF pa_project_assignments.rate_disc_reason_code%TYPE

274: INDEX BY BINARY_INTEGER;
275: l_discount_percentage discount_percentage;
276:
277: -- FP.L Development
278: TYPE rate_disc_reason_code IS TABLE OF pa_project_assignments.rate_disc_reason_code%TYPE
279: INDEX BY BINARY_INTEGER;
280: l_rate_disc_reason_code rate_disc_reason_code;
281:
282: TYPE tp_rate_override IS TABLE OF pa_project_assignments.tp_rate_override%TYPE

Line 282: TYPE tp_rate_override IS TABLE OF pa_project_assignments.tp_rate_override%TYPE

278: TYPE rate_disc_reason_code IS TABLE OF pa_project_assignments.rate_disc_reason_code%TYPE
279: INDEX BY BINARY_INTEGER;
280: l_rate_disc_reason_code rate_disc_reason_code;
281:
282: TYPE tp_rate_override IS TABLE OF pa_project_assignments.tp_rate_override%TYPE
283: INDEX BY BINARY_INTEGER;
284: l_tp_rate_override tp_rate_override;
285:
286: TYPE tp_currency_override IS TABLE OF pa_project_assignments.tp_currency_override%TYPE

Line 286: TYPE tp_currency_override IS TABLE OF pa_project_assignments.tp_currency_override%TYPE

282: TYPE tp_rate_override IS TABLE OF pa_project_assignments.tp_rate_override%TYPE
283: INDEX BY BINARY_INTEGER;
284: l_tp_rate_override tp_rate_override;
285:
286: TYPE tp_currency_override IS TABLE OF pa_project_assignments.tp_currency_override%TYPE
287: INDEX BY BINARY_INTEGER;
288: l_tp_currency_override tp_currency_override;
289:
290: TYPE tp_calc_base_code_override IS TABLE OF pa_project_assignments.tp_calc_base_code_override%TYPE

Line 290: TYPE tp_calc_base_code_override IS TABLE OF pa_project_assignments.tp_calc_base_code_override%TYPE

286: TYPE tp_currency_override IS TABLE OF pa_project_assignments.tp_currency_override%TYPE
287: INDEX BY BINARY_INTEGER;
288: l_tp_currency_override tp_currency_override;
289:
290: TYPE tp_calc_base_code_override IS TABLE OF pa_project_assignments.tp_calc_base_code_override%TYPE
291: INDEX BY BINARY_INTEGER;
292: l_tp_calc_base_code_override tp_calc_base_code_override;
293:
294: TYPE tp_percent_applied_override IS TABLE OF pa_project_assignments.tp_percent_applied_override%TYPE

Line 294: TYPE tp_percent_applied_override IS TABLE OF pa_project_assignments.tp_percent_applied_override%TYPE

290: TYPE tp_calc_base_code_override IS TABLE OF pa_project_assignments.tp_calc_base_code_override%TYPE
291: INDEX BY BINARY_INTEGER;
292: l_tp_calc_base_code_override tp_calc_base_code_override;
293:
294: TYPE tp_percent_applied_override IS TABLE OF pa_project_assignments.tp_percent_applied_override%TYPE
295: INDEX BY BINARY_INTEGER;
296: l_tp_percent_applied_override tp_percent_applied_override;
297:
298: -- FP.L Development

Line 299: TYPE staffing_owner_person_id IS TABLE OF pa_project_assignments.staffing_owner_person_id%TYPE

295: INDEX BY BINARY_INTEGER;
296: l_tp_percent_applied_override tp_percent_applied_override;
297:
298: -- FP.L Development
299: TYPE staffing_owner_person_id IS TABLE OF pa_project_assignments.staffing_owner_person_id%TYPE
300: INDEX BY BINARY_INTEGER;
301: l_staffing_owner_person_id staffing_owner_person_id;
302:
303: -- FP.M Development

Line 304: TYPE resource_list_member_id IS TABLE OF pa_project_assignments.resource_list_member_id%TYPE

300: INDEX BY BINARY_INTEGER;
301: l_staffing_owner_person_id staffing_owner_person_id;
302:
303: -- FP.M Development
304: TYPE resource_list_member_id IS TABLE OF pa_project_assignments.resource_list_member_id%TYPE
305: INDEX BY BINARY_INTEGER;
306: l_resource_list_member_id resource_list_member_id;
307:
308: TYPE attribute_category IS TABLE OF pa_project_assignments.attribute_category%TYPE

Line 308: TYPE attribute_category IS TABLE OF pa_project_assignments.attribute_category%TYPE

304: TYPE resource_list_member_id IS TABLE OF pa_project_assignments.resource_list_member_id%TYPE
305: INDEX BY BINARY_INTEGER;
306: l_resource_list_member_id resource_list_member_id;
307:
308: TYPE attribute_category IS TABLE OF pa_project_assignments.attribute_category%TYPE
309: INDEX BY BINARY_INTEGER;
310: l_attribute_category attribute_category;
311: TYPE attribute1 IS TABLE OF pa_project_assignments.attribute1%TYPE
312: INDEX BY BINARY_INTEGER;

Line 311: TYPE attribute1 IS TABLE OF pa_project_assignments.attribute1%TYPE

307:
308: TYPE attribute_category IS TABLE OF pa_project_assignments.attribute_category%TYPE
309: INDEX BY BINARY_INTEGER;
310: l_attribute_category attribute_category;
311: TYPE attribute1 IS TABLE OF pa_project_assignments.attribute1%TYPE
312: INDEX BY BINARY_INTEGER;
313: l_attribute1 attribute1;
314: TYPE attribute2 IS TABLE OF pa_project_assignments.attribute2%TYPE
315: INDEX BY BINARY_INTEGER;

Line 314: TYPE attribute2 IS TABLE OF pa_project_assignments.attribute2%TYPE

310: l_attribute_category attribute_category;
311: TYPE attribute1 IS TABLE OF pa_project_assignments.attribute1%TYPE
312: INDEX BY BINARY_INTEGER;
313: l_attribute1 attribute1;
314: TYPE attribute2 IS TABLE OF pa_project_assignments.attribute2%TYPE
315: INDEX BY BINARY_INTEGER;
316: l_attribute2 attribute2;
317: TYPE attribute3 IS TABLE OF pa_project_assignments.attribute3%TYPE
318: INDEX BY BINARY_INTEGER;

Line 317: TYPE attribute3 IS TABLE OF pa_project_assignments.attribute3%TYPE

313: l_attribute1 attribute1;
314: TYPE attribute2 IS TABLE OF pa_project_assignments.attribute2%TYPE
315: INDEX BY BINARY_INTEGER;
316: l_attribute2 attribute2;
317: TYPE attribute3 IS TABLE OF pa_project_assignments.attribute3%TYPE
318: INDEX BY BINARY_INTEGER;
319: l_attribute3 attribute3;
320: TYPE attribute4 IS TABLE OF pa_project_assignments.attribute4%TYPE
321: INDEX BY BINARY_INTEGER;

Line 320: TYPE attribute4 IS TABLE OF pa_project_assignments.attribute4%TYPE

316: l_attribute2 attribute2;
317: TYPE attribute3 IS TABLE OF pa_project_assignments.attribute3%TYPE
318: INDEX BY BINARY_INTEGER;
319: l_attribute3 attribute3;
320: TYPE attribute4 IS TABLE OF pa_project_assignments.attribute4%TYPE
321: INDEX BY BINARY_INTEGER;
322: l_attribute4 attribute4;
323: TYPE attribute5 IS TABLE OF pa_project_assignments.attribute5%TYPE
324: INDEX BY BINARY_INTEGER;

Line 323: TYPE attribute5 IS TABLE OF pa_project_assignments.attribute5%TYPE

319: l_attribute3 attribute3;
320: TYPE attribute4 IS TABLE OF pa_project_assignments.attribute4%TYPE
321: INDEX BY BINARY_INTEGER;
322: l_attribute4 attribute4;
323: TYPE attribute5 IS TABLE OF pa_project_assignments.attribute5%TYPE
324: INDEX BY BINARY_INTEGER;
325: l_attribute5 attribute5;
326: TYPE attribute6 IS TABLE OF pa_project_assignments.attribute6%TYPE
327: INDEX BY BINARY_INTEGER;

Line 326: TYPE attribute6 IS TABLE OF pa_project_assignments.attribute6%TYPE

322: l_attribute4 attribute4;
323: TYPE attribute5 IS TABLE OF pa_project_assignments.attribute5%TYPE
324: INDEX BY BINARY_INTEGER;
325: l_attribute5 attribute5;
326: TYPE attribute6 IS TABLE OF pa_project_assignments.attribute6%TYPE
327: INDEX BY BINARY_INTEGER;
328: l_attribute6 attribute6;
329: TYPE attribute7 IS TABLE OF pa_project_assignments.attribute7%TYPE
330: INDEX BY BINARY_INTEGER;

Line 329: TYPE attribute7 IS TABLE OF pa_project_assignments.attribute7%TYPE

325: l_attribute5 attribute5;
326: TYPE attribute6 IS TABLE OF pa_project_assignments.attribute6%TYPE
327: INDEX BY BINARY_INTEGER;
328: l_attribute6 attribute6;
329: TYPE attribute7 IS TABLE OF pa_project_assignments.attribute7%TYPE
330: INDEX BY BINARY_INTEGER;
331: l_attribute7 attribute7;
332: TYPE attribute8 IS TABLE OF pa_project_assignments.attribute8%TYPE
333: INDEX BY BINARY_INTEGER;

Line 332: TYPE attribute8 IS TABLE OF pa_project_assignments.attribute8%TYPE

328: l_attribute6 attribute6;
329: TYPE attribute7 IS TABLE OF pa_project_assignments.attribute7%TYPE
330: INDEX BY BINARY_INTEGER;
331: l_attribute7 attribute7;
332: TYPE attribute8 IS TABLE OF pa_project_assignments.attribute8%TYPE
333: INDEX BY BINARY_INTEGER;
334: l_attribute8 attribute8;
335: TYPE attribute9 IS TABLE OF pa_project_assignments.attribute9%TYPE
336: INDEX BY BINARY_INTEGER;

Line 335: TYPE attribute9 IS TABLE OF pa_project_assignments.attribute9%TYPE

331: l_attribute7 attribute7;
332: TYPE attribute8 IS TABLE OF pa_project_assignments.attribute8%TYPE
333: INDEX BY BINARY_INTEGER;
334: l_attribute8 attribute8;
335: TYPE attribute9 IS TABLE OF pa_project_assignments.attribute9%TYPE
336: INDEX BY BINARY_INTEGER;
337: l_attribute9 attribute9;
338: TYPE attribute10 IS TABLE OF pa_project_assignments.attribute10%TYPE
339: INDEX BY BINARY_INTEGER;

Line 338: TYPE attribute10 IS TABLE OF pa_project_assignments.attribute10%TYPE

334: l_attribute8 attribute8;
335: TYPE attribute9 IS TABLE OF pa_project_assignments.attribute9%TYPE
336: INDEX BY BINARY_INTEGER;
337: l_attribute9 attribute9;
338: TYPE attribute10 IS TABLE OF pa_project_assignments.attribute10%TYPE
339: INDEX BY BINARY_INTEGER;
340: l_attribute10 attribute10;
341: TYPE attribute11 IS TABLE OF pa_project_assignments.attribute11%TYPE
342: INDEX BY BINARY_INTEGER;

Line 341: TYPE attribute11 IS TABLE OF pa_project_assignments.attribute11%TYPE

337: l_attribute9 attribute9;
338: TYPE attribute10 IS TABLE OF pa_project_assignments.attribute10%TYPE
339: INDEX BY BINARY_INTEGER;
340: l_attribute10 attribute10;
341: TYPE attribute11 IS TABLE OF pa_project_assignments.attribute11%TYPE
342: INDEX BY BINARY_INTEGER;
343: l_attribute11 attribute11;
344: TYPE attribute12 IS TABLE OF pa_project_assignments.attribute12%TYPE
345: INDEX BY BINARY_INTEGER;

Line 344: TYPE attribute12 IS TABLE OF pa_project_assignments.attribute12%TYPE

340: l_attribute10 attribute10;
341: TYPE attribute11 IS TABLE OF pa_project_assignments.attribute11%TYPE
342: INDEX BY BINARY_INTEGER;
343: l_attribute11 attribute11;
344: TYPE attribute12 IS TABLE OF pa_project_assignments.attribute12%TYPE
345: INDEX BY BINARY_INTEGER;
346: l_attribute12 attribute12;
347: TYPE attribute13 IS TABLE OF pa_project_assignments.attribute13%TYPE
348: INDEX BY BINARY_INTEGER;

Line 347: TYPE attribute13 IS TABLE OF pa_project_assignments.attribute13%TYPE

343: l_attribute11 attribute11;
344: TYPE attribute12 IS TABLE OF pa_project_assignments.attribute12%TYPE
345: INDEX BY BINARY_INTEGER;
346: l_attribute12 attribute12;
347: TYPE attribute13 IS TABLE OF pa_project_assignments.attribute13%TYPE
348: INDEX BY BINARY_INTEGER;
349: l_attribute13 attribute13;
350: TYPE attribute14 IS TABLE OF pa_project_assignments.attribute14%TYPE
351: INDEX BY BINARY_INTEGER;

Line 350: TYPE attribute14 IS TABLE OF pa_project_assignments.attribute14%TYPE

346: l_attribute12 attribute12;
347: TYPE attribute13 IS TABLE OF pa_project_assignments.attribute13%TYPE
348: INDEX BY BINARY_INTEGER;
349: l_attribute13 attribute13;
350: TYPE attribute14 IS TABLE OF pa_project_assignments.attribute14%TYPE
351: INDEX BY BINARY_INTEGER;
352: l_attribute14 attribute14;
353: TYPE attribute15 IS TABLE OF pa_project_assignments.attribute15%TYPE
354: INDEX BY BINARY_INTEGER;

Line 353: TYPE attribute15 IS TABLE OF pa_project_assignments.attribute15%TYPE

349: l_attribute13 attribute13;
350: TYPE attribute14 IS TABLE OF pa_project_assignments.attribute14%TYPE
351: INDEX BY BINARY_INTEGER;
352: l_attribute14 attribute14;
353: TYPE attribute15 IS TABLE OF pa_project_assignments.attribute15%TYPE
354: INDEX BY BINARY_INTEGER;
355: l_attribute15 attribute15;
356: /* Added for bug 3051110 */
357: TYPE transfer_price_rate IS TABLE OF pa_project_assignments.transfer_price_rate%TYPE

Line 357: TYPE transfer_price_rate IS TABLE OF pa_project_assignments.transfer_price_rate%TYPE

353: TYPE attribute15 IS TABLE OF pa_project_assignments.attribute15%TYPE
354: INDEX BY BINARY_INTEGER;
355: l_attribute15 attribute15;
356: /* Added for bug 3051110 */
357: TYPE transfer_price_rate IS TABLE OF pa_project_assignments.transfer_price_rate%TYPE
358: INDEX BY BINARY_INTEGER;
359: l_transfer_price_rate transfer_price_rate;
360: TYPE transfer_pr_rate_curr IS TABLE OF pa_project_assignments.transfer_pr_rate_curr%TYPE
361: INDEX BY BINARY_INTEGER;

Line 360: TYPE transfer_pr_rate_curr IS TABLE OF pa_project_assignments.transfer_pr_rate_curr%TYPE

356: /* Added for bug 3051110 */
357: TYPE transfer_price_rate IS TABLE OF pa_project_assignments.transfer_price_rate%TYPE
358: INDEX BY BINARY_INTEGER;
359: l_transfer_price_rate transfer_price_rate;
360: TYPE transfer_pr_rate_curr IS TABLE OF pa_project_assignments.transfer_pr_rate_curr%TYPE
361: INDEX BY BINARY_INTEGER;
362: l_transfer_pr_rate_curr transfer_pr_rate_curr;
363: TYPE rowid_table IS TABLE OF ROWID
364: INDEX BY BINARY_INTEGER;

Line 486: INSERT INTO pa_project_assignments

482: END LOOP;
483:
484: FORALL i IN 1 .. p_number_of_requirements
485:
486: INSERT INTO pa_project_assignments
487: (assignment_id,
488: assignment_name,
489: assignment_type,
490: multiple_status_flag,

Line 575: ( pa_project_assignments_s.NEXTVAL,

571: last_update_login,
572: transfer_price_rate, --For bug 3051110
573: transfer_pr_rate_curr)
574: VALUES
575: ( pa_project_assignments_s.NEXTVAL,
576: DECODE(l_assignment_name(i), FND_API.G_MISS_CHAR, NULL, l_assignment_name(i)),
577: DECODE(l_assignment_type(i), FND_API.G_MISS_CHAR, NULL, l_assignment_type(i)),
578: DECODE(l_multiple_status_flag(i), FND_API.G_MISS_CHAR, NULL, l_multiple_status_flag(i)),
579: 1,

Line 688: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row'

684:
685: EXCEPTION
686: WHEN OTHERS THEN -- catch the exceptins here
687: -- Set the exception Message and the stack
688: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row'
689: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
691: RAISE;
692: END Insert_Row;

Line 697: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE

693:
694:
695: PROCEDURE Update_Row
696: ( p_assignment_row_id IN ROWID :=NULL
697: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
698: ,p_record_version_number IN NUMBER := NULL
699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

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

695: PROCEDURE Update_Row
696: ( p_assignment_row_id IN ROWID :=NULL
697: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
698: ,p_record_version_number IN NUMBER := NULL
699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

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

696: ( p_assignment_row_id IN ROWID :=NULL
697: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
698: ,p_record_version_number IN NUMBER := NULL
699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

697: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
698: ,p_record_version_number IN NUMBER := NULL
699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR

698: ,p_record_version_number IN NUMBER := NULL
699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM

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

699: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

700: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

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

701: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

Line 706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM

702: ,p_apprvl_status_code IN pa_project_assignments.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

703: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR

Line 708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM

704: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM

705: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

706: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

Line 711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR

707: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

708: ,p_resource_id IN pa_project_assignments.resource_id%TYPE := FND_API.G_MISS_NUM
709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

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

709: ,p_project_party_id IN pa_project_assignments.project_party_id%TYPE := FND_API.G_MISS_NUM
710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM

710: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

711: ,p_note_to_approver IN pa_project_assignments.note_to_approver%TYPE := FND_API.G_MISS_CHAR
712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

Line 716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM

712: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

713: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

714: ,p_assignment_effort IN pa_project_assignments.assignment_effort%TYPE := FND_API.G_MISS_NUM
715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

715: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM

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

716: ,p_source_assignment_id IN pa_project_assignments.source_assignment_id%TYPE := FND_API.G_MISS_NUM
717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM

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

717: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

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

718: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

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

719: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM

720: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

721: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

722: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

723: ,p_revenue_bill_rate IN pa_project_assignments.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

724: ,p_markup_percent IN pa_project_assignments.markup_percent%TYPE := FND_API.G_MISS_NUM
725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

725: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

726: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

727: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

728: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

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

729: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM

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

730: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

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

731: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

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

732: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

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

733: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

734: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR

735: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM

736: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

737: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

738: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

739: ,p_pending_approval_flag IN pa_project_assignments.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

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

740: ,p_no_of_active_candidates IN pa_project_assignments.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

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

741: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

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

742: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

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

743: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

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

744: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

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

745: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938

Line 750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM

746: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938

Line 751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR

747: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM

Line 752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM

748: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

Line 753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938

749: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

Line 754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938

750: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

Line 755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM

751: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR

752: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development

Line 757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR

753: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM -- Bug 2590938
754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM

754: ,p_rate_disc_reason_code IN pa_project_assignments.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR -- Bug 2590938
755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

755: ,p_tp_rate_override IN pa_project_assignments.tp_rate_override%TYPE := FND_API.G_MISS_NUM
756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development

756: ,p_tp_currency_override IN pa_project_assignments.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR

757: ,p_tp_calc_base_code_override IN pa_project_assignments.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR

758: ,p_tp_percent_applied_override IN pa_project_assignments.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR

759: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR

760: ,p_resource_list_member_id IN pa_project_assignments.resource_list_member_id%TYPE := FND_API.G_MISS_NUM -- FP.M Development
761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR

761: ,p_attribute_category IN pa_project_assignments.attribute_category%TYPE := FND_API.G_MISS_CHAR
762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR

762: ,p_attribute1 IN pa_project_assignments.attribute1%TYPE := FND_API.G_MISS_CHAR
763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR

763: ,p_attribute2 IN pa_project_assignments.attribute2%TYPE := FND_API.G_MISS_CHAR
764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR

764: ,p_attribute3 IN pa_project_assignments.attribute3%TYPE := FND_API.G_MISS_CHAR
765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR

765: ,p_attribute4 IN pa_project_assignments.attribute4%TYPE := FND_API.G_MISS_CHAR
766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR

766: ,p_attribute5 IN pa_project_assignments.attribute5%TYPE := FND_API.G_MISS_CHAR
767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR

767: ,p_attribute6 IN pa_project_assignments.attribute6%TYPE := FND_API.G_MISS_CHAR
768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR

768: ,p_attribute7 IN pa_project_assignments.attribute7%TYPE := FND_API.G_MISS_CHAR
769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR

769: ,p_attribute8 IN pa_project_assignments.attribute8%TYPE := FND_API.G_MISS_CHAR
770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */

Line 774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR

770: ,p_attribute9 IN pa_project_assignments.attribute9%TYPE := FND_API.G_MISS_CHAR
771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */
778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM

Line 775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR

771: ,p_attribute10 IN pa_project_assignments.attribute10%TYPE := FND_API.G_MISS_CHAR
772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */
778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
779: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR

Line 776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR

772: ,p_attribute11 IN pa_project_assignments.attribute11%TYPE := FND_API.G_MISS_CHAR
773: ,p_attribute12 IN pa_project_assignments.attribute12%TYPE := FND_API.G_MISS_CHAR
774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */
778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
779: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
780: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM

774: ,p_attribute13 IN pa_project_assignments.attribute13%TYPE := FND_API.G_MISS_CHAR
775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */
778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
779: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
780: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
781: )IS
782:

Line 779: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR

775: ,p_attribute14 IN pa_project_assignments.attribute14%TYPE := FND_API.G_MISS_CHAR
776: ,p_attribute15 IN pa_project_assignments.attribute15%TYPE := FND_API.G_MISS_CHAR
777: /* Added 2 columns for 3051110 */
778: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
779: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
780: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
781: )IS
782:
783:

Line 788: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE

784: l_row_id ROWID := p_assignment_row_id;
785: l_record_version_number NUMBER;
786: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
787:
788: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE
789: INDEX BY BINARY_INTEGER;
790: l_assignment_id assignment_id;
791: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
792:

Line 791: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;

787:
788: TYPE assignment_id IS TABLE OF pa_project_assignments.assignment_id%TYPE
789: INDEX BY BINARY_INTEGER;
790: l_assignment_id assignment_id;
791: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
792:
793: CURSOR get_row_id IS
794: SELECT rowid
795: FROM pa_project_assignments

Line 795: FROM pa_project_assignments

791: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
792:
793: CURSOR get_row_id IS
794: SELECT rowid
795: FROM pa_project_assignments
796: WHERE assignment_id = p_assignment_id;
797:
798: CURSOR check_team_template_wf IS
799: SELECT workflow_in_progress_flag

Line 811: FROM pa_project_assignments

807: -- is pending for the role
808: -- 2) for Single, check is taken care of in PA_ASSIGNMENT_PUB
809: CURSOR check_project_assignment_wf IS
810: SELECT mass_wf_in_progress_flag
811: FROM pa_project_assignments
812: WHERE assignment_id = p_assignment_id;
813: */
814: BEGIN
815:

Line 880: UPDATE pa_project_assignments

876: END IF;
877:
878: FORALL i IN l_assignment_id.FIRST .. l_assignment_id.LAST
879:
880: UPDATE pa_project_assignments
881: SET assignment_name = DECODE(p_assignment_name, FND_API.G_MISS_CHAR, assignment_name, p_assignment_name),
882: assignment_type = DECODE(p_assignment_type, FND_API.G_MISS_CHAR, assignment_type, p_assignment_type),
883: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
884: multiple_status_flag = DECODE(p_multiple_status_flag, FND_API.G_MISS_CHAR, multiple_status_flag, p_multiple_status_flag),

Line 983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Update_Row'

979: --
980: EXCEPTION
981: WHEN OTHERS THEN -- catch the exceptins here
982: -- Set the exception Message and the stack
983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Update_Row'
984: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986: RAISE;
987: --

Line 993: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE

989:
990:
991: PROCEDURE Delete_Row
992: ( p_assignment_row_id IN ROWID
993: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
994: ,p_record_version_number IN NUMBER := NULL
995: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
996: )
997: IS

Line 1001: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;

997: IS
998:
999: l_row_id ROWID;
1000: l_workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE;
1001: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
1002:
1003: CURSOR check_team_template_wf IS
1004: SELECT tt.workflow_in_progress_flag
1005: FROM pa_project_assignments asgn,

Line 1005: FROM pa_project_assignments asgn,

1001: l_mass_wf_in_progress_flag pa_project_assignments.mass_wf_in_progress_flag%TYPE;
1002:
1003: CURSOR check_team_template_wf IS
1004: SELECT tt.workflow_in_progress_flag
1005: FROM pa_project_assignments asgn,
1006: pa_team_templates tt
1007: WHERE asgn.assignment_id = p_assignment_id
1008: AND asgn.template_flag = 'Y'
1009: AND tt.team_template_id = asgn.assignment_template_id;

Line 1013: FROM pa_project_assignments

1009: AND tt.team_template_id = asgn.assignment_template_id;
1010:
1011: CURSOR check_project_assignment_wf IS
1012: SELECT mass_wf_in_progress_flag
1013: FROM pa_project_assignments
1014: WHERE assignment_id = p_assignment_id;
1015:
1016: BEGIN
1017:

Line 1054: DELETE FROM pa_project_assignments

1050: END IF;
1051:
1052: IF (p_assignment_id IS NOT NULL AND p_assignment_id <> FND_API.G_MISS_NUM) THEN
1053:
1054: DELETE FROM pa_project_assignments
1055: WHERE assignment_id = p_assignment_id
1056: AND nvl(p_record_version_number, record_version_number) = record_version_number;
1057:
1058: ELSIF (p_assignment_row_id IS NOT NULL) THEN

Line 1059: DELETE FROM pa_project_assignments

1055: WHERE assignment_id = p_assignment_id
1056: AND nvl(p_record_version_number, record_version_number) = record_version_number;
1057:
1058: ELSIF (p_assignment_row_id IS NOT NULL) THEN
1059: DELETE FROM pa_project_assignments
1060: WHERE rowid = p_assignment_row_id
1061: AND nvl(p_record_version_number, record_version_number) = record_version_number;
1062:
1063: END IF;

Line 1080: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row'

1076:
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: -- Set the exception Message and the stack
1080: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row'
1081: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1083: RAISE;
1084: END Delete_Row;

Line 1089: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE

1085:
1086:
1087: PROCEDURE Lock_Row
1088: ( p_assignment_row_id IN ROWID
1089: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1090: ,p_record_version_number IN NUMBER := NULL
1091: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1092: )
1093: IS

Line 1100: FROM pa_project_assignments

1096:
1097: BEGIN
1098: -- Lock the Assignment;
1099: SELECT rowid INTO l_row_id
1100: FROM pa_project_assignments
1101: WHERE assignment_id = p_assignment_id
1102: OR rowid = p_assignment_row_id
1103: FOR UPDATE NOWAIT;
1104: --

Line 1109: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Lock_Row'

1105: --
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: -- Set the exception Message and the stack
1109: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_ASSIGNMENTS_PKG.Lock_Row'
1110: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1112: RAISE;
1113:

Line 1117: END pa_project_assignments_pkg;

1113:
1114: END Lock_Row;
1115: --
1116: --
1117: END pa_project_assignments_pkg;