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_LA_STREAM_PVT dependencies on OKL_STREAM_GENERATOR_PVT

Line 21: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

17: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: -- Start modification Bug#3066346 bakuchib
20: G_LLA_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
21: l_pay_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
22: -- End modification Bug#3066346 bakuchib
23: -- Variable put by HKPATEL for rollover quote
24: l_link_fee_asset_yn VARCHAR2(12) := 'NONE';
25: -- srsreeni - Bug#5699923 - Added - Start

Line 3326: okl_stream_generator_pvt.get_stream_elements(

3322:
3323: -- gboomina Bug 4746368 - Start
3324: -- calling get_stream_elements with l_pt_pro_fee_tbl parameter
3325: -- Added parameter p_recurrence_date by djanaswa for bug 6007644
3326: okl_stream_generator_pvt.get_stream_elements(
3327: p_start_date => l_inflow.start_date,
3328: p_periods => l_inflow.periods,
3329: p_frequency => l_inflow.frequency,
3330: p_structure => l_inflow.structure,

Line 3365: okl_stream_generator_pvt.get_stream_header(

3361: -- Put the code for bug 4203804
3362: --srsreeni bug 5869271 start add
3363: IF (l_old_cle_id IS NULL OR (l_old_cle_id <> l_inflow.cle_id OR l_old_sty_id <> l_inflow.sty_id)) THEN
3364: --srsreeni bug 5869271 end add
3365: okl_stream_generator_pvt.get_stream_header(
3366: p_khr_id => p_chr_id,
3367: p_kle_id => l_inflow.cle_id,
3368: p_sty_id => l_inflow.sty_id,
3369: p_purpose_code => l_purpose_code,

Line 3432: okl_stream_generator_pvt.get_accrual_elements(

3428: END IF;
3429: END IF;
3430: --srsreeni bug 5869271 end
3431:
3432: okl_stream_generator_pvt.get_accrual_elements(
3433: p_start_date => l_inflow.start_date,
3434: p_periods => l_inflow.periods,
3435: p_frequency => l_inflow.frequency,
3436: p_structure => l_inflow.structure,

Line 3493: okl_stream_generator_pvt.get_sty_details (

3489:
3490: END IF;
3491:
3492: /*
3493: okl_stream_generator_pvt.get_sty_details (
3494: p_sty_name => 'PASS THROUGH REVENUE ACCRUAL',
3495: x_sty_id => l_sty_id,
3496: x_sty_name => l_sty_name,
3497: x_return_status => x_return_status);

Line 3506: okl_stream_generator_pvt.get_stream_header(

3502: END IF;
3503: */
3504: -- Code commented and added for user defined streams ends here- HKPATEL
3505: IF(l_sty_id.id IS NOT NULL) THEN
3506: okl_stream_generator_pvt.get_stream_header(
3507: p_khr_id => p_chr_id,
3508: p_kle_id => l_inflow.cle_id,
3509: p_sty_id => l_sty_id.id,
3510: p_purpose_code => l_purpose_code,

Line 3595: -- (i.e. from OKL_STREAM_GENERATOR_PVT)

3591: --Created separate API for generating pass through expense accrual streams
3592: --As part of bug 8624532 by NIKSHAH
3593: --API NAME: GENERATE_PASSTHRU_EXP_STREAMS
3594: --This api will be called from ESG (i.e. the next call) and from ISG
3595: -- (i.e. from OKL_STREAM_GENERATOR_PVT)
3596: GENERATE_PASSTHRU_EXP_STREAMS
3597: (
3598: p_api_version => p_api_version
3599: ,p_init_msg_list => p_init_msg_list

Line 3617: -- okl_stream_generator_pvt.generate_streams, which calls OKL_LA_STREAM_PVT.GEN_PASSTHRU_SERV_EXP_STREAMS

3613:
3614: --sechawla 15-SEP-2010 10045043 : begin
3615: -- Generate passthru service expense accrual streams for ESG
3616: -- ISG call for generating these streams is in
3617: -- okl_stream_generator_pvt.generate_streams, which calls OKL_LA_STREAM_PVT.GEN_PASSTHRU_SERV_EXP_STREAMS
3618: GEN_PASSTHRU_SERV_EXP_STREAMS
3619: (
3620: p_api_version => p_api_version
3621: ,p_init_msg_list => p_init_msg_list

Line 3695: --sechawla 15-SEP-2010 10045043 : Modified okl_stream_generator_pvt.prosp_adj_acc_strms for

3691: ELSE
3692: l_purpose_code := 'REPORT';
3693: END IF;
3694:
3695: --sechawla 15-SEP-2010 10045043 : Modified okl_stream_generator_pvt.prosp_adj_acc_strms for
3696: --purpose PASS_THRU_SVC_EXP_ACCRUAL, which is used to generate Passthru Service Expense Accrual Streams
3697: okl_stream_generator_pvt.prosp_adj_acc_strms(
3698: p_api_version => p_api_version
3699: ,p_init_msg_list => p_init_msg_list

Line 3697: okl_stream_generator_pvt.prosp_adj_acc_strms(

3693: END IF;
3694:
3695: --sechawla 15-SEP-2010 10045043 : Modified okl_stream_generator_pvt.prosp_adj_acc_strms for
3696: --purpose PASS_THRU_SVC_EXP_ACCRUAL, which is used to generate Passthru Service Expense Accrual Streams
3697: okl_stream_generator_pvt.prosp_adj_acc_strms(
3698: p_api_version => p_api_version
3699: ,p_init_msg_list => p_init_msg_list
3700: ,p_rebook_type => l_rebook_type
3701: ,p_rebook_date => l_rebook_date

Line 3910: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(

3906: IF(l_frequency IS NULL) THEN
3907: l_frequency := l_payment_frequency;
3908: END IF;
3909:
3910: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(
3911: p_frequency => l_frequency,
3912: x_return_status => x_return_status);
3913: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
3914: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4035: okl_stream_generator_pvt.get_stream_header(

4031: x_return_status := 'S';
4032: END IF;
4033: END IF;
4034: IF(l_sty_id.id IS NOT NULL) THEN
4035: okl_stream_generator_pvt.get_stream_header(
4036: p_khr_id => p_chr_id,
4037: p_kle_id => l_lne_rec.id,
4038: p_sty_id => l_sty_id.id,
4039: p_purpose_code => l_purpose_code,

Line 4119: -- okl_stream_generator_pvt.generate_streams

4115: -- Procedure Name : GEN_PASSTHRU_SERV_EXP_STREAMS
4116: -- Description : This procedure creats passthrough service expense accrual streams which
4117: -- will be used for both ISG and ESG. For ESG, this procedure is called from
4118: -- okl_la_stream_pvt.adjust_passthrough_streams. For ISG, this procedure is called from
4119: -- okl_stream_generator_pvt.generate_streams
4120: -- Business Rules :
4121: -- Version : 1.0
4122: -- History : SECHAWLA 15-Sep-2010 - Bug# 10045043 Added new procedure GEN_PASSTHRU_SERV_EXP_STREAMS
4123:

Line 4239: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(

4235: --If disbursement frequency is null then take the service/fee payment frequency
4236: IF(l_frequency IS NULL) THEN
4237: l_frequency := l_payment_frequency;
4238: END IF;
4239: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(
4240: p_frequency => l_frequency,
4241: x_return_status => x_return_status);
4242: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
4243: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4366: okl_stream_generator_pvt.get_stream_header(

4362: x_return_status := 'S';
4363: END IF;
4364: END IF;
4365: IF(l_sty_id.id IS NOT NULL) THEN
4366: okl_stream_generator_pvt.get_stream_header(
4367: p_khr_id => p_chr_id,
4368: p_kle_id => l_lne_rec.id,
4369: p_sty_id => l_sty_id.id,
4370: p_purpose_code => l_purpose_code,

Line 11373: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(

11369: END IF;
11370:
11371: IF (r_pass.disbursement_basis = 'PERCENT' ) THEN
11372:
11373: l_months_factor := OKL_STREAM_GENERATOR_PVT.get_months_factor(
11374: p_frequency => l_frequency,
11375: x_return_status => x_return_status);
11376: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
11377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 23176: lx_contract_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;

23172: -- TYPE yields IS TABLE OF yields_rec_type INDEX BY BINARY_INTEGER;
23173: -- Start modification 11i10 bakuchib
23174: p_chr_yields yields_rec_type;
23175: -- end modification 11i10 bakuchib
23176: lx_contract_rates OKL_STREAM_GENERATOR_PVT.rate_rec_type;
23177:
23178: l_hdr_rec l_hdr_csr%ROWTYPE;
23179: p_pdtv_rec pdtv_rec_type;
23180: x_pdt_parameter_rec pdt_param_rec_type;

Line 23616: p_paym_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type)

23612: x_return_status OUT NOCOPY VARCHAR2,
23613: x_msg_count OUT NOCOPY NUMBER,
23614: x_msg_data OUT NOCOPY VARCHAR2,
23615: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
23616: p_paym_tbl IN OKL_STREAM_GENERATOR_PVT.payment_tbl_type)
23617: IS
23618: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PAYMENTS';
23619: G_APP_NAME VARCHAR2(30) := 'OKL';
23620: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 23746: l_paym_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type := p_paym_tbl;

23742: end_date okc_rules_b.last_update_date%TYPE := okl_api.G_MISS_DATE);
23743: TYPE sll_date_tbl_type IS TABLE OF sll_date_rec_type
23744: INDEX BY BINARY_INTEGER;
23745: lt_sll_date_tbl_type sll_date_tbl_type;
23746: l_paym_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type := p_paym_tbl;
23747: BEGIN
23748: l_return_status := OKL_API.START_ACTIVITY (
23749: l_api_name
23750: ,p_init_msg_list