更新人员分配信息

          
DECLARE
    lv_ovn                          NUMBER;
    lv_effect_start_date            DATE;
    lv_update_mode                  VARCHAR2 (100);
    lv_cagr_grade_def_id            NUMBER;
    lv_cagr_concatenated_segments   VARCHAR2 (240);
    lv_soft_coding_keyflex_id       NUMBER             := NULL;
    lv_comment_id                   NUMBER;
    lv_people_group_id              NUMBER             := NULL;
    lv_special_ceiling_step_id      NUMBER             := NULL;
    lv_no_managers_warning          BOOLEAN;
    lv_hourly_salaried_warning      BOOLEAN;
    lv_group_name                   VARCHAR2 (240);
    lv_effective_start_date         DATE;
    lv_effective_end_date           DATE;
    lv_effective_date               DATE;
    lv_org_now_no_manager_warning   BOOLEAN;
    lv_other_manager_warning        BOOLEAN;
    lv_spp_delete_warning           BOOLEAN;
    lv_entries_changed_warning      VARCHAR2 (240);
    lv_tax_changed_warning          BOOLEAN;
    lv_concatenated_segments        VARCHAR2 (240);
    lv_gsp_post_process_warning     VARCHAR2 (240);
    lv_error_msg                    VARCHAR2 (4000);
    lv_assignment_id                NUMBER;
    lv_supervisor_id                per_all_assignments_f.supervisor_id%type;
    lv_commerce_id                  apc_hr_employees.commerce_id%type;
    CURSOR csr_ovn (lv_assign_id NUMBER)
    IS
       SELECT MAX (object_version_number)
         FROM per_assignments_f
        WHERE assignment_id = lv_assign_id;

BEGIN

      BEGIN
         OPEN csr_ovn (lv_assignment_id );
          FETCH csr_ovn
           INTO lv_ovn;
          CLOSE csr_ovn;

          BEGIN
             SELECT effective_start_date
               INTO lv_effect_start_date
               FROM per_all_assignments_f
              WHERE assignment_id = lv_assignment_id               --44836
                AND object_version_number = lv_ovn;
          EXCEPTION
             WHEN OTHERS
             THEN
                DBMS_OUTPUT.put_line ('Error:' || SUBSTR (SQLERRM, 1, 200));
          END;
          IF TRUNC(lv_effect_start_date) = TRUNC(lv_effective_date)
          THEN
             lv_update_mode := hr_api.g_correction;
          ELSE
             lv_update_mode := hr_api.g_update;
          END IF;
           
       EXCEPTION
          WHEN OTHERS
          THEN
             DBMS_OUTPUT.put_line ('Error:' || SUBSTR (SQLERRM, 1, 200));
       END;

hr_assignment_api.update_emp_asg
             (p_validate                          => FALSE,
              p_effective_date                    => lv_effective_date,
              p_datetrack_update_mode             =>lv_update_mode,
              p_assignment_id                     => lv_assignment_id ,
              p_object_version_number             => lv_ovn,
              p_supervisor_id                     => lv_supervisor_id,
              p_assignment_number                 => hr_api.g_varchar2,
              p_change_reason                     => hr_api.g_varchar2,
              p_assignment_status_type_id         => hr_api.g_number,
              p_comments                          => hr_api.g_varchar2,
              p_date_probation_end                => hr_api.g_date,
              p_default_code_comb_id              => hr_api.g_number,
              p_frequency                         => hr_api.g_varchar2,
              p_internal_address_line             => hr_api.g_varchar2,
              p_manager_flag                      => hr_api.g_varchar2,
              p_normal_hours                      => hr_api.g_number,
              p_perf_review_period                => hr_api.g_number,
              p_perf_review_period_frequency      => hr_api.g_varchar2,
              p_probation_period                  => hr_api.g_number,
              p_probation_unit                    => hr_api.g_varchar2,
              p_sal_review_period                 => hr_api.g_number,
              p_sal_review_period_frequency       => hr_api.g_varchar2,
              p_set_of_books_id                   => hr_api.g_number,
              p_source_type                       => hr_api.g_varchar2,
              p_time_normal_finish                => hr_api.g_varchar2,
              p_time_normal_start                 => hr_api.g_varchar2,
              p_bargaining_unit_code              => hr_api.g_varchar2,
              p_labour_union_member_flag          => hr_api.g_varchar2,
              p_hourly_salaried_code              => hr_api.g_varchar2,
              p_ass_attribute_category            => hr_api.g_varchar2,
              p_ass_attribute1                    => hr_api.g_varchar2,
              p_ass_attribute2                    => hr_api.g_varchar2,
              p_ass_attribute3                    => hr_api.g_varchar2,
              p_ass_attribute4                    => hr_api.g_varchar2,
              p_ass_attribute5                    => hr_api.g_varchar2,
              p_ass_attribute6                    => hr_api.g_varchar2,
              p_ass_attribute7                    => hr_api.g_varchar2,
              p_ass_attribute8                    => hr_api.g_varchar2,
              p_ass_attribute9                    => hr_api.g_varchar2,
              p_ass_attribute10                   => hr_api.g_varchar2,
              p_ass_attribute11                   => hr_api.g_varchar2,
              p_ass_attribute12                   => hr_api.g_varchar2,
              p_ass_attribute13                   => hr_api.g_varchar2,
              p_ass_attribute14                   => hr_api.g_varchar2,
              p_ass_attribute15                   => hr_api.g_varchar2,
              p_ass_attribute16                   => hr_api.g_varchar2,
              p_ass_attribute17                   => hr_api.g_varchar2,
              p_ass_attribute18                   => hr_api.g_varchar2,
              p_ass_attribute19                   => hr_api.g_varchar2,
              p_ass_attribute20                   => hr_api.g_varchar2,
              p_ass_attribute21                   => hr_api.g_varchar2,
              p_ass_attribute22                   => hr_api.g_varchar2,
              p_ass_attribute23                   => hr_api.g_varchar2,
              p_ass_attribute24                   => hr_api.g_varchar2,
              p_ass_attribute25                   => hr_api.g_varchar2,
              p_ass_attribute26                   => hr_api.g_varchar2,
              p_ass_attribute27                   => hr_api.g_varchar2,
              p_ass_attribute28                   => hr_api.g_varchar2,
              p_ass_attribute29                   => hr_api.g_varchar2,
              p_ass_attribute30                   => hr_api.g_varchar2,
              p_title                             => hr_api.g_varchar2,
              --,p_employer_id                   => c_rec.employer_id
              --,p_tax_area_code                 => c_rec.tax_area
              --,p_sic_area_code                 => c_rec.sic_area
              --,p_salary_payout_locn            => c_rec.salary_payout_locn
              --,p_special_tax_exmp_category     => c_rec.special_tax_exemp_cat_code
              p_concat_segments                   => NULL,
              p_contract_id                       => hr_api.g_number,
              p_establishment_id                  => hr_api.g_number,
              p_collective_agreement_id           => hr_api.g_number,
              p_cagr_id_flex_num                  => hr_api.g_number,
              p_cag_segment1                      => hr_api.g_varchar2,
              p_cag_segment2                      => hr_api.g_varchar2,
              p_cag_segment3                      => hr_api.g_varchar2,
              p_cag_segment4                      => hr_api.g_varchar2,
              p_cag_segment5                      => hr_api.g_varchar2,
              p_cag_segment6                      => hr_api.g_varchar2,
              p_cag_segment7                      => hr_api.g_varchar2,
              p_cag_segment8                      => hr_api.g_varchar2,
              p_cag_segment9                      => hr_api.g_varchar2,
              p_cag_segment10                     => hr_api.g_varchar2,
              p_cag_segment11                     => hr_api.g_varchar2,
              p_cag_segment12                     => hr_api.g_varchar2,
              p_cag_segment13                     => hr_api.g_varchar2,
              p_cag_segment14                     => hr_api.g_varchar2,
              p_cag_segment15                     => hr_api.g_varchar2,
              p_cag_segment16                     => hr_api.g_varchar2,
              p_cag_segment17                     => hr_api.g_varchar2,
              p_cag_segment18                     => hr_api.g_varchar2,
              p_cag_segment19                     => hr_api.g_varchar2,
              p_cag_segment20                     => hr_api.g_varchar2,
              p_notice_period                     => hr_api.g_number,
              p_notice_period_uom                 => hr_api.g_varchar2,
              p_employee_category                 => hr_api.g_varchar2,
              p_work_at_home                      => hr_api.g_varchar2,
              p_job_post_source_name              => hr_api.g_varchar2,
              p_cagr_grade_def_id                 => lv_cagr_grade_def_id,
              p_cagr_concatenated_segments        => lv_cagr_concatenated_segments,
              p_concatenated_segments             => lv_concatenated_segments,
              p_soft_coding_keyflex_id            => lv_soft_coding_keyflex_id,
              p_comment_id                        => lv_comment_id,
              p_effective_start_date              => lv_effective_start_date,
              p_effective_end_date                => lv_effective_end_date,
              p_no_managers_warning               => lv_no_managers_warning,
              p_other_manager_warning             => lv_other_manager_warning,
              p_hourly_salaried_warning           => lv_hourly_salaried_warning
             );
END;