DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2882: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;

2878: FROM mtl_parameters
2879: WHERE organization_id = v_org_id;
2880: l_item_rec Cur_item_dtl%ROWTYPE;
2881: l_issue_rec mtl_transactions_interface%ROWTYPE;
2882: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;
2883: l_receipt_rec mtl_transactions_interface%ROWTYPE;
2884: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;
2885: defined_error EXCEPTION;
2886: expected_error EXCEPTION;

Line 2884: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;

2880: l_item_rec Cur_item_dtl%ROWTYPE;
2881: l_issue_rec mtl_transactions_interface%ROWTYPE;
2882: l_issue_lot_rec mtl_transaction_lots_interface%ROWTYPE;
2883: l_receipt_rec mtl_transactions_interface%ROWTYPE;
2884: l_receipt_lot_rec mtl_transaction_lots_interface%ROWTYPE;
2885: defined_error EXCEPTION;
2886: expected_error EXCEPTION;
2887: item_not_defined EXCEPTION;
2888: no_open_period_err EXCEPTION;

Line 3278: p_mtli_rec IN mtl_transaction_lots_interface%ROWTYPE,

3274: p_param3 => l_txn_data);
3275: END create_issue_receipt;
3276:
3277: PROCEDURE insert_interface_recs(p_mti_rec IN mtl_transactions_interface%ROWTYPE,
3278: p_mtli_rec IN mtl_transaction_lots_interface%ROWTYPE,
3279: x_return_status OUT NOCOPY VARCHAR2) IS
3280: l_mti_tbl gme_common_pvt.mtl_tran_int_tbl;
3281: l_mtli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3282: l_api_name VARCHAR2(30) := 'insert_interface_recs';

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

3291: END IF;
3292: FORALL a IN 1..l_mti_tbl.COUNT
3293: INSERT INTO mtl_transactions_interface VALUES l_mti_tbl(a);
3294: FORALL b IN 1..l_mtli_tbl.COUNT
3295: INSERT INTO mtl_transaction_lots_interface VALUES l_mtli_tbl(b);
3296: IF (g_debug <= gme_debug.g_log_procedure) THEN
3297: gme_debug.put_line('End procedure '||l_api_name);
3298: END IF;
3299: EXCEPTION