DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_SEEDED_FUNCTIONS_PVT

Line 1735: x_value := OKL_SEEDED_FUNCTIONS_PVT.creditline_total_remaining(l_credit_id);

1731: l_row_found boolean := false;
1732: begin
1733: l_credit_id := OKL_CREDIT_PUB.get_creditline_by_chrid(p_contract_id);
1734: IF (l_credit_id IS NOT NULL) THEN
1735: x_value := OKL_SEEDED_FUNCTIONS_PVT.creditline_total_remaining(l_credit_id);
1736: ELSE
1737: x_value := 0;
1738: END IF;
1739:

Line 7536: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);

7532: -- Contract Trade In AND Contract Capitalized Reduction -- Downpayment
7533: --------------------------------------------------
7534: FOR l_kle_id IN c_kle_id(p_khr_id) LOOP
7535: BEGIN
7536: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);
7537:
7538: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7539: l_amount_buffer := 0;
7540: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN

Line 7552: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);

7548: l_amount := l_amount - l_amount_buffer;
7549:
7550: BEGIN
7551: IF ((l_kle_id.downpymnt_recvr IS NULL) OR (l_kle_id.downpymnt_recvr = 'VENDOR')) THEN
7552: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);
7553:
7554: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7555: l_amount_buffer := 0;
7556: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN

Line 7582: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => p_kle_id);

7578: --------------------------------------------------
7579: -- Contract Trade In
7580: --------------------------------------------------
7581: BEGIN
7582: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => p_kle_id);
7583:
7584: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7585: l_amount_buffer := 0;
7586: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN

Line 7607: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => p_kle_id);

7603: CLOSE downpymnt_recvr_csr;
7604:
7605: IF ((l_downpymnt_recvr IS NULL) OR (l_downpymnt_recvr = 'VENDOR')) THEN
7606: -- bug 5384359 -- end
7607: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => p_kle_id);
7608:
7609: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7610: l_amount_buffer := 0;
7611: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN

Line 7683: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => p_kle_id);

7679: CLOSE downpymnt_recvr_csr;
7680:
7681: IF ((l_downpymnt_recvr IS NULL) OR (l_downpymnt_recvr = 'VENDOR')) THEN
7682: -- bug 5402377 -- end
7683: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => p_kle_id);
7684:
7685: --END:| 27-Feb-2006 cklee -- Fixed bug#5003962 |
7686: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7687: l_amount_buffer := 0;

Line 7723: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => p_kle_id);

7719: p_line_id => p_kle_id,
7720: x_value => l_amount_buffer);
7721: */
7722: --skgautam Bug#5260198
7723: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => p_kle_id);
7724:
7725: --END:| 27-Feb-2006 cklee -- Fixed bug#5003962 |
7726: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
7727: l_amount_buffer := 0;

Line 9514: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);

9510: -- Contract Trade In AND Contract Capitalized Reduction -- Downpayment
9511: --------------------------------------------------
9512: /*FOR l_kle_id IN c_kle_id(p_khr_id) LOOP
9513: BEGIN
9514: l_amount_buffer := okl_seeded_functions_pvt.line_tradein(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);
9515:
9516: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
9517: l_amount_buffer := 0;
9518: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN

Line 9530: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);

9526: l_amount := l_amount - l_amount_buffer;
9527:
9528: BEGIN
9529: IF ((l_kle_id.downpymnt_recvr IS NULL) OR (l_kle_id.downpymnt_recvr = 'VENDOR')) THEN
9530: l_amount_buffer := okl_seeded_functions_pvt.line_capital_reduction(p_chr_id => p_khr_id, p_line_id => l_kle_id.kle_id);
9531:
9532: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
9533: l_amount_buffer := 0;
9534: ELSIF(x_return_status = okl_api.g_ret_sts_error) THEN