Oracle HRMS API – Create Employee Payment Method
- by PRajkumar
API -- hr_personal_pay_method_api.create_personal_pay_method
Example --
DECLARE
ln_method_id PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE;
ln_ext_acc_id PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE;
ln_obj_ver_num PAY_PERSONAL_PAYMENT_METHODS_F.OBJECT_VERSION_NUMBER%TYPE;
ld_eff_start_date DATE;
ld_eff_end_date DATE;
ln_comment_id NUMBER;
BEGIN
-- Create Employee Payment Method
-- --------------------------------------------------
hr_personal_pay_method_api.create_personal_pay_method
( -- Input data elements
-- ------------------------------
p_effective_date => TO_DATE('21-JUN-2011'),
p_assignment_id => 33561,
p_org_payment_method_id => 2,
p_priority => 50,
p_percentage => 100,
p_territory_code => 'US',
p_segment1 => 'PRAJKUMAR',
p_segment2 => 'S',
p_segment3 => '100200300',
p_segment4 => '567',
p_segment5 => 'HDFC',
p_segment6 => 'INDIA',
-- Output data elements
-- --------------------------------
p_personal_payment_method_id => ln_method_id,
p_external_account_id => ln_ext_acc_id,
p_object_version_number => ln_obj_ver_num,
p_effective_start_date => ld_eff_start_date,
p_effective_end_date => ld_eff_end_date,
p_comment_id => ln_comment_id
);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
dbms_output.put_line(SQLERRM);
END;
/
SHOW ERR;
