APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTIONS_INTERFACE

Line 311: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;

307: p_reservation_id IN NUMBER DEFAULT NULL)
308: IS
309: l_count NUMBER;
310: l_assign_phantom NUMBER;
311: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;
312: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;
313:
314: --
315: -- bug 9483781

Line 312: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;

308: IS
309: l_count NUMBER;
310: l_assign_phantom NUMBER;
311: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;
312: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;
313:
314: --
315: -- bug 9483781
316: -- Cursor to fetch the LPN_ID against a reservation

Line 3582: FROM mtl_transactions_interface mmti

3578:
3579: CURSOR cur_get_transaction (v_transaction_id NUMBER)
3580: IS
3581: SELECT *
3582: FROM mtl_transactions_interface mmti
3583: WHERE transaction_interface_id = v_transaction_id;
3584:
3585: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
3586: IS

Line 3592: l_mmti_rec mtl_transactions_interface%ROWTYPE;

3588: FROM mtl_transaction_lots_interface
3589: WHERE transaction_interface_id = v_transaction_id;
3590:
3591: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM_TXN';
3592: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3593: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3594: BEGIN
3595:
3596: IF (g_debug IS NOT NULL) THEN

Line 4471: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;

4467: , x_return_status OUT NOCOPY VARCHAR2
4468: ) IS
4469:
4470: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4471: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4472: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4473: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4474: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
4475: l_lot_expiration_date DATE;