1: PACKAGE PA_ASSIGNMENTS_HISTORY_PKG AUTHID CURRENT_USER AS
2: /*$Header: PARAAPKS.pls 120.1 2005/08/19 16:47:06 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2: /*$Header: PARAAPKS.pls 120.1 2005/08/19 16:47:06 mwasowic noship $*/
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
3:
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
4: PROCEDURE Insert_Row
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
5: ( p_assignment_id IN pa_assignments_history.assignment_id%TYPE := FND_API.G_MISS_NUM
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
6: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
7: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
8: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
9: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
10: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
11: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
12: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
13: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
14: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
15: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
16: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
17: ,p_resource_id IN pa_assignments_history.resource_id%TYPE := FND_API.G_MISS_NUM
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
18: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
19: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
20: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
21: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
22: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
23: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
24: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
25: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
26: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
27: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
28: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
29: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
30: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
31: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
32: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
33: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
34: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
35: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
36: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
37: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
38: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
39: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
40: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
41: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
42: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
43: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
44: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
45: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
46: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
47: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
48: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
49: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
50: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE := FND_API.G_MISS_CHAR
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
51: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
52: ,p_comp_match_weighting IN pa_assignments_history.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
53: ,p_avail_match_weighting IN pa_assignments_history.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
54: ,p_job_level_match_weighting IN pa_assignments_history.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
55: ,p_search_min_availability IN pa_assignments_history.search_min_availability%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
56: ,p_search_country_code IN pa_assignments_history.search_country_code%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
57: ,p_search_exp_org_struct_ver_id IN pa_assignments_history.search_exp_org_struct_ver_id%TYPE:= FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
58: ,p_search_exp_start_org_id IN pa_assignments_history.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_candidate_score IN pa_assignments_history.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
60: ,p_last_auto_search_date IN pa_assignments_history.last_auto_search_date%TYPE := FND_API.G_MISS_DATE
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
61: ,p_enable_auto_cand_nom_flag IN pa_assignments_history.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
62: ,p_mass_wf_in_progress_flag IN pa_assignments_history.mass_wf_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
63: ,p_bill_rate_override IN pa_assignments_history.bill_rate_override%TYPE := FND_API.G_MISS_NUM
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
64: ,p_bill_rate_curr_override IN pa_assignments_history.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
65: ,p_markup_percent_override IN pa_assignments_history.markup_percent_override%TYPE := FND_API.G_MISS_NUM
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
66: ,p_tp_rate_override IN pa_assignments_history.tp_rate_override%TYPE := FND_API.G_MISS_NUM
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
67: ,p_tp_currency_override IN pa_assignments_history.tp_currency_override%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
68: ,p_tp_calc_base_code_override IN pa_assignments_history.tp_calc_base_code_override%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
69: ,p_tp_percent_applied_override IN pa_assignments_history.tp_percent_applied_override%TYPE := FND_API.G_MISS_NUM
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
70: ,p_markup_percent IN pa_assignments_history.markup_percent%TYPE := FND_API.G_MISS_NUM
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
71: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
73: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
74: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
75: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
76: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
77: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
78: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
79: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
80: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
81: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
82: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
83: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
84: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
85: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
86: /* Added 2 columns for 3051110 */
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
87: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
88: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
89: /* Added 2 columns for 3041583 */
90: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
91: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
92: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
93: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: );
99: ( p_assignment_row_id IN ROWID :=NULL
100: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
101: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
102: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
103: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
100: ,p_assignment_id IN pa_assignments_history.assignment_id%TYPE
101: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
102: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
103: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
101: ,p_change_id IN pa_assignments_history.change_id%TYPE :=NULL
102: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
103: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
102: ,p_last_approved_flag IN pa_assignments_history.last_approved_flag%TYPE :=NULL
103: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
103: ,p_record_version_number IN pa_assignments_history.record_version_number%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
104: ,p_assignment_name IN pa_assignments_history.assignment_name%TYPE := FND_API.G_MISS_CHAR
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
105: ,p_assignment_type IN pa_assignments_history.assignment_type%TYPE := FND_API.G_MISS_CHAR
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
106: ,p_multiple_status_flag IN pa_assignments_history.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
107: ,p_apprvl_status_code IN pa_assignments_history.apprvl_status_code%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
108: ,p_status_code IN pa_assignments_history.status_code%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
109: ,p_staffing_priority_code IN pa_assignments_history.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
110: ,p_staffing_owner_person_id IN pa_assignments_history.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
111: ,p_project_id IN pa_assignments_history.project_id%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
112: ,p_project_role_id IN pa_assignments_history.project_role_id%TYPE := FND_API.G_MISS_NUM
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_project_party_id IN pa_assignments_history.project_party_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
114: ,p_project_subteam_id IN pa_assignments_history.project_subteam_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
115: ,p_description IN pa_assignments_history.description%TYPE := FND_API.G_MISS_CHAR
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
116: ,p_note_to_approver IN pa_assignments_history.note_to_approver%TYPE := FND_API.G_MISS_CHAR
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
117: ,p_start_date IN pa_assignments_history.start_date%TYPE := FND_API.G_MISS_DATE
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
118: ,p_end_date IN pa_assignments_history.end_date%TYPE := FND_API.G_MISS_DATE
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
119: ,p_assignment_effort IN pa_assignments_history.assignment_effort%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
120: ,p_extension_possible IN pa_assignments_history.extension_possible%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
121: ,p_source_assignment_id IN pa_assignments_history.source_assignment_id%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
122: ,p_assignment_template_id IN pa_assignments_history.assignment_template_id%TYPE := FND_API.G_MISS_NUM
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
123: ,p_min_resource_job_level IN pa_assignments_history.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
124: ,p_max_resource_job_level IN pa_assignments_history.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
125: ,p_assignment_number IN pa_assignments_history.assignment_number%TYPE := FND_API.G_MISS_NUM
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
126: ,p_additional_information IN pa_assignments_history.additional_information%TYPE := FND_API.G_MISS_CHAR
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
127: ,p_work_type_id IN pa_assignments_history.work_type_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
128: ,p_revenue_currency_code IN pa_assignments_history.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
129: ,p_revenue_bill_rate IN pa_assignments_history.revenue_bill_rate%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
130: ,p_expense_owner IN pa_assignments_history.expense_owner%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
131: ,p_expense_limit IN pa_assignments_history.expense_limit%TYPE := FND_API.G_MISS_NUM
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
132: ,p_expense_limit_currency_code IN pa_assignments_history.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
133: ,p_fcst_tp_amount_type IN pa_assignments_history.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
134: ,p_fcst_job_id IN pa_assignments_history.fcst_job_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
135: ,p_fcst_job_group_id IN pa_assignments_history.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
136: ,p_expenditure_org_id IN pa_assignments_history.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
137: ,p_expenditure_organization_id IN pa_assignments_history.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
138: ,p_expenditure_type_class IN pa_assignments_history.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
139: ,p_expenditure_type IN pa_assignments_history.expenditure_type%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
140: ,p_location_id IN pa_assignments_history.location_id%TYPE := FND_API.G_MISS_NUM
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
141: ,p_calendar_type IN pa_assignments_history.calendar_type%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
142: ,p_calendar_id IN pa_assignments_history.calendar_id%TYPE := FND_API.G_MISS_NUM
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
143: ,p_resource_calendar_percent IN pa_assignments_history.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
144: ,p_pending_approval_flag IN pa_assignments_history.pending_approval_flag%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
145: ,p_no_of_active_candidates IN pa_assignments_history.no_of_active_candidates%TYPE := FND_API.G_MISS_NUM
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
146: ,p_attribute_category IN pa_assignments_history.attribute_category%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
147: ,p_attribute1 IN pa_assignments_history.attribute1%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
148: ,p_attribute2 IN pa_assignments_history.attribute2%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
149: ,p_attribute3 IN pa_assignments_history.attribute3%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
150: ,p_attribute4 IN pa_assignments_history.attribute4%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
151: ,p_attribute5 IN pa_assignments_history.attribute5%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
152: ,p_attribute6 IN pa_assignments_history.attribute6%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
153: ,p_attribute7 IN pa_assignments_history.attribute7%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
154: ,p_attribute8 IN pa_assignments_history.attribute8%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
155: ,p_attribute9 IN pa_assignments_history.attribute9%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
156: ,p_attribute10 IN pa_assignments_history.attribute10%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute11 IN pa_assignments_history.attribute11%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute12 IN pa_assignments_history.attribute12%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
165: /* Added 2 columns for 3041583 */
159: ,p_attribute13 IN pa_assignments_history.attribute13%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
165: /* Added 2 columns for 3041583 */
166: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
167: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute14 IN pa_assignments_history.attribute14%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute15 IN pa_assignments_history.attribute15%TYPE := FND_API.G_MISS_CHAR
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
165: /* Added 2 columns for 3041583 */
166: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
167: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
168: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: /* Added 2 columns for 3051110 */
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
165: /* Added 2 columns for 3041583 */
166: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
167: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
168: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: );
170:
163: ,p_transfer_price_rate IN pa_project_assignments.transfer_price_rate%TYPE := FND_API.G_MISS_NUM
164: ,p_transfer_pr_rate_curr IN pa_project_assignments.transfer_pr_rate_curr%TYPE := FND_API.G_MISS_CHAR
165: /* Added 2 columns for 3041583 */
166: ,p_discount_percentage IN pa_assignments_history.discount_percentage%TYPE := FND_API.G_MISS_NUM
167: ,p_rate_disc_reason_code IN pa_assignments_history.rate_disc_reason_code%TYPE := FND_API.G_MISS_CHAR
168: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: );
170:
171: