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_ACTIVATE_CONTRACT_PUB dependencies on OKL_STRM_TYPE_B

Line 7: p_stream_type_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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

Line 9: x_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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

Line 15: FROM OKL_Strm_type_b

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: