[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select * into l_info_new
from ben_cwb_person_info
where group_per_in_ler_id = p_info_old.group_per_in_ler_id;
select group_pl_id,lf_evt_ocrd_dt
into l_group_pl_id, l_lf_evt_ocrd_dt
from ben_per_in_ler
where per_in_ler_id = p_info_old.group_per_in_ler_id;
select employee_id into l_person_id
from fnd_user
where user_id = l_info_new.last_updated_by;
procedure update_person_info
(p_validate in boolean default false
,p_group_per_in_ler_id in number
,p_assignment_id in number default hr_api.g_number
,p_person_id in number default hr_api.g_number
,p_supervisor_id in number default hr_api.g_number
,p_effective_date in date default hr_api.g_date
,p_full_name in varchar2 default hr_api.g_varchar2
,p_brief_name in varchar2 default hr_api.g_varchar2
,p_custom_name in varchar2 default hr_api.g_varchar2
,p_supervisor_full_name in varchar2 default hr_api.g_varchar2
,p_supervisor_brief_name in varchar2 default hr_api.g_varchar2
,p_supervisor_custom_name in varchar2 default hr_api.g_varchar2
,p_legislation_code in varchar2 default hr_api.g_varchar2
,p_years_employed in number default hr_api.g_number
,p_years_in_job in number default hr_api.g_number
,p_years_in_position in number default hr_api.g_number
,p_years_in_grade in number default hr_api.g_number
,p_employee_number in varchar2 default hr_api.g_varchar2
,p_start_date in date default hr_api.g_date
,p_original_start_date in date default hr_api.g_date
,p_adjusted_svc_date in date default hr_api.g_date
,p_base_salary in number default hr_api.g_number
,p_base_salary_change_date in date default hr_api.g_date
,p_payroll_name in varchar2 default hr_api.g_varchar2
,p_performance_rating in varchar2 default hr_api.g_varchar2
,p_performance_rating_type in varchar2 default hr_api.g_varchar2
,p_performance_rating_date in date default hr_api.g_date
,p_business_group_id in number default hr_api.g_number
,p_organization_id in number default hr_api.g_number
,p_job_id in number default hr_api.g_number
,p_grade_id in number default hr_api.g_number
,p_position_id in number default hr_api.g_number
,p_people_group_id in number default hr_api.g_number
,p_soft_coding_keyflex_id in number default hr_api.g_number
,p_location_id in number default hr_api.g_number
,p_pay_rate_id in number default hr_api.g_number
,p_assignment_status_type_id in Number default hr_api.g_number
,p_frequency in varchar2 default hr_api.g_varchar2
,p_grade_annulization_factor in number default hr_api.g_number
,p_pay_annulization_factor in number default hr_api.g_number
,p_grd_min_val in number default hr_api.g_number
,p_grd_max_val in number default hr_api.g_number
,p_grd_mid_point in number default hr_api.g_number
,p_grd_quartile in varchar2 default hr_api.g_varchar2
,p_grd_comparatio in Number default hr_api.g_number
,p_emp_category in varchar2 default hr_api.g_varchar2
,p_change_reason in varchar2 default hr_api.g_varchar2
,p_normal_hours in number default hr_api.g_number
,p_email_address in varchar2 default hr_api.g_varchar2
,p_base_salary_frequency in varchar2 default hr_api.g_varchar2
,p_new_assgn_ovn in number default hr_api.g_number
,p_new_perf_event_id in number default hr_api.g_number
,p_new_perf_review_id in number default hr_api.g_number
,p_post_process_stat_cd in varchar2 default hr_api.g_varchar2
,p_feedback_rating in varchar2 default hr_api.g_varchar2
,p_feedback_comments in varchar2 default hr_api.g_varchar2
,p_custom_segment1 in Varchar2 default hr_api.g_varchar2
,p_custom_segment2 in Varchar2 default hr_api.g_varchar2
,p_custom_segment3 in Varchar2 default hr_api.g_varchar2
,p_custom_segment4 in Varchar2 default hr_api.g_varchar2
,p_custom_segment5 in Varchar2 default hr_api.g_varchar2
,p_custom_segment6 in Varchar2 default hr_api.g_varchar2
,p_custom_segment7 in Varchar2 default hr_api.g_varchar2
,p_custom_segment8 in Varchar2 default hr_api.g_varchar2
,p_custom_segment9 in Varchar2 default hr_api.g_varchar2
,p_custom_segment10 in Varchar2 default hr_api.g_varchar2
,p_custom_segment11 in number default hr_api.g_number
,p_custom_segment12 in number default hr_api.g_number
,p_custom_segment13 in number default hr_api.g_number
,p_custom_segment14 in number default hr_api.g_number
,p_custom_segment15 in number default hr_api.g_number
,p_custom_segment16 in number default hr_api.g_number
,p_custom_segment17 in number default hr_api.g_number
,p_custom_segment18 in number default hr_api.g_number
,p_custom_segment19 in number default hr_api.g_number
,p_custom_segment20 in number default hr_api.g_number
,p_ass_attribute_category in Varchar2 default hr_api.g_varchar2
,p_ass_attribute1 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute2 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute3 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute4 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute5 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute6 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute7 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute8 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute9 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute10 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute11 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute12 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute13 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute14 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute15 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute16 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute17 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute18 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute19 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute20 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute21 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute22 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute23 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute24 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute25 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute26 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute27 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute28 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute29 in Varchar2 default hr_api.g_varchar2
,p_ass_attribute30 in Varchar2 default hr_api.g_varchar2
,p_ws_comments in Varchar2 default hr_api.g_varchar2
,p_people_group_name in varchar2 default hr_api.g_varchar2
,p_people_group_segment1 in varchar2 default hr_api.g_varchar2
,p_people_group_segment2 in varchar2 default hr_api.g_varchar2
,p_people_group_segment3 in varchar2 default hr_api.g_varchar2
,p_people_group_segment4 in varchar2 default hr_api.g_varchar2
,p_people_group_segment5 in varchar2 default hr_api.g_varchar2
,p_people_group_segment6 in varchar2 default hr_api.g_varchar2
,p_people_group_segment7 in varchar2 default hr_api.g_varchar2
,p_people_group_segment8 in varchar2 default hr_api.g_varchar2
,p_people_group_segment9 in varchar2 default hr_api.g_varchar2
,p_people_group_segment10 in varchar2 default hr_api.g_varchar2
,p_people_group_segment11 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute_category in varchar2 default hr_api.g_varchar2
,p_cpi_attribute1 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute2 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute3 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute4 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute5 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute6 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute7 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute8 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute9 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute10 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute11 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute12 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute13 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute14 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute15 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute16 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute17 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute18 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute19 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute20 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute21 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute22 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute23 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute24 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute25 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute26 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute27 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute28 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute29 in varchar2 default hr_api.g_varchar2
,p_cpi_attribute30 in varchar2 default hr_api.g_varchar2
,p_feedback_date in date default hr_api.g_date
,p_object_version_number in out nocopy number
) is
--
-- Declare cursors and local variables
--
l_object_version_number number;
l_proc varchar2(72) := g_package||'update_person_info';
select * into l_old_record
from ben_cwb_person_info
where group_per_in_ler_id = p_group_per_in_ler_id;
savepoint update_person_info;
ben_cwb_person_info_bk2.update_person_info_b
(p_group_per_in_ler_id => p_group_per_in_ler_id
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_supervisor_id => p_supervisor_id
,p_effective_date => p_effective_date
,p_full_name => p_full_name
,p_brief_name => p_brief_name
,p_custom_name => p_custom_name
,p_supervisor_full_name => p_supervisor_full_name
,p_supervisor_brief_name => p_supervisor_brief_name
,p_supervisor_custom_name => p_supervisor_custom_name
,p_legislation_code => p_legislation_code
,p_years_employed => p_years_employed
,p_years_in_job => p_years_in_job
,p_years_in_position => p_years_in_position
,p_years_in_grade => p_years_in_grade
,p_employee_number => p_employee_number
,p_start_date => p_start_date
,p_original_start_date => p_original_start_date
,p_adjusted_svc_date => p_adjusted_svc_date
,p_base_salary => p_base_salary
,p_base_salary_change_date => p_base_salary_change_date
,p_payroll_name => p_payroll_name
,p_performance_rating => p_performance_rating
,p_performance_rating_type => p_performance_rating_type
,p_performance_rating_date => p_performance_rating_date
,p_business_group_id => p_business_group_id
,p_organization_id => p_organization_id
,p_job_id => p_job_id
,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_people_group_id => p_people_group_id
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_location_id => p_location_id
,p_pay_rate_id => p_pay_rate_id
,p_assignment_status_type_id => p_assignment_status_type_id
,p_frequency => p_frequency
,p_grade_annulization_factor => p_grade_annulization_factor
,p_pay_annulization_factor => p_pay_annulization_factor
,p_grd_min_val => p_grd_min_val
,p_grd_max_val => p_grd_max_val
,p_grd_mid_point => p_grd_mid_point
,p_grd_quartile => p_grd_quartile
,p_grd_comparatio => p_grd_comparatio
,p_emp_category => p_emp_category
,p_change_reason => p_change_reason
,p_normal_hours => p_normal_hours
,p_email_address => p_email_address
,p_base_salary_frequency => p_base_salary_frequency
,p_new_assgn_ovn => p_new_assgn_ovn
,p_new_perf_event_id => p_new_perf_event_id
,p_new_perf_review_id => p_new_perf_review_id
,p_post_process_stat_cd => p_post_process_stat_cd
,p_feedback_rating => p_feedback_rating
,p_feedback_comments => p_feedback_comments
,p_custom_segment1 => p_custom_segment1
,p_custom_segment2 => p_custom_segment2
,p_custom_segment3 => p_custom_segment3
,p_custom_segment4 => p_custom_segment4
,p_custom_segment5 => p_custom_segment5
,p_custom_segment6 => p_custom_segment6
,p_custom_segment7 => p_custom_segment7
,p_custom_segment8 => p_custom_segment8
,p_custom_segment9 => p_custom_segment9
,p_custom_segment10 => p_custom_segment10
,p_custom_segment11 => p_custom_segment11
,p_custom_segment12 => p_custom_segment12
,p_custom_segment13 => p_custom_segment13
,p_custom_segment14 => p_custom_segment14
,p_custom_segment15 => p_custom_segment15
,p_custom_segment16 => p_custom_segment16
,p_custom_segment17 => p_custom_segment17
,p_custom_segment18 => p_custom_segment18
,p_custom_segment19 => p_custom_segment19
,p_custom_segment20 => p_custom_segment20
,p_ass_attribute_category => p_ass_attribute_category
,p_ass_attribute1 => p_ass_attribute1
,p_ass_attribute2 => p_ass_attribute2
,p_ass_attribute3 => p_ass_attribute3
,p_ass_attribute4 => p_ass_attribute4
,p_ass_attribute5 => p_ass_attribute5
,p_ass_attribute6 => p_ass_attribute6
,p_ass_attribute7 => p_ass_attribute7
,p_ass_attribute8 => p_ass_attribute8
,p_ass_attribute9 => p_ass_attribute9
,p_ass_attribute10 => p_ass_attribute10
,p_ass_attribute11 => p_ass_attribute11
,p_ass_attribute12 => p_ass_attribute12
,p_ass_attribute13 => p_ass_attribute13
,p_ass_attribute14 => p_ass_attribute14
,p_ass_attribute15 => p_ass_attribute15
,p_ass_attribute16 => p_ass_attribute16
,p_ass_attribute17 => p_ass_attribute17
,p_ass_attribute18 => p_ass_attribute18
,p_ass_attribute19 => p_ass_attribute19
,p_ass_attribute20 => p_ass_attribute20
,p_ass_attribute21 => p_ass_attribute21
,p_ass_attribute22 => p_ass_attribute22
,p_ass_attribute23 => p_ass_attribute23
,p_ass_attribute24 => p_ass_attribute24
,p_ass_attribute25 => p_ass_attribute25
,p_ass_attribute26 => p_ass_attribute26
,p_ass_attribute27 => p_ass_attribute27
,p_ass_attribute28 => p_ass_attribute28
,p_ass_attribute29 => p_ass_attribute29
,p_ass_attribute30 => p_ass_attribute30
,p_ws_comments => p_ws_comments
,p_people_group_name => p_people_group_name
,p_people_group_segment1 => p_people_group_segment1
,p_people_group_segment2 => p_people_group_segment2
,p_people_group_segment3 => p_people_group_segment3
,p_people_group_segment4 => p_people_group_segment4
,p_people_group_segment5 => p_people_group_segment5
,p_people_group_segment6 => p_people_group_segment6
,p_people_group_segment7 => p_people_group_segment7
,p_people_group_segment8 => p_people_group_segment8
,p_people_group_segment9 => p_people_group_segment9
,p_people_group_segment10 => p_people_group_segment10
,p_people_group_segment11 => p_people_group_segment11
,p_cpi_attribute_category => p_cpi_attribute_category
,p_cpi_attribute1 => p_cpi_attribute1
,p_cpi_attribute2 => p_cpi_attribute2
,p_cpi_attribute3 => p_cpi_attribute3
,p_cpi_attribute4 => p_cpi_attribute4
,p_cpi_attribute5 => p_cpi_attribute5
,p_cpi_attribute6 => p_cpi_attribute6
,p_cpi_attribute7 => p_cpi_attribute7
,p_cpi_attribute8 => p_cpi_attribute8
,p_cpi_attribute9 => p_cpi_attribute9
,p_cpi_attribute10 => p_cpi_attribute10
,p_cpi_attribute11 => p_cpi_attribute11
,p_cpi_attribute12 => p_cpi_attribute12
,p_cpi_attribute13 => p_cpi_attribute13
,p_cpi_attribute14 => p_cpi_attribute14
,p_cpi_attribute15 => p_cpi_attribute15
,p_cpi_attribute16 => p_cpi_attribute16
,p_cpi_attribute17 => p_cpi_attribute17
,p_cpi_attribute18 => p_cpi_attribute18
,p_cpi_attribute19 => p_cpi_attribute19
,p_cpi_attribute20 => p_cpi_attribute20
,p_cpi_attribute21 => p_cpi_attribute21
,p_cpi_attribute22 => p_cpi_attribute22
,p_cpi_attribute23 => p_cpi_attribute23
,p_cpi_attribute24 => p_cpi_attribute24
,p_cpi_attribute25 => p_cpi_attribute25
,p_cpi_attribute26 => p_cpi_attribute26
,p_cpi_attribute27 => p_cpi_attribute27
,p_cpi_attribute28 => p_cpi_attribute28
,p_cpi_attribute29 => p_cpi_attribute29
,p_cpi_attribute30 => p_cpi_attribute30
,p_feedback_date => p_feedback_date
,p_object_version_number => l_object_version_number
);
(p_module_name => 'UPDATE_PERSON_INFO'
,p_hook_type => 'BP'
);
ben_cwb_person_info_bk2.update_person_info_a
(p_group_per_in_ler_id => p_group_per_in_ler_id
,p_assignment_id => p_assignment_id
,p_person_id => p_person_id
,p_supervisor_id => p_supervisor_id
,p_effective_date => p_effective_date
,p_full_name => p_full_name
,p_brief_name => p_brief_name
,p_custom_name => p_custom_name
,p_supervisor_full_name => p_supervisor_full_name
,p_supervisor_brief_name => p_supervisor_brief_name
,p_supervisor_custom_name => p_supervisor_custom_name
,p_legislation_code => p_legislation_code
,p_years_employed => p_years_employed
,p_years_in_job => p_years_in_job
,p_years_in_position => p_years_in_position
,p_years_in_grade => p_years_in_grade
,p_employee_number => p_employee_number
,p_start_date => p_start_date
,p_original_start_date => p_original_start_date
,p_adjusted_svc_date => p_adjusted_svc_date
,p_base_salary => p_base_salary
,p_base_salary_change_date => p_base_salary_change_date
,p_payroll_name => p_payroll_name
,p_performance_rating => p_performance_rating
,p_performance_rating_type => p_performance_rating_type
,p_performance_rating_date => p_performance_rating_date
,p_business_group_id => p_business_group_id
,p_organization_id => p_organization_id
,p_job_id => p_job_id
,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_people_group_id => p_people_group_id
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_location_id => p_location_id
,p_pay_rate_id => p_pay_rate_id
,p_assignment_status_type_id => p_assignment_status_type_id
,p_frequency => p_frequency
,p_grade_annulization_factor => p_grade_annulization_factor
,p_pay_annulization_factor => p_pay_annulization_factor
,p_grd_min_val => p_grd_min_val
,p_grd_max_val => p_grd_max_val
,p_grd_mid_point => p_grd_mid_point
,p_grd_quartile => p_grd_quartile
,p_grd_comparatio => p_grd_comparatio
,p_emp_category => p_emp_category
,p_change_reason => p_change_reason
,p_normal_hours => p_normal_hours
,p_email_address => p_email_address
,p_base_salary_frequency => p_base_salary_frequency
,p_new_assgn_ovn => p_new_assgn_ovn
,p_new_perf_event_id => p_new_perf_event_id
,p_new_perf_review_id => p_new_perf_review_id
,p_post_process_stat_cd => p_post_process_stat_cd
,p_feedback_rating => p_feedback_rating
,p_feedback_comments => p_feedback_comments
,p_custom_segment1 => p_custom_segment1
,p_custom_segment2 => p_custom_segment2
,p_custom_segment3 => p_custom_segment3
,p_custom_segment4 => p_custom_segment4
,p_custom_segment5 => p_custom_segment5
,p_custom_segment6 => p_custom_segment6
,p_custom_segment7 => p_custom_segment7
,p_custom_segment8 => p_custom_segment8
,p_custom_segment9 => p_custom_segment9
,p_custom_segment10 => p_custom_segment10
,p_custom_segment11 => p_custom_segment11
,p_custom_segment12 => p_custom_segment12
,p_custom_segment13 => p_custom_segment13
,p_custom_segment14 => p_custom_segment14
,p_custom_segment15 => p_custom_segment15
,p_custom_segment16 => p_custom_segment16
,p_custom_segment17 => p_custom_segment17
,p_custom_segment18 => p_custom_segment18
,p_custom_segment19 => p_custom_segment19
,p_custom_segment20 => p_custom_segment20
,p_ass_attribute_category => p_ass_attribute_category
,p_ass_attribute1 => p_ass_attribute1
,p_ass_attribute2 => p_ass_attribute2
,p_ass_attribute3 => p_ass_attribute3
,p_ass_attribute4 => p_ass_attribute4
,p_ass_attribute5 => p_ass_attribute5
,p_ass_attribute6 => p_ass_attribute6
,p_ass_attribute7 => p_ass_attribute7
,p_ass_attribute8 => p_ass_attribute8
,p_ass_attribute9 => p_ass_attribute9
,p_ass_attribute10 => p_ass_attribute10
,p_ass_attribute11 => p_ass_attribute11
,p_ass_attribute12 => p_ass_attribute12
,p_ass_attribute13 => p_ass_attribute13
,p_ass_attribute14 => p_ass_attribute14
,p_ass_attribute15 => p_ass_attribute15
,p_ass_attribute16 => p_ass_attribute16
,p_ass_attribute17 => p_ass_attribute17
,p_ass_attribute18 => p_ass_attribute18
,p_ass_attribute19 => p_ass_attribute19
,p_ass_attribute20 => p_ass_attribute20
,p_ass_attribute21 => p_ass_attribute21
,p_ass_attribute22 => p_ass_attribute22
,p_ass_attribute23 => p_ass_attribute23
,p_ass_attribute24 => p_ass_attribute24
,p_ass_attribute25 => p_ass_attribute25
,p_ass_attribute26 => p_ass_attribute26
,p_ass_attribute27 => p_ass_attribute27
,p_ass_attribute28 => p_ass_attribute28
,p_ass_attribute29 => p_ass_attribute29
,p_ass_attribute30 => p_ass_attribute30
,p_ws_comments => p_ws_comments
,p_people_group_name => p_people_group_name
,p_people_group_segment1 => p_people_group_segment1
,p_people_group_segment2 => p_people_group_segment2
,p_people_group_segment3 => p_people_group_segment3
,p_people_group_segment4 => p_people_group_segment4
,p_people_group_segment5 => p_people_group_segment5
,p_people_group_segment6 => p_people_group_segment6
,p_people_group_segment7 => p_people_group_segment7
,p_people_group_segment8 => p_people_group_segment8
,p_people_group_segment9 => p_people_group_segment9
,p_people_group_segment10 => p_people_group_segment10
,p_people_group_segment11 => p_people_group_segment11
,p_cpi_attribute_category => p_cpi_attribute_category
,p_cpi_attribute1 => p_cpi_attribute1
,p_cpi_attribute2 => p_cpi_attribute2
,p_cpi_attribute3 => p_cpi_attribute3
,p_cpi_attribute4 => p_cpi_attribute4
,p_cpi_attribute5 => p_cpi_attribute5
,p_cpi_attribute6 => p_cpi_attribute6
,p_cpi_attribute7 => p_cpi_attribute7
,p_cpi_attribute8 => p_cpi_attribute8
,p_cpi_attribute9 => p_cpi_attribute9
,p_cpi_attribute10 => p_cpi_attribute10
,p_cpi_attribute11 => p_cpi_attribute11
,p_cpi_attribute12 => p_cpi_attribute12
,p_cpi_attribute13 => p_cpi_attribute13
,p_cpi_attribute14 => p_cpi_attribute14
,p_cpi_attribute15 => p_cpi_attribute15
,p_cpi_attribute16 => p_cpi_attribute16
,p_cpi_attribute17 => p_cpi_attribute17
,p_cpi_attribute18 => p_cpi_attribute18
,p_cpi_attribute19 => p_cpi_attribute19
,p_cpi_attribute20 => p_cpi_attribute20
,p_cpi_attribute21 => p_cpi_attribute21
,p_cpi_attribute22 => p_cpi_attribute22
,p_cpi_attribute23 => p_cpi_attribute23
,p_cpi_attribute24 => p_cpi_attribute24
,p_cpi_attribute25 => p_cpi_attribute25
,p_cpi_attribute26 => p_cpi_attribute26
,p_cpi_attribute27 => p_cpi_attribute27
,p_cpi_attribute28 => p_cpi_attribute28
,p_cpi_attribute29 => p_cpi_attribute29
,p_cpi_attribute30 => p_cpi_attribute30
,p_feedback_date => p_feedback_date
,p_object_version_number => l_object_version_number
);
(p_module_name => 'UPDATE_PERSON_INFO'
,p_hook_type => 'AP'
);
rollback to update_person_info;
rollback to update_person_info;
end update_person_info;
procedure delete_person_info
(p_validate in boolean default false
,p_group_per_in_ler_id in number
,p_object_version_number in number
) is
--
--
l_proc varchar2(72) := g_package||'delete_person_info';
savepoint delete_person_info;
ben_cwb_person_info_bk3.delete_person_info_b
(p_group_per_in_ler_id => p_group_per_in_ler_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_PERSON_INFO'
,p_hook_type => 'BP'
);
ben_cwb_person_info_bk3.delete_person_info_a
(p_group_per_in_ler_id => p_group_per_in_ler_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'DELETE_PERSON_INFO'
,p_hook_type => 'AP'
);
ben_cwb_audit_api.update_per_record(p_group_per_in_ler_id);
rollback to delete_person_info;
rollback to delete_person_info;
end delete_person_info;