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 209: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

205: ) return number;
206:
207: PROCEDURE Add_External_Links(
208: p_api_version in number,
209: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
210: p_commit in varchar2, -- := FND_API.G_FALSE,
211: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY varchar2,
213: x_msg_count OUT NOCOPY number,

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

206:
207: PROCEDURE Add_External_Links(
208: p_api_version in number,
209: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
210: p_commit in varchar2, -- := FND_API.G_FALSE,
211: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY varchar2,
213: x_msg_count OUT NOCOPY number,
214: x_msg_data OUT NOCOPY varchar2,

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

207: PROCEDURE Add_External_Links(
208: p_api_version in number,
209: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
210: p_commit in varchar2, -- := FND_API.G_FALSE,
211: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY varchar2,
213: x_msg_count OUT NOCOPY number,
214: x_msg_data OUT NOCOPY varchar2,
215: p_usage_code in varchar2,

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

223: -- Update or delete link
224: --
225: --PROCEDURE Change_Set_Type_Links(
226: -- p_api_version in number,
227: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
228: -- p_commit in varchar2 := FND_API.G_FALSE,
229: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
230: -- x_return_status OUT NOCOPY varchar2,
231: -- x_msg_count OUT NOCOPY number,

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

224: --
225: --PROCEDURE Change_Set_Type_Links(
226: -- p_api_version in number,
227: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
228: -- p_commit in varchar2 := FND_API.G_FALSE,
229: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
230: -- x_return_status OUT NOCOPY varchar2,
231: -- x_msg_count OUT NOCOPY number,
232: -- x_msg_data OUT NOCOPY varchar2,

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

225: --PROCEDURE Change_Set_Type_Links(
226: -- p_api_version in number,
227: -- p_init_msg_list in varchar2 := FND_API.G_FALSE,
228: -- p_commit in varchar2 := FND_API.G_FALSE,
229: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
230: -- x_return_status OUT NOCOPY varchar2,
231: -- x_msg_count OUT NOCOPY number,
232: -- x_msg_data OUT NOCOPY varchar2,
233: -- p_link_id_tbl in cs_kb_number_tbl_type,

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

235: --);
236:
237: PROCEDURE Change_Ele_Type_Links(
238: p_api_version in number,
239: p_init_msg_list in varchar2 := FND_API.G_FALSE,
240: p_commit in varchar2 := FND_API.G_FALSE,
241: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY varchar2,
243: x_msg_count OUT NOCOPY number,

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

236:
237: PROCEDURE Change_Ele_Type_Links(
238: p_api_version in number,
239: p_init_msg_list in varchar2 := FND_API.G_FALSE,
240: p_commit in varchar2 := FND_API.G_FALSE,
241: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY varchar2,
243: x_msg_count OUT NOCOPY number,
244: x_msg_data OUT NOCOPY varchar2,

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

237: PROCEDURE Change_Ele_Type_Links(
238: p_api_version in number,
239: p_init_msg_list in varchar2 := FND_API.G_FALSE,
240: p_commit in varchar2 := FND_API.G_FALSE,
241: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY varchar2,
243: x_msg_count OUT NOCOPY number,
244: x_msg_data OUT NOCOPY varchar2,
245: p_link_id_tbl in cs_kb_number_tbl_type,

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

250: -- (used when del set)
251: --
252: PROCEDURE Change_Set_Links(
253: p_api_version in number,
254: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
255: p_commit in varchar2, -- := FND_API.G_FALSE,
256: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY varchar2,
258: x_msg_count OUT NOCOPY number,

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

251: --
252: PROCEDURE Change_Set_Links(
253: p_api_version in number,
254: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
255: p_commit in varchar2, -- := FND_API.G_FALSE,
256: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY varchar2,
258: x_msg_count OUT NOCOPY number,
259: x_msg_data OUT NOCOPY varchar2,

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

252: PROCEDURE Change_Set_Links(
253: p_api_version in number,
254: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
255: p_commit in varchar2, -- := FND_API.G_FALSE,
256: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY varchar2,
258: x_msg_count OUT NOCOPY number,
259: x_msg_data OUT NOCOPY varchar2,
260: p_link_id_tbl in cs_kb_number_tbl_type,

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

262: );
263:
264: PROCEDURE Change_Element_Links(
265: p_api_version in number,
266: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
267: p_commit in varchar2, -- := FND_API.G_FALSE,
268: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY varchar2,
270: x_msg_count OUT NOCOPY number,

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

263:
264: PROCEDURE Change_Element_Links(
265: p_api_version in number,
266: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
267: p_commit in varchar2, -- := FND_API.G_FALSE,
268: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY varchar2,
270: x_msg_count OUT NOCOPY number,
271: x_msg_data OUT NOCOPY varchar2,

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

264: PROCEDURE Change_Element_Links(
265: p_api_version in number,
266: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
267: p_commit in varchar2, -- := FND_API.G_FALSE,
268: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY varchar2,
270: x_msg_count OUT NOCOPY number,
271: x_msg_data OUT NOCOPY varchar2,
272: p_link_id_tbl in cs_kb_number_tbl_type,

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

274: );
275:
276: PROCEDURE Change_Element_To_Sets(
277: p_api_version in number,
278: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
279: p_commit in varchar2, -- := FND_API.G_FALSE,
280: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY varchar2,
282: x_msg_count OUT NOCOPY number,

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

275:
276: PROCEDURE Change_Element_To_Sets(
277: p_api_version in number,
278: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
279: p_commit in varchar2, -- := FND_API.G_FALSE,
280: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY varchar2,
282: x_msg_count OUT NOCOPY number,
283: x_msg_data OUT NOCOPY varchar2,

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

276: PROCEDURE Change_Element_To_Sets(
277: p_api_version in number,
278: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
279: p_commit in varchar2, -- := FND_API.G_FALSE,
280: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
281: x_return_status OUT NOCOPY varchar2,
282: x_msg_count OUT NOCOPY number,
283: x_msg_data OUT NOCOPY varchar2,
284: p_element_id in number,

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

291:
292: -- Original (Pre 8/03/00) Contributed element ids not passed back
293: PROCEDURE Create_Set_And_Elements(
294: p_api_version in number,
295: p_init_msg_list in varchar2 := FND_API.G_FALSE,
296: p_commit in varchar2 := FND_API.G_FALSE,
297: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
298: x_return_status OUT NOCOPY varchar2,
299: x_msg_count OUT NOCOPY number,

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

292: -- Original (Pre 8/03/00) Contributed element ids not passed back
293: PROCEDURE Create_Set_And_Elements(
294: p_api_version in number,
295: p_init_msg_list in varchar2 := FND_API.G_FALSE,
296: p_commit in varchar2 := FND_API.G_FALSE,
297: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
298: x_return_status OUT NOCOPY varchar2,
299: x_msg_count OUT NOCOPY number,
300: x_msg_data OUT NOCOPY varchar2,

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

293: PROCEDURE Create_Set_And_Elements(
294: p_api_version in number,
295: p_init_msg_list in varchar2 := FND_API.G_FALSE,
296: p_commit in varchar2 := FND_API.G_FALSE,
297: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
298: x_return_status OUT NOCOPY varchar2,
299: x_msg_count OUT NOCOPY number,
300: x_msg_data OUT NOCOPY varchar2,
301: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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

306:
307: -- New (Post 8/03/00) Contributed element ids passed back
308: PROCEDURE Create_Set_And_Elements(
309: p_api_version in number,
310: p_init_msg_list in varchar2 := FND_API.G_FALSE,
311: p_commit in varchar2 := FND_API.G_FALSE,
312: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY varchar2,
314: x_msg_count OUT NOCOPY number,

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

307: -- New (Post 8/03/00) Contributed element ids passed back
308: PROCEDURE Create_Set_And_Elements(
309: p_api_version in number,
310: p_init_msg_list in varchar2 := FND_API.G_FALSE,
311: p_commit in varchar2 := FND_API.G_FALSE,
312: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY varchar2,
314: x_msg_count OUT NOCOPY number,
315: x_msg_data OUT NOCOPY varchar2,

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

308: PROCEDURE Create_Set_And_Elements(
309: p_api_version in number,
310: p_init_msg_list in varchar2 := FND_API.G_FALSE,
311: p_commit in varchar2 := FND_API.G_FALSE,
312: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY varchar2,
314: x_msg_count OUT NOCOPY number,
315: x_msg_data OUT NOCOPY varchar2,
316: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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

321: );
322:
323: PROCEDURE Create_Set(
324: p_api_version in number,
325: p_init_msg_list in varchar2 := FND_API.G_FALSE,
326: p_commit in varchar2 := FND_API.G_FALSE,
327: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY varchar2,
329: x_msg_count OUT NOCOPY number,

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

322:
323: PROCEDURE Create_Set(
324: p_api_version in number,
325: p_init_msg_list in varchar2 := FND_API.G_FALSE,
326: p_commit in varchar2 := FND_API.G_FALSE,
327: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY varchar2,
329: x_msg_count OUT NOCOPY number,
330: x_msg_data OUT NOCOPY varchar2,

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

323: PROCEDURE Create_Set(
324: p_api_version in number,
325: p_init_msg_list in varchar2 := FND_API.G_FALSE,
326: p_commit in varchar2 := FND_API.G_FALSE,
327: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY varchar2,
329: x_msg_count OUT NOCOPY number,
330: x_msg_data OUT NOCOPY varchar2,
331: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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

335: );
336:
337: PROCEDURE Create_Element(
338: p_api_version in number,
339: p_init_msg_list in varchar2 := FND_API.G_FALSE,
340: p_commit in varchar2 := FND_API.G_FALSE,
341: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
342: x_return_status OUT NOCOPY varchar2,
343: x_msg_count OUT NOCOPY number,

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

336:
337: PROCEDURE Create_Element(
338: p_api_version in number,
339: p_init_msg_list in varchar2 := FND_API.G_FALSE,
340: p_commit in varchar2 := FND_API.G_FALSE,
341: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
342: x_return_status OUT NOCOPY varchar2,
343: x_msg_count OUT NOCOPY number,
344: x_msg_data OUT NOCOPY varchar2,

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

337: PROCEDURE Create_Element(
338: p_api_version in number,
339: p_init_msg_list in varchar2 := FND_API.G_FALSE,
340: p_commit in varchar2 := FND_API.G_FALSE,
341: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
342: x_return_status OUT NOCOPY varchar2,
343: x_msg_count OUT NOCOPY number,
344: x_msg_data OUT NOCOPY varchar2,
345: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

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

353:
354: -- Original (Pre 8/03/00) Contributed element ids not passed back
355: PROCEDURE Create_Set_And_Elements(
356: p_api_version in number,
357: p_init_msg_list in varchar2 := FND_API.G_FALSE,
358: p_commit in varchar2 := FND_API.G_FALSE,
359: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY varchar2,
361: x_msg_count OUT NOCOPY number,

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

354: -- Original (Pre 8/03/00) Contributed element ids not passed back
355: PROCEDURE Create_Set_And_Elements(
356: p_api_version in number,
357: p_init_msg_list in varchar2 := FND_API.G_FALSE,
358: p_commit in varchar2 := FND_API.G_FALSE,
359: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY varchar2,
361: x_msg_count OUT NOCOPY number,
362: x_msg_data OUT NOCOPY varchar2,

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

355: PROCEDURE Create_Set_And_Elements(
356: p_api_version in number,
357: p_init_msg_list in varchar2 := FND_API.G_FALSE,
358: p_commit in varchar2 := FND_API.G_FALSE,
359: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
360: x_return_status OUT NOCOPY varchar2,
361: x_msg_count OUT NOCOPY number,
362: x_msg_data OUT NOCOPY varchar2,
363: p_set_def_obj in cs_kb_set_def_obj_type,

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

369:
370: -- New (Post 8/03/00) Contributed element ids passed back
371: PROCEDURE Create_Set_And_Elements(
372: p_api_version in number,
373: p_init_msg_list in varchar2 := FND_API.G_FALSE,
374: p_commit in varchar2 := FND_API.G_FALSE,
375: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
376: x_return_status OUT NOCOPY varchar2,
377: x_msg_count OUT NOCOPY number,

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

370: -- New (Post 8/03/00) Contributed element ids passed back
371: PROCEDURE Create_Set_And_Elements(
372: p_api_version in number,
373: p_init_msg_list in varchar2 := FND_API.G_FALSE,
374: p_commit in varchar2 := FND_API.G_FALSE,
375: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
376: x_return_status OUT NOCOPY varchar2,
377: x_msg_count OUT NOCOPY number,
378: x_msg_data OUT NOCOPY varchar2,

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

371: PROCEDURE Create_Set_And_Elements(
372: p_api_version in number,
373: p_init_msg_list in varchar2 := FND_API.G_FALSE,
374: p_commit in varchar2 := FND_API.G_FALSE,
375: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
376: x_return_status OUT NOCOPY varchar2,
377: x_msg_count OUT NOCOPY number,
378: x_msg_data OUT NOCOPY varchar2,
379: p_set_def_obj in cs_kb_set_def_obj_type,

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

385: );
386:
387: PROCEDURE Create_Set(
388: p_api_version in number,
389: p_init_msg_list in varchar2 := FND_API.G_FALSE,
390: p_commit in varchar2 := FND_API.G_FALSE,
391: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY varchar2,
393: x_msg_count OUT NOCOPY number,

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

386:
387: PROCEDURE Create_Set(
388: p_api_version in number,
389: p_init_msg_list in varchar2 := FND_API.G_FALSE,
390: p_commit in varchar2 := FND_API.G_FALSE,
391: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY varchar2,
393: x_msg_count OUT NOCOPY number,
394: x_msg_data OUT NOCOPY varchar2,

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

387: PROCEDURE Create_Set(
388: p_api_version in number,
389: p_init_msg_list in varchar2 := FND_API.G_FALSE,
390: p_commit in varchar2 := FND_API.G_FALSE,
391: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY varchar2,
393: x_msg_count OUT NOCOPY number,
394: x_msg_data OUT NOCOPY varchar2,
395: p_set_def_obj in cs_kb_set_def_obj_type,

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

400: );
401:
402: PROCEDURE Create_Element(
403: p_api_version in number,
404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
405: p_commit in varchar2 := FND_API.G_FALSE,
406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY varchar2,
408: x_msg_count OUT NOCOPY number,

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

401:
402: PROCEDURE Create_Element(
403: p_api_version in number,
404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
405: p_commit in varchar2 := FND_API.G_FALSE,
406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY varchar2,
408: x_msg_count OUT NOCOPY number,
409: x_msg_data OUT NOCOPY varchar2,

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

402: PROCEDURE Create_Element(
403: p_api_version in number,
404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
405: p_commit in varchar2 := FND_API.G_FALSE,
406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
407: x_return_status OUT NOCOPY varchar2,
408: x_msg_count OUT NOCOPY number,
409: x_msg_data OUT NOCOPY varchar2,
410: p_ele_def_obj in cs_kb_ele_def_obj_type,

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

416: --
417:
418: PROCEDURE Incr_Set_Useful(
419: p_api_version in number,
420: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
421: p_commit in varchar2, -- := FND_API.G_FALSE,
422: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY varchar2,
424: x_msg_count OUT NOCOPY number,

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

417:
418: PROCEDURE Incr_Set_Useful(
419: p_api_version in number,
420: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
421: p_commit in varchar2, -- := FND_API.G_FALSE,
422: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY varchar2,
424: x_msg_count OUT NOCOPY number,
425: x_msg_data OUT NOCOPY varchar2,

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

418: PROCEDURE Incr_Set_Useful(
419: p_api_version in number,
420: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
421: p_commit in varchar2, -- := FND_API.G_FALSE,
422: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY varchar2,
424: x_msg_count OUT NOCOPY number,
425: x_msg_data OUT NOCOPY varchar2,
426: p_set_id in number,

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

433: -- Search APIs
434: --
435: --PROCEDURE Find_Eles_Matching (
436: -- p_api_version in number,
437: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
438: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
439: -- x_return_status OUT NOCOPY varchar2,
440: -- x_msg_count OUT NOCOPY number,
441: -- x_msg_data OUT NOCOPY varchar2,

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

434: --
435: --PROCEDURE Find_Eles_Matching (
436: -- p_api_version in number,
437: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
438: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
439: -- x_return_status OUT NOCOPY varchar2,
440: -- x_msg_count OUT NOCOPY number,
441: -- x_msg_data OUT NOCOPY varchar2,
442: -- p_query_str in varchar2,

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

451: --);
452:
453: --PROCEDURE Find_Eles_Related (
454: -- p_api_version in number,
455: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
456: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
457: -- x_return_status OUT NOCOPY varchar2,
458: -- x_msg_count OUT NOCOPY number,
459: -- x_msg_data OUT NOCOPY varchar2,

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

452:
453: --PROCEDURE Find_Eles_Related (
454: -- p_api_version in number,
455: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
456: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
457: -- x_return_status OUT NOCOPY varchar2,
458: -- x_msg_count OUT NOCOPY number,
459: -- x_msg_data OUT NOCOPY varchar2,
460: -- p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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

468: --);
469:
470: PROCEDURE Find_Sets_Matching (
471: p_api_version in number,
472: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
473: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
474: x_return_status OUT NOCOPY varchar2,
475: x_msg_count OUT NOCOPY number,
476: x_msg_data OUT NOCOPY varchar2,

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

469:
470: PROCEDURE Find_Sets_Matching (
471: p_api_version in number,
472: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
473: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
474: x_return_status OUT NOCOPY varchar2,
475: x_msg_count OUT NOCOPY number,
476: x_msg_data OUT NOCOPY varchar2,
477: p_pos_query_str in varchar2,

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

481: p_rows in number,
482: p_start_score in number := null,
483: p_start_id in number := null,
484: p_start_row in number, -- := 1,
485: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
486: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
487: x_total_rows OUT NOCOPY number,
488: p_search_option in number := null
489: );

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

489: );
490:
491: PROCEDURE Find_Sets_Matching2 (
492: p_api_version in number,
493: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
494: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
495: x_return_status OUT NOCOPY varchar2,
496: x_msg_count OUT NOCOPY number,
497: x_msg_data OUT NOCOPY varchar2,

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

490:
491: PROCEDURE Find_Sets_Matching2 (
492: p_api_version in number,
493: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
494: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
495: x_return_status OUT NOCOPY varchar2,
496: x_msg_count OUT NOCOPY number,
497: x_msg_data OUT NOCOPY varchar2,
498: p_pos_query_str in varchar2,

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

503: p_rows in number,
504: p_start_score in number := null,
505: p_start_id in number := null,
506: p_start_row in number, -- := 1,
507: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
508: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
509: x_total_rows OUT NOCOPY number,
510: p_search_option in number := null
511: );

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

511: );
512:
513: --PROCEDURE Find_Sets_Related (
514: -- p_api_version in number,
515: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
516: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
517: -- x_return_status OUT NOCOPY varchar2,
518: -- x_msg_count OUT NOCOPY number,
519: -- x_msg_data OUT NOCOPY varchar2,

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

512:
513: --PROCEDURE Find_Sets_Related (
514: -- p_api_version in number,
515: -- p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
516: -- p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
517: -- x_return_status OUT NOCOPY varchar2,
518: -- x_msg_count OUT NOCOPY number,
519: -- x_msg_data OUT NOCOPY varchar2,
520: -- p_pos_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,