APPS.GMD_NPD_MIGRATE dependencies on LM_SPRD_FLS

Line 1165: -- lab_organization_id column in lm_sprd_fls will be updated wih the profile

1161: --
1162: -- DESCRIPTION:
1163: -- This PL/SQL procedure is used to update the lab_organization_id.
1164: --
1165: -- lab_organization_id column in lm_sprd_fls will be updated wih the profile
1166: -- value gmd$default_lab_type organization_id.
1167: --
1168: -- PARAMETERS:
1169: -- P_migration_run_id - id to use to right to migration log

Line 1202: p_table_name => 'LM_SPRD_FLS',

1198: GMA_COMMON_LOGGING.gma_migration_central_log (
1199: p_run_id => P_migration_run_id,
1200: p_log_level => FND_LOG.LEVEL_EVENT,
1201: p_message_token => 'GMA_MIGRATION_STARTED',
1202: p_table_name => 'LM_SPRD_FLS',
1203: p_context => 'SIMULATOR_LAB_TYPE',
1204: p_param1 => NULL,
1205: p_param2 => NULL,
1206: p_param3 => NULL,

Line 1222: UPDATE lm_sprd_fls

1218: CLOSE Cur_get_orgn;
1219: IF (l_organization_id IS NULL) THEN
1220: RAISE ORGN_MISSING;
1221: END IF;
1222: UPDATE lm_sprd_fls
1223: SET lab_organization_id = l_organization_id
1224: WHERE lab_organization_id IS NULL;
1225: END IF;
1226:

Line 1235: p_table_name => 'LM_SPRD_FLS',

1231: GMA_COMMON_LOGGING.gma_migration_central_log (
1232: p_run_id => P_migration_run_id,
1233: p_log_level => FND_LOG.LEVEL_EVENT,
1234: p_message_token => 'GMA_MIGRATION_COMPLETED',
1235: p_table_name => 'LM_SPRD_FLS',
1236: p_context => 'SIMULATOR_LAB_TYPE',
1237: p_param1 => NULL,
1238: p_param2 => NULL,
1239: p_param3 => NULL,

Line 1254: p_table_name => 'LM_SPRD_FLS',

1250: GMA_COMMON_LOGGING.gma_migration_central_log (
1251: p_run_id => P_migration_run_id,
1252: p_log_level => FND_LOG.LEVEL_ERROR,
1253: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1254: p_table_name => 'LM_SPRD_FLS',
1255: p_context => 'SIMULATOR_LAB_TYPE',
1256: p_token1 => 'ORGANIZATION',
1257: p_param1 => l_profile_value,
1258: p_app_short_name => 'GMA');

Line 1267: p_table_name => 'LM_SPRD_FLS',

1263: GMA_COMMON_LOGGING.gma_migration_central_log (
1264: p_run_id => P_migration_run_id,
1265: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1266: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1267: p_table_name => 'LM_SPRD_FLS',
1268: p_context => 'SIMULATOR_LAB_TYPE',
1269: p_param1 => NULL,
1270: p_param2 => NULL,
1271: p_param3 => NULL,

Line 1281: p_table_name => 'LM_SPRD_FLS',

1277: GMA_COMMON_LOGGING.gma_migration_central_log (
1278: p_run_id => P_migration_run_id,
1279: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1280: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1281: p_table_name => 'LM_SPRD_FLS',
1282: p_context => 'SIMULATOR_LAB_TYPE',
1283: p_param1 => NULL,
1284: p_param2 => NULL,
1285: p_param3 => NULL,