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_SAMPLES

Line 147: p_param1 => 'gmd_samples',

143: p_token2 => 'PRO',
144: p_token3 => 'UPD',
145: p_token4 => 'INS',
146: p_token5 => 'ERR',
147: p_param1 => 'gmd_samples',
148: p_param2 => to_char(GMD_QC_MIG12.g_sample_pro_count),
149: p_param3 => to_char(GMD_QC_MIG12.g_sample_upd_count),
150: p_param4 => 0,
151: p_param5 => to_char(GMD_QC_MIG12.g_sample_err_count),

Line 2418: -- gmd_samples organization_id

2414: -- x_exception_count OUT NUMBER - Exception Count
2415: --
2416: -- The following columns will be migrated by the Common migration script.
2417: --
2418: -- gmd_samples organization_id
2419: -- gmd_samples lab_organization_id
2420: -- gmd_samples sample_qty_uom
2421: --===========================================================================
2422: -- plowe 02/08/2012 Bug 13025068/13685161

Line 2419: -- gmd_samples lab_organization_id

2415: --
2416: -- The following columns will be migrated by the Common migration script.
2417: --
2418: -- gmd_samples organization_id
2419: -- gmd_samples lab_organization_id
2420: -- gmd_samples sample_qty_uom
2421: --===========================================================================
2422: -- plowe 02/08/2012 Bug 13025068/13685161
2423: -- make sure that if the sample is for a lot of sublot item where no

Line 2420: -- gmd_samples sample_qty_uom

2416: -- The following columns will be migrated by the Common migration script.
2417: --
2418: -- gmd_samples organization_id
2419: -- gmd_samples lab_organization_id
2420: -- gmd_samples sample_qty_uom
2421: --===========================================================================
2422: -- plowe 02/08/2012 Bug 13025068/13685161
2423: -- make sure that if the sample is for a lot of sublot item where no
2424: -- sublots exist then make sure this code migrates the lot as per inventory migration.

Line 2467: Cursor for gmd_samples.

2463: MIG_SOURCE_SUBINV_ERROR EXCEPTION;
2464:
2465:
2466: /*==============================
2467: Cursor for gmd_samples.
2468: Added organization id to exclude
2469: records added post-migration in
2470: case migration is erroneously
2471: rerun again.

Line 2478: FROM gmd_samples

2474: -- Bug# 5108963
2475: -- Removed organization_id IS NULL from the where clause and added orgn_code IS NOT NULL.
2476: CURSOR get_samples IS
2477: SELECT *
2478: FROM gmd_samples
2479: WHERE rowid BETWEEN p_start_rowid AND p_end_rowid AND -- Bug 14198664 support ad_parallel
2480: migrated_ind IS NULL AND
2481: orgn_code IS NOT NULL;
2482:

Line 2488: l_organization_id gmd_samples.organization_id%TYPE;

2484: /*==============================
2485: Placeholders.
2486: ==============================*/
2487:
2488: l_organization_id gmd_samples.organization_id%TYPE;
2489: l_lab_organization_id gmd_samples.organization_id%TYPE;
2490: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2491: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2492: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 2489: l_lab_organization_id gmd_samples.organization_id%TYPE;

2485: Placeholders.
2486: ==============================*/
2487:
2488: l_organization_id gmd_samples.organization_id%TYPE;
2489: l_lab_organization_id gmd_samples.organization_id%TYPE;
2490: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2491: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2492: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
2493: l_subinv mtl_item_locations.subinventory_code%TYPE;

Line 2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;

2494: lsub_organization_id mtl_item_locations.organization_id%TYPE;
2495: ls_organization_id mtl_item_locations.organization_id%TYPE;
2496: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

Line 2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;

2495: ls_organization_id mtl_item_locations.organization_id%TYPE;
2496: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

Line 2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;

2496: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2504: l_lot_number gmd_samples.lot_number%TYPE;

Line 2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;

2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2504: l_lot_number gmd_samples.lot_number%TYPE;
2505: l_get_parent_only NUMBER := 0;

Line 2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2504: l_lot_number gmd_samples.lot_number%TYPE;
2505: l_get_parent_only NUMBER := 0;
2506: l_failure_count NUMBER;
2507:

Line 2504: l_lot_number gmd_samples.lot_number%TYPE;

2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2504: l_lot_number gmd_samples.lot_number%TYPE;
2505: l_get_parent_only NUMBER := 0;
2506: l_failure_count NUMBER;
2507:
2508: -- Bug# 5261810

Line 2511: l_source_org_id gmd_samples.organization_id%TYPE;

2507:
2508: -- Bug# 5261810
2509: l_org_id NUMBER;
2510: l_material_detail_id NUMBER;
2511: l_source_org_id gmd_samples.organization_id%TYPE;
2512: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2513: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2514: l_source_subinv gmd_samples.source_subinventory%TYPE;
2515: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 2514: l_source_subinv gmd_samples.source_subinventory%TYPE;

2510: l_material_detail_id NUMBER;
2511: l_source_org_id gmd_samples.organization_id%TYPE;
2512: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2513: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2514: l_source_subinv gmd_samples.source_subinventory%TYPE;
2515: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;
2516: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2517: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2518:

Line 2530: FROM gmd_sampling_events gse , gmd_samples gs

2526:
2527: -- cursor modified while fixing bug 14198664
2528: CURSOR get_sampling_event IS
2529: SELECT gse.sampling_event_id
2530: FROM gmd_sampling_events gse , gmd_samples gs
2531: WHERE gse.migrated_ind IS NULL
2532: AND gs.sampling_event_id = gse.sampling_event_id
2533: and gs.rowid between p_start_rowid and p_end_rowid;
2534:

Line 2541: CURSOR get_sample_data(v_sampling_event_id gmd_samples.sampling_event_id%TYPE) IS

2537: -- 12/09/2005
2538:
2539: -- Bug# 5261810
2540: -- Added org_id and material_detail_id
2541: CURSOR get_sample_data(v_sampling_event_id gmd_samples.sampling_event_id%TYPE) IS
2542: SELECT organization_id, inventory_item_id, revision, lot_number,
2543: subinventory, locator_id, parent_lot_number, org_id, material_detail_id
2544: FROM gmd_samples
2545: WHERE sampling_event_id = v_sampling_event_id

Line 2544: FROM gmd_samples

2540: -- Added org_id and material_detail_id
2541: CURSOR get_sample_data(v_sampling_event_id gmd_samples.sampling_event_id%TYPE) IS
2542: SELECT organization_id, inventory_item_id, revision, lot_number,
2543: subinventory, locator_id, parent_lot_number, org_id, material_detail_id
2544: FROM gmd_samples
2545: WHERE sampling_event_id = v_sampling_event_id
2546: AND rowid BETWEEN p_start_rowid AND p_end_rowid
2547: AND (migrated_ind = 1 OR organization_id IS NOT NULL);
2548:

Line 2581: Log Start of gmd_samples migration.

2577: x_exception_count := 0;
2578: GMD_QC_MIG12.g_progress_ind := 0;
2579:
2580: /*==============================================
2581: Log Start of gmd_samples migration.
2582: ==============================================*/
2583:
2584: GMA_COMMON_LOGGING.gma_migration_central_log (
2585: p_run_id => p_migration_run_id,

Line 2588: p_table_name => 'GMD_SAMPLES',

2584: GMA_COMMON_LOGGING.gma_migration_central_log (
2585: p_run_id => p_migration_run_id,
2586: p_log_level => FND_LOG.LEVEL_EVENT,
2587: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2588: p_table_name => 'GMD_SAMPLES',
2589: p_token1 => 'TABLE_NAME',
2590: p_param1 => 'GMD_SAMPLES',
2591: p_context => 'Quality Samples',
2592: p_app_short_name => 'GMA');

Line 2590: p_param1 => 'GMD_SAMPLES',

2586: p_log_level => FND_LOG.LEVEL_EVENT,
2587: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2588: p_table_name => 'GMD_SAMPLES',
2589: p_token1 => 'TABLE_NAME',
2590: p_param1 => 'GMD_SAMPLES',
2591: p_context => 'Quality Samples',
2592: p_app_short_name => 'GMA');
2593:
2594: /*=======================================

Line 2595: Migrate gmd_samples.

2591: p_context => 'Quality Samples',
2592: p_app_short_name => 'GMA');
2593:
2594: /*=======================================
2595: Migrate gmd_samples.
2596: =======================================*/
2597:
2598: GMD_QC_MIG12.g_sample_upd_count := 0;
2599: Gmd_Qc_Mig12.G_Sample_Err_Count := 0;

Line 3111: Update gmd_samples.

3107: END IF;
3108:
3109:
3110: /*==========================
3111: Update gmd_samples.
3112: ==========================*/
3113:
3114: UPDATE gmd_samples
3115: SET organization_id = l_organization_id,

Line 3114: UPDATE gmd_samples

3110: /*==========================
3111: Update gmd_samples.
3112: ==========================*/
3113:
3114: UPDATE gmd_samples
3115: SET organization_id = l_organization_id,
3116: subinventory = l_subinventory,
3117: locator_id = l_locator_id,
3118: inventory_item_id = l_inventory_item_id,

