DBA Data[Home] [Help]

APPS.OKL_CREDIT_PUB dependencies on OKL_CREDIT_PUB

Line 1: PACKAGE BODY OKL_CREDIT_PUB AS

1: PACKAGE BODY OKL_CREDIT_PUB AS
2: /* $Header: OKLPCRDB.pls 120.22.12020000.2 2012/08/07 12:46:59 racheruv ship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------

Line 5621: l_amount_add := nvl(OKL_CREDIT_PUB.get_total_credit_addition(p_contract_id),0);

5617: l_amount_reduce NUMBER := 0;
5618:
5619: BEGIN
5620:
5621: l_amount_add := nvl(OKL_CREDIT_PUB.get_total_credit_addition(p_contract_id),0);
5622: l_amount_new := nvl(OKL_CREDIT_PUB.get_total_credit_new_limit(p_contract_id),0);
5623: l_amount_reduce := nvl(OKL_CREDIT_PUB.get_total_credit_reduction(p_contract_id),0);
5624:
5625: l_amount := l_amount_new + l_amount_add - l_amount_reduce;

Line 5622: l_amount_new := nvl(OKL_CREDIT_PUB.get_total_credit_new_limit(p_contract_id),0);

5618:
5619: BEGIN
5620:
5621: l_amount_add := nvl(OKL_CREDIT_PUB.get_total_credit_addition(p_contract_id),0);
5622: l_amount_new := nvl(OKL_CREDIT_PUB.get_total_credit_new_limit(p_contract_id),0);
5623: l_amount_reduce := nvl(OKL_CREDIT_PUB.get_total_credit_reduction(p_contract_id),0);
5624:
5625: l_amount := l_amount_new + l_amount_add - l_amount_reduce;
5626:

Line 5623: l_amount_reduce := nvl(OKL_CREDIT_PUB.get_total_credit_reduction(p_contract_id),0);

5619: BEGIN
5620:
5621: l_amount_add := nvl(OKL_CREDIT_PUB.get_total_credit_addition(p_contract_id),0);
5622: l_amount_new := nvl(OKL_CREDIT_PUB.get_total_credit_new_limit(p_contract_id),0);
5623: l_amount_reduce := nvl(OKL_CREDIT_PUB.get_total_credit_reduction(p_contract_id),0);
5624:
5625: l_amount := l_amount_new + l_amount_add - l_amount_reduce;
5626:
5627: RETURN l_amount;

Line 5663: l_amount_credit_limit := nvl(OKL_CREDIT_PUB.get_total_credit_limit(p_contract_id),0);

5659:
5660: BEGIN
5661:
5662: --l_amount_funded := nvl(OKL_FUNDING_PVT.get_total_funded(p_contract_id),0);
5663: l_amount_credit_limit := nvl(OKL_CREDIT_PUB.get_total_credit_limit(p_contract_id),0);
5664:
5665: l_amount := l_amount_credit_limit - l_amount_funded;
5666:
5667: RETURN l_amount;

Line 6591: END OKL_CREDIT_PUB;

6587: END activate_credit;
6588: -- end: cklee 07/12/2005
6589:
6590:
6591: END OKL_CREDIT_PUB;