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_STRM_TYPE_B

Line 121: TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE

117: INDEX BY BINARY_INTEGER;
118: --Bug 4662173 - End of Changes
119:
120:
121: TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE
122: INDEX BY BINARY_INTEGER;
123: ---------------------------------------------------------------------------
124: -- End for Bug#2807737 changes
125: -- PRCODURE LOG_MESSAGE

Line 185: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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: );
189:

Line 187: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%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: );
189:
190: /*
191: -- Returns the primary stream type id for primary stream purpose for a contract

Line 198: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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: );
202:

Line 200: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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: );
202:
203: /*
204: -- Returns the dep stream type id for dep stream purpose for a contract

Line 211: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
215: );

Line 212: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
215: );
216:

Line 214: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
215: );
216:
217: PROCEDURE get_dependent_stream_type
218: (

Line 220: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

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
224: );

Line 221: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
224: );
225:

Line 223: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
224: );
225:
226: -- Added for bug 6326479
227: PROCEDURE get_dependent_stream_type

Line 231: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
235: );

Line 232: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%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
235: );
236:

Line 234: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.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
235: );
236:
237: PROCEDURE get_dependent_stream_type_rep
238: (

Line 240: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
244: );

Line 241: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
244: );
245:

Line 243: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
244: );
245:
246: PROCEDURE get_dependent_stream_type_rep
247: (

Line 249: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

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
253: );

Line 250: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
253: );
254:

Line 252: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE

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
253: );
254:
255: -- Added for bug 6326479
256: PROCEDURE get_dependent_stream_type_rep

Line 260: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
264: );

Line 261: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

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
264: );
265:

Line 263: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.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
264: );
265:
266: FUNCTION strm_tmpt_contains_strm_type
267: (

Line 269: p_sty_id IN okl_strm_type_b.ID%TYPE

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:
273: -- Gets the status of the stream generation request for external generator