DBA Data[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on OKL_STREAM_GENERATOR_PVT

Line 7408: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

7404: p_khr_id IN NUMBER,
7405: p_kle_id IN NUMBER,
7406: p_rate_type IN VARCHAR2,
7407: p_target_param IN VARCHAR2,
7408: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7409: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7410: x_overall_rate OUT NOCOPY NUMBER,
7411: x_return_status OUT NOCOPY VARCHAR2,
7412: x_msg_count OUT NOCOPY NUMBER,

Line 7409: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

7405: p_kle_id IN NUMBER,
7406: p_rate_type IN VARCHAR2,
7407: p_target_param IN VARCHAR2,
7408: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7409: x_pay_tbl OUT NOCOPY OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
7410: x_overall_rate OUT NOCOPY NUMBER,
7411: x_return_status OUT NOCOPY VARCHAR2,
7412: x_msg_count OUT NOCOPY NUMBER,
7413: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 7514: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

7510: where language = 'US'
7511: and name = n;
7512:
7513: r_sty c_sty%ROWTYPE;
7514: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7515: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7516: l_sty_id NUMBER := -1;
7517:
7518: l_interim_interest NUMBER;

Line 7515: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

7511: and name = n;
7512:
7513: r_sty c_sty%ROWTYPE;
7514: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7515: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
7516: l_sty_id NUMBER := -1;
7517:
7518: l_interim_interest NUMBER;
7519: l_interim_days NUMBER;

Line 7655: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7651: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
7652: RAISE OKL_API.G_EXCEPTION_ERROR;
7653: END IF;
7654: -- Bug 4626837: End
7655: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7656: p_api_version => p_api_version,
7657: p_init_msg_list => p_init_msg_list,
7658: p_khr_id => p_khr_id,
7659: p_kle_id => p_kle_id,

Line 7765: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7761:
7762: If ( lt_pay_tbl.COUNT > 0 ) Then
7763:
7764:
7765: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7766: p_api_version => p_api_version,
7767: p_init_msg_list => p_init_msg_list,
7768: p_khr_id => p_khr_id,
7769: p_kle_id => r_fee.kleId,

Line 7816: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

7812: END LOOP;
7813:
7814: If ( lt_pay_tbl.COUNT > 0 ) Then
7815:
7816: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
7817: p_api_version => p_api_version,
7818: p_init_msg_list => p_init_msg_list,
7819: p_khr_id => p_khr_id,
7820: p_kle_id => l_kle_Id,

Line 8389: OKL_STREAM_GENERATOR_PVT.get_sched_principal_bal(

8385: FOR l_asset_cost IN c_asset_cost LOOP
8386:
8387: l_number_of_assets := l_number_of_assets + 1;
8388:
8389: OKL_STREAM_GENERATOR_PVT.get_sched_principal_bal(
8390: p_api_version => 1.0,
8391: p_init_msg_list => 'T',
8392: p_khr_id => p_khr_id,
8393: p_kle_id => l_asset_cost.id,

Line 8431: /*OKL_STREAM_GENERATOR_PVT.get_stream_elements(

8427: l_npv := l_npv + l_accumulated_int / POWER((1 + l_iir/l_ppy), l_periods);
8428:
8429: lx_selv_tbl.DELETE;
8430: -- Commented the code by djanaswa for bug 6007644
8431: /*OKL_STREAM_GENERATOR_PVT.get_stream_elements(
8432: p_start_date => p_pay_start_date,
8433: p_periods => p_term,
8434: p_frequency => p_frequency,
8435: p_structure => 0,

Line 9911: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,

9907: p_api_version IN NUMBER,
9908: p_init_msg_list IN VARCHAR2,
9909: p_khr_id IN NUMBER,
9910: p_kle_id IN NUMBER,
9911: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
9912: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,
9913: x_return_status OUT NOCOPY VARCHAR2,
9914: x_msg_count OUT NOCOPY NUMBER,
9915: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 9912: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,

9908: p_init_msg_list IN VARCHAR2,
9909: p_khr_id IN NUMBER,
9910: p_kle_id IN NUMBER,
9911: p_pay_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type,
9912: x_rates OUT NOCOPY OKL_STREAM_GENERATOR_PVT.rate_rec_type,
9913: x_return_status OUT NOCOPY VARCHAR2,
9914: x_msg_count OUT NOCOPY NUMBER,
9915: x_msg_data OUT NOCOPY VARCHAR2) IS
9916:

Line 9917: l_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;

9913: x_return_status OUT NOCOPY VARCHAR2,
9914: x_msg_count OUT NOCOPY NUMBER,
9915: x_msg_data OUT NOCOPY VARCHAR2) IS
9916:
9917: l_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;
9918:
9919: CURSOR c_hdr IS
9920: SELECT chr.template_yn,
9921: chr.currency_code,

Line 10018: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

10014: where language = 'US'
10015: and name = n;
10016:
10017: r_sty c_sty%ROWTYPE;
10018: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
10019: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
10020: l_sty_id NUMBER := -1;
10021:
10022: l_interim_interest NUMBER;

Line 10019: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

10015: and name = n;
10016:
10017: r_sty c_sty%ROWTYPE;
10018: lt_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
10019: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
10020: l_sty_id NUMBER := -1;
10021:
10022: l_interim_interest NUMBER;
10023: l_interim_days NUMBER;

Line 10185: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

10181: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
10182: RAISE OKL_API.G_EXCEPTION_ERROR;
10183: END IF;
10184: -- Bug 4626837 : End
10185: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
10186: p_api_version => p_api_version,
10187: p_init_msg_list => p_init_msg_list,
10188: p_khr_id => p_khr_id,
10189: p_kle_id => p_kle_id,

Line 10282: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

10278: Else
10279:
10280: If ( lt_pay_tbl.COUNT > 0 ) Then
10281:
10282: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
10283: p_api_version => p_api_version,
10284: p_init_msg_list => p_init_msg_list,
10285: p_khr_id => p_khr_id,
10286: p_kle_id => r_fee.kleId,

Line 10328: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(

10324: END LOOP;
10325:
10326: If ( lt_pay_tbl.COUNT > 0 ) Then
10327:
10328: OKL_STREAM_GENERATOR_PVT.generate_cash_flows(
10329: p_api_version => p_api_version,
10330: p_init_msg_list => p_init_msg_list,
10331: p_khr_id => p_khr_id,
10332: p_kle_id => l_kle_Id,

Line 10606: OKL_STREAM_GENERATOR_PVT.generate_quote_streams(

10602: set active_yn = 'N'
10603: where khr_id = p_khr_id
10604: and kle_id = p_kle_id;
10605:
10606: OKL_STREAM_GENERATOR_PVT.generate_quote_streams(
10607: p_api_version => p_api_version,
10608: p_init_msg_list => p_init_msg_list,
10609: p_khr_id => p_khr_id,
10610: p_kle_id => p_kle_id,

Line 10901: okl_stream_generator_pvt.get_stream_elements(

10897: l_recurrence_date := l_pay_level(i).start_date;
10898: END IF;
10899: --end djanaswa
10900: -- Added parameter p_recurrence_date by djanaswa for bug 6007644
10901: okl_stream_generator_pvt.get_stream_elements(
10902: p_start_date => l_pay_level(i).start_date,
10903: p_periods => l_pay_level(i).periods,
10904: p_frequency => l_pay_level(i).frequency,
10905: p_structure => l_pay_level(i).structure,