3:
4: PROCEDURE get_stream_id
5: (
6: p_khr_id IN okl_k_headers_full_v.id%TYPE,
7: p_stream_type_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
10: )
11: IS
5: (
6: p_khr_id IN okl_k_headers_full_v.id%TYPE,
7: p_stream_type_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
10: )
11: IS
12:
13: CURSOR pry_sty_csr IS
11: IS
12:
13: CURSOR pry_sty_csr IS
14: SELECT ID
15: FROM OKL_Strm_type_b
16: WHERE stream_type_purpose = p_stream_type_purpose;
17:
18: l_sty_id NUMBER;
19: