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_TAX_PKG dependencies on PO_HEADERS_ALL

Line 319: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,

315: Curr JAI_PO_TAXES.CURRENCY%TYPE,
316: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
317: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
318: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
319: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
320: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
321: );
322:
323:

Line 1353: , po_headers_all pha --Added by Kevin Cheng

1349: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1350: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1351: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1352: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
1353: , po_headers_all pha --Added by Kevin Cheng
1354: WHERE Po_Line_Id = p_line_id
1355: AND Line_Location_Id = p_line_loc_id
1356: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1357: AND A.Tax_Id = B.Tax_Id

Line 2391: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL

2387: p_Last_Update_Date date,
2388: p_Last_Updated_By number,
2389: p_Last_Update_Login number
2390: /* Brathod, For Bug# 4242351 */
2391: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
2392: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
2393: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
2394: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
2395: /* End of Bug# 4242351 */

Line 2392: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL

2388: p_Last_Updated_By number,
2389: p_Last_Update_Login number
2390: /* Brathod, For Bug# 4242351 */
2391: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
2392: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
2393: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
2394: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
2395: /* End of Bug# 4242351 */
2396: )

Line 2393: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL

2389: p_Last_Update_Login number
2390: /* Brathod, For Bug# 4242351 */
2391: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
2392: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
2393: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
2394: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
2395: /* End of Bug# 4242351 */
2396: )
2397: IS

Line 2394: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

2390: /* Brathod, For Bug# 4242351 */
2391: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
2392: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
2393: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
2394: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
2395: /* End of Bug# 4242351 */
2396: )
2397: IS
2398: v_vendor_id NUMBER; --File.Sql.35 Cbabu := NVL( p_Vendor_Id, 0 );

Line 2497: Issue:- Cursor get_po_hdr having a select statement on table po_headers_all

2493: 2. 14/03/2005 bug#4250072 rallamse Version# 115.2
2494: Changes for VAT implementation
2495:
2496: 3. 31/03/2005 Brathod, Bug#4242351, Version 115.3
2497: Issue:- Cursor get_po_hdr having a select statement on table po_headers_all
2498: was raising mutating error.
2499: Solution:- Four new parameters are passed to the procedure
2500: to avoid select statement.
2501: 4. Kunkumar Added v_service_type_code and its manipulations for forward porting to R12.

Line 2825: FROM po_headers_all

2821: ln_vat_assessable_value NUMBER;
2822: ---------------------------------------------------
2823: CURSOR c_po_hdr_curr(p_po_header_id IN NUMBER) IS
2824: SELECT currency_code, org_id
2825: FROM po_headers_all
2826: WHERE po_header_id = p_po_header_id;
2827:
2828: /*cursor modified to use headers instead of lines as it is mutating in reqn triggers
2829: for bug#5877782*/

Line 3100: , po_headers_all pha --Added by Kevin Cheng

3096: B.rounding_factor rnd_factor,
3097: B.adhoc_flag adhoc_flag
3098: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3099: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3100: , po_headers_all pha --Added by Kevin Cheng
3101: WHERE Po_Line_Id = p_po_line_id
3102: --AND nvl(line_location_id,-999) = p_line_location_id
3103: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3104: AND A.Tax_Id = B.Tax_Id

Line 5150: from po_headers_all

5146:
5147:
5148: cursor fetch_vendor_id_cur IS
5149: select vendor_id,vendor_site_id
5150: from po_headers_all
5151: where po_header_id=p_po_hdr_id;
5152:
5153: --Added by kunkumar End
5154:

Line 5165: po_lines_all pla, po_headers_all pha

5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5163: SELECT jpll.Line_Location_Id
5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
5165: po_lines_all pla, po_headers_all pha
5166: WHERE pha.po_header_id = pla.po_header_id
5167: AND jpll.line_location_id = plla.line_location_id
5168: AND pha.po_header_id = plla.po_header_id
5169: AND pla.po_line_id = plla.po_line_id

Line 5178: FROM po_lines_all pla, po_headers_all pha

5174:
5175: -- Cursor definition for picking po_line_id from po_lines_all
5176: CURSOR fetch_line_id_cur IS
5177: SELECT pla.Po_Line_Id
5178: FROM po_lines_all pla, po_headers_all pha
5179: WHERE pha.Po_Header_Id = p_from_hdr_id
5180: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
5181: AND pha.po_header_id =pla.po_header_id;
5182:

Line 5549: FROM po_headers_all

5545: --Added by Ravi for vat assessable vlue
5546: CURSOR cur_vendor
5547: IS
5548: SELECT vendor_id,vendor_site_id
5549: FROM po_headers_all
5550: WHERE po_header_id = p_po_hdr_id;
5551:
5552: CURSOR cur_item
5553: IS

Line 5921: FROM Po_Headers_All

5917: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
5918:
5919: CURSOR Get_Assessable_Val_Cur IS
5920: SELECT Vendor_Id, Vendor_Site_Id, Currency_Code
5921: FROM Po_Headers_All
5922: WHERE Po_Header_Id = v_po_hdr_id;
5923:
5924: CURSOR Get_Item_Id_Cur IS
5925: SELECT Item_Id

Line 5956: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;

5952: lv_last_upd_by NUMBER;
5953: lv_last_upd_login NUMBER;
5954: lv_price NUMBER;
5955: lv_org_id NUMBER ;
5956: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;
5957: lv_conv_rate number ;
5958: lv_type_lookup_code VARCHAR2(30);
5959: lv_quot_class_code VARCHAR2(30);
5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;

Line 5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;

5956: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;
5957: lv_conv_rate number ;
5958: lv_type_lookup_code VARCHAR2(30);
5959: lv_quot_class_code VARCHAR2(30);
5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
5961: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
5962:
5963: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
5964: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;

Line 5961: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;

5957: lv_conv_rate number ;
5958: lv_type_lookup_code VARCHAR2(30);
5959: lv_quot_class_code VARCHAR2(30);
5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
5961: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
5962:
5963: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
5964: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
5965: lv_func_curr VARCHAR2(15);

Line 5963: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;

5959: lv_quot_class_code VARCHAR2(30);
5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
5961: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
5962:
5963: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
5964: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
5965: lv_func_curr VARCHAR2(15);
5966:
5967: flag1 VARCHAR2(10);

Line 5964: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;

5960: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
5961: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
5962:
5963: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
5964: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
5965: lv_func_curr VARCHAR2(15);
5966:
5967: flag1 VARCHAR2(10);
5968:

Line 5975: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS

5971: FROM JAI_CMN_VENDOR_SITES
5972: WHERE vendor_id = c_vendor_id
5973: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
5974:
5975: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS
5976: select vendor_id,vendor_site_id , currency_code , rate ,RATE_TYPE , RATE_DATE ,ship_to_location_id
5977: from po_headers_all
5978: where po_header_id=p_po_hdr_id;
5979:

Line 5977: from po_headers_all

5973: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
5974:
5975: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS
5976: select vendor_id,vendor_site_id , currency_code , rate ,RATE_TYPE , RATE_DATE ,ship_to_location_id
5977: from po_headers_all
5978: where po_header_id=p_po_hdr_id;
5979:
5980: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
5981: SELECT Price_Override ,Unit_Meas_Lookup_Code