APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 67: SELECT rcv_transactions_interface_s.NEXTVAL

63: print_debug('Entered insert_interface_code 10 : ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
64: print_debug(' parent_transaction_id => '||p_rcv_transaction_rec.rcv_transaction_id,1);
65:
66: --Generate a new value for RTID from the sequence
67: SELECT rcv_transactions_interface_s.NEXTVAL
68: INTO l_interface_transaction_id
69: FROM sys.DUAL;
70:
71: l_parent_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;

Line 3279: SELECT rcv_transactions_interface_s.NEXTVAL

3275: GOTO nextrtrecord;
3276: END IF;
3277:
3278:
3279: SELECT rcv_transactions_interface_s.NEXTVAL
3280: INTO l_new_intf_id
3281: FROM dual;
3282:
3283: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 3579: SELECT rcv_transactions_interface_s.NEXTVAL

3575: l_rti_tb(l_txn_id)(l_lot_num).quantity
3576: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
3577:
3578: ELSE
3579: SELECT rcv_transactions_interface_s.NEXTVAL
3580: INTO l_new_intf_id
3581: FROM dual;
3582:
3583: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;