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_SUPPLIER_SPEC_VRS

Line 327: p_param1 => 'gmd_supplier_spec_vrs',

323: p_token2 => 'PRO',
324: p_token3 => 'UPD',
325: p_token4 => 'INS',
326: p_token5 => 'ERR',
327: p_param1 => 'gmd_supplier_spec_vrs',
328: p_param2 => to_char(GMD_QC_MIG12.g_supl_spec_pro_count),
329: p_param3 => to_char(GMD_QC_MIG12.g_supl_spec_upd_count),
330: p_param4 => to_char(GMD_QC_MIG12.g_supl_spec_ins_count),
331: p_param5 => to_char(GMD_QC_MIG12.g_supl_spec_err_count),

Line 340: p_param1 => 'gmd_supplier_spec_vrs',

336: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
337: p_context => 'Quality Specifications',
338: p_token1 => 'TAB',
339: p_token2 => 'DEL',
340: p_param1 => 'gmd_supplier_spec_vrs',
341: p_param2 => to_char(GMD_QC_MIG12.g_supl_spec_del_count),
342: p_app_short_name => 'GMD');
343: END IF;
344:

Line 3627: -- gmd_supplier_spec_vrs organization_id

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: --===========================================================================*/
3631:

Line 3977: FROM gmd_supplier_spec_vrs

3973: =======================================*/
3974:
3975: CURSOR get_supplier_spec IS
3976: SELECT *
3977: FROM gmd_supplier_spec_vrs
3978: WHERE migrated_ind IS NULL
3979: ORDER BY orgn_code;
3980:
3981: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;

Line 3981: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;

3977: FROM gmd_supplier_spec_vrs
3978: WHERE migrated_ind IS NULL
3979: ORDER BY orgn_code;
3980:
3981: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;
3982:
3983: /*=======================================
3984: Cursor to get orgn_codes for sample
3985: that supplier validity rule is tied to.

Line 3991: gmd_supplier_spec_vrs gssv

3987:
3988: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
3989: SELECT DISTINCT gse.orgn_code, gse.organization_id
3990: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
3991: gmd_supplier_spec_vrs gssv
3992: WHERE gse.sampling_event_id = gesd.sampling_event_id
3993: AND gesd.spec_vr_id = gssv.spec_vr_id
3994: AND gssv.spec_vr_id = v_spec_id;
3995:

Line 4006: FROM gmd_supplier_spec_vrs

4002: -- Commented the following cursor definition and added it with the new where clause.
4003:
4004: /*CURSOR check_supl_spec IS
4005: SELECT spec_vr_id
4006: FROM gmd_supplier_spec_vrs
4007: WHERE orgn_code = l_sample_orgn_code;*/
4008:
4009: CURSOR check_supl_spec IS
4010: SELECT spec_vr_id

Line 4011: FROM gmd_supplier_spec_vrs

4007: WHERE orgn_code = l_sample_orgn_code;*/
4008:
4009: CURSOR check_supl_spec IS
4010: SELECT spec_vr_id
4011: FROM gmd_supplier_spec_vrs
4012: WHERE orgn_code = l_sample_orgn_code
4013: AND spec_id = l_supl_spec.spec_id
4014: AND ( (supplier_id IS NULL AND l_supl_spec.supplier_id IS NULL) OR
4015: (supplier_id = l_supl_spec.supplier_id)

Line 5929: Migrate gmd_supplier_spec_vrs.

5925:
5926:
5927:
5928: /*===================================
5929: Migrate gmd_supplier_spec_vrs.
5930: ===================================*/
5931:
5932: GMA_COMMON_LOGGING.gma_migration_central_log (
5933: p_run_id => p_migration_run_id,

Line 5936: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',

5932: GMA_COMMON_LOGGING.gma_migration_central_log (
5933: p_run_id => p_migration_run_id,
5934: p_log_level => FND_LOG.LEVEL_EVENT,
5935: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5936: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
5937: p_token1 => 'TABLE_NAME',
5938: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',
5939: p_context => 'Quality Specifications',
5940: p_app_short_name => 'GMA');

Line 5938: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',

5934: p_log_level => FND_LOG.LEVEL_EVENT,
5935: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
5936: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
5937: p_token1 => 'TABLE_NAME',
5938: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',
5939: p_context => 'Quality Specifications',
5940: p_app_short_name => 'GMA');
5941:
5942: GMD_QC_MIG12.g_progress_ind := 5;

Line 5995: Update gmd_supplier_spec_vrs.

5991:
5992:
5993: IF (l_supl_spec.organization_id IS NOT NULL) THEN
5994: /*=====================================
5995: Update gmd_supplier_spec_vrs.
5996: =====================================*/
5997:
5998: -- Bug# 5482253
5999: -- Added org_id in the update statement

Line 6000: UPDATE gmd_supplier_spec_vrs

5996: =====================================*/
5997:
5998: -- Bug# 5482253
5999: -- Added org_id in the update statement
6000: UPDATE gmd_supplier_spec_vrs
6001: SET out_of_spec_lot_status_id = l_out_spec_status_id,
6002: in_spec_lot_status_id = l_in_spec_status_id,
6003: org_id = l_supl_org_id,
6004: migrated_ind = 1

Line 6030: DELETE gmd_supplier_spec_vrs

6026: /*==========================================
6027: This is not marked as an error.
6028: ==========================================*/
6029:
6030: DELETE gmd_supplier_spec_vrs
6031: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6032:
6033: IF (p_commit = FND_API.G_TRUE) THEN
6034: COMMIT;

Line 6069: UPDATE gmd_supplier_spec_vrs

6065: END IF;
6066:
6067: -- Bug# 5482253
6068: -- Added org_id in the update statement
6069: UPDATE gmd_supplier_spec_vrs
6070: SET out_of_spec_lot_status_id = l_out_spec_status_id,
6071: in_spec_lot_status_id = l_in_spec_status_id,
6072: organization_id = l_sample_organization_id,
6073: orgn_code = l_sample_orgn_code,

Line 6126: INSERT INTO gmd_supplier_spec_vrs

6122: ELSE
6123: l_text_code := NULL;
6124: END IF;
6125:
6126: INSERT INTO gmd_supplier_spec_vrs
6127: (
6128: PO_HEADER_ID,
6129: SPEC_VR_ID,
6130: SPEC_ID,

Line 6242: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6238: GMA_COMMON_LOGGING.gma_migration_central_log (
6239: p_run_id => p_migration_run_id,
6240: p_log_level => FND_LOG.LEVEL_ERROR,
6241: p_message_token => 'GMD_MIG_NO_ORG',
6242: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6243: p_token1 => 'ORG',
6244: p_token2 => 'ONAME',
6245: p_token3 => 'ROWK',
6246: p_token4 => 'ROWV',

Line 6260: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6256: GMA_COMMON_LOGGING.gma_migration_central_log (
6257: p_run_id => p_migration_run_id,
6258: p_log_level => FND_LOG.LEVEL_ERROR,
6259: p_message_token => 'GMD_MIG_STATUS_ID',
6260: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6261: p_token1 => 'STAT',
6262: p_token2 => 'ROWK',
6263: p_token3 => 'ROWV',
6264: p_param1 => l_supl_spec.in_spec_lot_status,

Line 6276: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6272: GMA_COMMON_LOGGING.gma_migration_central_log (
6273: p_run_id => p_migration_run_id,
6274: p_log_level => FND_LOG.LEVEL_ERROR,
6275: p_message_token => 'GMD_MIG_STATUS_ID',
6276: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6277: p_token1 => 'STAT',
6278: p_token2 => 'ROWK',
6279: p_token3 => 'ROWV',
6280: p_param1 => l_supl_spec.out_of_spec_lot_status,

Line 6293: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6289: p_run_id => p_migration_run_id,
6290: p_log_level => FND_LOG.LEVEL_ERROR,
6291: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6292: p_table_name => NULL,
6293: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6294: p_token1 => 'TAB',
6295: p_param1 => 'gmd_supplier_spec_vrs',
6296: p_app_short_name => 'GMD');
6297:

Line 6295: p_param1 => 'gmd_supplier_spec_vrs',

6291: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6292: p_table_name => NULL,
6293: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6294: p_token1 => 'TAB',
6295: p_param1 => 'gmd_supplier_spec_vrs',
6296: p_app_short_name => 'GMD');
6297:
6298:
6299: WHEN SUP_NO_ORG_ID THEN

Line 6305: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6301: p_run_id => p_migration_run_id,
6302: p_log_level => FND_LOG.LEVEL_ERROR,
6303: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6304: p_table_name => NULL,
6305: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6306: p_token1 => 'ORG',
6307: p_token2 => 'ROWK',
6308: p_token3 => 'ROWV',
6309: p_param1 => l_sample_orgn_code,

Line 6322: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',

6318: GMA_COMMON_LOGGING.gma_migration_central_log (
6319: p_run_id => p_migration_run_id,
6320: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6321: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6322: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6323: p_db_error => SQLERRM,
6324: p_app_short_name => 'GMA');
6325: ROLLBACK;
6326: x_exception_count := x_exception_count + 1;

Line 6336: Log end of gmd_supplier_spec_vrs migration.

6332:
6333:
6334:
6335: /*==============================================
6336: Log end of gmd_supplier_spec_vrs migration.
6337: ==============================================*/
6338:
6339: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6340: