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

Line 35: okl_streams stm,

31: CURSOR c_k_income (p_sty_name VARCHAR2) IS
32: SELECT sel.amount income_amount,
33: sel.stream_element_date income_date
34: FROM okl_strm_elements sel,
35: okl_streams stm,
36: okl_strm_type_b sty,
37: okl_strm_type_tl styt
38: WHERE stm.khr_id = p_khr_id
39: AND stm.say_code = 'WORK'

Line 49: l_selv_tbl okl_streams_pub.selv_tbl_type;

45: AND styt.language = 'US'
46: AND styt.name = p_sty_name
47: ORDER BY sel.stream_element_date;
48:
49: l_selv_tbl okl_streams_pub.selv_tbl_type;
50: lx_selv_tbl okl_streams_pub.selv_tbl_type;
51:
52: l_stmv_rec okl_streams_pub.stmv_rec_type;
53: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 50: lx_selv_tbl okl_streams_pub.selv_tbl_type;

46: AND styt.name = p_sty_name
47: ORDER BY sel.stream_element_date;
48:
49: l_selv_tbl okl_streams_pub.selv_tbl_type;
50: lx_selv_tbl okl_streams_pub.selv_tbl_type;
51:
52: l_stmv_rec okl_streams_pub.stmv_rec_type;
53: lx_stmv_rec okl_streams_pub.stmv_rec_type;
54:

Line 52: l_stmv_rec okl_streams_pub.stmv_rec_type;

48:
49: l_selv_tbl okl_streams_pub.selv_tbl_type;
50: lx_selv_tbl okl_streams_pub.selv_tbl_type;
51:
52: l_stmv_rec okl_streams_pub.stmv_rec_type;
53: lx_stmv_rec okl_streams_pub.stmv_rec_type;
54:
55: l_amortized_exp_id NUMBER;
56: l_sty_name VARCHAR2(150);

Line 53: lx_stmv_rec okl_streams_pub.stmv_rec_type;

49: l_selv_tbl okl_streams_pub.selv_tbl_type;
50: lx_selv_tbl okl_streams_pub.selv_tbl_type;
51:
52: l_stmv_rec okl_streams_pub.stmv_rec_type;
53: lx_stmv_rec okl_streams_pub.stmv_rec_type;
54:
55: l_amortized_exp_id NUMBER;
56: l_sty_name VARCHAR2(150);
57: l_name VARCHAR2(150);

Line 260: lx_return_status := Okl_Streams_Util.round_streams_amount(

256:
257: END LOOP;
258:
259:
260: lx_return_status := Okl_Streams_Util.round_streams_amount(
261: p_api_version => g_api_version,
262: p_init_msg_list => G_FALSE,
263: x_msg_count => lx_msg_count,
264: x_msg_data => lx_msg_data,

Line 279: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

275: l_selv_tbl.DELETE;
276: l_selv_tbl := lx_selv_tbl;
277:
278:
279: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
280: p_init_msg_list => G_FALSE,
281: x_return_status => lx_return_status,
282: x_msg_count => lx_msg_count,
283: x_msg_data => lx_msg_data,

Line 403: l_selv_tbl okl_streams_pub.selv_tbl_type;

399: SELECT NVL(initial_direct_cost, 0)
400: FROM okl_k_lines
401: WHERE id = p_kle_id;
402:
403: l_selv_tbl okl_streams_pub.selv_tbl_type;
404: lx_selv_tbl okl_streams_pub.selv_tbl_type;
405:
406: l_stmv_rec okl_streams_pub.stmv_rec_type;
407: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 404: lx_selv_tbl okl_streams_pub.selv_tbl_type;

400: FROM okl_k_lines
401: WHERE id = p_kle_id;
402:
403: l_selv_tbl okl_streams_pub.selv_tbl_type;
404: lx_selv_tbl okl_streams_pub.selv_tbl_type;
405:
406: l_stmv_rec okl_streams_pub.stmv_rec_type;
407: lx_stmv_rec okl_streams_pub.stmv_rec_type;
408:

Line 406: l_stmv_rec okl_streams_pub.stmv_rec_type;

402:
403: l_selv_tbl okl_streams_pub.selv_tbl_type;
404: lx_selv_tbl okl_streams_pub.selv_tbl_type;
405:
406: l_stmv_rec okl_streams_pub.stmv_rec_type;
407: lx_stmv_rec okl_streams_pub.stmv_rec_type;
408:
409: l_end_date DATE;
410: l_periodic_exp_id NUMBER;

Line 407: lx_stmv_rec okl_streams_pub.stmv_rec_type;

403: l_selv_tbl okl_streams_pub.selv_tbl_type;
404: lx_selv_tbl okl_streams_pub.selv_tbl_type;
405:
406: l_stmv_rec okl_streams_pub.stmv_rec_type;
407: lx_stmv_rec okl_streams_pub.stmv_rec_type;
408:
409: l_end_date DATE;
410: l_periodic_exp_id NUMBER;
411: l_sty_name VARCHAR2(150);

Line 634: lx_return_status := Okl_Streams_Util.round_streams_amount(

630:
631: END LOOP;
632:
633:
634: lx_return_status := Okl_Streams_Util.round_streams_amount(
635: p_api_version => g_api_version,
636: p_init_msg_list => G_FALSE,
637: x_msg_count => lx_msg_count,
638: x_msg_data => lx_msg_data,

Line 652: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

648:
649: l_selv_tbl.DELETE;
650: l_selv_tbl := lx_selv_tbl;
651:
652: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
653: p_init_msg_list => G_FALSE,
654: x_return_status => lx_return_status,
655: x_msg_count => lx_msg_count,
656: x_msg_data => lx_msg_data,