APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 172: SELECT rcv_transactions_interface_s.NEXTVAL

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

Line 5705: SELECT rcv_transactions_interface_s.NEXTVAL

5701: END IF;
5702: GOTO nextrtrecord;
5703: END IF;
5704:
5705: SELECT rcv_transactions_interface_s.NEXTVAL
5706: INTO l_new_intf_id
5707: FROM dual;
5708:
5709: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 5994: SELECT rcv_transactions_interface_s.NEXTVAL

5990: l_rti_tb(l_txn_id)(l_lot_num).quantity
5991: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
5992:
5993: ELSE
5994: SELECT rcv_transactions_interface_s.NEXTVAL
5995: INTO l_new_intf_id
5996: FROM dual;
5997:
5998: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;