172: -- Parameters :
173: -- IN :
174: -- p_api_version IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2(1) Optional
176: -- Default = FND_API.G_FALSE
177: -- p_commit IN VARCHAR2(1) Optional
178: -- Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional
180: -- Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_api_version IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2(1) Optional
176: -- Default = FND_API.G_FALSE
177: -- p_commit IN VARCHAR2(1) Optional
178: -- Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional
180: -- Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_qry_string IN
182: -- String of keywords
176: -- Default = FND_API.G_FALSE
177: -- p_commit IN VARCHAR2(1) Optional
178: -- Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional
180: -- Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_qry_string IN
182: -- String of keywords
183: -- p_search_option IN
184: -- Search option such as and, or, not, theme
198: -- End of comments
199:
200: PROCEDURE Construct_Text_Query(
201: p_api_version in number,
202: p_init_msg_list in varchar2 := FND_API.G_FALSE,
203: p_commit in varchar2 := FND_API.G_FALSE,
204: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY varchar2,
206: x_msg_count OUT NOCOPY number,
199:
200: PROCEDURE Construct_Text_Query(
201: p_api_version in number,
202: p_init_msg_list in varchar2 := FND_API.G_FALSE,
203: p_commit in varchar2 := FND_API.G_FALSE,
204: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY varchar2,
206: x_msg_count OUT NOCOPY number,
207: x_msg_data OUT NOCOPY varchar2,
200: PROCEDURE Construct_Text_Query(
201: p_api_version in number,
202: p_init_msg_list in varchar2 := FND_API.G_FALSE,
203: p_commit in varchar2 := FND_API.G_FALSE,
204: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
205: x_return_status OUT NOCOPY varchar2,
206: x_msg_count OUT NOCOPY number,
207: x_msg_data OUT NOCOPY varchar2,
208: p_qry_string in varchar2,
220: -- Parameters :
221: -- IN :
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2(1) Optional
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2(1) Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2(1) Optional
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2(1) Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_set_def_rec IN
230: -- CS_Knowledge_PUB.set_def_rec_type Required
224: -- Default = FND_API.G_FALSE
225: -- p_commit IN VARCHAR2(1) Optional
226: -- Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional
228: -- Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_set_def_rec IN
230: -- CS_Knowledge_PUB.set_def_rec_type Required
231: -- Definition of the set. Must have set type, status, name.
232: -- p_ele_def_tbl IN
253: -- End of comments
254:
255: PROCEDURE Create_Set_And_Elements(
256: p_api_version in number,
257: p_init_msg_list in varchar2 := FND_API.G_FALSE,
258: p_commit in varchar2 := FND_API.G_FALSE,
259: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
260: x_return_status OUT NOCOPY varchar2,
261: x_msg_count OUT NOCOPY number,
254:
255: PROCEDURE Create_Set_And_Elements(
256: p_api_version in number,
257: p_init_msg_list in varchar2 := FND_API.G_FALSE,
258: p_commit in varchar2 := FND_API.G_FALSE,
259: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
260: x_return_status OUT NOCOPY varchar2,
261: x_msg_count OUT NOCOPY number,
262: x_msg_data OUT NOCOPY varchar2,
255: PROCEDURE Create_Set_And_Elements(
256: p_api_version in number,
257: p_init_msg_list in varchar2 := FND_API.G_FALSE,
258: p_commit in varchar2 := FND_API.G_FALSE,
259: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
260: x_return_status OUT NOCOPY varchar2,
261: x_msg_count OUT NOCOPY number,
262: x_msg_data OUT NOCOPY varchar2,
263: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,