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_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 1712: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

1708: )
1709: is
1710:
1711:
1712: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1713: select total_invoice_amount ,
1714: total_invoice_cancel_amount ,
1715: total_invoice_apply_amount ,
1716: total_invoice_unapply_amount ,

Line 1721: from jai_ap_tds_thhold_grps

1717: total_tax_paid ,
1718: total_thhold_change_tax_paid ,
1719: current_threshold_slab_id ,
1720: total_calc_tax_paid -- Bug 5751783
1721: from jai_ap_tds_thhold_grps
1722: where threshold_grp_id = p_threshold_grp_id;
1723:
1724: cursor c_get_threshold_grp_id
1725: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,

Line 1728: from jai_ap_tds_thhold_grps

1724: cursor c_get_threshold_grp_id
1725: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,
1726: p_section_type varchar2, p_section_code varchar2, p_fin_year number) is
1727: select threshold_grp_id
1728: from jai_ap_tds_thhold_grps
1729: where vendor_id = p_vendor_id and
1730: org_tan_num = p_org_tan_num and
1731: vendor_pan_num = p_vendor_pan_num and
1732: section_type = p_section_type and

Line 1742: from jai_ap_tds_thhold_grps

1738: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,
1739: p_section_type varchar2, p_section_code varchar2, p_fin_year number,
1740: p_threshold_hdr_id number) is
1741: select threshold_grp_id
1742: from jai_ap_tds_thhold_grps
1743: where vendor_id = p_vendor_id and
1744: org_tan_num = p_org_tan_num and
1745: vendor_pan_num = p_vendor_pan_num and
1746: section_type = p_section_type and

Line 1759: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

1755: )
1756: );
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;

Line 1866: insert into jai_ap_tds_thhold_grps

1862: if nvl(ln_threshold_grp_id, 0) = 0 then
1863:
1864: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1865:
1866: insert into jai_ap_tds_thhold_grps
1867: (
1868: threshold_grp_id ,
1869: threshold_hdr_id ,
1870: vendor_id ,

Line 1884: jai_ap_tds_thhold_grps_s.nextval ,

1880: last_update_login
1881: )
1882: values
1883: (
1884: jai_ap_tds_thhold_grps_s.nextval ,
1885: p_threshold_hdr_id ,
1886: p_vendor_id ,
1887: p_org_tan_num ,
1888: p_vendor_pan_num ,

Line 1914: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

1910:
1911: /* Get the old value of teh threshold group */
1912: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1913:
1914: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1915: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1916: close c_jai_ap_tds_thhold_grps;
1917:
1918:

Line 1915: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

1911: /* Get the old value of teh threshold group */
1912: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1913:
1914: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1915: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1916: close c_jai_ap_tds_thhold_grps;
1917:
1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 1916: close c_jai_ap_tds_thhold_grps;

1912: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1913:
1914: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1915: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1916: close c_jai_ap_tds_thhold_grps;
1917:
1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

1915: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1916: close c_jai_ap_tds_thhold_grps;
1917:
1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

1916: close c_jai_ap_tds_thhold_grps;
1917:
1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

1917:
1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

1918:
1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
1926:

Line 1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

1919: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
1926:
1927: /*Bug 5751783*/

Line 1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

1920: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
1926:
1927: /*Bug 5751783*/
1928: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

Line 1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

1921: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1922: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1923: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
1926:
1927: /*Bug 5751783*/
1928: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
1929:

Line 1928: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

1924: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1925: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
1926:
1927: /*Bug 5751783*/
1928: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
1929:
1930: /* Check that threshold should not become negative */
1931: ln_effective_threshold_amount :=
1932: ( nvl(ln_old_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0) ) -

Line 1971: update jai_ap_tds_thhold_grps

1967:
1968: -- End if ;
1969:
1970: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1971: update jai_ap_tds_thhold_grps
1972: set
1973: total_invoice_amount = nvl(total_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0),
1974: total_invoice_cancel_amount = nvl(total_invoice_cancel_amount, 0) + nvl(p_trx_invoice_cancel_amount, 0),
1975: total_invoice_apply_amount = nvl(total_invoice_apply_amount, 0) + nvl(p_trx_invoice_apply_amount, 0),

Line 1988: r_jai_ap_tds_thhold_grps := null;

1984:
1985: where threshold_grp_id = ln_threshold_grp_id;
1986:
1987: /* Get the new value */
1988: r_jai_ap_tds_thhold_grps := null;
1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:

Line 1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

1985: where threshold_grp_id = ln_threshold_grp_id;
1986:
1987: /* Get the new value */
1988: r_jai_ap_tds_thhold_grps := null;
1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

1986:
1987: /* Get the new value */
1988: r_jai_ap_tds_thhold_grps := null;
1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 1991: close c_jai_ap_tds_thhold_grps;

1987: /* Get the new value */
1988: r_jai_ap_tds_thhold_grps := null;
1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

Line 1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

1989: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

1990: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

1991: close c_jai_ap_tds_thhold_grps;
1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

1992:
1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2000:

Line 1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

1993: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2000:
2001: /*Bug 5751783*/

Line 1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

1994: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2000:
2001: /*Bug 5751783*/
2002: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

Line 1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

1995: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
1996: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
1997: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2000:
2001: /*Bug 5751783*/
2002: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
2003:

Line 2002: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

1998: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
1999: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2000:
2001: /*Bug 5751783*/
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

Line 2480: from jai_ap_tds_thhold_grps

2476: p_fin_year number,
2477: p_section_type jai_ap_tds_inv_taxes.section_type%type)
2478: IS --rchandan for bug#4428980
2479: select threshold_grp_id
2480: from jai_ap_tds_thhold_grps
2481: where vendor_id = p_vendor_id
2482: and section_type = p_section_type --rchandan for bug#4428980
2483: and section_code = p_tds_section_code
2484: and org_tan_num = p_tan_no

Line 2488: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

2484: and org_tan_num = p_tan_no
2485: and vendor_pan_num = p_pan_no
2486: and fin_year = p_fin_year;
2487:
2488: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
2489: select (
2490: nvl(total_invoice_amount, 0) -
2491: nvl(total_invoice_cancel_amount, 0) -
2492: nvl(total_invoice_apply_amount, 0) +

Line 2501: from jai_ap_tds_thhold_grps

2497: total_thhold_change_tax_paid,
2498: current_threshold_slab_id,
2499: /*Bug 5751783. Selected non-rounded value for calculation*/
2500: total_calc_tax_paid
2501: from jai_ap_tds_thhold_grps
2502: where threshold_grp_id = p_threshold_grp_id;
2503:
2504:
2505: cursor c_jai_ap_tds_thhold_slabs

Line 2752: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

2748: -------------------------------------------------------------------------------
2749: --Addec by Jia for FP Bug#7431371, End
2750:
2751: ln_prepayment_app_amt number :=0; --xiao for Bug#6596019
2752: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2753: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
2754: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
2755:
2756: ln_count number:= 0;

Line 3030: from jai_ap_tds_thhold_grps

3026: p_thhold_hdr_id number
3027: )
3028: IS
3029: select threshold_grp_id
3030: from jai_ap_tds_thhold_grps
3031: where vendor_id = p_vendor_id
3032: and section_type = p_section_type
3033: and section_code = p_tds_section_code
3034: and org_tan_num = p_tan_no

Line 3049: from jai_ap_tds_thhold_grps

3045: p_section_type jai_ap_tds_inv_taxes.section_type%type
3046: )
3047: IS
3048: select threshold_grp_id
3049: from jai_ap_tds_thhold_grps
3050: where vendor_id = p_vendor_id
3051: and section_type = p_section_type
3052: and section_code = p_tds_section_code
3053: and org_tan_num = p_tan_no

Line 4077: r_jai_ap_tds_thhold_grps := null;

4073: if nvl(ln_threshold_grp_id, 0) <> 0 then
4074:
4075: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
4076:
4077: r_jai_ap_tds_thhold_grps := null;
4078:
4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4081: close c_jai_ap_tds_thhold_grps;

Line 4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

4075: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
4076:
4077: r_jai_ap_tds_thhold_grps := null;
4078:
4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4081: close c_jai_ap_tds_thhold_grps;
4082:
4083: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

4076:
4077: r_jai_ap_tds_thhold_grps := null;
4078:
4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4081: close c_jai_ap_tds_thhold_grps;
4082:
4083: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4084:

Line 4081: close c_jai_ap_tds_thhold_grps;

4077: r_jai_ap_tds_thhold_grps := null;
4078:
4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4081: close c_jai_ap_tds_thhold_grps;
4082:
4083: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4084:
4085: else

Line 4083: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

4079: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4080: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4081: close c_jai_ap_tds_thhold_grps;
4082:
4083: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4084:
4085: else
4086:
4087: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */

Line 4282: r_jai_ap_tds_thhold_grps := null;

4278: /*if nvl(ln_threshold_grp_id, 0) <> 0 then
4279:
4280: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); \* 13 *\
4281:
4282: r_jai_ap_tds_thhold_grps := null;
4283:
4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4286: close c_jai_ap_tds_thhold_grps;

Line 4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

4280: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); \* 13 *\
4281:
4282: r_jai_ap_tds_thhold_grps := null;
4283:
4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4286: close c_jai_ap_tds_thhold_grps;
4287:
4288: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

4281:
4282: r_jai_ap_tds_thhold_grps := null;
4283:
4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4286: close c_jai_ap_tds_thhold_grps;
4287:
4288: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4289:

Line 4286: close c_jai_ap_tds_thhold_grps;

4282: r_jai_ap_tds_thhold_grps := null;
4283:
4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4286: close c_jai_ap_tds_thhold_grps;
4287:
4288: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4289:
4290: else

Line 4288: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

4284: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4285: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4286: close c_jai_ap_tds_thhold_grps;
4287:
4288: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4289:
4290: else
4291:
4292: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); \* 14 *\

Line 4368: r_jai_ap_tds_thhold_grps := null;

4364: r_jai_ap_tds_thhold_slabs := null;
4365:
4366: --Added by Chong for Bug#13802244 2012/09/17 Start
4367: -------------------------------------------------------------------------------------------
4368: r_jai_ap_tds_thhold_grps := null;
4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4371: close c_jai_ap_tds_thhold_grps;
4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

4365:
4366: --Added by Chong for Bug#13802244 2012/09/17 Start
4367: -------------------------------------------------------------------------------------------
4368: r_jai_ap_tds_thhold_grps := null;
4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4371: close c_jai_ap_tds_thhold_grps;
4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4373: -------------------------------------------------------------------------------------------

Line 4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

4366: --Added by Chong for Bug#13802244 2012/09/17 Start
4367: -------------------------------------------------------------------------------------------
4368: r_jai_ap_tds_thhold_grps := null;
4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4371: close c_jai_ap_tds_thhold_grps;
4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4373: -------------------------------------------------------------------------------------------
4374: --Added by Chong for Bug#13802244 2012/09/17 End

Line 4371: close c_jai_ap_tds_thhold_grps;

4367: -------------------------------------------------------------------------------------------
4368: r_jai_ap_tds_thhold_grps := null;
4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4371: close c_jai_ap_tds_thhold_grps;
4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4373: -------------------------------------------------------------------------------------------
4374: --Added by Chong for Bug#13802244 2012/09/17 End
4375:

Line 4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

4368: r_jai_ap_tds_thhold_grps := null;
4369: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4370: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4371: close c_jai_ap_tds_thhold_grps;
4372: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4373: -------------------------------------------------------------------------------------------
4374: --Added by Chong for Bug#13802244 2012/09/17 End
4375:
4376:

Line 5137: from jai_ap_tds_thhold_grps

5133:
5134: Cursor get_section_info(cn_threshold_grp_id number)
5135: Is
5136: select section_type,section_code
5137: from jai_ap_tds_thhold_grps
5138: where threshold_grp_id = cn_threshold_grp_id;
5139:
5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;
5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;

Line 5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;

5136: select section_type,section_code
5137: from jai_ap_tds_thhold_grps
5138: where threshold_grp_id = cn_threshold_grp_id;
5139:
5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;
5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;
5142:
5143: cursor get_tax_category(cn_threshold_slab_id number)
5144: is

Line 5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;

5137: from jai_ap_tds_thhold_grps
5138: where threshold_grp_id = cn_threshold_grp_id;
5139:
5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;
5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;
5142:
5143: cursor get_tax_category(cn_threshold_slab_id number)
5144: is
5145: SELECT --JATTTY.THRESHOLD_TYPE_ID, JATTTY.FROM_DATE, JATTTY.TO_DATE, JATTTY.THRESHOLD_TYPE, JATTTA.THRESHOLD_SLAB_ID, JATTS.FROM_AMOUNT, JATTS.TO_AMOUNT,

Line 9007: If p_effective_invoice_amt is null, will get amount from JAI_AP_TDS_THHOLD_GRPS

9003: -------------------------------------------------------------------------------
9004: S.No Date Author and Details
9005: Update by Chong.Lei 2012-02-06
9006: : get threshold slab info.
9007: If p_effective_invoice_amt is null, will get amount from JAI_AP_TDS_THHOLD_GRPS
9008: If p_effective_invoice_amt is not null, will use given amount
9009: ---------------------------------------------------------------------------- */
9010: PROCEDURE get_tds_threshold_slab(p_prepay_distribution_id IN NUMBER,
9011: p_invoice_id IN NUMBER,

Line 9053: FROM jai_ap_tds_thhold_grps

9049: AND section_type = 'TDS_SECTION';
9050:
9051: CURSOR c_get_threshold_grp_dtl(p_threshold_grp_id NUMBER) IS
9052: SELECT *
9053: FROM jai_ap_tds_thhold_grps
9054: WHERE threshold_grp_id = p_threshold_grp_id;
9055:
9056: CURSOR c_get_threshold_hdr(p_vendor_id NUMBER,
9057: p_org_tan_num VARCHAR2,

Line 9173: --If p_effective_invoice_amt is null, will get amount from JAI_AP_TDS_THHOLD_GRPS

9169: END IF;
9170:
9171:
9172: IF p_effective_invoice_amt IS NULL THEN
9173: --If p_effective_invoice_amt is null, will get amount from JAI_AP_TDS_THHOLD_GRPS
9174: ln_effective_invoice_amt := r_get_threshold_grp_dtl.total_invoice_amount -
9175: r_get_threshold_grp_dtl.total_invoice_cancel_amount -
9176: r_get_threshold_grp_dtl.total_invoice_apply_amount +
9177: r_get_threshold_grp_dtl.total_invoice_unapply_amount;

Line 9326: from jai_ap_tds_thhold_grps

9322:
9323: cursor c_get_tds_section_info(cn_threshold_grp_id NUMBER) is
9324: select section_type
9325: ,section_code
9326: from jai_ap_tds_thhold_grps
9327: where threshold_grp_id = cn_threshold_grp_id;
9328: CURSOR c_get_tax_amount(cv_event VARCHAR2, cn_threshold_grp_id NUMBER) IS
9329: SELECT SUM(TAXABLE_AMOUNT), SUM(TAX_AMOUNT)
9330: FROM JAI_AP_TDS_THHOLD_TRXS