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_RESULTS

Line 185: p_param1 => 'gmd_results',

181: p_token2 => 'PRO',
182: p_token3 => 'UPD',
183: p_token4 => 'INS',
184: p_token5 => 'ERR',
185: p_param1 => 'gmd_results',
186: p_param2 => to_char(GMD_QC_MIG12.g_result_pro_count),
187: p_param3 => to_char(GMD_QC_MIG12.g_result_upd_count),
188: p_param4 => 0,
189: p_param5 => to_char(GMD_QC_MIG12.g_result_err_count),

Line 3631: -- gmd_results lab_organization_id

3627: -- p_end_rowid IN ROWID
3628: -- x_exception_count OUT NUMBER - Exception Count
3629: --
3630: -- The following columns will be migrated by the Common migration script.
3631: -- gmd_results lab_organization_id
3632: -- gmd_results test_qty_uom
3633: --===========================================================================
3634: in cases , these were being used to populate samples
3635: */

Line 3632: -- gmd_results test_qty_uom

3628: -- x_exception_count OUT NUMBER - Exception Count
3629: --
3630: -- The following columns will be migrated by the Common migration script.
3631: -- gmd_results lab_organization_id
3632: -- gmd_results test_qty_uom
3633: --===========================================================================
3634: in cases , these were being used to populate samples
3635: */
3636: PROCEDURE GMD_QC_MIGRATE_RESULTS

Line 3658: FROM gmd_results

3654: CURSOR get_results IS
3655: SELECT result_id, qc_lab_orgn_code, lab_organization_id,
3656: test_kit_item_id, test_kit_lot_no, test_kit_sublot_no,
3657: test_kit_inv_item_id
3658: FROM gmd_results
3659: WHERE rowid BETWEEN p_start_rowid AND p_end_rowid -- Bug 14198664 support ad_parallel
3660: AND migrated_ind IS NULL
3661: AND test_kit_item_id is not null;
3662:

Line 3667: Log Start of gmd_results.

3663: BEGIN
3664:
3665:
3666: /*=====================================
3667: Log Start of gmd_results.
3668: =====================================*/
3669:
3670: GMA_COMMON_LOGGING.gma_migration_central_log (
3671: p_run_id => p_migration_run_id,

Line 3674: p_table_name => 'GMD_RESULTS',

3670: GMA_COMMON_LOGGING.gma_migration_central_log (
3671: p_run_id => p_migration_run_id,
3672: p_log_level => FND_LOG.LEVEL_EVENT,
3673: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3674: p_table_name => 'GMD_RESULTS',
3675: p_token1 => 'TABLE_NAME',
3676: p_param1 => 'GMD_RESULTS',
3677: p_context => 'Quality Results',
3678: p_app_short_name => 'GMA');

Line 3676: p_param1 => 'GMD_RESULTS',

3672: p_log_level => FND_LOG.LEVEL_EVENT,
3673: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3674: p_table_name => 'GMD_RESULTS',
3675: p_token1 => 'TABLE_NAME',
3676: p_param1 => 'GMD_RESULTS',
3677: p_context => 'Quality Results',
3678: p_app_short_name => 'GMA');
3679:
3680: GMD_QC_MIG12.g_result_upd_count := 0;

Line 3685: UPDATE gmd_results

3681: GMD_QC_MIG12.g_result_pro_count := 0;
3682: GMD_QC_MIG12.g_result_err_count := 0;
3683: GMD_QC_MIG12.g_progress_ind := 3;
3684:
3685: UPDATE gmd_results
3686: SET migrated_ind = 1
3687: WHERE test_kit_item_id is null
3688: AND test_kit_inv_item_id is null
3689: AND rowid BETWEEN p_start_rowid AND p_end_rowid -- Bug 14198664 support ad_parallel

Line 3768: Update gmd_results.

3764: END IF;
3765:
3766:
3767: /*==========================
3768: Update gmd_results.
3769: ==========================*/
3770:
3771: UPDATE gmd_results
3772: SET test_kit_lot_number = l_lot_number,

Line 3771: UPDATE gmd_results

3767: /*==========================
3768: Update gmd_results.
3769: ==========================*/
3770:
3771: UPDATE gmd_results
3772: SET test_kit_lot_number = l_lot_number,
3773: test_kit_inv_item_id = l_inventory_item_id,
3774: migrated_ind = 1
3775: WHERE result_id = v_result.result_id;

Line 3790: p_context => 'Quality Results - gmd_results',

3786: GMA_COMMON_LOGGING.gma_migration_central_log (
3787: p_run_id => p_migration_run_id,
3788: p_log_level => FND_LOG.LEVEL_ERROR,
3789: p_message_token => 'GMD_MIG_NO_ORG',
3790: p_context => 'Quality Results - gmd_results',
3791: p_token1 => 'ORG',
3792: p_token2 => 'ONAME',
3793: p_token3 => 'ROWK',
3794: p_token4 => 'ROWV',

Line 3811: p_context => 'Quality Results - gmd_results',

3807: GMA_COMMON_LOGGING.gma_migration_central_log (
3808: p_run_id => p_migration_run_id,
3809: p_log_level => FND_LOG.LEVEL_ERROR,
3810: p_message_token => 'GMD_MIG_ODM_ITEM',
3811: p_context => 'Quality Results - gmd_results',
3812: p_token1 => 'ORG',
3813: p_token2 => 'ITEMID',
3814: p_token3 => 'ROWK',
3815: p_token4 => 'ROWV',

Line 3829: p_context => 'Quality Results - gmd_results',

3825: GMA_COMMON_LOGGING.gma_migration_central_log (
3826: p_run_id => p_migration_run_id,
3827: p_log_level => FND_LOG.LEVEL_ERROR,
3828: p_message_token => 'GMD_MIG_LOT',
3829: p_context => 'Quality Results - gmd_results',
3830: p_token1 => 'ROWK',
3831: p_token2 => 'ROWV',
3832: p_param1 => 'RESULT_ID',
3833: p_param2 => to_char(v_result.result_id),

Line 3844: p_context => 'Quality Results - gmd_results',

3840: GMA_COMMON_LOGGING.gma_migration_central_log (
3841: p_run_id => p_migration_run_id,
3842: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3843: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3844: p_context => 'Quality Results - gmd_results',
3845: p_db_error => SQLERRM,
3846: p_app_short_name => 'GMA');
3847: x_exception_count := x_exception_count + 1;
3848:

Line 3854: Log number of updates to gmd_results.

3850:
3851: END LOOP;
3852:
3853: /*==============================================
3854: Log number of updates to gmd_results.
3855: ==============================================*/
3856:
3857: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3858: