DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on MTL_LOT_NUMBERS

Line 1403: SELECT distinct grade_code FROM mtl_lot_numbers

1399: l_count PLS_INTEGER;
1400: l_migrate_count PLS_INTEGER;
1401:
1402: CURSOR c_lot_grades IS
1403: SELECT distinct grade_code FROM mtl_lot_numbers
1404: WHERE grade_code is not NULL;
1405:
1406: BEGIN
1407: x_failure_count := 0;

Line 1414: p_table_name => 'MTL_LOT_NUMBERS',

1410: GMA_COMMON_LOGGING.gma_migration_central_log (
1411: p_run_id => p_migration_run_id,
1412: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1413: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1414: p_table_name => 'MTL_LOT_NUMBERS',
1415: p_context => 'GRADES',
1416: p_param1 => NULL,
1417: p_param2 => NULL,
1418: p_param3 => NULL,

Line 1493: p_table_name => 'MTL_LOT_NUMBERS',

1489: GMA_COMMON_LOGGING.gma_migration_central_log (
1490: p_run_id => p_migration_run_id,
1491: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1492: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1493: p_table_name => 'MTL_LOT_NUMBERS',
1494: p_context => 'GRADES',
1495: p_param1 => NULL,
1496: p_param2 => NULL,
1497: p_param3 => NULL,

Line 1510: p_table_name => 'MTL_LOT_NUMBERS',

1506: GMA_COMMON_LOGGING.gma_migration_central_log (
1507: p_run_id => p_migration_run_id,
1508: p_log_level => FND_LOG.LEVEL_ERROR,
1509: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1510: p_table_name => 'MTL_LOT_NUMBERS',
1511: p_context => 'GRADES',
1512: p_param1 => NULL,
1513: p_param2 => NULL,
1514: p_param3 => NULL,