APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on PO_HEADERS_ALL

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

174: v_line_num NUMBER; -- added on 13th oct
175: v_quot_from_hdr_id NUMBER; -- Added by subbu on 15-OCT-2000
176: v_count NUMBER; -- Added by subbu on 15-OCT-2000
177: v_type VARCHAR2(1) ; -- Added by subbu on 16th-oct-00
178: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
179:
180: v_service_type_code VARCHAR2(30); -- added brathod Bug#5879769
181:
182:

Line 188: FROM Po_Headers_All

184: SELECT From_Type_Lookup_Code, from_header_id,
185: Type_Lookup_Code, Quotation_Class_Code,
186: Vendor_id, Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
187: style_id --Added by Sanjikum for Bug#4483042
188: FROM Po_Headers_All
189: WHERE Po_Header_Id = v_po_hdr_id;
190:
191: CURSOR Fetch_Org_Id_Cur IS
192: SELECT Inventory_Organization_Id

Line 798: v_style_id po_headers_all.style_id%TYPE;

794:
795: -- Start of bug 3037284
796: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
797: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
798: v_style_id po_headers_all.style_id%TYPE;
799:
800: CURSOR rec_get_tax_amount
801: IS
802: SELECT

Line 841: po_headers_all

837: ship_to_location_id
838: , rate_type, rate_date, rate, -- Vijay Shankar for Bug #3184673
839: style_id
840: FROM
841: po_headers_all
842: WHERE
843: po_header_id = v_po_hdr_id;
844:
845: -- Get the Inventory Organization Id

Line 960: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;

956: AND FSP.org_id = v_operating_id ;
957:
958:
959: -- Vijay Shankar for Bug #3184673
960: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
961: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
962: v_po_rate PO_HEADERS_ALL.rate%TYPE;
963:
964: v_currency_conv_rate NUMBER;

Line 961: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;

957:
958:
959: -- Vijay Shankar for Bug #3184673
960: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
961: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
962: v_po_rate PO_HEADERS_ALL.rate%TYPE;
963:
964: v_currency_conv_rate NUMBER;
965: v_trigger_name VARCHAR2(50);

Line 962: v_po_rate PO_HEADERS_ALL.rate%TYPE;

958:
959: -- Vijay Shankar for Bug #3184673
960: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
961: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
962: v_po_rate PO_HEADERS_ALL.rate%TYPE;
963:
964: v_currency_conv_rate NUMBER;
965: v_trigger_name VARCHAR2(50);
966: v_temp VARCHAR2(2500);