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 139: p_param1 => 'gmd_samples',

135: p_token2 => 'PRO',
136: p_token3 => 'UPD',
137: p_token4 => 'INS',
138: p_token5 => 'ERR',
139: p_param1 => 'gmd_samples',
140: p_param2 => to_char(GMD_QC_MIG12.g_sample_pro_count),
141: p_param3 => to_char(GMD_QC_MIG12.g_sample_upd_count),
142: p_param4 => 0,
143: p_param5 => to_char(GMD_QC_MIG12.g_sample_err_count),

Line 2409: -- gmd_samples organization_id

2405: -- x_exception_count OUT NUMBER - Exception Count
2406: --
2407: -- The following columns will be migrated by the Common migration script.
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

Line 2410: -- gmd_samples lab_organization_id

2406: --
2407: -- The following columns will be migrated by the Common migration script.
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: --=========================================================================== */

Line 2411: -- gmd_samples sample_qty_uom

2407: -- The following columns will be migrated by the Common migration script.
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:

Line 2449: Cursor for gmd_samples.

2445: MIG_SOURCE_SUBINV_ERROR EXCEPTION;
2446:
2447:
2448: /*==============================
2449: Cursor for gmd_samples.
2450: Added organization id to exclude
2451: records added post-migration in
2452: case migration is erroneously
2453: rerun again.

Line 2460: FROM gmd_samples

2456: -- Bug# 5108963
2457: -- Removed organization_id IS NULL from the where clause and added orgn_code IS NOT NULL.
2458: CURSOR get_samples IS
2459: SELECT *
2460: FROM gmd_samples
2461: WHERE migrated_ind IS NULL
2462: AND orgn_code IS NOT NULL;
2463:
2464:

Line 2469: l_organization_id gmd_samples.organization_id%TYPE;

2465: /*==============================
2466: Placeholders.
2467: ==============================*/
2468:
2469: l_organization_id gmd_samples.organization_id%TYPE;
2470: l_lab_organization_id gmd_samples.organization_id%TYPE;
2471: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2472: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2473: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 2470: l_lab_organization_id gmd_samples.organization_id%TYPE;

2466: Placeholders.
2467: ==============================*/
2468:
2469: l_organization_id gmd_samples.organization_id%TYPE;
2470: l_lab_organization_id gmd_samples.organization_id%TYPE;
2471: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2472: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2473: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
2474: l_subinv mtl_item_locations.subinventory_code%TYPE;

Line 2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;

2475: lsub_organization_id mtl_item_locations.organization_id%TYPE;
2476: ls_organization_id mtl_item_locations.organization_id%TYPE;
2477: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

Line 2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;

2476: ls_organization_id mtl_item_locations.organization_id%TYPE;
2477: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

Line 2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;

2477: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2485: l_lot_number gmd_samples.lot_number%TYPE;

Line 2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;

2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2485: l_lot_number gmd_samples.lot_number%TYPE;
2486: l_get_parent_only NUMBER := 0;

Line 2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2485: l_lot_number gmd_samples.lot_number%TYPE;
2486: l_get_parent_only NUMBER := 0;
2487: l_failure_count NUMBER;
2488:

Line 2485: l_lot_number gmd_samples.lot_number%TYPE;

2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2485: l_lot_number gmd_samples.lot_number%TYPE;
2486: l_get_parent_only NUMBER := 0;
2487: l_failure_count NUMBER;
2488:
2489: -- Bug# 5261810

Line 2492: l_source_org_id gmd_samples.organization_id%TYPE;

2488:
2489: -- Bug# 5261810
2490: l_org_id NUMBER;
2491: l_material_detail_id NUMBER;
2492: l_source_org_id gmd_samples.organization_id%TYPE;
2493: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2494: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2495: l_source_subinv gmd_samples.source_subinventory%TYPE;
2496: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 2495: l_source_subinv gmd_samples.source_subinventory%TYPE;

2491: l_material_detail_id NUMBER;
2492: l_source_org_id gmd_samples.organization_id%TYPE;
2493: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2494: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2495: l_source_subinv gmd_samples.source_subinventory%TYPE;
2496: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;
2497: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2498: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2499:

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

2512: -- 12/09/2005
2513:
2514: -- Bug# 5261810
2515: -- Added org_id and material_detail_id
2516: CURSOR get_sample_data(v_sampling_event_id gmd_samples.sampling_event_id%TYPE) IS
2517: SELECT organization_id, inventory_item_id, revision, lot_number,
2518: subinventory, locator_id, parent_lot_number, org_id, material_detail_id
2519: FROM gmd_samples
2520: WHERE sampling_event_id = v_sampling_event_id

Line 2519: FROM gmd_samples

2515: -- Added org_id and material_detail_id
2516: CURSOR get_sample_data(v_sampling_event_id gmd_samples.sampling_event_id%TYPE) IS
2517: SELECT organization_id, inventory_item_id, revision, lot_number,
2518: subinventory, locator_id, parent_lot_number, org_id, material_detail_id
2519: FROM gmd_samples
2520: WHERE sampling_event_id = v_sampling_event_id
2521: AND (migrated_ind = 1 OR organization_id IS NOT NULL);
2522:
2523: l_samp_data get_sample_data%ROWTYPE;

Line 2527: Cursor for gmd_samples.

2523: l_samp_data get_sample_data%ROWTYPE;
2524:
2525:
2526: /*==============================
2527: Cursor for gmd_samples.
2528: ==============================*/
2529:
2530: CURSOR get_results IS
2531: SELECT result_id, qc_lab_orgn_code, lab_organization_id,

Line 2544: Log Start of gmd_samples migration.

2540: x_exception_count := 0;
2541: GMD_QC_MIG12.g_progress_ind := 0;
2542:
2543: /*==============================================
2544: Log Start of gmd_samples migration.
2545: ==============================================*/
2546:
2547: GMA_COMMON_LOGGING.gma_migration_central_log (
2548: p_run_id => p_migration_run_id,

Line 2551: p_table_name => 'GMD_SAMPLES',

2547: GMA_COMMON_LOGGING.gma_migration_central_log (
2548: p_run_id => p_migration_run_id,
2549: p_log_level => FND_LOG.LEVEL_EVENT,
2550: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2551: p_table_name => 'GMD_SAMPLES',
2552: p_token1 => 'TABLE_NAME',
2553: p_param1 => 'GMD_SAMPLES',
2554: p_context => 'Quality Samples',
2555: p_app_short_name => 'GMA');

Line 2553: p_param1 => 'GMD_SAMPLES',

2549: p_log_level => FND_LOG.LEVEL_EVENT,
2550: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2551: p_table_name => 'GMD_SAMPLES',
2552: p_token1 => 'TABLE_NAME',
2553: p_param1 => 'GMD_SAMPLES',
2554: p_context => 'Quality Samples',
2555: p_app_short_name => 'GMA');
2556:
2557: /*=======================================

Line 2558: Migrate gmd_samples.

2554: p_context => 'Quality Samples',
2555: p_app_short_name => 'GMA');
2556:
2557: /*=======================================
2558: Migrate gmd_samples.
2559: =======================================*/
2560:
2561: GMD_QC_MIG12.g_sample_upd_count := 0;
2562: GMD_QC_MIG12.g_sample_err_count := 0;

Line 2937: Update gmd_samples.

2933: END IF;
2934:
2935:
2936: /*==========================
2937: Update gmd_samples.
2938: ==========================*/
2939:
2940: UPDATE gmd_samples
2941: SET organization_id = l_organization_id,

Line 2940: UPDATE gmd_samples

2936: /*==========================
2937: Update gmd_samples.
2938: ==========================*/
2939:
2940: UPDATE gmd_samples
2941: SET organization_id = l_organization_id,
2942: subinventory = l_subinventory,
2943: locator_id = l_locator_id,
2944: inventory_item_id = l_inventory_item_id,

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

