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;
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE
2749: ,p_rate_effective_start_date IN OUT NOCOPY pay_grade_rules_f.effective_start_date%TYPE
2750: ,p_rate_effective_end_date IN OUT NOCOPY pay_grade_rules_f.effective_end_date%TYPE
2751: ,p_rate_object_version_number IN OUT NOCOPY pay_grade_rules_f.object_version_number%TYPE
2752: --
2753: ,p_date_employee_data_verified IN per_all_people_f.date_employee_data_verified%TYPE
2754: ,p_date_of_birth IN per_all_people_f.date_of_birth%TYPE
2755: ,p_email_address IN per_all_people_f.email_address%TYPE
3493: --
3494: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3494: l_checklist_item_id per_checklist_items.checklist_item_id%TYPE;
3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3495: l_chk_object_version_number per_checklist_items.object_version_number%TYPE;
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3503: --
3496: --
3497: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
3498: l_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
3499: l_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
3500: l_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE;
3501: --
3502: l_party_id per_all_people_f.party_id%TYPE;
3503: --
3504: l_gsp_post_process_warning varchar2(30); -- bug2999562
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE