APPS.MIGRATE_BATCH dependencies on IC_TRAN_CMP

Line 1249: l_ic_tran_cmp_out ic_tran_cmp%ROWTYPE;

1245: l_is_plain BOOLEAN;
1246: l_def_lot_id ic_tran_pnd.trans_id%TYPE;
1247: l_completed_ind ic_tran_pnd.completed_ind%TYPE;
1248: l_trans_qty ic_tran_pnd.trans_qty%TYPE;
1249: l_ic_tran_cmp_out ic_tran_cmp%ROWTYPE;
1250: l_ic_tran_pnd_out ic_tran_pnd%ROWTYPE;
1251: l_tran_row ic_tran_pnd%ROWTYPE;
1252: l_tran_reverse gmi_trans_engine_pub.ictran_rec;
1253: l_tran_pending gmi_trans_engine_pub.ictran_rec;

Line 1497: x_tran_row => l_ic_tran_cmp_out,

1493: p_init_msg_list => FND_API.g_false,
1494: p_commit => FND_API.g_false,
1495: p_validation_level => FND_API.g_valid_level_full,
1496: p_tran_rec => l_tran_reverse,
1497: x_tran_row => l_ic_tran_cmp_out,
1498: x_return_status => l_return_status,
1499: x_msg_count => l_msg_count,
1500: x_msg_data => l_msg_data,
1501: p_table_name => 'IC_TRAN_PND'

Line 1546: p_batch_id => l_ic_tran_cmp_out.doc_id,

1542: RAISE error_create_tran;
1543: END IF;
1544:
1545: insert_inv_txns_gtmp (
1546: p_batch_id => l_ic_tran_cmp_out.doc_id,
1547: p_doc_type => l_ic_tran_cmp_out.doc_type,
1548: p_trans_id => l_ic_tran_cmp_out.trans_id,
1549: x_return_status => l_return_status
1550: );

Line 1547: p_doc_type => l_ic_tran_cmp_out.doc_type,

1543: END IF;
1544:
1545: insert_inv_txns_gtmp (
1546: p_batch_id => l_ic_tran_cmp_out.doc_id,
1547: p_doc_type => l_ic_tran_cmp_out.doc_type,
1548: p_trans_id => l_ic_tran_cmp_out.trans_id,
1549: x_return_status => l_return_status
1550: );
1551:

Line 1548: p_trans_id => l_ic_tran_cmp_out.trans_id,

1544:
1545: insert_inv_txns_gtmp (
1546: p_batch_id => l_ic_tran_cmp_out.doc_id,
1547: p_doc_type => l_ic_tran_cmp_out.doc_type,
1548: p_trans_id => l_ic_tran_cmp_out.trans_id,
1549: x_return_status => l_return_status
1550: );
1551:
1552: IF l_return_status <> x_return_status THEN

Line 1639: (l_def_lot_id, l_ic_tran_cmp_out.trans_id);

1635: /* Now let's indicate in the temporary table about the reversals */
1636: UPDATE gme_inventory_txns_gtmp
1637: SET transaction_no = 2
1638: WHERE trans_id IN
1639: (l_def_lot_id, l_ic_tran_cmp_out.trans_id);
1640: END IF; /* IF l_reversible THEN */
1641: ELSE
1642: l_message :=
1643: 'Unable to lock inventory tables for trans_id '