APPS.INV_LOT_API_PKG dependencies on MTL_PARAMETERS

Line 149: FROM mtl_parameters

145: /* Cursor definition to check if Lot UOM Conversion is needed */
146: CURSOR c_lot_uom_conv(cp_organization_id NUMBER) IS
147: SELECT copy_lot_attribute_flag,
148: lot_number_generation
149: FROM mtl_parameters
150: WHERE organization_id = cp_organization_id;
151:
152: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
153:

Line 261: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either

257:
258: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
259:
260: IF p_copy_lot_attribute_flag IS NULL THEN
261: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
262: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
263:
264: /* Check needed for Lot UOM conversion */
265: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;

Line 262: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.

258: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
259:
260: IF p_copy_lot_attribute_flag IS NULL THEN
261: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
262: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
263:
264: /* Check needed for Lot UOM conversion */
265: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
266: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;

Line 269: -- Possible values for mtl_parameters.lot_number_generation are:

265: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
266: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
267:
268: IF c_lot_uom_conv%FOUND THEN
269: -- Possible values for mtl_parameters.lot_number_generation are:
270: -- 1 At organization level
271: -- 3 User defined
272: -- 2 At item level
273: