eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_HEADERS_ALL

Line 898: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042

894: v_loc_count NUMBER;--File.Sql.35 Cbabu := 0; --new variable for loc chk on 17-aug-00
895:
896: v_tax_category_id JAI_PO_TAXES.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
897: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
898: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
899:
900: ------------------------------>
901: -- Check the vendor btn the vendor present in tax lines and that of suggested vendor in requisition lines
902: -- If they are same or any one is null then insert po vendor else keep the vendor in tact.

Line 935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

931: v_ship_to_location_id NUMBER;
932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
937: -- End, Vijay Shankar for Bug# 3193592
938:
939: CURSOR Fetch_Unit_Measure_Cur IS

Line 936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;

932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
937: -- End, Vijay Shankar for Bug# 3193592
938:
939: CURSOR Fetch_Unit_Measure_Cur IS
940: SELECT Unit_Meas_Lookup_Code

Line 954: FROM Po_Headers_All

950: CURSOR Fetch_Po_Vendor_Id_Cur( hdr_id IN NUMBER ) IS
951: SELECT Vendor_Id, Vendor_SIte_Id, Currency_Code, Rate_Date, Rate_Type, Rate
952: , type_lookup_code, quotation_class_code, -- Vijay Shankar for Bug# 3193592
953: style_id --Added by Sanjikum for Bug#4483042
954: FROM Po_Headers_All
955: WHERE Po_Header_Id = hdr_id;
956:
957: /* Bug 4513549. Added by LGOPALSA
958: Commented the following cursor as it is