API to Create Payment Method for Employee

DECLARE

ln_personal_payment_method_id    PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE;

ln_external_account_id            PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE;

ln_object_version_number    PAY_PERSONAL_PAYMENT_METHODS_F.OBJECT_VERSION_NUMBER%TYPE;

ld_effective_start_date             DATE;

ld_effective_end_date              DATE;

ln_comment_id                        NUMBER;

BEGIN

    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_personal_payment_method_id,

        p_external_account_id               => ln_external_account_id,

        p_object_version_number        => ln_object_version_number,

        p_effective_start_date              => ld_effective_start_date,

        p_effective_end_date              => ld_effective_end_date,

        p_comment_id                       => ln_comment_id

    );

    COMMIT;

EXCEPTION

    WHEN OTHERS THEN

        ROLLBACK;

        dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Leave a Reply

Your email address will not be published. Required fields are marked *