[Home] [Help]
115: , x_parent_lot_number IN OUT NOCOPY VARCHAR2
116: , x_failure_count OUT NOCOPY NUMBER
117: ) IS
118: PRAGMA AUTONOMOUS_TRANSACTION;
119: l_lot_rec mtl_lot_numbers%ROWTYPE;
120: o_lot_rec mtl_lot_numbers%ROWTYPE;
121: o_item_rec INV_ITEM_API.Item_rec_type;
122: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
123: l_opm_lot ic_lots_mst%ROWTYPE;
116: , x_failure_count OUT NOCOPY NUMBER
117: ) IS
118: PRAGMA AUTONOMOUS_TRANSACTION;
119: l_lot_rec mtl_lot_numbers%ROWTYPE;
120: o_lot_rec mtl_lot_numbers%ROWTYPE;
121: o_item_rec INV_ITEM_API.Item_rec_type;
122: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
123: l_opm_lot ic_lots_mst%ROWTYPE;
124: l_inventory_item_id NUMBER;
474:
475: -- Check if the lot already exists
476: SELECT count(*)
477: INTO l_count
478: FROM mtl_lot_numbers
479: WHERE
480: organization_id = p_organization_id AND
481: inventory_item_id = l_inventory_item_id AND
482: lot_number = x_lot_number;
499: p_app_short_name => 'GMI');
500:
501: /* Start for fix for Bug#9600386 */
502:
503: UPDATE MTL_LOT_NUMBERS
504: SET VENDOR_ID = l_lot_rec.vendor_id,
505: VENDOR_NAME = l_lot_rec.vendor_name,
506: SUPPLIER_LOT_NUMBER = l_opm_lot.vendor_lot_no
507: WHERE organization_id = p_organization_id AND
633: FROM fnd_descr_flex_column_usages col2,
634: fnd_descr_flex_contexts cont2
635: WHERE
636: col2.application_id = 401 and
637: col2.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
638: col2.enabled_flag = 'Y' and
639: col.application_id = cont2.application_id and
640: col.descriptive_flexfield_name = cont2.descriptive_flexfield_name and
641: col.descriptive_flex_context_code = cont2.descriptive_flex_context_code and
679: SELECT cont.descriptive_flex_context_code
680: INTO l_odm_context
681: FROM fnd_descr_flex_contexts cont
682: WHERE cont.application_id = 401 and
683: cont.descriptive_flexfield_name = 'MTL_LOT_NUMBERS' and
684: cont.enabled_flag = 'Y' and
685: cont.global_flag = 'N' and
686: rownum = 1;
687: EXCEPTION