DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 444: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;

440: p_locator_id IN NUMBER,
441: x_return_status OUT NOCOPY VARCHAR2,
442: x_error_msg OUT NOCOPY VARCHAR2)
443: IS
444: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;
445: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
446: BEGIN
447:
448: IF (g_debug IS NOT NULL) THEN

Line 445: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;

441: x_return_status OUT NOCOPY VARCHAR2,
442: x_error_msg OUT NOCOPY VARCHAR2)
443: IS
444: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;
445: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
446: BEGIN
447:
448: IF (g_debug IS NOT NULL) THEN
449: gme_debug.log_initialize ('MobileCreLotTxn');

Line 3588: FROM mtl_transaction_lots_interface

3584:
3585: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
3586: IS
3587: SELECT *
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;

Line 4472: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;

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;
4476: