APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 28: * Helper routing to create a new record in RCV_TRANSACTIONS_INTERFACE

24:
25: /*----------------------------------------------------------------------------*
26: * FUNCTION: insert_interface_code
27: * Description:
28: * Helper routing to create a new record in RCV_TRANSACTIONS_INTERFACE
29: *
30: * Input Parameters:
31: * p_rcv_transactions_rec - Record containing the values for RTI
32: *

Line 41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';

37: p_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.RCVTXN_TRANSACTION_REC_TP
38: )
39: RETURN NUMBER IS
40: l_interface_transaction_id NUMBER;
41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';
42: l_parent_transaction_id NUMBER := p_rcv_transaction_rec.rcv_transaction_id;
43: l_movement_id NUMBER;
44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

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 160: INSERT INTO rcv_transactions_interface

156: END IF;
157:
158: BEGIN
159: --At last, now insert the record into RTI
160: INSERT INTO rcv_transactions_interface
161: (
162: receipt_source_code
163: , interface_transaction_id
164: , group_id

Line 648: --Now, insert the RCV_TRANSACTIONS_INTERFACE record

644: p_rcv_transaction_rec.wip_operation_seq_num := NULL;
645: p_rcv_transaction_rec.wip_resource_seq_num := NULL;
646: p_rcv_transaction_rec.wip_repetitive_schedule_id := NULL;
647:
648: --Now, insert the RCV_TRANSACTIONS_INTERFACE record
649: l_progress := 50;
650:
651: IF (l_debug = 1) THEN
652: print_debug('Inserting the RTI for TRANSFER transaction', 4);

Line 2316: * This procedure creates a RCV_TRANSACTIONS_INTERFACE record for a Receiving

2312:
2313: /*------------------------------------------------------------------------------
2314: * PROCEDURE: create_transfer_rcvtxn_rec
2315: * Description:
2316: * This procedure creates a RCV_TRANSACTIONS_INTERFACE record for a Receiving
2317: * Transfer Transaction
2318: * Called from the Mobile putaway UI and packing workbench
2319: *
2320: * Output Parameters

Line 3214: FROM rcv_transactions_interface

3210: FROM mtl_transaction_lots_interface
3211: WHERE product_code = 'RCV'
3212: AND product_transaction_id
3213: IN (SELECT interface_transaction_id
3214: FROM rcv_transactions_interface
3215: WHERE parent_transaction_id = l_rtv_rec.rcv_transaction_id
3216: )
3217: AND lot_number = p_lot_number;
3218: EXCEPTION

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;