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_STREAM_GENERATOR_PVT dependencies on OKL_STRM_ELEMENTS

Line 642: okl_strm_elements sel

638: /*
639: Cursor c_sty IS
640: SELECT sel.id
641: FROM okl_streams stm,
642: okl_strm_elements sel
643: where stm.khr_id = p_khr_id
644: and stm.say_code = 'HIST'
645: and stm.SGN_CODE = 'MANL'
646: and stm.active_yn = 'N'

Line 1621: FROM okl_strm_elements sel,

1617:
1618: CURSOR c_k_income (p_sty_name VARCHAR2) IS
1619: SELECT sel.amount income_amount,
1620: sel.stream_element_date income_date
1621: FROM okl_strm_elements sel,
1622: okl_streams stm,
1623: okl_strm_type_b sty,
1624: okl_strm_type_tl styt
1625: WHERE stm.khr_id = p_khr_id

Line 3567: FROM okl_strm_elements

3563: AND id <> p_stm_id;
3564:
3565: CURSOR c_last_sel (p_stm_id NUMBER) IS
3566: SELECT se_line_number
3567: FROM okl_strm_elements
3568: WHERE stm_id = p_stm_id
3569: ORDER BY se_line_number DESC;
3570:
3571: CURSOR c_sel (p_stm_id NUMBER) IS

Line 3573: FROM okl_strm_elements

3569: ORDER BY se_line_number DESC;
3570:
3571: CURSOR c_sel (p_stm_id NUMBER) IS
3572: SELECT id
3573: FROM okl_strm_elements
3574: WHERE stm_id = p_stm_id
3575: ORDER BY stream_element_date;
3576:
3577: l_stm_first NUMBER;

Line 3603: UPDATE okl_strm_elements

3599: FOR l_sel IN c_sel (l_stm.id) LOOP
3600:
3601: n := n + 1;
3602:
3603: UPDATE okl_strm_elements
3604: SET stm_id = l_stm_first, se_line_number = (l_line_num + n) WHERE id = l_sel.id;
3605:
3606: END LOOP;
3607:

Line 3692: FROM okl_strm_elements

3688: AND id <> p_stm_id;
3689:
3690: CURSOR c_last_sel (p_stm_id NUMBER) IS
3691: SELECT se_line_number
3692: FROM okl_strm_elements
3693: WHERE stm_id = p_stm_id
3694: ORDER BY se_line_number DESC;
3695:
3696: CURSOR c_sel (p_stm_id NUMBER) IS

Line 3698: FROM okl_strm_elements

3694: ORDER BY se_line_number DESC;
3695:
3696: CURSOR c_sel (p_stm_id NUMBER) IS
3697: SELECT id
3698: FROM okl_strm_elements
3699: WHERE stm_id = p_stm_id
3700: ORDER BY stream_element_date;
3701:
3702: l_stm_first NUMBER;

Line 3729: UPDATE okl_strm_elements SET stm_id = l_stm_first, se_line_number = (l_line_num + n) WHERE id = l_sel.id;

3725: FOR l_sel IN c_sel (l_stm.id) LOOP
3726:
3727: n := n + 1;
3728:
3729: UPDATE okl_strm_elements SET stm_id = l_stm_first, se_line_number = (l_line_num + n) WHERE id = l_sel.id;
3730:
3731: END LOOP;
3732:
3733: END LOOP;

Line 3797: okl_strm_elements ele,

3793: stm.sty_id,
3794: sty.stream_type_purpose stm_purpose,
3795: ele.amount amount
3796: FROM okl_streams stm,
3797: okl_strm_elements ele,
3798: okl_strm_type_b sty
3799: WHERE stm.khr_id = p_khr_id
3800: AND ele.stm_id = stm.id
3801: AND stm.say_code = 'WORK'

Line 3939: DELETE okl_strm_elements

3935: THEN
3936: --print( l_prog_name, 'Deleting ' || l_ele_id_del_tbl.COUNT || ' Stream Elements ' );
3937: BEGIN
3938: FORALL indx in l_ele_id_del_tbl.FIRST .. l_ele_id_del_tbl.LAST
3939: DELETE okl_strm_elements
3940: WHERE id = l_ele_id_del_tbl(indx) AND
3941: stm_id = l_streamid_del_tbl(indx);
3942: EXCEPTION
3943: WHEN OTHERS THEN

Line 3966: UPDATE okl_strm_elements

3962: THEN
3963: --print( l_prog_name, 'Modifiying ' || l_ele_id_mod_tbl.COUNT || ' Stream Elements ' );
3964: BEGIN
3965: FORALL indx in l_ele_id_mod_tbl.FIRST .. l_ele_id_mod_tbl.LAST
3966: UPDATE okl_strm_elements
3967: SET stream_element_date = l_sel_date_mod_tbl(indx),
3968: amount = l_amt_mod_tbl(indx)
3969: WHERE id = l_ele_id_mod_tbl(indx) AND
3970: stm_id = l_streamid_mod_tbl(indx);

Line 4194: okl_strm_elements sel,

4190: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4191: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4192: FROM okl_streams stm,
4193: okl_strm_type_b sty,
4194: okl_strm_elements sel,
4195: okc_k_lines_b cle,
4196: okc_line_styles_b lse,
4197: okc_rules_b sll,
4198: okc_rules_b slh,

Line 5104: -- Create the Stream Elements in the OKL_STRM_ELEMENTS table

5100: l_pt_tbl(i).sel_id := l_se_id;
5101: END LOOP;
5102: END IF;
5103: --print( l_prog_name, 'start date ' || l_selv_tbl(1).stream_element_date );
5104: -- Create the Stream Elements in the OKL_STRM_ELEMENTS table
5105: -- feels like the join between stream header and stream elements here is
5106: -- sel_id, we are populating it in the above for loop.
5107: okl_streams_pub.create_stream_elements(
5108: p_api_version => G_API_VERSION,

Line 7760: UPDATE okl_strm_elements

7756: END IF;
7757:
7758: -- print( l_prog_name, ' updating ' );
7759:
7760: UPDATE okl_strm_elements
7761: SET comments=NULL
7762: WHERE stm_id IN
7763: (SELECT id from okl_streams WHERE khr_id = p_khr_id and say_code = 'WORK');
7764: -- print( l_prog_name, ' done ' );

Line 8197: okl_strm_elements ele

8193: from okl_pools pol,
8194: okl_pool_contents pcn,
8195: okl_strm_type_v sty,
8196: okl_streams stm,
8197: okl_strm_elements ele
8198: where pcn.sty_id = sty.id
8199: and pcn.pol_id = pol.id
8200: and stm.kle_id = pcn.kle_id
8201: and stm.khr_id = pcn.khr_id

Line 8256: okl_strm_elements ele

8252: from okl_pools pol,
8253: okl_pool_contents pcn,
8254: okl_strm_type_v sty,
8255: okl_streams stm,
8256: okl_strm_elements ele
8257: where pcn.sty_id = sty.id
8258: and pcn.pol_id = pol.id
8259: and stm.kle_id = pcn.kle_id
8260: and stm.khr_id = pcn.khr_id

Line 8867: okl_strm_elements ele

8863: from okl_pools pol,
8864: okl_pool_contents pcn,
8865: okl_strm_type_v sty,
8866: okl_streams stm,
8867: okl_strm_elements ele
8868: where pcn.sty_id = sty.id
8869: and pcn.pol_id = pol.id
8870: and stm.kle_id = pcn.kle_id
8871: and stm.khr_id = pcn.khr_id

Line 8929: okl_strm_elements ele

8925: from okl_pools pol,
8926: okl_pool_contents pcn,
8927: okl_strm_type_v sty,
8928: okl_streams stm,
8929: okl_strm_elements ele
8930: where pcn.sty_id = sty.id
8931: and pcn.pol_id = pol.id
8932: and stm.kle_id = pcn.kle_id
8933: and stm.khr_id = pcn.khr_id

Line 10982: okl_strm_elements ele,

10978: CURSOR c_pbal IS
10979: SELECT ele.amount,
10980: ele.stream_element_date
10981: FROM okl_streams stm,
10982: okl_strm_elements ele,
10983: okl_strm_type_b sty
10984: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
10985: AND stm.sty_id = sty.id
10986: AND stm.khr_id = p_khr_id

Line 10994: okl_strm_elements ele,

10990: AND ele.stm_id = stm.id
10991: AND ele.stream_element_date =
10992: ( SELECT max( ele.stream_element_date)
10993: FROM okl_streams stm,
10994: okl_strm_elements ele,
10995: okl_strm_type_b sty
10996: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
10997: AND stm.sty_id = sty.id
10998: AND stm.khr_id = p_khr_id