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.CS_KNOWLEDGE_PVT dependencies on FND_API

Line 21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

17: -- for return status
18: ERROR_STATUS CONSTANT NUMBER := -1;
19: OKAY_STATUS CONSTANT NUMBER := 0;
20:
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_VALID_LEVEL_TYPESOK CONSTANT NUMBER := 50;
24:
25: --

Line 22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

18: ERROR_STATUS CONSTANT NUMBER := -1;
19: OKAY_STATUS CONSTANT NUMBER := 0;
20:
21: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_VALID_LEVEL_TYPESOK CONSTANT NUMBER := 50;
24:
25: --
26: -- TYPES AND MISSING CONSTANTS

Line 203: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

199: ) return number;
200:
201: PROCEDURE Add_External_Links(
202: p_api_version in number,
203: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
204: p_commit in varchar2, -- := FND_API.G_FALSE,
205: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY varchar2,
207: x_msg_count OUT NOCOPY number,

Line 204: p_commit in varchar2, -- := FND_API.G_FALSE,

200:
201: PROCEDURE Add_External_Links(
202: p_api_version in number,
203: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
204: p_commit in varchar2, -- := FND_API.G_FALSE,
205: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY varchar2,
207: x_msg_count OUT NOCOPY number,
208: x_msg_data OUT NOCOPY varchar2,

Line 205: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

201: PROCEDURE Add_External_Links(
202: p_api_version in number,
203: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
204: p_commit in varchar2, -- := FND_API.G_FALSE,
205: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
206: x_return_status OUT NOCOPY varchar2,
207: x_msg_count OUT NOCOPY number,
208: x_msg_data OUT NOCOPY varchar2,
209: p_usage_code in varchar2,

Line 221: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,

217: -- Update or delete link
218: --
219: --PROCEDURE Change_Set_Type_Links(
220: -- p_api_version in number,
221: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
222: -- p_commit in varchar2 := FND_API.G_FALSE,
223: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
224: -- x_return_status OUT NOCOPY varchar2,
225: -- x_msg_count OUT NOCOPY number,

Line 222: -- p_commit in varchar2 := FND_API.G_FALSE,

218: --
219: --PROCEDURE Change_Set_Type_Links(
220: -- p_api_version in number,
221: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
222: -- p_commit in varchar2 := FND_API.G_FALSE,
223: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
224: -- x_return_status OUT NOCOPY varchar2,
225: -- x_msg_count OUT NOCOPY number,
226: -- x_msg_data OUT NOCOPY varchar2,

Line 223: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

219: --PROCEDURE Change_Set_Type_Links(
220: -- p_api_version in number,
221: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
222: -- p_commit in varchar2 := FND_API.G_FALSE,
223: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
224: -- x_return_status OUT NOCOPY varchar2,
225: -- x_msg_count OUT NOCOPY number,
226: -- x_msg_data OUT NOCOPY varchar2,
227: -- p_link_id_tbl in cs_kb_number_tbl_type,

Line 233: p_init_msg_list in varchar2 := FND_API.G_FALSE,

229: --);
230:
231: PROCEDURE Change_Ele_Type_Links(
232: p_api_version in number,
233: p_init_msg_list in varchar2 := FND_API.G_FALSE,
234: p_commit in varchar2 := FND_API.G_FALSE,
235: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
236: x_return_status OUT NOCOPY varchar2,
237: x_msg_count OUT NOCOPY number,

Line 234: p_commit in varchar2 := FND_API.G_FALSE,

230:
231: PROCEDURE Change_Ele_Type_Links(
232: p_api_version in number,
233: p_init_msg_list in varchar2 := FND_API.G_FALSE,
234: p_commit in varchar2 := FND_API.G_FALSE,
235: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
236: x_return_status OUT NOCOPY varchar2,
237: x_msg_count OUT NOCOPY number,
238: x_msg_data OUT NOCOPY varchar2,

Line 235: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

231: PROCEDURE Change_Ele_Type_Links(
232: p_api_version in number,
233: p_init_msg_list in varchar2 := FND_API.G_FALSE,
234: p_commit in varchar2 := FND_API.G_FALSE,
235: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
236: x_return_status OUT NOCOPY varchar2,
237: x_msg_count OUT NOCOPY number,
238: x_msg_data OUT NOCOPY varchar2,
239: p_link_id_tbl in cs_kb_number_tbl_type,

Line 248: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

244: -- (used when del set)
245: --
246: PROCEDURE Change_Set_Links(
247: p_api_version in number,
248: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
249: p_commit in varchar2, -- := FND_API.G_FALSE,
250: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY varchar2,
252: x_msg_count OUT NOCOPY number,

Line 249: p_commit in varchar2, -- := FND_API.G_FALSE,

245: --
246: PROCEDURE Change_Set_Links(
247: p_api_version in number,
248: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
249: p_commit in varchar2, -- := FND_API.G_FALSE,
250: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY varchar2,
252: x_msg_count OUT NOCOPY number,
253: x_msg_data OUT NOCOPY varchar2,

Line 250: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

246: PROCEDURE Change_Set_Links(
247: p_api_version in number,
248: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
249: p_commit in varchar2, -- := FND_API.G_FALSE,
250: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY varchar2,
252: x_msg_count OUT NOCOPY number,
253: x_msg_data OUT NOCOPY varchar2,
254: p_link_id_tbl in cs_kb_number_tbl_type,

Line 260: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

256: );
257:
258: PROCEDURE Change_Element_Links(
259: p_api_version in number,
260: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
261: p_commit in varchar2, -- := FND_API.G_FALSE,
262: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY varchar2,
264: x_msg_count OUT NOCOPY number,

Line 261: p_commit in varchar2, -- := FND_API.G_FALSE,

257:
258: PROCEDURE Change_Element_Links(
259: p_api_version in number,
260: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
261: p_commit in varchar2, -- := FND_API.G_FALSE,
262: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY varchar2,
264: x_msg_count OUT NOCOPY number,
265: x_msg_data OUT NOCOPY varchar2,

Line 262: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

258: PROCEDURE Change_Element_Links(
259: p_api_version in number,
260: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
261: p_commit in varchar2, -- := FND_API.G_FALSE,
262: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY varchar2,
264: x_msg_count OUT NOCOPY number,
265: x_msg_data OUT NOCOPY varchar2,
266: p_link_id_tbl in cs_kb_number_tbl_type,

Line 272: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

268: );
269:
270: PROCEDURE Change_Element_To_Sets(
271: p_api_version in number,
272: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
273: p_commit in varchar2, -- := FND_API.G_FALSE,
274: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY varchar2,
276: x_msg_count OUT NOCOPY number,

Line 273: p_commit in varchar2, -- := FND_API.G_FALSE,

269:
270: PROCEDURE Change_Element_To_Sets(
271: p_api_version in number,
272: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
273: p_commit in varchar2, -- := FND_API.G_FALSE,
274: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY varchar2,
276: x_msg_count OUT NOCOPY number,
277: x_msg_data OUT NOCOPY varchar2,

Line 274: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

270: PROCEDURE Change_Element_To_Sets(
271: p_api_version in number,
272: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
273: p_commit in varchar2, -- := FND_API.G_FALSE,
274: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
275: x_return_status OUT NOCOPY varchar2,
276: x_msg_count OUT NOCOPY number,
277: x_msg_data OUT NOCOPY varchar2,
278: p_element_id in number,

Line 289: p_init_msg_list in varchar2 := FND_API.G_FALSE,

285:
286: -- Original (Pre 8/03/00) Contributed element ids not passed back
287: PROCEDURE Create_Set_And_Elements(
288: p_api_version in number,
289: p_init_msg_list in varchar2 := FND_API.G_FALSE,
290: p_commit in varchar2 := FND_API.G_FALSE,
291: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
292: x_return_status OUT NOCOPY varchar2,
293: x_msg_count OUT NOCOPY number,

Line 290: p_commit in varchar2 := FND_API.G_FALSE,

286: -- Original (Pre 8/03/00) Contributed element ids not passed back
287: PROCEDURE Create_Set_And_Elements(
288: p_api_version in number,
289: p_init_msg_list in varchar2 := FND_API.G_FALSE,
290: p_commit in varchar2 := FND_API.G_FALSE,
291: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
292: x_return_status OUT NOCOPY varchar2,
293: x_msg_count OUT NOCOPY number,
294: x_msg_data OUT NOCOPY varchar2,

Line 291: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

287: PROCEDURE Create_Set_And_Elements(
288: p_api_version in number,
289: p_init_msg_list in varchar2 := FND_API.G_FALSE,
290: p_commit in varchar2 := FND_API.G_FALSE,
291: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
292: x_return_status OUT NOCOPY varchar2,
293: x_msg_count OUT NOCOPY number,
294: x_msg_data OUT NOCOPY varchar2,
295: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 304: p_init_msg_list in varchar2 := FND_API.G_FALSE,

300:
301: -- New (Post 8/03/00) Contributed element ids passed back
302: PROCEDURE Create_Set_And_Elements(
303: p_api_version in number,
304: p_init_msg_list in varchar2 := FND_API.G_FALSE,
305: p_commit in varchar2 := FND_API.G_FALSE,
306: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT NOCOPY varchar2,
308: x_msg_count OUT NOCOPY number,

Line 305: p_commit in varchar2 := FND_API.G_FALSE,

301: -- New (Post 8/03/00) Contributed element ids passed back
302: PROCEDURE Create_Set_And_Elements(
303: p_api_version in number,
304: p_init_msg_list in varchar2 := FND_API.G_FALSE,
305: p_commit in varchar2 := FND_API.G_FALSE,
306: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT NOCOPY varchar2,
308: x_msg_count OUT NOCOPY number,
309: x_msg_data OUT NOCOPY varchar2,

Line 306: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

302: PROCEDURE Create_Set_And_Elements(
303: p_api_version in number,
304: p_init_msg_list in varchar2 := FND_API.G_FALSE,
305: p_commit in varchar2 := FND_API.G_FALSE,
306: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT NOCOPY varchar2,
308: x_msg_count OUT NOCOPY number,
309: x_msg_data OUT NOCOPY varchar2,
310: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 319: p_init_msg_list in varchar2 := FND_API.G_FALSE,

315: );
316:
317: PROCEDURE Create_Set(
318: p_api_version in number,
319: p_init_msg_list in varchar2 := FND_API.G_FALSE,
320: p_commit in varchar2 := FND_API.G_FALSE,
321: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
322: x_return_status OUT NOCOPY varchar2,
323: x_msg_count OUT NOCOPY number,

Line 320: p_commit in varchar2 := FND_API.G_FALSE,

316:
317: PROCEDURE Create_Set(
318: p_api_version in number,
319: p_init_msg_list in varchar2 := FND_API.G_FALSE,
320: p_commit in varchar2 := FND_API.G_FALSE,
321: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
322: x_return_status OUT NOCOPY varchar2,
323: x_msg_count OUT NOCOPY number,
324: x_msg_data OUT NOCOPY varchar2,

Line 321: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

317: PROCEDURE Create_Set(
318: p_api_version in number,
319: p_init_msg_list in varchar2 := FND_API.G_FALSE,
320: p_commit in varchar2 := FND_API.G_FALSE,
321: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
322: x_return_status OUT NOCOPY varchar2,
323: x_msg_count OUT NOCOPY number,
324: x_msg_data OUT NOCOPY varchar2,
325: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 333: p_init_msg_list in varchar2 := FND_API.G_FALSE,

329: );
330:
331: PROCEDURE Create_Element(
332: p_api_version in number,
333: p_init_msg_list in varchar2 := FND_API.G_FALSE,
334: p_commit in varchar2 := FND_API.G_FALSE,
335: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
336: x_return_status OUT NOCOPY varchar2,
337: x_msg_count OUT NOCOPY number,

Line 334: p_commit in varchar2 := FND_API.G_FALSE,

330:
331: PROCEDURE Create_Element(
332: p_api_version in number,
333: p_init_msg_list in varchar2 := FND_API.G_FALSE,
334: p_commit in varchar2 := FND_API.G_FALSE,
335: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
336: x_return_status OUT NOCOPY varchar2,
337: x_msg_count OUT NOCOPY number,
338: x_msg_data OUT NOCOPY varchar2,

Line 335: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

331: PROCEDURE Create_Element(
332: p_api_version in number,
333: p_init_msg_list in varchar2 := FND_API.G_FALSE,
334: p_commit in varchar2 := FND_API.G_FALSE,
335: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
336: x_return_status OUT NOCOPY varchar2,
337: x_msg_count OUT NOCOPY number,
338: x_msg_data OUT NOCOPY varchar2,
339: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

Line 351: p_init_msg_list in varchar2 := FND_API.G_FALSE,

347:
348: -- Original (Pre 8/03/00) Contributed element ids not passed back
349: PROCEDURE Create_Set_And_Elements(
350: p_api_version in number,
351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
352: p_commit in varchar2 := FND_API.G_FALSE,
353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
354: x_return_status OUT NOCOPY varchar2,
355: x_msg_count OUT NOCOPY number,

Line 352: p_commit in varchar2 := FND_API.G_FALSE,

348: -- Original (Pre 8/03/00) Contributed element ids not passed back
349: PROCEDURE Create_Set_And_Elements(
350: p_api_version in number,
351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
352: p_commit in varchar2 := FND_API.G_FALSE,
353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
354: x_return_status OUT NOCOPY varchar2,
355: x_msg_count OUT NOCOPY number,
356: x_msg_data OUT NOCOPY varchar2,

Line 353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

349: PROCEDURE Create_Set_And_Elements(
350: p_api_version in number,
351: p_init_msg_list in varchar2 := FND_API.G_FALSE,
352: p_commit in varchar2 := FND_API.G_FALSE,
353: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
354: x_return_status OUT NOCOPY varchar2,
355: x_msg_count OUT NOCOPY number,
356: x_msg_data OUT NOCOPY varchar2,
357: p_set_def_obj in cs_kb_set_def_obj_type,

Line 367: p_init_msg_list in varchar2 := FND_API.G_FALSE,

363:
364: -- New (Post 8/03/00) Contributed element ids passed back
365: PROCEDURE Create_Set_And_Elements(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,

Line 368: p_commit in varchar2 := FND_API.G_FALSE,

364: -- New (Post 8/03/00) Contributed element ids passed back
365: PROCEDURE Create_Set_And_Elements(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,
372: x_msg_data OUT NOCOPY varchar2,

Line 369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

365: PROCEDURE Create_Set_And_Elements(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,
372: x_msg_data OUT NOCOPY varchar2,
373: p_set_def_obj in cs_kb_set_def_obj_type,

Line 383: p_init_msg_list in varchar2 := FND_API.G_FALSE,

379: );
380:
381: PROCEDURE Create_Set(
382: p_api_version in number,
383: p_init_msg_list in varchar2 := FND_API.G_FALSE,
384: p_commit in varchar2 := FND_API.G_FALSE,
385: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY varchar2,
387: x_msg_count OUT NOCOPY number,

Line 384: p_commit in varchar2 := FND_API.G_FALSE,

380:
381: PROCEDURE Create_Set(
382: p_api_version in number,
383: p_init_msg_list in varchar2 := FND_API.G_FALSE,
384: p_commit in varchar2 := FND_API.G_FALSE,
385: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY varchar2,
387: x_msg_count OUT NOCOPY number,
388: x_msg_data OUT NOCOPY varchar2,

Line 385: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

381: PROCEDURE Create_Set(
382: p_api_version in number,
383: p_init_msg_list in varchar2 := FND_API.G_FALSE,
384: p_commit in varchar2 := FND_API.G_FALSE,
385: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY varchar2,
387: x_msg_count OUT NOCOPY number,
388: x_msg_data OUT NOCOPY varchar2,
389: p_set_def_obj in cs_kb_set_def_obj_type,

Line 398: p_init_msg_list in varchar2 := FND_API.G_FALSE,

394: );
395:
396: PROCEDURE Create_Element(
397: p_api_version in number,
398: p_init_msg_list in varchar2 := FND_API.G_FALSE,
399: p_commit in varchar2 := FND_API.G_FALSE,
400: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
401: x_return_status OUT NOCOPY varchar2,
402: x_msg_count OUT NOCOPY number,

Line 399: p_commit in varchar2 := FND_API.G_FALSE,

395:
396: PROCEDURE Create_Element(
397: p_api_version in number,
398: p_init_msg_list in varchar2 := FND_API.G_FALSE,
399: p_commit in varchar2 := FND_API.G_FALSE,
400: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
401: x_return_status OUT NOCOPY varchar2,
402: x_msg_count OUT NOCOPY number,
403: x_msg_data OUT NOCOPY varchar2,

Line 400: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

396: PROCEDURE Create_Element(
397: p_api_version in number,
398: p_init_msg_list in varchar2 := FND_API.G_FALSE,
399: p_commit in varchar2 := FND_API.G_FALSE,
400: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
401: x_return_status OUT NOCOPY varchar2,
402: x_msg_count OUT NOCOPY number,
403: x_msg_data OUT NOCOPY varchar2,
404: p_ele_def_obj in cs_kb_ele_def_obj_type,

Line 414: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

410: --
411:
412: PROCEDURE Incr_Set_Useful(
413: p_api_version in number,
414: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
415: p_commit in varchar2, -- := FND_API.G_FALSE,
416: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
417: x_return_status OUT NOCOPY varchar2,
418: x_msg_count OUT NOCOPY number,

Line 415: p_commit in varchar2, -- := FND_API.G_FALSE,

411:
412: PROCEDURE Incr_Set_Useful(
413: p_api_version in number,
414: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
415: p_commit in varchar2, -- := FND_API.G_FALSE,
416: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
417: x_return_status OUT NOCOPY varchar2,
418: x_msg_count OUT NOCOPY number,
419: x_msg_data OUT NOCOPY varchar2,

Line 416: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

412: PROCEDURE Incr_Set_Useful(
413: p_api_version in number,
414: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
415: p_commit in varchar2, -- := FND_API.G_FALSE,
416: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
417: x_return_status OUT NOCOPY varchar2,
418: x_msg_count OUT NOCOPY number,
419: x_msg_data OUT NOCOPY varchar2,
420: p_set_id in number,

Line 431: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

427: -- Search APIs
428: --
429: --PROCEDURE Find_Eles_Matching (
430: -- p_api_version in number,
431: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
432: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
433: -- x_return_status OUT NOCOPY varchar2,
434: -- x_msg_count OUT NOCOPY number,
435: -- x_msg_data OUT NOCOPY varchar2,

Line 432: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

428: --
429: --PROCEDURE Find_Eles_Matching (
430: -- p_api_version in number,
431: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
432: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
433: -- x_return_status OUT NOCOPY varchar2,
434: -- x_msg_count OUT NOCOPY number,
435: -- x_msg_data OUT NOCOPY varchar2,
436: -- p_query_str in varchar2,

Line 449: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

445: --);
446:
447: --PROCEDURE Find_Eles_Related (
448: -- p_api_version in number,
449: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
450: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
451: -- x_return_status OUT NOCOPY varchar2,
452: -- x_msg_count OUT NOCOPY number,
453: -- x_msg_data OUT NOCOPY varchar2,

Line 450: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

446:
447: --PROCEDURE Find_Eles_Related (
448: -- p_api_version in number,
449: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
450: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
451: -- x_return_status OUT NOCOPY varchar2,
452: -- x_msg_count OUT NOCOPY number,
453: -- x_msg_data OUT NOCOPY varchar2,
454: -- p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

Line 466: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

462: --);
463:
464: PROCEDURE Find_Sets_Matching (
465: p_api_version in number,
466: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
467: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
468: x_return_status OUT NOCOPY varchar2,
469: x_msg_count OUT NOCOPY number,
470: x_msg_data OUT NOCOPY varchar2,

Line 467: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

463:
464: PROCEDURE Find_Sets_Matching (
465: p_api_version in number,
466: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
467: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
468: x_return_status OUT NOCOPY varchar2,
469: x_msg_count OUT NOCOPY number,
470: x_msg_data OUT NOCOPY varchar2,
471: p_pos_query_str in varchar2,

Line 479: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,

475: p_rows in number,
476: p_start_score in number := null,
477: p_start_id in number := null,
478: p_start_row in number, -- := 1,
479: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
480: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
481: x_total_rows OUT NOCOPY number,
482: p_search_option in number := null
483: );

Line 487: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

483: );
484:
485: PROCEDURE Find_Sets_Matching2 (
486: p_api_version in number,
487: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
488: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
489: x_return_status OUT NOCOPY varchar2,
490: x_msg_count OUT NOCOPY number,
491: x_msg_data OUT NOCOPY varchar2,

Line 488: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

484:
485: PROCEDURE Find_Sets_Matching2 (
486: p_api_version in number,
487: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
488: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
489: x_return_status OUT NOCOPY varchar2,
490: x_msg_count OUT NOCOPY number,
491: x_msg_data OUT NOCOPY varchar2,
492: p_pos_query_str in varchar2,

Line 501: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,

497: p_rows in number,
498: p_start_score in number := null,
499: p_start_id in number := null,
500: p_start_row in number, -- := 1,
501: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
502: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
503: x_total_rows OUT NOCOPY number,
504: p_search_option in number := null
505: );

Line 509: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

505: );
506:
507: --PROCEDURE Find_Sets_Related (
508: -- p_api_version in number,
509: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
510: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
511: -- x_return_status OUT NOCOPY varchar2,
512: -- x_msg_count OUT NOCOPY number,
513: -- x_msg_data OUT NOCOPY varchar2,

Line 510: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

506:
507: --PROCEDURE Find_Sets_Related (
508: -- p_api_version in number,
509: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
510: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
511: -- x_return_status OUT NOCOPY varchar2,
512: -- x_msg_count OUT NOCOPY number,
513: -- x_msg_data OUT NOCOPY varchar2,
514: -- p_pos_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,