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 356: p_param1 => 'gmd_monitoring_spec_vrs',

352: p_token2 => 'PRO',
353: p_token3 => 'UPD',
354: p_token4 => 'INS',
355: p_token5 => 'ERR',
356: p_param1 => 'gmd_monitoring_spec_vrs',
357: p_param2 => to_char(GMD_QC_MIG12.g_mon_spec_pro_count),
358: p_param3 => to_char(GMD_QC_MIG12.g_mon_spec_upd_count),
359: p_param4 => to_char(GMD_QC_MIG12.g_mon_spec_ins_count),
360: p_param5 => to_char(GMD_QC_MIG12.g_mon_spec_err_count),

Line 369: p_param1 => 'gmd_monitoring_spec_vrs',

365: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
366: p_context => 'Quality Specifications',
367: p_token1 => 'TAB',
368: p_token2 => 'DEL',
369: p_param1 => 'gmd_monitoring_spec_vrs',
370: p_param2 => to_char(GMD_QC_MIG12.g_mon_spec_del_count),
371: p_app_short_name => 'GMD');
372: END IF;
373:

Line 3628: -- gmd_monitoring_spec_vrs organization_id

3624: -- gmd_inventory_spec_vrs organization_id
3625: -- gmd_wip_spec_vrs organization_id
3626: -- gmd_customer_spec_vrs organization_id
3627: -- gmd_supplier_spec_vrs organization_id
3628: -- gmd_monitoring_spec_vrs organization_id
3629: -- gmd_monitoring_spec_vrs resource_organization_id
3630: --===========================================================================*/
3631:
3632: PROCEDURE GMD_QC_MIGRATE_SPECS

Line 3629: -- gmd_monitoring_spec_vrs resource_organization_id

3625: -- gmd_wip_spec_vrs organization_id
3626: -- gmd_customer_spec_vrs organization_id
3627: -- gmd_supplier_spec_vrs organization_id
3628: -- gmd_monitoring_spec_vrs organization_id
3629: -- gmd_monitoring_spec_vrs resource_organization_id
3630: --===========================================================================*/
3631:
3632: PROCEDURE GMD_QC_MIGRATE_SPECS
3633: ( p_migration_run_id IN NUMBER

Line 4029: Cursor for gmd_monitoring_spec_vrs.

4025: );
4026:
4027:
4028: /*=======================================
4029: Cursor for gmd_monitoring_spec_vrs.
4030: =======================================*/
4031:
4032: -- Bug# 5097487
4033: -- 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 4036: FROM gmd_monitoring_spec_vrs

4032: -- Bug# 5097487
4033: -- 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
4034: CURSOR get_monitor_spec IS
4035: SELECT *
4036: FROM gmd_monitoring_spec_vrs
4037: WHERE migrated_ind IS NULL
4038: AND rule_type = 'L'
4039: ORDER BY loct_orgn_code;
4040:

Line 4041: l_mon_spec gmd_monitoring_spec_vrs%ROWTYPE;

4037: WHERE migrated_ind IS NULL
4038: AND rule_type = 'L'
4039: ORDER BY loct_orgn_code;
4040:
4041: l_mon_spec gmd_monitoring_spec_vrs%ROWTYPE;
4042:
4043: /*==========================================
4044: Cursor to get orgn_codes for sample
4045: that monitoring validity rule is tied to.

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

4044: Cursor to get orgn_codes for sample
4045: that monitoring validity rule is tied to.
4046: ==========================================*/
4047:
4048: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4049: SELECT DISTINCT gse.orgn_code, gse.organization_id
4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4051: gmd_monitoring_spec_vrs gmsv
4052: WHERE gse.sampling_event_id = gesd.sampling_event_id

Line 4051: gmd_monitoring_spec_vrs gmsv

4047:
4048: CURSOR get_mon_sample_org (v_spec_id gmd_monitoring_spec_vrs.spec_vr_id%TYPE) IS
4049: SELECT DISTINCT gse.orgn_code, gse.organization_id
4050: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4051: gmd_monitoring_spec_vrs gmsv
4052: WHERE gse.sampling_event_id = gesd.sampling_event_id
4053: AND gesd.spec_vr_id = gmsv.spec_vr_id
4054: AND gmsv.spec_vr_id = v_spec_id;
4055:

Line 4066: FROM gmd_monitoring_spec_vrs

4062: -- Commented the following cursor definition and added it with the new where clause.
4063:
4064: /*CURSOR check_mon_spec IS
4065: SELECT spec_vr_id
4066: FROM gmd_monitoring_spec_vrs
4067: WHERE loct_orgn_code = l_sample_orgn_code
4068: AND whse_code = l_mon_spec.whse_code
4069: AND location = l_mon_spec.location;*/
4070:

Line 4073: FROM gmd_monitoring_spec_vrs

4069: AND location = l_mon_spec.location;*/
4070:
4071: CURSOR check_mon_spec IS
4072: SELECT spec_vr_id
4073: FROM gmd_monitoring_spec_vrs
4074: WHERE loct_orgn_code = l_sample_orgn_code
4075: AND spec_id = l_mon_spec.spec_id
4076: AND ( (whse_code IS NULL AND l_mon_spec.whse_code IS NULL) OR
4077: (whse_code = l_mon_spec.whse_code)

Line 6342: Migrate gmd_monitoring_spec_vrs;

6338:
6339: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6340:
6341: /*====================================
6342: Migrate gmd_monitoring_spec_vrs;
6343: ====================================*/
6344:
6345: GMA_COMMON_LOGGING.gma_migration_central_log (
6346: p_run_id => p_migration_run_id,

Line 6349: p_table_name => 'GMD_MONITORING_SPEC_VRS',

6345: GMA_COMMON_LOGGING.gma_migration_central_log (
6346: p_run_id => p_migration_run_id,
6347: p_log_level => FND_LOG.LEVEL_EVENT,
6348: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6349: p_table_name => 'GMD_MONITORING_SPEC_VRS',
6350: p_token1 => 'TABLE_NAME',
6351: p_param1 => 'GMD_MONITORING_SPEC_VRS',
6352: p_context => 'Quality Specifications',
6353: p_app_short_name => 'GMA');

Line 6351: p_param1 => 'GMD_MONITORING_SPEC_VRS',

6347: p_log_level => FND_LOG.LEVEL_EVENT,
6348: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6349: p_table_name => 'GMD_MONITORING_SPEC_VRS',
6350: p_token1 => 'TABLE_NAME',
6351: p_param1 => 'GMD_MONITORING_SPEC_VRS',
6352: p_context => 'Quality Specifications',
6353: p_app_short_name => 'GMA');
6354:
6355: GMD_QC_MIG12.g_progress_ind := 6;

Line 6475: UPDATE gmd_monitoring_spec_vrs

6471:
6472:
6473:
6474: IF (l_mon_spec.loct_orgn_code IS NOT NULL) THEN
6475: UPDATE gmd_monitoring_spec_vrs
6476: SET locator_organization_id = l_organization_id,
6477: subinventory = l_subinventory,
6478: locator_id = l_locator_id,
6479: migrated_ind = 1

Line 6505: DELETE gmd_monitoring_spec_vrs

6501: /*==========================================
6502: This is not marked as an error.
6503: ==========================================*/
6504:
6505: DELETE gmd_monitoring_spec_vrs
6506: WHERE spec_vr_id = l_mon_spec.spec_vr_id;
6507:
6508: IF (p_commit = FND_API.G_TRUE) THEN
6509: COMMIT;

Line 6542: UPDATE gmd_monitoring_spec_vrs

6538: RAISE MON_NO_ORG_ID;
6539: END IF;
6540: END IF;
6541:
6542: UPDATE gmd_monitoring_spec_vrs
6543: SET locator_organization_id = l_sample_organization_id,
6544: loct_orgn_code = l_sample_orgn_code,
6545: subinventory = l_subinventory,
6546: locator_id = l_locator_id,

Line 6604: INSERT INTO gmd_monitoring_spec_vrs

6600: ELSE
6601: l_text_code := NULL;
6602: END IF;
6603:
6604: INSERT INTO gmd_monitoring_spec_vrs
6605: (
6606: SPEC_VR_ID,
6607: SPEC_ID,
6608: RULE_TYPE,

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

6699: GMA_COMMON_LOGGING.gma_migration_central_log (
6700: p_run_id => p_migration_run_id,
6701: p_log_level => FND_LOG.LEVEL_ERROR,
6702: p_message_token => 'GMD_MIG_NO_ORG',
6703: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6704: p_token1 => 'ORG',
6705: p_token2 => 'ONAME',
6706: p_token3 => 'ROWK',
6707: p_token4 => 'ROWV',

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

6717: GMA_COMMON_LOGGING.gma_migration_central_log (
6718: p_run_id => p_migration_run_id,
6719: p_log_level => FND_LOG.LEVEL_ERROR,
6720: p_message_token => 'GMD_MIG_NO_ORG',
6721: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6722: p_token1 => 'ORG',
6723: p_token2 => 'ONAME',
6724: p_token3 => 'ROWK',
6725: p_token4 => 'ROWV',

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

6735: GMA_COMMON_LOGGING.gma_migration_central_log (
6736: p_run_id => p_migration_run_id,
6737: p_log_level => FND_LOG.LEVEL_ERROR,
6738: p_message_token => 'GMD_MIG_WHSE_ERROR',
6739: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6740: p_token1 => 'WHSE',
6741: p_token2 => 'WNAME',
6742: p_token3 => 'ROWK',
6743: p_token4 => 'ROWV',

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

6754: p_run_id => p_migration_run_id,
6755: p_log_level => FND_LOG.LEVEL_ERROR,
6756: p_message_token => 'GMD_MIG_MSPEC_SUB_MISMATCH',
6757: p_table_name => NULL,
6758: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6759: p_token1 => 'VRID',
6760: p_token2 => 'ORG',
6761: p_token3 => 'WHSE',
6762: p_token4 => 'ORGID',

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

6774: GMA_COMMON_LOGGING.gma_migration_central_log (
6775: p_run_id => p_migration_run_id,
6776: p_log_level => FND_LOG.LEVEL_ERROR,
6777: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
6778: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6779: p_token1 => 'ROWK',
6780: p_token2 => 'ROWV',
6781: p_token3 => 'FNAME',
6782: p_param1 => 'SPEC_VR_ID',

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

6790: GMA_COMMON_LOGGING.gma_migration_central_log (
6791: p_run_id => p_migration_run_id,
6792: p_log_level => FND_LOG.LEVEL_ERROR,
6793: p_message_token => 'GMD_MIG_LOCATOR_ID',
6794: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6795: p_token1 => 'WHSE',
6796: p_token2 => 'LOCATION',
6797: p_token3 => 'LFIELD',
6798: p_token4 => 'ROWK',

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

6810: GMA_COMMON_LOGGING.gma_migration_central_log (
6811: p_run_id => p_migration_run_id,
6812: p_log_level => FND_LOG.LEVEL_ERROR,
6813: p_message_token => 'GMD_MIG_SUBINV',
6814: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6815: p_token1 => 'LOCATOR',
6816: p_token2 => 'ROWK',
6817: p_token3 => 'ROWV',
6818: p_param1 => to_char(l_locator_id),

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

6828: p_run_id => p_migration_run_id,
6829: p_log_level => FND_LOG.LEVEL_ERROR,
6830: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6831: p_table_name => NULL,
6832: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6833: p_token1 => 'TAB',
6834: p_param1 => 'gmd_monitoring_spec_vrs',
6835: p_app_short_name => 'GMD');
6836:

Line 6834: p_param1 => 'gmd_monitoring_spec_vrs',

6830: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6831: p_table_name => NULL,
6832: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6833: p_token1 => 'TAB',
6834: p_param1 => 'gmd_monitoring_spec_vrs',
6835: p_app_short_name => 'GMD');
6836:
6837: WHEN MON_NO_ORG_ID THEN
6838: GMA_COMMON_LOGGING.gma_migration_central_log (

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

6839: p_run_id => p_migration_run_id,
6840: p_log_level => FND_LOG.LEVEL_ERROR,
6841: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6842: p_table_name => NULL,
6843: p_context => 'Quality Specifications - gmd_monitoring_spec_vrs',
6844: p_token1 => 'ORG',
6845: p_token2 => 'ROWK',
6846: p_token3 => 'ROWV',
6847: p_param1 => l_sample_orgn_code,

Line 6860: Log end of gmd_monitoring_spec_vrs migration.

6856: END LOOP;
6857:
6858:
6859: /*==============================================
6860: Log end of gmd_monitoring_spec_vrs migration.
6861: ==============================================*/
6862:
6863: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6864: