The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT um_type,std_factor
FROM sy_uoms_mst
WHERE um_code = V_uom
AND delete_mark = 0;
SELECT type_factor
FROM ic_item_cnv
WHERE item_id = V_item_id
AND lot_id = V_lot_id
AND um_type = V_um_type;
* the proper selection of the conversion factor.
*
* Lab type is a passed parameter from the call lm_uomcv. It
* populates the global variable 'lab_type' which is needed
* for the select criteria in determining the conversion factor.
*
* This is because the lab module allows for different
* conversion factors based on density the standard item conversion
* table is not used here.
*
* Parameters
* none
*
* Return Values
* 1 Success
* -1 Failure
*************************************************************************/
X_density VARCHAR2(40);
SELECT num_data
FROM lm_item_dat
WHERE lab_type = V_lab_type
AND item_id = V_item_id
AND formula_id = V_lot_id
AND tech_parm_name = X_density;
SELECT item_um
FROM ic_item_mst
WHERE item_id = V_item_id;
update the new quantity and return
to caller.
================================== */
IF (V_cur_uom = V_new_uom) THEN
V_new_qty := V_cur_qty;