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_GENERATION_PKG

Line 40: jai_ap_tds_generation_pkg.generate_tds_invoices

36: b) Code Added to open and Fetch the details from the
37: above 2 cursors
38: c) Changed the value of parameter pn_tax_amount,
39: while calling
40: jai_ap_tds_generation_pkg.generate_tds_invoices
41: d) Changed the value of parameter p_trx_tax_paid,
42: while calling
43: jai_ap_tds_generation_pkg.maintain_thhold_grps
44:

Line 43: jai_ap_tds_generation_pkg.maintain_thhold_grps

39: while calling
40: jai_ap_tds_generation_pkg.generate_tds_invoices
41: d) Changed the value of parameter p_trx_tax_paid,
42: while calling
43: jai_ap_tds_generation_pkg.maintain_thhold_grps
44:
45: Dependencies (Functional)
46: -------------------------
47: jai_ap_tds_gen.plb Version 120.3

Line 608: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

604: FETCH c_tds_details_apply INTO r_tds_details_apply;
605: EXIT WHEN c_tds_details_apply%NOTFOUND ;
606:
607: ln_temp_threshold_grp_id := r_tds_details_apply.tds_threshold_grp_id;
608: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
609: p_prepay_distribution_id => p_prepay_distribution_id,
610: p_threshold_grp_id => ln_temp_threshold_grp_id,
611: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
612: p_threshold_slab_id => ln_threshold_slab_id,

Line 624: jai_ap_tds_generation_pkg.maintain_thhold_grps

620: END IF;
621:
622:
623: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
624: jai_ap_tds_generation_pkg.maintain_thhold_grps
625: (
626: p_threshold_grp_id => ln_threshold_grp_id,
627: p_trx_invoice_unapply_amount => r_tds_details_apply.tds_taxable_basis,/*5751783*/
628: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 666: jai_ap_tds_generation_pkg.generate_tds_invoices

662: /* Bug 5751783
663: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
664: * invoice_id of the prepayment application.
665: */
666: jai_ap_tds_generation_pkg.generate_tds_invoices
667: (
668: pn_invoice_id => ln_parent_pp_invoice_id ,
669: pn_invoice_distribution_id => p_invoice_distribution_id ,
670: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 702: jai_ap_tds_generation_pkg.maintain_thhold_grps

698: /* Update the threshold group */
699:
700: ln_threshold_grp_id:= r_tds_details_apply.tds_threshold_grp_id;
701: if p_event = 'INSERT' then /*Added for Bug 8431516*/
702: jai_ap_tds_generation_pkg.maintain_thhold_grps
703: (
704: p_threshold_grp_id => ln_threshold_grp_id,
705: p_trx_tax_paid => r_get_total_prepayment_tax.tds_amount,
706: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 748: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

744: * Store the current Threshold slab and type
745: * After PP Unapplication
746: */
747:
748: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
749: p_prepay_distribution_id => p_prepay_distribution_id,
750: p_threshold_grp_id => ln_temp_threshold_grp_id,
751: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
752: p_threshold_slab_id => ln_after_threshold_slab_id,

Line 766: jai_ap_tds_generation_pkg.process_threshold_transition

762: IF ln_threshold_slab_id <> ln_after_threshold_slab_id THEN
763: lv_slab_transition_tds_event :=
764: 'THRESHOLD TRANSITION-PPUA(from slab id -' || ln_threshold_slab_id ||
765: 'to slab id - ' || ln_after_threshold_slab_id || ')';
766: jai_ap_tds_generation_pkg.process_threshold_transition
767: (
768: p_threshold_grp_id => ln_temp_threshold_grp_id,
769: p_threshold_slab_id => ln_after_threshold_slab_id,
770: p_invoice_id => ln_parent_pp_invoice_id,

Line 829: jai_ap_tds_generation_pkg.generate_tds_invoices

825: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
826: * invoice_id of the prepayment application.
827: */
828:
829: jai_ap_tds_generation_pkg.generate_tds_invoices
830: (
831: pn_invoice_id => ln_parent_pp_invoice_id ,
832: pn_invoice_distribution_id => p_invoice_distribution_id ,
833: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 906: jai_ap_tds_generation_pkg.generate_tds_invoices

902: /* Bug 5721614. Added by Lakshmi Gopalsami
903: * Changed from p_invoice_id to ln_parent_pp_invoice_id ie,
904: * invoice_id of the prepayment application.
905: */
906: jai_ap_tds_generation_pkg.generate_tds_invoices
907: (
908: pn_invoice_id => ln_parent_pp_invoice_id ,
909: pn_invoice_distribution_id => p_invoice_distribution_id ,
910: pv_invoice_num_to_tds_apply => lv_invoice_num_to_tds_apply ,

Line 965: jai_ap_tds_generation_pkg.import_and_approve

961: where invoice_id = p_invoice_id;
962:
963: if ln_start_threshold_trx_id is not null then
964:
965: jai_ap_tds_generation_pkg.import_and_approve
966: (
967: p_invoice_id => ln_parent_pp_invoice_id, /*Bug 5751783*/
968: p_start_thhold_trx_id => ln_start_threshold_trx_id,
969: p_tds_event => 'PREPAYMENT UNAPPLICATION',

Line 1680: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1676: ln_tds_tmp_amt := 0;
1677: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1678: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1679: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1680: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1681: else
1682: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1683: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1684: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1684: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1680: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1681: else
1682: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1683: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1684: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1685: end if;
1686: IF trunc(p_creation_date) >=
1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1688: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

Line 1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1683: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1684: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1685: end if;
1686: IF trunc(p_creation_date) >=
1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1688: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1689: END IF;
1690: -- End for bug 5722028
1691:

Line 1688: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1684: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1685: end if;
1686: IF trunc(p_creation_date) >=
1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1688: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1689: END IF;
1690: -- End for bug 5722028
1691:
1692:

Line 1736: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1732: ln_tds_tmp_amt := 0;
1733: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1734: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1735: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1736: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1737: else
1738: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1739: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1740: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1740: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1736: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1737: else
1738: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1739: * (ln_tax_rate_basis/100), /*Bug 6363056*/
1740: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1741: end if;
1742:
1743: /* Bug 7280925. Commented by Lakshmi Gopalsami
1744: * Rounding to 10 is applicable only for TDS.

Line 1747: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1743: /* Bug 7280925. Commented by Lakshmi Gopalsami
1744: * Rounding to 10 is applicable only for TDS.
1745: * WCT and ESSI should be rounded to Re. 1
1746: IF trunc(p_creation_date) >=
1747: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1748: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1749: END IF;
1750: */
1751: -- End for bug 5722028

Line 1748: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1744: * Rounding to 10 is applicable only for TDS.
1745: * WCT and ESSI should be rounded to Re. 1
1746: IF trunc(p_creation_date) >=
1747: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1748: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1749: END IF;
1750: */
1751: -- End for bug 5722028
1752:

Line 1795: jai_ap_tds_generation_pkg.g_inr_currency_rounding);

1791: ln_tds_tmp_amt := 0;
1792: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1793: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1794: * (ln_tax_rate_basis/100),
1795: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1796: else
1797: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1798: * (ln_tax_rate_basis/100),
1799: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

Line 1799: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);

1795: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1796: else
1797: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1798: * (ln_tax_rate_basis/100),
1799: jai_ap_tds_generation_pkg.g_fcy_currency_rounding);
1800: end if;
1801: /* Bug 7280925. Commented by Lakshmi Gopalsami
1802: * Rounding to 10 is applicable only for TDS.
1803: * WCT and ESSI should be rounded to Re. 1

Line 1805: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1801: /* Bug 7280925. Commented by Lakshmi Gopalsami
1802: * Rounding to 10 is applicable only for TDS.
1803: * WCT and ESSI should be rounded to Re. 1
1804: IF trunc(p_creation_date) >=
1805: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1806: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1807: END IF;
1808: */
1809: -- End for bug 5722028

Line 1806: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);

1802: * Rounding to 10 is applicable only for TDS.
1803: * WCT and ESSI should be rounded to Re. 1
1804: IF trunc(p_creation_date) >=
1805: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1806: ln_tds_tmp_amt := jai_ap_tds_generation_pkg.get_rnded_value(ln_tds_tmp_amt);
1807: END IF;
1808: */
1809: -- End for bug 5722028
1810:

Line 1877: jai_ap_tds_generation_pkg.maintain_thhold_grps(

1873: open c_get_grp_details_si_inv_dist(p_invoice_id, r_get_tax_sec_det.invoice_distribution_id);
1874: fetch c_get_grp_details_si_inv_dist into ln_si_thgrp_id;
1875: close c_get_grp_details_si_inv_dist;
1876:
1877: jai_ap_tds_generation_pkg.maintain_thhold_grps(
1878: p_threshold_grp_id => ln_si_thgrp_id,
1879: p_trx_invoice_apply_amount => r_get_tax_sec_det.application_amount,
1880: p_tds_event => 'PREPAYMENT APPLICATION',
1881: p_invoice_id => p_invoice_id,

Line 1963: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

1959:
1960: ln_threshold_grp_id := ln_temp_threshold_grp_id;
1961: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_threshold_grp_id :'||ln_threshold_grp_id);
1962: --Call to procedure - get_tds_threshold_slab, Store the current Threshold slab and type before PP application
1963: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
1964: p_prepay_distribution_id => p_prepay_distribution_id,
1965: p_threshold_grp_id => ln_temp_threshold_grp_id,
1966: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
1967: p_threshold_slab_id => ln_threshold_slab_id,

Line 1979: jai_ap_tds_generation_pkg.maintain_thhold_grps

1975: END IF;
1976: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1977: if r_get_total_prepayment_tax.tds_amount > 0 THEN
1978: /* update the threshold with the tds amount that will be impacted because of this application */
1979: jai_ap_tds_generation_pkg.maintain_thhold_grps
1980: (
1981: p_threshold_grp_id => ln_threshold_grp_id,
1982: p_trx_invoice_apply_amount => get_si_det.tds_taxable_basis,
1983: p_tds_event => 'PREPAYMENT APPLICATION',

Line 2054: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

2050: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_parent_invoice_id :'||ln_parent_invoice_id);
2051: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' get_tds_threshold_slab :p_prepay_distribution_id :'||p_prepay_distribution_id);
2052:
2053: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application
2054: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
2055: p_prepay_distribution_id => p_prepay_distribution_id,
2056: p_threshold_grp_id => ln_temp_threshold_grp_id,
2057: p_threshold_hdr_id => ln_temp_threshold_hdr_id,
2058: p_threshold_slab_id => ln_after_threshold_slab_id,

Line 2111: jai_ap_tds_generation_pkg.generate_tds_invoices

2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);
2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);
2110: /*Bug 5751783. Changed from invoice_id to ln_parent_invoice_id*/
2111: jai_ap_tds_generation_pkg.generate_tds_invoices
2112: (
2113: pn_invoice_id => ln_parent_invoice_id,
2114: pn_invoice_distribution_id => p_invoice_distribution_id,
2115: pv_invoice_num_prepay_apply => lv_invoice_num_prepay_apply,

Line 2142: jai_ap_tds_generation_pkg.maintain_thhold_grps

2138: ln_start_threshold_trx_id := ln_threshold_trx_id_tds;
2139: END IF ;
2140:
2141: /* Update the threshold group */
2142: jai_ap_tds_generation_pkg.maintain_thhold_grps
2143: ( p_threshold_grp_id => ln_threshold_grp_id,
2144: p_trx_tax_paid => (-1 * ln_tot_tds_amt),
2145: p_tds_event => 'PREPAYMENT APPLICATION',
2146: p_invoice_id => p_invoice_id,

Line 2176: jai_ap_tds_generation_pkg.process_threshold_rollback

2172: * Changed from p_invoice_id to ln_parent_invoice_id
2173: * Parent invoice_id should be depending on the TDS invoice
2174: * created.
2175: */
2176: jai_ap_tds_generation_pkg.process_threshold_rollback
2177: ( p_invoice_id => ln_parent_invoice_id,
2178: p_before_threshold_type => lv_threshold_type,
2179: p_after_threshold_type => lv_after_threshold_type,
2180: p_before_threshold_slab_id => ln_threshold_slab_id,

Line 2231: jai_ap_tds_generation_pkg.generate_tds_invoices

2227: END IF ;
2228:
2229: if p_event = 'INSERT' then --Added for Bug 8431516
2230: /*Bug 5751783 - Changed from p_invoice_id to ln_pp_section_invoice_id*/
2231: jai_ap_tds_generation_pkg.generate_tds_invoices
2232: (
2233: pn_invoice_id => ln_parent_invoice_id ,
2234: pn_invoice_distribution_id => p_invoice_distribution_id ,
2235: pn_taxable_amount => r_get_total_prepayment_tax.wct_taxable_basis ,

Line 2290: jai_ap_tds_generation_pkg.generate_tds_invoices

2286: END IF ;
2287:
2288: IF p_event = 'INSERT' then --Added for Bug 8431516
2289: /*Bug 5751783 - Changed from p_invoice_id to ln_pp_section_invoice_id*/
2290: jai_ap_tds_generation_pkg.generate_tds_invoices
2291: (
2292: pn_invoice_id => ln_parent_invoice_id ,
2293: pn_invoice_distribution_id => p_invoice_distribution_id ,
2294: pn_taxable_amount => r_get_total_prepayment_tax.essi_taxable_basis ,

Line 2330: jai_ap_tds_generation_pkg.import_and_approve

2326: /*Bug - 9826422
2327: Records are inserted into AP Interface tables using Standard Invoice, but import_and_approve
2328: was called using the Prepayment Invoice ID. Hence wrong group_id was getting passed and no
2329: Invoices were getting improved*/
2330: jai_ap_tds_generation_pkg.import_and_approve
2331: (
2332: p_invoice_id => ln_parent_invoice_id,
2333: p_start_thhold_trx_id => ln_start_threshold_trx_id,
2334: p_tds_event => 'PREPAYMENT APPLICATION',