APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 70: updated jai_ap_tdS_inv_taxes and jai_ap_tds_thhold_grps

66: gn_tds_rounding_factor
67: gd_tds_rounding_effective_date and function get_rnded_value
68: is created.
69:
70: updated jai_ap_tdS_inv_taxes and jai_ap_tds_thhold_grps
71: withe the rounded values. This is done in procedure
72: process_tds_at_inv_validate and maintain_thhold_grps.
73: In generate_tds_invoices derived the logic for rounding.
74: Added conditions in queries for fetching the taxable

Line 975: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

971: where invoice_distribution_id = p_prepay_distribution_id
972: and section_type = p_section_type;
973:
974:
975: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
976: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
977: from jai_ap_tds_thhold_grps
978: where threshold_grp_id = p_threshold_grp_id;
979:

Line 977: from jai_ap_tds_thhold_grps

973:
974:
975: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
976: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
977: from jai_ap_tds_thhold_grps
978: where threshold_grp_id = p_threshold_grp_id;
979:
980: cursor c_ap_invoices_all (p_invoice_distribution_id number) is
981: select invoice_num

Line 1033: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;

1029:
1030: ln_exchange_rate number;
1031: ln_threshold_grp_id number;
1032: ln_total_tds_amount number;
1033: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;
1034: ln_prepay_tax_id number;
1035:
1036: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1037: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

Line 1058: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1054: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1055: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1056: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1057: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1058: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1059: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
1060:
1061: -- Bug 5722028. Added by CSahoo
1062: ln_tds_tmp_amt number;

Line 1267: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

1263: /* Bug 4522507. Added by Lakshmi Gopalsami
1264: Commented the following cursor
1265:
1266:
1267: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1268: fetch c_jai_ap_tds_thhold_grps into ln_current_threshold_slab_id;
1269: close c_jai_ap_tds_thhold_grps;
1270: */
1271:

Line 1268: fetch c_jai_ap_tds_thhold_grps into ln_current_threshold_slab_id;

1264: Commented the following cursor
1265:
1266:
1267: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1268: fetch c_jai_ap_tds_thhold_grps into ln_current_threshold_slab_id;
1269: close c_jai_ap_tds_thhold_grps;
1270: */
1271:
1272: update jai_ap_tds_prepayments

Line 1269: close c_jai_ap_tds_thhold_grps;

1265:
1266:
1267: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1268: fetch c_jai_ap_tds_thhold_grps into ln_current_threshold_slab_id;
1269: close c_jai_ap_tds_thhold_grps;
1270: */
1271:
1272: update jai_ap_tds_prepayments
1273: set tds_threshold_grp_id = ln_threshold_grp_id