APPS.RCV_ROI_PARALLEL SQL Statements

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

Line: 11

      select header_interface_id from rcv_headers_interface
      where NVL(asn_type,'STD') in ('ASN','ASBN','STD')
      and   processing_status_code in ('PENDING')
      and   nvl(validation_flag,'N') = 'Y'
      for update of group_id nowait;

Line: 52

    SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
    INTO   v_group_id(i)
    FROM   dual;

Line: 84

    v_h_int_id.DELETE;

Line: 96

     ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_HEADERS_INTERFACE');

Line: 100

    UPDATE rcv_headers_interface
    SET    group_id = v_gid_table(k)
    WHERE  header_interface_id = v_id_table(k);

Line: 105

     ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_TRANSACTIONS_INTERFACE');

Line: 109

    UPDATE rcv_transactions_interface
    SET    group_id = v_gid_table(k)
    WHERE  header_interface_id = v_id_table(k);

Line: 116

  SELECT distinct group_id
  BULK COLLECT INTO   v_group_id
  FROM   RCV_HEADERS_INTERFACE
  WHERE  NVL(asn_type,'STD') in ('ASN','ASBN','STD')
  AND    processing_status_code in ('PENDING')
  AND    nvl(validation_flag,'N') = 'Y';