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 335: p_param1 => 'gmd_supplier_spec_vrs',

331: p_token2 => 'PRO',
332: p_token3 => 'UPD',
333: p_token4 => 'INS',
334: p_token5 => 'ERR',
335: p_param1 => 'gmd_supplier_spec_vrs',
336: p_param2 => to_char(GMD_QC_MIG12.g_supl_spec_pro_count),
337: p_param3 => to_char(GMD_QC_MIG12.g_supl_spec_upd_count),
338: p_param4 => to_char(GMD_QC_MIG12.g_supl_spec_ins_count),
339: p_param5 => to_char(GMD_QC_MIG12.g_supl_spec_err_count),

Line 348: p_param1 => 'gmd_supplier_spec_vrs',

344: p_message_token => 'GMD_MIG_SPEC_TABLE_SUMMARY2',
345: p_context => 'Quality Specifications',
346: p_token1 => 'TAB',
347: p_token2 => 'DEL',
348: p_param1 => 'gmd_supplier_spec_vrs',
349: p_param2 => to_char(GMD_QC_MIG12.g_supl_spec_del_count),
350: p_app_short_name => 'GMD');
351: END IF;
352:

Line 3896: -- gmd_supplier_spec_vrs organization_id

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

Line 4246: FROM gmd_supplier_spec_vrs

4242: =======================================*/
4243:
4244: CURSOR get_supplier_spec IS
4245: SELECT *
4246: FROM gmd_supplier_spec_vrs
4247: WHERE migrated_ind IS NULL
4248: ORDER BY orgn_code;
4249:
4250: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;

Line 4250: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;

4246: FROM gmd_supplier_spec_vrs
4247: WHERE migrated_ind IS NULL
4248: ORDER BY orgn_code;
4249:
4250: l_supl_spec gmd_supplier_spec_vrs%ROWTYPE;
4251:
4252: /*=======================================
4253: Cursor to get orgn_codes for sample
4254: that supplier validity rule is tied to.

Line 4260: gmd_supplier_spec_vrs gssv

4256:
4257: CURSOR get_supl_sample_org (v_spec_id gmd_wip_spec_vrs.spec_vr_id%TYPE) IS
4258: SELECT DISTINCT gse.orgn_code, gse.organization_id
4259: FROM gmd_sampling_events gse, gmd_event_spec_disp gesd,
4260: gmd_supplier_spec_vrs gssv
4261: WHERE gse.sampling_event_id = gesd.sampling_event_id
4262: AND gesd.spec_vr_id = gssv.spec_vr_id
4263: AND gssv.spec_vr_id = v_spec_id;
4264:

Line 4275: FROM gmd_supplier_spec_vrs

4271: -- Commented the following cursor definition and added it with the new where clause.
4272:
4273: /*CURSOR check_supl_spec IS
4274: SELECT spec_vr_id
4275: FROM gmd_supplier_spec_vrs
4276: WHERE orgn_code = l_sample_orgn_code;*/
4277:
4278: CURSOR check_supl_spec IS
4279: SELECT spec_vr_id

Line 4280: FROM gmd_supplier_spec_vrs

4276: WHERE orgn_code = l_sample_orgn_code;*/
4277:
4278: CURSOR check_supl_spec IS
4279: SELECT spec_vr_id
4280: FROM gmd_supplier_spec_vrs
4281: WHERE orgn_code = l_sample_orgn_code
4282: AND spec_id = l_supl_spec.spec_id
4283: AND ( (supplier_id IS NULL AND l_supl_spec.supplier_id IS NULL) OR
4284: (supplier_id = l_supl_spec.supplier_id)

Line 6198: Migrate gmd_supplier_spec_vrs.

6194:
6195:
6196:
6197: /*===================================
6198: Migrate gmd_supplier_spec_vrs.
6199: ===================================*/
6200:
6201: GMA_COMMON_LOGGING.gma_migration_central_log (
6202: p_run_id => p_migration_run_id,

Line 6205: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',

6201: GMA_COMMON_LOGGING.gma_migration_central_log (
6202: p_run_id => p_migration_run_id,
6203: p_log_level => FND_LOG.LEVEL_EVENT,
6204: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6205: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
6206: p_token1 => 'TABLE_NAME',
6207: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',
6208: p_context => 'Quality Specifications',
6209: p_app_short_name => 'GMA');

Line 6207: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',

6203: p_log_level => FND_LOG.LEVEL_EVENT,
6204: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
6205: p_table_name => 'GMD_SUPPLIER_SPEC_VRS',
6206: p_token1 => 'TABLE_NAME',
6207: p_param1 => 'GMD_SUPPLIER_SPEC_VRS',
6208: p_context => 'Quality Specifications',
6209: p_app_short_name => 'GMA');
6210:
6211: GMD_QC_MIG12.g_progress_ind := 5;

Line 6264: Update gmd_supplier_spec_vrs.

6260:
6261:
6262: IF (l_supl_spec.organization_id IS NOT NULL) THEN
6263: /*=====================================
6264: Update gmd_supplier_spec_vrs.
6265: =====================================*/
6266:
6267: -- Bug# 5482253
6268: -- Added org_id in the update statement

Line 6269: UPDATE gmd_supplier_spec_vrs

6265: =====================================*/
6266:
6267: -- Bug# 5482253
6268: -- Added org_id in the update statement
6269: UPDATE gmd_supplier_spec_vrs
6270: SET out_of_spec_lot_status_id = l_out_spec_status_id,
6271: in_spec_lot_status_id = l_in_spec_status_id,
6272: org_id = l_supl_org_id,
6273: migrated_ind = 1

Line 6299: DELETE gmd_supplier_spec_vrs

6295: /*==========================================
6296: This is not marked as an error.
6297: ==========================================*/
6298:
6299: DELETE gmd_supplier_spec_vrs
6300: WHERE spec_vr_id = l_supl_spec.spec_vr_id;
6301:
6302: IF (p_commit = FND_API.G_TRUE) THEN
6303: COMMIT;

Line 6338: UPDATE gmd_supplier_spec_vrs

6334: END IF;
6335:
6336: -- Bug# 5482253
6337: -- Added org_id in the update statement
6338: UPDATE gmd_supplier_spec_vrs
6339: SET out_of_spec_lot_status_id = l_out_spec_status_id,
6340: in_spec_lot_status_id = l_in_spec_status_id,
6341: organization_id = l_sample_organization_id,
6342: orgn_code = l_sample_orgn_code,

Line 6395: INSERT INTO gmd_supplier_spec_vrs

6391: ELSE
6392: l_text_code := NULL;
6393: END IF;
6394:
6395: INSERT INTO gmd_supplier_spec_vrs
6396: (
6397: PO_HEADER_ID,
6398: SPEC_VR_ID,
6399: SPEC_ID,

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

6507: GMA_COMMON_LOGGING.gma_migration_central_log (
6508: p_run_id => p_migration_run_id,
6509: p_log_level => FND_LOG.LEVEL_ERROR,
6510: p_message_token => 'GMD_MIG_NO_ORG',
6511: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6512: p_token1 => 'ORG',
6513: p_token2 => 'ONAME',
6514: p_token3 => 'ROWK',
6515: p_token4 => 'ROWV',

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

6525: GMA_COMMON_LOGGING.gma_migration_central_log (
6526: p_run_id => p_migration_run_id,
6527: p_log_level => FND_LOG.LEVEL_ERROR,
6528: p_message_token => 'GMD_MIG_STATUS_ID',
6529: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6530: p_token1 => 'STAT',
6531: p_token2 => 'ROWK',
6532: p_token3 => 'ROWV',
6533: p_param1 => l_supl_spec.in_spec_lot_status,

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

6541: GMA_COMMON_LOGGING.gma_migration_central_log (
6542: p_run_id => p_migration_run_id,
6543: p_log_level => FND_LOG.LEVEL_ERROR,
6544: p_message_token => 'GMD_MIG_STATUS_ID',
6545: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6546: p_token1 => 'STAT',
6547: p_token2 => 'ROWK',
6548: p_token3 => 'ROWV',
6549: p_param1 => l_supl_spec.out_of_spec_lot_status,

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

6558: p_run_id => p_migration_run_id,
6559: p_log_level => FND_LOG.LEVEL_ERROR,
6560: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6561: p_table_name => NULL,
6562: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6563: p_token1 => 'TAB',
6564: p_param1 => 'gmd_supplier_spec_vrs',
6565: p_app_short_name => 'GMD');
6566:

Line 6564: p_param1 => 'gmd_supplier_spec_vrs',

6560: p_message_token => 'GMD_MIG_COMMON_SPEC_DELETE',
6561: p_table_name => NULL,
6562: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6563: p_token1 => 'TAB',
6564: p_param1 => 'gmd_supplier_spec_vrs',
6565: p_app_short_name => 'GMD');
6566:
6567:
6568: WHEN SUP_NO_ORG_ID THEN

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

6570: p_run_id => p_migration_run_id,
6571: p_log_level => FND_LOG.LEVEL_ERROR,
6572: p_message_token => 'GMD_MIG_NULL_ORG_ID',
6573: p_table_name => NULL,
6574: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6575: p_token1 => 'ORG',
6576: p_token2 => 'ROWK',
6577: p_token3 => 'ROWV',
6578: p_param1 => l_sample_orgn_code,

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

6587: GMA_COMMON_LOGGING.gma_migration_central_log (
6588: p_run_id => p_migration_run_id,
6589: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
6590: p_message_token => 'GMA_MIGRATION_DB_ERROR',
6591: p_context => 'Quality Specifications - gmd_supplier_spec_vrs',
6592: p_db_error => SQLERRM,
6593: p_app_short_name => 'GMA');
6594: ROLLBACK;
6595: x_exception_count := x_exception_count + 1;

Line 6605: Log end of gmd_supplier_spec_vrs migration.

6601:
6602:
6603:
6604: /*==============================================
6605: Log end of gmd_supplier_spec_vrs migration.
6606: ==============================================*/
6607:
6608: LOG_SPEC_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
6609: