Oracle HRMS Employee sal proposal &bank details APIs

--sal_proposal
--
BEGIN
hr_maintain_proposal_api.insert_salary_proposal
( p_pay_proposal_id => l_pay_proposal_id
,p_assignment_id => l_assignment_id
,p_business_group_id => p_business_group_id
,p_change_date => sal_rec.start_date
,p_proposed_salary_n => sal_rec.basic
,p_date_to => sal_rec.end_date
,p_proposal_reason => sal_rec.reason_code
,p_object_version_number => l_object_version_number
,p_approved => 'Y'
,p_validate => TRUE
,p_multiple_components => 'N'
,p_element_entry_id => l_element_entry_id
,p_inv_next_sal_date_warning => l_inv_next_sal_date_warning
,p_proposed_salary_warning => l_proposed_salary_warning
,p_approved_warning => l_approved_warning
,p_payroll_warning => l_payroll_warning
);
END;
-- EMP bank details
--
BEGIN
hr_personal_pay_method_api.create_personal_pay_method
( p_validate => TRUE
,p_effective_date => l_effective_date --emp_bank_rec.start_date
,p_assignment_id => l_assignment_id
,p_org_payment_method_id => l_org_pay_method_id
,p_priority => 1
,p_percentage => 100
,p_territory_code => 'AE'
,p_segment1 => emp_bank_rec.bank_code
,p_segment2 => emp_bank_rec.bank_code
,p_segment3 => emp_bank_rec.branch_code
,p_segment4 => emp_bank_rec.account
,p_personal_payment_method_id => l_personal_payment_method_id
,p_external_account_id => l_external_account_id
,p_object_version_number => l_object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
);
END;