APPS.GMD_QC_MIG12 dependencies on GMD_TEST_METHODS_B

Line 64: p_param1 => 'gmd_test_methods_b',

60: p_token2 => 'PRO',
61: p_token3 => 'UPD',
62: p_token4 => 'INS',
63: p_token5 => 'ERR',
64: p_param1 => 'gmd_test_methods_b',
65: p_param2 => to_char(GMD_QC_MIG12.g_test_method_pro_count),
66: p_param3 => to_char(GMD_QC_MIG12.g_test_method_upd_count),
67: p_param4 => 0,
68: p_param5 => to_char(GMD_QC_MIG12.g_test_method_err_count),

Line 1034: -- gmd_test_methods_b - test_qty_uom

1030: -- x_exception_count OUT NUMBER - Exception Count
1031: --
1032: -- The following columns will be migrated by the Common migration script.
1033: --
1034: -- gmd_test_methods_b - test_qty_uom
1035: -- gmd_quality_config - organization_id
1036: -- gmd_sampling_plans - sample_qty_uom
1037: -- gmd_uom_conversions - from_qty_uom
1038: -- gmd_uom_conversions - from_qty_uom_base

Line 1092: FROM gmd_test_methods_b

1088:
1089: CURSOR get_test_methods IS
1090: SELECT test_method_id, test_kit_item_id, test_kit_inv_item_id,
1091: test_kit_organization_id
1092: FROM gmd_test_methods_b
1093: WHERE migrated_ind IS NULL;
1094:
1095:
1096: /*=========================

Line 1346: p_param1 => 'GMD_TEST_METHODS_B',

1342: p_log_level => FND_LOG.LEVEL_EVENT,
1343: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1344: p_table_name => 'GMD_QUALITY_CONFIG',
1345: p_token1 => 'TABLE_NAME',
1346: p_param1 => 'GMD_TEST_METHODS_B',
1347: p_context => 'Quality Setup',
1348: p_app_short_name => 'GMA');
1349:
1350: GMD_QC_MIG12.g_progress_ind := 1;

Line 1396: UPDATE gmd_test_methods_b

1392: l_inventory_item_id := NULL;
1393: END IF;
1394: END IF;
1395:
1396: UPDATE gmd_test_methods_b
1397: SET test_kit_inv_item_id = l_inventory_item_id,
1398: test_kit_organization_id = l_test_org,
1399: migrated_ind = 1
1400: WHERE test_method_id = v_test_method.test_method_id;

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

1411: GMA_COMMON_LOGGING.gma_migration_central_log (
1412: p_run_id => p_migration_run_id,
1413: p_log_level => FND_LOG.LEVEL_ERROR,
1414: p_message_token => 'GMD_MIG_INVALID_ITEM',
1415: p_context => 'Quality Setup - gmd_test_methods_b',
1416: p_token1 => 'ORG',
1417: p_token2 => 'ITEMID',
1418: p_token3 => 'ROWK',
1419: p_token4 => 'ROWV',

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

1432: GMA_COMMON_LOGGING.gma_migration_central_log (
1433: p_run_id => p_migration_run_id,
1434: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1435: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1436: p_context => 'Quality Setup - gmd_test_methods_b',
1437: p_db_error => SQLERRM,
1438: p_app_short_name => 'GMA');
1439: GMD_QC_MIG12.g_test_method_err_count := GMD_QC_MIG12.g_test_method_err_count + 1;
1440: x_exception_count := x_exception_count + 1;