APPS.CSD_INTERNAL_ORDERS_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');

159: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
160:
161:
162: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');
164: END IF;
165:
166: -- 3. insert into rcv transactions interface table.
167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);

Line 166: -- 3. insert into rcv transactions interface table.

162: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');
164: END IF;
165:
166: -- 3. insert into rcv transactions interface table.
167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);
168:
169: FOR i IN l_shipment_header_id.FIRST ..l_shipment_header_id.LAST
170: LOOP

Line 171: INSERT INTO rcv_transactions_interface

167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);
168:
169: FOR i IN l_shipment_header_id.FIRST ..l_shipment_header_id.LAST
170: LOOP
171: INSERT INTO rcv_transactions_interface
172: (interface_transaction_id,
173: header_interface_id,
174: GROUP_ID,
175: transaction_date,

Line 222: VALUES (rcv_transactions_interface_s.NEXTVAL,

218: shipment_header_id,
219: shipment_line_id,
220: org_id
221: )
222: VALUES (rcv_transactions_interface_s.NEXTVAL,
223: l_hdr_interface_id(i),
224: x_request_group_id,
225: SYSDATE,
226: l_quantity(i),