DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTIONS_INTERFACE

Line 243: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;

239: x_error_msg OUT NOCOPY VARCHAR2)
240: IS
241: l_count NUMBER;
242: l_assign_phantom NUMBER;
243: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;
244: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;
245: BEGIN
246:
247: -- Clearing the quantity cache

Line 244: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;

240: IS
241: l_count NUMBER;
242: l_assign_phantom NUMBER;
243: l_mmti_rec_in mtl_transactions_interface%ROWTYPE;
244: l_mmti_rec_out mtl_transactions_interface%ROWTYPE;
245: BEGIN
246:
247: -- Clearing the quantity cache
248: inv_quantity_tree_pub.clear_quantity_cache;

Line 3486: FROM mtl_transactions_interface mmti

3482:
3483: CURSOR cur_get_transaction (v_transaction_id NUMBER)
3484: IS
3485: SELECT *
3486: FROM mtl_transactions_interface mmti
3487: WHERE transaction_interface_id = v_transaction_id;
3488:
3489: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
3490: IS

Line 3496: l_mmti_rec mtl_transactions_interface%ROWTYPE;

3492: FROM mtl_transaction_lots_interface
3493: WHERE transaction_interface_id = v_transaction_id;
3494:
3495: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM_TXN';
3496: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3497: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3498: BEGIN
3499:
3500: IF (g_debug IS NOT NULL) THEN

Line 4341: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;

4337: , x_return_status OUT NOCOPY VARCHAR2
4338: ) IS
4339:
4340: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4341: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4342: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4343: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4344: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
4345: l_lot_expiration_date DATE;