1. 利用update_emp_asg 来update supervisor
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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17087603/viewspace-670864/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17087603/viewspace-670864/