DBA Data[Home] [Help]

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 661: Insert Row to mtl_lot_uom_class_conversions.

657:
658:
659: IF (p_process_data = 'Y') THEN
660: /*=============================================
661: Insert Row to mtl_lot_uom_class_conversions.
662: Perform all database updates.
663: ===========================================*/
664:
665: l_tran_seq := x_sequence;