APPS.MTL_LOT_UOM_CONV_PUB dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 100: , p_lot_uom_conv_rec IN OUT NOCOPY mtl_lot_uom_class_conversions%ROWTYPE

96: , p_update_type_indicator IN NUMBER DEFAULT 5
97: , p_reason_id IN NUMBER
98: , p_batch_id IN NUMBER
99: , p_process_data IN VARCHAR2
100: , p_lot_uom_conv_rec IN OUT NOCOPY mtl_lot_uom_class_conversions%ROWTYPE
101: , p_qty_update_tbl IN OUT NOCOPY MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type
102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_msg_count OUT NOCOPY NUMBER
104: , x_msg_data OUT NOCOPY VARCHAR2

Line 111: l_conv_seq MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_ID%TYPE;

107:
108: IS
109: l_api_name CONSTANT VARCHAR2(30) := 'create_lot_uom_conversion';
110: l_api_version CONSTANT NUMBER := 1.0 ;
111: l_conv_seq MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_ID%TYPE;
112: l_aud_seq MTL_LOT_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
113:
114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;

Line 663: Insert Row to mtl_lot_uom_class_conversions.

659:
660:
661: IF (p_process_data = 'Y') THEN
662: /*=============================================
663: Insert Row to mtl_lot_uom_class_conversions.
664: Perform all database updates.
665: ===========================================*/
666: --bug#12566380
667: BEGIN

Line 669: FROM mtl_lot_uom_class_conversions

665: ===========================================*/
666: --bug#12566380
667: BEGIN
668: SELECT conversion_id into l_conversion_id
669: FROM mtl_lot_uom_class_conversions
670: WHERE organization_id = p_lot_uom_conv_rec.organization_id AND
671: inventory_item_id = p_lot_uom_conv_rec.inventory_item_id AND
672: lot_number = p_lot_uom_conv_rec.lot_number AND
673: from_uom_code = p_lot_uom_conv_rec.from_uom_code AND