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

Line 72: FROM okl_streams stmb,

68: AND pocb.khr_id = p_khr_id
69: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
70: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
71: AND EXISTS (SELECT '1'
72: FROM okl_streams stmb,
73: okl_strm_type_b styb
74: WHERE stmb.sty_id = styb.id
75: AND stmb.khr_id = pocb.khr_id
76: AND stmb.id = pocb.stm_id

Line 94: FROM okl_streams stmb,

90: AND pocb.khr_id = p_khr_id
91: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) > TRUNC(p_effective_date)
92: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
93: AND EXISTS (SELECT '1'
94: FROM okl_streams stmb,
95: okl_strm_type_b styb
96: WHERE stmb.sty_id = styb.id
97: AND stmb.khr_id = pocb.khr_id
98: AND stmb.id = pocb.stm_id

Line 117: FROM okl_streams stmb,

113: AND pocb.khr_id = p_khr_id
114: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) < TRUNC(p_effective_date)
115: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
116: AND EXISTS (SELECT '1'
117: FROM okl_streams stmb,
118: okl_strm_type_b styb
119: WHERE stmb.sty_id = styb.id
120: AND stmb.khr_id = pocb.khr_id
121: AND stmb.id = pocb.stm_id

Line 138: FROM okl_streams stmb,

134: AND pocb.khr_id = p_khr_id
135: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) = TRUNC(p_effective_date)
136: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
137: AND EXISTS (SELECT '1'
138: FROM okl_streams stmb,
139: okl_strm_type_b styb
140: WHERE stmb.sty_id = styb.id
141: AND stmb.khr_id = pocb.khr_id
142: AND stmb.id = pocb.stm_id

Line 361: FROM okl_streams stmb,

357: AND pocb.kle_id = p_kle_id
358: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
359: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
360: AND EXISTS (SELECT '1'
361: FROM okl_streams stmb,
362: okl_strm_type_b styb
363: WHERE stmb.sty_id = styb.id
364: AND stmb.khr_id = pocb.khr_id
365: AND stmb.kle_id = pocb.kle_id

Line 384: FROM okl_streams stmb,

380: AND pocb.kle_id = p_kle_id
381: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) > TRUNC(p_effective_date)
382: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
383: AND EXISTS (SELECT '1'
384: FROM okl_streams stmb,
385: okl_strm_type_b styb
386: WHERE stmb.sty_id = styb.id
387: AND stmb.khr_id = pocb.khr_id
388: AND stmb.kle_id = pocb.kle_id

Line 407: FROM okl_streams stmb,

403: AND pocb.kle_id = p_kle_id
404: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) < TRUNC(p_effective_date)
405: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
406: AND EXISTS (SELECT '1'
407: FROM okl_streams stmb,
408: okl_strm_type_b styb
409: WHERE stmb.sty_id = styb.id
410: AND stmb.khr_id = pocb.khr_id
411: AND stmb.kle_id = pocb.kle_id

Line 430: FROM okl_streams stmb,

426: AND pocb.kle_id = p_kle_id
427: AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) = TRUNC(p_effective_date)
428: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
429: AND EXISTS (SELECT '1'
430: FROM okl_streams stmb,
431: okl_strm_type_b styb
432: WHERE stmb.sty_id = styb.id
433: AND stmb.khr_id = pocb.khr_id
434: AND stmb.kle_id = pocb.kle_id

Line 809: p_stm_id IN okl_streams.ID%TYPE

805:
806: -- End of comments
807: ----------------------------------------------------------------------------------
808: FUNCTION is_stm_securitized(
809: p_stm_id IN okl_streams.ID%TYPE
810: ,p_effective_date IN DATE
811: ) RETURN VARCHAR
812: IS
813: l_dummy VARCHAR2(1);

Line 817: CURSOR c_stm(p_stm_id okl_streams.ID%TYPE, p_effective_date DATE) IS

813: l_dummy VARCHAR2(1);
814: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
815: l_row_found BOOLEAN := FALSE;
816:
817: CURSOR c_stm(p_stm_id okl_streams.ID%TYPE, p_effective_date DATE) IS
818: SELECT '1'
819: FROM okl_streams strm
820: ,okl_pool_contents pl
821: ,okl_pools ph

Line 819: FROM okl_streams strm

815: l_row_found BOOLEAN := FALSE;
816:
817: CURSOR c_stm(p_stm_id okl_streams.ID%TYPE, p_effective_date DATE) IS
818: SELECT '1'
819: FROM okl_streams strm
820: ,okl_pool_contents pl
821: ,okl_pools ph
822: ,okc_k_headers_b khr
823: WHERE -- mvasudev, stm_id changes

Line 887: ,p_stm_id IN okl_streams.ID%TYPE

883: ,p_init_msg_list IN VARCHAR2
884: ,x_return_status OUT NOCOPY VARCHAR2
885: ,x_msg_count OUT NOCOPY NUMBER
886: ,x_msg_data OUT NOCOPY VARCHAR2
887: ,p_stm_id IN okl_streams.ID%TYPE
888: ,p_effective_date IN DATE
889: ,x_value OUT NOCOPY VARCHAR2
890: )
891: IS

Line 984: FROM okl_streams strm

980: l_row_found BOOLEAN := FALSE;
981:
982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS
983: SELECT '1'
984: FROM okl_streams strm
985: ,okl_strm_elements ele
986: ,okl_pool_contents pl
987: ,okl_pools ph
988: ,okc_k_headers_b khr

Line 2282: FROM okl_streams

2278: -- Cursor to get Latest Streams for this Lease Contract/Asset Line
2279: CURSOR l_okl_stm_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER)
2280: IS
2281: SELECT id
2282: FROM okl_streams
2283: WHERE khr_id = p_khr_id
2284: AND kle_id = p_kle_id
2285: AND sty_id = p_sty_id
2286: AND say_code = 'CURR'

Line 2966: FROM okl_streams

2962: -- Cursor to get the Latest Streams for this Asset Line
2963: CURSOR l_okl_stm_csr(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER)
2964: IS
2965: SELECT id
2966: FROM okl_streams
2967: WHERE khr_id = p_khr_id
2968: AND kle_id = p_kle_id
2969: AND sty_id = p_sty_id
2970: AND say_code = 'CURR'

Line 3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;

3208: IS
3209: SELECT okl_sif_seq.NEXTVAL transaction_number
3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:

Line 3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

3209: SELECT okl_sif_seq.NEXTVAL transaction_number
3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';

Line 3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;

3210: FROM dual;
3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3218: l_api_version CONSTANT NUMBER := 1.0;

Line 3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;

3211:
3212: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3213: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3214: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3215: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
3216:
3217: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_disb_streams';
3218: l_api_version CONSTANT NUMBER := 1.0;
3219: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3251: Okl_Streams_Util.get_primary_stream_type(p_khr_id => p_source_id,

3247: l_sty_purpose := p_loan_sty_purpose;
3248: END IF;
3249: -- End Changes ankushar Bug# 6740000
3250: -- Get the primary Stream Type
3251: Okl_Streams_Util.get_primary_stream_type(p_khr_id => p_source_id,
3252: p_primary_sty_purpose => l_sty_purpose,
3253: x_return_status => l_return_status,
3254: x_primary_sty_id => l_sty_id);
3255:

Line 3282: Okl_Streams_Pub.create_streams(p_api_version => p_api_version

3278: lp_selv_tbl(1).amount := p_amount;
3279: lp_selv_tbl(1).stream_element_date := p_stream_element_date;
3280: lp_selv_tbl(1).se_line_number := 1;
3281:
3282: Okl_Streams_Pub.create_streams(p_api_version => p_api_version
3283: ,p_init_msg_list => p_init_msg_list
3284: ,x_return_status => l_return_status
3285: ,x_msg_count => x_msg_count
3286: ,x_msg_data => x_msg_data