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_STREAMS_UTIL dependencies on OKL_K_HEADERS_FULL_V

Line 184: p_khr_id IN okl_k_headers_full_v.id%TYPE,

180: */
181:
182: PROCEDURE get_primary_stream_type
183: (
184: p_khr_id IN okl_k_headers_full_v.id%TYPE,
185: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
188: );

Line 197: p_khr_id IN okl_k_headers_full_v.id%TYPE,

193: */
194:
195: PROCEDURE get_primary_stream_type_rep
196: (
197: p_khr_id IN okl_k_headers_full_v.id%TYPE,
198: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE
201: );

Line 210: p_khr_id IN okl_k_headers_full_v.id%TYPE,

206:
207:
208: PROCEDURE get_dependent_stream_type
209: (
210: p_khr_id IN okl_k_headers_full_v.id%TYPE,
211: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
212: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 219: p_khr_id IN okl_k_headers_full_v.id%TYPE,

215: );
216:
217: PROCEDURE get_dependent_stream_type
218: (
219: p_khr_id IN okl_k_headers_full_v.id%TYPE,
220: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
221: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 229: p_khr_id IN okl_k_headers_full_v.id%TYPE,

225:
226: -- Added for bug 6326479
227: PROCEDURE get_dependent_stream_type
228: (
229: p_khr_id IN okl_k_headers_full_v.id%TYPE,
230: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
231: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
232: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
233: x_return_status OUT NOCOPY VARCHAR2,

Line 230: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,

226: -- Added for bug 6326479
227: PROCEDURE get_dependent_stream_type
228: (
229: p_khr_id IN okl_k_headers_full_v.id%TYPE,
230: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
231: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
232: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 239: p_khr_id IN okl_k_headers_full_v.id%TYPE,

235: );
236:
237: PROCEDURE get_dependent_stream_type_rep
238: (
239: p_khr_id IN okl_k_headers_full_v.id%TYPE,
240: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
241: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 248: p_khr_id IN okl_k_headers_full_v.id%TYPE,

244: );
245:
246: PROCEDURE get_dependent_stream_type_rep
247: (
248: p_khr_id IN okl_k_headers_full_v.id%TYPE,
249: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
250: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 258: p_khr_id IN okl_k_headers_full_v.id%TYPE,

254:
255: -- Added for bug 6326479
256: PROCEDURE get_dependent_stream_type_rep
257: (
258: p_khr_id IN okl_k_headers_full_v.id%TYPE,
259: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
260: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
261: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
262: x_return_status OUT NOCOPY VARCHAR2,

Line 259: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,

255: -- Added for bug 6326479
256: PROCEDURE get_dependent_stream_type_rep
257: (
258: p_khr_id IN okl_k_headers_full_v.id%TYPE,
259: p_product_id IN okl_k_headers_full_v.pdt_id%TYPE,
260: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
261: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

Line 268: p_khr_id IN okl_k_headers_full_v.id%TYPE,

264: );
265:
266: FUNCTION strm_tmpt_contains_strm_type
267: (
268: p_khr_id IN okl_k_headers_full_v.id%TYPE,
269: p_sty_id IN okl_strm_type_b.ID%TYPE
270: )
271: RETURN VARCHAR2;
272: