APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on GL_SETS_OF_BOOKS

Line 500: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

496: where invoice_id = p_invoice_id
497: and invoice_distribution_id_prepay = p_invoice_distribution_id
498: and essi_threshold_trx_id_apply is not null;
499:
500: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
501: select currency_code
502: from gl_sets_of_books
503: where set_of_books_id = cp_set_of_books_id;
504:

Line 502: from gl_sets_of_books

498: and essi_threshold_trx_id_apply is not null;
499:
500: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
501: select currency_code
502: from gl_sets_of_books
503: where set_of_books_id = cp_set_of_books_id;
504:
505: cursor c_get_tds_tax_id(p_invoice_id number, p_prepay_distribution_id number) is
506: select tds_tax_id_prepay

Line 544: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

540:
541:
542: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
543: r_tds_details_apply c_tds_details_apply%rowtype;
544: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
545:
546: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
547: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
548: ln_threshold_trx_id_apply number;

Line 578: open c_gl_sets_of_books(p_set_of_books_id);

574:
575: begin
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
577:
578: open c_gl_sets_of_books(p_set_of_books_id);
579: fetch c_gl_sets_of_books into r_gl_sets_of_books;
580: close c_gl_sets_of_books;
581:
582: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 579: fetch c_gl_sets_of_books into r_gl_sets_of_books;

575: begin
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
577:
578: open c_gl_sets_of_books(p_set_of_books_id);
579: fetch c_gl_sets_of_books into r_gl_sets_of_books;
580: close c_gl_sets_of_books;
581:
582: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
583: /* Foreign currency invoice */

Line 580: close c_gl_sets_of_books;

576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
577:
578: open c_gl_sets_of_books(p_set_of_books_id);
579: fetch c_gl_sets_of_books into r_gl_sets_of_books;
580: close c_gl_sets_of_books;
581:
582: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
583: /* Foreign currency invoice */
584: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 582: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

578: open c_gl_sets_of_books(p_set_of_books_id);
579: fetch c_gl_sets_of_books into r_gl_sets_of_books;
580: close c_gl_sets_of_books;
581:
582: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
583: /* Foreign currency invoice */
584: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
585: ln_exchange_rate := p_exchange_rate;
586: end if;

Line 1389: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

1385: p_codepath in out nocopy varchar2
1386: )
1387: is
1388:
1389: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1390: select currency_code
1391: from gl_sets_of_books
1392: where set_of_books_id = cp_set_of_books_id;
1393:

Line 1391: from gl_sets_of_books

1387: is
1388:
1389: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1390: select currency_code
1391: from gl_sets_of_books
1392: where set_of_books_id = cp_set_of_books_id;
1393:
1394: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
1395: select tds_prepayment_id,

Line 1561: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

1557: AND tds_threshold_trx_id_unapply IS NULL;
1558: ln_application_amount number;
1559: /* Bug 14183670 -end*/
1560:
1561: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1562: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1563: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
1564:
1565: ln_exchange_rate number;

Line 1635: open c_gl_sets_of_books(p_set_of_books_id);

1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1637: close c_gl_sets_of_books;
1638:
1639: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;

1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1637: close c_gl_sets_of_books;
1638:
1639: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1640: /* Foreign currency invoice */

Line 1637: close c_gl_sets_of_books;

1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1637: close c_gl_sets_of_books;
1638:
1639: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1640: /* Foreign currency invoice */
1641: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */

Line 1639: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1637: close c_gl_sets_of_books;
1638:
1639: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1640: /* Foreign currency invoice */
1641: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
1642: ln_exchange_rate := p_exchange_rate;
1643: end if;

Line 1677: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1673: /* Bug 5722028. Addd by CSahoo
1674: * Need to round the value as per the setup.
1675: */
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

Line 1733: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1729: /* Bug 5722028. Addd by CSahoo
1730: * Need to round the value as per the setup.
1731: */
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

Line 1792: if r_gl_sets_of_books.currency_code = p_invoice_currency_code then

1788: /* Bug 5722028. Addd by Lakshmi Gopalsami
1789: * Need to round the value as per the setup.
1790: */
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