DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 353: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;

349: p_locator_id IN NUMBER,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_error_msg OUT NOCOPY VARCHAR2)
352: IS
353: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;
354: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
355: BEGIN
356:
357: IF (g_debug IS NOT NULL) THEN

Line 354: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;

350: x_return_status OUT NOCOPY VARCHAR2,
351: x_error_msg OUT NOCOPY VARCHAR2)
352: IS
353: l_mmli_rec_in mtl_transaction_lots_interface%ROWTYPE;
354: l_mmli_rec_out mtl_transaction_lots_interface%ROWTYPE;
355: BEGIN
356:
357: IF (g_debug IS NOT NULL) THEN
358: gme_debug.log_initialize ('MobileCreLotTxn');

Line 3492: FROM mtl_transaction_lots_interface

3488:
3489: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
3490: IS
3491: SELECT *
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;

Line 4342: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;

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