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_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_AM_LEASE_LOAN_TRMNT_PVT

Line 1: PACKAGE BODY OKL_AM_LEASE_LOAN_TRMNT_PVT AS

1: PACKAGE BODY OKL_AM_LEASE_LOAN_TRMNT_PVT AS
2: /* $Header: OKLRLLTB.pls 120.42.12010000.3 2008/10/20 18:37:23 apaul ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_lease_loan_trmnt_pvt.';

4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_lease_loan_trmnt_pvt.';
9:
10: -- Start of comments
11: --
12: -- Function Name : check_int_calc_done.

Line 668: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_TERMNT_QUOTE_PVT

664: -- Start of comments
665: --
666: -- Function Name : check_true_partial_quote.
667: -- Description : Returns Y if TRUE partial quote(some more assets); else N or NULL
668: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_TERMNT_QUOTE_PVT
669: -- Parameters :
670: -- Version : 1.0
671: -- History : RMUNJULU 3061751 27-AUG-2003 Created
672: --

Line 799: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT

795: -- Start of comments
796: --
797: -- Function Name : check_true_partial_quote.
798: -- Description : Returns Y if TRUE partial quote(some more assets); else N or NULL
799: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT
800: -- Parameters :
801: -- Version : 1.0
802: -- History : rmunjulu bug 4997075
803: --

Line 916: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT

912: -- Start of comments
913: --
914: -- Function Name : check_service_k_int_needed.
915: -- Description : Returns Y if Service Intergration needed; else N or NULL
916: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT
917: -- Parameters :
918: -- Version : 1.0
919: -- History : RMUNJULU 3061751 27-AUG-2003 Created
920: -- RMUNJULU 05-JAN-04 SERVICE K UPDATES

Line 1095: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_ASSET_DISPOSE_PVT, OKL_AM_ASSET_RETURN_PVT

1091: -- Start of comments
1092: --
1093: -- Procedure Name : service_k_integration
1094: -- Desciption : Do the service contract integration steps (checks + notifications)
1095: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_ASSET_DISPOSE_PVT, OKL_AM_ASSET_RETURN_PVT
1096: -- Parameters :
1097: -- Version : 1.0
1098: -- History : RMUNJULU 3061751 27-AUG-2003 Created
1099: -- : RMUNJULU 3061751 14-OCT-2003 Added code to get delink_yn from table

Line 3715: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

3711: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
3712:
3713: -- rmunjulu EDAT
3714: -- If quote exists then accnting date is quote accept date else sysdate
3715: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3716:
3717: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3718: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3719:

Line 3717: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

3713: -- rmunjulu EDAT
3714: -- If quote exists then accnting date is quote accept date else sysdate
3715: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3716:
3717: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3718: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3719:
3720: ELSE
3721:

Line 3718: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

3714: -- If quote exists then accnting date is quote accept date else sysdate
3715: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3716:
3717: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3718: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3719:
3720: ELSE
3721:
3722: l_quote_accpt_date := p_termination_date;

Line 3906: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

3902: CLOSE get_accel_till_csr ;
3903: --Bug 5852720 by srsreeni starts
3904: -- fix for bug -- 5610960 -- added below condition
3905: -- If quote exists then cancelation date is quote eff from date else sysdate
3906: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3907: --Bug 5852720 by srsreeni ends
3908: --akrangan Bug 5526955 fix start
3909: --Based on CHK_ACCRUAL_PREVIOUS_MNTH_YN setup
3910: --check accruals till quote eff date OR previous month last date

Line 4281: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN

4277: CLOSE check_accrual_previous_csr;
4278: --Bug 5852720 by akrangan starts
4279: -- fix for bug -- 5610960 -- added below condition
4280: -- If quote exists then cancelation date is quote eff from date else sysdate
4281: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4282: --Bug 5852720 by akrangan ends
4283: IF nvl(l_accrual_previous_mnth_yn,'N') = 'N' THEN
4284: l_acceleration_rec.accelerate_from_date := TRUNC(LAST_DAY(l_quote_eff_date) + 1);
4285: ELSE

Line 4967: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'

4963: THEN
4964: RAISE OKL_API.G_EXCEPTION_ERROR;
4965: END IF;
4966: -- If quote exists then accnting date is quote accept date else sysdate
4967: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
4968: THEN
4969: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4970: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4971: ELSE

Line 4969: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

4965: END IF;
4966: -- If quote exists then accnting date is quote accept date else sysdate
4967: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
4968: THEN
4969: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4970: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4971: ELSE
4972: l_quote_accpt_date := p_termination_date;
4973: l_quote_eff_date := p_termination_date;

Line 4970: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

4966: -- If quote exists then accnting date is quote accept date else sysdate
4967: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
4968: THEN
4969: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
4970: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
4971: ELSE
4972: l_quote_accpt_date := p_termination_date;
4973: l_quote_eff_date := p_termination_date;
4974: END IF;

Line 5533: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'N' THEN

5529: RAISE OKL_API.G_EXCEPTION_ERROR;
5530: END IF;
5531:
5532: -- expiration
5533: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'N' THEN
5534:
5535: -- If quote exists then accnting date is quote accept date else sysdate
5536: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5537: THEN

Line 5536: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'

5532: -- expiration
5533: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'N' THEN
5534:
5535: -- If quote exists then accnting date is quote accept date else sysdate
5536: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5537: THEN
5538: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5539: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5540: ELSE

Line 5538: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

5534:
5535: -- If quote exists then accnting date is quote accept date else sysdate
5536: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5537: THEN
5538: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5539: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5540: ELSE
5541: l_quote_accpt_date := p_termination_date;
5542: l_quote_eff_date := p_termination_date;

Line 5539: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

5535: -- If quote exists then accnting date is quote accept date else sysdate
5536: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5537: THEN
5538: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5539: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5540: ELSE
5541: l_quote_accpt_date := p_termination_date;
5542: l_quote_eff_date := p_termination_date;
5543: END IF;

Line 5813: END OKL_AM_LEASE_LOAN_TRMNT_PVT;

5809: '_PVT'
5810: );
5811: END process_loan_refunds;
5812:
5813: END OKL_AM_LEASE_LOAN_TRMNT_PVT;