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_VARIABLE_INTEREST_PVT dependencies on OKL_STREAMS

Line 945: okl_streams stm,

941: from
942: okl_K_lines_full_v kle,
943: okc_statuses_b sts,
944: okl_strm_elements sel,
945: okl_streams stm,
946: okl_strm_type_b sty
947: WHERE kle.dnz_chr_id = p_chr_id
948: AND kle.id = p_kle_id
949: AND kle.sts_code = sts.code

Line 966: okl_streams str,

962:
963: Cursor l_chr_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2) IS
964: SELECT NVL(SUM(sele.amount),0) amount
965: FROM okl_strm_elements sele,
966: okl_streams str,
967: okl_strm_type_b sty
968: WHERE sele.stm_id = str.id
969: AND str.sty_id = sty.id
970: AND sty.stream_type_purpose = 'RENT'

Line 1046: okl_streams stm,

1042: from
1043: okl_K_lines_full_v kle,
1044: okc_statuses_b sts,
1045: okl_strm_elements sel,
1046: okl_streams stm,
1047: okl_strm_type_b sty
1048: WHERE kle.dnz_chr_id = p_chr_id
1049: AND kle.id = p_kle_id
1050: AND kle.sts_code = sts.code

Line 1510: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty

1506: c_khr_type_rec c_khr_type%ROWTYPE;
1507:
1508: /* CURSOR c_principal_bal_cur(p_contract_id NUMBER, p_bal_date DATE) IS
1509: SELECT sum(sel.amount) amount
1510: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty
1511: WHERE stm.khr_id = p_contract_id
1512: AND stm.active_yn = 'Y'
1513: AND stm.say_code = 'CURR'
1514: AND sty.id = stm.sty_id

Line 1518: FROM okl_strm_elements sel,okl_streams stm,

1514: AND sty.id = stm.sty_id
1515: AND sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
1516: AND sel.stm_id = stm.id
1517: and trunc(sel.stream_element_date) = ( select trunc(max(sel.stream_element_date))
1518: FROM okl_strm_elements sel,okl_streams stm,
1519: okl_strm_type_b sty
1520: WHERE stm.khr_id = p_contract_id
1521: AND stm.active_yn = 'Y'
1522: AND stm.say_code = 'CURR'

Line 1530: FROM okl_strm_elements sel,okl_streams stm,

1526: and trunc(sel.stream_element_date) <= p_bal_date);
1527:
1528: CURSOR c_stream_date_arr(p_contract_id NUMBER, p_bal_date DATE) IS
1529: select trunc(min(sel.stream_element_date))
1530: FROM okl_strm_elements sel,okl_streams stm,
1531: okl_strm_type_b sty
1532: WHERE stm.khr_id = p_contract_id
1533: AND stm.active_yn = 'Y'
1534: AND stm.say_code = 'CURR'

Line 1914: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty,

1910: AND val.datetime_valid < p_end_date);
1911:
1912: CURSOR c_calc_start_date (c_contract_id NUMBER)IS
1913: select min(sel.stream_element_date)
1914: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty,
1915: okl_k_headers khr, okc_k_headers_b chr
1916: WHERE stm.khr_id = c_contract_id
1917: AND stm.active_yn = 'Y'
1918: AND stm.say_code = 'CURR'

Line 2323: FROM okl_streams stm

2319: ORDER BY khr.deal_type, chr.contract_number;
2320:
2321: CURSOR c_strm_elements1(p_khr_id NUMBER, p_sty_id NUMBER) IS
2322: SELECT stm.id
2323: FROM okl_streams stm
2324: WHERE stm.khr_id = p_khr_id
2325: AND stm.sty_id = p_sty_id;
2326:
2327: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS

Line 2385: u_selv_rec Okl_Streams_Pub.selv_rec_type;

2381: l_init_tldv_rec Okl_Txd_Ar_Ln_Dtls_Pub.tldv_rec_type;
2382: r_tldv_rec Okl_Txd_Ar_Ln_Dtls_Pub.tldv_rec_type;
2383:
2384: -- Stream elements
2385: u_selv_rec Okl_Streams_Pub.selv_rec_type;
2386: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
2387: r_selv_rec Okl_Streams_Pub.selv_rec_type;
2388:
2389: ------------------------------------------------------------

Line 2386: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;

2382: r_tldv_rec Okl_Txd_Ar_Ln_Dtls_Pub.tldv_rec_type;
2383:
2384: -- Stream elements
2385: u_selv_rec Okl_Streams_Pub.selv_rec_type;
2386: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
2387: r_selv_rec Okl_Streams_Pub.selv_rec_type;
2388:
2389: ------------------------------------------------------------
2390: -- Declare records

Line 2387: r_selv_rec Okl_Streams_Pub.selv_rec_type;

2383:
2384: -- Stream elements
2385: u_selv_rec Okl_Streams_Pub.selv_rec_type;
2386: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
2387: r_selv_rec Okl_Streams_Pub.selv_rec_type;
2388:
2389: ------------------------------------------------------------
2390: -- Declare records
2391: ------------------------------------------------------------

Line 2395: l_selv_rec Okl_Streams_Pub.selv_rec_type;

2391: ------------------------------------------------------------
2392: l_interest_rec interest_rec;
2393: lx_interest_rec interest_rec;
2394: e_interest_rec interest_rec;
2395: l_selv_rec Okl_Streams_Pub.selv_rec_type;
2396: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
2397: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2398: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2399: l_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 2396: lx_selv_rec Okl_Streams_Pub.selv_rec_type;

2392: l_interest_rec interest_rec;
2393: lx_interest_rec interest_rec;
2394: e_interest_rec interest_rec;
2395: l_selv_rec Okl_Streams_Pub.selv_rec_type;
2396: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
2397: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2398: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2399: l_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
2400: lx_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 2397: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2393: lx_interest_rec interest_rec;
2394: e_interest_rec interest_rec;
2395: l_selv_rec Okl_Streams_Pub.selv_rec_type;
2396: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
2397: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2398: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2399: l_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
2400: lx_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
2401: l_tilv_rec Okl_Txl_Ar_Inv_Lns_Pub.tilv_rec_type;

Line 2398: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

2394: e_interest_rec interest_rec;
2395: l_selv_rec Okl_Streams_Pub.selv_rec_type;
2396: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
2397: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2398: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
2399: l_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
2400: lx_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
2401: l_tilv_rec Okl_Txl_Ar_Inv_Lns_Pub.tilv_rec_type;
2402: lx_tilv_rec Okl_Txl_Ar_Inv_Lns_Pub.tilv_rec_type;

Line 2466: Okl_Streams_Util.get_primary_stream_type(

2462: ||r_contracts_csr.date_last_interim_interest_cal);
2463:
2464:
2465: -- Get sty_id for the contract
2466: Okl_Streams_Util.get_primary_stream_type(
2467: p_khr_id => r_contracts_csr.khr_id,
2468: p_primary_sty_purpose => 'VARIABLE_INTEREST',
2469: x_return_status => l_return_status,
2470: x_primary_sty_id => l_sty_id );

Line 2880: Okl_Streams_Pub.create_streams(

2876: l_stmv_rec.active_yn := 'Y';
2877: l_stmv_rec.date_current := sysdate;
2878: l_stmv_rec.comments := 'Variable Interest';
2879:
2880: Okl_Streams_Pub.create_streams(
2881: p_api_version => p_api_version,
2882: p_init_msg_list => p_init_msg_list,
2883: x_return_status => x_return_status,
2884: x_msg_count => x_msg_count,

Line 2929: Okl_Streams_Pub.create_stream_elements(

2925: l_selv_rec.se_line_number := l_selv_rec.se_line_number+1;
2926: end if;
2927: CLOSE c_stm_id_line_number;
2928:
2929: Okl_Streams_Pub.create_stream_elements(
2930: p_api_version => p_api_version,
2931: p_init_msg_list => p_init_msg_list,
2932: x_return_status => x_return_status,
2933: x_msg_count => x_msg_count,

Line 3212: ,okl_streams_v stm_int_pmt

3208: Cursor stream_element_interest_csr (p_line_id NUMBER,
3209: p_stream_element_date DATE) IS
3210: SELECT nvl(sel_int_pmt.amount, 0) interest
3211: FROM okl_strm_type_v sty_int_pmt
3212: ,okl_streams_v stm_int_pmt
3213: ,okl_strm_elements_v sel_int_pmt
3214: WHERE stm_int_pmt.kle_id = p_line_id
3215: AND stm_int_pmt.id = sel_int_pmt.stm_id
3216: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 3226: ,okl_streams_v stm_prin_pmt

3222: Cursor stream_element_principal_csr (p_line_id NUMBER,
3223: p_stream_element_date DATE) IS
3224: SELECT nvl(sel_prin_pmt.amount, 0) principal
3225: FROM okl_strm_type_v sty_prin_pmt
3226: ,okl_streams_v stm_prin_pmt
3227: ,okl_strm_elements_v sel_prin_pmt
3228: WHERE stm_prin_pmt.kle_id = p_line_id
3229: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3230: AND sel_prin_pmt.stream_element_date = p_stream_element_date

Line 3298: ,okl_streams_v stm_int_pmt

3294: Cursor strm_elem_int_line_csr (p_line_id NUMBER,
3295: p_stream_element_date DATE) IS
3296: SELECT nvl(sel_int_pmt.amount, 0) interest
3297: FROM okl_strm_type_v sty_int_pmt
3298: ,okl_streams_v stm_int_pmt
3299: ,okl_strm_elements_v sel_int_pmt
3300: WHERE stm_int_pmt.kle_id = p_line_id
3301: AND stm_int_pmt.id = sel_int_pmt.stm_id
3302: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 3312: ,okl_streams_v stm_prin_pmt

3308: Cursor strm_elem_prin_line_csr (p_line_id NUMBER,
3309: p_stream_element_date DATE) IS
3310: SELECT nvl(sel_prin_pmt.amount, 0) principal
3311: FROM okl_strm_type_v sty_prin_pmt
3312: ,okl_streams_v stm_prin_pmt
3313: ,okl_strm_elements_v sel_prin_pmt
3314: WHERE stm_prin_pmt.kle_id = p_line_id
3315: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3316: AND sel_prin_pmt.stream_element_date = p_stream_element_date

Line 3326: ,okl_streams_v stm_int_pmt

3322: Cursor strm_elem_int_hdr_csr (p_khr_id NUMBER,
3323: p_stream_element_date DATE) IS
3324: SELECT nvl(sel_int_pmt.amount, 0) interest
3325: FROM okl_strm_type_v sty_int_pmt
3326: ,okl_streams_v stm_int_pmt
3327: ,okl_strm_elements_v sel_int_pmt
3328: WHERE stm_int_pmt.khr_id = p_khr_id
3329: AND stm_int_pmt.id = sel_int_pmt.stm_id
3330: AND sel_int_pmt.stream_element_date = p_stream_element_date

Line 3340: ,okl_streams_v stm_prin_pmt

3336: Cursor strm_elem_prin_hdr_csr ( p_khr_id NUMBER,
3337: p_stream_element_date DATE) IS
3338: SELECT nvl(sel_prin_pmt.amount, 0) principal
3339: FROM okl_strm_type_v sty_prin_pmt
3340: ,okl_streams_v stm_prin_pmt
3341: ,okl_strm_elements_v sel_prin_pmt
3342: WHERE stm_prin_pmt.khr_id = p_khr_id
3343: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3344: AND sel_prin_pmt.stream_element_date = p_stream_element_date

Line 4242: ,okl_streams str

4238:
4239: SELECT sel.amount
4240: FROM
4241: okl_strm_elements sel
4242: ,okl_streams str
4243: ,okl_strm_type_v sty
4244: WHERE sel.stm_id = str.id
4245: AND str.khr_id = p_contract_id
4246: AND str.kle_id = p_line_id

Line 4258: ,okl_streams str

4254: p_stream_element_date DATE) IS
4255: SELECT SUM(amount)
4256: FROM
4257: okl_strm_elements sel
4258: ,okl_streams str
4259: ,okl_strm_type_v sty
4260: WHERE sel.stm_id = str.id
4261: AND str.khr_id = p_contract_id
4262: AND str.say_code = 'CURR'

Line 4351: ,okl_streams str

4347: SELECT sel.stream_element_date receipt_date,
4348: sum(sel.amount) principal_pmt_rcpt_amt
4349: FROM
4350: okl_strm_elements sel
4351: ,okl_streams str
4352: ,okl_strm_type_v sty
4353: WHERE sel.stm_id = str.id
4354: AND str.khr_id = p_contract_id
4355: AND str.kle_id = NVL(p_line_id, str.kle_id)

Line 4373: ,okl_streams str

4369: SELECT sel.stream_element_date receipt_date,
4370: sum(sel.amount) principal_pmt_rcpt_amt
4371: FROM
4372: okl_strm_elements sel
4373: ,okl_streams str
4374: ,okl_strm_type_v sty
4375: WHERE sel.stm_id = str.id
4376: AND str.khr_id = p_contract_id
4377: AND str.kle_id = NVL(p_line_id, str.kle_id)

Line 4849: ,okl_streams str

4845: sum(sel.amount) txn_amount,
4846: 'R' txn_type
4847: FROM
4848: okl_strm_elements sel
4849: ,okl_streams str
4850: ,okl_strm_type_v sty
4851: WHERE sel.stm_id = str.id
4852: AND str.khr_id = p_contract_id
4853: AND str.say_code = 'CURR'

Line 5315: FROM okl_streams stm,

5311: FUNCTION get_last_int_calc_date(p_khr_id IN NUMBER) RETURN DATE IS
5312: l_ret_date DATE := NULL;
5313:
5314: CURSOR c_int_calc_date_csr(cp_khr_id NUMBER) IS SELECT (max(sel.stream_element_date) - 1) last_interest_calc_date
5315: FROM okl_streams stm,
5316: okl_strm_elements sel,
5317: okl_strm_type_b sty
5318: WHERE stm.khr_id = cp_khr_id
5319: AND stm.id = sel.stm_id

Line 6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

6593: l_msg_count NUMBER;
6594: l_msg_data VARCHAR2(2000);
6595: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6596: l_stream_exists VARCHAR2(1) := '?';
6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;
6600: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
6601: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

6594: l_msg_data VARCHAR2(2000);
6595: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6596: l_stream_exists VARCHAR2(1) := '?';
6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;
6600: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
6601: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
6602: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;

Line 6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;

6595: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6596: l_stream_exists VARCHAR2(1) := '?';
6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;
6600: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
6601: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
6602: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
6603: l_def_desc CONSTANT VARCHAR2(80) := 'Variable Interest Stream Billing';

Line 6600: lx_selv_rec Okl_Streams_Pub.selv_rec_type;

6596: l_stream_exists VARCHAR2(1) := '?';
6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;
6600: lx_selv_rec Okl_Streams_Pub.selv_rec_type;
6601: i_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
6602: r_taiv_rec Okl_Trx_Ar_Invoices_Pub.taiv_rec_type;
6603: l_def_desc CONSTANT VARCHAR2(80) := 'Variable Interest Stream Billing';
6604: l_final_status CONSTANT VARCHAR2(30) := 'SUBMITTED';

Line 6671: FROM okl_streams stm

6667: --END: Added by dpsingh for SLA Uptake, Bug 5964482
6668:
6669: CURSOR stream_csr(p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER) IS
6670: SELECT stm.id
6671: FROM okl_streams stm
6672: WHERE stm.khr_id = p_khr_id
6673: AND nvl(stm.kle_id, -9999) = NVL(p_kle_id, -9999)
6674: AND stm.say_code = 'CURR'
6675: AND stm.active_yn = 'Y'

Line 6752: Okl_Streams_Util.get_primary_stream_type(

6748: x_return_status := OKL_API.G_RET_STS_SUCCESS;
6749:
6750: -- Get sty_id for the contract
6751: IF (p_stream_type_purpose = 'VARIABLE_INTEREST') THEN
6752: Okl_Streams_Util.get_primary_stream_type(
6753: p_khr_id => p_contract_id,
6754: p_primary_sty_purpose => p_stream_type_purpose,
6755: x_return_status => x_return_status,
6756: x_primary_sty_id => l_sty_id

Line 6759: Okl_Streams_Util.get_dependent_stream_type(

6755: x_return_status => x_return_status,
6756: x_primary_sty_id => l_sty_id
6757: );
6758: ELSE
6759: Okl_Streams_Util.get_dependent_stream_type(
6760: p_khr_id => p_contract_id,
6761: p_primary_sty_purpose => 'RENT',
6762: p_dependent_sty_purpose => p_stream_type_purpose,
6763: x_return_status => x_return_status,

Line 6775: print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');

6771: print_debug( ' -- ERROR: Could not retrieve Stream Id for purpose '|| p_stream_type_purpose );
6772: END IF;
6773:
6774: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6775: print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
6776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6777: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6778: print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
6779: RAISE create_stream_invoice_failed;

Line 6778: print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');

6774: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6775: print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
6776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6777: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6778: print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
6779: RAISE create_stream_invoice_failed;
6780: END IF;
6781:
6782: l_selv_rec.stm_id := NULL;

Line 6811: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');

6807: ELSE
6808: l_stmv_rec.comments := 'Variable Interest';
6809: END IF;
6810:
6811: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
6812:
6813: Okl_Streams_Pub.create_streams(
6814: p_api_version => p_api_version,
6815: p_init_msg_list => p_init_msg_list,

Line 6813: Okl_Streams_Pub.create_streams(

6809: END IF;
6810:
6811: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
6812:
6813: Okl_Streams_Pub.create_streams(
6814: p_api_version => p_api_version,
6815: p_init_msg_list => p_init_msg_list,
6816: x_return_status => x_return_status,
6817: x_msg_count => x_msg_count,

Line 6830: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');

6826: print_debug (' -- Error: '||x_msg_data);
6827: END IF;
6828:
6829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6830: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
6831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6832: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6833: print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
6834: RAISE create_stream_invoice_failed;

Line 6833: print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');

6829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6830: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
6831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6832: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6833: print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
6834: RAISE create_stream_invoice_failed;
6835: END IF;
6836:
6837: l_stream_created := OKL_API.G_TRUE;

Line 6871: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');

6867: l_selv_rec.comments := 'Variable Interest';
6868: END IF;
6869:
6870:
6871: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');
6872:
6873: Okl_Streams_Pub.create_stream_elements(
6874: p_api_version => p_api_version,
6875: p_init_msg_list => p_init_msg_list,

Line 6873: Okl_Streams_Pub.create_stream_elements(

6869:
6870:
6871: print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');
6872:
6873: Okl_Streams_Pub.create_stream_elements(
6874: p_api_version => p_api_version,
6875: p_init_msg_list => p_init_msg_list,
6876: x_return_status => x_return_status,
6877: x_msg_count => x_msg_count,

Line 6889: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');

6885: print_debug (' -- Error: '||x_msg_data);
6886: END IF;
6887:
6888: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6889: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
6890: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6891: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6892: print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
6893: RAISE create_stream_invoice_failed;

Line 6892: print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');

6888: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
6889: print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
6890: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6891: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6892: print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
6893: RAISE create_stream_invoice_failed;
6894: END IF;
6895:
6896: l_strm_element_created := OKL_API.G_TRUE;

Line 7457: OKL_STREAMS_PUB.delete_stream_elements(

7453: END IF;
7454: -- Daily Interest calculation conc. program does not use savepoint. Delete the streams/Trx
7455: IF (p_process_flag = 'DAILY_INTEREST') THEN
7456: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
7457: OKL_STREAMS_PUB.delete_stream_elements(
7458: p_api_version => 1.0,
7459: p_init_msg_list => OKC_API.G_FALSE,
7460: x_return_status => x_return_status,
7461: x_msg_count => x_msg_count,

Line 7466: OKL_STREAMS_PUB.delete_streams(

7462: x_msg_data => x_msg_data,
7463: p_selv_rec => lx_selv_rec);
7464: END IF;
7465: IF (l_stream_created = OKL_API.G_TRUE) THEN
7466: OKL_STREAMS_PUB.delete_streams(
7467: p_api_version => 1.0,
7468: p_init_msg_list => OKC_API.G_FALSE,
7469: x_return_status => x_return_status,
7470: x_msg_count => x_msg_count,

Line 7504: OKL_STREAMS_PUB.delete_stream_elements(

7500: END IF;
7501: -- Daily Interest calculation conc. program does not use savepoint. Delete the streams/Trx
7502: IF (p_process_flag = 'DAILY_INTEREST') THEN
7503: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
7504: OKL_STREAMS_PUB.delete_stream_elements(
7505: p_api_version => 1.0,
7506: p_init_msg_list => OKC_API.G_FALSE,
7507: x_return_status => x_return_status,
7508: x_msg_count => x_msg_count,

Line 7513: OKL_STREAMS_PUB.delete_streams(

7509: x_msg_data => x_msg_data,
7510: p_selv_rec => lx_selv_rec);
7511: END IF;
7512: IF (l_stream_created = OKL_API.G_TRUE) THEN
7513: OKL_STREAMS_PUB.delete_streams(
7514: p_api_version => 1.0,
7515: p_init_msg_list => OKC_API.G_FALSE,
7516: x_return_status => x_return_status,
7517: x_msg_count => x_msg_count,

Line 7798: FROM okl_streams stm,

7794: --checks if newly created Daily Interest - Principal stream elements exist
7795: --prior to date passed
7796: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7797: SELECT 'Y' return_value
7798: FROM okl_streams stm,
7799: okl_strm_type_b sty,
7800: okl_strm_elements sel
7801: WHERE stm.khr_id = cp_khr_id
7802: AND stm.sty_id = sty.id

Line 7816: FROM okl_streams stm,

7812: --checks if newly created Principal Catchup stream elements exist
7813: --prior to date passed
7814: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7815: SELECT 'Y' return_value
7816: FROM okl_streams stm,
7817: okl_strm_type_b sty,
7818: okl_strm_elements sel
7819: WHERE stm.khr_id = cp_khr_id
7820: AND stm.sty_id = sty.id

Line 8087: FROM okl_streams stm,

8083: --get the id's of Daily Interest - Principal stream elements
8084: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8085: SELECT sel.id source_id
8086: , 'OKL_STRM_ELEMENTS_V' source_table
8087: FROM okl_streams stm,
8088: okl_strm_type_b sty,
8089: okl_strm_elements sel
8090: WHERE stm.khr_id = cp_khr_id
8091: AND stm.sty_id = sty.id

Line 8106: FROM okl_streams stm,

8102: --get the id's of Principal Catchup stream elements
8103: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8104: SELECT sel.id source_id
8105: , 'OKL_STRM_ELEMENTS_V' source_table
8106: FROM okl_streams stm,
8107: okl_strm_type_b sty,
8108: okl_strm_elements sel
8109: WHERE stm.khr_id = cp_khr_id
8110: AND stm.sty_id = sty.id

Line 9020: OKL_STREAMS_UTIL.get_line_id(p_trx_number => p_trx_number

9016: p_index_number IN NUMBER,
9017: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
9018: l_kle_id NUMBER := -9999;
9019: BEGIN
9020: OKL_STREAMS_UTIL.get_line_id(p_trx_number => p_trx_number
9021: ,p_index_number => p_index_number
9022: ,x_kle_id => l_kle_id
9023: ,x_return_status => x_return_status);
9024: RETURN l_kle_id;

Line 10272: okl_streams stm,

10268:
10269: /*CURSOR c_terms_cur (p_contract_id NUMBER, p_reamort_date DATE) IS
10270: SELECT max(sel.stream_element_date)
10271: FROM okl_strm_elements sel,
10272: okl_streams stm,
10273: okl_strm_type_b sty,
10274: okc_k_headers_b khr
10275: WHERE stm.khr_id = p_contract_id
10276: AND stm.active_yn = 'Y'

Line 11245: okl_streams_v stm_prin_pmt,

11241:
11242: CURSOR loan_payment_amount_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11243: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11244: FROM okl_strm_type_v sty_prin_pmt,
11245: okl_streams_v stm_prin_pmt,
11246: okl_strm_elements_v sel_prin_pmt
11247: WHERE stm_prin_pmt.khr_id = p_khr_id
11248: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11249: AND sel_prin_pmt.stream_element_date <= p_due_date

Line 11258: okl_streams_v stm_prin_pmt,

11254:
11255: CURSOR scheduled_prin_pmnt_amt_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11256: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11257: FROM okl_strm_type_v sty_prin_pmt,
11258: okl_streams_v stm_prin_pmt,
11259: okl_strm_elements_v sel_prin_pmt
11260: WHERE stm_prin_pmt.khr_id = p_khr_id
11261: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11262: AND sel_prin_pmt.stream_element_date = p_due_date

Line 11504: okl_streams_v stm_prin_pmt,

11500:
11501: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11502: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11503: FROM okl_strm_type_v sty_prin_pmt,
11504: okl_streams_v stm_prin_pmt,
11505: okl_strm_elements_v sel_prin_pmt
11506: WHERE stm_prin_pmt.khr_id = cp_khr_id
11507: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11508: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 11518: okl_streams_v stm_prin_pmt,

11514: -- Derive the interest billed for previous billing periods
11515: CURSOR Interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
11516: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11517: FROM okl_strm_type_v sty_prin_pmt,
11518: okl_streams_v stm_prin_pmt,
11519: okl_strm_elements_v sel_prin_pmt
11520: WHERE stm_prin_pmt.khr_id = cp_khr_id
11521: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11522: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 11542: okl_streams str,

11538: SELECT sel.id,
11539: sel.stream_element_date,
11540: sel.amount
11541: FROM okl_strm_type_v sty,
11542: okl_streams str,
11543: okl_strm_elements sel
11544: WHERE sel.stm_id = str.id
11545: AND str.khr_id = cp_khr_id
11546: AND str.kle_id = cp_kle_id

Line 11562: okl_streams_v stm_prin_pmt,

11558:
11559: CURSOR scheduled_prin_pmnt_amt_csr (cp_khr_id NUMBER, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11560: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11561: FROM okl_strm_type_v sty_prin_pmt,
11562: okl_streams_v stm_prin_pmt,
11563: okl_strm_elements_v sel_prin_pmt
11564: WHERE stm_prin_pmt.khr_id = cp_khr_id
11565: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11566: AND sel_prin_pmt.stream_element_date = cp_due_date

Line 11888: okl_strm_elements selb, okl_streams stmb

11884: SELECT chrb.id contract_id, cleb.id kle_id,
11885: selb.stream_element_date, selb.amount amount
11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
11887: okc_line_styles_b lseb, okl_strm_type_b styb,
11888: okl_strm_elements selb, okl_streams stmb
11889: WHERE cleb.dnz_chr_id = chrb.id
11890: AND cleb.chr_id = chrb.id
11891: AND chrb.id = p_contract_id
11892: AND cleb.lse_id = lseb.id

Line 12138: okl_streams_v stm_prin_pmt,

12134:
12135: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12136: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12137: FROM okl_strm_type_v sty_prin_pmt,
12138: okl_streams_v stm_prin_pmt,
12139: okl_strm_elements_v sel_prin_pmt
12140: WHERE stm_prin_pmt.khr_id = cp_khr_id
12141: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12142: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date

Line 12151: okl_streams_v stm_prin_pmt,

12147:
12148: CURSOR int_pay_amt_end_date_csr (cp_khr_id NUMBER, cp_start_date DATE) IS
12149: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12150: FROM okl_strm_type_v sty_prin_pmt,
12151: okl_streams_v stm_prin_pmt,
12152: okl_strm_elements_v sel_prin_pmt
12153: WHERE stm_prin_pmt.khr_id = cp_khr_id
12154: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12155: AND sel_prin_pmt.stream_element_date >= cp_start_date

Line 12164: okl_streams_v stm_prin_pmt,

12160:
12161: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12162: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12163: FROM okl_strm_type_v sty_prin_pmt,
12164: okl_streams_v stm_prin_pmt,
12165: okl_strm_elements_v sel_prin_pmt
12166: WHERE stm_prin_pmt.khr_id = cp_khr_id
12167: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12168: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date