API to Delete Element Entry

DECLARE

    ld_effective_start_date          DATE;

    ld_effective_end_date          DATE;

    lb_delete_warning                BOOLEAN;

    ln_object_version_number    PAY_ELEMENT_ENTRIES_F.OBJECT_VERSION_NUMBER%TYPE    := 1;

BEGIN

    pay_element_entry_api.delete_element_entry

    (    — Input data elements

        p_datetrack_delete_mode   => ‘DELETE’,

        p_effective_date                  => TO_DATE(’23-JUNE-2011′),

        p_element_entry_id             => 118557,

        — Output data elements

        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_delete_warning             => lb_delete_warning

    );

    COMMIT;

EXCEPTION

    WHEN OTHERS THEN

        ROLLBACK;

        dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Before API Execution

After API Execution

Leave a Reply

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