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 468: p_param1 => 'gmd_ss_variants',

464: p_token2 => 'PRO',
465: p_token3 => 'UPD',
466: p_token4 => 'INS',
467: p_token5 => 'ERR',
468: p_param1 => 'gmd_ss_variants',
469: p_param2 => to_char(GMD_QC_MIG12.g_ss_variant_pro_count),
470: p_param3 => to_char(GMD_QC_MIG12.g_ss_variant_upd_count),
471: p_param4 => 0,
472: p_param5 => to_char(GMD_QC_MIG12.g_ss_variant_err_count),

Line 6907: -- gmd_ss_variants sample_quantity_uom

6903: -- gmd_stability_studies_b organization_id
6904: -- gmd_stability_studies_b lab_organization_id
6905: -- gmd_ss_material_sources source_organization_id
6906: -- gmd_ss_material_sources sample_quantity_uom
6907: -- gmd_ss_variants sample_quantity_uom
6908: --=========================================================================== */
6909:
6910: PROCEDURE GMD_QC_MIGRATE_STABS
6911: ( p_migration_run_id IN NUMBER

Line 7000: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv

6996: =====================================*/
6997:
6998: CURSOR get_stab_study_org(p_package_id gmd_ss_storage_package.package_id%TYPE) IS
6999: SELECT distinct gssb.orgn_code, gsv.package_id
7000: FROM gmd_stability_studies_b gssb, gmd_ss_variants gsv
7001: WHERE gssb.ss_id = gsv.ss_id
7002: AND gsv.package_id = p_package_id;
7003:
7004: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;

Line 7005: l_gsv_package_id gmd_ss_variants.package_id%TYPE;

7001: WHERE gssb.ss_id = gsv.ss_id
7002: AND gsv.package_id = p_package_id;
7003:
7004: l_stab_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7005: l_gsv_package_id gmd_ss_variants.package_id%TYPE;
7006:
7007: /*=====================================
7008: Cursor for gmd_ss_storage_package.
7009: =====================================*/

Line 7075: Cursor to get gmd_ss_variants.

7071: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE;
7072: l_failure_count NUMBER;
7073:
7074: /*=========================================
7075: Cursor to get gmd_ss_variants.
7076: If record is created after migration
7077: and migration is rerun we will classify
7078: the record as migrated even though it
7079: is not a truly migrated record.

Line 7085: FROM gmd_ss_variants

7081:
7082: CURSOR get_ss_variant IS
7083: SELECT variant_id, storage_whse_code, storage_location,
7084: storage_organization_id, storage_subinventory, storage_locator_id
7085: FROM gmd_ss_variants
7086: WHERE migrated_ind IS NULL;
7087:
7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;

Line 7088: l_variant_id gmd_ss_variants.variant_id%TYPE;

7084: storage_organization_id, storage_subinventory, storage_locator_id
7085: FROM gmd_ss_variants
7086: WHERE migrated_ind IS NULL;
7087:
7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;

Line 7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;

7085: FROM gmd_ss_variants
7086: WHERE migrated_ind IS NULL;
7087:
7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

Line 7090: l_storage_location gmd_ss_variants.storage_location%TYPE;

7086: WHERE migrated_ind IS NULL;
7087:
7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;

Line 7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;

7087:
7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7095:

Line 7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;

7088: l_variant_id gmd_ss_variants.variant_id%TYPE;
7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7095:
7096: /*=========================================

Line 7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;

7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7095:
7096: /*=========================================
7097: Cursor to get gmd_ss_storage_history.
7098: Select also where organization id is

Line 7722: Log Start of gmd_ss_variants.

7718:
7719: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7720:
7721: /*===================================
7722: Log Start of gmd_ss_variants.
7723: ===================================*/
7724:
7725: GMA_COMMON_LOGGING.gma_migration_central_log (
7726: p_run_id => p_migration_run_id,

Line 7729: p_table_name => 'GMD_SS_VARIANTS',

7725: GMA_COMMON_LOGGING.gma_migration_central_log (
7726: p_run_id => p_migration_run_id,
7727: p_log_level => FND_LOG.LEVEL_EVENT,
7728: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7729: p_table_name => 'GMD_SS_VARIANTS',
7730: p_token1 => 'TABLE_NAME',
7731: p_param1 => 'GMD_SS_VARIANTS',
7732: p_context => 'Quality Stability Studies',
7733: p_app_short_name => 'GMA');

Line 7731: p_param1 => 'GMD_SS_VARIANTS',

7727: p_log_level => FND_LOG.LEVEL_EVENT,
7728: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7729: p_table_name => 'GMD_SS_VARIANTS',
7730: p_token1 => 'TABLE_NAME',
7731: p_param1 => 'GMD_SS_VARIANTS',
7732: p_context => 'Quality Stability Studies',
7733: p_app_short_name => 'GMA');
7734:
7735: GMD_QC_MIG12.g_ss_variant_pro_count := 0;

Line 7741: Migrate gmd_ss_variants.

7737: GMD_QC_MIG12.g_ss_variant_upd_count := 0;
7738: GMD_QC_MIG12.g_progress_ind := 4;
7739:
7740: /*==============================
7741: Migrate gmd_ss_variants.
7742: ==============================*/
7743:
7744: FOR l_var_rec IN get_ss_variant LOOP
7745: BEGIN -- variant subprogram

Line 7829: Update gmd_ss_variants.

7825: l_storage_organization_id := l_var_rec.storage_organization_id;
7826: END IF;
7827:
7828: /*===============================
7829: Update gmd_ss_variants.
7830: *===============================*/
7831:
7832: UPDATE gmd_ss_variants
7833: SET storage_organization_id = l_storage_organization_id,

Line 7832: UPDATE gmd_ss_variants

7828: /*===============================
7829: Update gmd_ss_variants.
7830: *===============================*/
7831:
7832: UPDATE gmd_ss_variants
7833: SET storage_organization_id = l_storage_organization_id,
7834: storage_subinventory = l_storage_subinventory,
7835: storage_locator_id = l_storage_locator_id,
7836: migrated_ind = 1

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

7849: GMA_COMMON_LOGGING.gma_migration_central_log (
7850: p_run_id => p_migration_run_id,
7851: p_log_level => FND_LOG.LEVEL_ERROR,
7852: p_message_token => 'GMD_MIG_WHSE_ERROR',
7853: p_context => 'Quality Stability Studies - gmd_ss_variants',
7854: p_token1 => 'WHSE',
7855: p_token2 => 'WNAME',
7856: p_token3 => 'ROWK',
7857: p_token4 => 'ROWV',

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

7867: GMA_COMMON_LOGGING.gma_migration_central_log (
7868: p_run_id => p_migration_run_id,
7869: p_log_level => FND_LOG.LEVEL_ERROR,
7870: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7871: p_context => 'Quality Stability Studies - gmd_ss_variants',
7872: p_token1 => 'ROWK',
7873: p_token2 => 'ROWV',
7874: p_token3 => 'FNAME',
7875: p_param1 => 'VARIANT_ID',

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

7883: GMA_COMMON_LOGGING.gma_migration_central_log (
7884: p_run_id => p_migration_run_id,
7885: p_log_level => FND_LOG.LEVEL_ERROR,
7886: p_message_token => 'GMD_MIG_LOCATOR_ID',
7887: p_context => 'Quality Stability Studies - gmd_ss_variants',
7888: p_token1 => 'WHSE',
7889: p_token2 => 'LOCATION',
7890: p_token3 => 'LFIELD',
7891: p_token4 => 'ROWK',

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

7903: GMA_COMMON_LOGGING.gma_migration_central_log (
7904: p_run_id => p_migration_run_id,
7905: p_log_level => FND_LOG.LEVEL_ERROR,
7906: p_message_token => 'GMD_MIG_SUBINV',
7907: p_context => 'Quality Stability Studies - gmd_ss_variants',
7908: p_token1 => 'LOCATOR',
7909: p_token2 => 'ROWK',
7910: p_token3 => 'ROWV',
7911: p_param1 => to_char(l_storage_locator_id),

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

7921: GMA_COMMON_LOGGING.gma_migration_central_log (
7922: p_run_id => p_migration_run_id,
7923: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7924: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7925: p_context => 'Quality Stability Studies - gmd_ss_variants',
7926: p_db_error => SQLERRM,
7927: p_app_short_name => 'GMA');
7928: x_exception_count := x_exception_count + 1;
7929: ROLLBACK;

Line 7938: Log End of gmd_ss_variants.

7934: END LOOP; -- end get_ss_variant
7935:
7936:
7937: /*==============================================
7938: Log End of gmd_ss_variants.
7939: ==============================================*/
7940:
7941: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7942:

Line 8234: Update gmd_ss_variants to point

8230:
8231: GMD_QC_MIG12.g_store_pack_ins_count := GMD_QC_MIG12.g_store_pack_ins_count + 1;
8232:
8233: /*================================
8234: Update gmd_ss_variants to point
8235: to new package record.
8236: ================================*/
8237:
8238: UPDATE gmd_ss_variants

Line 8238: UPDATE gmd_ss_variants

8234: Update gmd_ss_variants to point
8235: to new package record.
8236: ================================*/
8237:
8238: UPDATE gmd_ss_variants
8239: SET package_id = l_package_id
8240: WHERE package_id = l_store_pack.package_id
8241: AND ss_id IN (select ss_id from gmd_stability_studies_b where orgn_code = l_stab_orgn_code);
8242: