APPS.GMD_QC_MIG12 dependencies on GMD_TEST_METHODS_B

Line 56: p_param1 => 'gmd_test_methods_b',

52: p_token2 => 'PRO',
53: p_token3 => 'UPD',
54: p_token4 => 'INS',
55: p_token5 => 'ERR',
56: p_param1 => 'gmd_test_methods_b',
57: p_param2 => to_char(GMD_QC_MIG12.g_test_method_pro_count),
58: p_param3 => to_char(GMD_QC_MIG12.g_test_method_upd_count),
59: p_param4 => 0,
60: p_param5 => to_char(GMD_QC_MIG12.g_test_method_err_count),

Line 1026: -- gmd_test_methods_b - test_qty_uom

1022: -- x_exception_count OUT NUMBER - Exception Count
1023: --
1024: -- The following columns will be migrated by the Common migration script.
1025: --
1026: -- gmd_test_methods_b - test_qty_uom
1027: -- gmd_quality_config - organization_id
1028: -- gmd_sampling_plans - sample_qty_uom
1029: -- gmd_uom_conversions - from_qty_uom
1030: -- gmd_uom_conversions - from_qty_uom_base

Line 1084: FROM gmd_test_methods_b

1080:
1081: CURSOR get_test_methods IS
1082: SELECT test_method_id, test_kit_item_id, test_kit_inv_item_id,
1083: test_kit_organization_id
1084: FROM gmd_test_methods_b
1085: WHERE migrated_ind IS NULL;
1086:
1087:
1088: /*=========================

Line 1338: p_param1 => 'GMD_TEST_METHODS_B',

1334: p_log_level => FND_LOG.LEVEL_EVENT,
1335: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1336: p_table_name => 'GMD_QUALITY_CONFIG',
1337: p_token1 => 'TABLE_NAME',
1338: p_param1 => 'GMD_TEST_METHODS_B',
1339: p_context => 'Quality Setup',
1340: p_app_short_name => 'GMA');
1341:
1342: GMD_QC_MIG12.g_progress_ind := 1;

Line 1388: UPDATE gmd_test_methods_b

1384: l_inventory_item_id := NULL;
1385: END IF;
1386: END IF;
1387:
1388: UPDATE gmd_test_methods_b
1389: SET test_kit_inv_item_id = l_inventory_item_id,
1390: test_kit_organization_id = l_test_org,
1391: migrated_ind = 1
1392: WHERE test_method_id = v_test_method.test_method_id;

Line 1407: p_context => 'Quality Setup - gmd_test_methods_b',

1403: GMA_COMMON_LOGGING.gma_migration_central_log (
1404: p_run_id => p_migration_run_id,
1405: p_log_level => FND_LOG.LEVEL_ERROR,
1406: p_message_token => 'GMD_MIG_INVALID_ITEM',
1407: p_context => 'Quality Setup - gmd_test_methods_b',
1408: p_token1 => 'ORG',
1409: p_token2 => 'ITEMID',
1410: p_token3 => 'ROWK',
1411: p_token4 => 'ROWV',

Line 1428: p_context => 'Quality Setup - gmd_test_methods_b',

1424: GMA_COMMON_LOGGING.gma_migration_central_log (
1425: p_run_id => p_migration_run_id,
1426: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1427: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1428: p_context => 'Quality Setup - gmd_test_methods_b',
1429: p_db_error => SQLERRM,
1430: p_app_short_name => 'GMA');
1431: GMD_QC_MIG12.g_test_method_err_count := GMD_QC_MIG12.g_test_method_err_count + 1;
1432: x_exception_count := x_exception_count + 1;