APPS.GMD_QC_MIG12 dependencies on GMD_RESULTS

Line 177: p_param1 => 'gmd_results',

173: p_token2 => 'PRO',
174: p_token3 => 'UPD',
175: p_token4 => 'INS',
176: p_token5 => 'ERR',
177: p_param1 => 'gmd_results',
178: p_param2 => to_char(GMD_QC_MIG12.g_result_pro_count),
179: p_param3 => to_char(GMD_QC_MIG12.g_result_upd_count),
180: p_param4 => 0,
181: p_param5 => to_char(GMD_QC_MIG12.g_result_err_count),

Line 2412: -- gmd_results lab_organization_id

2408: --
2409: -- gmd_samples organization_id
2410: -- gmd_samples lab_organization_id
2411: -- gmd_samples sample_qty_uom
2412: -- gmd_results lab_organization_id
2413: -- gmd_results test_qty_uom
2414: --=========================================================================== */
2415:
2416: PROCEDURE GMD_QC_MIGRATE_SAMPLES

Line 2413: -- gmd_results test_qty_uom

2409: -- gmd_samples organization_id
2410: -- gmd_samples lab_organization_id
2411: -- gmd_samples sample_qty_uom
2412: -- gmd_results lab_organization_id
2413: -- gmd_results test_qty_uom
2414: --=========================================================================== */
2415:
2416: PROCEDURE GMD_QC_MIGRATE_SAMPLES
2417: ( p_migration_run_id IN NUMBER

Line 2534: FROM gmd_results

2530: CURSOR get_results IS
2531: SELECT result_id, qc_lab_orgn_code, lab_organization_id,
2532: test_kit_item_id, test_kit_lot_no, test_kit_sublot_no,
2533: test_kit_inv_item_id
2534: FROM gmd_results
2535: WHERE migrated_ind IS NULL;
2536:
2537:
2538: BEGIN

Line 3403: Log Start of gmd_results.

3399: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3400:
3401:
3402: /*=====================================
3403: Log Start of gmd_results.
3404: =====================================*/
3405:
3406: GMA_COMMON_LOGGING.gma_migration_central_log (
3407: p_run_id => p_migration_run_id,

Line 3410: p_table_name => 'GMD_RESULTS',

3406: GMA_COMMON_LOGGING.gma_migration_central_log (
3407: p_run_id => p_migration_run_id,
3408: p_log_level => FND_LOG.LEVEL_EVENT,
3409: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3410: p_table_name => 'GMD_RESULTS',
3411: p_token1 => 'TABLE_NAME',
3412: p_param1 => 'GMD_RESULTS',
3413: p_context => 'Quality Samples',
3414: p_app_short_name => 'GMA');

Line 3412: p_param1 => 'GMD_RESULTS',

3408: p_log_level => FND_LOG.LEVEL_EVENT,
3409: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
3410: p_table_name => 'GMD_RESULTS',
3411: p_token1 => 'TABLE_NAME',
3412: p_param1 => 'GMD_RESULTS',
3413: p_context => 'Quality Samples',
3414: p_app_short_name => 'GMA');
3415:
3416: GMD_QC_MIG12.g_result_upd_count := 0;

Line 3497: Update gmd_results.

3493: END IF;
3494:
3495:
3496: /*==========================
3497: Update gmd_results.
3498: ==========================*/
3499:
3500: UPDATE gmd_results
3501: SET test_kit_lot_number = l_lot_number,

Line 3500: UPDATE gmd_results

3496: /*==========================
3497: Update gmd_results.
3498: ==========================*/
3499:
3500: UPDATE gmd_results
3501: SET test_kit_lot_number = l_lot_number,
3502: test_kit_inv_item_id = l_inventory_item_id,
3503: migrated_ind = 1
3504: WHERE result_id = v_result.result_id;

Line 3519: p_context => 'Quality Samples - gmd_results',

3515: GMA_COMMON_LOGGING.gma_migration_central_log (
3516: p_run_id => p_migration_run_id,
3517: p_log_level => FND_LOG.LEVEL_ERROR,
3518: p_message_token => 'GMD_MIG_NO_ORG',
3519: p_context => 'Quality Samples - gmd_results',
3520: p_token1 => 'ORG',
3521: p_token2 => 'ONAME',
3522: p_token3 => 'ROWK',
3523: p_token4 => 'ROWV',

Line 3540: p_context => 'Quality Samples - gmd_results',

3536: GMA_COMMON_LOGGING.gma_migration_central_log (
3537: p_run_id => p_migration_run_id,
3538: p_log_level => FND_LOG.LEVEL_ERROR,
3539: p_message_token => 'GMD_MIG_ODM_ITEM',
3540: p_context => 'Quality Samples - gmd_results',
3541: p_token1 => 'ORG',
3542: p_token2 => 'ITEMID',
3543: p_token3 => 'ROWK',
3544: p_token4 => 'ROWV',

Line 3558: p_context => 'Quality Samples - gmd_results',

3554: GMA_COMMON_LOGGING.gma_migration_central_log (
3555: p_run_id => p_migration_run_id,
3556: p_log_level => FND_LOG.LEVEL_ERROR,
3557: p_message_token => 'GMD_MIG_LOT',
3558: p_context => 'Quality Samples - gmd_results',
3559: p_token1 => 'ROWK',
3560: p_token2 => 'ROWV',
3561: p_param1 => 'RESULT_ID',
3562: p_param2 => to_char(v_result.result_id),

Line 3573: p_context => 'Quality Samples - gmd_results',

3569: GMA_COMMON_LOGGING.gma_migration_central_log (
3570: p_run_id => p_migration_run_id,
3571: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3572: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3573: p_context => 'Quality Samples - gmd_results',
3574: p_db_error => SQLERRM,
3575: p_app_short_name => 'GMA');
3576: x_exception_count := x_exception_count + 1;
3577:

Line 3583: Log number of updates to gmd_results.

3579:
3580: END LOOP;
3581:
3582: /*==============================================
3583: Log number of updates to gmd_results.
3584: ==============================================*/
3585:
3586: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3587: