APPS.INV_GMI_MIGRATION dependencies on MTL_LOT_NUMBERS

Line 1495: SELECT distinct grade_code FROM mtl_lot_numbers

1491: l_count PLS_INTEGER;
1492: l_migrate_count PLS_INTEGER;
1493:
1494: CURSOR c_lot_grades IS
1495: SELECT distinct grade_code FROM mtl_lot_numbers
1496: WHERE grade_code is not NULL;
1497:
1498: BEGIN
1499: x_failure_count := 0;

Line 1506: p_table_name => 'MTL_LOT_NUMBERS',

1502: GMA_COMMON_LOGGING.gma_migration_central_log (
1503: p_run_id => p_migration_run_id,
1504: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1505: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1506: p_table_name => 'MTL_LOT_NUMBERS',
1507: p_context => 'GRADES',
1508: p_param1 => NULL,
1509: p_param2 => NULL,
1510: p_param3 => NULL,

Line 1585: p_table_name => 'MTL_LOT_NUMBERS',

1581: GMA_COMMON_LOGGING.gma_migration_central_log (
1582: p_run_id => p_migration_run_id,
1583: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1584: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1585: p_table_name => 'MTL_LOT_NUMBERS',
1586: p_context => 'GRADES',
1587: p_param1 => NULL,
1588: p_param2 => NULL,
1589: p_param3 => NULL,

Line 1602: p_table_name => 'MTL_LOT_NUMBERS',

1598: GMA_COMMON_LOGGING.gma_migration_central_log (
1599: p_run_id => p_migration_run_id,
1600: p_log_level => FND_LOG.LEVEL_ERROR,
1601: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1602: p_table_name => 'MTL_LOT_NUMBERS',
1603: p_context => 'GRADES',
1604: p_param1 => NULL,
1605: p_param2 => NULL,
1606: p_param3 => NULL,