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 298: p_param1 => 'gmd_customer_spec_vrs',

294: p_token2 => 'PRO',
295: p_token3 => 'UPD',
296: p_token4 => 'INS',
297: p_token5 => 'ERR',
298: p_param1 => 'gmd_customer_spec_vrs',
299: p_param2 => to_char(GMD_QC_MIG12.g_cust_spec_pro_count),
300: p_param3 => to_char(GMD_QC_MIG12.g_cust_spec_upd_count),
301: p_param4 => to_char(GMD_QC_MIG12.g_cust_spec_ins_count),
302: p_param5 => to_char(GMD_QC_MIG12.g_cust_spec_err_count),

Line 311: p_param1 => 'gmd_customer_spec_vrs',

307: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
308: p_context => 'Quality Specifications',
309: p_token1 => 'TAB',
310: p_token2 => 'DEL',
311: p_param1 => 'gmd_customer_spec_vrs',
312: p_param2 => to_char(GMD_QC_MIG12.g_cust_spec_del_count),
313: p_app_short_name => 'GMD');
314: END IF;
315:

Line 3626: -- gmd_customer_spec_vrs organization_id

3622: -- gmd_spec_tests_b test_qty_uom
3623: -- gmd_spec_tests_b to_qty_uom
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: --===========================================================================*/

Line 3911: Cursor for gmd_customer_spec_vrs.

3907: (charge = l_wip_spec.charge)
3908: );
3909:
3910: /*=======================================
3911: Cursor for gmd_customer_spec_vrs.
3912: =======================================*/
3913:
3914: CURSOR get_cust_spec IS
3915: SELECT * from gmd_customer_spec_vrs

Line 3915: SELECT * from gmd_customer_spec_vrs

3911: Cursor for gmd_customer_spec_vrs.
3912: =======================================*/
3913:
3914: CURSOR get_cust_spec IS
3915: SELECT * from gmd_customer_spec_vrs
3916: WHERE migrated_ind IS NULL
3917: ORDER BY orgn_code;
3918:
3919: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;

Line 3919: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;

3915: SELECT * from gmd_customer_spec_vrs
3916: WHERE migrated_ind IS NULL
3917: ORDER BY orgn_code;
3918:
3919: l_cust_spec gmd_customer_spec_vrs%ROWTYPE;
3920:
3921: /*=======================================
3922: Cursor to get orgn_codes for sample
3923: that customer validity rule is tied to.

Line 3929: gmd_customer_spec_vrs gcsv

3925:
3926: CURSOR get_cust_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3927: SELECT DISTINCT gse.orgn_code, gse.organization_id
3928: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3929: gmd_customer_spec_vrs gcsv
3930: WHERE gse.sampling_event_id = gesd.sampling_event_id
3931: AND gesd.spec_vr_id = gcsv.spec_vr_id
3932: AND gcsv.spec_vr_id = v_spec_id;
3933:

Line 3944: FROM gmd_customer_spec_vrs

3940: -- Commented the following cursor definition and added it with the new where clause.
3941:
3942: /*CURSOR check_cust_spec IS
3943: SELECT spec_vr_id
3944: FROM gmd_customer_spec_vrs
3945: WHERE orgn_code = l_sample_orgn_code;*/
3946:
3947: CURSOR check_cust_spec IS
3948: SELECT spec_vr_id

Line 3949: FROM gmd_customer_spec_vrs

3945: WHERE orgn_code = l_sample_orgn_code;*/
3946:
3947: CURSOR check_cust_spec IS
3948: SELECT spec_vr_id
3949: FROM gmd_customer_spec_vrs
3950: WHERE orgn_code = l_sample_orgn_code
3951: AND spec_id = l_cust_spec.spec_id
3952: AND ( (cust_id IS NULL AND l_cust_spec.cust_id IS NULL) OR
3953: (cust_id = l_cust_spec.cust_id)

Line 5594: Migrate gmd_customer_spec_vrs.

5590:
5591: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5592:
5593: /*=======================================
5594: Migrate gmd_customer_spec_vrs.
5595: =======================================*/
5596:
5597: GMA_COMMON_LOGGING.gma_migration_central_log (
5598: p_run_id => p_migration_run_id,

Line 5601: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',

5597: GMA_COMMON_LOGGING.gma_migration_central_log (
5598: p_run_id => p_migration_run_id,
5599: p_log_level => FND_LOG.LEVEL_EVENT,
5600: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5601: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
5602: p_token1 => 'TABLE_NAME',
5603: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',
5604: p_context => 'Quality Specifications',
5605: p_app_short_name => 'GMA');

Line 5603: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',

5599: p_log_level => FND_LOG.LEVEL_EVENT,
5600: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5601: p_table_name => 'GMD_CUSTOMER_SPEC_VRS',
5602: p_token1 => 'TABLE_NAME',
5603: p_param1 => 'GMD_CUSTOMER_SPEC_VRS',
5604: p_context => 'Quality Specifications',
5605: p_app_short_name => 'GMA');
5606:
5607: GMD_QC_MIG12.g_progress_ind := 4;

Line 5623: Update gmd_customer_spec_vrs.

5619: END IF;
5620:
5621: IF (l_cust_spec.organization_id IS NOT NULL) THEN
5622: /*====================================
5623: Update gmd_customer_spec_vrs.
5624: ====================================*/
5625: UPDATE gmd_customer_spec_vrs
5626: SET migrated_ind = 1
5627: WHERE spec_vr_id = l_cust_spec.spec_vr_id;

Line 5625: UPDATE gmd_customer_spec_vrs

5621: IF (l_cust_spec.organization_id IS NOT NULL) THEN
5622: /*====================================
5623: Update gmd_customer_spec_vrs.
5624: ====================================*/
5625: UPDATE gmd_customer_spec_vrs
5626: SET migrated_ind = 1
5627: WHERE spec_vr_id = l_cust_spec.spec_vr_id;
5628:
5629: IF (p_commit = FND_API.G_TRUE) THEN

Line 5652: DELETE gmd_customer_spec_vrs

5648: /*==========================================
5649: This is not marked as an error.
5650: ==========================================*/
5651:
5652: DELETE gmd_customer_spec_vrs
5653: WHERE spec_vr_id = l_wip_spec.spec_vr_id;
5654:
5655: IF (p_commit = FND_API.G_TRUE) THEN
5656: COMMIT;

Line 5688: Update gmd_customer_spec_vrs.

5684: END IF;
5685: END IF;
5686:
5687: /*=====================================
5688: Update gmd_customer_spec_vrs.
5689: =====================================*/
5690: UPDATE gmd_customer_spec_vrs
5691: SET orgn_code = l_sample_orgn_code,
5692: organization_id = l_sample_organization_id,

Line 5690: UPDATE gmd_customer_spec_vrs

5686:
5687: /*=====================================
5688: Update gmd_customer_spec_vrs.
5689: =====================================*/
5690: UPDATE gmd_customer_spec_vrs
5691: SET orgn_code = l_sample_orgn_code,
5692: organization_id = l_sample_organization_id,
5693: migrated_ind = 1
5694: WHERE spec_vr_id = l_cust_spec.spec_vr_id;

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

5705: GMA_COMMON_LOGGING.gma_migration_central_log (
5706: p_run_id => p_migration_run_id,
5707: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5708: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5709: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5710: p_db_error => SQLERRM,
5711: p_app_short_name => 'GMA');
5712: ROLLBACK;
5713: x_exception_count := x_exception_count + 1;

Line 5754: INSERT INTO gmd_customer_spec_vrs

5750: ELSE
5751: l_text_code := NULL;
5752: END IF;
5753:
5754: INSERT INTO gmd_customer_spec_vrs
5755: (
5756: SPEC_VR_ID,
5757: SPEC_ID,
5758: ORGN_CODE,

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

5853: GMA_COMMON_LOGGING.gma_migration_central_log (
5854: p_run_id => p_migration_run_id,
5855: p_log_level => FND_LOG.LEVEL_ERROR,
5856: p_message_token => 'GMD_MIG_NO_ORG',
5857: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5858: p_token1 => 'ORG',
5859: p_token2 => 'ONAME',
5860: p_token3 => 'ROWK',
5861: p_token4 => 'ROWV',

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

5873: p_run_id => p_migration_run_id,
5874: p_log_level => FND_LOG.LEVEL_ERROR,
5875: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5876: p_table_name => NULL,
5877: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5878: p_token1 => 'TAB',
5879: p_param1 => 'gmd_customer_spec_vrs',
5880: p_app_short_name => 'GMD');
5881:

Line 5879: p_param1 => 'gmd_customer_spec_vrs',

5875: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
5876: p_table_name => NULL,
5877: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5878: p_token1 => 'TAB',
5879: p_param1 => 'gmd_customer_spec_vrs',
5880: p_app_short_name => 'GMD');
5881:
5882:
5883: WHEN CUST_NO_ORG_ID THEN

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

5885: p_run_id => p_migration_run_id,
5886: p_log_level => FND_LOG.LEVEL_ERROR,
5887: p_message_token => 'GMD_MIG_NULL_ORG_ID',
5888: p_table_name => NULL,
5889: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5890: p_token1 => 'ORG',
5891: p_token2 => 'ROWK',
5892: p_token3 => 'ROWV',
5893: p_param1 => l_sample_orgn_code,

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

5903: GMA_COMMON_LOGGING.gma_migration_central_log (
5904: p_run_id => p_migration_run_id,
5905: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
5906: p_message_token => 'GMA_MIGRATION_DB_ERROR',
5907: p_context => 'Quality Specifications - gmd_customer_spec_vrs',
5908: p_db_error => SQLERRM,
5909: p_app_short_name => 'GMA');
5910: ROLLBACK;
5911: x_exception_count := x_exception_count + 1;

Line 5921: Log end of gmd_customer_spec_vrs migration.

5917:
5918:
5919:
5920: /*==============================================
5921: Log end of gmd_customer_spec_vrs migration.
5922: ==============================================*/
5923:
5924: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
5925: