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_CUSTOMER_SPEC_VRS

Line 306: p_param1 => 'gmd_customer_spec_vrs',

302: p_token2 => 'PRO',
303: p_token3 => 'UPD',
304: p_token4 => 'INS',
305: p_token5 => 'ERR',
306: p_param1 => 'gmd_customer_spec_vrs',
307: p_param2 => to_char(GMD_QC_MIG12.g_cust_spec_pro_count),
308: p_param3 => to_char(GMD_QC_MIG12.g_cust_spec_upd_count),
309: p_param4 => to_char(GMD_QC_MIG12.g_cust_spec_ins_count),
310: p_param5 => to_char(GMD_QC_MIG12.g_cust_spec_err_count),

Line 319: p_param1 => 'gmd_customer_spec_vrs',

315: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
316: p_context => 'Quality Specifications',
317: p_token1 => 'TAB',
318: p_token2 => 'DEL',
319: p_param1 => 'gmd_customer_spec_vrs',
320: p_param2 => to_char(GMD_QC_MIG12.g_cust_spec_del_count),
321: p_app_short_name => 'GMD');
322: END IF;
323:

Line 3895: -- gmd_customer_spec_vrs organization_id

3891: -- gmd_spec_tests_b test_qty_uom
3892: -- gmd_spec_tests_b to_qty_uom
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: --===========================================================================*/

Line 4180: Cursor for gmd_customer_spec_vrs.

4176: (charge = l_wip_spec.charge)
4177: );
4178:
4179: /*=======================================
4180: Cursor for gmd_customer_spec_vrs.
4181: =======================================*/
4182:
4183: CURSOR get_cust_spec IS
4184: SELECT * from gmd_customer_spec_vrs

Line 4184: SELECT * from gmd_customer_spec_vrs

4180: Cursor for gmd_customer_spec_vrs.
4181: =======================================*/
4182:
4183: CURSOR get_cust_spec IS
4184: SELECT * from gmd_customer_spec_vrs
4185: WHERE migrated_ind IS NULL
4186: ORDER BY orgn_code;
4187:
4188: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;

Line 4188: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;

4184: SELECT * from gmd_customer_spec_vrs
4185: WHERE migrated_ind IS NULL
4186: ORDER BY orgn_code;
4187:
4188: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;
4189:
4190: /*=======================================
4191: Cursor to get orgn_codes for sample
4192: that customer validity rule is tied to.

Line 4198: gmd_customer_spec_vrs gcsv

4194:
4195: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4196: SELECT DISTINCT gse.orgn_code, gse.organization_id
4197: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4198: gmd_customer_spec_vrs gcsv
4199: WHERE gse.sampling_event_id = gesd.sampling_event_id
4200: AND gesd.spec_vr_id = gcsv.spec_vr_id
4201: AND gcsv.spec_vr_id = v_spec_id;
4202:

Line 4213: FROM gmd_customer_spec_vrs

4209: -- Commented the following cursor definition and added it with the new where clause.
4210:
4211: /*CURSOR check_cust_spec IS
4212: SELECT spec_vr_id
4213: FROM gmd_customer_spec_vrs
4214: WHERE orgn_code = l_sample_orgn_code;*/
4215:
4216: CURSOR check_cust_spec IS
4217: SELECT spec_vr_id

Line 4218: FROM gmd_customer_spec_vrs

4214: WHERE orgn_code = l_sample_orgn_code;*/
4215:
4216: CURSOR check_cust_spec IS
4217: SELECT spec_vr_id
4218: FROM gmd_customer_spec_vrs
4219: WHERE orgn_code = l_sample_orgn_code
4220: AND spec_id = l_cust_spec.spec_id
4221: AND ( (cust_id IS NULL AND l_cust_spec.cust_id IS NULL) OR
4222: (cust_id = l_cust_spec.cust_id)

Line 5863: Migrate gmd_customer_spec_vrs.

5859:
5860: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5861:
5862: /*=======================================
5863: Migrate gmd_customer_spec_vrs.
5864: =======================================*/
5865:
5866: GMA_COMMON_LOGGING.gma_migration_central_log (
5867: p_run_id => p_migration_run_id,

Line 5870: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',

5866: GMA_COMMON_LOGGING.gma_migration_central_log (
5867: p_run_id => p_migration_run_id,
5868: p_log_level => FND_LOG.LEVEL_EVENT,
5869: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5870: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
5871: p_token1 => 'TABLE_NAME',
5872: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',
5873: p_context => 'Quality Specifications',
5874: p_app_short_name => 'GMA');

Line 5872: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',

5868: p_log_level => FND_LOG.LEVEL_EVENT,
5869: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5870: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
5871: p_token1 => 'TABLE_NAME',
5872: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',
5873: p_context => 'Quality Specifications',
5874: p_app_short_name => 'GMA');
5875:
5876: GMD_QC_MIG12.g_progress_ind := 4;

Line 5892: Update gmd_customer_spec_vrs.

5888: END IF;
5889:
5890: IF (l_cust_spec.organization_id IS NOT NULL) THEN
5891: /*====================================
5892: Update gmd_customer_spec_vrs.
5893: ====================================*/
5894: UPDATE gmd_customer_spec_vrs
5895: SET migrated_ind = 1
5896: WHERE spec_vr_id = l_cust_spec.spec_vr_id;

Line 5894: UPDATE gmd_customer_spec_vrs

5890: IF (l_cust_spec.organization_id IS NOT NULL) THEN
5891: /*====================================
5892: Update gmd_customer_spec_vrs.
5893: ====================================*/
5894: UPDATE gmd_customer_spec_vrs
5895: SET migrated_ind = 1
5896: WHERE spec_vr_id = l_cust_spec.spec_vr_id;
5897:
5898: IF (p_commit = FND_API.G_TRUE) THEN

Line 5921: DELETE gmd_customer_spec_vrs

5917: /*==========================================
5918: This is not marked as an error.
5919: ==========================================*/
5920:
5921: DELETE gmd_customer_spec_vrs
5922: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5923:
5924: IF (p_commit = FND_API.G_TRUE) THEN
5925: COMMIT;

Line 5957: Update gmd_customer_spec_vrs.

5953: END IF;
5954: END IF;
5955:
5956: /*=====================================
5957: Update gmd_customer_spec_vrs.
5958: =====================================*/
5959: UPDATE gmd_customer_spec_vrs
5960: SET orgn_code = l_sample_orgn_code,
5961: organization_id = l_sample_organization_id,

Line 5959: UPDATE gmd_customer_spec_vrs

5955:
5956: /*=====================================
5957: Update gmd_customer_spec_vrs.
5958: =====================================*/
5959: UPDATE gmd_customer_spec_vrs
5960: SET orgn_code = l_sample_orgn_code,
5961: organization_id = l_sample_organization_id,
5962: migrated_ind = 1
5963: WHERE spec_vr_id = l_cust_spec.spec_vr_id;

Line 5978: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

5974: GMA_COMMON_LOGGING.gma_migration_central_log (
5975: p_run_id => p_migration_run_id,
5976: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5977: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5978: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5979: p_db_error => SQLERRM,
5980: p_app_short_name => 'GMA');
5981: ROLLBACK;
5982: x_exception_count := x_exception_count + 1;

Line 6023: INSERT INTO gmd_customer_spec_vrs

6019: ELSE
6020: l_text_code := NULL;
6021: END IF;
6022:
6023: INSERT INTO gmd_customer_spec_vrs
6024: (
6025: SPEC_VR_ID,
6026: SPEC_ID,
6027: ORGN_CODE,

Line 6126: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

6122: GMA_COMMON_LOGGING.gma_migration_central_log (
6123: p_run_id => p_migration_run_id,
6124: p_log_level => FND_LOG.LEVEL_ERROR,
6125: p_message_token => 'GMD_MIG_NO_ORG',
6126: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
6127: p_token1 => 'ORG',
6128: p_token2 => 'ONAME',
6129: p_token3 => 'ROWK',
6130: p_token4 => 'ROWV',

Line 6146: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

6142: p_run_id => p_migration_run_id,
6143: p_log_level => FND_LOG.LEVEL_ERROR,
6144: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6145: p_table_name => NULL,
6146: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
6147: p_token1 => 'TAB',
6148: p_param1 => 'gmd_customer_spec_vrs',
6149: p_app_short_name => 'GMD');
6150:

Line 6148: p_param1 => 'gmd_customer_spec_vrs',

6144: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6145: p_table_name => NULL,
6146: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
6147: p_token1 => 'TAB',
6148: p_param1 => 'gmd_customer_spec_vrs',
6149: p_app_short_name => 'GMD');
6150:
6151:
6152: WHEN CUST_NO_ORG_ID THEN

Line 6158: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

6154: p_run_id => p_migration_run_id,
6155: p_log_level => FND_LOG.LEVEL_ERROR,
6156: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6157: p_table_name => NULL,
6158: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
6159: p_token1 => 'ORG',
6160: p_token2 => 'ROWK',
6161: p_token3 => 'ROWV',
6162: p_param1 => l_sample_orgn_code,

Line 6176: p_context => 'Quality Specifications - gmd_customer_spec_vrs',

6172: GMA_COMMON_LOGGING.gma_migration_central_log (
6173: p_run_id => p_migration_run_id,
6174: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6175: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6176: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
6177: p_db_error => SQLERRM,
6178: p_app_short_name => 'GMA');
6179: ROLLBACK;
6180: x_exception_count := x_exception_count + 1;

Line 6190: Log end of gmd_customer_spec_vrs migration.

6186:
6187:
6188:
6189: /*==============================================
6190: Log end of gmd_customer_spec_vrs migration.
6191: ==============================================*/
6192:
6193: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6194: