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_SS_VARIANTS

Line 476: p_param1 => 'gmd_ss_variants',

472: p_token2 => 'PRO',
473: p_token3 => 'UPD',
474: p_token4 => 'INS',
475: p_token5 => 'ERR',
476: p_param1 => 'gmd_ss_variants',
477: p_param2 => to_char(GMD_QC_MIG12.g_ss_variant_pro_count),
478: p_param3 => to_char(GMD_QC_MIG12.g_ss_variant_upd_count),
479: p_param4 => 0,
480: p_param5 => to_char(GMD_QC_MIG12.g_ss_variant_err_count),

Line 7176: -- gmd_ss_variants sample_quantity_uom

7172: -- gmd_stability_studies_b organization_id
7173: -- gmd_stability_studies_b lab_organization_id
7174: -- gmd_ss_material_sources source_organization_id
7175: -- gmd_ss_material_sources sample_quantity_uom
7176: -- gmd_ss_variants sample_quantity_uom
7177: --=========================================================================== */
7178:
7179: PROCEDURE GMD_QC_MIGRATE_STABS
7180: ( p_migration_run_id IN NUMBER

Line 7269: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv

7265: =====================================*/
7266:
7267: CURSOR get_stab_study_org(p_package_id gmd_ss_storage_package.package_id%TYPE) IS
7268: SELECT distinct gssb.orgn_code, gsv.package_id
7269: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv
7270: WHERE gssb.ss_id = gsv.ss_id
7271: AND gsv.package_id = p_package_id;
7272:
7273: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

Line 7274: l_gsv_package_id gmd_ss_variants.package_id%TYPE;

7270: WHERE gssb.ss_id = gsv.ss_id
7271: AND gsv.package_id = p_package_id;
7272:
7273: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7274: l_gsv_package_id gmd_ss_variants.package_id%TYPE;
7275:
7276: /*=====================================
7277: Cursor for gmd_ss_storage_package.
7278: =====================================*/

Line 7344: Cursor to get gmd_ss_variants.

7340: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
7341: l_failure_count NUMBER;
7342:
7343: /*=========================================
7344: Cursor to get gmd_ss_variants.
7345: If record is created after migration
7346: and migration is rerun we will classify
7347: the record as migrated even though it
7348: is not a truly migrated record.

Line 7354: FROM gmd_ss_variants

7350:
7351: CURSOR get_ss_variant IS
7352: SELECT variant_id, storage_whse_code, storage_location,
7353: storage_organization_id, storage_subinventory, storage_locator_id
7354: FROM gmd_ss_variants
7355: WHERE migrated_ind IS NULL;
7356:
7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;

Line 7357: l_variant_id gmd_ss_variants.variant_id%TYPE;

7353: storage_organization_id, storage_subinventory, storage_locator_id
7354: FROM gmd_ss_variants
7355: WHERE migrated_ind IS NULL;
7356:
7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;

Line 7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;

7354: FROM gmd_ss_variants
7355: WHERE migrated_ind IS NULL;
7356:
7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

Line 7359: l_storage_location gmd_ss_variants.storage_location%TYPE;

7355: WHERE migrated_ind IS NULL;
7356:
7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;

Line 7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;

7356:
7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7364:

Line 7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;

7357: l_variant_id gmd_ss_variants.variant_id%TYPE;
7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7364:
7365: /*=========================================

Line 7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;

7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7364:
7365: /*=========================================
7366: Cursor to get gmd_ss_storage_history.
7367: Select also where organization id is

Line 7991: Log Start of gmd_ss_variants.

7987:
7988: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7989:
7990: /*===================================
7991: Log Start of gmd_ss_variants.
7992: ===================================*/
7993:
7994: GMA_COMMON_LOGGING.gma_migration_central_log (
7995: p_run_id => p_migration_run_id,

Line 7998: p_table_name => 'GMD_SS_VARIANTS',

7994: GMA_COMMON_LOGGING.gma_migration_central_log (
7995: p_run_id => p_migration_run_id,
7996: p_log_level => FND_LOG.LEVEL_EVENT,
7997: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7998: p_table_name => 'GMD_SS_VARIANTS',
7999: p_token1 => 'TABLE_NAME',
8000: p_param1 => 'GMD_SS_VARIANTS',
8001: p_context => 'Quality Stability Studies',
8002: p_app_short_name => 'GMA');

Line 8000: p_param1 => 'GMD_SS_VARIANTS',

7996: p_log_level => FND_LOG.LEVEL_EVENT,
7997: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7998: p_table_name => 'GMD_SS_VARIANTS',
7999: p_token1 => 'TABLE_NAME',
8000: p_param1 => 'GMD_SS_VARIANTS',
8001: p_context => 'Quality Stability Studies',
8002: p_app_short_name => 'GMA');
8003:
8004: GMD_QC_MIG12.g_ss_variant_pro_count := 0;

Line 8010: Migrate gmd_ss_variants.

8006: GMD_QC_MIG12.g_ss_variant_upd_count := 0;
8007: GMD_QC_MIG12.g_progress_ind := 4;
8008:
8009: /*==============================
8010: Migrate gmd_ss_variants.
8011: ==============================*/
8012:
8013: FOR l_var_rec IN get_ss_variant LOOP
8014: BEGIN -- variant subprogram

Line 8098: Update gmd_ss_variants.

8094: l_storage_organization_id := l_var_rec.storage_organization_id;
8095: END IF;
8096:
8097: /*===============================
8098: Update gmd_ss_variants.
8099: *===============================*/
8100:
8101: UPDATE gmd_ss_variants
8102: SET storage_organization_id = l_storage_organization_id,

Line 8101: UPDATE gmd_ss_variants

8097: /*===============================
8098: Update gmd_ss_variants.
8099: *===============================*/
8100:
8101: UPDATE gmd_ss_variants
8102: SET storage_organization_id = l_storage_organization_id,
8103: storage_subinventory = l_storage_subinventory,
8104: storage_locator_id = l_storage_locator_id,
8105: migrated_ind = 1

Line 8122: p_context => 'Quality Stability Studies - gmd_ss_variants',

8118: GMA_COMMON_LOGGING.gma_migration_central_log (
8119: p_run_id => p_migration_run_id,
8120: p_log_level => FND_LOG.LEVEL_ERROR,
8121: p_message_token => 'GMD_MIG_WHSE_ERROR',
8122: p_context => 'Quality Stability Studies - gmd_ss_variants',
8123: p_token1 => 'WHSE',
8124: p_token2 => 'WNAME',
8125: p_token3 => 'ROWK',
8126: p_token4 => 'ROWV',

Line 8140: p_context => 'Quality Stability Studies - gmd_ss_variants',

8136: GMA_COMMON_LOGGING.gma_migration_central_log (
8137: p_run_id => p_migration_run_id,
8138: p_log_level => FND_LOG.LEVEL_ERROR,
8139: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8140: p_context => 'Quality Stability Studies - gmd_ss_variants',
8141: p_token1 => 'ROWK',
8142: p_token2 => 'ROWV',
8143: p_token3 => 'FNAME',
8144: p_param1 => 'VARIANT_ID',

Line 8156: p_context => 'Quality Stability Studies - gmd_ss_variants',

8152: GMA_COMMON_LOGGING.gma_migration_central_log (
8153: p_run_id => p_migration_run_id,
8154: p_log_level => FND_LOG.LEVEL_ERROR,
8155: p_message_token => 'GMD_MIG_LOCATOR_ID',
8156: p_context => 'Quality Stability Studies - gmd_ss_variants',
8157: p_token1 => 'WHSE',
8158: p_token2 => 'LOCATION',
8159: p_token3 => 'LFIELD',
8160: p_token4 => 'ROWK',

Line 8176: p_context => 'Quality Stability Studies - gmd_ss_variants',

8172: GMA_COMMON_LOGGING.gma_migration_central_log (
8173: p_run_id => p_migration_run_id,
8174: p_log_level => FND_LOG.LEVEL_ERROR,
8175: p_message_token => 'GMD_MIG_SUBINV',
8176: p_context => 'Quality Stability Studies - gmd_ss_variants',
8177: p_token1 => 'LOCATOR',
8178: p_token2 => 'ROWK',
8179: p_token3 => 'ROWV',
8180: p_param1 => to_char(l_storage_locator_id),

Line 8194: p_context => 'Quality Stability Studies - gmd_ss_variants',

8190: GMA_COMMON_LOGGING.gma_migration_central_log (
8191: p_run_id => p_migration_run_id,
8192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8193: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8194: p_context => 'Quality Stability Studies - gmd_ss_variants',
8195: p_db_error => SQLERRM,
8196: p_app_short_name => 'GMA');
8197: x_exception_count := x_exception_count + 1;
8198: ROLLBACK;

Line 8207: Log End of gmd_ss_variants.

8203: END LOOP; -- end get_ss_variant
8204:
8205:
8206: /*==============================================
8207: Log End of gmd_ss_variants.
8208: ==============================================*/
8209:
8210: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8211:

Line 8503: Update gmd_ss_variants to point

8499:
8500: GMD_QC_MIG12.g_store_pack_ins_count := GMD_QC_MIG12.g_store_pack_ins_count + 1;
8501:
8502: /*================================
8503: Update gmd_ss_variants to point
8504: to new package record.
8505: ================================*/
8506:
8507: UPDATE gmd_ss_variants

Line 8507: UPDATE gmd_ss_variants

8503: Update gmd_ss_variants to point
8504: to new package record.
8505: ================================*/
8506:
8507: UPDATE gmd_ss_variants
8508: SET package_id = l_package_id
8509: WHERE package_id = l_store_pack.package_id
8510: AND ss_id IN (select ss_id from gmd_stability_studies_b where orgn_code = l_stab_orgn_code);
8511: