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_PAY_INVOICES_CONS_PVT

Line 1: PACKAGE BODY okl_pay_invoices_cons_pvt AS

1: PACKAGE BODY okl_pay_invoices_cons_pvt AS
2: /* $Header: OKLRPICB.pls 120.41.12010000.2 2010/02/11 06:30:28 nikshah ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES.INVOICE';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 1702: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

1698:
1699: -- Main cursor to get the consolidate invoice header
1700: CURSOR c_cin_invoice IS
1701: SELECT
1702: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1703: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) cin_date_invoiced -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1704: ,tap.pay_group_lookup_code
1705: ,tap.ipvs_id
1706: ,tap.ippt_id

Line 1712: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(

1708: ,tap.currency_code
1709: ,tap.currency_conversion_type
1710: ,tap.currency_conversion_rate
1711: ,TRUNC(tap.currency_conversion_date) currency_conversion_date -- cklee 09/13/07
1712: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1713: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1714: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1715: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1716: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(

Line 1714: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(

1710: ,tap.currency_conversion_rate
1711: ,TRUNC(tap.currency_conversion_date) currency_conversion_date -- cklee 09/13/07
1712: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1713: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1714: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1715: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1716: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(
1717: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_group
1718: ,SUM(tpl.amount) cin_invoice_amount

Line 1716: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(

1712: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1713: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1714: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1715: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1716: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(
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

Line 1765: okl_pay_invoices_cons_pvt.get_Disbursement_rule(

1761: TRUNC(tap.currency_conversion_date), -- cklee 09/13/07
1762: tap.legal_entity_id,
1763: tap.vpa_id,
1764: tap.invoice_type,
1765: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1766: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1767: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1768: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1769: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

Line 1767: okl_pay_invoices_cons_pvt.get_Disbursement_group(

1763: tap.vpa_id,
1764: tap.invoice_type,
1765: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1766: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1767: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1768: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1769: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1770: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1771: UNION ALL

Line 1769: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

1765: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1766: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1767: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1768: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1769: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1770: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1771: UNION ALL
1772: SELECT
1773: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

Line 1773: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

1769: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1770: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1771: UNION ALL
1772: SELECT
1773: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1774: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) cin_date_invoiced -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1775: ,tap.pay_group_lookup_code
1776: ,tap.ipvs_id
1777: ,tap.ippt_id

Line 1783: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(

1779: ,tap.currency_code
1780: ,tap.currency_conversion_type
1781: ,tap.currency_conversion_rate
1782: ,TRUNC(tap.currency_conversion_date) currency_conversion_date -- cklee 09/13/07
1783: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1784: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1785: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1786: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1787: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(

Line 1785: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(

1781: ,tap.currency_conversion_rate
1782: ,TRUNC(tap.currency_conversion_date) currency_conversion_date -- cklee 09/13/07
1783: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1784: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1785: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1786: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1787: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(
1788: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_group
1789: ,SUM(tpl.amount) cin_invoice_amount

Line 1787: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(

1783: --futrue release ,okl_pay_invoices_cons_pvt.get_contract_group(
1784: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')) contract_group
1785: ,okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1786: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y') disbursement_rule
1787: ,okl_pay_invoices_cons_pvt.get_Disbursement_group(
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

Line 1836: okl_pay_invoices_cons_pvt.get_Disbursement_rule(

1832: TRUNC(tap.currency_conversion_date), -- cklee 09/13/07
1833: tap.legal_entity_id,
1834: tap.vpa_id,
1835: tap.invoice_type,
1836: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1837: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1838: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1839: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1840: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

Line 1838: okl_pay_invoices_cons_pvt.get_Disbursement_group(

1834: tap.vpa_id,
1835: tap.invoice_type,
1836: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1837: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1838: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1839: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1840: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1841: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')); -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1842:

Line 1840: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

1836: okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1837: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1838: okl_pay_invoices_cons_pvt.get_Disbursement_group(
1839: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'),
1840: TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1841: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')); -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1842:
1843: r_cin_invoice c_cin_invoice%ROWTYPE;
1844:

Line 1935: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(

1931: and nvl(TRUNC(tap.currency_conversion_date), trunc(sysdate)) = nvl(TRUNC(p_currency_conversion_date),nvl(TRUNC(tap.currency_conversion_date), trunc(sysdate))) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1932: and tap.legal_entity_id = p_legal_entity_id
1933: and nvl(tap.vpa_id,-1) = nvl(p_vpa_id, nvl(tap.vpa_id,-1))
1934: and nvl(tap.invoice_type, 'x') = nvl(p_invoice_type,nvl(tap.invoice_type, 'x'))
1935: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1936: tap.date_invoiced,tpl.id, povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
1937: = p_disbursement_rule
1938: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
1939: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')

Line 1938: and okl_pay_invoices_cons_pvt.get_Disbursement_group(

1934: and nvl(tap.invoice_type, 'x') = nvl(p_invoice_type,nvl(tap.invoice_type, 'x'))
1935: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(
1936: tap.date_invoiced,tpl.id, povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
1937: = p_disbursement_rule
1938: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
1939: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
1940: = p_disbursement_group
1941: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
1942: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')

Line 1941: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(

1937: = p_disbursement_rule
1938: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
1939: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
1940: = p_disbursement_group
1941: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
1942: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')
1943: -- = nvl(p_contract_group, 'x')
1944: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1945: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc

Line 1944: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

1940: = p_disbursement_group
1941: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
1942: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')
1943: -- = nvl(p_contract_group, 'x')
1944: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
1945: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')) -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
1946: = p_cin_date_invoiced
1947: UNION ALL
1948: SELECT

Line 2016: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(

2012: and nvl(TRUNC(tap.currency_conversion_date), trunc(sysdate)) = nvl(TRUNC(p_currency_conversion_date),nvl(TRUNC(tap.currency_conversion_date), trunc(sysdate))) -- -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
2013: and tap.legal_entity_id = p_legal_entity_id
2014: and nvl(tap.vpa_id,-1) = nvl(p_vpa_id, nvl(tap.vpa_id,-1))
2015: and nvl(tap.invoice_type, 'x') = nvl(p_invoice_type,nvl(tap.invoice_type, 'x'))
2016: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(
2017: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
2018: = p_disbursement_rule
2019: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
2020: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')

Line 2019: and okl_pay_invoices_cons_pvt.get_Disbursement_group(

2015: and nvl(tap.invoice_type, 'x') = nvl(p_invoice_type,nvl(tap.invoice_type, 'x'))
2016: and okl_pay_invoices_cons_pvt.get_Disbursement_rule(
2017: tap.date_invoiced,tpl.id,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
2018: = p_disbursement_rule
2019: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
2020: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
2021: = p_disbursement_group
2022: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
2023: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')

Line 2022: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(

2018: = p_disbursement_rule
2019: and okl_pay_invoices_cons_pvt.get_Disbursement_group(
2020: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y')
2021: = p_disbursement_group
2022: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
2023: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')
2024: -- = nvl(p_contract_group, 'x')
2025: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
2026: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'))

Line 2025: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(

2021: = p_disbursement_group
2022: -- and nvl(okl_pay_invoices_cons_pvt.get_contract_group(
2023: -- tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,chr.contract_number, nvl(tpl.adv_grouping_flag,'Y')), 'x')
2024: -- = nvl(p_contract_group, 'x')
2025: and TRUNC(okl_pay_invoices_cons_pvt.get_ap_invoice_date(
2026: tap.date_invoiced,povs.vendor_id,tap.ipvs_id,sty.stream_type_purpose,'Y'))
2027: = p_cin_date_invoiced; -- | 12-Dec-2007 cklee -- Fixed bug: 6682348 added trunc
2028:
2029: r_invoice c_invoice%ROWTYPE;

Line 4991: END okl_pay_invoices_cons_pvt;

4987: --end: 31-Oct-2007 cklee -- bug: 6508575 fixed
4988:
4989:
4990:
4991: END okl_pay_invoices_cons_pvt;