2967: GMA_COMMON_LOGGING.gma_migration_central_log (
2968: p_run_id => p_migration_run_id,
2969: p_log_level => FND_LOG.LEVEL_ERROR,
2970: p_message_token => 'GMD_MIG_NO_ORG',
2971: p_context => 'Quality Samples - gmd_samples',
2972: p_token1 => 'ORG',
2973: p_token2 => 'ONAME',
2974: p_token3 => 'ROWK',
2975: p_token4 => 'ROWV',

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

2985: GMA_COMMON_LOGGING.gma_migration_central_log (
2986: p_run_id => p_migration_run_id,
2987: p_log_level => FND_LOG.LEVEL_ERROR,
2988: p_message_token => 'GMD_MIG_NO_ORG',
2989: p_context => 'Quality Samples - gmd_samples',
2990: p_token1 => 'ORG',
2991: p_token2 => 'ONAME',
2992: p_token3 => 'ROWK',
2993: p_token4 => 'ROWV',

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

3003: GMA_COMMON_LOGGING.gma_migration_central_log (
3004: p_run_id => p_migration_run_id,
3005: p_log_level => FND_LOG.LEVEL_ERROR,
3006: p_message_token => 'GMD_MIG_WHSE_ERROR',
3007: p_context => 'Quality Samples - gmd_samples',
3008: p_token1 => 'WHSE',
3009: p_token2 => 'WNAME',
3010: p_token3 => 'ROWK',
3011: p_token4 => 'ROWV',

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

3023: p_run_id => p_migration_run_id,
3024: p_log_level => FND_LOG.LEVEL_ERROR,
3025: p_message_token => 'GMD_MIG_SUBINV_MISMATCH',
3026: p_table_name => NULL,
3027: p_context => 'Quality Samples - gmd_samples',
3028: p_token1 => 'SAMPLEID',
3029: p_token2 => 'ORG',
3030: p_token3 => 'WHSE',
3031: p_token4 => 'ORGID',

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

3044: GMA_COMMON_LOGGING.gma_migration_central_log (
3045: p_run_id => p_migration_run_id,
3046: p_log_level => FND_LOG.LEVEL_ERROR,
3047: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3048: p_context => 'Quality Samples - gmd_samples',
3049: p_token1 => 'ROWK',
3050: p_token2 => 'ROWV',
3051: p_token3 => 'FNAME',
3052: p_param1 => 'SAMPLE_ID',

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

3061: GMA_COMMON_LOGGING.gma_migration_central_log (
3062: p_run_id => p_migration_run_id,
3063: p_log_level => FND_LOG.LEVEL_ERROR,
3064: p_message_token => 'GMD_MIG_LOCATOR_ID',
3065: p_context => 'Quality Samples - gmd_samples',
3066: p_token1 => 'WHSE',
3067: p_token2 => 'LOCATION',
3068: p_token3 => 'LFIELD',
3069: p_token4 => 'ROWK',

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

3082: GMA_COMMON_LOGGING.gma_migration_central_log (
3083: p_run_id => p_migration_run_id,
3084: p_log_level => FND_LOG.LEVEL_ERROR,
3085: p_message_token => 'GMD_MIG_SUBINV',
3086: p_context => 'Quality Samples - gmd_samples',
3087: p_token1 => 'LOCATOR',
3088: p_token2 => 'ROWK',
3089: p_token3 => 'ROWV',
3090: p_param1 => to_char(l_locator_id),

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

3100: GMA_COMMON_LOGGING.gma_migration_central_log (
3101: p_run_id => p_migration_run_id,
3102: p_log_level => FND_LOG.LEVEL_ERROR,
3103: p_message_token => 'GMD_MIG_WHSE_ERROR',
3104: p_context => 'Quality Samples - gmd_samples',
3105: p_token1 => 'WHSE',
3106: p_token2 => 'WNAME',
3107: p_token3 => 'ROWK',
3108: p_token4 => 'ROWV',

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

3119: GMA_COMMON_LOGGING.gma_migration_central_log (
3120: p_run_id => p_migration_run_id,
3121: p_log_level => FND_LOG.LEVEL_ERROR,
3122: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3123: p_context => 'Quality Samples - gmd_samples',
3124: p_token1 => 'ROWK',
3125: p_token2 => 'ROWV',
3126: p_token3 => 'FNAME',
3127: p_param1 => 'SAMPLE_ID',

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

3136: GMA_COMMON_LOGGING.gma_migration_central_log (
3137: p_run_id => p_migration_run_id,
3138: p_log_level => FND_LOG.LEVEL_ERROR,
3139: p_message_token => 'GMD_MIG_LOCATOR_ID',
3140: p_context => 'Quality Samples - gmd_samples',
3141: p_token1 => 'WHSE',
3142: p_token2 => 'LOCATION',
3143: p_token3 => 'LFIELD',
3144: p_token4 => 'ROWK',

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_WHSE_ERROR',
3163: p_context => 'Quality Samples - gmd_samples',
3164: p_token1 => 'WHSE',
3165: p_token2 => 'WNAME',
3166: p_token3 => 'ROWK',
3167: p_token4 => 'ROWV',

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

3178: GMA_COMMON_LOGGING.gma_migration_central_log (
3179: p_run_id => p_migration_run_id,
3180: p_log_level => FND_LOG.LEVEL_ERROR,
3181: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
3182: p_context => 'Quality Samples - gmd_samples',
3183: p_token1 => 'ROWK',
3184: p_token2 => 'ROWV',
3185: p_token3 => 'FNAME',
3186: p_param1 => 'SAMPLE_ID',

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

3195: GMA_COMMON_LOGGING.gma_migration_central_log (
3196: p_run_id => p_migration_run_id,
3197: p_log_level => FND_LOG.LEVEL_ERROR,
3198: p_message_token => 'GMD_MIG_LOCATOR_ID',
3199: p_context => 'Quality Samples - gmd_samples',
3200: p_token1 => 'WHSE',
3201: p_token2 => 'LOCATION',
3202: p_token3 => 'LFIELD',
3203: p_token4 => 'ROWK',

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

3216: GMA_COMMON_LOGGING.gma_migration_central_log (
3217: p_run_id => p_migration_run_id,
3218: p_log_level => FND_LOG.LEVEL_ERROR,
3219: p_message_token => 'GMD_MIG_SUBINV',
3220: p_context => 'Quality Samples - gmd_samples',
3221: p_token1 => 'LOCATOR',
3222: p_token2 => 'ROWK',
3223: p_token3 => 'ROWV',
3224: p_param1 => to_char(l_source_locator_id),

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

3233: GMA_COMMON_LOGGING.gma_migration_central_log (
3234: p_run_id => p_migration_run_id,
3235: p_log_level => FND_LOG.LEVEL_ERROR,
3236: p_message_token => 'GMD_MIG_ODM_ITEM',
3237: p_context => 'Quality Samples - gmd_samples',
3238: p_token1 => 'ORG',
3239: p_token2 => 'ITEMID',
3240: p_token3 => 'ROWK',
3241: p_token4 => 'ROWV',

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

3252: GMA_COMMON_LOGGING.gma_migration_central_log (
3253: p_run_id => p_migration_run_id,
3254: p_log_level => FND_LOG.LEVEL_ERROR,
3255: p_message_token => 'GMD_MIG_OPM_ITEM',
3256: p_context => 'Quality Samples - gmd_samples',
3257: p_token1 => 'ITEMID',
3258: p_token2 => 'ROWK',
3259: p_token3 => 'ROWV',
3260: p_param1 => to_char(v_samp_rec.item_id),

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

3269: GMA_COMMON_LOGGING.gma_migration_central_log (
3270: p_run_id => p_migration_run_id,
3271: p_log_level => FND_LOG.LEVEL_ERROR,
3272: p_message_token => 'GMD_MIG_LOT',
3273: p_context => 'Quality Samples - gmd_samples',
3274: p_token1 => 'ROWK',
3275: p_token2 => 'ROWV',
3276: p_param1 => 'SAMPLE_ID',
3277: p_param2 => to_char(v_samp_rec.sample_id),

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

3285: GMA_COMMON_LOGGING.gma_migration_central_log (
3286: p_run_id => p_migration_run_id,
3287: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
3288: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3289: p_context => 'Quality Samples - gmd_samples',
3290: p_db_error => SQLERRM,
3291: p_app_short_name => 'GMA');
3292: ROLLBACK;
3293: x_exception_count := x_exception_count + 1;

Line 3301: Log number of updates to gmd_samples.

3297: END LOOP; -- loop of sample record.
3298:
3299:
3300: /*==============================================
3301: Log number of updates to gmd_samples.
3302: ==============================================*/
3303:
3304: LOG_SAMPLE_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
3305:

Line 3333: Get Data from gmd_samples.

3329: BEGIN -- sample event subprogram
3330:
3331: GMD_QC_MIG12.g_sample_event_pro_count := GMD_QC_MIG12.g_sample_event_pro_count + 1;
3332: /*===============================
3333: Get Data from gmd_samples.
3334: ===============================*/
3335: OPEN get_sample_data(v_samp_event.sampling_event_id);
3336: FETCH get_sample_data INTO l_samp_data;
3337: IF (get_sample_data%NOTFOUND) THEN

Line 3692: l_organization_id gmd_samples.organization_id%TYPE;

3688: /*==============================
3689: Placeholders.
3690: ==============================*/
3691:
3692: l_organization_id gmd_samples.organization_id%TYPE;
3693: ls_organization_id gmd_samples.organization_id%TYPE;
3694: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3695: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3696: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 3693: ls_organization_id gmd_samples.organization_id%TYPE;

3689: Placeholders.
3690: ==============================*/
3691:
3692: l_organization_id gmd_samples.organization_id%TYPE;
3693: ls_organization_id gmd_samples.organization_id%TYPE;
3694: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3695: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3696: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
3697: l_subinv mtl_item_locations.subinventory_code%TYPE;

Line 3701: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

3697: l_subinv mtl_item_locations.subinventory_code%TYPE;
3698: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3699: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3700: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3701: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3702: l_lot_number gmd_samples.lot_number%TYPE;
3703: l_get_parent_only NUMBER := 0;
3704: l_failure_count NUMBER;
3705: l_return_status NUMBER;

Line 3702: l_lot_number gmd_samples.lot_number%TYPE;

3698: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3699: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3700: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3701: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3702: l_lot_number gmd_samples.lot_number%TYPE;
3703: l_get_parent_only NUMBER := 0;
3704: l_failure_count NUMBER;
3705: l_return_status NUMBER;
3706: l_in_spec_status_id ic_lots_sts.status_id%TYPE;