Oracle HRMS API – Create Employee Payment Method

Oracle HRMS API – Create Employee Payment Method

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;