APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 175: FROM Mtl_Units_Of_Measure

171:
172: --CURSOR Fetch_Uom_Code_Cur IS pramasub FP start
173: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS /*4281841*/
174: SELECT Uom_Code
175: FROM Mtl_Units_Of_Measure
176: WHERE Unit_Of_Measure = cp_unit_of_meas;
177: --WHERE Unit_Of_Measure = v_uom_code; pramasub start
178:
179: -- additions by sriram - starts here Bug # 2977200

Line 283: Uom_Code was fetched from mtl_units_of_measure using a Query instead of cursor

279: 12. 07-Nov-2008 JMEENA for bug#5394234
280: Increased the length of variables v_sugg_vendor_name and v_sugg_vendor_loc from 80 to 360
281:
282: 13 31-JUL-2009 Bug 8711805
283: Uom_Code was fetched from mtl_units_of_measure using a Query instead of cursor
284: Hence when unit_of_measure is NULL in case of 'Fixed Price Services' Line Type
285: (Set in Profile option 'POR : Amount Based Services Line Type') NO_DATA_FOUND
286: error is thrown.
287:

Line 605: FROM Mtl_Units_of_Measure

601: /*Added for Bug 8711805 - End*/
602: /*
603: SELECT Uom_Code
604: INTO v_uom_code
605: FROM Mtl_Units_of_Measure
606: WHERE Unit_Of_Measure = pr_new.Unit_Meas_Lookup_Code;
607: */
608:
609: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,

Line 1033: FROM Mtl_Units_Of_Measure

1029: WHERE Po_Line_Id = v_po_line_id;
1030:
1031: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
1032: SELECT Uom_Code
1033: FROM Mtl_Units_Of_Measure
1034: WHERE Unit_Of_Measure = p_uom;
1035:
1036: -- Pick up vendor id for the corresponding Po_Header_Id
1037: CURSOR Fetch_Po_Vendor_Id_Cur( hdr_id IN NUMBER ) IS

Line 1959: FROM Mtl_Units_Of_Measure

1955: * and implemented the same using caching logic.
1956: */
1957:
1958: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
1959: FROM Mtl_Units_Of_Measure
1960: WHERE Unit_Of_Measure = v_uom;
1961:
1962: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
1963: From JAI_PO_REQ_LINES

Line 2788: FROM Mtl_Units_Of_Measure

2784: FROM Po_Requisition_Headers_V
2785: WHERE Requisition_Header_Id = v_header_id;
2786:
2787: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
2788: FROM Mtl_Units_Of_Measure
2789: WHERE Unit_Of_Measure = v_uom;
2790:
2791: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2792: From JAI_PO_REQ_LINES