APPS.INV_GMI_MIGRATION dependencies on IC_ITEM_CNV

Line 1665: CURSOR c_ic_item_cnv IS

1661: l_locator_id NUMBER;
1662: l_subinventory_ind_flag VARCHAR2(1);
1663: l_migrated_ind PLS_INTEGER;
1664:
1665: CURSOR c_ic_item_cnv IS
1666: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1667: FROM ic_item_cnv c, ic_lots_mst_mig m
1668: WHERE
1669: c.rowid BETWEEN p_start_rowid AND p_end_rowid and

Line 1667: FROM ic_item_cnv c, ic_lots_mst_mig m

1663: l_migrated_ind PLS_INTEGER;
1664:
1665: CURSOR c_ic_item_cnv IS
1666: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1667: FROM ic_item_cnv c, ic_lots_mst_mig m
1668: WHERE
1669: c.rowid BETWEEN p_start_rowid AND p_end_rowid and
1670: c.item_id = m.item_id and
1671: c.lot_id = m.lot_id and

Line 1705: FOR c in c_ic_item_cnv LOOP

1701: p_param5 => NULL,
1702: p_db_error => NULL,
1703: p_app_short_name => 'GMA');
1704:
1705: FOR c in c_ic_item_cnv LOOP
1706: BEGIN
1707: -- Get the discrete item id
1708: INV_OPM_Item_Migration.get_ODM_item (
1709: p_migration_run_id => p_migration_run_id,

Line 1723: p_table_name => 'IC_ITEM_CNV',

1719: GMA_COMMON_LOGGING.gma_migration_central_log (
1720: p_run_id => p_migration_run_id,
1721: p_log_level => FND_LOG.LEVEL_ERROR,
1722: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1723: p_table_name => 'IC_ITEM_CNV',
1724: p_context => 'LOT CONVERSION',
1725: p_param1 => INV_GMI_Migration.org(c.organization_id),
1726: p_param2 => INV_GMI_Migration.item(c.item_id),
1727: p_param3 => NULL,

Line 1780: p_table_name => 'IC_ITEM_CNV',

1776: GMA_COMMON_LOGGING.gma_migration_central_log (
1777: p_run_id => p_migration_run_id,
1778: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1779: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1780: p_table_name => 'IC_ITEM_CNV',
1781: p_context => 'LOT CONVERSIONS',
1782: p_param1 => INV_GMI_Migration.org(c.organization_id),
1783: p_param2 => INV_GMI_Migration.ditem(c.organization_id, l_inventory_item_id),
1784: p_param3 => c.lot_number,

Line 1896: p_table_name => 'IC_ITEM_CNV',

1892: GMA_COMMON_LOGGING.gma_migration_central_log (
1893: p_run_id => p_migration_run_id,
1894: p_log_level => FND_LOG.LEVEL_ERROR,
1895: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1896: p_table_name => 'IC_ITEM_CNV',
1897: p_context => 'LOT CONVERSION',
1898: p_param1 => adetail.whse_code,
1899: p_param2 => NULL,
1900: p_param3 => NULL,

Line 1933: p_table_name => 'IC_ITEM_CNV',

1929: GMA_COMMON_LOGGING.gma_migration_central_log (
1930: p_run_id => p_migration_run_id,
1931: p_log_level => FND_LOG.LEVEL_ERROR,
1932: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
1933: p_table_name => 'IC_ITEM_CNV',
1934: p_context => 'LOT CONVERSION',
1935: p_param1 => adetail.whse_code,
1936: p_param2 => adetail.location,
1937: p_param3 => NULL,

Line 2064: p_table_name => 'IC_ITEM_CNV',

2060: GMA_COMMON_LOGGING.gma_migration_central_log (
2061: p_run_id => p_migration_run_id,
2062: p_log_level => FND_LOG.LEVEL_ERROR,
2063: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2064: p_table_name => 'IC_ITEM_CNV',
2065: p_context => 'LOT CONVERSION',
2066: p_param1 => l_field_name,
2067: p_param2 => l_field_value,
2068: p_param3 => NULL,

Line 2086: p_table_name => 'IC_ITEM_CNV',

2082: GMA_COMMON_LOGGING.gma_migration_central_log (
2083: p_run_id => p_migration_run_id,
2084: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2085: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2086: p_table_name => 'IC_ITEM_CNV',
2087: p_context => 'LOT CONVERSION',
2088: p_param1 => l_migrate_count,
2089: p_param2 => x_failure_count,
2090: p_param3 => NULL,

Line 2104: p_table_name => 'IC_ITEM_CNV',

2100: GMA_COMMON_LOGGING.gma_migration_central_log (
2101: p_run_id => p_migration_run_id,
2102: p_log_level => FND_LOG.LEVEL_ERROR,
2103: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2104: p_table_name => 'IC_ITEM_CNV',
2105: p_context => 'LOT CONVERSION',
2106: p_param1 => NULL,
2107: p_param2 => NULL,
2108: p_param3 => NULL,