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_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_CREATE_STREAMS_PUB

Line 2399: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;

2395: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
2396: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
2397: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
2398: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
2399: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:

Line 2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;

2396: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
2397: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
2398: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
2399: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:
2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

Line 2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;

2397: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
2398: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
2399: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:
2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
2405: l_reduce_residual_ptg_by NUMBER;

Line 2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;

2398: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
2399: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:
2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
2405: l_reduce_residual_ptg_by NUMBER;
2406: l_amount NUMBER := 0;

Line 2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

2400: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
2401: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
2402: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
2403:
2404: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
2405: l_reduce_residual_ptg_by NUMBER;
2406: l_amount NUMBER := 0;
2407: l_principal_amount NUMBER := 0;
2408: l_principal_balance NUMBER := 0;

Line 3304: /* l_csm_loan_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;

3300: l_csm_loan_header.jtot_object1_code := 'OKL_TRX_REQUESTS';
3301: l_csm_loan_header.object1_id1 := x_trqv_tbl(1).id;
3302:
3303: --rkuttiya commenting following lines of code for 11i OKL.H PPD Impacts of Variable Rate
3304: /* l_csm_loan_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;
3305:
3306: l_csm_loan_levels_tbl.delete;
3307:
3308: FOR i in 1..l_csm_loan_lines_tbl.COUNT LOOP

Line 3335: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;

3331: l_csm_loan_levels_tbl(knt).DESCRIPTION := 'Funding';
3332: l_csm_loan_levels_tbl(knt).date_start := l_csm_loan_header.date_start;
3333: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;
3334: l_csm_loan_levels_tbl(knt).level_index_number := l_index;
3335: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;
3336: l_csm_loan_levels_tbl(knt).amount := l_asset_cost;
3337: l_csm_loan_levels_tbl(knt).lock_level_step := NULL;
3338: l_csm_loan_levels_tbl(knt).period := NULL;
3339: l_csm_loan_levels_tbl(knt).advance_or_arrears := NULL;

Line 3356: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

3352: l_csm_loan_levels_tbl(knt).description := 'RENT';
3353: l_csm_loan_levels_tbl(knt).date_start := cur_rec.start_date + cur_rec.stub_days;
3354: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;
3355: l_csm_loan_levels_tbl(knt).level_index_number := l_index;
3356: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
3357: l_csm_loan_levels_tbl(knt).number_of_periods := 1;
3358: --In the CASE of ESG, the amount to be calculated is negated.
3359: --We are doing this because, we need to figure out whether
3360: --to lock the amount or rate or both when,

Line 3366: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;

3362: --is -ve, we lock the rate and set the amount back to positive,
3363: --if the amount is +ve,we lock Both and send the amount as is.
3364:
3365: IF cur_rec.stub_amount > 0 THEN
3366: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
3367: l_csm_loan_levels_tbl(knt).amount := cur_rec.stub_amount;
3368: ELSE
3369: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
3370: l_csm_loan_levels_tbl(knt).amount := -1 * NVL(cur_rec.stub_amount,0);

Line 3369: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;

3365: IF cur_rec.stub_amount > 0 THEN
3366: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
3367: l_csm_loan_levels_tbl(knt).amount := cur_rec.stub_amount;
3368: ELSE
3369: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
3370: l_csm_loan_levels_tbl(knt).amount := -1 * NVL(cur_rec.stub_amount,0);
3371: END IF;
3372: l_csm_loan_levels_tbl(knt).rate := l_iir;
3373: l_csm_loan_levels_tbl(knt).period := 'T';

Line 3375: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

3371: END IF;
3372: l_csm_loan_levels_tbl(knt).rate := l_iir;
3373: l_csm_loan_levels_tbl(knt).period := 'T';
3374: l_csm_loan_levels_tbl(knt).advance_or_arrears := cur_rec.advance_or_arrears;
3375: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
3376: l_csm_loan_levels_tbl(knt).structure := nvl(cur_rec.advance_payments,0);
3377: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
3378: ELSE
3379: l_csm_loan_levels_tbl(knt).description := 'RENT';

Line 3377: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

3373: l_csm_loan_levels_tbl(knt).period := 'T';
3374: l_csm_loan_levels_tbl(knt).advance_or_arrears := cur_rec.advance_or_arrears;
3375: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
3376: l_csm_loan_levels_tbl(knt).structure := nvl(cur_rec.advance_payments,0);
3377: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
3378: ELSE
3379: l_csm_loan_levels_tbl(knt).description := 'RENT';
3380: l_csm_loan_levels_tbl(knt).date_start := cur_rec.start_date;
3381: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;

Line 3383: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

3379: l_csm_loan_levels_tbl(knt).description := 'RENT';
3380: l_csm_loan_levels_tbl(knt).date_start := cur_rec.start_date;
3381: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;
3382: l_csm_loan_levels_tbl(knt).level_index_number := l_index;
3383: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
3384: l_csm_loan_levels_tbl(knt).number_of_periods := cur_rec.number_of_periods;
3385: --In the CASE of ESG, the amount to be calculated is negated.
3386: --We are doing this because, we need to figure out whether
3387: --to lock the amount or rate or both when,

Line 3392: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;

3388: --sending the params to Pricing using ESG. So, if the amount
3389: --is -ve, we lock the rate and set the amount back to positive,
3390: --if the amount is +ve,we lock Both and send the amount as is.
3391: IF cur_rec.amount > 0 THEN
3392: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
3393: l_csm_loan_levels_tbl(knt).amount := cur_rec.amount;
3394: ELSE
3395: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
3396: l_csm_loan_levels_tbl(knt).amount := -1 * NVL(cur_rec.amount,0);

Line 3395: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;

3391: IF cur_rec.amount > 0 THEN
3392: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
3393: l_csm_loan_levels_tbl(knt).amount := cur_rec.amount;
3394: ELSE
3395: l_csm_loan_levels_tbl(knt).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
3396: l_csm_loan_levels_tbl(knt).amount := -1 * NVL(cur_rec.amount,0);
3397: END IF;
3398: l_csm_loan_levels_tbl(knt).rate := l_iir;
3399: l_csm_loan_levels_tbl(knt).period := cur_rec.frequency_code;

Line 3401: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

3397: END IF;
3398: l_csm_loan_levels_tbl(knt).rate := l_iir;
3399: l_csm_loan_levels_tbl(knt).period := cur_rec.frequency_code;
3400: l_csm_loan_levels_tbl(knt).advance_or_arrears := cur_rec.advance_or_arrears;
3401: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
3402: l_csm_loan_levels_tbl(knt).structure :=nvl(cur_rec.advance_payments,0);
3403: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
3404: END IF;
3405: END LOOP;

Line 3403: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

3399: l_csm_loan_levels_tbl(knt).period := cur_rec.frequency_code;
3400: l_csm_loan_levels_tbl(knt).advance_or_arrears := cur_rec.advance_or_arrears;
3401: l_csm_loan_levels_tbl(knt).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
3402: l_csm_loan_levels_tbl(knt).structure :=nvl(cur_rec.advance_payments,0);
3403: l_csm_loan_levels_tbl(knt).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
3404: END IF;
3405: END LOOP;
3406: --Open the cursor and get the PPD payments that
3407: --have happenned before this PPD.

Line 3418: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;

3414: l_csm_loan_levels_tbl(knt).DESCRIPTION := 'Funding';
3415: l_csm_loan_levels_tbl(knt).date_start := cur_rec.start_date;
3416: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;
3417: l_csm_loan_levels_tbl(knt).level_index_number := l_index;
3418: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;
3419: l_csm_loan_levels_tbl(knt).lock_level_step := NULL;
3420: l_csm_loan_levels_tbl(knt).period := NULL;
3421: l_csm_loan_levels_tbl(knt).advance_or_arrears := NULL;
3422: l_csm_loan_levels_tbl(knt).income_or_expense := NULL;

Line 3436: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;

3432: l_csm_loan_levels_tbl(knt).DESCRIPTION := 'Funding';
3433: l_csm_loan_levels_tbl(knt).date_start := x_trqv_tbl(1).payment_date;
3434: l_csm_loan_levels_tbl(knt).kle_loan_id := l_csm_loan_lines_tbl(i).kle_loan_id;
3435: l_csm_loan_levels_tbl(knt).level_index_number := l_index;
3436: l_csm_loan_levels_tbl(knt).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_FUNDING;
3437: l_csm_loan_levels_tbl(knt).lock_level_step := NULL;
3438: l_csm_loan_levels_tbl(knt).period := NULL;
3439: l_csm_loan_levels_tbl(knt).advance_or_arrears := NULL;
3440: l_csm_loan_levels_tbl(knt).income_or_expense := NULL;

Line 3487: Okl_Create_Streams_Pub.Create_Streams_Loan_Restr(p_api_version => p_api_version,

3483: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3484: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling ESG streams');
3485: END IF;
3486: --Call the Create streams
3487: Okl_Create_Streams_Pub.Create_Streams_Loan_Restr(p_api_version => p_api_version,
3488: p_init_msg_list => p_init_msg_list,
3489: p_skip_prc_engine => l_skip_prc_engine,
3490: p_csm_loan_header => l_csm_loan_header,
3491: p_csm_loan_lines_tbl => l_csm_loan_lines_tbl,