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.

[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on GMD_SS_STORAGE_PACKAGE

Line 487: p_param1 => 'gmd_ss_storage_package',

483: p_token2 => 'PRO',
484: p_token3 => 'UPD',
485: p_token4 => 'INS',
486: p_token5 => 'ERR',
487: p_param1 => 'gmd_ss_storage_package',
488: p_param2 => to_char(GMD_QC_MIG12.g_store_pack_pro_count),
489: p_param3 => to_char(GMD_QC_MIG12.g_store_pack_upd_count),
490: p_param4 => to_char(GMD_QC_MIG12.g_store_pack_ins_count),
491: p_param5 => to_char(GMD_QC_MIG12.g_store_pack_err_count),

Line 6902: -- gmd_ss_storage_package quantity_uom

6898: -- x_exception_count OUT NUMBER - Exception Count
6899: --
6900: -- The following columns will be migrated by the Common migration script.
6901: --
6902: -- gmd_ss_storage_package 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

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

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

Line 7008: Cursor for gmd_ss_storage_package.

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: =====================================*/
7010:
7011: CURSOR get_store_pack IS
7012: SELECT *

Line 7013: FROM gmd_ss_storage_package

7009: =====================================*/
7010:
7011: CURSOR get_store_pack IS
7012: SELECT *
7013: FROM gmd_ss_storage_package
7014: WHERE migrated_ind IS NULL
7015: AND organization_id IS NULL;
7016:
7017: l_store_pack gmd_ss_storage_package%ROWTYPE;

Line 7017: l_store_pack gmd_ss_storage_package%ROWTYPE;

7013: FROM gmd_ss_storage_package
7014: WHERE migrated_ind IS NULL
7015: AND organization_id IS NULL;
7016:
7017: l_store_pack gmd_ss_storage_package%ROWTYPE;
7018: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;
7019:
7020: l_package_id NUMBER;
7021:

Line 7018: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;

7014: WHERE migrated_ind IS NULL
7015: AND organization_id IS NULL;
7016:
7017: l_store_pack gmd_ss_storage_package%ROWTYPE;
7018: l_store_pack_invitem_id gmd_ss_storage_package.inventory_item_id%TYPE;
7019:
7020: l_package_id NUMBER;
7021:
7022: CURSOR get_pack_seq IS

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

7974: GMA_COMMON_LOGGING.gma_migration_central_log (
7975: p_run_id => p_migration_run_id,
7976: p_log_level => FND_LOG.LEVEL_ERROR,
7977: p_message_token => 'GMD_MIG_DEFAULT_LAB_NULL',
7978: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
7979: p_app_short_name => 'GMD');
7980: ROLLBACK;
7981: RETURN;
7982: x_exception_count := x_exception_count + 1;

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

7985: GMA_COMMON_LOGGING.gma_migration_central_log (
7986: p_run_id => p_migration_run_id,
7987: p_log_level => FND_LOG.LEVEL_ERROR,
7988: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7989: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
7990: p_app_short_name => 'GMD');
7991: x_exception_count := x_exception_count + 1;
7992: ROLLBACK;
7993: RETURN;

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

7997: GMA_COMMON_LOGGING.gma_migration_central_log (
7998: p_run_id => p_migration_run_id,
7999: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8000: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8001: p_context => 'Quality Stability Studies - pre gmd_ss_storage_package',
8002: p_db_error => SQLERRM,
8003: p_app_short_name => 'GMA');
8004: x_exception_count := x_exception_count + 1;
8005: ROLLBACK;

Line 8019: p_table_name => 'GMD_SS_STORAGE_PACKAGE',

8015: GMA_COMMON_LOGGING.gma_migration_central_log (
8016: p_run_id => p_migration_run_id,
8017: p_log_level => FND_LOG.LEVEL_EVENT,
8018: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8019: p_table_name => 'GMD_SS_STORAGE_PACKAGE',
8020: p_token1 => 'TABLE_NAME',
8021: p_param1 => 'GMD_SS_STORAGE_PACKAGE',
8022: p_context => 'Quality Stability Studies',
8023: p_app_short_name => 'GMA');

Line 8021: p_param1 => 'GMD_SS_STORAGE_PACKAGE',

8017: p_log_level => FND_LOG.LEVEL_EVENT,
8018: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8019: p_table_name => 'GMD_SS_STORAGE_PACKAGE',
8020: p_token1 => 'TABLE_NAME',
8021: p_param1 => 'GMD_SS_STORAGE_PACKAGE',
8022: p_context => 'Quality Stability Studies',
8023: p_app_short_name => 'GMA');
8024:
8025: GMD_QC_MIG12.g_store_pack_upd_count := 0;

Line 8046: gmd_ss_storage_package record.

8042: the package record. If linked to 1 or more
8043: stability studies update this record with the
8044: orgn from the first stability study. For any
8045: other stability studies create a new
8046: gmd_ss_storage_package record.
8047: =================================================*/
8048: OPEN get_stab_study_org(l_store_pack.package_id);
8049: FETCH get_stab_study_org INTO l_stab_orgn_code, l_gsv_package_id;
8050: IF (get_stab_study_org%NOTFOUND) THEN

Line 8072: Update gmd_ss_storage_package

8068: l_store_pack_invitem_id := NULL;
8069: END IF;
8070:
8071: /*================================
8072: Update gmd_ss_storage_package
8073: ================================*/
8074:
8075: UPDATE gmd_ss_storage_package
8076: SET organization_id = l_def_ss_org_id,

Line 8075: UPDATE gmd_ss_storage_package

8071: /*================================
8072: Update gmd_ss_storage_package
8073: ================================*/
8074:
8075: UPDATE gmd_ss_storage_package
8076: SET organization_id = l_def_ss_org_id,
8077: inventory_item_id = l_store_pack_invitem_id,
8078: migrated_ind = 1
8079: WHERE package_id = l_store_pack.package_id;

Line 8113: Update gmd_ss_storage_package

8109: l_store_pack_invitem_id := NULL;
8110: END IF;
8111:
8112: /*================================
8113: Update gmd_ss_storage_package
8114: using Stability study org.
8115: ================================*/
8116:
8117: UPDATE gmd_ss_storage_package

Line 8117: UPDATE gmd_ss_storage_package

8113: Update gmd_ss_storage_package
8114: using Stability study org.
8115: ================================*/
8116:
8117: UPDATE gmd_ss_storage_package
8118: SET organization_id = l_ss_org_id,
8119: inventory_item_id = l_store_pack_invitem_id,
8120: migrated_ind = 1
8121: WHERE package_id = l_store_pack.package_id;

Line 8167: Insert gmd_ss_storage_package.

8163: l_store_pack_invitem_id := NULL;
8164: END IF;
8165:
8166: /*================================
8167: Insert gmd_ss_storage_package.
8168: ================================*/
8169:
8170: OPEN get_pack_seq;
8171: FETCH get_pack_seq INTO l_package_id;

Line 8174: INSERT INTO gmd_ss_storage_package (

8170: OPEN get_pack_seq;
8171: FETCH get_pack_seq INTO l_package_id;
8172: CLOSE get_pack_seq;
8173:
8174: INSERT INTO gmd_ss_storage_package (
8175: PACKAGE_ID,
8176: FORMULA_ID,
8177: QUANTITY,
8178: UOM,

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

8259: GMA_COMMON_LOGGING.gma_migration_central_log (
8260: p_run_id => p_migration_run_id,
8261: p_log_level => FND_LOG.LEVEL_ERROR,
8262: p_message_token => 'GMD_MIG_ODM_ITEM',
8263: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8264: p_token1 => 'ORG',
8265: p_token2 => 'ITEMID',
8266: p_token3 => 'ROWK',
8267: p_token4 => 'ROWV',

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

8279: GMA_COMMON_LOGGING.gma_migration_central_log (
8280: p_run_id => p_migration_run_id,
8281: p_log_level => FND_LOG.LEVEL_ERROR,
8282: p_message_token => 'GMD_MIG_SS_ORG',
8283: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8284: p_token1 => 'ORG',
8285: p_token2 => 'ROWK',
8286: p_token3 => 'ROWV',
8287: p_param1 => l_stab_orgn_code,

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

8296: GMA_COMMON_LOGGING.gma_migration_central_log (
8297: p_run_id => p_migration_run_id,
8298: p_log_level => FND_LOG.LEVEL_ERROR,
8299: p_message_token => 'GMD_MIG_ODM_ITEM',
8300: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8301: p_token1 => 'ORG',
8302: p_token2 => 'ITEMID',
8303: p_token3 => 'ROWK',
8304: p_token4 => 'ROWV',

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

8317: GMA_COMMON_LOGGING.gma_migration_central_log (
8318: p_run_id => p_migration_run_id,
8319: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8320: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8321: p_context => 'Quality Stability Studies - gmd_ss_storage_package',
8322: p_db_error => SQLERRM,
8323: p_app_short_name => 'GMA');
8324: x_exception_count := x_exception_count + 1;
8325: ROLLBACK;

Line 8333: Log End of gmd_ss_storage_package.

8329: END LOOP; -- end get_store_pack
8330:
8331:
8332: /*==============================================
8333: Log End of gmd_ss_storage_package.
8334: ==============================================*/
8335:
8336: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8337: