DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 7255: SELECT rcv_transactions_interface_s.NEXTVAL

7251: l_progress := '6';
7252:
7253: END IF; --IF (p_first_time = 1)
7254:
7255: SELECT rcv_transactions_interface_s.NEXTVAL
7256: INTO l_interface_transaction_id
7257: FROM dual;
7258:
7259: -- init_start_values should have called gen_txn_group_id

Line 7442: rcv_transactions_interface

7438: ,p_org_id => l_operating_unit_id --
7439: );
7440:
7441: UPDATE
7442: rcv_transactions_interface
7443: SET
7444: validation_flag = 'Y'
7445: ,lpn_group_id = l_group_id
7446: WHERE ROWID = l_rowid;

Line 10538: SELECT rcv_transactions_interface_s.NEXTVAL

10534: --number corresponding to the parent transaction. So in such cases, we have to
10535: --generate a new value of product_transaction_id while updating the MSNI
10536: --ramarava
10537: IF (l_serialized_item AND l_mmtt_prm_qty = 1) THEN
10538: SELECT rcv_transactions_interface_s.NEXTVAL
10539: INTO l_product_transaction_id
10540: FROM sys.dual;
10541: END IF;
10542: