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_FUNDING_PVT dependencies on OKL_FUNDING_PVT

Line 1: PACKAGE BODY OKL_FUNDING_PVT AS

1: PACKAGE BODY OKL_FUNDING_PVT AS
2: /* $Header: OKLCFUNB.pls 120.72.12020000.6 2013/04/02 12:30:01 racheruv ship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------

Line 185: -SUM(NVL(OKL_FUNDING_PVT.get_partial_subsidy_amount(tpl.KLE_ID, tpl.AMOUNT),0)) SUBSIDY_TOT_AMT

181: tap.ID TAP_ID,
182: tap.VENDOR_INVOICE_NUMBER,
183: tap.IPVS_ID,
184: tap.PAYMENT_METHOD_CODE,
185: -SUM(NVL(OKL_FUNDING_PVT.get_partial_subsidy_amount(tpl.KLE_ID, tpl.AMOUNT),0)) SUBSIDY_TOT_AMT
186: from okc_k_headers_b khr,
187: okl_trx_ap_invoices_b tap,
188: okl_txl_ap_inv_lns_all_b tpl
189: where khr.id = tpl.khr_id

Line 193: and OKL_FUNDING_PVT.get_partial_subsidy_amount(tpl.kle_id, tpl.amount) > 0

189: where khr.id = tpl.khr_id
190: and tap.id = tpl.tap_id
191: and tap.id = p_fund_id
192: and tap.funding_type_code = 'ASSET'
193: and OKL_FUNDING_PVT.get_partial_subsidy_amount(tpl.kle_id, tpl.amount) > 0
194: group by khr.ID,
195: khr.AUTHORING_ORG_ID,
196: khr.CURRENCY_CODE,
197: tap.VENDOR_INVOICE_NUMBER,

Line 379: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST(

375: /*
376: -------------------------------------------------------------------
377: -- create internal Accounting entry for each subsidy
378: -------------------------------------------------------------------
379: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST(
380: p_api_version => p_api_version,
381: p_init_msg_list => p_init_msg_list,
382: x_return_status => x_return_status,
383: x_msg_count => x_msg_count,

Line 412: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST(

408: --start:| 21-May-2007 cklee OKLR12B Accounting CR |
409: -------------------------------------------------------------------
410: -- create internal Accounting for a funding header
411: -------------------------------------------------------------------
412: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST(
413: p_api_version => p_api_version,
414: p_init_msg_list => p_init_msg_list,
415: x_return_status => x_return_status,
416: x_msg_count => x_msg_count,

Line 1445: l_amount := nvl(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_fund_id, l_funding_type_code),0);

1441: ELSE
1442:
1443: --- vpanwar 21/02/2007 changed
1444: -- /**
1445: l_amount := nvl(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_fund_id, l_funding_type_code),0);
1446: -- **
1447: OPEN c_amount(p_fund_line_id);
1448: FETCH c_amount INTO l_amount;
1449: CLOSE c_amount;

Line 2091: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN

2087:
2088:
2089: BEGIN
2090:
2091: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN
2092:
2093: l_amount := OKL_FUNDING_PVT.get_contract_line_amt(p_contract_id);
2094: END IF;
2095:

Line 2093: l_amount := OKL_FUNDING_PVT.get_contract_line_amt(p_contract_id);

2089: BEGIN
2090:
2091: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN
2092:
2093: l_amount := OKL_FUNDING_PVT.get_contract_line_amt(p_contract_id);
2094: END IF;
2095:
2096: RETURN l_amount;
2097: EXCEPTION

Line 2574: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN

2570: IF (l_amount IS NULL) THEN
2571: l_amount := 0;
2572: END IF;
2573:
2574: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
2575: l_amount := 0;
2576: END IF;
2577:
2578: RETURN l_amount;

Line 2857: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN

2853: l_amount := 0;
2854: END IF;
2855:
2856:
2857: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
2858: l_amount := 0;
2859: END IF;
2860:
2861: RETURN l_amount;

Line 3326: -- OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID)

3322:
3323: l_line_amt NUMBER := 0; --bug#5600694
3324:
3325: -- check FA line
3326: -- OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID)
3327: -- will return 0 if user has not been funded FA line yet
3328: -- sjalasut, modified the below cursor to have khr_id be referred from
3329: -- okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b. changes made
3330: -- as part of OKLR12B disbursements project

Line 3352: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0

3348: and b.id = c.TAP_ID
3349: and a.cle_id = c.kle_id
3350: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3351: and b.id = p_fund_id
3352: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3353: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3354: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3355:
3356:

Line 3353: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >

3349: and a.cle_id = c.kle_id
3350: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3351: and b.id = p_fund_id
3352: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3353: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3354: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3355:
3356:
3357: -- get current amount for Asset, Expense, or Supplier Retention

Line 3354: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */

3350: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3351: and b.id = p_fund_id
3352: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3353: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3354: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3355:
3356:
3357: -- get current amount for Asset, Expense, or Supplier Retention
3358:

Line 3597: l_line_amt := OKL_FUNDING_PVT.get_contract_line_amt(i.CHR_ID, i.CLE_ID, i.ipvs_id);

3593: */
3594: FOR i IN c_invalid_fund(p_tapv_rec.id)
3595: LOOP
3596:
3597: l_line_amt := OKL_FUNDING_PVT.get_contract_line_amt(i.CHR_ID, i.CLE_ID, i.ipvs_id);
3598:
3599: IF l_line_amt > 0
3600: AND OKL_FUNDING_PVT.get_contract_line_funded_amt(i.CHR_ID, i.CLE_ID) >
3601: l_line_amt

Line 3600: AND OKL_FUNDING_PVT.get_contract_line_funded_amt(i.CHR_ID, i.CLE_ID) >

3596:
3597: l_line_amt := OKL_FUNDING_PVT.get_contract_line_amt(i.CHR_ID, i.CLE_ID, i.ipvs_id);
3598:
3599: IF l_line_amt > 0
3600: AND OKL_FUNDING_PVT.get_contract_line_funded_amt(i.CHR_ID, i.CLE_ID) >
3601: l_line_amt
3602: THEN
3603: l_invalid_fund := i.ASSET_NUMBER;
3604: EXIT;

Line 3965: IF (okl_funding_pvt.is_chr_fundable_status(p_chr_id, p_funding_type_code) = 0) THEN

3961:
3962: BEGIN
3963:
3964: --Bug# 10156343
3965: IF (okl_funding_pvt.is_chr_fundable_status(p_chr_id, p_funding_type_code) = 0) THEN
3966:
3967: OPEN c_sts(p_chr_id);
3968: FETCH c_sts INTO l_status;
3969: CLOSE c_sts;

Line 5327: l_amount := OKL_FUNDING_PVT.get_contract_line_funded_amt(l_id, l_funding_type_code);

5323: l_INVOICE_TYPE;
5324: CLOSE c;
5325:
5326: -- set default
5327: l_amount := OKL_FUNDING_PVT.get_contract_line_funded_amt(l_id, l_funding_type_code);
5328: -- fill in all necessary attributes
5329: l_tapv_rec.id := l_id;
5330: l_tapv_rec.amount:= nvl(l_amount,0);
5331: l_tapv_rec.VENDOR_INVOICE_NUMBER := l_VENDOR_INVOICE_NUMBER;

Line 5939: IF (l_tapv_rec.FUNDING_TYPE_CODE = OKL_FUNDING_PVT.G_ASSET_TYPE_CODE) THEN

5935:
5936: -------------------------------------------------------------
5937: -- create subsidy entries for 11.5.10
5938: -------------------------------------------------------------
5939: IF (l_tapv_rec.FUNDING_TYPE_CODE = OKL_FUNDING_PVT.G_ASSET_TYPE_CODE) THEN
5940:
5941: create_fund_asset_subsidies(p_api_version => p_api_version,
5942: p_init_msg_list => p_init_msg_list,
5943: x_return_status => x_return_status,

Line 6344: okl_funding_pvt.get_contract_line_amt(

6340: SELECT a.cle_id cle_id,
6341: a.chr_id chr_id,
6342: a.asset_number kle_num,
6343: a.description kle_name,
6344: okl_funding_pvt.get_contract_line_amt(
6345: a.chr_id,
6346: a.cle_id,
6347: p_vendor_site_id
6348: ) kle_amt

Line 6720: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT

6716: --SELECT cle_id, KLE_AMT
6717: --FROM
6718: --(
6719: select a.cle_id,
6720: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6721: from OKL_ASSETS_LOV_UV A,
6722: OKL_TRX_AP_INVOICES_B b
6723: WHERE a.chr_id = b.khr_id
6724: AND b.ID = p_fund_id

Line 6849: OKL_FUNDING_PVT.SYNC_HEADER_AMOUNT(

6845: RAISE OKL_API.G_EXCEPTION_ERROR;
6846: END IF;
6847:
6848: -- sync funding header amount
6849: OKL_FUNDING_PVT.SYNC_HEADER_AMOUNT(
6850: p_api_version => p_api_version,
6851: p_init_msg_list => p_init_msg_list,
6852: x_return_status => x_return_status,
6853: x_msg_count => x_msg_count,

Line 6961: nvl(sum(OKL_FUNDING_PVT.get_contract_line_funded_amt(a.id,a.funding_type_code)),0)

6957: -- as part of OKLR12B disbursements project
6958: CURSOR c2 (p_contract_id NUMBER)
6959: IS
6960: select a.ipvs_id,
6961: nvl(sum(OKL_FUNDING_PVT.get_contract_line_funded_amt(a.id,a.funding_type_code)),0)
6962: from okl_trx_ap_invoices_b a
6963: ,okl_txl_ap_inv_lns_all_b b
6964: where a.id = b.tap_id
6965: and b.khr_id = p_contract_id

Line 7126: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST

7122: EXIT WHEN fund_line_csr%NOTFOUND;
7123: */
7124: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
7125:
7126: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST
7127: (p_api_version => p_api_version,
7128: p_init_msg_list => p_init_msg_list,
7129: x_return_status => x_return_status,
7130: x_msg_count => x_msg_count,

Line 8835: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN

8831: IF (l_amount IS NULL) THEN
8832: l_amount := 0;
8833: END IF;
8834:
8835: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
8836: l_amount := 0;
8837: END IF;
8838:
8839: RETURN l_amount;

Line 9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);

9329: ) IS
9330:
9331: BEGIN
9332:
9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);

Line 9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);

9330:
9331: BEGIN
9332:
9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);

Line 9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);

9331: BEGIN
9332:
9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);

Line 9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);

9332:
9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);

Line 9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);

9333: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);

Line 9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);

9334: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);

Line 9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);

9335: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9343:

Line 9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);

9336: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9343:
9344: --Bug# 15992711: This Variable will be used to display in UI Funding Summary section

Line 9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);

9337: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9343:
9344: --Bug# 15992711: This Variable will be used to display in UI Funding Summary section
9345: --Start Modification 120.67.12010000.8 Pratrao 4-Mar-2013

Line 9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);

9338: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9339: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9340: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9341: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9343:
9344: --Bug# 15992711: This Variable will be used to display in UI Funding Summary section
9345: --Start Modification 120.67.12010000.8 Pratrao 4-Mar-2013
9346: x_fnd_rec.TOTAL_RELEASE_ASSET_AMOUNT := OKL_FUNDING_PVT.GET_RELEASED_ASST_AMT(p_contract_id);

Line 9346: x_fnd_rec.TOTAL_RELEASE_ASSET_AMOUNT := OKL_FUNDING_PVT.GET_RELEASED_ASST_AMT(p_contract_id);

9342: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9343:
9344: --Bug# 15992711: This Variable will be used to display in UI Funding Summary section
9345: --Start Modification 120.67.12010000.8 Pratrao 4-Mar-2013
9346: x_fnd_rec.TOTAL_RELEASE_ASSET_AMOUNT := OKL_FUNDING_PVT.GET_RELEASED_ASST_AMT(p_contract_id);
9347: --Bug# 15992711 End Modification
9348:
9349:
9350: EXCEPTION

Line 9560: END OKL_FUNDING_PVT;

9556: RETURN l_amount;
9557: END get_released_asst_amt;
9558: --Bug# 15992711 End Modification
9559:
9560: END OKL_FUNDING_PVT;