The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
INTO v_group_id(i)
FROM dual;
v_h_int_id.DELETE;
ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_HEADERS_INTERFACE');
UPDATE rcv_headers_interface
SET group_id = v_gid_table(k)
WHERE header_interface_id = v_id_table(k);
ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_TRANSACTIONS_INTERFACE');
UPDATE rcv_transactions_interface
SET group_id = v_gid_table(k)
WHERE header_interface_id = v_id_table(k);
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';