API to Create and Update Employee Phone

DECLARE

    ln_phone_id                         PER_PHONES.PHONE_ID%TYPE;

    ln_object_version_number   PER_PHONES.OBJECT_VERSION_NUMBER%TYPE;

BEGIN

    hr_phone_api.create_or_update_phone

    (    — Input data elements

        p_date_from          => TO_DATE(’13-JUN-2011′),

        p_phone_type        => ‘W1’,

        p_phone_number   => ‘9999999’,

        p_parent_id            => 32979,

        p_parent_table       => ‘PER_ALL_PEOPLE_F’,

        p_effective_date    => TO_DATE(’13-JUN-2011′),

        — Output data elements

        p_phone_id                       => ln_phone_id,

        p_object_version_number => ln_object_version_number

    );

    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 *