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 JAI_PO_TAXES

Line 258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,

254: /* Bug 5094130. Added by Lakshmi Gopalsami
255: Removed the PO_TAX_CUR cursor and added the record type
256: */
257: TYPE PO_TAX_CUR IS RECORD(
258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

255: Removed the PO_TAX_CUR cursor and added the record type
256: */
257: TYPE PO_TAX_CUR IS RECORD(
258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

256: */
257: TYPE PO_TAX_CUR IS RECORD(
258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
264: /* bug 5094130. Added by Lakshmi Gopalsami

Line 261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

257: TYPE PO_TAX_CUR IS RECORD(
258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
264: /* bug 5094130. Added by Lakshmi Gopalsami
265: * Included precedences 6 to 10

Line 262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

258: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
264: /* bug 5094130. Added by Lakshmi Gopalsami
265: * Included precedences 6 to 10
266: */

Line 263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

259: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
260: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
261: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
262: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
264: /* bug 5094130. Added by Lakshmi Gopalsami
265: * Included precedences 6 to 10
266: */
267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

263: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
264: /* bug 5094130. Added by Lakshmi Gopalsami
265: * Included precedences 6 to 10
266: */
267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

Line 268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

264: /* bug 5094130. Added by Lakshmi Gopalsami
265: * Included precedences 6 to 10
266: */
267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

Line 269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

265: * Included precedences 6 to 10
266: */
267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,

Line 270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

266: */
267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

Line 271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

267: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

Line 272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

268: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
269: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,

Line 274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

270: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,

Line 275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

271: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

Line 276: Uom_code JAI_PO_TAXES.UOM%TYPE,

272: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,

Line 277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

273: Tax_type_val NUMBER,
274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE

Line 278: Curr JAI_PO_TAXES.CURRENCY%TYPE,

274: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
275: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
276: Uom_code JAI_PO_TAXES.UOM%TYPE,
277: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
278: Curr JAI_PO_TAXES.CURRENCY%TYPE,
279: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
280: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
281: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
282: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007

Line 295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,

291:
292: --Added by Kevin Cheng for Retroactive Price 2008/01/11
293: --=====================================================
294: TYPE PO_TAX_RETRO_CUR IS RECORD(
295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

292: --Added by Kevin Cheng for Retroactive Price 2008/01/11
293: --=====================================================
294: TYPE PO_TAX_RETRO_CUR IS RECORD(
295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

293: --=====================================================
294: TYPE PO_TAX_RETRO_CUR IS RECORD(
295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
301: /* bug 5094130. Added by Lakshmi Gopalsami

Line 298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

294: TYPE PO_TAX_RETRO_CUR IS RECORD(
295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
301: /* bug 5094130. Added by Lakshmi Gopalsami
302: * Included precedences 6 to 10

Line 299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

295: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
301: /* bug 5094130. Added by Lakshmi Gopalsami
302: * Included precedences 6 to 10
303: */

Line 300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

296: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
297: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
298: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
299: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
301: /* bug 5094130. Added by Lakshmi Gopalsami
302: * Included precedences 6 to 10
303: */
304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

300: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
301: /* bug 5094130. Added by Lakshmi Gopalsami
302: * Included precedences 6 to 10
303: */
304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

Line 305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

301: /* bug 5094130. Added by Lakshmi Gopalsami
302: * Included precedences 6 to 10
303: */
304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

Line 306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

302: * Included precedences 6 to 10
303: */
304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,

Line 307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

303: */
304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

Line 308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

304: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

Line 309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

305: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
306: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,

Line 311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

307: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
315: Curr JAI_PO_TAXES.CURRENCY%TYPE,

Line 312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

308: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
315: Curr JAI_PO_TAXES.CURRENCY%TYPE,
316: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

Line 313: Uom_code JAI_PO_TAXES.UOM%TYPE,

309: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%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,

Line 314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

310: Tax_type_val NUMBER,
311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%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,

Line 315: Curr JAI_PO_TAXES.CURRENCY%TYPE,

311: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
312: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
313: Uom_code JAI_PO_TAXES.UOM%TYPE,
314: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%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,

Line 320: tax_vendor_id JAI_PO_TAXES.Vendor_Id%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:
324: -- START, Vijay Shankar for Bug# 3190782

Line 362: FROM JAI_PO_TAXES

358: AND A.uom_class = B.uom_class;
359:
360: CURSOR Fetch_Sum_Cur( linelocid IN NUMBER ) IS
361: SELECT SUM( NVL( Tax_Amount, 0 ) )
362: FROM JAI_PO_TAXES
363: WHERE Line_Location_Id = linelocid -- For Blanket Rel Line Loc Id is passed in place of header id.
364: AND Tax_Type <> jai_constants.tax_type_tds ; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
365:
366: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calculate_tax';

Line 391: JAI_PO_TAXES through REF CURSOR. Code related to populating plsql tables during P_TYPE='REQUISITION'

387:
388: 3 10-OCT-03 Vijay Shankar for Bug# 3190782, FileVersion: 616.2
389: Tax Calculation is not handled properly when P_TYPE='REQUISITION', which is made proper with this fix. Basically
390: assigning values to plsql tables is handled properly with common code by accessing JAI_PO_REQ_LINE_TAXES and
391: JAI_PO_TAXES through REF CURSOR. Code related to populating plsql tables during P_TYPE='REQUISITION'
392: is removed and aligned with PO code.
393:
394: 4. 12-OCT-05 Bug4210102. Added by LGOPALSA
395: Added CVD and Excise education Cess

Line 501: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa

497: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
498: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
499: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
500: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
501: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
502: WHERE Po_Line_Id = p_line_id
503: AND Line_Location_Id = p_line_loc_id
504: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
505: AND A.Tax_Id = B.Tax_Id

Line 1352: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa

1348: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
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*/

Line 2071: UPDATE JAI_PO_TAXES

2067: bsln_amt := p_price;
2068: END IF;
2069: IF p_type = 'RELEASE' THEN
2070:
2071: UPDATE JAI_PO_TAXES
2072: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2073: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2074: WHERE Line_Location_Id = p_header_id
2075: AND Po_Line_Id = p_line_id

Line 2097: UPDATE JAI_PO_TAXES

2093: END IF;
2094: END IF;
2095: --=====================================================
2096: ELSIF p_type = 'STANDARDPO' THEN
2097: UPDATE JAI_PO_TAXES
2098: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2099: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2100: WHERE Line_Location_Id = p_line_loc_id
2101: AND Po_Line_Id = p_line_id

Line 2940: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa

2936: B.End_Date Valid_Date,
2937: B.rounding_factor rnd_factor,
2938: B.adhoc_flag adhoc_flag
2939: ,b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 17, 2007
2940: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
2941: WHERE Po_Line_Id = p_po_line_id
2942: --AND nvl(line_location_id,-999) = p_line_location_id
2943: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2944: AND A.Tax_Id = B.Tax_Id

Line 2958: FROM JAI_PO_TAXES

2954: AND a.uom_class = b.uom_class;
2955:
2956: CURSOR fetch_sum_cur( p_line_location_id IN NUMBER ) IS
2957: SELECT SUM( NVL( tax_amount, 0 ) )
2958: FROM JAI_PO_TAXES
2959: WHERE line_location_id = p_line_location_id -- For Blanket Rel Line Loc Id is passed in place of header id.
2960: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2961:
2962: CURSOR fetch_line_uom_code IS

Line 3099: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa

3095: B.End_Date Valid_Date,
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*/

Line 5019: UPDATE JAI_PO_TAXES

5015: ', tax_target_tab -> '||tax_target_tab(i));
5016: END IF;
5017:
5018: --Bgowrava for Bug#5877782 Added standard Who columns
5019: UPDATE JAI_PO_TAXES
5020: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5021: tax_target_amount = nvl( tax_target_tab(i), 0 ),
5022: last_update_date = sysdate,
5023: last_updated_by = fnd_global.user_id,

Line 5193: -- Cursor definition for picking values from JAI_PO_TAXES

5189: tax_category_id -- cbabu for EnhancementBug# 2427465
5190: FROM JAI_PO_LINE_LOCATIONS
5191: WHERE Line_Location_Id = v_ln_loc_id;
5192:
5193: -- Cursor definition for picking values from JAI_PO_TAXES
5194: -- using line_location_id as where clause
5195: CURSOR fetch_po_ln_loc_tax_cur IS
5196: SELECT line_location_id,
5197: tax_line_no,

Line 5227: FROM JAI_PO_TAXES

5223: last_update_date,
5224: last_updated_by,
5225: last_update_login,
5226: tax_category_id -- cbabu for EnhancementBug# 2427465
5227: FROM JAI_PO_TAXES
5228: WHERE Line_Location_Id = v_ln_loc_id;
5229:
5230: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
5231: -- using po_line_id as where clause

Line 5243: -- Cursor definition for picking values from JAI_PO_TAXES

5239: AND po_header_id = p_from_hdr_id
5240: AND ( line_location_id IS NULL
5241: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
5242:
5243: -- Cursor definition for picking values from JAI_PO_TAXES
5244: -- using po_line_id as where clause
5245:
5246: CURSOR fetch_jain_line_tax_cur IS
5247: SELECT line_location_id,

Line 5278: FROM JAI_PO_TAXES

5274: last_update_date,
5275: last_updated_by,
5276: last_update_login,
5277: tax_category_id -- cbabu for EnhancementBug# 2427465
5278: FROM JAI_PO_TAXES
5279: WHERE Po_Line_Id = v_line_id
5280: AND po_header_id = p_from_hdr_id
5281: AND ( line_location_id IS NULL
5282: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465

Line 5373: INSERT INTO JAI_PO_TAXES (

5369:
5370:
5371: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
5372:
5373: INSERT INTO JAI_PO_TAXES (
5374: line_location_id, tax_line_no, po_line_id, po_header_id,
5375: precedence_1, precedence_2, precedence_3, precedence_4,precedence_5,
5376: precedence_6, precedence_7, precedence_8, precedence_9,
5377: precedence_10, tax_id, currency, tax_rate, qty_rate,

Line 5423: INSERT INTO JAI_PO_TAXES (

5419:
5420: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
5421:
5422: FOR rec in Fetch_Po_Ln_Loc_Tax_Cur LOOP
5423: INSERT INTO JAI_PO_TAXES (
5424: line_location_id, tax_line_no, po_line_id, po_header_id,
5425: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
5426: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
5427: tax_id, currency, tax_rate, qty_rate,

Line 5511: FROM JAI_PO_TAXES a

5507: a.precedence_10 p_10,
5508: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
5509: a.vendor_id, a.modvat_flag,
5510: tax_category_id -- cbabu for EnhancementBug# 2427465
5511: FROM JAI_PO_TAXES a
5512: /*condition modified for bug 7436368*/
5513: WHERE ((a.line_location_id IS NULL AND v_quot_line_loc_id=-999) OR (a.line_location_id = v_quot_line_loc_id))
5514: --a.line_location_id = v_quot_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
5515: --WHERE NVL( a.line_location_id, -999 ) = v_quot_line_loc_id

Line 5638: INSERT INTO JAI_PO_TAXES(

5634: v_tax_amount := 0;
5635: end if;
5636: --Ends here...
5637:
5638: INSERT INTO JAI_PO_TAXES(
5639: po_line_id,
5640: po_header_id,
5641: line_location_id,
5642: line_focus_id,

Line 5831: FROM JAI_PO_TAXES

5827: Precedence_6, Precedence_7, Precedence_8, Precedence_9,Precedence_10,
5828: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type,
5829: Vendor_Id, Modvat_Flag, Tax_Target_Amount,
5830: tax_category_id -- cbabu for EnhancementBug# 2427465
5831: FROM JAI_PO_TAXES
5832: WHERE NVL( Line_Location_Id, -999 ) = llid /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980* -- NVL condition is added by SAcsethi for bug 6134628 */
5833: AND Po_Line_Id = lineid
5834: ORDER BY Tax_Line_No;
5835:

Line 5915: FROM JAI_PO_TAXES

5911: WHERE Unit_Of_Measure = uom;
5912:
5913: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
5914: SELECT SUM( NVL( Tax_Amount, 0 ) )
5915: FROM JAI_PO_TAXES
5916: WHERE Line_Location_Id = llid
5917: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
5918:
5919: CURSOR Get_Assessable_Val_Cur IS

Line 6184: JAI_PO_TAXES

6180: --Incorporated by Nagaraj.s on 15/05/2002 for Bug#2373231
6181:
6182: BEGIN
6183: SELECT COUNT(1) INTO v_tax_count FROM
6184: JAI_PO_TAXES
6185: WHERE Line_Location_Id = Tax_Rec.Line_Location_Id AND
6186: TAX_ID = Tax_Rec.Tax_id;
6187: END;
6188:

Line 6194: INSERT INTO JAI_PO_TAXES(

6190:
6191:
6192: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6193:
6194: INSERT INTO JAI_PO_TAXES(
6195: Line_Focus_Id,
6196: Line_Location_Id, Tax_Line_No,
6197: Po_Line_Id, Po_Header_Id,
6198: Precedence_1, Precedence_2, Precedence_3, Precedence_4,Precedence_5,

Line 6421: JAI_PO_TAXES

6417: -- v_tax_amt := Tax_Rec.Tax_Amount * v_qty / p_qty;
6418: --Incorporated by Nagaraj.s on 15/05/2002 for Bug#2373231
6419: BEGIN
6420: SELECT COUNT(1) INTO v_tax_count FROM
6421: JAI_PO_TAXES
6422: WHERE Line_Location_Id = p_line_Loc_Id AND
6423: TAX_ID = Tax_Rec.Tax_id;
6424: END;
6425:

Line 6428: INSERT INTO JAI_PO_TAXES(

6424: END;
6425:
6426: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6427: IF v_tax_count =0 THEN
6428: INSERT INTO JAI_PO_TAXES(
6429: line_focus_id, line_location_id, tax_line_no,
6430: po_line_id, po_header_id,
6431: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
6432: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10 ,

Line 6706: FROM JAI_PO_TAXES

6702: Precedence_6, Precedence_7, Precedence_8, Precedence_9, PRecedence_10,
6703: Tax_Id, Currency, Tax_Rate, Qty_Rate,
6704: UOM, Tax_Amount, Tax_Type, Modvat_Flag, Vendor_Id,
6705: tax_category_id -- cbabu for EnhancementBug# 2427465
6706: FROM JAI_PO_TAXES
6707: WHERE Po_Line_Id = v_frm_po_line_id
6708: AND Line_Location_Id IS NULL
6709: ORDER BY Tax_Line_No;
6710:

Line 6720: FROM JAI_PO_TAXES

6716: Precedence_6,Precedence_7, Precedence_8, Precedence_9, PRecedence_10,
6717: Tax_Id, Currency, Tax_Rate, Qty_Rate,
6718: UOM, Tax_Amount, Tax_Type, Modvat_Flag, Vendor_Id,
6719: tax_category_id -- cbabu for EnhancementBug# 2427465
6720: FROM JAI_PO_TAXES
6721: WHERE Po_Line_Id = v_frm_po_line_id
6722: AND Line_Location_Id = v_frm_line_loc_id
6723: ORDER BY Tax_Line_No;
6724:

Line 6732: FROM JAI_PO_TAXES

6728: WHERE Tax_Id = taxid;
6729:
6730: CURSOR Fetch_Sum_Cur( Lfid IN NUMBER ) IS
6731: SELECT SUM( NVL( Tax_Amount, 0 ) )
6732: FROM JAI_PO_TAXES
6733: WHERE Line_Focus_Id = lfid;
6734:
6735: v_uom_code VARCHAR2(4); -- cbabu for Bug# 2695844
6736:

Line 7162: FROM JAI_PO_TAXES

7158: AND Line_Location_Id = v_line_loc_id;
7159:
7160: CURSOR Fetch_Sum_Cur IS
7161: SELECT SUM( NVL( Tax_Amount, 0 ) )
7162: FROM JAI_PO_TAXES
7163: WHERE Line_Location_Id = v_line_loc_id
7164: AND Tax_Type <> jai_constants.tax_type_tds; -- 'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
7165:
7166: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.ja_in_po_case2';

Line 7205: DELETE Jai_Po_Taxes

7201:
7202: END IF;
7203: ELSE
7204:
7205: DELETE Jai_Po_Taxes
7206: WHERE Po_Line_Id = v_po_line_id
7207: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
7208:
7209: UPDATE Jai_Po_Line_Locations

Line 7346: UPDATE JAI_PO_TAXES

7342: IF ( v_quot_class_code = 'CATALOG' ) OR ( v_type_lookup_code = 'BLANKET' ) THEN
7343:
7344: /* Added 'AND' condition - Bug 6012541 */
7345: IF v_line_loc_id IS NOT NULL AND v_line_loc_id <> 0 THEN
7346: UPDATE JAI_PO_TAXES
7347: SET Tax_Amount = NULL,
7348: Tax_Target_Amount = NULL,
7349: Last_Updated_By = v_last_upd_by,
7350: Last_Update_Date = v_last_upd_dt,

Line 7366: UPDATE JAI_PO_TAXES

7362: AND Line_Location_id = v_line_loc_id;
7363:
7364: ELSE
7365:
7366: UPDATE JAI_PO_TAXES
7367: SET Tax_Amount = NULL,
7368: Tax_Target_Amount = NULL,
7369: Last_Updated_By = v_last_upd_by,
7370: Last_Update_Date = v_last_upd_dt,

Line 7485: INSERT INTO JAI_PO_TAXES(

7481: END IF;
7482:
7483: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
7484:
7485: INSERT INTO JAI_PO_TAXES(
7486: Line_Focus_Id, Line_Location_Id, Tax_Line_No,
7487: Po_Line_Id, Po_Header_Id,
7488: Precedence_1, Precedence_2, Precedence_3, Precedence_4, Precedence_5,
7489: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,