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.

[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THGRP_AUDITS

Line 1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;

1757: --------------------------------------------------------------------
1758: --Added by Zhiwei Hou for Bug#13359892 on 20111224 end
1759: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1760:
1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

Line 1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

1758: --Added by Zhiwei Hou for Bug#13359892 on 20111224 end
1759: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1760:
1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

1759: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1760:
1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

1760:
1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

1761: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:

Line 1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

1762: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

Line 1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

1763: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

Line 1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

1764: ln_old_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1765: ln_old_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

Line 1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;

1766: ln_old_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

Line 1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

1767: ln_old_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

Line 1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;

1768: ln_old_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

Line 1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;

1769:
1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1777: ln_effective_threshold_amount number;

Line 1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;

1770: ln_new_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1777: ln_effective_threshold_amount number;
1778: ln_effective_tax_paid number;

Line 1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;

1771: ln_new_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;
1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1777: ln_effective_threshold_amount number;
1778: ln_effective_tax_paid number;
1779:

Line 1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;

1772: ln_new_invoice_apply_amount jai_ap_tds_thgrp_audits.old_invoice_apply_amount%type;
1773: ln_new_invoice_unapply_amount jai_ap_tds_thgrp_audits.old_invoice_unapply_amount%type;
1774: ln_new_tax_paid jai_ap_tds_thgrp_audits.old_tax_paid%type;
1775: ln_new_thhold_change_tax_paid jai_ap_tds_thgrp_audits.old_thhold_change_tax_paid%type;
1776: ln_new_threshold_slab_id jai_ap_tds_thgrp_audits.old_threshold_slab_id%type;
1777: ln_effective_threshold_amount number;
1778: ln_effective_tax_paid number;
1779:
1780: /*Bug 5751783. Added following variables.*/

Line 1781: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;

1777: ln_effective_threshold_amount number;
1778: ln_effective_tax_paid number;
1779:
1780: /*Bug 5751783. Added following variables.*/
1781: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
1782: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
1783: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
1784:
1785: -- bug 5722028. Added by csahoo

Line 1782: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;

1778: ln_effective_tax_paid number;
1779:
1780: /*Bug 5751783. Added following variables.*/
1781: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
1782: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
1783: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
1784:
1785: -- bug 5722028. Added by csahoo
1786: ln_tmp_tds_amt number;

Line 1783: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;

1779:
1780: /*Bug 5751783. Added following variables.*/
1781: ln_calc_old_tax_paid jai_ap_tds_thgrp_audits.calc_old_tax_paid%type;
1782: ln_calc_trx_tax_paid jai_ap_tds_thgrp_audits.calc_trx_tax_paid%type;
1783: ln_calc_new_tax_paid jai_ap_tds_thgrp_audits.calc_new_tax_paid%type;
1784:
1785: -- bug 5722028. Added by csahoo
1786: ln_tmp_tds_amt number;
1787: ln_tmp_tds_change number;

Line 2006: insert into jai_ap_tds_thgrp_audits

2002: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
2003:
2004: /* Insert into the audite table */
2005: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2006: insert into jai_ap_tds_thgrp_audits
2007: (
2008: threshold_grp_audit_id ,
2009: threshold_grp_id ,
2010: old_invoice_amount ,

Line 2048: jai_ap_tds_thgrp_audits_s.nextval ,

2044: calc_new_tax_paid
2045: )
2046: values
2047: (
2048: jai_ap_tds_thgrp_audits_s.nextval ,
2049: ln_threshold_grp_id ,
2050: ln_old_invoice_amount ,
2051: ln_old_invoice_cancel_amount ,
2052: ln_old_invoice_apply_amount ,