[Home] [Help]
4511: -- Conversion rate used for converting quantity from one uom to another
4512: --p_rounding factor
4513: -- Rounding factor used rounding the Requisition line level quantity
4514: --p_enforce_full_lot_qty
4515: -- PO System parameters: Enforce Full Lot Quantities. Valid values are
4516: -- NONE, ADVISORY and MANDATORY
4517: --IN OUT:
4518: --x_quantity
4519: -- Requisition line level quantity.
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4811: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4812: l_uom_conversion_rate NUMBER;
4813: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;
4814: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;
4815: l_asl_purchasing_uom PO_ASL_ATTRIBUTES.purchasing_unit_of_measure%type; --
4816: --
4817:
5226:
5227: begin
5228: SELECT enforce_full_lot_quantities
5229: INTO l_enforce_full_lot_qty
5230: FROM po_system_parameters;
5231: exception when others then
5232: l_enforce_full_lot_qty := null;
5233: end;
5234: -- Calling the procedure for applying order modifier, quantity conversion and rounding
5339: --UOM conversion and rounding operations are to be performed on the
5340: --Requisition.
5341: SELECT enforce_full_lot_quantities
5342: INTO l_enforce_full_lot_qty
5343: FROM po_system_parameters;
5344: --
5345:
5346: OPEN L_GET_REQ_INFO_INV_CSR;
5347: LOOP
6852: -- SQL Why : To calculate the currency conversion rate
6853:
6854: SELECT default_rate_type
6855: INTO l_rate_type
6856: FROM po_system_parameters;
6857:
6858: -- SQL What: Get the currency precision from system parameters
6859: -- SQL Why : To round the calculated amount
6860: