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 3373: SELECT rcv_transactions_interface_s.NEXTVAL

3369: GOTO nextrtrecord;
3370: END IF;
3371:
3372:
3373: SELECT rcv_transactions_interface_s.NEXTVAL
3374: INTO l_new_intf_id
3375: FROM dual;
3376:
3377: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 3691: SELECT rcv_transactions_interface_s.NEXTVAL

3687: l_rti_tb(l_txn_id)(l_lot_num).quantity
3688: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
3689:
3690: ELSE
3691: SELECT rcv_transactions_interface_s.NEXTVAL
3692: INTO l_new_intf_id
3693: FROM dual;
3694:
3695: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;

Line 3805: SELECT rcv_transactions_interface_s.NEXTVAL

3801: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
3802:
3803: ELSE
3804:
3805: SELECT rcv_transactions_interface_s.NEXTVAL
3806: INTO l_new_intf_id
3807: FROM dual;
3808:
3809: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;