DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_TESTS_B

Line 1297: FROM gmd_tests_b

1293: attribute28,
1294: attribute29,
1295: attribute30,
1296: attribute_category
1297: FROM gmd_tests_b
1298: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1299:
1300:
1301: -- Bug 3097029; expression error type requires at least

Line 1318: UPDATE gmd_tests_b

1314:
1315:
1316:
1317: /* Updated record status to migrated */
1318: UPDATE gmd_tests_b
1319: SET migration_status = 'MO';
1320:
1321: l_rec_count := SQL%ROWCOUNT;
1322:

Line 1325: p_table_name => 'GMD_TESTS_B',

1321: l_rec_count := SQL%ROWCOUNT;
1322:
1323: GMA_MIGRATION.gma_insert_message (
1324: p_run_id => p_migration_id,
1325: p_table_name => 'GMD_TESTS_B',
1326: p_DB_ERROR => '',
1327: p_param1 => '',
1328: p_param2 => l_rec_count,
1329: p_param3 => '',

Line 1346: p_table_name => 'GMD_TESTS_B',

1342: WHEN OTHERS THEN
1343: x_return_status := 'U';
1344: GMA_MIGRATION.gma_insert_message (
1345: p_run_id => p_migration_id,
1346: p_table_name => 'GMD_TESTS_B',
1347: p_DB_ERROR => sqlerrm,
1348: p_param1 => '',
1349: p_param2 => '',
1350: p_param3 => '',

Line 1361: p_table_name => 'GMD_TESTS_B',

1357: p_base_message => 'Failed to migrate tests base due to '||sqlerrm);
1358:
1359: GMA_MIGRATION.gma_insert_message (
1360: p_run_id => p_migration_id,
1361: p_table_name => 'GMD_TESTS_B',
1362: p_DB_ERROR => '',
1363: p_param1 => '',
1364: p_param2 => '',
1365: p_param3 => '',