APPS.INV_GMI_MIGRATION dependencies on IC_ITEM_CNV

Line 1573: CURSOR c_ic_item_cnv IS

1569: l_locator_id NUMBER;
1570: l_subinventory_ind_flag VARCHAR2(1);
1571: l_migrated_ind PLS_INTEGER;
1572:
1573: CURSOR c_ic_item_cnv IS
1574: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1575: FROM ic_item_cnv c, ic_lots_mst_mig m
1576: WHERE
1577: c.rowid BETWEEN p_start_rowid AND p_end_rowid and

Line 1575: FROM ic_item_cnv c, ic_lots_mst_mig m

1571: l_migrated_ind PLS_INTEGER;
1572:
1573: CURSOR c_ic_item_cnv IS
1574: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1575: FROM ic_item_cnv c, ic_lots_mst_mig m
1576: WHERE
1577: c.rowid BETWEEN p_start_rowid AND p_end_rowid and
1578: c.item_id = m.item_id and
1579: c.lot_id = m.lot_id and

Line 1613: FOR c in c_ic_item_cnv LOOP

1609: p_param5 => NULL,
1610: p_db_error => NULL,
1611: p_app_short_name => 'GMA');
1612:
1613: FOR c in c_ic_item_cnv LOOP
1614: BEGIN
1615: -- Get the discrete item id
1616: INV_OPM_Item_Migration.get_ODM_item (
1617: p_migration_run_id => p_migration_run_id,

Line 1631: p_table_name => 'IC_ITEM_CNV',

1627: GMA_COMMON_LOGGING.gma_migration_central_log (
1628: p_run_id => p_migration_run_id,
1629: p_log_level => FND_LOG.LEVEL_ERROR,
1630: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1631: p_table_name => 'IC_ITEM_CNV',
1632: p_context => 'LOT CONVERSION',
1633: p_param1 => INV_GMI_Migration.org(c.organization_id),
1634: p_param2 => INV_GMI_Migration.item(c.item_id),
1635: p_param3 => NULL,

Line 1688: p_table_name => 'IC_ITEM_CNV',

1684: GMA_COMMON_LOGGING.gma_migration_central_log (
1685: p_run_id => p_migration_run_id,
1686: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1687: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1688: p_table_name => 'IC_ITEM_CNV',
1689: p_context => 'LOT CONVERSIONS',
1690: p_param1 => INV_GMI_Migration.org(c.organization_id),
1691: p_param2 => INV_GMI_Migration.ditem(c.organization_id, l_inventory_item_id),
1692: p_param3 => c.lot_number,

Line 1804: p_table_name => 'IC_ITEM_CNV',

1800: GMA_COMMON_LOGGING.gma_migration_central_log (
1801: p_run_id => p_migration_run_id,
1802: p_log_level => FND_LOG.LEVEL_ERROR,
1803: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1804: p_table_name => 'IC_ITEM_CNV',
1805: p_context => 'LOT CONVERSION',
1806: p_param1 => adetail.whse_code,
1807: p_param2 => NULL,
1808: p_param3 => NULL,

Line 1841: p_table_name => 'IC_ITEM_CNV',

1837: GMA_COMMON_LOGGING.gma_migration_central_log (
1838: p_run_id => p_migration_run_id,
1839: p_log_level => FND_LOG.LEVEL_ERROR,
1840: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
1841: p_table_name => 'IC_ITEM_CNV',
1842: p_context => 'LOT CONVERSION',
1843: p_param1 => adetail.whse_code,
1844: p_param2 => adetail.location,
1845: p_param3 => NULL,

Line 1972: p_table_name => 'IC_ITEM_CNV',

1968: GMA_COMMON_LOGGING.gma_migration_central_log (
1969: p_run_id => p_migration_run_id,
1970: p_log_level => FND_LOG.LEVEL_ERROR,
1971: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
1972: p_table_name => 'IC_ITEM_CNV',
1973: p_context => 'LOT CONVERSION',
1974: p_param1 => l_field_name,
1975: p_param2 => l_field_value,
1976: p_param3 => NULL,

Line 1994: p_table_name => 'IC_ITEM_CNV',

1990: GMA_COMMON_LOGGING.gma_migration_central_log (
1991: p_run_id => p_migration_run_id,
1992: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1993: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1994: p_table_name => 'IC_ITEM_CNV',
1995: p_context => 'LOT CONVERSION',
1996: p_param1 => l_migrate_count,
1997: p_param2 => x_failure_count,
1998: p_param3 => NULL,

Line 2012: p_table_name => 'IC_ITEM_CNV',

2008: GMA_COMMON_LOGGING.gma_migration_central_log (
2009: p_run_id => p_migration_run_id,
2010: p_log_level => FND_LOG.LEVEL_ERROR,
2011: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2012: p_table_name => 'IC_ITEM_CNV',
2013: p_context => 'LOT CONVERSION',
2014: p_param1 => NULL,
2015: p_param2 => NULL,
2016: p_param3 => NULL,