APPS.GMD_QC_MIG12 dependencies on INV_OPM_LOT_MIGRATION

Line 2934: inv_opm_lot_migration.GET_ODM_LOT (

2930: IF (l_get_parent_only = 1) THEN
2931: l_parent_lot_number := v_samp_rec.lot_no;
2932: l_lot_number := null;
2933: ELSE
2934: inv_opm_lot_migration.GET_ODM_LOT (
2935: P_MIGRATION_RUN_ID => p_migration_run_id,
2936: P_ORGN_CODE => v_samp_rec.orgn_code,
2937: P_ITEM_ID => v_samp_rec.item_id,
2938: P_LOT_NO => v_samp_rec.lot_no,

Line 3004: -- 13826138 replace call to inv_opm_lot_migration.GET_ODM_LOT with

3000: END IF;
3001:
3002:
3003:
3004: -- 13826138 replace call to inv_opm_lot_migration.GET_ODM_LOT with
3005: --P_GET_PARENT_ONLY => 1 with a call to c acusror
3006: -- as this was generating spurious error messages whern not found (i.e
3007: -- non--else had migrated the parent lot _
3008: l_parent_lot_number := null;

Line 3028: inv_opm_lot_migration.GET_ODM_LOT (

3024: RAISE MIG_LOT_ERROR;
3025: END IF;
3026: CLOSE get_lot;
3027:
3028: inv_opm_lot_migration.GET_ODM_LOT (
3029: P_MIGRATION_RUN_ID => p_migration_run_id,
3030: P_ORGN_CODE => v_samp_rec.orgn_code,
3031: P_ITEM_ID => v_samp_rec.item_id,
3032: P_LOT_NO => l_lot_no,

Line 3061: inv_opm_lot_migration.GET_ODM_LOT (

3057: END IF; -- IF l_parent_lot_number is NULL then
3058:
3059: ELSE -- IF (l_get_parent_only = 1) THEN if here means l_get_parent_only = 0
3060:
3061: inv_opm_lot_migration.GET_ODM_LOT (
3062: P_MIGRATION_RUN_ID => p_migration_run_id,
3063: P_ORGN_CODE => v_samp_rec.orgn_code,
3064: P_ITEM_ID => v_samp_rec.item_id,
3065: P_LOT_NO => v_samp_rec.lot_no,

Line 3743: inv_opm_lot_migration.GET_ODM_LOT (

3739: Get Lot Number.
3740: =======================*/
3741:
3742: IF (v_result.test_kit_lot_no IS NOT NULL AND l_inventory_item_id IS NOT NULL) THEN
3743: inv_opm_lot_migration.GET_ODM_LOT (
3744: P_MIGRATION_RUN_ID => p_migration_run_id,
3745: P_ORGN_CODE => v_result.qc_lab_orgn_code,
3746: P_ITEM_ID => v_result.test_kit_item_id,
3747: P_LOT_NO => v_result.test_kit_lot_no,

Line 4680: inv_opm_lot_migration.GET_ODM_LOT (

4676: IF (l_get_parent_only = 1) THEN
4677: l_parent_lot_number := l_inv_spec.lot_no;
4678: l_lot_number := null;
4679: ELSE
4680: inv_opm_lot_migration.GET_ODM_LOT (
4681: P_MIGRATION_RUN_ID => p_migration_run_id,
4682: P_ORGN_CODE => l_inv_spec.orgn_code,
4683: P_ITEM_ID => l_item_id,
4684: P_LOT_NO => l_inv_spec.lot_no,

Line 4850: inv_opm_lot_migration.GET_ODM_LOT (

4846: IF (l_get_parent_only = 1) THEN
4847: l_parent_lot_number := l_inv_spec.lot_no;
4848: l_lot_number := null;
4849: ELSE
4850: inv_opm_lot_migration.GET_ODM_LOT (
4851: P_MIGRATION_RUN_ID => p_migration_run_id,
4852: P_ORGN_CODE => l_sample_orgn_code,
4853: P_ITEM_ID => l_item_id,
4854: P_LOT_NO => l_inv_spec.lot_no,

Line 4954: inv_opm_lot_migration.GET_ODM_LOT (

4950: IF (l_get_parent_only = 1) THEN
4951: l_parent_lot_number := l_inv_spec.lot_no;
4952: l_lot_number := null;
4953: ELSE
4954: inv_opm_lot_migration.GET_ODM_LOT (
4955: P_MIGRATION_RUN_ID => p_migration_run_id,
4956: P_ORGN_CODE => l_sample_orgn_code,
4957: P_ITEM_ID => l_item_id,
4958: P_LOT_NO => l_inv_spec.lot_no,

Line 7856: inv_opm_lot_migration.GET_ODM_LOT (

7852: IF (l_ss_item_id IS NOT NULL AND l_matl_rec.lot_id IS NOT NULL) THEN --verify
7853: /*=======================
7854: Get Lot Number.
7855: =======================*/
7856: inv_opm_lot_migration.GET_ODM_LOT (
7857: P_MIGRATION_RUN_ID => p_migration_run_id,
7858: P_ORGN_CODE => l_lot_orgn_code,
7859: P_ITEM_ID => l_ss_item_id,
7860: P_LOT_ID => l_matl_rec.lot_id,