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.67.12010000.2 2008/08/06 18:12:35 cklee 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 2065: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN

2061:
2062:
2063: BEGIN
2064:
2065: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN
2066:
2067: l_amount := OKL_FUNDING_PVT.get_contract_line_amt(p_contract_id);
2068: END IF;
2069:

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

2063: BEGIN
2064:
2065: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 1) THEN
2066:
2067: l_amount := OKL_FUNDING_PVT.get_contract_line_amt(p_contract_id);
2068: END IF;
2069:
2070: RETURN l_amount;
2071: EXCEPTION

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

2503: IF (l_amount IS NULL) THEN
2504: l_amount := 0;
2505: END IF;
2506:
2507: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
2508: l_amount := 0;
2509: END IF;
2510:
2511: RETURN l_amount;

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

2742: l_amount := 0;
2743: END IF;
2744:
2745:
2746: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
2747: l_amount := 0;
2748: END IF;
2749:
2750: RETURN l_amount;

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

3192:
3193: l_line_amt NUMBER := 0; --bug#5600694
3194:
3195: -- check FA line
3196: -- OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID)
3197: -- will return 0 if user has not been funded FA line yet
3198: -- sjalasut, modified the below cursor to have khr_id be referred from
3199: -- okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b. changes made
3200: -- as part of OKLR12B disbursements project

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

3218: and b.id = c.TAP_ID
3219: and a.cle_id = c.kle_id
3220: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3221: and b.id = p_fund_id
3222: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3223: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3224: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3225:
3226:

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

3219: and a.cle_id = c.kle_id
3220: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3221: and b.id = p_fund_id
3222: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3223: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3224: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3225:
3226:
3227: -- get current amount for Asset, Expense, or Supplier Retention

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

3220: --END:| 13-Apr-2006 cklee -- Fixed bug#5160342 |
3221: and b.id = p_fund_id
3222: and OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) > 0
3223: and OKL_FUNDING_PVT.get_contract_line_funded_amt(a.CHR_ID, a.CLE_ID) >
3224: OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id); */
3225:
3226:
3227: -- get current amount for Asset, Expense, or Supplier Retention
3228:

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

3463: */
3464: FOR i IN c_invalid_fund(p_tapv_rec.id)
3465: LOOP
3466:
3467: l_line_amt := OKL_FUNDING_PVT.get_contract_line_amt(i.CHR_ID, i.CLE_ID, i.ipvs_id);
3468:
3469: IF l_line_amt > 0
3470: AND OKL_FUNDING_PVT.get_contract_line_funded_amt(i.CHR_ID, i.CLE_ID) >
3471: l_line_amt

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

3466:
3467: l_line_amt := OKL_FUNDING_PVT.get_contract_line_amt(i.CHR_ID, i.CLE_ID, i.ipvs_id);
3468:
3469: IF l_line_amt > 0
3470: AND OKL_FUNDING_PVT.get_contract_line_funded_amt(i.CHR_ID, i.CLE_ID) >
3471: l_line_amt
3472: THEN
3473: l_invalid_fund := i.ASSET_NUMBER;
3474: EXIT;

Line 3832: IF (okl_funding_pvt.is_chr_fundable_status(p_chr_id) = 0) THEN

3828: ;
3829:
3830: BEGIN
3831:
3832: IF (okl_funding_pvt.is_chr_fundable_status(p_chr_id) = 0) THEN
3833:
3834: OPEN c_sts(p_chr_id);
3835: FETCH c_sts INTO l_status;
3836: CLOSE c_sts;

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

5186: l_INVOICE_TYPE;
5187: CLOSE c;
5188:
5189: -- set default
5190: l_amount := OKL_FUNDING_PVT.get_contract_line_funded_amt(l_id, l_funding_type_code);
5191: -- fill in all necessary attributes
5192: l_tapv_rec.id := l_id;
5193: l_tapv_rec.amount:= nvl(l_amount,0);
5194: l_tapv_rec.VENDOR_INVOICE_NUMBER := l_VENDOR_INVOICE_NUMBER;

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

