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

Line 112: 3) In the procedure maintain_thhold_grps, while updating the table - jai_ap_tds_thhold_grps,

108:
109: 15. 19-Aug-2005 Ramananda for bug#4562793. File Version 120.6
110: 1) Moved the Cursor - c_ja_in_tax_codes, up from below the cursor c_po_vendor_sites_all
111: 2) Changed the parameters being passed to cursor - c_po_vendors and c_po_vendor_sites_all
112: 3) In the procedure maintain_thhold_grps, while updating the table - jai_ap_tds_thhold_grps,
113: changed the update for column - current_threshold_slab_id
114:
115: Dependency Due to this Bug
116: --------------------------

Line 194: updated jai_ap_tdS_inv_taxes and jai_ap_tds_thhold_grps

190: gn_tds_rounding_factor
191: gd_tds_rounding_effective_date and function get_rnded_value
192: is created.
193:
194: updated jai_ap_tdS_inv_taxes and jai_ap_tds_thhold_grps
195: withe the rounded values. This is done in procedure
196: process_tds_at_inv_validate and maintain_thhold_grps.
197: In generate_tds_invoices derived the logic for rounding.
198: Added conditions in queries for fetching the taxable

Line 416: from jai_ap_tds_thhold_grps

412:
413: cursor c_get_threshold_group
414: (p_vendor_id number, p_tan_no varchar2, p_pan_no varchar2, p_tds_section_code varchar2 , p_fin_year number,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
415: select threshold_grp_id
416: from jai_ap_tds_thhold_grps
417: where vendor_id = p_vendor_id
418: and section_type = p_section_type --rchandan for bug#4428980
419: and section_code = p_tds_section_code
420: and org_tan_num = p_tan_no

Line 424: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

420: and org_tan_num = p_tan_no
421: and vendor_pan_num = p_pan_no
422: and fin_year = p_fin_year;
423:
424: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
425: select (
426: nvl(total_invoice_amount, 0) -
427: nvl(total_invoice_cancel_amount, 0) -
428: nvl(total_invoice_apply_amount, 0) +

Line 435: from jai_ap_tds_thhold_grps

431: total_invoice_amount,
432: total_tax_paid,
433: total_thhold_change_tax_paid,
434: current_threshold_slab_id
435: from jai_ap_tds_thhold_grps
436: where threshold_grp_id = p_threshold_grp_id;
437:
438:
439: cursor c_jai_ap_tds_thhold_slabs

Line 536: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

532: and actual_tax_id is not null
533: group by section_type, actual_tax_id;
534:
535:
536: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
537: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
538: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
539:
540: ln_count number:= 0;

Line 768: r_jai_ap_tds_thhold_grps := null;

764: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
765: if nvl(ln_threshold_grp_id, 0) <> 0 then
766: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
767:
768: r_jai_ap_tds_thhold_grps := null;
769:
770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
772: close c_jai_ap_tds_thhold_grps;

Line 770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

766: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
767:
768: r_jai_ap_tds_thhold_grps := null;
769:
770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
772: close c_jai_ap_tds_thhold_grps;
773:
774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

767:
768: r_jai_ap_tds_thhold_grps := null;
769:
770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
772: close c_jai_ap_tds_thhold_grps;
773:
774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
775:

Line 772: close c_jai_ap_tds_thhold_grps;

768: r_jai_ap_tds_thhold_grps := null;
769:
770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
772: close c_jai_ap_tds_thhold_grps;
773:
774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
775:
776: else

Line 774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

770: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
771: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
772: close c_jai_ap_tds_thhold_grps;
773:
774: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
775:
776: else
777: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
778:

Line 1949: cursor c_jai_ap_tds_thhold_grps(cp_threshold_grp_id number) is

1945: where threshold_slab_id = p_threshold_slab_id
1946: and operating_unit_id = p_org_id;
1947:
1948:
1949: cursor c_jai_ap_tds_thhold_grps(cp_threshold_grp_id number) is
1950: select (
1951: nvl(total_invoice_amount, 0) -
1952: nvl(total_invoice_cancel_amount, 0) -
1953: nvl(total_invoice_apply_amount, 0) +

Line 1958: from jai_ap_tds_thhold_grps

1954: nvl(total_invoice_unapply_amount, 0)
1955: )
1956: total_invoice_amount,
1957: total_tax_paid
1958: from jai_ap_tds_thhold_grps
1959: where threshold_grp_id = cp_threshold_grp_id;
1960:
1961: cursor c_ja_in_tax_codes(cp_tax_id number) is
1962: select tax_rate

Line 1980: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

1976: lv_codepath jai_ap_tds_inv_taxes.codepath%type;
1977:
1978:
1979: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1980: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1981: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1982:
1983: ln_thhold_transition_tax_amt number;
1984: lv_tds_invoice_num ap_invoices_all.invoice_num%type;

Line 1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);

1992: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1998: close c_jai_ap_tds_thhold_grps;
1999:
2000: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);

Line 1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

1993: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1998: close c_jai_ap_tds_thhold_grps;
1999:
2000: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2001: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;

Line 1998: close c_jai_ap_tds_thhold_grps;

1994: close c_jai_ap_tds_thhold_taxes;
1995:
1996: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
1997: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1998: close c_jai_ap_tds_thhold_grps;
1999:
2000: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2001: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2002: close c_ja_in_tax_codes;

Line 2008: ROUND(r_jai_ap_tds_thhold_grps.total_invoice_amount * (r_ja_in_tax_codes.tax_rate/100),

2004: -- Bug 5722028. Added by csahoo
2005: -- Rounded depending on the TDS setup rounding.
2006:
2007: ln_thhold_transition_tax_amt :=
2008: ROUND(r_jai_ap_tds_thhold_grps.total_invoice_amount * (r_ja_in_tax_codes.tax_rate/100),
2009: g_inr_currency_rounding);
2010:
2011: IF trunc(sysdate) >=
2012: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

Line 2016: ln_thhold_transition_tax_amt := ln_thhold_transition_tax_amt - r_jai_ap_tds_thhold_grps.total_tax_paid;

2012: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
2013: ln_thhold_transition_tax_amt := get_rnded_value(ln_thhold_transition_tax_amt);
2014: END IF;
2015:
2016: ln_thhold_transition_tax_amt := ln_thhold_transition_tax_amt - r_jai_ap_tds_thhold_grps.total_tax_paid;
2017:
2018:
2019: if ln_thhold_transition_tax_amt > 0 then
2020:

Line 2606: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

2602: )
2603: is
2604:
2605:
2606: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
2607: select total_invoice_amount ,
2608: total_invoice_cancel_amount ,
2609: total_invoice_apply_amount ,
2610: total_invoice_unapply_amount ,

Line 2614: from jai_ap_tds_thhold_grps

2610: total_invoice_unapply_amount ,
2611: total_tax_paid ,
2612: total_thhold_change_tax_paid ,
2613: current_threshold_slab_id
2614: from jai_ap_tds_thhold_grps
2615: where threshold_grp_id = p_threshold_grp_id;
2616:
2617: cursor c_get_threshold_grp_id
2618: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,

Line 2621: from jai_ap_tds_thhold_grps

2617: cursor c_get_threshold_grp_id
2618: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,
2619: p_section_type varchar2, p_section_code varchar2, p_fin_year number) is
2620: select threshold_grp_id
2621: from jai_ap_tds_thhold_grps
2622: where vendor_id = p_vendor_id and
2623: org_tan_num = p_org_tan_num and
2624: vendor_pan_num = p_vendor_pan_num and
2625: section_type = p_section_type and

Line 2630: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

2626: section_code = p_section_code and
2627: fin_year = p_fin_year;
2628:
2629:
2630: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2631:
2632: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
2633: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
2634: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

Line 2721: insert into jai_ap_tds_thhold_grps

