APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 174: SELECT rcv_transactions_interface_s.NEXTVAL

170:
171: -- Chk if RCV_TRANSACTION.INTERFACE_transaction_id item is populated
172: -- If not, populate the item with get_interface_id function
173: --if l_rcv_transaction_rec.INTERFACE_transaction_id is null THEN
174: SELECT rcv_transactions_interface_s.NEXTVAL
175: INTO l_interface_transaction_id
176: FROM SYS.DUAL;
177:
178: l_rcv_transaction_rec.interface_transaction_id := l_interface_transaction_id;

Line 5840: SELECT rcv_transactions_interface_s.NEXTVAL

5836: END IF;
5837: GOTO nextrtrecord;
5838: END IF;
5839:
5840: SELECT rcv_transactions_interface_s.NEXTVAL
5841: INTO l_new_intf_id
5842: FROM dual;
5843:
5844: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 6137: SELECT rcv_transactions_interface_s.NEXTVAL

6133: l_rti_tb(l_txn_id)(l_lot_num).quantity
6134: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
6135:
6136: ELSE
6137: SELECT rcv_transactions_interface_s.NEXTVAL
6138: INTO l_new_intf_id
6139: FROM dual;
6140:
6141: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;