APPS.RCV_ROI_PARALLEL dependencies on RCV_HEADERS_INTERFACE

Line 11: select header_interface_id from rcv_headers_interface

7: p_req_ids OUT NOCOPY RCV_ROI_PARALLEL.reqid_list) IS
8: x_progress NUMBER;
9: /*
10: cursor c_header is
11: select header_interface_id from rcv_headers_interface
12: where NVL(asn_type,'STD') in ('ASN','ASBN','STD')
13: and processing_status_code in ('PENDING')
14: and nvl(validation_flag,'N') = 'Y'
15: for update of group_id nowait;

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

92: v_gid_table(i) := v_group_id(CEIL(i/v_id_table.COUNT*p_num_of_groups));
93: END LOOP;
94:
95: IF (g_asn_debug = 'Y') THEN
96: ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_HEADERS_INTERFACE');
97: END IF;
98:
99: FORALL k IN 1..v_id_table.COUNT
100: UPDATE rcv_headers_interface

Line 100: UPDATE rcv_headers_interface

96: ASN_DEBUG.PUT_LINE('Before Bulk Update of RCV_HEADERS_INTERFACE');
97: END IF;
98:
99: FORALL k IN 1..v_id_table.COUNT
100: UPDATE rcv_headers_interface
101: SET group_id = v_gid_table(k)
102: WHERE header_interface_id = v_id_table(k);
103:
104: IF (g_asn_debug = 'Y') THEN

Line 118: FROM RCV_HEADERS_INTERFACE

114: */
115:
116: SELECT distinct group_id
117: BULK COLLECT INTO v_group_id
118: FROM RCV_HEADERS_INTERFACE
119: WHERE NVL(asn_type,'STD') in ('ASN','ASBN','STD')
120: AND processing_status_code in ('PENDING')
121: AND nvl(validation_flag,'N') = 'Y';
122: