eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_MIG12 dependencies on GMD_MONITORING_SPEC_VRS

Line 364: p_param1 => 'gmd_monitoring_spec_vrs',

360: p_token2 => 'PRO',
361: p_token3 => 'UPD',
362: p_token4 => 'INS',
363: p_token5 => 'ERR',
364: p_param1 => 'gmd_monitoring_spec_vrs',
365: p_param2 => to_char(GMD_QC_MIG12.g_mon_spec_pro_count),
366: p_param3 => to_char(GMD_QC_MIG12.g_mon_spec_upd_count),
367: p_param4 => to_char(GMD_QC_MIG12.g_mon_spec_ins_count),
368: p_param5 => to_char(GMD_QC_MIG12.g_mon_spec_err_count),

Line 377: p_param1 => 'gmd_monitoring_spec_vrs',

373: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
374: p_context => 'Quality Specifications',
375: p_token1 => 'TAB',
376: p_token2 => 'DEL',
377: p_param1 => 'gmd_monitoring_spec_vrs',
378: p_param2 => to_char(GMD_QC_MIG12.g_mon_spec_del_count),
379: p_app_short_name => 'GMD');
380: END IF;
381:

Line 3897: -- gmd_monitoring_spec_vrs organization_id

3893: -- gmd_inventory_spec_vrs organization_id
3894: -- gmd_wip_spec_vrs organization_id
3895: -- gmd_customer_spec_vrs organization_id
3896: -- gmd_supplier_spec_vrs organization_id
3897: -- gmd_monitoring_spec_vrs organization_id
3898: -- gmd_monitoring_spec_vrs resource_organization_id
3899: --===========================================================================*/
3900:
3901: PROCEDURE GMD_QC_MIGRATE_SPECS

Line 3898: -- gmd_monitoring_spec_vrs resource_organization_id

3894: -- gmd_wip_spec_vrs organization_id
3895: -- gmd_customer_spec_vrs organization_id
3896: -- gmd_supplier_spec_vrs organization_id
3897: -- gmd_monitoring_spec_vrs organization_id
3898: -- gmd_monitoring_spec_vrs resource_organization_id
3899: --===========================================================================*/
3900:
3901: PROCEDURE GMD_QC_MIGRATE_SPECS
3902: ( p_migration_run_id IN NUMBER

Line 4298: Cursor for gmd_monitoring_spec_vrs.

4294: );
4295:
4296:
4297: /*=======================================
4298: Cursor for gmd_monitoring_spec_vrs.
4299: =======================================*/
4300:
4301: -- Bug# 5097487
4302: -- Added rule_type = 'L' in the where clause since we dont want to process VR for resource as it is already done by gma upgrade script

Line 4305: FROM gmd_monitoring_spec_vrs

4301: -- Bug# 5097487
4302: -- Added rule_type = 'L' in the where clause since we dont want to process VR for resource as it is already done by gma upgrade script
4303: CURSOR get_monitor_spec IS
4304: SELECT *
4305: FROM gmd_monitoring_spec_vrs
4306: WHERE migrated_ind IS NULL
4307: AND rule_type = 'L'
4308: ORDER BY loct_orgn_code;
4309:

Line 4310: l_mon_spec gmd_monitoring_spec_vrs%ROWTYPE;

4306: WHERE migrated_ind IS NULL
4307: AND rule_type = 'L'
4308: ORDER BY loct_orgn_code;
4309:
4310: l_mon_spec gmd_monitoring_spec_vrs%ROWTYPE;
4311:
4312: /*==========================================
4313: Cursor to get orgn_codes for sample
4314: that monitoring validity rule is tied to.

Line 4317: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS

4313: Cursor to get orgn_codes for sample
4314: that monitoring validity rule is tied to.
4315: ==========================================*/
4316:
4317: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4318: SELECT DISTINCT gse.orgn_code, gse.organization_id
4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4320: gmd_monitoring_spec_vrs gmsv
4321: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 4320: gmd_monitoring_spec_vrs gmsv

4316:
4317: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4318: SELECT DISTINCT gse.orgn_code, gse.organization_id
4319: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4320: gmd_monitoring_spec_vrs gmsv
4321: WHERE gse.sampling_event_id = gesd.sampling_event_id
4322: AND gesd.spec_vr_id = gmsv.spec_vr_id
4323: AND gmsv.spec_vr_id = v_spec_id;
4324:

Line 4335: FROM gmd_monitoring_spec_vrs

4331: -- Commented the following cursor definition and added it with the new where clause.
4332:
4333: /*CURSOR check_mon_spec IS
4334: SELECT spec_vr_id
4335: FROM gmd_monitoring_spec_vrs
4336: WHERE loct_orgn_code = l_sample_orgn_code
4337: AND whse_code = l_mon_spec.whse_code
4338: AND location = l_mon_spec.location;*/
4339:

Line 4342: FROM gmd_monitoring_spec_vrs

4338: AND location = l_mon_spec.location;*/
4339:
4340: CURSOR check_mon_spec IS
4341: SELECT spec_vr_id
4342: FROM gmd_monitoring_spec_vrs
4343: WHERE loct_orgn_code = l_sample_orgn_code
4344: AND spec_id = l_mon_spec.spec_id
4345: AND ( (whse_code IS NULL AND l_mon_spec.whse_code IS NULL) OR
4346: (whse_code = l_mon_spec.whse_code)

Line 6611: Migrate gmd_monitoring_spec_vrs;

6607:
6608: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6609:
6610: /*====================================
6611: Migrate gmd_monitoring_spec_vrs;
6612: ====================================*/
6613:
6614: GMA_COMMON_LOGGING.gma_migration_central_log (
6615: p_run_id => p_migration_run_id,

Line 6618: p_table_name => 'GMD_MONITORING_SPEC_VRS',

6614: GMA_COMMON_LOGGING.gma_migration_central_log (
6615: p_run_id => p_migration_run_id,
6616: p_log_level => FND_LOG.LEVEL_EVENT,
6617: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6618: p_table_name => 'GMD_MONITORING_SPEC_VRS',
6619: p_token1 => 'TABLE_NAME',
6620: p_param1 => 'GMD_MONITORING_SPEC_VRS',
6621: p_context => 'Quality Specifications',
6622: p_app_short_name => 'GMA');

Line 6620: p_param1 => 'GMD_MONITORING_SPEC_VRS',

6616: p_log_level => FND_LOG.LEVEL_EVENT,
6617: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6618: p_table_name => 'GMD_MONITORING_SPEC_VRS',
6619: p_token1 => 'TABLE_NAME',
6620: p_param1 => 'GMD_MONITORING_SPEC_VRS',
6621: p_context => 'Quality Specifications',
6622: p_app_short_name => 'GMA');
6623:
6624: GMD_QC_MIG12.g_progress_ind := 6;

Line 6744: UPDATE gmd_monitoring_spec_vrs

6740:
6741:
6742:
6743: IF (l_mon_spec.loct_orgn_code IS NOT NULL) THEN
6744: UPDATE gmd_monitoring_spec_vrs
6745: SET locator_organization_id = l_organization_id,
6746: subinventory = l_subinventory,
6747: locator_id = l_locator_id,
6748: migrated_ind = 1

Line 6774: DELETE gmd_monitoring_spec_vrs

6770: /*==========================================
6771: This is not marked as an error.
6772: ==========================================*/
6773:
6774: DELETE gmd_monitoring_spec_vrs
6775: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6776:
6777: IF (p_commit = FND_API.G_TRUE) THEN
6778: COMMIT;

Line 6811: UPDATE gmd_monitoring_spec_vrs

6807: RAISE MON_NO_ORG_ID;
6808: END IF;
6809: END IF;
6810:
6811: UPDATE gmd_monitoring_spec_vrs
6812: SET locator_organization_id = l_sample_organization_id,
6813: loct_orgn_code = l_sample_orgn_code,
6814: subinventory = l_subinventory,
6815: locator_id = l_locator_id,

Line 6873: INSERT INTO gmd_monitoring_spec_vrs

6869: ELSE
6870: l_text_code := NULL;
6871: END IF;
6872:
6873: INSERT INTO gmd_monitoring_spec_vrs
6874: (
6875: SPEC_VR_ID,
6876: SPEC_ID,
6877: RULE_TYPE,

Line 6972: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

6968: GMA_COMMON_LOGGING.gma_migration_central_log (
6969: p_run_id => p_migration_run_id,
6970: p_log_level => FND_LOG.LEVEL_ERROR,
6971: p_message_token => 'GMD_MIG_NO_ORG',
6972: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6973: p_token1 => 'ORG',
6974: p_token2 => 'ONAME',
6975: p_token3 => 'ROWK',
6976: p_token4 => 'ROWV',

Line 6990: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

6986: GMA_COMMON_LOGGING.gma_migration_central_log (
6987: p_run_id => p_migration_run_id,
6988: p_log_level => FND_LOG.LEVEL_ERROR,
6989: p_message_token => 'GMD_MIG_NO_ORG',
6990: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6991: p_token1 => 'ORG',
6992: p_token2 => 'ONAME',
6993: p_token3 => 'ROWK',
6994: p_token4 => 'ROWV',

Line 7008: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7004: GMA_COMMON_LOGGING.gma_migration_central_log (
7005: p_run_id => p_migration_run_id,
7006: p_log_level => FND_LOG.LEVEL_ERROR,
7007: p_message_token => 'GMD_MIG_WHSE_ERROR',
7008: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7009: p_token1 => 'WHSE',
7010: p_token2 => 'WNAME',
7011: p_token3 => 'ROWK',
7012: p_token4 => 'ROWV',

Line 7027: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7023: p_run_id => p_migration_run_id,
7024: p_log_level => FND_LOG.LEVEL_ERROR,
7025: p_message_token => 'GMD_MIG_MSPEC_SUB_MISMATCH',
7026: p_table_name => NULL,
7027: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7028: p_token1 => 'VRID',
7029: p_token2 => 'ORG',
7030: p_token3 => 'WHSE',
7031: p_token4 => 'ORGID',

Line 7047: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7043: GMA_COMMON_LOGGING.gma_migration_central_log (
7044: p_run_id => p_migration_run_id,
7045: p_log_level => FND_LOG.LEVEL_ERROR,
7046: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7047: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7048: p_token1 => 'ROWK',
7049: p_token2 => 'ROWV',
7050: p_token3 => 'FNAME',
7051: p_param1 => 'SPEC_VR_ID',

Line 7063: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7059: GMA_COMMON_LOGGING.gma_migration_central_log (
7060: p_run_id => p_migration_run_id,
7061: p_log_level => FND_LOG.LEVEL_ERROR,
7062: p_message_token => 'GMD_MIG_LOCATOR_ID',
7063: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7064: p_token1 => 'WHSE',
7065: p_token2 => 'LOCATION',
7066: p_token3 => 'LFIELD',
7067: p_token4 => 'ROWK',

Line 7083: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7079: GMA_COMMON_LOGGING.gma_migration_central_log (
7080: p_run_id => p_migration_run_id,
7081: p_log_level => FND_LOG.LEVEL_ERROR,
7082: p_message_token => 'GMD_MIG_SUBINV',
7083: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7084: p_token1 => 'LOCATOR',
7085: p_token2 => 'ROWK',
7086: p_token3 => 'ROWV',
7087: p_param1 => to_char(l_locator_id),

Line 7101: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7097: p_run_id => p_migration_run_id,
7098: p_log_level => FND_LOG.LEVEL_ERROR,
7099: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
7100: p_table_name => NULL,
7101: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7102: p_token1 => 'TAB',
7103: p_param1 => 'gmd_monitoring_spec_vrs',
7104: p_app_short_name => 'GMD');
7105:

Line 7103: p_param1 => 'gmd_monitoring_spec_vrs',

7099: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
7100: p_table_name => NULL,
7101: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7102: p_token1 => 'TAB',
7103: p_param1 => 'gmd_monitoring_spec_vrs',
7104: p_app_short_name => 'GMD');
7105:
7106: WHEN MON_NO_ORG_ID THEN
7107: GMA_COMMON_LOGGING.gma_migration_central_log (

Line 7112: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',

7108: p_run_id => p_migration_run_id,
7109: p_log_level => FND_LOG.LEVEL_ERROR,
7110: p_message_token => 'GMD_MIG_NULL_ORG_ID',
7111: p_table_name => NULL,
7112: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
7113: p_token1 => 'ORG',
7114: p_token2 => 'ROWK',
7115: p_token3 => 'ROWV',
7116: p_param1 => l_sample_orgn_code,

Line 7129: Log end of gmd_monitoring_spec_vrs migration.

7125: END LOOP;
7126:
7127:
7128: /*==============================================
7129: Log end of gmd_monitoring_spec_vrs migration.
7130: ==============================================*/
7131:
7132: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7133: