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 302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,

298: /* Bug 5094130. Added by Lakshmi Gopalsami
299: Removed the PO_TAX_CUR cursor and added the record type
300: */
301: TYPE PO_TAX_CUR IS RECORD(
302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

299: Removed the PO_TAX_CUR cursor and added the record type
300: */
301: TYPE PO_TAX_CUR IS RECORD(
302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

300: */
301: TYPE PO_TAX_CUR IS RECORD(
302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
308: /* bug 5094130. Added by Lakshmi Gopalsami

Line 305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

301: TYPE PO_TAX_CUR IS RECORD(
302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
308: /* bug 5094130. Added by Lakshmi Gopalsami
309: * Included precedences 6 to 10

Line 306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

302: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
308: /* bug 5094130. Added by Lakshmi Gopalsami
309: * Included precedences 6 to 10
310: */

Line 307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

303: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
304: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
305: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
306: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
308: /* bug 5094130. Added by Lakshmi Gopalsami
309: * Included precedences 6 to 10
310: */
311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

307: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
308: /* bug 5094130. Added by Lakshmi Gopalsami
309: * Included precedences 6 to 10
310: */
311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

Line 312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

308: /* bug 5094130. Added by Lakshmi Gopalsami
309: * Included precedences 6 to 10
310: */
311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

Line 313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

309: * Included precedences 6 to 10
310: */
311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,

Line 314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

310: */
311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

Line 315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

311: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

Line 316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

312: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
313: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,

Line 318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

314: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,

Line 319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

315: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

Line 320: Uom_code JAI_PO_TAXES.UOM%TYPE,

316: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,

Line 321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

317: Tax_type_val NUMBER,
318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE

Line 322: Curr JAI_PO_TAXES.CURRENCY%TYPE,

318: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007

Line 339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,

335:
336: --Added by Kevin Cheng for Retroactive Price 2008/01/11
337: --=====================================================
338: TYPE PO_TAX_RETRO_CUR IS RECORD(
339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

336: --Added by Kevin Cheng for Retroactive Price 2008/01/11
337: --=====================================================
338: TYPE PO_TAX_RETRO_CUR IS RECORD(
339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

337: --=====================================================
338: TYPE PO_TAX_RETRO_CUR IS RECORD(
339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
345: /* bug 5094130. Added by Lakshmi Gopalsami

Line 342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

338: TYPE PO_TAX_RETRO_CUR IS RECORD(
339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
345: /* bug 5094130. Added by Lakshmi Gopalsami
346: * Included precedences 6 to 10

Line 343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

339: LNo JAI_PO_TAXES.TAX_LINE_NO%TYPE,
340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
345: /* bug 5094130. Added by Lakshmi Gopalsami
346: * Included precedences 6 to 10
347: */

Line 344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

340: P_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
341: P_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
342: P_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
343: P_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
345: /* bug 5094130. Added by Lakshmi Gopalsami
346: * Included precedences 6 to 10
347: */
348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

344: P_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
345: /* bug 5094130. Added by Lakshmi Gopalsami
346: * Included precedences 6 to 10
347: */
348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

Line 349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

345: /* bug 5094130. Added by Lakshmi Gopalsami
346: * Included precedences 6 to 10
347: */
348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

Line 350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

346: * Included precedences 6 to 10
347: */
348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,

Line 351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

347: */
348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

Line 352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,

348: P_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

Line 353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

349: P_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
350: P_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,

Line 355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

351: P_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,

Line 356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

352: P_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE,
353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

Line 357: Uom_code JAI_PO_TAXES.UOM%TYPE,

353: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,

Line 358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

354: Tax_type_val NUMBER,
355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,

Line 359: Curr JAI_PO_TAXES.CURRENCY%TYPE,

355: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,

Line 364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE

360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
365: );
366:
367:
368: -- START, Vijay Shankar for Bug# 3190782

Line 412: FROM JAI_PO_TAXES

408: AND A.uom_class = B.uom_class;
409:
410: CURSOR Fetch_Sum_Cur( linelocid IN NUMBER ) IS
411: SELECT SUM( NVL( Tax_Amount, 0 ) )
412: FROM JAI_PO_TAXES
413: WHERE Line_Location_Id = linelocid -- For Blanket Rel Line Loc Id is passed in place of header id.
414: AND Tax_Type <> jai_constants.tax_type_tds ; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
415:
416: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calculate_tax';

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

437:
438: 3 10-OCT-03 Vijay Shankar for Bug# 3190782, FileVersion: 616.2
439: Tax Calculation is not handled properly when P_TYPE='REQUISITION', which is made proper with this fix. Basically
440: assigning values to plsql tables is handled properly with common code by accessing JAI_PO_REQ_LINE_TAXES and
441: JAI_PO_TAXES through REF CURSOR. Code related to populating plsql tables during P_TYPE='REQUISITION'
442: is removed and aligned with PO code.
443:
444: 4. 12-OCT-05 Bug4210102. Added by LGOPALSA
445: Added CVD and Excise education Cess

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

569: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
570: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
571: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
572: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
573: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
574: WHERE Po_Line_Id = p_line_id
575: AND Line_Location_Id = p_line_loc_id
576: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
577: AND A.Tax_Id = B.Tax_Id

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

2027: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2028: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2029: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2030: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
2031: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
2032: , po_headers_all pha --Added by Kevin Cheng
2033: WHERE Po_Line_Id = p_line_id
2034: AND Line_Location_Id = p_line_loc_id
2035: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 2792: UPDATE JAI_PO_TAXES

2788: bsln_amt := p_price;
2789: END IF;
2790: IF p_type = 'RELEASE' THEN
2791:
2792: UPDATE JAI_PO_TAXES
2793: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2794: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2795: WHERE Line_Location_Id = p_header_id
2796: AND Po_Line_Id = p_line_id

Line 2818: UPDATE JAI_PO_TAXES

2814: END IF;
2815: END IF;
2816: --=====================================================
2817: ELSIF p_type = 'STANDARDPO' THEN
2818: UPDATE JAI_PO_TAXES
2819: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2820: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2821: WHERE Line_Location_Id = p_line_loc_id
2822: AND Po_Line_Id = p_line_id

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

3708: B.End_Date Valid_Date,
3709: B.rounding_factor rnd_factor,
3710: B.adhoc_flag adhoc_flag
3711: ,b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 17, 2007
3712: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3713: WHERE Po_Line_Id = p_po_line_id
3714: AND nvl(line_location_id,-999) = p_line_location_id /*uncommented for bug 9307152, commented line below*/
3715: --AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3716: AND A.Tax_Id = B.Tax_Id

Line 3730: FROM JAI_PO_TAXES

3726: AND a.uom_class = b.uom_class;
3727:
3728: CURSOR fetch_sum_cur( p_line_location_id IN NUMBER ) IS
3729: SELECT SUM( NVL( tax_amount, 0 ) )
3730: FROM JAI_PO_TAXES
3731: WHERE line_location_id = p_line_location_id -- For Blanket Rel Line Loc Id is passed in place of header id.
3732: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3733:
3734: CURSOR fetch_line_uom_code IS

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

3880: B.End_Date Valid_Date,
3881: B.rounding_factor rnd_factor,
3882: B.adhoc_flag adhoc_flag
3883: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3884: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3885: , po_headers_all pha --Added by Kevin Cheng
3886: WHERE Po_Line_Id = p_po_line_id
3887: --AND nvl(line_location_id,-999) = p_line_location_id
3888: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 6408: UPDATE JAI_PO_TAXES

6404: ', tax_target_tab -> '||tax_target_tab(i));
6405: END IF;
6406:
6407: --Bgowrava for Bug#5877782 Added standard Who columns
6408: UPDATE JAI_PO_TAXES
6409: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6410: tax_target_amount = nvl( tax_target_tab(i), 0 ),
6411: last_update_date = sysdate,
6412: last_updated_by = fnd_global.user_id,

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

6578: tax_category_id -- cbabu for EnhancementBug# 2427465
6579: FROM JAI_PO_LINE_LOCATIONS
6580: WHERE Line_Location_Id = v_ln_loc_id;
6581:
6582: -- Cursor definition for picking values from JAI_PO_TAXES
6583: -- using line_location_id as where clause
6584: CURSOR fetch_po_ln_loc_tax_cur IS
6585: SELECT line_location_id,
6586: tax_line_no,

Line 6616: FROM JAI_PO_TAXES

6612: last_update_date,
6613: last_updated_by,
6614: last_update_login,
6615: tax_category_id -- cbabu for EnhancementBug# 2427465
6616: FROM JAI_PO_TAXES
6617: WHERE Line_Location_Id = v_ln_loc_id;
6618:
6619: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
6620: -- using po_line_id as where clause

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

6628: AND po_header_id = p_from_hdr_id
6629: AND ( line_location_id IS NULL
6630: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
6631:
6632: -- Cursor definition for picking values from JAI_PO_TAXES
6633: -- using po_line_id as where clause
6634:
6635: CURSOR fetch_jain_line_tax_cur IS
6636: SELECT line_location_id,

Line 6667: FROM JAI_PO_TAXES

6663: last_update_date,
6664: last_updated_by,
6665: last_update_login,
6666: tax_category_id -- cbabu for EnhancementBug# 2427465
6667: FROM JAI_PO_TAXES
6668: WHERE Po_Line_Id = v_line_id
6669: AND po_header_id = p_from_hdr_id
6670: AND ( line_location_id IS NULL
6671: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465

Line 6762: INSERT INTO JAI_PO_TAXES (

6758:
6759:
6760: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6761:
6762: INSERT INTO JAI_PO_TAXES (
6763: line_location_id, tax_line_no, po_line_id, po_header_id,
6764: precedence_1, precedence_2, precedence_3, precedence_4,precedence_5,
6765: precedence_6, precedence_7, precedence_8, precedence_9,
6766: precedence_10, tax_id, currency, tax_rate, qty_rate,

Line 6812: INSERT INTO JAI_PO_TAXES (

6808:
6809: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6810:
6811: FOR rec in Fetch_Po_Ln_Loc_Tax_Cur LOOP
6812: INSERT INTO JAI_PO_TAXES (
6813: line_location_id, tax_line_no, po_line_id, po_header_id,
6814: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
6815: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
6816: tax_id, currency, tax_rate, qty_rate,

Line 6903: FROM JAI_PO_TAXES a

6899: a.precedence_10 p_10,
6900: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type,
6901: a.vendor_id, a.modvat_flag,
6902: tax_category_id -- cbabu for EnhancementBug# 2427465
6903: FROM JAI_PO_TAXES a
6904: /*condition modified for bug 7436368*/
6905: WHERE ((a.line_location_id IS NULL AND v_quot_line_loc_id=-999) OR (a.line_location_id = v_quot_line_loc_id))
6906: --a.line_location_id = v_quot_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
6907: --WHERE NVL( a.line_location_id, -999 ) = v_quot_line_loc_id

Line 7032: INSERT INTO JAI_PO_TAXES(

7028: v_tax_amount := 0;
7029: end if;
7030: --Ends here...
7031:
7032: INSERT INTO JAI_PO_TAXES(
7033: po_line_id,
7034: po_header_id,
7035: line_location_id,
7036: line_focus_id,

Line 7246: FROM JAI_PO_TAXES

7242: Precedence_6, Precedence_7, Precedence_8, Precedence_9,Precedence_10,
7243: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type,
7244: Vendor_Id, Modvat_Flag, Tax_Target_Amount,
7245: tax_category_id -- cbabu for EnhancementBug# 2427465
7246: FROM JAI_PO_TAXES
7247: WHERE --NVL( Line_Location_Id, -999 ) = llid
7248: line_location_id is null/*added the condition for bug#14632514*/
7249: AND Po_Line_Id = lineid
7250: ORDER BY Tax_Line_No;

Line 7331: FROM JAI_PO_TAXES

7327: WHERE Unit_Of_Measure = uom;
7328:
7329: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
7330: SELECT SUM( NVL( Tax_Amount, 0 ) )
7331: FROM JAI_PO_TAXES
7332: WHERE Line_Location_Id = llid
7333: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
7334:
7335: CURSOR Get_Assessable_Val_Cur IS

Line 7606: JAI_PO_TAXES

7602: --Incorporated by Nagaraj.s on 15/05/2002 for Bug#2373231
7603:
7604: BEGIN
7605: SELECT COUNT(1) INTO v_tax_count FROM
7606: JAI_PO_TAXES
7607: WHERE Line_Location_Id = Tax_Rec.Line_Location_Id AND
7608: TAX_ID = Tax_Rec.Tax_id;
7609: END;
7610:

Line 7616: INSERT INTO JAI_PO_TAXES(

7612:
7613:
7614: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
7615:
7616: INSERT INTO JAI_PO_TAXES(
7617: Line_Focus_Id,
7618: Line_Location_Id, Tax_Line_No,
7619: Po_Line_Id, Po_Header_Id,
7620: Precedence_1, Precedence_2, Precedence_3, Precedence_4,Precedence_5,

Line 7868: JAI_PO_TAXES

7864: -- v_tax_amt := Tax_Rec.Tax_Amount * v_qty / p_qty;
7865: --Incorporated by Nagaraj.s on 15/05/2002 for Bug#2373231
7866: BEGIN
7867: SELECT COUNT(1) INTO v_tax_count FROM
7868: JAI_PO_TAXES
7869: WHERE Line_Location_Id = p_line_Loc_Id AND
7870: TAX_ID = Tax_Rec.Tax_id;
7871: END;
7872:

Line 7875: INSERT INTO JAI_PO_TAXES(

7871: END;
7872:
7873: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
7874: IF v_tax_count =0 THEN
7875: INSERT INTO JAI_PO_TAXES(
7876: line_focus_id, line_location_id, tax_line_no,
7877: po_line_id, po_header_id,
7878: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
7879: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10 ,

Line 8189: FROM JAI_PO_TAXES

8185: Precedence_6, Precedence_7, Precedence_8, Precedence_9, PRecedence_10,
8186: Tax_Id, Currency, Tax_Rate, Qty_Rate,
8187: UOM, Tax_Amount, Tax_Type, Modvat_Flag, Vendor_Id,
8188: tax_category_id -- cbabu for EnhancementBug# 2427465
8189: FROM JAI_PO_TAXES
8190: WHERE Po_Line_Id = v_frm_po_line_id
8191: AND Line_Location_Id IS NULL
8192: ORDER BY Tax_Line_No;
8193:

Line 8203: FROM JAI_PO_TAXES

8199: Precedence_6,Precedence_7, Precedence_8, Precedence_9, PRecedence_10,
8200: Tax_Id, Currency, Tax_Rate, Qty_Rate,
8201: UOM, Tax_Amount, Tax_Type, Modvat_Flag, Vendor_Id,
8202: tax_category_id -- cbabu for EnhancementBug# 2427465
8203: FROM JAI_PO_TAXES
8204: WHERE Po_Line_Id = v_frm_po_line_id
8205: AND Line_Location_Id = v_frm_line_loc_id
8206: ORDER BY Tax_Line_No;
8207:

Line 8215: FROM JAI_PO_TAXES

8211: WHERE Tax_Id = taxid;
8212:
8213: CURSOR Fetch_Sum_Cur( Lfid IN NUMBER ) IS
8214: SELECT SUM( NVL( Tax_Amount, 0 ) )
8215: FROM JAI_PO_TAXES
8216: WHERE Line_Focus_Id = lfid;
8217:
8218: v_uom_code VARCHAR2(4); -- cbabu for Bug# 2695844
8219:

Line 8682: FROM JAI_PO_TAXES

8678: AND Line_Location_Id = v_line_loc_id;
8679:
8680: CURSOR Fetch_Sum_Cur IS
8681: SELECT SUM( NVL( Tax_Amount, 0 ) )
8682: FROM JAI_PO_TAXES
8683: WHERE Line_Location_Id = v_line_loc_id
8684: AND Tax_Type <> jai_constants.tax_type_tds; -- 'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
8685:
8686: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.ja_in_po_case2';

Line 8755: DELETE Jai_Po_Taxes

8751: END IF;--added by peng.zheng for bug 10043656, ends
8752: ELSE
8753: */
8754:
8755: DELETE Jai_Po_Taxes
8756: WHERE Po_Line_Id = v_po_line_id
8757: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
8758:
8759: UPDATE Jai_Po_Line_Locations

Line 8927: UPDATE JAI_PO_TAXES

8923: IF ( v_quot_class_code = 'CATALOG' ) OR ( v_type_lookup_code = 'BLANKET' ) THEN
8924:
8925: /* Added 'AND' condition - Bug 6012541 */
8926: IF v_line_loc_id IS NOT NULL AND v_line_loc_id <> 0 THEN
8927: UPDATE JAI_PO_TAXES
8928: SET Tax_Amount = NULL,
8929: Tax_Target_Amount = NULL,
8930: Last_Updated_By = v_last_upd_by,
8931: Last_Update_Date = v_last_upd_dt,

Line 8947: UPDATE JAI_PO_TAXES

8943: AND Line_Location_id = v_line_loc_id;
8944:
8945: ELSE
8946:
8947: UPDATE JAI_PO_TAXES
8948: SET Tax_Amount = NULL,
8949: Tax_Target_Amount = NULL,
8950: Last_Updated_By = v_last_upd_by,
8951: Last_Update_Date = v_last_upd_dt,

Line 9066: INSERT INTO JAI_PO_TAXES(

9062: END IF;
9063:
9064: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
9065:
9066: INSERT INTO JAI_PO_TAXES(
9067: Line_Focus_Id, Line_Location_Id, Tax_Line_No,
9068: Po_Line_Id, Po_Header_Id,
9069: Precedence_1, Precedence_2, Precedence_3, Precedence_4, Precedence_5,
9070: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,