39: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
40: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
40: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
42: ,p_project_title IN per_all_assignments_f.project_title%TYPE
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
43: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
44: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
45: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
46: ,p_rate_value IN pay_grade_rules_f.value%TYPE
47: ,p_rate_effective_start_date OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
48: ,p_rate_effective_end_date OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
49: ,p_rate_object_version_number OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
50: --
51: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
52: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
53: ,p_email_address IN per_all_people_f.email_address%TYPE
791: --
792: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
792: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;
793: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;
801: l_dummy_v VARCHAR2(240);
794: --
795: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
796: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
797: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
798: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
799: --
800: l_dummy_n NUMBER;
801: l_dummy_v VARCHAR2(240);
802: l_dummy_d DATE;
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2715: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2716: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2717: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2718: --
2719: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2720: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2721: ,p_email_address IN per_all_people_f.email_address%TYPE
3459: --
3460: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3461: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3462: --
3463: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3464: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3465: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3466: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3467: --
3460: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3461: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3462: --
3463: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3464: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3465: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3466: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3467: --
3468: l_party_id per_all_people_f.party_id%TYPE;
3461: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3462: --
3463: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3464: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3465: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3466: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3467: --
3468: l_party_id per_all_people_f.party_id%TYPE;
3469: --
3462: --
3463: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3464: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3465: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3466: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3467: --
3468: l_party_id per_all_people_f.party_id%TYPE;
3469: --
3470: l_gsp_post_process_warning varchar2(30); -- bug2999562
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7007: --CWK
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7007: --CWK
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE