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_GRP dependencies on FND_API

Line 18: -- Default = FND_API.G_FALSE

14: -- Parameters :
15: -- IN :
16: -- p_api_version IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2(1) Optional
18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2(1) Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 20: -- Default = FND_API.G_FALSE

16: -- p_api_version IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2(1) Optional
18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2(1) Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL
23: -- p_qry_string IN
24: -- String of keywords

Line 22: -- Default = FND_API.G_VALID_LEVEL_FULL

18: -- Default = FND_API.G_FALSE
19: -- p_commit IN VARCHAR2(1) Optional
20: -- Default = FND_API.G_FALSE
21: -- p_validation_level IN NUMBER Optional
22: -- Default = FND_API.G_VALID_LEVEL_FULL
23: -- p_qry_string IN
24: -- String of keywords
25: -- p_search_option IN
26: -- Search option such as and, or, not, theme

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

40: -- End of comments
41:
42: PROCEDURE Construct_Text_Query(
43: p_api_version in number,
44: p_init_msg_list in varchar2 := FND_API.G_FALSE,
45: p_commit in varchar2 := FND_API.G_FALSE,
46: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY varchar2,
48: x_msg_count OUT NOCOPY number,

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

41:
42: PROCEDURE Construct_Text_Query(
43: p_api_version in number,
44: p_init_msg_list in varchar2 := FND_API.G_FALSE,
45: p_commit in varchar2 := FND_API.G_FALSE,
46: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY varchar2,
48: x_msg_count OUT NOCOPY number,
49: x_msg_data OUT NOCOPY varchar2,

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

42: PROCEDURE Construct_Text_Query(
43: p_api_version in number,
44: p_init_msg_list in varchar2 := FND_API.G_FALSE,
45: p_commit in varchar2 := FND_API.G_FALSE,
46: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
47: x_return_status OUT NOCOPY varchar2,
48: x_msg_count OUT NOCOPY number,
49: x_msg_data OUT NOCOPY varchar2,
50: p_qry_string in varchar2,

Line 65: -- Default = FND_API.G_FALSE

61: -- Parameters :
62: -- IN :
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2(1) Optional
65: -- Default = FND_API.G_FALSE
66: -- p_commit IN VARCHAR2(1) Optional
67: -- Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional
69: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 67: -- Default = FND_API.G_FALSE

63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2(1) Optional
65: -- Default = FND_API.G_FALSE
66: -- p_commit IN VARCHAR2(1) Optional
67: -- Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional
69: -- Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_set_id IN NUMBER Required
71: -- p_object_code IN VARCHAR2 Required

Line 69: -- Default = FND_API.G_VALID_LEVEL_FULL

65: -- Default = FND_API.G_FALSE
66: -- p_commit IN VARCHAR2(1) Optional
67: -- Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional
69: -- Default = FND_API.G_VALID_LEVEL_FULL
70: -- p_set_id IN NUMBER Required
71: -- p_object_code IN VARCHAR2 Required
72: -- p_other_id IN NUMBER Required
73: -- OUT :

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

83: -- End of comments
84:
85: PROCEDURE Delete_Set_Link(
86: p_api_version in number,
87: p_init_msg_list in varchar2 := FND_API.G_FALSE,
88: p_commit in varchar2 := FND_API.G_FALSE,
89: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT NOCOPY varchar2,
91: x_msg_count OUT NOCOPY number,

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

84:
85: PROCEDURE Delete_Set_Link(
86: p_api_version in number,
87: p_init_msg_list in varchar2 := FND_API.G_FALSE,
88: p_commit in varchar2 := FND_API.G_FALSE,
89: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT NOCOPY varchar2,
91: x_msg_count OUT NOCOPY number,
92: x_msg_data OUT NOCOPY varchar2,

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

85: PROCEDURE Delete_Set_Link(
86: p_api_version in number,
87: p_init_msg_list in varchar2 := FND_API.G_FALSE,
88: p_commit in varchar2 := FND_API.G_FALSE,
89: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT NOCOPY varchar2,
91: x_msg_count OUT NOCOPY number,
92: x_msg_data OUT NOCOPY varchar2,
93: p_set_id in number,

Line 108: -- Default = FND_API.G_FALSE

104: -- Parameters :
105: -- IN :
106: -- p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2(1) Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2(1) Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 110: -- Default = FND_API.G_FALSE

106: -- p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2(1) Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2(1) Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_element_id IN NUMBER Required
114: -- p_object_code IN VARCHAR2 Required

Line 112: -- Default = FND_API.G_VALID_LEVEL_FULL

108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2(1) Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_element_id IN NUMBER Required
114: -- p_object_code IN VARCHAR2 Required
115: -- p_other_id IN NUMBER Required
116: -- OUT :

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

126: -- End of comments
127:
128: PROCEDURE Delete_Element_Link(
129: p_api_version in number,
130: p_init_msg_list in varchar2 := FND_API.G_FALSE,
131: p_commit in varchar2 := FND_API.G_FALSE,
132: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY varchar2,
134: x_msg_count OUT NOCOPY number,

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

127:
128: PROCEDURE Delete_Element_Link(
129: p_api_version in number,
130: p_init_msg_list in varchar2 := FND_API.G_FALSE,
131: p_commit in varchar2 := FND_API.G_FALSE,
132: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY varchar2,
134: x_msg_count OUT NOCOPY number,
135: x_msg_data OUT NOCOPY varchar2,

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

128: PROCEDURE Delete_Element_Link(
129: p_api_version in number,
130: p_init_msg_list in varchar2 := FND_API.G_FALSE,
131: p_commit in varchar2 := FND_API.G_FALSE,
132: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
133: x_return_status OUT NOCOPY varchar2,
134: x_msg_count OUT NOCOPY number,
135: x_msg_data OUT NOCOPY varchar2,
136: p_element_id in number,

Line 151: -- Default = FND_API.G_FALSE

147: -- Parameters :
148: -- IN :
149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2(1) Optional
151: -- Default = FND_API.G_FALSE
152: -- p_commit IN VARCHAR2(1) Optional
153: -- Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 153: -- Default = FND_API.G_FALSE

149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2(1) Optional
151: -- Default = FND_API.G_FALSE
152: -- p_commit IN VARCHAR2(1) Optional
153: -- Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL
156: -- p_set_def_rec IN
157: -- CS_Knowledge_PUB.set_def_rec_type Required

Line 155: -- Default = FND_API.G_VALID_LEVEL_FULL

151: -- Default = FND_API.G_FALSE
152: -- p_commit IN VARCHAR2(1) Optional
153: -- Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional
155: -- Default = FND_API.G_VALID_LEVEL_FULL
156: -- p_set_def_rec IN
157: -- CS_Knowledge_PUB.set_def_rec_type Required
158: -- Definition of the set. Must have set type, status, name.
159: -- p_ele_def_tbl IN

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

178: -- End of comments
179:
180: PROCEDURE Create_Set_And_Elements(
181: p_api_version in number,
182: p_init_msg_list in varchar2 := FND_API.G_FALSE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY varchar2,
186: x_msg_count OUT NOCOPY number,

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

179:
180: PROCEDURE Create_Set_And_Elements(
181: p_api_version in number,
182: p_init_msg_list in varchar2 := FND_API.G_FALSE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY varchar2,
186: x_msg_count OUT NOCOPY number,
187: x_msg_data OUT NOCOPY varchar2,

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

180: PROCEDURE Create_Set_And_Elements(
181: p_api_version in number,
182: p_init_msg_list in varchar2 := FND_API.G_FALSE,
183: p_commit in varchar2 := FND_API.G_FALSE,
184: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
185: x_return_status OUT NOCOPY varchar2,
186: x_msg_count OUT NOCOPY number,
187: x_msg_data OUT NOCOPY varchar2,
188: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 204: -- Default = FND_API.G_FALSE

200: -- Parameters :
201: -- IN :
202: -- p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2(1) Optional
204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2(1) Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 206: -- Default = FND_API.G_FALSE

202: -- p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2(1) Optional
204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2(1) Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_set_def_rec IN
210: -- CS_Knowledge_PUB.set_def_rec_type Required

Line 208: -- Default = FND_API.G_VALID_LEVEL_FULL

204: -- Default = FND_API.G_FALSE
205: -- p_commit IN VARCHAR2(1) Optional
206: -- Default = FND_API.G_FALSE
207: -- p_validation_level IN NUMBER Optional
208: -- Default = FND_API.G_VALID_LEVEL_FULL
209: -- p_set_def_rec IN
210: -- CS_Knowledge_PUB.set_def_rec_type Required
211: -- Definition of the set. Must have set type, status, name.
212: -- p_ele_def_tbl IN

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

233: -- End of comments
234:
235: PROCEDURE Create_Set_And_Elements(
236: p_api_version in number,
237: p_init_msg_list in varchar2 := FND_API.G_FALSE,
238: p_commit in varchar2 := FND_API.G_FALSE,
239: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
240: x_return_status OUT NOCOPY varchar2,
241: x_msg_count OUT NOCOPY number,

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

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

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

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

Line 261: -- Default = FND_API.G_FALSE

257: -- Parameters :
258: -- IN :
259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2(1) Optional
261: -- Default = FND_API.G_FALSE
262: -- p_commit IN VARCHAR2(1) Optional
263: -- Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional
265: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 263: -- Default = FND_API.G_FALSE

259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2(1) Optional
261: -- Default = FND_API.G_FALSE
262: -- p_commit IN VARCHAR2(1) Optional
263: -- Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional
265: -- Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_set_def_rec IN
267: -- CS_Knowledge_PUB.set_def_rec_type Required

Line 265: -- Default = FND_API.G_VALID_LEVEL_FULL

261: -- Default = FND_API.G_FALSE
262: -- p_commit IN VARCHAR2(1) Optional
263: -- Default = FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Optional
265: -- Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_set_def_rec IN
267: -- CS_Knowledge_PUB.set_def_rec_type Required
268: -- Definition of the set. Must have set type, status, name.
269: -- p_ele_id_tbl IN

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

286: -- End of comments
287:
288: PROCEDURE Create_Set(
289: p_api_version in number,
290: p_init_msg_list in varchar2 := FND_API.G_FALSE,
291: p_commit in varchar2 := FND_API.G_FALSE,
292: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
293: x_return_status OUT NOCOPY varchar2,
294: x_msg_count OUT NOCOPY number,

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

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

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

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

Line 312: -- Default = FND_API.G_FALSE

308: -- Parameters :
309: -- IN :
310: -- p_api_version IN NUMBER Required
311: -- p_init_msg_list IN VARCHAR2(1) Optional
312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2(1) Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 314: -- Default = FND_API.G_FALSE

310: -- p_api_version IN NUMBER Required
311: -- p_init_msg_list IN VARCHAR2(1) Optional
312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2(1) Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL
317: -- p_ele_def_rec IN
318: -- CS_Knowledge_PUB.ele_def_rec_type Required

Line 316: -- Default = FND_API.G_VALID_LEVEL_FULL

312: -- Default = FND_API.G_FALSE
313: -- p_commit IN VARCHAR2(1) Optional
314: -- Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional
316: -- Default = FND_API.G_VALID_LEVEL_FULL
317: -- p_ele_def_rec IN
318: -- CS_Knowledge_PUB.ele_def_rec_type Required
319: -- Definition of element.
320: --

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

334: -- End of comments
335:
336: PROCEDURE Create_Element(
337: p_api_version in number,
338: p_init_msg_list in varchar2 := FND_API.G_FALSE,
339: p_commit in varchar2 := FND_API.G_FALSE,
340: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
341: x_return_status OUT NOCOPY varchar2,
342: x_msg_count OUT NOCOPY number,

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

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

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

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

Line 358: -- Default = FND_API.G_FALSE

354: -- Parameters :
355: -- IN :
356: -- p_api_version IN NUMBER Required
357: -- p_init_msg_list IN VARCHAR2(1) Optional
358: -- Default = FND_API.G_FALSE
359: -- p_validation_level IN NUMBER Optional
360: -- Default = FND_API.G_VALID_LEVEL_FULL
361: -- p_pos_query_str IN VARCHAR2 Required
362: -- p_neg_query_str IN VARCHAR2 Optional

Line 360: -- Default = FND_API.G_VALID_LEVEL_FULL

356: -- p_api_version IN NUMBER Required
357: -- p_init_msg_list IN VARCHAR2(1) Optional
358: -- Default = FND_API.G_FALSE
359: -- p_validation_level IN NUMBER Optional
360: -- Default = FND_API.G_VALID_LEVEL_FULL
361: -- p_pos_query_str IN VARCHAR2 Required
362: -- p_neg_query_str IN VARCHAR2 Optional
363: -- Default = null
364: -- p_type_id_tbl IN

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

393: -- End of comments
394:
395: PROCEDURE Find_Sets_Matching (
396: p_api_version in number,
397: p_init_msg_list in varchar2 := FND_API.G_FALSE,
398: --p_commit in varchar2 := FND_API.G_FALSE,
399: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY varchar2,
401: x_msg_count OUT NOCOPY number,

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

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

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

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

Line 423: -- Default = FND_API.G_FALSE

419: -- Parameters :
420: -- IN :
421: -- p_api_version IN NUMBER Required
422: -- p_init_msg_list IN VARCHAR2(1) Optional
423: -- Default = FND_API.G_FALSE
424: -- p_commit IN VARCHAR2(1) Optional
425: -- Default = FND_API.G_FALSE
426: -- p_validation_level IN NUMBER Optional
427: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 425: -- Default = FND_API.G_FALSE

421: -- p_api_version IN NUMBER Required
422: -- p_init_msg_list IN VARCHAR2(1) Optional
423: -- Default = FND_API.G_FALSE
424: -- p_commit IN VARCHAR2(1) Optional
425: -- Default = FND_API.G_FALSE
426: -- p_validation_level IN NUMBER Optional
427: -- Default = FND_API.G_VALID_LEVEL_FULL
428: -- p_element_link_rec IN
429: -- CS_KB_ELEMENT_LINKS%ROWTYPE Required

Line 427: -- Default = FND_API.G_VALID_LEVEL_FULL

423: -- Default = FND_API.G_FALSE
424: -- p_commit IN VARCHAR2(1) Optional
425: -- Default = FND_API.G_FALSE
426: -- p_validation_level IN NUMBER Optional
427: -- Default = FND_API.G_VALID_LEVEL_FULL
428: -- p_element_link_rec IN
429: -- CS_KB_ELEMENT_LINKS%ROWTYPE Required
430: -- Definition of element link
431: --

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

442: -- End of comments
443:
444: PROCEDURE Create_Element_Link(
445: p_api_version in number,
446: p_init_msg_list in varchar2 := FND_API.G_FALSE,
447: p_commit in varchar2 := FND_API.G_FALSE,
448: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
449: x_return_status OUT NOCOPY varchar2,
450: x_msg_count OUT NOCOPY number,

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

443:
444: PROCEDURE Create_Element_Link(
445: p_api_version in number,
446: p_init_msg_list in varchar2 := FND_API.G_FALSE,
447: p_commit in varchar2 := FND_API.G_FALSE,
448: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
449: x_return_status OUT NOCOPY varchar2,
450: x_msg_count OUT NOCOPY number,
451: x_msg_data OUT NOCOPY varchar2,

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

444: PROCEDURE Create_Element_Link(
445: p_api_version in number,
446: p_init_msg_list in varchar2 := FND_API.G_FALSE,
447: p_commit in varchar2 := FND_API.G_FALSE,
448: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
449: x_return_status OUT NOCOPY varchar2,
450: x_msg_count OUT NOCOPY number,
451: x_msg_data OUT NOCOPY varchar2,
452: p_element_link_rec in CS_KB_ELEMENT_LINKS%ROWTYPE,

Line 466: -- Default = FND_API.G_FALSE

462: -- Parameters :
463: -- IN :
464: -- p_api_version IN NUMBER Required
465: -- p_init_msg_list IN VARCHAR2(1) Optional
466: -- Default = FND_API.G_FALSE
467: -- p_commit IN VARCHAR2(1) Optional
468: -- Default = FND_API.G_FALSE
469: -- p_validation_level IN NUMBER Optional
470: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 468: -- Default = FND_API.G_FALSE

464: -- p_api_version IN NUMBER Required
465: -- p_init_msg_list IN VARCHAR2(1) Optional
466: -- Default = FND_API.G_FALSE
467: -- p_commit IN VARCHAR2(1) Optional
468: -- Default = FND_API.G_FALSE
469: -- p_validation_level IN NUMBER Optional
470: -- Default = FND_API.G_VALID_LEVEL_FULL
471: -- p_set_link_rec IN
472: -- CS_KB_SET_LINKS%ROWTYPE Required

Line 470: -- Default = FND_API.G_VALID_LEVEL_FULL

466: -- Default = FND_API.G_FALSE
467: -- p_commit IN VARCHAR2(1) Optional
468: -- Default = FND_API.G_FALSE
469: -- p_validation_level IN NUMBER Optional
470: -- Default = FND_API.G_VALID_LEVEL_FULL
471: -- p_set_link_rec IN
472: -- CS_KB_SET_LINKS%ROWTYPE Required
473: -- Definition of set link
474: --

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

485: -- End of comments
486:
487: PROCEDURE Create_Set_Link(
488: p_api_version in number,
489: p_init_msg_list in varchar2 := FND_API.G_FALSE,
490: p_commit in varchar2 := FND_API.G_FALSE,
491: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY varchar2,
493: x_msg_count OUT NOCOPY number,

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

486:
487: PROCEDURE Create_Set_Link(
488: p_api_version in number,
489: p_init_msg_list in varchar2 := FND_API.G_FALSE,
490: p_commit in varchar2 := FND_API.G_FALSE,
491: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY varchar2,
493: x_msg_count OUT NOCOPY number,
494: x_msg_data OUT NOCOPY varchar2,

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

487: PROCEDURE Create_Set_Link(
488: p_api_version in number,
489: p_init_msg_list in varchar2 := FND_API.G_FALSE,
490: p_commit in varchar2 := FND_API.G_FALSE,
491: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY varchar2,
493: x_msg_count OUT NOCOPY number,
494: x_msg_data OUT NOCOPY varchar2,
495: p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE,

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

497: );
498:
499: PROCEDURE Update_Set_Link(
500: p_api_version in number,
501: p_init_msg_list in varchar2 := FND_API.G_FALSE,
502: p_commit in varchar2 := FND_API.G_FALSE,
503: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
504: x_return_status OUT NOCOPY varchar2,
505: x_msg_count OUT NOCOPY number,

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

498:
499: PROCEDURE Update_Set_Link(
500: p_api_version in number,
501: p_init_msg_list in varchar2 := FND_API.G_FALSE,
502: p_commit in varchar2 := FND_API.G_FALSE,
503: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
504: x_return_status OUT NOCOPY varchar2,
505: x_msg_count OUT NOCOPY number,
506: x_msg_data OUT NOCOPY varchar2,

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

499: PROCEDURE Update_Set_Link(
500: p_api_version in number,
501: p_init_msg_list in varchar2 := FND_API.G_FALSE,
502: p_commit in varchar2 := FND_API.G_FALSE,
503: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
504: x_return_status OUT NOCOPY varchar2,
505: x_msg_count OUT NOCOPY number,
506: x_msg_data OUT NOCOPY varchar2,
507: p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE

Line 516: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

512: -- the record type api.
513: --
514: PROCEDURE Specific_Search(
515: p_api_version IN NUMBER,
516: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2,

Line 517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

513: --
514: PROCEDURE Specific_Search(
515: p_api_version IN NUMBER,
516: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2,
521: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 522: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

518: x_return_status OUT NOCOPY VARCHAR2,
519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2,
521: p_repository_tbl IN cs_kb_varchar100_tbl_type,
522: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
524: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
525: p_application_id IN NUMBER,
526: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,

Line 523: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2,
521: p_repository_tbl IN cs_kb_varchar100_tbl_type,
522: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
524: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
525: p_application_id IN NUMBER,
526: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
527: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,

Line 524: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

520: x_msg_data OUT NOCOPY VARCHAR2,
521: p_repository_tbl IN cs_kb_varchar100_tbl_type,
522: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
524: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
525: p_application_id IN NUMBER,
526: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
527: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
528: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,

Line 530: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

526: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
527: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
528: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
529: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
530: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_category_id IN JTF_NUMBER_TABLE,
532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,

Line 532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

528: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
529: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
530: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_category_id IN JTF_NUMBER_TABLE,
532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

529: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
530: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_category_id IN JTF_NUMBER_TABLE,
532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
540: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 554: -- Default = FND_API.G_FALSE

550: --
551: -- Parameters :
552: -- IN : p_api_version IN NUMBER Required
553: -- p_init_msg_list IN VARCHAR2(1) Optional
554: -- Default = FND_API.G_FALSE
555: -- p_validation_level IN NUMBER Optional
556: -- Default = FND_API.G_VALID_LEVEL_FULL
557: -- p_repository_tbl IN
558: -- cs_kb_varchar100_tbl_type Required

Line 556: -- Default = FND_API.G_VALID_LEVEL_FULL

552: -- IN : p_api_version IN NUMBER Required
553: -- p_init_msg_list IN VARCHAR2(1) Optional
554: -- Default = FND_API.G_FALSE
555: -- p_validation_level IN NUMBER Optional
556: -- Default = FND_API.G_VALID_LEVEL_FULL
557: -- p_repository_tbl IN
558: -- cs_kb_varchar100_tbl_type Required
559: -- valid values are MES, SMS, ALL
560: -- p_search_string IN VARCHAR2 Optional

Line 561: -- := FND_API.G_MISS_CHAR

557: -- p_repository_tbl IN
558: -- cs_kb_varchar100_tbl_type Required
559: -- valid values are MES, SMS, ALL
560: -- p_search_string IN VARCHAR2 Optional
561: -- := FND_API.G_MISS_CHAR
562: -- used for interMedia search on SMS or MES contents.
563: -- p_updated_in_days IN NUMBER Optional
564: -- := FND_API.G_MISS_NUM
565: -- days since last updated. For MES.

Line 564: -- := FND_API.G_MISS_NUM

560: -- p_search_string IN VARCHAR2 Optional
561: -- := FND_API.G_MISS_CHAR
562: -- used for interMedia search on SMS or MES contents.
563: -- p_updated_in_days IN NUMBER Optional
564: -- := FND_API.G_MISS_NUM
565: -- days since last updated. For MES.
566: -- p_check_login_user IN VARCHAR2 Optional
567: -- := FND_API.G_TRUE
568: -- whether or not to check login user's access privilege. For MES.

Line 567: -- := FND_API.G_TRUE

563: -- p_updated_in_days IN NUMBER Optional
564: -- := FND_API.G_MISS_NUM
565: -- days since last updated. For MES.
566: -- p_check_login_user IN VARCHAR2 Optional
567: -- := FND_API.G_TRUE
568: -- whether or not to check login user's access privilege. For MES.
569: -- p_application_id IN NUMBER Required
570: -- p_area_array IN
571: -- AMV_SEARCH_PVT.amv_char_varray_type Optional

Line 587: -- := FND_API.G_MISS_NUM

583: -- CAN_CONTAIN, MUST_CONTAIN, MUST_NOT_CONTAIN
584: -- Do not use this for interMedia search on content.
585: -- This is only for searching keyword, author, title_desc.
586: -- p_user_id IN NUMBER Optional
587: -- := FND_API.G_MISS_NUM
588: -- For MES
589: -- p_category_id IN
590: -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl
591: -- := AMV_SEARCH_PVT.amv_number_varray_type()

Line 594: -- := FND_API.G_FALSE

590: -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl
591: -- := AMV_SEARCH_PVT.amv_number_varray_type()
592: -- MES category identifier. Empty obj to search all MES categories.
593: -- p_include_subcats IN VARCHAR2 Optional
594: -- := FND_API.G_FALSE
595: -- Include sub categories. MES
596: -- p_external_contents IN VARCHAR2 Optional
597: -- := FND_API.G_FALSE
598: -- Include external contents. MES

Line 597: -- := FND_API.G_FALSE

593: -- p_include_subcats IN VARCHAR2 Optional
594: -- := FND_API.G_FALSE
595: -- Include sub categories. MES
596: -- p_external_contents IN VARCHAR2 Optional
597: -- := FND_API.G_FALSE
598: -- Include external contents. MES
599: -- p_rows_requested_tbl IN cs_kb_number_tbl_type Required
600: -- Number of rows requested
601: -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required

Line 604: -- := fnd_api.g_true

600: -- Number of rows requested
601: -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required
602: -- Start row position
603: -- p_get_total_cnt_flag IN VARCHAR2 Optional
604: -- := fnd_api.g_true
605: -- Whether to get total count
606: --
607: --
608: -- OUT :

Line 630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

626: -- End of comments
627: --
628: PROCEDURE Specific_Search(
629: p_api_version IN NUMBER,
630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,

Line 631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

627: --
628: PROCEDURE Specific_Search(
629: p_api_version IN NUMBER,
630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 636: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_repository_tbl IN cs_kb_varchar100_tbl_type,
636: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_repository_tbl IN cs_kb_varchar100_tbl_type,
636: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),

Line 638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_repository_tbl IN cs_kb_varchar100_tbl_type,
636: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651: p_rows_requested_tbl IN cs_kb_number_tbl_type,
652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651: p_rows_requested_tbl IN cs_kb_number_tbl_type,
652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651: p_rows_requested_tbl IN cs_kb_number_tbl_type,
652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
657: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 669: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

665: -- Same as above. With x_amv_result_array out parameter returned from Amv.
666: --
667: PROCEDURE Specific_Search(
668: p_api_version IN NUMBER,
669: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,

Line 670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

666: --
667: PROCEDURE Specific_Search(
668: p_api_version IN NUMBER,
669: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 675: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

671: x_return_status OUT NOCOPY VARCHAR2,
672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_repository_tbl IN cs_kb_varchar100_tbl_type,
675: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

672: x_msg_count OUT NOCOPY NUMBER,
673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_repository_tbl IN cs_kb_varchar100_tbl_type,
675: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),

Line 677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

673: x_msg_data OUT NOCOPY VARCHAR2,
674: p_repository_tbl IN cs_kb_varchar100_tbl_type,
675: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690: p_rows_requested_tbl IN cs_kb_number_tbl_type,
691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690: p_rows_requested_tbl IN cs_kb_number_tbl_type,
691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
693: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690: p_rows_requested_tbl IN cs_kb_number_tbl_type,
691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
693: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
694: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
695: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
696: x_result_array OUT NOCOPY cs_kb_result_varray_type,