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.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 894: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

890:
891: CURSOR c_invoice IS
892: SELECT
893: tap.id tap_id
894: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
895: ,tap.org_id
896: ,tap.invoice_category_code
897: ,tap.invoice_number
898: --,tap.vendor_invoice_number

Line 985: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

981: AND nvl(tap.vpa_id,-1) = nvl(p_vpa_id, nvl(tap.vpa_id,-1))
982: UNION ALL
983: SELECT
984: tap.id tap_id
985: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
986: ,tap.org_id
987: ,tap.invoice_category_code
988: ,tap.invoice_number
989: --,tap.vendor_invoice_number

Line 1721: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

1717: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_group
1718: ,SUM(tpl.amount) cin_invoice_amount
1719: ,povs.vendor_id
1720: ,tap.INVOICE_TYPE
1721: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
1722: ,tap.LEGAL_ENTITY_ID
1723: ,tap.VPA_ID
1724: ,acc_cr.code_combination_id
1725: ,COUNT(1) line_count

Line 1756: NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id),

1752: tap.ipvs_id,
1753: tap.pay_group_lookup_code,
1754: tap.payment_method_code,
1755: tap.ippt_id,
1756: NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id),
1757: acc_cr.code_combination_id,
1758: tap.currency_code,
1759: tap.currency_conversion_type,
1760: tap.currency_conversion_rate,

Line 1792: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

1788: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_group
1789: ,SUM(tpl.amount) cin_invoice_amount
1790: ,povs.vendor_id
1791: ,tap.INVOICE_TYPE
1792: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
1793: ,tap.LEGAL_ENTITY_ID
1794: ,tap.VPA_ID
1795: ,acc_cr.code_combination_id
1796: ,COUNT(1) line_count

Line 1827: NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id),

1823: tap.ipvs_id,
1824: tap.pay_group_lookup_code,
1825: tap.payment_method_code,
1826: tap.ippt_id,
1827: NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id),
1828: acc_cr.code_combination_id,
1829: tap.currency_code,
1830: tap.currency_conversion_type,
1831: tap.currency_conversion_rate,

Line 1869: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

1865: p_cin_date_invoiced date
1866: )IS
1867: SELECT
1868: tap.id tap_id
1869: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
1870: ,tap.org_id
1871: ,tap.invoice_number
1872: ,nvl(tap.vendor_invoice_number, tap.invoice_number) vendor_invoice_number
1873: ,tap.code_combination_id tap_ccid

Line 1926: and NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) = p_set_of_books_id

1922: and tap.ipvs_id = p_ipvs_id
1923: and NVL(tap.pay_group_lookup_code,'x') = NVL(p_pay_group_lookup_code,'x')
1924: and tap.payment_method_code = p_payment_method_code
1925: and NVL(tap.ippt_id,-123) = NVL(p_ippt_id,-123)
1926: and NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) = p_set_of_books_id
1927: and nvl(acc_cr.code_combination_id, -1) = nvl(p_code_combination_id, nvl(acc_cr.code_combination_id, -1))
1928: and tap.currency_code = p_currency_code
1929: and nvl(tap.currency_conversion_type, 'x') = nvl(p_currency_conversion_type,nvl(tap.currency_conversion_type, 'x'))
1930: and nvl(tap.currency_conversion_rate, -1) = nvl(p_currency_conversion_rate,nvl(tap.currency_conversion_rate, -1))

Line 1950: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

1946: = p_cin_date_invoiced
1947: UNION ALL
1948: SELECT
1949: tap.id tap_id
1950: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
1951: ,tap.org_id
1952: ,tap.invoice_number
1953: ,nvl(tap.vendor_invoice_number, tap.invoice_number) vendor_invoice_number
1954: ,tap.code_combination_id tap_ccid

Line 2007: and NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) = p_set_of_books_id

2003: and tap.ipvs_id = p_ipvs_id
2004: and NVL(tap.pay_group_lookup_code,'x') = NVL(p_pay_group_lookup_code,'x')
2005: and tap.payment_method_code = p_payment_method_code
2006: and NVL(tap.ippt_id,-123) = NVL(p_ippt_id,-123)
2007: and NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) = p_set_of_books_id
2008: and nvl(acc_cr.code_combination_id, -1) = nvl(p_code_combination_id, nvl(acc_cr.code_combination_id, -1))
2009: and tap.currency_code = p_currency_code
2010: and nvl(tap.currency_conversion_type, 'x') = nvl(p_currency_conversion_type,nvl(tap.currency_conversion_type, 'x'))
2011: and nvl(tap.currency_conversion_rate, -1) = nvl(p_currency_conversion_rate,nvl(tap.currency_conversion_rate, -1))

Line 3023: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

3019:
3020: CURSOR c_invoice IS
3021: SELECT
3022: tap.id tap_id
3023: ,NVL(tap.set_of_books_id, OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
3024: ,tap.org_id
3025: ,tap.invoice_category_code
3026: ,tap.invoice_number
3027: --,tap.vendor_invoice_number

Line 3083: OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

3079: SELECT
3080: -- NULL tpl_id -- cklee comment out
3081: tap.id tap_id
3082: ,NVL(tap.set_of_books_id,
3083: OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
3084: ,tap.org_id
3085: ,tap.invoice_category_code
3086: ,tap.invoice_number
3087: --,tap.vendor_invoice_number

Line 3136: ,NVL(tap.set_of_books_id,OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id

3132: UNION
3133: SELECT
3134: -- tpl.id tpl_id -- cklee comment out
3135: tap.id tap_id
3136: ,NVL(tap.set_of_books_id,OKL_ACCOUNTING_UTIL.get_set_of_books_id) sob_id
3137: ,tap.org_id
3138: ,tap.invoice_category_code
3139: ,tap.invoice_number
3140: --,tap.vendor_invoice_number

Line 3404: := okl_accounting_util.get_func_curr_code;

3400:
3401: -- If Currency Code is null then default functional currency
3402: IF ( l_xpiv_rec.INVOICE_CURRENCY_CODE IS NULL ) THEN
3403: l_xpiv_rec.INVOICE_CURRENCY_CODE
3404: := okl_accounting_util.get_func_curr_code;
3405: END IF;
3406:
3407: -- If the type were not captured in authoring
3408: IF l_xpiv_rec.currency_conversion_type IS NULL THEN

Line 3432: := okl_accounting_util.get_curr_con_rate

3428: OR l_xpiv_rec.currency_conversion_type = 'Corporate') THEN
3429:
3430: l_xpiv_rec.currency_conversion_rate := NULL;
3431: /*
3432: := okl_accounting_util.get_curr_con_rate
3433: (p_from_curr_code => l_xpiv_rec.INVOICE_CURRENCY_CODE,
3434: p_to_curr_code => okl_accounting_util.get_func_curr_code,
3435: p_con_date => l_xpiv_rec.currency_conversion_date,
3436: p_con_type => l_xpiv_rec.currency_conversion_type);

Line 3434: p_to_curr_code => okl_accounting_util.get_func_curr_code,

3430: l_xpiv_rec.currency_conversion_rate := NULL;
3431: /*
3432: := okl_accounting_util.get_curr_con_rate
3433: (p_from_curr_code => l_xpiv_rec.INVOICE_CURRENCY_CODE,
3434: p_to_curr_code => okl_accounting_util.get_func_curr_code,
3435: p_con_date => l_xpiv_rec.currency_conversion_date,
3436: p_con_type => l_xpiv_rec.currency_conversion_type);
3437: */
3438: END IF;

Line 3848: := okl_accounting_util.get_func_curr_code;

3844:
3845: -- If Currency Code is null then default functional currency
3846: IF ( l_xpiv_rec.INVOICE_CURRENCY_CODE IS NULL ) THEN
3847: l_xpiv_rec.INVOICE_CURRENCY_CODE
3848: := okl_accounting_util.get_func_curr_code;
3849: END IF;
3850:
3851: -- If the type were not captured in authoring
3852: IF l_xpiv_rec.currency_conversion_type IS NULL THEN

Line 3876: := okl_accounting_util.get_curr_con_rate

3872: OR l_xpiv_rec.currency_conversion_type = 'Corporate') THEN
3873:
3874: l_xpiv_rec.currency_conversion_rate := NULL;
3875: /*l_xpiv_rec.currency_conversion_rate
3876: := okl_accounting_util.get_curr_con_rate
3877: (p_from_curr_code => l_xpiv_rec.INVOICE_CURRENCY_CODE,
3878: p_to_curr_code => okl_accounting_util.get_func_curr_code,
3879: p_con_date => l_xpiv_rec.currency_conversion_date,
3880: p_con_type => l_xpiv_rec.currency_conversion_type);

Line 3878: p_to_curr_code => okl_accounting_util.get_func_curr_code,

3874: l_xpiv_rec.currency_conversion_rate := NULL;
3875: /*l_xpiv_rec.currency_conversion_rate
3876: := okl_accounting_util.get_curr_con_rate
3877: (p_from_curr_code => l_xpiv_rec.INVOICE_CURRENCY_CODE,
3878: p_to_curr_code => okl_accounting_util.get_func_curr_code,
3879: p_con_date => l_xpiv_rec.currency_conversion_date,
3880: p_con_type => l_xpiv_rec.currency_conversion_type);
3881: */
3882: END IF;