APPS.GME_POST_MIGRATION dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 3309: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;

3305: FROM mtl_parameters
3306: WHERE organization_id = v_org_id;
3307: l_item_rec Cur_item_dtl%ROWTYPE;
3308: l_issue_rec mtl_transactions_interface%ROWTYPE;
3309: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;
3310: l_receipt_rec mtl_transactions_interface%ROWTYPE;
3311: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;
3312: defined_error EXCEPTION;
3313: expected_error EXCEPTION;

Line 3311: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;

3307: l_item_rec Cur_item_dtl%ROWTYPE;
3308: l_issue_rec mtl_transactions_interface%ROWTYPE;
3309: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;
3310: l_receipt_rec mtl_transactions_interface%ROWTYPE;
3311: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;
3312: defined_error EXCEPTION;
3313: expected_error EXCEPTION;
3314: item_not_defined EXCEPTION;
3315: no_open_period_err EXCEPTION;

Line 3828: p_mtli_rec IN mtl_transaction_lots_interface%ROWTYPE,

3824: p_param4 => l_txn_data);
3825: END create_issue_receipt;
3826:
3827: PROCEDURE insert_interface_recs(p_mti_rec IN mtl_transactions_interface%ROWTYPE,
3828: p_mtli_rec IN mtl_transaction_lots_interface%ROWTYPE,
3829: x_return_status OUT NOCOPY VARCHAR2) IS
3830: l_mti_tbl gme_common_pvt.mtl_tran_int_tbl;
3831: l_mtli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3832: l_api_name VARCHAR2(30) := 'insert_interface_recs';

Line 3845: INSERT INTO mtl_transaction_lots_interface VALUES l_mtli_tbl(b);

3841: END IF;
3842: FORALL a IN 1..l_mti_tbl.COUNT
3843: INSERT INTO mtl_transactions_interface VALUES l_mti_tbl(a);
3844: FORALL b IN 1..l_mtli_tbl.COUNT
3845: INSERT INTO mtl_transaction_lots_interface VALUES l_mtli_tbl(b);
3846: IF (g_debug <= gme_debug.g_log_procedure) THEN
3847: gme_debug.put_line('End procedure '||l_api_name);
3848: END IF;
3849: EXCEPTION