2717: if nvl(ln_threshold_grp_id, 0) = 0 then
2718:
2719: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2720:
2721: insert into jai_ap_tds_thhold_grps
2722: (
2723: threshold_grp_id ,
2724: vendor_id ,
2725: org_tan_num ,

Line 2738: jai_ap_tds_thhold_grps_s.nextval ,

2734: last_update_login
2735: )
2736: values
2737: (
2738: jai_ap_tds_thhold_grps_s.nextval ,
2739: p_vendor_id ,
2740: p_org_tan_num ,
2741: p_vendor_pan_num ,
2742: p_section_type ,

Line 2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

2759: end if; /* ln_threshold_grp_id is not given as an input */
2760:
2761: /* Get the old value of teh threshold group */
2762: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

2760:
2761: /* Get the old value of teh threshold group */
2762: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 2765: close c_jai_ap_tds_thhold_grps;

2761: /* Get the old value of teh threshold group */
2762: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

Line 2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

2763: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

2764: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

2765: close c_jai_ap_tds_thhold_grps;
2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

2766:
2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2774:

Line 2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

2767: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2774:
2775: /* Check that threshold should not become negative */

Line 2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

2768: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2774:
2775: /* Check that threshold should not become negative */
2776: ln_effective_threshold_amount :=

Line 2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

2769: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2770: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2771: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2772: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2773: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2774:
2775: /* Check that threshold should not become negative */
2776: ln_effective_threshold_amount :=
2777: ( nvl(ln_old_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0) ) -

Line 2811: update jai_ap_tds_thhold_grps

2807: END IF;
2808: -- End if ;
2809:
2810: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2811: update jai_ap_tds_thhold_grps
2812: set
2813: total_invoice_amount = nvl(total_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0),
2814: total_invoice_cancel_amount = nvl(total_invoice_cancel_amount, 0) + nvl(p_trx_invoice_cancel_amount, 0),
2815: total_invoice_apply_amount = nvl(total_invoice_apply_amount, 0) + nvl(p_trx_invoice_apply_amount, 0),

Line 2825: r_jai_ap_tds_thhold_grps := null;

2821: current_threshold_slab_id = nvl( p_trx_threshold_slab_id, 0)
2822: where threshold_grp_id = ln_threshold_grp_id;
2823:
2824: /* Get the new value */
2825: r_jai_ap_tds_thhold_grps := null;
2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:

Line 2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

2822: where threshold_grp_id = ln_threshold_grp_id;
2823:
2824: /* Get the new value */
2825: r_jai_ap_tds_thhold_grps := null;
2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

2823:
2824: /* Get the new value */
2825: r_jai_ap_tds_thhold_grps := null;
2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 2828: close c_jai_ap_tds_thhold_grps;

2824: /* Get the new value */
2825: r_jai_ap_tds_thhold_grps := null;
2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

Line 2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

2826: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

2827: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

2828: close c_jai_ap_tds_thhold_grps;
2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

2829:
2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:

Line 2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

2830: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:
2838: /* Insert into the audite table */

Line 2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

2831: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:
2838: /* Insert into the audite table */
2839: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

Line 2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

2832: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
2833: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
2834: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
2835: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
2836: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
2837:
2838: /* Insert into the audite table */
2839: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2840: insert into jai_ap_tds_thgrp_audits

Line 3327: FROM jai_ap_tds_thhold_grps

3323:
3324: CURSOR c_get_threshold_grp_dtl(p_threshold_grp_id NUMBER)
3325: IS
3326: SELECT *
3327: FROM jai_ap_tds_thhold_grps
3328: WHERE threshold_grp_id = p_threshold_grp_id;
3329:
3330: CURSOR c_get_threshold_hdr(p_vendor_id NUMBER,
3331: p_org_tan_num VARCHAR2,

Line 3457: FROM jai_ap_tds_thhold_grps

3453:
3454: CURSOR c_threshold_grp(p_threshold_grp_id NUMBER)
3455: IS
3456: SELECT *
3457: FROM jai_ap_tds_thhold_grps
3458: WHERE threshold_grp_id = p_threshold_grp_id;
3459:
3460: CURSOR c_taxable_amount(c_threshold_grp_id NUMBER,
3461: c_single_threshold_amt NUMBER)

Line 3503: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

3499: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
3500: lv_tds_cm_num ap_invoices_all.invoice_num%type;
3501: ln_threshold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
3502: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;
3503: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3504:
3505: CURSOR get_thhold_transn (cp_threshold_grp_id IN NUMBER )
3506: IS
3507: SELECT SUM(NVL(jattt.taxable_amount,0))