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_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 872: from jai_ap_tds_thhold_grps

868:
869: cursor c_get_threshold_group
870: (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
871: select threshold_grp_id
872: from jai_ap_tds_thhold_grps
873: where vendor_id = p_vendor_id
874: and section_type = p_section_type --rchandan for bug#4428980
875: and section_code = p_tds_section_code
876: and org_tan_num = p_tan_no

Line 880: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

876: and org_tan_num = p_tan_no
877: and vendor_pan_num = p_pan_no
878: and fin_year = p_fin_year;
879:
880: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
881: select (
882: nvl(total_invoice_amount, 0) -
883: nvl(total_invoice_cancel_amount, 0) -
884: nvl(total_invoice_apply_amount, 0) +

Line 893: from jai_ap_tds_thhold_grps

889: total_thhold_change_tax_paid,
890: current_threshold_slab_id,
891: /*Bug 5751783. Selected non-rounded value for calculation*/
892: total_calc_tax_paid
893: from jai_ap_tds_thhold_grps
894: where threshold_grp_id = p_threshold_grp_id;
895:
896:
897: cursor c_jai_ap_tds_thhold_slabs

Line 1103: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

1099: -------------------------------------------------------------------------------
1100: --Addec by Jia for FP Bug#7431371, End
1101:
1102: ln_prepayment_app_amt number :=0; --xiao for Bug#6596019
1103: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
1104: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1105: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1106:
1107: ln_count number:= 0;

Line 1464: r_jai_ap_tds_thhold_grps := null;

1460: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1461: if nvl(ln_threshold_grp_id, 0) <> 0 then
1462: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
1463:
1464: r_jai_ap_tds_thhold_grps := null;
1465:
1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1468: close c_jai_ap_tds_thhold_grps;

Line 1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

1462: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
1463:
1464: r_jai_ap_tds_thhold_grps := null;
1465:
1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1468: close c_jai_ap_tds_thhold_grps;
1469:
1470: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

1463:
1464: r_jai_ap_tds_thhold_grps := null;
1465:
1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1468: close c_jai_ap_tds_thhold_grps;
1469:
1470: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1471:

Line 1468: close c_jai_ap_tds_thhold_grps;

1464: r_jai_ap_tds_thhold_grps := null;
1465:
1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1468: close c_jai_ap_tds_thhold_grps;
1469:
1470: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1471:
1472: else

Line 1470: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

1466: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1467: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
1468: close c_jai_ap_tds_thhold_grps;
1469:
1470: ln_total_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
1471:
1472: else
1473: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
1474:

Line 2845: cursor c_jai_ap_tds_thhold_grps(cp_threshold_grp_id number) is

2841: and tds_event like 'SURCHARGE_CALCULATE';
2842: /* END, Bgowrava for Bug#8254510*/
2843:
2844:
2845: cursor c_jai_ap_tds_thhold_grps(cp_threshold_grp_id number) is
2846: select (
2847: nvl(total_invoice_amount, 0) -
2848: nvl(total_invoice_cancel_amount, 0) -
2849: nvl(total_invoice_apply_amount, 0) +

Line 2856: from jai_ap_tds_thhold_grps

2852: total_invoice_amount,
2853: total_tax_paid,
2854: /*Bug 5751783. Selected non-rounded value for calculation*/
2855: total_calc_tax_paid
2856: from jai_ap_tds_thhold_grps
2857: where threshold_grp_id = cp_threshold_grp_id;
2858:
2859: cursor c_ja_in_tax_codes(cp_tax_id number) is
2860: select tax_rate, surcharge_rate, cess_rate, sh_cess_rate, section_code --Added surcharge_rate, cess_rate, sh_cess_rate, section_code by Bgowrava for bug#8254510

Line 2950: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

2946: lv_codepath jai_ap_tds_inv_taxes.codepath%type;
2947:
2948:
2949: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
2950: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2951: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
2952: ln_thhold_transition_tax_amt number;
2953: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
2954: lv_tds_cm_num ap_invoices_all.invoice_num%type;

Line 2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);

2989: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
2990: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2995: close c_jai_ap_tds_thhold_grps;
2996:
2997: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);

Line 2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

2990: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2995: close c_jai_ap_tds_thhold_grps;
2996:
2997: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2998: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;

Line 2995: close c_jai_ap_tds_thhold_grps;

2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2995: close c_jai_ap_tds_thhold_grps;
2996:
2997: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2998: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2999: close c_ja_in_tax_codes;

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

3001: -- Bug 5722028. Added by csahoo
3002: -- Rounded depending on the TDS setup rounding.
3003:
3004: /*ln_thhold_transition_tax_amt :=
3005: ROUND(r_jai_ap_tds_thhold_grps.total_invoice_amount * (r_ja_in_tax_codes.tax_rate/100),
3006: g_inr_currency_rounding);
3007:
3008: IF trunc(sysdate) >=
3009: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

Line 3013: ln_thhold_transition_tax_amt := ln_thhold_transition_tax_amt - r_jai_ap_tds_thhold_grps.total_tax_paid;*/ --Commented by Bgowrava for Bug#8254510

3009: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
3010: ln_thhold_transition_tax_amt := get_rnded_value(ln_thhold_transition_tax_amt);
3011: END IF;
3012:
3013: ln_thhold_transition_tax_amt := ln_thhold_transition_tax_amt - r_jai_ap_tds_thhold_grps.total_tax_paid;*/ --Commented by Bgowrava for Bug#8254510
3014: /*Moved below lines from below to here by amandali for Bug#9562876*/
3015: ln_threshold_slab_id_after := p_threshold_slab_id;
3016: ln_threshold_slab_id_temp := substr(p_tds_event, instr(p_tds_event,'from slab id -')+14 );
3017: ln_threshold_slab_id_before := to_number(substr(ln_threshold_slab_id_temp,1, instr(ln_threshold_slab_id_temp,'to slab id -')-1));

Line 3807: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

3803: )
3804: is
3805:
3806:
3807: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
3808: select total_invoice_amount ,
3809: total_invoice_cancel_amount ,
3810: total_invoice_apply_amount ,
3811: total_invoice_unapply_amount ,

Line 3816: from jai_ap_tds_thhold_grps

3812: total_tax_paid ,
3813: total_thhold_change_tax_paid ,
3814: current_threshold_slab_id ,
3815: total_calc_tax_paid -- Bug 5751783
3816: from jai_ap_tds_thhold_grps
3817: where threshold_grp_id = p_threshold_grp_id;
3818:
3819: cursor c_get_threshold_grp_id
3820: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,

Line 3823: from jai_ap_tds_thhold_grps

3819: cursor c_get_threshold_grp_id
3820: ( p_vendor_id number, p_org_tan_num varchar2, p_vendor_pan_num varchar2,
3821: p_section_type varchar2, p_section_code varchar2, p_fin_year number) is
3822: select threshold_grp_id
3823: from jai_ap_tds_thhold_grps
3824: where vendor_id = p_vendor_id and
3825: org_tan_num = p_org_tan_num and
3826: vendor_pan_num = p_vendor_pan_num and
3827: section_type = p_section_type and

Line 3832: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;

3828: section_code = p_section_code and
3829: fin_year = p_fin_year;
3830:
3831:
3832: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
3833:
3834: ln_threshold_grp_id jai_ap_tds_thgrp_audits.threshold_grp_id%type;
3835: ln_old_invoice_amount jai_ap_tds_thgrp_audits.old_invoice_amount%type;
3836: ln_old_invoice_cancel_amount jai_ap_tds_thgrp_audits.old_invoice_cancel_amount%type;

Line 3928: insert into jai_ap_tds_thhold_grps

3924: if nvl(ln_threshold_grp_id, 0) = 0 then
3925:
3926: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
3927:
3928: insert into jai_ap_tds_thhold_grps
3929: (
3930: threshold_grp_id ,
3931: vendor_id ,
3932: org_tan_num ,

Line 3945: jai_ap_tds_thhold_grps_s.nextval ,

3941: last_update_login
3942: )
3943: values
3944: (
3945: jai_ap_tds_thhold_grps_s.nextval ,
3946: p_vendor_id ,
3947: p_org_tan_num ,
3948: p_vendor_pan_num ,
3949: p_section_type ,

Line 3970: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

3966: end if; /* ln_threshold_grp_id is not given as an input */
3967:
3968: /* Get the old value of teh threshold group */
3969: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
3970: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

3967:
3968: /* Get the old value of teh threshold group */
3969: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
3970: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 3972: close c_jai_ap_tds_thhold_grps;

3968: /* Get the old value of teh threshold group */
3969: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
3970: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

Line 3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

3970: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

3971: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

3972: close c_jai_ap_tds_thhold_grps;
3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

3973:
3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
3981:

Line 3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

3974: ln_old_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
3981:
3982: /*Bug 5751783*/

Line 3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

3975: ln_old_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
3981:
3982: /*Bug 5751783*/
3983: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

Line 3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

3976: ln_old_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
3977: ln_old_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
3978: ln_old_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
3981:
3982: /*Bug 5751783*/
3983: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
3984:

Line 3983: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

3979: ln_old_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
3980: ln_old_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
3981:
3982: /*Bug 5751783*/
3983: ln_calc_old_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
3984:
3985: /* Check that threshold should not become negative */
3986: ln_effective_threshold_amount :=
3987: ( nvl(ln_old_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0) ) -

Line 4021: update jai_ap_tds_thhold_grps

4017: END IF;
4018: -- End if ;
4019:
4020: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
4021: update jai_ap_tds_thhold_grps
4022: set
4023: total_invoice_amount = nvl(total_invoice_amount, 0) + nvl(p_trx_invoice_amount, 0),
4024: total_invoice_cancel_amount = nvl(total_invoice_cancel_amount, 0) + nvl(p_trx_invoice_cancel_amount, 0),
4025: total_invoice_apply_amount = nvl(total_invoice_apply_amount, 0) + nvl(p_trx_invoice_apply_amount, 0),

Line 4038: r_jai_ap_tds_thhold_grps := null;

4034:
4035: where threshold_grp_id = ln_threshold_grp_id;
4036:
4037: /* Get the new value */
4038: r_jai_ap_tds_thhold_grps := null;
4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:

Line 4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

4035: where threshold_grp_id = ln_threshold_grp_id;
4036:
4037: /* Get the new value */
4038: r_jai_ap_tds_thhold_grps := null;
4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

Line 4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;

4036:
4037: /* Get the new value */
4038: r_jai_ap_tds_thhold_grps := null;
4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

Line 4041: close c_jai_ap_tds_thhold_grps;

4037: /* Get the new value */
4038: r_jai_ap_tds_thhold_grps := null;
4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

Line 4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;

4039: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

Line 4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;

4040: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

Line 4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;

4041: close c_jai_ap_tds_thhold_grps;
4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

Line 4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;

4042:
4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
4050:

Line 4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;

4043: ln_new_invoice_amount := r_jai_ap_tds_thhold_grps.total_invoice_amount;
4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
4050:
4051: /*Bug 5751783*/

Line 4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;

4044: ln_new_invoice_cancel_amount := r_jai_ap_tds_thhold_grps.total_invoice_cancel_amount;
4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
4050:
4051: /*Bug 5751783*/
4052: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

Line 4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;

4045: ln_new_invoice_apply_amount := r_jai_ap_tds_thhold_grps.total_invoice_apply_amount;
4046: ln_new_invoice_unapply_amount := r_jai_ap_tds_thhold_grps.total_invoice_unapply_amount;
4047: ln_new_tax_paid := r_jai_ap_tds_thhold_grps.total_tax_paid;
4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
4050:
4051: /*Bug 5751783*/
4052: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
4053:

Line 4052: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;

4048: ln_new_thhold_change_tax_paid := r_jai_ap_tds_thhold_grps.total_thhold_change_tax_paid;
4049: ln_new_threshold_slab_id := r_jai_ap_tds_thhold_grps.current_threshold_slab_id;
4050:
4051: /*Bug 5751783*/
4052: ln_calc_new_tax_paid := r_jai_ap_tds_thhold_grps.total_calc_tax_paid;
4053:
4054: /* Insert into the audite table */
4055: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
4056: insert into jai_ap_tds_thgrp_audits

Line 4572: FROM jai_ap_tds_thhold_grps

4568:
4569: CURSOR c_get_threshold_grp_dtl(p_threshold_grp_id NUMBER)
4570: IS
4571: SELECT *
4572: FROM jai_ap_tds_thhold_grps
4573: WHERE threshold_grp_id = p_threshold_grp_id;
4574:
4575: CURSOR c_get_threshold_hdr(p_vendor_id NUMBER,
4576: p_org_tan_num VARCHAR2,

Line 4702: FROM jai_ap_tds_thhold_grps

4698:
4699: CURSOR c_threshold_grp(p_threshold_grp_id NUMBER)
4700: IS
4701: SELECT *
4702: FROM jai_ap_tds_thhold_grps
4703: WHERE threshold_grp_id = p_threshold_grp_id;
4704:
4705: CURSOR c_taxable_amount(c_threshold_grp_id NUMBER,
4706: c_single_threshold_amt NUMBER)

Line 4748: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

4744: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
4745: lv_tds_cm_num ap_invoices_all.invoice_num%type;
4746: ln_threshold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
4747: ln_threshold_grp_audit_id jai_ap_tds_thgrp_audits.threshold_grp_audit_id%TYPE;
4748: ln_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
4749:
4750: /* Bug 5751783.
4751: * Get the sum of invoice amount for which TDS is not calculated
4752: */