DBA Data[Home] [Help]

APPS.PAY_NAF_DEL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

  PROCEDURE pre_delete
    (p_rec IN pay_naf_shd.g_rec_type) IS
    l_proc varchar2(72) DEFAULT g_package
                                || 'pre_delete';
Line: 19

  END pre_delete;
Line: 21

  PROCEDURE delete_dml
    (p_rec IN pay_naf_shd.g_rec_type) IS
    l_proc varchar2(72) DEFAULT g_package
                                || 'delete_dml';
Line: 32

    DELETE
    FROM    pay_no_altinn_transfers
    WHERE   transfer_id = p_rec.transfer_id;
Line: 41

  END delete_dml;
Line: 43

  PROCEDURE post_delete
    (p_rec IN pay_naf_shd.g_rec_type) IS
    l_proc varchar2(72) DEFAULT g_package
                                || 'post_delete';
Line: 55

  END post_delete;
Line: 74

    pay_naf_bus.delete_validate (p_rec);
Line: 76

    pre_delete (p_rec);
Line: 78

    delete_dml (p_rec);
Line: 80

    post_delete (p_rec);