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_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 565: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

561: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
562: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
563: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
564: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
565: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
566: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
567: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
568: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
569: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;

Line 1443: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

1439: where invoice_distribution_id = p_prepay_distribution_id
1440: and section_type = p_section_type;
1441:
1442:
1443: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1444: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
1445: from jai_ap_tds_thhold_grps
1446: where threshold_grp_id = p_threshold_grp_id;
1447:

Line 1445: from jai_ap_tds_thhold_grps

1441:
1442:
1443: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1444: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
1445: from jai_ap_tds_thhold_grps
1446: where threshold_grp_id = p_threshold_grp_id;
1447:
1448: cursor c_ap_invoices_all (p_invoice_distribution_id number) is
1449: select invoice_num, invoice_id /*Bug 5751783*/

Line 1503: FROM jai_ap_tds_thhold_grps

1499: where invoice_id = p_invoice_id;
1500:
1501: CURSOR c_get_thgrp_det ( p_threshold_grp_id NUMBER ) IS
1502: SELECT *
1503: FROM jai_ap_tds_thhold_grps
1504: WHERE threshold_grp_id = p_threshold_grp_id;
1505: /*Bug 6363056 End*/
1506:
1507:

Line 1568: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;

1564:
1565: ln_exchange_rate number;
1566: ln_threshold_grp_id number;
1567: ln_total_tds_amount number;
1568: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;
1569: ln_prepay_tax_id number;
1570:
1571: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1572: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

Line 1593: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1589: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1590: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1591: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1592: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1593: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1594: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
1595:
1596: -- Bug 5722028. Added by CSahoo
1597: ln_tds_tmp_amt number;

Line 1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1604: r_ja_in_tax_codes_prepay c_ja_in_tax_codes%rowtype;
1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

Line 1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

Line 1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1614: /*Bug 6363056 - End*/
1615: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1616: /*START, Bgowrava for Bug#7626202*/

Line 1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1614: /*Bug 6363056 - End*/
1615: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1616: /*START, Bgowrava for Bug#7626202*/
1617: ln_tot_tds_amt number := 0;

Line 1921: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;

1917: goto exit_from_procedure;
1918: end if;
1919:
1920: OPEN c_get_thgrp_det(ln_pp_thhold_grp_id);
1921: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;
1922: CLOSE c_get_thgrp_det;
1923:
1924: FOR get_si_det IN (SELECT jattt.*,
1925: jatp.tds_prepayment_id tds_prepayment_id,

Line 1953: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;

1949: NVL (ln_temp_threshold_grp_id, 0) <> 0 AND
1950: NVL (ln_temp_threshold_grp_id,0 ) <> NVL (ln_pp_thhold_grp_id, 0)
1951: THEN
1952: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
1953: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
1954: CLOSE c_get_thgrp_det;
1955: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
1956: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
1957: END IF ;

Line 1955: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN

1951: THEN
1952: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
1953: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
1954: CLOSE c_get_thgrp_det;
1955: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
1956: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
1957: END IF ;
1958: END IF ;
1959: