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

Line 495: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

491: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
492: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
493: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
494: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
495: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
496: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
497: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
498: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
499: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;

Line 1460: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

1456: where invoice_distribution_id = p_prepay_distribution_id
1457: and section_type = p_section_type;
1458:
1459:
1460: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1461: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
1462: from jai_ap_tds_thhold_grps
1463: where threshold_grp_id = p_threshold_grp_id;
1464:

Line 1462: from jai_ap_tds_thhold_grps

1458:
1459:
1460: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1461: select nvl(current_threshold_slab_id, 0) current_threshold_slab_id
1462: from jai_ap_tds_thhold_grps
1463: where threshold_grp_id = p_threshold_grp_id;
1464:
1465: cursor c_ap_invoices_all (p_invoice_distribution_id number) is
1466: select invoice_num, invoice_id \*Bug 5751783*\

Line 1520: FROM jai_ap_tds_thhold_grps

1516: where invoice_id = p_invoice_id;
1517:
1518: CURSOR c_get_thgrp_det ( p_threshold_grp_id NUMBER ) IS
1519: SELECT *
1520: FROM jai_ap_tds_thhold_grps
1521: WHERE threshold_grp_id = p_threshold_grp_id;
1522: \*Bug 6363056 End*\
1523:
1524:

Line 1576: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;

1572:
1573: ln_exchange_rate number;
1574: ln_threshold_grp_id number;
1575: ln_total_tds_amount number;
1576: ln_current_threshold_slab_id jai_ap_tds_thhold_grps.current_threshold_slab_id%type;
1577: ln_prepay_tax_id number;
1578:
1579: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
1580: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;

Line 1601: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1597: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1598: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1599: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
1600: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
1601: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1602: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
1603:
1604: -- Bug 5722028. Added by CSahoo
1605: ln_tds_tmp_amt number;

Line 1616: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1612: r_ja_in_tax_codes_prepay c_ja_in_tax_codes%rowtype;
1613: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1614: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1615: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1616: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1617: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1618: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1619: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

Line 1617: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

1613: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1614: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1615: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1616: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1617: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1618: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1619: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1621: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

Line 1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

1616: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1617: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1618: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1619: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1621: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1622: \*Bug 6363056 - End*\
1623: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1624: \*START, Bgowrava for Bug#7626202*\

Line 1621: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

1617: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1618: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1619: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1621: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1622: \*Bug 6363056 - End*\
1623: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1624: \*START, Bgowrava for Bug#7626202*\
1625: ln_tot_tds_amt number := 0;

Line 1912: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;

1908: goto exit_from_procedure;
1909: end if;
1910:
1911: OPEN c_get_thgrp_det(ln_pp_thhold_grp_id);
1912: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;
1913: CLOSE c_get_thgrp_det;
1914:
1915: FOR get_si_det IN (SELECT jattt.*,
1916: jatp.tds_prepayment_id tds_prepayment_id,

Line 1944: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;

1940: NVL (ln_temp_threshold_grp_id, 0) <> 0 AND
1941: NVL (ln_temp_threshold_grp_id,0 ) <> NVL (ln_pp_thhold_grp_id, 0)
1942: THEN
1943: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
1944: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
1945: CLOSE c_get_thgrp_det;
1946: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
1947: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
1948: END IF ;

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

1942: THEN
1943: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
1944: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
1945: CLOSE c_get_thgrp_det;
1946: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
1947: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
1948: END IF ;
1949: END IF ;
1950:

Line 3149: FROM jai_ap_tds_thhold_grps

3145: where invoice_id = p_invoice_id;
3146:
3147: CURSOR c_get_thgrp_det ( p_threshold_grp_id NUMBER ) IS
3148: SELECT *
3149: FROM jai_ap_tds_thhold_grps
3150: WHERE threshold_grp_id = p_threshold_grp_id;
3151:
3152: cursor c_get_grp_details_si_inv_dist(p_invoice_id number, p_invoice_distribution_id number)
3153: is

Line 3216: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

3212: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
3213: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
3214: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
3215: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
3216: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3217: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
3218:
3219:
3220: ln_tds_tmp_amt number;

Line 3222: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

3218:
3219:
3220: ln_tds_tmp_amt number;
3221: ln_parent_invoice_id NUMBER ;
3222: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3223: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
3224: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3225: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3226: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE;

Line 3224: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

3220: ln_tds_tmp_amt number;
3221: ln_parent_invoice_id NUMBER ;
3222: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3223: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
3224: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3225: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3226: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE;
3227: ln_tot_tds_amt number := 0;
3228: ln_tot_appln_amt number := 0;

Line 3225: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;

3221: ln_parent_invoice_id NUMBER ;
3222: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3223: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
3224: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3225: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3226: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE;
3227: ln_tot_tds_amt number := 0;
3228: ln_tot_appln_amt number := 0;
3229: ln_application_mode VARCHAR2(1);

Line 3476: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;

3472: goto exit_from_procedure;
3473: end if;
3474:
3475: OPEN c_get_thgrp_det(ln_pp_thhold_grp_id);
3476: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;
3477: CLOSE c_get_thgrp_det;
3478:
3479: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3480: FOR get_si_det IN (SELECT jattt.*,

Line 3514: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;

3510: NVL (ln_temp_threshold_grp_id, 0) <> 0 AND
3511: NVL (ln_temp_threshold_grp_id,0 ) <> NVL (ln_pp_thhold_grp_id, 0)
3512: THEN
3513: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
3514: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
3515: CLOSE c_get_thgrp_det;
3516: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
3517: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
3518: END IF ;

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

3512: THEN
3513: OPEN c_get_thgrp_det(ln_temp_threshold_grp_id);
3514: FETCH c_get_thgrp_det INTO r_si_jai_ap_tds_thhold_grps;
3515: CLOSE c_get_thgrp_det;
3516: IF r_pp_jai_ap_tds_thhold_grps.fin_year > r_si_jai_ap_tds_thhold_grps.fin_year THEN
3517: ln_temp_threshold_grp_id := ln_pp_thhold_grp_id;
3518: END IF ;
3519: END IF ;
3520: