DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_SYSTEM_PARAMETERS

Line 4487: -- PO System parameters: Enforce Full Lot Quantities. Valid values are

4483: -- Conversion rate used for converting quantity from one uom to another
4484: --p_rounding factor
4485: -- Rounding factor used rounding the Requisition line level quantity
4486: --p_enforce_full_lot_qty
4487: -- PO System parameters: Enforce Full Lot Quantities. Valid values are
4488: -- NONE, ADVISORY and MANDATORY
4489: --IN OUT:
4490: --x_quantity
4491: -- Requisition line level quantity.

Line 4775: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;

4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4773: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4774: l_uom_conversion_rate NUMBER;
4775: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;
4776: l_interface_source_code PO_REQUISITIONS_INTERFACE.interface_source_code%type;
4777: l_asl_purchasing_uom PO_ASL_ATTRIBUTES.purchasing_unit_of_measure%type; --
4778: --
4779:

Line 5266: FROM po_system_parameters;

5262: --UOM conversion and rounding operations are to be performed on the
5263: --Requisition.
5264: SELECT enforce_full_lot_quantities
5265: INTO l_enforce_full_lot_qty
5266: FROM po_system_parameters;
5267: --
5268:
5269: OPEN L_GET_REQ_INFO_INV_CSR;
5270: LOOP

Line 6779: FROM po_system_parameters;

6775: -- SQL Why : To calculate the currency conversion rate
6776:
6777: SELECT default_rate_type
6778: INTO l_rate_type
6779: FROM po_system_parameters;
6780:
6781: -- SQL What: Get the currency precision from system parameters
6782: -- SQL Why : To round the calculated amount
6783: