[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
528: success NUMBER; --File.Sql.35 Cbabu := 1;
529:
530: /*v_rowid JAI_CMN_LOCATORS_T.Row_Id%TYPE;*//*commented by rchandan for bug#4479131*/
531: found BOOLEAN;
532: v_style_id po_headers_all.style_id%TYPE;--Added by Sanjikum for Bug#4483042
533:
534: /* Bug 5243532. Added by Lakshmi Gopalsami
535: * Defined variable for implementing caching logic.
536: */
538:
539: ------------------------------------------------------------------------------------
540:
541: CURSOR POC_Cur IS SELECT Rowid
542: FROM Po_Headers_All
543: WHERE Po_Header_Id = v_po_hdr_id;
544:
545: CURSOR Check_Rfq_Quot_Cur IS SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
546: Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
544:
545: CURSOR Check_Rfq_Quot_Cur IS SELECT Type_Lookup_Code, Quotation_Class_Code, Vendor_id,
546: Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
547: style_id --Added by Sanjikum for Bug#4483042
548: FROM Po_Headers_All
549: WHERE Po_Header_Id = v_po_hdr_id;
550:
551: -- Get the Inventory Organization Id
552: