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.

[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_STRM_ELEMENTS

Line 651: okl_strm_elements sel

647: /*
648: Cursor c_sty IS
649: SELECT sel.id
650: FROM okl_streams stm,
651: okl_strm_elements sel
652: where stm.khr_id = p_khr_id
653: and stm.say_code = 'HIST'
654: and stm.SGN_CODE = 'MANL'
655: and stm.active_yn = 'N'

Line 1636: FROM okl_strm_elements sel,

1632:
1633: CURSOR c_k_income (p_sty_name VARCHAR2) IS
1634: SELECT sel.amount income_amount,
1635: sel.stream_element_date income_date
1636: FROM okl_strm_elements sel,
1637: okl_streams stm,
1638: okl_strm_type_b sty,
1639: okl_strm_type_tl styt
1640: WHERE stm.khr_id = p_khr_id

Line 3474: FROM okl_strm_elements

3470: AND id <> p_stm_id;
3471:
3472: CURSOR c_last_sel (p_stm_id NUMBER) IS
3473: SELECT se_line_number
3474: FROM okl_strm_elements
3475: WHERE stm_id = p_stm_id
3476: ORDER BY se_line_number DESC;
3477:
3478: CURSOR c_sel (p_stm_id NUMBER) IS

Line 3480: FROM okl_strm_elements

3476: ORDER BY se_line_number DESC;
3477:
3478: CURSOR c_sel (p_stm_id NUMBER) IS
3479: SELECT id
3480: FROM okl_strm_elements
3481: WHERE stm_id = p_stm_id
3482: ORDER BY stream_element_date;
3483:
3484: l_stm_first NUMBER;

Line 3510: UPDATE okl_strm_elements

3506: FOR l_sel IN c_sel (l_stm.id) LOOP
3507:
3508: n := n + 1;
3509:
3510: UPDATE okl_strm_elements
3511: SET stm_id = l_stm_first,
3512: se_line_number = (l_line_num + n)
3513:
3514: WHERE id = l_sel.id;

Line 3602: FROM okl_strm_elements

3598: AND id <> p_stm_id;
3599:
3600: CURSOR c_last_sel (p_stm_id NUMBER) IS
3601: SELECT se_line_number
3602: FROM okl_strm_elements
3603: WHERE stm_id = p_stm_id
3604: ORDER BY se_line_number DESC;
3605:
3606: CURSOR c_sel (p_stm_id NUMBER) IS

Line 3608: FROM okl_strm_elements

3604: ORDER BY se_line_number DESC;
3605:
3606: CURSOR c_sel (p_stm_id NUMBER) IS
3607: SELECT id
3608: FROM okl_strm_elements
3609: WHERE stm_id = p_stm_id
3610: ORDER BY stream_element_date;
3611:
3612: l_stm_first NUMBER;

Line 3639: UPDATE okl_strm_elements

3635: FOR l_sel IN c_sel (l_stm.id) LOOP
3636:
3637: n := n + 1;
3638:
3639: UPDATE okl_strm_elements
3640: SET stm_id = l_stm_first,
3641: se_line_number = (l_line_num + n)
3642: WHERE id = l_sel.id;
3643:

Line 3710: okl_strm_elements ele,

3706: stm.sty_id,
3707: sty.stream_type_purpose stm_purpose,
3708: ele.amount amount
3709: FROM okl_streams stm,
3710: okl_strm_elements ele,
3711: okl_strm_type_b sty
3712: WHERE stm.khr_id = p_khr_id
3713: AND ele.stm_id = stm.id
3714: AND stm.say_code = 'WORK'

Line 3852: DELETE okl_strm_elements

3848: THEN
3849: --print( l_prog_name, 'Deleting ' || l_ele_id_del_tbl.COUNT || ' Stream Elements ' );
3850: BEGIN
3851: FORALL indx in l_ele_id_del_tbl.FIRST .. l_ele_id_del_tbl.LAST
3852: DELETE okl_strm_elements
3853: WHERE id = l_ele_id_del_tbl(indx) AND
3854: stm_id = l_streamid_del_tbl(indx);
3855: EXCEPTION
3856: WHEN OTHERS THEN

Line 3879: UPDATE okl_strm_elements

3875: THEN
3876: --print( l_prog_name, 'Modifiying ' || l_ele_id_mod_tbl.COUNT || ' Stream Elements ' );
3877: BEGIN
3878: FORALL indx in l_ele_id_mod_tbl.FIRST .. l_ele_id_mod_tbl.LAST
3879: UPDATE okl_strm_elements
3880: SET stream_element_date = l_sel_date_mod_tbl(indx),
3881: amount = l_amt_mod_tbl(indx)
3882: WHERE id = l_ele_id_mod_tbl(indx) AND
3883: stm_id = l_streamid_mod_tbl(indx);

Line 4110: okl_strm_elements sel,

4106: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4107: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4108: FROM okl_streams stm,
4109: okl_strm_type_b sty,
4110: okl_strm_elements sel,
4111: okc_k_lines_b cle,
4112: okc_line_styles_b lse,
4113: okc_rules_b sll,
4114: okc_rules_b slh,

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

5022: l_pt_tbl(i).sel_id := l_se_id;
5023: END LOOP;
5024: END IF;
5025: --print( l_prog_name, 'start date ' || l_selv_tbl(1).stream_element_date );
5026: -- Create the Stream Elements in the OKL_STRM_ELEMENTS table
5027: -- feels like the join between stream header and stream elements here is
5028: -- sel_id, we are populating it in the above for loop.
5029: okl_streams_pub.create_stream_elements(
5030: p_api_version => G_API_VERSION,

Line 6293: , OKL_STRM_ELEMENTS SEL

6289: , SEL.ACCRUED_YN
6290: , STM.TRANSACTION_NUMBER
6291: , STY.STREAM_TYPE_PURPOSE
6292: FROM OKL_STREAMS STM
6293: , OKL_STRM_ELEMENTS SEL
6294: , OKL_STRM_TYPE_B STY
6295: WHERE SEL.STM_ID = STM.ID
6296: AND STM.KHR_ID = cp_chr_id
6297: AND STM.KLE_ID = cp_cle_id

Line 6776: print(l_prog_name, 'Before calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

6772: print(l_prog_name, 'Before calling APIs to Delete the Identified Streams l_del_stm_id_tbl.COUNT=' || l_del_stm_id_tbl.COUNT );
6773: IF l_del_stm_id_tbl.COUNT > 0
6774: THEN
6775: -- Delete the records from the OKL_STREAM_ELEMENTS first
6776: print(l_prog_name, 'Before calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6777: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6778: DELETE okl_strm_elements sel
6779: WHERE sel.stm_id = l_del_stm_id_tbl(i);
6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

Line 6778: DELETE okl_strm_elements sel

6774: THEN
6775: -- Delete the records from the OKL_STREAM_ELEMENTS first
6776: print(l_prog_name, 'Before calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6777: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6778: DELETE okl_strm_elements sel
6779: WHERE sel.stm_id = l_del_stm_id_tbl(i);
6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6781:
6782: -- Delete teh records from the OKL_STREAMS table now

Line 6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

6776: print(l_prog_name, 'Before calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6777: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6778: DELETE okl_strm_elements sel
6779: WHERE sel.stm_id = l_del_stm_id_tbl(i);
6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6781:
6782: -- Delete teh records from the OKL_STREAMS table now
6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6784: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST

Line 6949: FROM okl_strm_elements sel,

6945: stm.kle_id kle_id,
6946: stm.sty_id sty_id,
6947: stm.say_code say_code,
6948: stm.purpose_code purpose_code
6949: FROM okl_strm_elements sel,
6950: okl_streams stm
6951: WHERE stm.kle_id = p_kle_id
6952: AND stm.khr_id = p_khr_id
6953: AND stm.sty_id = p_sty_id

Line 7072: FROM okl_strm_elements sel

7068: )
7069: IS
7070: SELECT TRUNC(sel.stream_element_date) income_date
7071: ,SUM(sel.amount) income_amount
7072: FROM okl_strm_elements sel
7073: ,okl_streams stm
7074: ,okl_strm_type_b sty
7075: ,okl_strm_type_tl styt
7076: WHERE stm.khr_id = p_khr_id

Line 7539: UPDATE okl_strm_elements

7535: print(l_prog_name, 'Start: Performaing the Bulk Update of ' || l_sel_id_tbl.COUNT || ' Streams. '
7536: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
7537: -- Bulk update
7538: FORALL i in l_sel_id_tbl.FIRST .. l_sel_id_tbl.LAST
7539: UPDATE okl_strm_elements
7540: SET amount = l_sel_amt_tbl(i)
7541: WHERE id = l_sel_id_tbl(i)
7542: AND stm_id = l_stm_id_tbl(i);
7543: print(l_prog_name, 'Done: Performaing the Bulk Update of ' || l_sel_id_tbl.COUNT || ' Streams '

Line 7939: UPDATE okl_strm_elements

7935: print(l_prog_name, 'Start: Performaing the Bulk Update of ' || l_sel_id_tbl.COUNT || ' Streams. '
7936: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
7937: -- Bulk update
7938: FORALL i in l_sel_id_tbl.FIRST .. l_sel_id_tbl.LAST
7939: UPDATE okl_strm_elements
7940: SET amount = l_sel_amt_tbl(i)
7941: WHERE id = l_sel_id_tbl(i)
7942: AND stm_id = l_stm_id_tbl(i);
7943: print(l_prog_name, 'Done: Performaing the Bulk Update of ' || l_sel_id_tbl.COUNT || ' Streams '

Line 10085: UPDATE okl_strm_elements

10081: END IF;
10082:
10083: -- print( l_prog_name, ' updating ' );
10084:
10085: UPDATE okl_strm_elements
10086: SET comments=NULL
10087: WHERE stm_id IN
10088: (SELECT id from okl_streams WHERE khr_id = p_khr_id and say_code = 'WORK');
10089: -- print( l_prog_name, ' done ' );

Line 10652: okl_strm_elements ele

10648: from okl_pools pol,
10649: okl_pool_contents pcn,
10650: okl_strm_type_v sty,
10651: okl_streams stm,
10652: okl_strm_elements ele
10653: where pcn.sty_id = sty.id
10654: and pcn.pol_id = pol.id
10655: and stm.kle_id = pcn.kle_id
10656: and stm.khr_id = pcn.khr_id

Line 10711: okl_strm_elements ele

10707: from okl_pools pol,
10708: okl_pool_contents pcn,
10709: okl_strm_type_v sty,
10710: okl_streams stm,
10711: okl_strm_elements ele
10712: where pcn.sty_id = sty.id
10713: and pcn.pol_id = pol.id
10714: and stm.kle_id = pcn.kle_id
10715: and stm.khr_id = pcn.khr_id

Line 11322: okl_strm_elements ele

11318: from okl_pools pol,
11319: okl_pool_contents pcn,
11320: okl_strm_type_v sty,
11321: okl_streams stm,
11322: okl_strm_elements ele
11323: where pcn.sty_id = sty.id
11324: and pcn.pol_id = pol.id
11325: and stm.kle_id = pcn.kle_id
11326: and stm.khr_id = pcn.khr_id

Line 11384: okl_strm_elements ele

11380: from okl_pools pol,
11381: okl_pool_contents pcn,
11382: okl_strm_type_v sty,
11383: okl_streams stm,
11384: okl_strm_elements ele
11385: where pcn.sty_id = sty.id
11386: and pcn.pol_id = pol.id
11387: and stm.kle_id = pcn.kle_id
11388: and stm.khr_id = pcn.khr_id

Line 13437: okl_strm_elements ele,

13433: CURSOR c_pbal IS
13434: SELECT ele.amount,
13435: ele.stream_element_date
13436: FROM okl_streams stm,
13437: okl_strm_elements ele,
13438: okl_strm_type_b sty
13439: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13440: AND stm.sty_id = sty.id
13441: AND stm.khr_id = p_khr_id

Line 13449: okl_strm_elements ele,

13445: AND ele.stm_id = stm.id
13446: AND ele.stream_element_date =
13447: ( SELECT max( ele.stream_element_date)
13448: FROM okl_streams stm,
13449: okl_strm_elements ele,
13450: okl_strm_type_b sty
13451: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13452: AND stm.sty_id = sty.id
13453: AND stm.khr_id = p_khr_id