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_STORAGE_PACKAGE

Line 495: p_param1 => 'gmd_ss_storage_package',

491: p_token2 => 'PRO',
492: p_token3 => 'UPD',
493: p_token4 => 'INS',
494: p_token5 => 'ERR',
495: p_param1 => 'gmd_ss_storage_package',
496: p_param2 => to_char(GMD_QC_MIG12.g_store_pack_pro_count),
497: p_param3 => to_char(GMD_QC_MIG12.g_store_pack_upd_count),
498: p_param4 => to_char(GMD_QC_MIG12.g_store_pack_ins_count),
499: p_param5 => to_char(GMD_QC_MIG12.g_store_pack_err_count),

Line 7171: -- gmd_ss_storage_package quantity_uom

7167: -- x_exception_count OUT NUMBER - Exception Count
7168: --
7169: -- The following columns will be migrated by the Common migration script.
7170: --
7171: -- gmd_ss_storage_package 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

Line 7267: CURSOR get_stab_study_org(p_package_id gmd_ss_storage_package.package_id%TYPE) IS

7263: orgs associated with the storage
7264: package.
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;

Line 7277: Cursor for gmd_ss_storage_package.

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: =====================================*/
7279:
7280: CURSOR get_store_pack IS
7281: SELECT *

Line 7282: FROM gmd_ss_storage_package

7278: =====================================*/
7279:
7280: CURSOR get_store_pack IS
7281: SELECT *
7282: FROM gmd_ss_storage_package
7283: WHERE migrated_ind IS NULL
7284: AND organization_id IS NULL;
7285:
7286: l_store_pack gmd_ss_storage_package%ROWTYPE;

Line 7286: l_store_pack gmd_ss_storage_package%ROWTYPE;

7282: FROM gmd_ss_storage_package
7283: WHERE migrated_ind IS NULL
7284: AND organization_id IS NULL;
7285:
7286: l_store_pack gmd_ss_storage_package%ROWTYPE;
7287: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;
7288:
7289: l_package_id NUMBER;
7290:

Line 7287: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;

7283: WHERE migrated_ind IS NULL
7284: AND organization_id IS NULL;
7285:
7286: l_store_pack gmd_ss_storage_package%ROWTYPE;
7287: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;
7288:
7289: l_package_id NUMBER;
7290:
7291: CURSOR get_pack_seq IS

Line 8247: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

8243: GMA_COMMON_LOGGING.gma_migration_central_log (
8244: p_run_id => p_migration_run_id,
8245: p_log_level => FND_LOG.LEVEL_ERROR,
8246: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
8247: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
8248: p_app_short_name => 'GMD');
8249: ROLLBACK;
8250: RETURN;
8251: x_exception_count := x_exception_count + 1;

Line 8258: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

8254: GMA_COMMON_LOGGING.gma_migration_central_log (
8255: p_run_id => p_migration_run_id,
8256: p_log_level => FND_LOG.LEVEL_ERROR,
8257: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
8258: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
8259: p_app_short_name => 'GMD');
8260: x_exception_count := x_exception_count + 1;
8261: ROLLBACK;
8262: RETURN;

Line 8270: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',

8266: GMA_COMMON_LOGGING.gma_migration_central_log (
8267: p_run_id => p_migration_run_id,
8268: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8269: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8270: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
8271: p_db_error => SQLERRM,
8272: p_app_short_name => 'GMA');
8273: x_exception_count := x_exception_count + 1;
8274: ROLLBACK;

Line 8288: p_table_name => 'GMD_SS_STORAGE_PACKAGE',

8284: GMA_COMMON_LOGGING.gma_migration_central_log (
8285: p_run_id => p_migration_run_id,
8286: p_log_level => FND_LOG.LEVEL_EVENT,
8287: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8288: p_table_name => 'GMD_SS_STORAGE_PACKAGE',
8289: p_token1 => 'TABLE_NAME',
8290: p_param1 => 'GMD_SS_STORAGE_PACKAGE',
8291: p_context => 'Quality Stability Studies',
8292: p_app_short_name => 'GMA');

Line 8290: p_param1 => 'GMD_SS_STORAGE_PACKAGE',

8286: p_log_level => FND_LOG.LEVEL_EVENT,
8287: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8288: p_table_name => 'GMD_SS_STORAGE_PACKAGE',
8289: p_token1 => 'TABLE_NAME',
8290: p_param1 => 'GMD_SS_STORAGE_PACKAGE',
8291: p_context => 'Quality Stability Studies',
8292: p_app_short_name => 'GMA');
8293:
8294: GMD_QC_MIG12.g_store_pack_upd_count := 0;

Line 8315: gmd_ss_storage_package record.

8311: the package record. If linked to 1 or more
8312: stability studies update this record with the
8313: orgn from the first stability study. For any
8314: other stability studies create a new
8315: gmd_ss_storage_package record.
8316: =================================================*/
8317: OPEN get_stab_study_org(l_store_pack.package_id);
8318: FETCH get_stab_study_org INTO l_stab_orgn_code, l_gsv_package_id;
8319: IF (get_stab_study_org%NOTFOUND) THEN

Line 8341: Update gmd_ss_storage_package

8337: l_store_pack_invitem_id := NULL;
8338: END IF;
8339:
8340: /*================================
8341: Update gmd_ss_storage_package
8342: ================================*/
8343:
8344: UPDATE gmd_ss_storage_package
8345: SET organization_id = l_def_ss_org_id,

Line 8344: UPDATE gmd_ss_storage_package

8340: /*================================
8341: Update gmd_ss_storage_package
8342: ================================*/
8343:
8344: UPDATE gmd_ss_storage_package
8345: SET organization_id = l_def_ss_org_id,
8346: inventory_item_id = l_store_pack_invitem_id,
8347: migrated_ind = 1
8348: WHERE package_id = l_store_pack.package_id;

Line 8382: Update gmd_ss_storage_package

8378: l_store_pack_invitem_id := NULL;
8379: END IF;
8380:
8381: /*================================
8382: Update gmd_ss_storage_package
8383: using Stability study org.
8384: ================================*/
8385:
8386: UPDATE gmd_ss_storage_package

Line 8386: UPDATE gmd_ss_storage_package

8382: Update gmd_ss_storage_package
8383: using Stability study org.
8384: ================================*/
8385:
8386: UPDATE gmd_ss_storage_package
8387: SET organization_id = l_ss_org_id,
8388: inventory_item_id = l_store_pack_invitem_id,
8389: migrated_ind = 1
8390: WHERE package_id = l_store_pack.package_id;

Line 8436: Insert gmd_ss_storage_package.

8432: l_store_pack_invitem_id := NULL;
8433: END IF;
8434:
8435: /*================================
8436: Insert gmd_ss_storage_package.
8437: ================================*/
8438:
8439: OPEN get_pack_seq;
8440: FETCH get_pack_seq INTO l_package_id;

Line 8443: INSERT INTO gmd_ss_storage_package (

8439: OPEN get_pack_seq;
8440: FETCH get_pack_seq INTO l_package_id;
8441: CLOSE get_pack_seq;
8442:
8443: INSERT INTO gmd_ss_storage_package (
8444: PACKAGE_ID,
8445: FORMULA_ID,
8446: QUANTITY,
8447: UOM,

Line 8532: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

8528: GMA_COMMON_LOGGING.gma_migration_central_log (
8529: p_run_id => p_migration_run_id,
8530: p_log_level => FND_LOG.LEVEL_ERROR,
8531: p_message_token => 'GMD_MIG_ODM_ITEM',
8532: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8533: p_token1 => 'ORG',
8534: p_token2 => 'ITEMID',
8535: p_token3 => 'ROWK',
8536: p_token4 => 'ROWV',

Line 8552: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

8548: GMA_COMMON_LOGGING.gma_migration_central_log (
8549: p_run_id => p_migration_run_id,
8550: p_log_level => FND_LOG.LEVEL_ERROR,
8551: p_message_token => 'GMD_MIG_SS_ORG',
8552: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8553: p_token1 => 'ORG',
8554: p_token2 => 'ROWK',
8555: p_token3 => 'ROWV',
8556: p_param1 => l_stab_orgn_code,

Line 8569: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

8565: GMA_COMMON_LOGGING.gma_migration_central_log (
8566: p_run_id => p_migration_run_id,
8567: p_log_level => FND_LOG.LEVEL_ERROR,
8568: p_message_token => 'GMD_MIG_ODM_ITEM',
8569: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8570: p_token1 => 'ORG',
8571: p_token2 => 'ITEMID',
8572: p_token3 => 'ROWK',
8573: p_token4 => 'ROWV',

Line 8590: p_context => 'Quality Stability Studies - gmd_ss_storage_package',

8586: GMA_COMMON_LOGGING.gma_migration_central_log (
8587: p_run_id => p_migration_run_id,
8588: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8589: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8590: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8591: p_db_error => SQLERRM,
8592: p_app_short_name => 'GMA');
8593: x_exception_count := x_exception_count + 1;
8594: ROLLBACK;

Line 8602: Log End of gmd_ss_storage_package.

8598: END LOOP; -- end get_store_pack
8599:
8600:
8601: /*==============================================
8602: Log End of gmd_ss_storage_package.
8603: ==============================================*/
8604:
8605: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8606: