APPS.RCV_ASN_INTERFACE_TRX_INS_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 252: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE

248: P_EXPRESS_TRANSACTION IN VARCHAR2 DEFAULT NULL,
249: X_LCM_SHIPMENT_LINE_ID IN NUMBER DEFAULT NULL, -- lcm changes
250: X_UNIT_LANDED_COST IN NUMBER DEFAULT NULL -- lcm changes
251: ) IS
252: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
253: WHERE interface_transaction_id = X_Interface_Transaction_Id;
254:
255: CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;
256:

Line 255: CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;

251: ) IS
252: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
253: WHERE interface_transaction_id = X_Interface_Transaction_Id;
254:
255: CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;
256:
257: BEGIN
258: if (X_Interface_Transaction_Id is NULL) then
259: OPEN C2;

Line 264: INSERT INTO RCV_TRANSACTIONS_INTERFACE(

260: FETCH C2 INTO X_Interface_Transaction_Id;
261: CLOSE C2;
262: end if;
263:
264: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
265: INTERFACE_TRANSACTION_ID,
266: GROUP_ID,
267: LAST_UPDATE_DATE,
268: LAST_UPDATED_BY,