Line 3145: p_context => 'Quality Samples - gmd_samples',

3141: GMA_COMMON_LOGGING.gma_migration_central_log (
3142: p_run_id => p_migration_run_id,
3143: p_log_level => FND_LOG.LEVEL_ERROR,
3144: p_message_token => 'GMD_MIG_NO_ORG',
3145: p_context => 'Quality Samples - gmd_samples',
3146: p_token1 => 'ORG',
3147: p_token2 => 'ONAME',
3148: p_token3 => 'ROWK',
3149: p_token4 => 'ROWV',

Line 3163: p_context => 'Quality Samples - gmd_samples',

3159: GMA_COMMON_LOGGING.gma_migration_central_log (
3160: p_run_id => p_migration_run_id,
3161: p_log_level => FND_LOG.LEVEL_ERROR,
3162: p_message_token => 'GMD_MIG_NO_ORG',
3163: p_context => 'Quality Samples - gmd_samples',
3164: p_token1 => 'ORG',
3165: p_token2 => 'ONAME',
3166: p_token3 => 'ROWK',
3167: p_token4 => 'ROWV',

Line 3181: p_context => 'Quality Samples - gmd_samples',

3177: GMA_COMMON_LOGGING.gma_migration_central_log (
3178: p_run_id => p_migration_run_id,
3179: p_log_level => FND_LOG.LEVEL_ERROR,
3180: p_message_token => 'GMD_MIG_WHSE_ERROR',
3181: p_context => 'Quality Samples - gmd_samples',
3182: p_token1 => 'WHSE',
3183: p_token2 => 'WNAME',
3184: p_token3 => 'ROWK',
3185: p_token4 => 'ROWV',

Line 3201: p_context => 'Quality Samples - gmd_samples',

3197: p_run_id => p_migration_run_id,
3198: p_log_level => FND_LOG.LEVEL_ERROR,
3199: p_message_token => 'GMD_MIG_SUBINV_MISMATCH',
3200: p_table_name => NULL,
3201: p_context => 'Quality Samples - gmd_samples',
3202: p_token1 => 'SAMPLEID',
3203: p_token2 => 'ORG',
3204: p_token3 => 'WHSE',
3205: p_token4 => 'ORGID',

Line 3222: p_context => 'Quality Samples - gmd_samples',

3218: GMA_COMMON_LOGGING.gma_migration_central_log (
3219: p_run_id => p_migration_run_id,
3220: p_log_level => FND_LOG.LEVEL_ERROR,
3221: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3222: p_context => 'Quality Samples - gmd_samples',
3223: p_token1 => 'ROWK',
3224: p_token2 => 'ROWV',
3225: p_token3 => 'FNAME',
3226: p_param1 => 'SAMPLE_ID',

Line 3239: p_context => 'Quality Samples - gmd_samples',

3235: GMA_COMMON_LOGGING.gma_migration_central_log (
3236: p_run_id => p_migration_run_id,
3237: p_log_level => FND_LOG.LEVEL_ERROR,
3238: p_message_token => 'GMD_MIG_LOCATOR_ID',
3239: p_context => 'Quality Samples - gmd_samples',
3240: p_token1 => 'WHSE',
3241: p_token2 => 'LOCATION',
3242: p_token3 => 'LFIELD',
3243: p_token4 => 'ROWK',

Line 3260: p_context => 'Quality Samples - gmd_samples',

3256: GMA_COMMON_LOGGING.gma_migration_central_log (
3257: p_run_id => p_migration_run_id,
3258: p_log_level => FND_LOG.LEVEL_ERROR,
3259: p_message_token => 'GMD_MIG_SUBINV',
3260: p_context => 'Quality Samples - gmd_samples',
3261: p_token1 => 'LOCATOR',
3262: p_token2 => 'ROWK',
3263: p_token3 => 'ROWV',
3264: p_param1 => to_char(l_locator_id),

Line 3278: p_context => 'Quality Samples - gmd_samples',

3274: GMA_COMMON_LOGGING.gma_migration_central_log (
3275: p_run_id => p_migration_run_id,
3276: p_log_level => FND_LOG.LEVEL_ERROR,
3277: p_message_token => 'GMD_MIG_WHSE_ERROR',
3278: p_context => 'Quality Samples - gmd_samples',
3279: p_token1 => 'WHSE',
3280: p_token2 => 'WNAME',
3281: p_token3 => 'ROWK',
3282: p_token4 => 'ROWV',

Line 3297: p_context => 'Quality Samples - gmd_samples',

3293: GMA_COMMON_LOGGING.gma_migration_central_log (
3294: p_run_id => p_migration_run_id,
3295: p_log_level => FND_LOG.LEVEL_ERROR,
3296: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3297: p_context => 'Quality Samples - gmd_samples',
3298: p_token1 => 'ROWK',
3299: p_token2 => 'ROWV',
3300: p_token3 => 'FNAME',
3301: p_param1 => 'SAMPLE_ID',

Line 3314: p_context => 'Quality Samples - gmd_samples',

3310: GMA_COMMON_LOGGING.gma_migration_central_log (
3311: p_run_id => p_migration_run_id,
3312: p_log_level => FND_LOG.LEVEL_ERROR,
3313: p_message_token => 'GMD_MIG_LOCATOR_ID',
3314: p_context => 'Quality Samples - gmd_samples',
3315: p_token1 => 'WHSE',
3316: p_token2 => 'LOCATION',
3317: p_token3 => 'LFIELD',
3318: p_token4 => 'ROWK',

Line 3337: p_context => 'Quality Samples - gmd_samples',

3333: GMA_COMMON_LOGGING.gma_migration_central_log (
3334: p_run_id => p_migration_run_id,
3335: p_log_level => FND_LOG.LEVEL_ERROR,
3336: p_message_token => 'GMD_MIG_WHSE_ERROR',
3337: p_context => 'Quality Samples - gmd_samples',
3338: p_token1 => 'WHSE',
3339: p_token2 => 'WNAME',
3340: p_token3 => 'ROWK',
3341: p_token4 => 'ROWV',

Line 3356: p_context => 'Quality Samples - gmd_samples',

3352: GMA_COMMON_LOGGING.gma_migration_central_log (
3353: p_run_id => p_migration_run_id,
3354: p_log_level => FND_LOG.LEVEL_ERROR,
3355: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3356: p_context => 'Quality Samples - gmd_samples',
3357: p_token1 => 'ROWK',
3358: p_token2 => 'ROWV',
3359: p_token3 => 'FNAME',
3360: p_param1 => 'SAMPLE_ID',

Line 3373: p_context => 'Quality Samples - gmd_samples',

3369: GMA_COMMON_LOGGING.gma_migration_central_log (
3370: p_run_id => p_migration_run_id,
3371: p_log_level => FND_LOG.LEVEL_ERROR,
3372: p_message_token => 'GMD_MIG_LOCATOR_ID',
3373: p_context => 'Quality Samples - gmd_samples',
3374: p_token1 => 'WHSE',
3375: p_token2 => 'LOCATION',
3376: p_token3 => 'LFIELD',
3377: p_token4 => 'ROWK',

Line 3394: p_context => 'Quality Samples - gmd_samples',

3390: GMA_COMMON_LOGGING.gma_migration_central_log (
3391: p_run_id => p_migration_run_id,
3392: p_log_level => FND_LOG.LEVEL_ERROR,
3393: p_message_token => 'GMD_MIG_SUBINV',
3394: p_context => 'Quality Samples - gmd_samples',
3395: p_token1 => 'LOCATOR',
3396: p_token2 => 'ROWK',
3397: p_token3 => 'ROWV',
3398: p_param1 => to_char(l_source_locator_id),

Line 3411: p_context => 'Quality Samples - gmd_samples',

3407: GMA_COMMON_LOGGING.gma_migration_central_log (
3408: p_run_id => p_migration_run_id,
3409: p_log_level => FND_LOG.LEVEL_ERROR,
3410: p_message_token => 'GMD_MIG_ODM_ITEM',
3411: p_context => 'Quality Samples - gmd_samples',
3412: p_token1 => 'ORG',
3413: p_token2 => 'ITEMID',
3414: p_token3 => 'ROWK',
3415: p_token4 => 'ROWV',

Line 3430: p_context => 'Quality Samples - gmd_samples',

3426: GMA_COMMON_LOGGING.gma_migration_central_log (
3427: p_run_id => p_migration_run_id,
3428: p_log_level => FND_LOG.LEVEL_ERROR,
3429: p_message_token => 'GMD_MIG_OPM_ITEM',
3430: p_context => 'Quality Samples - gmd_samples',
3431: p_token1 => 'ITEMID',
3432: p_token2 => 'ROWK',
3433: p_token3 => 'ROWV',
3434: p_param1 => to_char(v_samp_rec.item_id),

Line 3447: p_context => 'Quality Samples - gmd_samples',

3443: GMA_COMMON_LOGGING.gma_migration_central_log (
3444: p_run_id => p_migration_run_id,
3445: p_log_level => FND_LOG.LEVEL_ERROR,
3446: p_message_token => 'GMD_MIG_LOT',
3447: p_context => 'Quality Samples - gmd_samples',
3448: p_token1 => 'ROWK',
3449: p_token2 => 'ROWV',
3450: p_param1 => 'SAMPLE_ID',
3451: p_param2 => to_char(v_samp_rec.sample_id),

Line 3463: p_context => 'Quality Samples - gmd_samples',

3459: GMA_COMMON_LOGGING.gma_migration_central_log (
3460: p_run_id => p_migration_run_id,
3461: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3462: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3463: p_context => 'Quality Samples - gmd_samples',
3464: p_db_error => SQLERRM,
3465: p_app_short_name => 'GMA');
3466: ROLLBACK;
3467: x_exception_count := x_exception_count + 1;

Line 3475: Log number of updates to gmd_samples.

3471: END LOOP; -- loop of sample record.
3472:
3473:
3474: /*==============================================
3475: Log number of updates to gmd_samples.
3476: ==============================================*/
3477:
3478: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3479:

Line 3507: -- Get Data from gmd_samples.

3503: BEGIN -- sample event subprogram
3504:
3505: GMD_QC_MIG12.g_sample_event_pro_count := GMD_QC_MIG12.g_sample_event_pro_count + 1;
3506: -- ===============================
3507: -- Get Data from gmd_samples.
3508: --===============================
3509: OPEN get_sample_data(v_samp_event.sampling_event_id);
3510: FETCH get_sample_data INTO l_samp_data;
3511: IF (get_sample_data%NOTFOUND) THEN

Line 3575: Using gmd_samples gs On ( gs.rowId BETWEEN p_start_rowid AND p_end_rowid AND

3571: /* Start of Merged code for trying a fix
3572:
3573: Merge into
3574: ( Select * from gmd_sampling_events where migrated_ind is null ) gse
3575: Using gmd_samples gs On ( gs.rowId BETWEEN p_start_rowid AND p_end_rowid AND
3576: gs.sampling_event_id = gse.sampling_event_id AND
3577: (gs.migrated_ind = 1 OR gs.organization_id IS NOT NULL) )
3578: When Matched then Update
3579: Set gse.organization_id = gs.organization_id,

Line 3649: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

3645: NEXTRESULT EXCEPTION;
3646: MIG_LOT_ERROR EXCEPTION;
3647: MIG_ODM_ITEM EXCEPTION;
3648:
3649: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3650: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
3651: l_failure_count NUMBER;
3652: l_lot_number gmd_samples.lot_number%TYPE;
3653:

Line 3650: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;

3646: MIG_LOT_ERROR EXCEPTION;
3647: MIG_ODM_ITEM EXCEPTION;
3648:
3649: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3650: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
3651: l_failure_count NUMBER;
3652: l_lot_number gmd_samples.lot_number%TYPE;
3653:
3654: CURSOR get_results IS

Line 3652: l_lot_number gmd_samples.lot_number%TYPE;

3648:
3649: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3650: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
3651: l_failure_count NUMBER;
3652: l_lot_number gmd_samples.lot_number%TYPE;
3653:
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,

Line 3961: l_organization_id gmd_samples.organization_id%TYPE;

3957: /*==============================
3958: Placeholders.
3959: ==============================*/
3960:
3961: l_organization_id gmd_samples.organization_id%TYPE;
3962: ls_organization_id gmd_samples.organization_id%TYPE;
3963: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3964: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3965: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 3962: ls_organization_id gmd_samples.organization_id%TYPE;

3958: Placeholders.
3959: ==============================*/
3960:
3961: l_organization_id gmd_samples.organization_id%TYPE;
3962: ls_organization_id gmd_samples.organization_id%TYPE;
3963: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3964: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3965: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
3966: l_subinv mtl_item_locations.subinventory_code%TYPE;

Line 3970: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

3966: l_subinv mtl_item_locations.subinventory_code%TYPE;
3967: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3968: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3969: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3970: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3971: l_lot_number gmd_samples.lot_number%TYPE;
3972: l_get_parent_only NUMBER := 0;
3973: l_failure_count NUMBER;
3974: l_return_status NUMBER;

Line 3971: l_lot_number gmd_samples.lot_number%TYPE;

3967: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3968: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3969: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3970: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3971: l_lot_number gmd_samples.lot_number%TYPE;
3972: l_get_parent_only NUMBER := 0;
3973: l_failure_count NUMBER;
3974: l_return_status NUMBER;
3975: l_in_spec_status_id ic_lots_sts.status_id%TYPE;