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_GENERATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 519: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

515: AND organization_id = p_org_id
516: )
517: and p_accounting_date between start_date and end_date;
518:
519: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
520: select currency_code
521: from gl_sets_of_books
522: where set_of_books_id = cp_set_of_books_id;
523:

Line 521: from gl_sets_of_books

517: and p_accounting_date between start_date and end_date;
518:
519: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
520: select currency_code
521: from gl_sets_of_books
522: where set_of_books_id = cp_set_of_books_id;
523:
524: cursor c_get_non_tds_section_tax (p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
525: select section_type,

Line 537: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

533: group by section_type, actual_tax_id;
534:
535:
536: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
537: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
538: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
539:
540: ln_count number:= 0;
541: ln_cnt_already_processed number:= 0;

Line 626: open c_gl_sets_of_books(p_set_of_books_id);

622: and nvl(user_deleted_tax_flag, 'N') = 'Y';
623:
624: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
625:
626: open c_gl_sets_of_books(p_set_of_books_id);
627: fetch c_gl_sets_of_books into r_gl_sets_of_books;
628: close c_gl_sets_of_books;
629:
630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

Line 627: fetch c_gl_sets_of_books into r_gl_sets_of_books;

623:
624: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
625:
626: open c_gl_sets_of_books(p_set_of_books_id);
627: fetch c_gl_sets_of_books into r_gl_sets_of_books;
628: close c_gl_sets_of_books;
629:
630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
631: /* Foreign currency invoice */

Line 628: close c_gl_sets_of_books;

624: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
625:
626: open c_gl_sets_of_books(p_set_of_books_id);
627: fetch c_gl_sets_of_books into r_gl_sets_of_books;
628: close c_gl_sets_of_books;
629:
630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
631: /* Foreign currency invoice */
632: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */

Line 630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then

626: open c_gl_sets_of_books(p_set_of_books_id);
627: fetch c_gl_sets_of_books into r_gl_sets_of_books;
628: close c_gl_sets_of_books;
629:
630: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
631: /* Foreign currency invoice */
632: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
633: ln_exchange_rate := p_exchange_rate;
634: end if;

Line 667: If r_gl_sets_of_books.currency_code = p_invoice_currency_code then

663: */
664: /* Bug 7280925. Added by Lakshmi Gopalsami
665: Commented the following code as this is being handled in
666: generate_tds_invoicse and maintain_thhold_Grps
667: If r_gl_sets_of_books.currency_code = p_invoice_currency_code then
668: ln_tmp_tds_amt := round(ln_tax_amount,g_inr_currency_rounding);
669: else
670: ln_tmp_tds_amt := round(ln_tax_amount,g_fcy_currency_rounding);
671: end if ;

Line 1264: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

1260: from JAI_CMN_TAXES_ALL
1261: where tax_id = pn_tax_id;
1262:
1263:
1264: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1265: select currency_code
1266: from gl_sets_of_books
1267: where set_of_books_id = cp_set_of_books_id;
1268:

Line 1266: from gl_sets_of_books

1262:
1263:
1264: cursor c_gl_sets_of_books(cp_set_of_books_id number) is
1265: select currency_code
1266: from gl_sets_of_books
1267: where set_of_books_id = cp_set_of_books_id;
1268:
1269: cursor c_get_ja_in_ap_inv_id is
1270: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676

Line 1282: r_gl_sets_of_books c_gl_sets_of_books%rowtype;

1278: r_ap_invoices_all c_ap_invoices_all%rowtype;
1279: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
1280: r_po_vendor_sites_all c_po_vendor_sites_all%rowtype;
1281: r_po_vendors c_po_vendors%rowtype;
1282: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
1283: r_ap_payment_schedules_all c_ap_payment_schedules_all%rowtype;
1284:
1285:
1286: lv_source varchar2(30); --File.Sql.35 Cbabu := 'TDS';

Line 1388: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);

1384: open c_po_vendor_sites_all(r_ja_in_tax_codes.vendor_id, r_ja_in_tax_codes.vendor_site_id);
1385: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;
1386: close c_po_vendor_sites_all;
1387:
1388: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);
1389: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1390: close c_gl_sets_of_books;
1391:
1392:

Line 1389: fetch c_gl_sets_of_books into r_gl_sets_of_books;

1385: fetch c_po_vendor_sites_all into r_po_vendor_sites_all;
1386: close c_po_vendor_sites_all;
1387:
1388: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);
1389: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1390: close c_gl_sets_of_books;
1391:
1392:
1393: /* Get the payment details from the vendor site */

Line 1390: close c_gl_sets_of_books;

1386: close c_po_vendor_sites_all;
1387:
1388: open c_gl_sets_of_books(r_ap_invoices_all.set_of_books_id);
1389: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1390: close c_gl_sets_of_books;
1391:
1392:
1393: /* Get the payment details from the vendor site */
1394: ln_terms_id := r_po_vendor_sites_all.terms_id;

Line 1583: p_invoice_currency_code => r_gl_sets_of_books.currency_code,

1579: p_invoice_date => ld_accounting_date,
1580: p_vendor_id => r_ja_in_tax_codes.vendor_id,
1581: p_vendor_site_id => r_ja_in_tax_codes.vendor_site_id,
1582: p_invoice_amount => ln_invoice_to_tds_amount,
1583: p_invoice_currency_code => r_gl_sets_of_books.currency_code,
1584: p_exchange_rate => null,
1585: p_exchange_rate_type => null,
1586: p_exchange_date => null,
1587: p_terms_id => ln_terms_id,

Line 1641: if r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code then

1637: */
1638: IF pv_tds_event NOT IN
1639: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
1640: ('PREPAYMENT UNAPPLICATION') THEN
1641: if r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code then
1642: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
1643: ELSE
1644: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
1645: end if;

Line 1821: IF r_ap_invoices_all.invoice_currency_code = r_gl_sets_of_books.currency_code THEN

1817: ln_tds_rnded_amt := pn_tax_amount;
1818: IF pv_tds_event NOT IN
1819: -- Bug 7280925. commented by Lakshmi Gopalsami ('INVOICE CANCEL',
1820: ('PREPAYMENT UNAPPLICATION') THEN
1821: IF r_ap_invoices_all.invoice_currency_code = r_gl_sets_of_books.currency_code THEN
1822: ln_tds_rnded_amt := ROUND(pn_tax_amount , g_inr_currency_rounding);
1823: ELSE
1824: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
1825: END IF ;

Line 1894: r_gl_sets_of_books.currency_code ,

1890: r_ja_in_tax_codes.vendor_id ,
1891: r_ja_in_tax_codes.vendor_site_id ,
1892: lv_invoice_to_tds_num ,
1893: lv_invoice_to_tds_type ,
1894: r_gl_sets_of_books.currency_code ,
1895: ln_invoice_to_tds_amount ,
1896: r_ap_invoices_all.vendor_id ,
1897: r_ap_invoices_all.vendor_site_id ,
1898: lv_invoice_to_vendor_num ,