APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on PO_HEADERS_ALL

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

191: v_line_num NUMBER; -- added on 13th oct
192: v_quot_from_hdr_id NUMBER; -- Added by subbu on 15-OCT-2000
193: v_count NUMBER; -- Added by subbu on 15-OCT-2000
194: v_type VARCHAR2(1) ; -- Added by subbu on 16th-oct-00
195: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
196: v_orig_ship_id NUMBER; /*Bug 8586635*/
197:
198: v_service_type_code VARCHAR2(30); -- added brathod Bug#5879769
199:

Line 206: FROM Po_Headers_All

202: SELECT From_Type_Lookup_Code, from_header_id,
203: Type_Lookup_Code, Quotation_Class_Code,
204: Vendor_id, Vendor_Site_Id, Currency_Code, Ship_To_Location_Id,
205: style_id --Added by Sanjikum for Bug#4483042
206: FROM Po_Headers_All
207: WHERE Po_Header_Id = v_po_hdr_id;
208:
209: CURSOR Fetch_Org_Id_Cur IS
210: SELECT Inventory_Organization_Id

Line 949: v_style_id po_headers_all.style_id%TYPE;

945:
946: -- Start of bug 3037284
947: v_quantity_received PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED%TYPE ; --File.Sql.35 Cbabu := nvl(pr_new.quantity_received,0) ;
948: v_quantity_cancelled PO_LINE_LOCATIONS_ALL.QUANTITY_CANCELLED%TYPE ; --File.Sql.35 Cbabu := pr_new.quantity_cancelled ;
949: v_style_id po_headers_all.style_id%TYPE;
950:
951: CURSOR rec_get_tax_amount
952: IS
953: SELECT

Line 992: po_headers_all

988: ship_to_location_id
989: , rate_type, rate_date, rate, -- Vijay Shankar for Bug #3184673
990: style_id
991: FROM
992: po_headers_all
993: WHERE
994: po_header_id = v_po_hdr_id;
995:
996: -- Get the Inventory Organization Id

Line 1111: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;

1107: AND FSP.org_id = v_operating_id ;
1108:
1109:
1110: -- Vijay Shankar for Bug #3184673
1111: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1112: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1113: v_po_rate PO_HEADERS_ALL.rate%TYPE;
1114:
1115: v_currency_conv_rate NUMBER;

Line 1112: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;

1108:
1109:
1110: -- Vijay Shankar for Bug #3184673
1111: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1112: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1113: v_po_rate PO_HEADERS_ALL.rate%TYPE;
1114:
1115: v_currency_conv_rate NUMBER;
1116: v_trigger_name VARCHAR2(50);

Line 1113: v_po_rate PO_HEADERS_ALL.rate%TYPE;

1109:
1110: -- Vijay Shankar for Bug #3184673
1111: v_po_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1112: v_po_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1113: v_po_rate PO_HEADERS_ALL.rate%TYPE;
1114:
1115: v_currency_conv_rate NUMBER;
1116: v_trigger_name VARCHAR2(50);
1117: v_temp VARCHAR2(2500);