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 GL_SETS_OF_BOOKS

Line 422: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

418: get_tax_category(decode(jatp.application_basis,'STANDARD',jatp.invoice_distribution_id,p_prepay_distribution_id)),
419: tds_section_code_prepay,
420: essi_threshold_trx_id_apply
421: ;
422: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
423: select currency_code
424: from gl_sets_of_books
425: where set_of_books_id = cp_set_of_books_id;
426:

Line 424: from gl_sets_of_books

420: essi_threshold_trx_id_apply
421: ;
422: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
423: select currency_code
424: from gl_sets_of_books
425: where set_of_books_id = cp_set_of_books_id;
426:
427: cursor c_get_tds_tax_id(p_invoice_id number, p_prepay_distribution_id number) is
428: select tds_tax_id_prepay

Line 474: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

470: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
471: r_tds_details_apply c_tds_details_apply%rowtype;
472: r_wct_details_apply c_wct_details_apply%ROWTYPE;
473: r_essi_details_apply c_essi_details_apply%ROWTYPE;
474: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
475:
476: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
477: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
478: ln_threshold_trx_id_apply number;

Line 515: open c_gl_sets_of_books(p_set_of_books_id);

511: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
512: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
513: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Chong.Lei for bug#13787158
514:
515: open c_gl_sets_of_books(p_set_of_books_id);
516: fetch c_gl_sets_of_books into r_gl_sets_of_books;
517: close c_gl_sets_of_books;
518:
519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 516: fetch c_gl_sets_of_books into r_gl_sets_of_books;

512: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
513: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Chong.Lei for bug#13787158
514:
515: open c_gl_sets_of_books(p_set_of_books_id);
516: fetch c_gl_sets_of_books into r_gl_sets_of_books;
517: close c_gl_sets_of_books;
518:
519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
520: /* Foreign currency invoice */

Line 517: close c_gl_sets_of_books;

513: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Chong.Lei for bug#13787158
514:
515: open c_gl_sets_of_books(p_set_of_books_id);
516: fetch c_gl_sets_of_books into r_gl_sets_of_books;
517: close c_gl_sets_of_books;
518:
519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
520: /* Foreign currency invoice */
521: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

515: open c_gl_sets_of_books(p_set_of_books_id);
516: fetch c_gl_sets_of_books into r_gl_sets_of_books;
517: close c_gl_sets_of_books;
518:
519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
520: /* Foreign currency invoice */
521: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
522: ln_exchange_rate := p_exchange_rate;
523: end if;

Line 1406: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

1402: p_codepath in out nocopy varchar2
1403: )
1404: is
1405:
1406: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1407: select currency_code
1408: from gl_sets_of_books
1409: where set_of_books_id = cp_set_of_books_id;
1410:

Line 1408: from gl_sets_of_books

1404: is
1405:
1406: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1407: select currency_code
1408: from gl_sets_of_books
1409: where set_of_books_id = cp_set_of_books_id;
1410:
1411: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
1412: select tds_prepayment_id,

Line 1569: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

1565: AND threshold_trx_id IS NOT NULL
1566: group by invoice_id;
1567: \*Bug 12671504 - End*\
1568:
1569: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1570: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1571: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
1572:
1573: ln_exchange_rate number;

Line 1639: open c_gl_sets_of_books(p_set_of_books_id);

1635: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); \* 1 *\
1636:
1637: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1638:
1639: open c_gl_sets_of_books(p_set_of_books_id);
1640: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1641: close c_gl_sets_of_books;
1642:
1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 1640: fetch c_gl_sets_of_books into r_gl_sets_of_books;

1636:
1637: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1638:
1639: open c_gl_sets_of_books(p_set_of_books_id);
1640: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1641: close c_gl_sets_of_books;
1642:
1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1644: \* Foreign currency invoice *\

Line 1641: close c_gl_sets_of_books;

1637: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1638:
1639: open c_gl_sets_of_books(p_set_of_books_id);
1640: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1641: close c_gl_sets_of_books;
1642:
1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1644: \* Foreign currency invoice *\
1645: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); \* 6.1 *\

Line 1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

1639: open c_gl_sets_of_books(p_set_of_books_id);
1640: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1641: close c_gl_sets_of_books;
1642:
1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1644: \* Foreign currency invoice *\
1645: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); \* 6.1 *\
1646: ln_exchange_rate := p_exchange_rate;
1647: end if;

Line 1680: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1676: \* Bug 5722028. Addd by CSahoo
1677: * Need to round the value as per the setup.
1678: *\
1679: ln_tds_tmp_amt := 0;
1680: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1681: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1682: * (ln_tax_rate_basis/100), \*Bug 6363056*\
1683: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1684: else

Line 1736: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1732: \* Bug 5722028. Addd by CSahoo
1733: * Need to round the value as per the setup.
1734: *\
1735: ln_tds_tmp_amt := 0;
1736: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1737: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1738: * (ln_tax_rate_basis/100), \*Bug 6363056*\
1739: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1740: else

Line 1795: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1791: \* Bug 5722028. Addd by Lakshmi Gopalsami
1792: * Need to round the value as per the setup.
1793: *\
1794: ln_tds_tmp_amt := 0;
1795: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then
1796: ln_tds_tmp_amt := round(cur_rec.application_amount *ln_exchange_rate
1797: * (ln_tax_rate_basis/100),
1798: jai_ap_tds_generation_pkg.g_inr_currency_rounding);
1799: else

Line 2991: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

2987: p_codepath in out nocopy varchar2
2988: )
2989: is
2990:
2991: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
2992: select currency_code
2993: from gl_sets_of_books
2994: where set_of_books_id = cp_set_of_books_id;
2995:

Line 2993: from gl_sets_of_books

2989: is
2990:
2991: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
2992: select currency_code
2993: from gl_sets_of_books
2994: where set_of_books_id = cp_set_of_books_id;
2995:
2996: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
2997: select tds_prepayment_id,

Line 3192: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

3188: FROM JAI_AP_TDS_INV_TAXES
3189: WHERE INVOICE_DISTRIBUTION_ID = cn_invoice_distribution_id
3190: AND ROWNUM = 1;
3191:
3192: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
3193: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
3194: r_get_tax_sec_det c_get_tax_sec_det%ROWTYPE;
3195: ln_exchange_rate number;
3196: ln_threshold_grp_id number;

Line 3249: open c_gl_sets_of_books(p_set_of_books_id);

3245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_tds_prepayemnts_pkg.generate_rtn', 'START'); /* 1 */
3246:
3247: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id);
3248:
3249: open c_gl_sets_of_books(p_set_of_books_id);
3250: fetch c_gl_sets_of_books into r_gl_sets_of_books;
3251: close c_gl_sets_of_books;
3252:
3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 3250: fetch c_gl_sets_of_books into r_gl_sets_of_books;

3246:
3247: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id);
3248:
3249: open c_gl_sets_of_books(p_set_of_books_id);
3250: fetch c_gl_sets_of_books into r_gl_sets_of_books;
3251: close c_gl_sets_of_books;
3252:
3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
3254: /* Foreign currency invoice */

Line 3251: close c_gl_sets_of_books;

3247: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id);
3248:
3249: open c_gl_sets_of_books(p_set_of_books_id);
3250: fetch c_gl_sets_of_books into r_gl_sets_of_books;
3251: close c_gl_sets_of_books;
3252:
3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
3254: /* Foreign currency invoice */
3255: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */

Line 3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

3249: open c_gl_sets_of_books(p_set_of_books_id);
3250: fetch c_gl_sets_of_books into r_gl_sets_of_books;
3251: close c_gl_sets_of_books;
3252:
3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
3254: /* Foreign currency invoice */
3255: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3256: ln_exchange_rate := p_exchange_rate;
3257: end if;