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_DISB_PVT dependencies on OKL_PAY_INVOICES_DISB_PVT

Line 1: PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT AS

1: PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT AS
2: /* $Header: OKLRPIDB.pls 120.22 2007/12/06 22:52:23 cklee noship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 1628: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1624: AND pph.payout_basis = 'BILLING'
1625: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1626: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1627: --added for evergreen change request 08_nov_2005
1628: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1629: OR
1630: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1631: --added for evergreen change request 08_nov_2005
1632: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1632: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1628: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1629: OR
1630: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1631: --added for evergreen change request 08_nov_2005
1632: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1633: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
1634: AND NVL (TRUNC(p_to_date), SYSDATE+10000)
1635: UNION ALL
1636: SELECT

Line 1707: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1703: --rkuttiya R12 B Billing Architecture replaced arv.date_consolidated by arv.date_consolidated
1704: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1705: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1706: --added for evergreen change request 08_nov_2005
1707: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1708: OR
1709: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1710: --added for evergreen change request 08_nov_2005
1711: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1711: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1707: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1708: OR
1709: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1710: --added for evergreen change request 08_nov_2005
1711: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1712: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
1713: AND NVL (TRUNC(p_to_date), SYSDATE+10000);
1714: --rkuttiya R12 B Billing Architecture end changes for this cursor
1715:

Line 1731: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date

1727: NULL cnr_id
1728: ,arl.receivables_invoice_number
1729: ,tai.set_of_books_id
1730: ,arv.org_id
1731: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1732: ,arv.currency_code
1733: ,tai.khr_id
1734: ,til.kle_id
1735: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount

Line 1735: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount

1731: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1732: ,arv.currency_code
1733: ,tai.khr_id
1734: ,til.kle_id
1735: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount
1736: ,arl.sty_id
1737: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1738: -- ,arl.id lsm_id
1739: ,tld.id tld_id

Line 1793: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1789: AND pph.payout_basis = 'FULL_RECEIPT'
1790: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1791: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1792: --added for evergreen change request 08_nov_2005
1793: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1794: OR
1795: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1796: --added for evergreen change request 08_nov_2005
1797: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1797: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1793: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1794: OR
1795: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1796: --added for evergreen change request 08_nov_2005
1797: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1798: AND arl.receivables_invoice_id = aps.customer_trx_id
1799: AND aps.class = 'INV'
1800: AND aps.status = 'CL'
1801: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)

Line 1809: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date

1805: NULL cnr_id
1806: ,arl.receivables_invoice_number
1807: ,tai.set_of_books_id
1808: ,arv.org_id
1809: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1810: ,arv.currency_code
1811: ,tai.khr_id
1812: ,til.kle_id
1813: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount

Line 1813: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount

1809: ,okl_pay_invoices_disb_pvt.receipt_date(arl.receivables_invoice_id) receipt_date
1810: ,arv.currency_code
1811: ,tai.khr_id
1812: ,til.kle_id
1813: ,okl_pay_invoices_disb_pvt.receipt_amount(arl.receivables_invoice_id) amount
1814: ,arl.sty_id
1815: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1816: -- ,arl.id lsm_id
1817: ,tld.id tld_id

Line 1878: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1874: AND pph.payout_basis = 'FULL_RECEIPT'
1875: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1876: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1877: --added for evergreen change request 08_nov_2005
1878: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1879: OR
1880: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1881: --added for evergreen change request 08_nov_2005
1882: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1882: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1878: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1879: OR
1880: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1881: --added for evergreen change request 08_nov_2005
1882: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1883: AND arl.receivables_invoice_id = aps.customer_trx_id
1884: AND aps.class = 'INV'
1885: AND aps.status = 'CL'
1886: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)

Line 1902: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date

1898: NULL cnr_id
1899: ,arl.receivables_invoice_number
1900: ,tai.set_of_books_id
1901: ,arv.org_id
1902: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1903: ,arv.currency_code
1904: ,tai.khr_id
1905: ,til.kle_id
1906: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

Line 1906: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

1902: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1903: ,arv.currency_code
1904: ,tai.khr_id
1905: ,til.kle_id
1906: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount
1907: ,arl.sty_id
1908: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1909: -- ,arl.id lsm_id
1910: ,tld.id tld_id

Line 1961: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0

1957: --commented for evergreen change request 08_nov_2005
1958: --AND kle.id = pph.cle_id
1959: AND kle.dnz_chr_id = pph.dnz_chr_id
1960: AND pph.payout_basis = 'PARTIAL_RECEIPT'
1961: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
1962: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1963: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1964: --added for evergreen change request 08_nov_2005
1965: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

Line 1965: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

1961: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
1962: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
1963: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
1964: --added for evergreen change request 08_nov_2005
1965: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1966: OR
1967: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1968: --added for evergreen change request 08_nov_2005
1969: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 1969: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

1965: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
1966: OR
1967: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
1968: --added for evergreen change request 08_nov_2005
1969: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
1970: AND arl.receivables_invoice_id = aps.customer_trx_id
1971: AND aps.class = 'INV'
1972: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
1973: AND NVL (TRUNC(p_to_date), SYSDATE+10000)

Line 1980: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date

1976: NULL cnr_id
1977: ,arl.receivables_invoice_number
1978: ,tai.set_of_books_id
1979: ,arv.org_id
1980: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1981: ,arv.currency_code
1982: ,tai.khr_id
1983: ,til.kle_id
1984: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

Line 1984: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount

1980: ,okl_pay_invoices_disb_pvt.partial_receipt_date(arl.receivables_invoice_id) partial_receipt_date
1981: ,arv.currency_code
1982: ,tai.khr_id
1983: ,til.kle_id
1984: ,okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) amount
1985: ,arl.sty_id
1986: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts starts
1987: -- ,arl.id lsm_id
1988: ,tld.id tld_id

Line 2045: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0

2041: --commented for evergreen change request 08_nov_2005
2042: --AND kle.id = pph.cle_id
2043: AND kle.dnz_chr_id = pph.dnz_chr_id
2044: AND pph.payout_basis = 'PARTIAL_RECEIPT'
2045: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2046: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2047: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2048: --added for evergreen change request 08_nov_2005
2049: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

Line 2049: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2045: AND okl_pay_invoices_disb_pvt.partial_receipt_amount(arl.receivables_invoice_id) <> 0
2046: AND trunc(arv.date_consolidated) >= trunc(NVL(pph.passthru_start_date, arv.date_consolidated))
2047: AND (trunc(arv.date_consolidated) <= trunc(kle.end_date) AND pph.passthru_term = 'BASE'
2048: --added for evergreen change request 08_nov_2005
2049: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2050: OR
2051: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2052: --added for evergreen change request 08_nov_2005
2053: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

Line 2053: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)

2049: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2050: OR
2051: trunc(arv.date_consolidated) > trunc(kle.end_date) AND pph.passthru_term = 'EVERGREEN'
2052: --added for evergreen change request 08_nov_2005
2053: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id)
2054: AND arl.receivables_invoice_id = aps.customer_trx_id
2055: AND aps.class = 'INV'
2056: AND trunc(arv.date_consolidated) BETWEEN NVL (TRUNC(p_from_date), SYSDATE-10000)
2057: AND NVL (TRUNC(p_to_date), SYSDATE+10000);

Line 2133: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2129: --commented for evergreen change request 08_nov_2005
2130: --AND kle.id = pph.cle_id
2131: AND kle.dnz_chr_id = pph.dnz_chr_id
2132: --added for evergreen change request 08_nov_2005
2133: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2134: AND pph.payout_basis = 'DUE_DATE'
2135: AND trunc(ste.stream_element_date) >= trunc(NVL(pph.passthru_start_date, ste.stream_element_date))
2136: AND trunc(ste.stream_element_date) <= trunc(kle.end_date)
2137: AND pph.passthru_term = 'BASE'

Line 2210: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id

2206: --commented for evergreen change request 08_nov_2005
2207: --AND kle.id = pph.cle_id
2208: AND kle.dnz_chr_id = pph.dnz_chr_id
2209: --added for evergreen change request 08_nov_2005
2210: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'BASE') = pph.id
2211: AND pph.payout_basis = 'DUE_DATE'
2212: AND trunc(ste.stream_element_date) >= trunc(NVL(pph.passthru_start_date, ste.stream_element_date))
2213: AND trunc(ste.stream_element_date) <= trunc(kle.end_date)
2214: AND pph.passthru_term = 'BASE';

Line 2265: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id

2261: --added for evergreen change request 08_nov_2005
2262: AND kle.lse_id = lse.id
2263: AND kle.dnz_chr_id = pph.dnz_chr_id
2264: --added for evergreen change request 08_nov_2005
2265: AND OKL_PAY_INVOICES_DISB_PVT.get_kle_party_pmt_hdr(kle.dnz_chr_id,kle.id,lse.lty_code,'EVERGREEN') = pph.id
2266: --commented for evergreen change request 08_nov_2005
2267: --AND kle.id = pph.cle_id
2268: AND pph.passthru_term = 'EVERGREEN'
2269: AND pph.payout_basis = 'FORMULA';

Line 2715: END OKL_PAY_INVOICES_DISB_PVT;

2711:
2712: END credit_check;
2713:
2714:
2715: END OKL_PAY_INVOICES_DISB_PVT;