DBA Data[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on OKL_STREAM_GENERATOR_PVT

Line 7018: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

7014: p_khr_id IN NUMBER,
7015: p_kle_id IN NUMBER,
7016: p_rate_type IN VARCHAR2,
7017: p_target_param IN VARCHAR2,
7018: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7019: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7020: x_overall_rate OUT NOCOPY NUMBER,
7021: x_return_status OUT NOCOPY VARCHAR2,
7022: x_msg_count OUT NOCOPY NUMBER,

Line 7019: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

7015: p_kle_id IN NUMBER,
7016: p_rate_type IN VARCHAR2,
7017: p_target_param IN VARCHAR2,
7018: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7019: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7020: x_overall_rate OUT NOCOPY NUMBER,
7021: x_return_status OUT NOCOPY VARCHAR2,
7022: x_msg_count OUT NOCOPY NUMBER,
7023: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 7124: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

7120: where language = 'US'
7121: and name = n;
7122:
7123: r_sty c_sty%ROWTYPE;
7124: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7125: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7126: l_sty_id NUMBER := -1;
7127:
7128: l_interim_interest NUMBER;

Line 7125: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

7121: and name = n;
7122:
7123: r_sty c_sty%ROWTYPE;
7124: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7125: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7126: l_sty_id NUMBER := -1;
7127:
7128: l_interim_interest NUMBER;
7129: l_interim_days NUMBER;

Line 7265: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7261: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
7262: RAISE OKL_API.G_EXCEPTION_ERROR;
7263: END IF;
7264: -- Bug 4626837: End
7265: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7266: p_api_version => p_api_version,
7267: p_init_msg_list => p_init_msg_list,
7268: p_khr_id => p_khr_id,
7269: p_kle_id => p_kle_id,

Line 7375: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7371:
7372: If ( lt_pay_tbl.COUNT > 0 ) Then
7373:
7374:
7375: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7376: p_api_version => p_api_version,
7377: p_init_msg_list => p_init_msg_list,
7378: p_khr_id => p_khr_id,
7379: p_kle_id => r_fee.kleId,

Line 7426: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7422: END LOOP;
7423:
7424: If ( lt_pay_tbl.COUNT > 0 ) Then
7425:
7426: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7427: p_api_version => p_api_version,
7428: p_init_msg_list => p_init_msg_list,
7429: p_khr_id => p_khr_id,
7430: p_kle_id => l_kle_Id,

Line 7999: OKL_STREAM_GENERATOR_PVT.get_sched_principal_bal(

7995: FOR l_asset_cost IN c_asset_cost LOOP
7996:
7997: l_number_of_assets := l_number_of_assets + 1;
7998:
7999: OKL_STREAM_GENERATOR_PVT.get_sched_principal_bal(
8000: p_api_version => 1.0,
8001: p_init_msg_list => 'T',
8002: p_khr_id => p_khr_id,
8003: p_kle_id => l_asset_cost.id,

Line 8041: /*OKL_STREAM_GENERATOR_PVT.get_stream_elements(

8037: l_npv := l_npv + l_accumulated_int / POWER((1 + l_iir/l_ppy), l_periods);
8038:
8039: lx_selv_tbl.DELETE;
8040: -- Commented the code by djanaswa for bug 6007644
8041: /*OKL_STREAM_GENERATOR_PVT.get_stream_elements(
8042: p_start_date => p_pay_start_date,
8043: p_periods => p_term,
8044: p_frequency => p_frequency,
8045: p_structure => 0,

Line 9526: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

9522: p_api_version IN NUMBER,
9523: p_init_msg_list IN VARCHAR2,
9524: p_khr_id IN NUMBER,
9525: p_kle_id IN NUMBER,
9526: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
9527: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,
9528: x_return_status OUT NOCOPY VARCHAR2,
9529: x_msg_count OUT NOCOPY NUMBER,
9530: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 9527: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,

9523: p_init_msg_list IN VARCHAR2,
9524: p_khr_id IN NUMBER,
9525: p_kle_id IN NUMBER,
9526: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
9527: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,
9528: x_return_status OUT NOCOPY VARCHAR2,
9529: x_msg_count OUT NOCOPY NUMBER,
9530: x_msg_data OUT NOCOPY VARCHAR2) IS
9531:

Line 9532: l_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;

9528: x_return_status OUT NOCOPY VARCHAR2,
9529: x_msg_count OUT NOCOPY NUMBER,
9530: x_msg_data OUT NOCOPY VARCHAR2) IS
9531:
9532: l_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;
9533:
9534: CURSOR c_hdr IS
9535: SELECT chr.template_yn,
9536: chr.currency_code,

Line 9633: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

9629: where language = 'US'
9630: and name = n;
9631:
9632: r_sty c_sty%ROWTYPE;
9633: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
9634: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
9635: l_sty_id NUMBER := -1;
9636:
9637: l_interim_interest NUMBER;

Line 9634: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

9630: and name = n;
9631:
9632: r_sty c_sty%ROWTYPE;
9633: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
9634: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
9635: l_sty_id NUMBER := -1;
9636:
9637: l_interim_interest NUMBER;
9638: l_interim_days NUMBER;

Line 9800: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

9796: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
9797: RAISE OKL_API.G_EXCEPTION_ERROR;
9798: END IF;
9799: -- Bug 4626837 : End
9800: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
9801: p_api_version => p_api_version,
9802: p_init_msg_list => p_init_msg_list,
9803: p_khr_id => p_khr_id,
9804: p_kle_id => p_kle_id,

Line 9897: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

9893: Else
9894:
9895: If ( lt_pay_tbl.COUNT > 0 ) Then
9896:
9897: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
9898: p_api_version => p_api_version,
9899: p_init_msg_list => p_init_msg_list,
9900: p_khr_id => p_khr_id,
9901: p_kle_id => r_fee.kleId,

Line 9943: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

9939: END LOOP;
9940:
9941: If ( lt_pay_tbl.COUNT > 0 ) Then
9942:
9943: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
9944: p_api_version => p_api_version,
9945: p_init_msg_list => p_init_msg_list,
9946: p_khr_id => p_khr_id,
9947: p_kle_id => l_kle_Id,

Line 10228: OKL_STREAM_GENERATOR_PVT.generate_quote_streams(

10224: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
10225: where khr_id = p_khr_id
10226: and kle_id = p_kle_id;
10227:
10228: OKL_STREAM_GENERATOR_PVT.generate_quote_streams(
10229: p_api_version => p_api_version,
10230: p_init_msg_list => p_init_msg_list,
10231: p_khr_id => p_khr_id,
10232: p_kle_id => p_kle_id,

Line 10523: okl_stream_generator_pvt.get_stream_elements(

10519: l_recurrence_date := l_pay_level(i).start_date;
10520: END IF;
10521: --end djanaswa
10522: -- Added parameter p_recurrence_date by djanaswa for bug 6007644
10523: okl_stream_generator_pvt.get_stream_elements(
10524: p_start_date => l_pay_level(i).start_date,
10525: p_periods => l_pay_level(i).periods,
10526: p_frequency => l_pay_level(i).frequency,
10527: p_structure => l_pay_level(i).structure,