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.47.12020000.3 2012/07/31 18:56:45 gkadarka 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 690: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_TERMNT_QUOTE_PVT

686: -- Start of comments
687: --
688: -- Function Name : check_true_partial_quote.
689: -- Description : Returns Y if TRUE partial quote(some more assets); else N or NULL
690: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_TERMNT_QUOTE_PVT
691: -- Parameters :
692: -- Version : 1.0
693: -- History : RMUNJULU 3061751 27-AUG-2003 Created
694: --

Line 821: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT

817: -- Start of comments
818: --
819: -- Function Name : check_true_partial_quote.
820: -- Description : Returns Y if TRUE partial quote(some more assets); else N or NULL
821: -- Business Rules : CALLED FROM OKL_AM_LEASE_LOAN_TRMNT_PVT
822: -- Parameters :
823: -- Version : 1.0
824: -- History : rmunjulu bug 4997075
825: --

Line 938: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT

934: -- Start of comments
935: --
936: -- Function Name : check_service_k_int_needed.
937: -- Description : Returns Y if Service Intergration needed; else N or NULL
938: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT
939: -- Parameters :
940: -- Version : 1.0
941: -- History : RMUNJULU 3061751 27-AUG-2003 Created
942: -- RMUNJULU 05-JAN-04 SERVICE K UPDATES

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

1113: -- Start of comments
1114: --
1115: -- Procedure Name : service_k_integration
1116: -- Desciption : Do the service contract integration steps (checks + notifications)
1117: -- Business Rules : Called from OKL_AM_LEASE_LOAN_TRMNT_PVT, OKL_AM_ASSET_DISPOSE_PVT, OKL_AM_ASSET_RETURN_PVT
1118: -- Parameters :
1119: -- Version : 1.0
1120: -- History : RMUNJULU 3061751 27-AUG-2003 Created
1121: -- : RMUNJULU 3061751 14-OCT-2003 Added code to get delink_yn from table

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

3733: -- rmunjulu +++++++++ Effective Dated Termination -- start ++++++++++++++++
3734:
3735: -- rmunjulu EDAT
3736: -- If quote exists then accnting date is quote accept date else sysdate
3737: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3738:
3739: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3740: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3741:

Line 3739: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

3735: -- rmunjulu EDAT
3736: -- If quote exists then accnting date is quote accept date else sysdate
3737: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3738:
3739: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3740: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3741:
3742: ELSE
3743:

Line 3740: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

3736: -- If quote exists then accnting date is quote accept date else sysdate
3737: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3738:
3739: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
3740: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
3741:
3742: ELSE
3743:
3744: l_quote_accpt_date := p_termination_date;

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

3924: CLOSE get_accel_till_csr ;
3925: --Bug 5852720 by srsreeni starts
3926: -- fix for bug -- 5610960 -- added below condition
3927: -- If quote exists then cancelation date is quote eff from date else sysdate
3928: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
3929: --Bug 5852720 by srsreeni ends
3930: --akrangan Bug 5526955 fix start
3931: --Based on CHK_ACCRUAL_PREVIOUS_MNTH_YN setup
3932: --check accruals till quote eff date OR previous month last date

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

4299: CLOSE check_accrual_previous_csr;
4300: --Bug 5852720 by akrangan starts
4301: -- fix for bug -- 5610960 -- added below condition
4302: -- If quote exists then cancelation date is quote eff from date else sysdate
4303: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists,'N') = 'Y' THEN
4304: --Bug 5852720 by akrangan ends
4305: IF nvl(l_accrual_previous_mnth_yn,'N') = 'N' THEN
4306: l_acceleration_rec.accelerate_from_date := TRUNC(LAST_DAY(l_quote_eff_date) + 1);
4307: ELSE

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

5004: THEN
5005: RAISE OKL_API.G_EXCEPTION_ERROR;
5006: END IF;
5007: -- If quote exists then accnting date is quote accept date else sysdate
5008: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5009: THEN
5010: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5011: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5012: ELSE

Line 5010: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

5006: END IF;
5007: -- If quote exists then accnting date is quote accept date else sysdate
5008: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5009: THEN
5010: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5011: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5012: ELSE
5013: l_quote_accpt_date := p_termination_date;
5014: l_quote_eff_date := p_termination_date;

Line 5011: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

5007: -- If quote exists then accnting date is quote accept date else sysdate
5008: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5009: THEN
5010: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5011: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5012: ELSE
5013: l_quote_accpt_date := p_termination_date;
5014: l_quote_eff_date := p_termination_date;
5015: END IF;

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

5573: RAISE OKL_API.G_EXCEPTION_ERROR;
5574: END IF;
5575:
5576: -- expiration
5577: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'N' THEN
5578:
5579: -- If quote exists then accnting date is quote accept date else sysdate
5580: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5581: THEN

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

5576: -- expiration
5577: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'N' THEN
5578:
5579: -- If quote exists then accnting date is quote accept date else sysdate
5580: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5581: THEN
5582: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5583: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5584: ELSE

Line 5582: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;

5578:
5579: -- If quote exists then accnting date is quote accept date else sysdate
5580: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5581: THEN
5582: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5583: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5584: ELSE
5585: l_quote_accpt_date := p_termination_date;
5586: l_quote_eff_date := p_termination_date;

Line 5583: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;

5579: -- If quote exists then accnting date is quote accept date else sysdate
5580: IF nvl(okl_am_lease_loan_trmnt_pvt.g_quote_exists, 'N') = 'Y'
5581: THEN
5582: l_quote_accpt_date := okl_am_lease_loan_trmnt_pvt.g_quote_accept_date;
5583: l_quote_eff_date := okl_am_lease_loan_trmnt_pvt.g_quote_eff_from_date;
5584: ELSE
5585: l_quote_accpt_date := p_termination_date;
5586: l_quote_eff_date := p_termination_date;
5587: END IF;

Line 5857: END OKL_AM_LEASE_LOAN_TRMNT_PVT;

5853: '_PVT'
5854: );
5855: END process_loan_refunds;
5856:
5857: END OKL_AM_LEASE_LOAN_TRMNT_PVT;