5778:
5779: -------------------------------------------------------------
5780: -- create subsidy entries for 11.5.10
5781: -------------------------------------------------------------
5782: IF (l_tapv_rec.FUNDING_TYPE_CODE = OKL_FUNDING_PVT.G_ASSET_TYPE_CODE) THEN
5783:
5784: create_fund_asset_subsidies(p_api_version => p_api_version,
5785: p_init_msg_list => p_init_msg_list,
5786: x_return_status => x_return_status,

Line 6187: okl_funding_pvt.get_contract_line_amt(

6183: SELECT a.cle_id cle_id,
6184: a.chr_id chr_id,
6185: a.asset_number kle_num,
6186: a.description kle_name,
6187: okl_funding_pvt.get_contract_line_amt(
6188: a.chr_id,
6189: a.cle_id,
6190: p_vendor_site_id
6191: ) kle_amt

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

6559: --SELECT cle_id, KLE_AMT
6560: --FROM
6561: --(
6562: select a.cle_id,
6563: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6564: from OKL_ASSETS_LOV_UV A,
6565: OKL_TRX_AP_INVOICES_B b
6566: WHERE a.chr_id = b.khr_id
6567: AND b.ID = p_fund_id

Line 6692: OKL_FUNDING_PVT.SYNC_HEADER_AMOUNT(

6688: RAISE OKL_API.G_EXCEPTION_ERROR;
6689: END IF;
6690:
6691: -- sync funding header amount
6692: OKL_FUNDING_PVT.SYNC_HEADER_AMOUNT(
6693: p_api_version => p_api_version,
6694: p_init_msg_list => p_init_msg_list,
6695: x_return_status => x_return_status,
6696: x_msg_count => x_msg_count,

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

6800: -- as part of OKLR12B disbursements project
6801: CURSOR c2 (p_contract_id NUMBER)
6802: IS
6803: select a.ipvs_id,
6804: nvl(sum(OKL_FUNDING_PVT.get_contract_line_funded_amt(a.id,a.funding_type_code)),0)
6805: from okl_trx_ap_invoices_b a
6806: ,okl_txl_ap_inv_lns_all_b b
6807: where a.id = b.tap_id
6808: and b.khr_id = p_contract_id

Line 6969: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST

6965: EXIT WHEN fund_line_csr%NOTFOUND;
6966: */
6967: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
6968:
6969: OKL_FUNDING_PVT.CREATE_ACCOUNTING_DIST
6970: (p_api_version => p_api_version,
6971: p_init_msg_list => p_init_msg_list,
6972: x_return_status => x_return_status,
6973: x_msg_count => x_msg_count,

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

8609: IF (l_amount IS NULL) THEN
8610: l_amount := 0;
8611: END IF;
8612:
8613: IF (okl_funding_pvt.is_chr_fundable_status(p_contract_id) = 0) THEN
8614: l_amount := 0;
8615: END IF;
8616:
8617: RETURN l_amount;

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

9106: x_fnd_rec OUT NOCOPY fnd_rec_type
9107: ) IS
9108:
9109: BEGIN
9110: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);

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

9107: ) IS
9108:
9109: BEGIN
9110: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);

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

9108:
9109: BEGIN
9110: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);

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

9109: BEGIN
9110: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);

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

9110: x_fnd_rec.TOTAL_FUNDABLE_AMOUNT := OKL_FUNDING_PVT.get_chr_canbe_funded(p_contract_id);
9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);

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

9111: x_fnd_rec.TOTAL_PRE_FUNDED := OKL_FUNDING_PVT.get_amount_prefunded(p_contract_id);
9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9119: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);

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

9112: x_fnd_rec.TOTAL_ASSETS_FUNDED := OKL_FUNDING_PVT.get_chr_oec_hasbeen_funded_amt(p_contract_id);
9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9119: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9120:

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

9113: x_fnd_rec.TOTAL_EXPENSES_FUNDED := OKL_FUNDING_PVT.get_chr_exp_hasbeen_funded_amt(p_contract_id);
9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9119: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9120:
9121:

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

9114: x_fnd_rec.TOTAL_ADJUSTMENTS := OKL_FUNDING_PVT.get_chr_funded_adjs(p_contract_id);
9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9119: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9120:
9121:
9122:

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

9115: x_fnd_rec.TOTAL_REMAINING_TO_FUND := OKL_FUNDING_PVT.get_chr_canbe_funded_rem(p_contract_id);
9116: x_fnd_rec.TOTAL_SUPPLIER_RETENTION := OKL_FUNDING_PVT.get_total_retention(p_contract_id);
9117: x_fnd_rec.TOTAL_BORROWER_PAYMENTS := OKL_FUNDING_PVT.get_amount_borrowerPay(p_contract_id);
9118: x_fnd_rec.TOTAL_SUBSIDIES_FUNDED := OKL_FUNDING_PVT.get_amount_subsidy(p_contract_id);
9119: x_fnd_rec.TOTAL_MANUAL_DISBURSEMENT := OKL_FUNDING_PVT.get_amount_manu_disb(p_contract_id);
9120:
9121:
9122:
9123: EXCEPTION

Line 9135: END OKL_FUNDING_PVT;

9131: -- END, PROCEDURE to get Funding Summary
9132: */
9133:
9134:
9135: END OKL_FUNDING_PVT;