APPS.GL_FUNDS_CHECKER_PKG SQL Statements

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

Line: 267

    delete from gl_bc_packets bp
     where bp.packet_id in (p_packetid, p_packetid_ursvd);

Line: 273

    delete from gl_bc_packet_arrival_order ao
     where ao.packet_id in (p_packetid, p_packetid_ursvd);

Line: 322

    update gl_bc_packets bp
       set bp.status_code = 'T'
     where bp.packet_id = g_packet_id;

Line: 327

              'Updated Status for ' || SQL%ROWCOUNT || ' Trans to Fatal' ||
              g_delim;

Line: 333

    update gl_bc_packet_arrival_order ao
       set ao.affect_funds_flag = 'N'
     where ao.packet_id = g_packet_id;