[Home] [Help]
142: v_currency_code gl_sets_of_books.currency_code%type; --added by Gsr and Sriram on 21-03-2001
143:
144: -- Vijay Shankar for Bug# 3466223
145: v_from_header_id NUMBER;
146: v_from_type_lookup_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;
147: result BOOLEAN;
148: req_id NUMBER;
149:
150: CURSOR Check_Rfq_Quot_Cur IS
150: CURSOR Check_Rfq_Quot_Cur IS
151: SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
152: Vendor_Site_Id, Currency_Code, Ship_To_Location_Id
153: , from_header_id, from_type_lookup_code -- Vijay Shankar for Bug# 3466223
154: FROM Po_Headers_All
155: WHERE Po_Header_Id = v_po_hdr_id;
156:
157: -- Get the Inventory Organization Id
158: CURSOR Fetch_Org_Id_Cur IS
540: success NUMBER; --File.Sql.35 Cbabu := 1;
541:
542: /*v_rowid JAI_CMN_LOCATORS_T.Row_Id%TYPE;*//*commented by rchandan for bug#4479131*/
543: found BOOLEAN;
544: v_style_id po_headers_all.style_id%TYPE;--Added by Sanjikum for Bug#4483042
545:
546: /* Bug 5243532. Added by Lakshmi Gopalsami
547: * Defined variable for implementing caching logic.
548: */
550:
551: ------------------------------------------------------------------------------------
552:
553: CURSOR POC_Cur IS SELECT Rowid
554: FROM Po_Headers_All
555: WHERE Po_Header_Id = v_po_hdr_id;
556:
557: CURSOR Check_Rfq_Quot_Cur IS SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
558: Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
556:
557: CURSOR Check_Rfq_Quot_Cur IS SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
558: Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
559: style_id --Added by Sanjikum for Bug#4483042
560: FROM Po_Headers_All
561: WHERE Po_Header_Id = v_po_hdr_id;
562:
563: -- Get the Inventory Organization Id
564: