DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_GRP dependencies on CS_KNOWLEDGE_PUB

Line 229: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

225: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY varchar2,
227: x_msg_count OUT NOCOPY number,
228: x_msg_data OUT NOCOPY varchar2,
229: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
230: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
231: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type :=null,
232: x_set_id OUT NOCOPY number
233: )is

Line 230: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

226: x_return_status OUT NOCOPY varchar2,
227: x_msg_count OUT NOCOPY number,
228: x_msg_data OUT NOCOPY varchar2,
229: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
230: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
231: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type :=null,
232: x_set_id OUT NOCOPY number
233: )is
234: l_api_name CONSTANT varchar2(30) := 'Create_Set_And_Elements';

Line 231: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type :=null,

227: x_msg_count OUT NOCOPY number,
228: x_msg_data OUT NOCOPY varchar2,
229: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
230: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
231: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type :=null,
232: x_set_id OUT NOCOPY number
233: )is
234: l_api_name CONSTANT varchar2(30) := 'Create_Set_And_Elements';
235: l_api_version CONSTANT number := 1.0;

Line 299: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

295: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY varchar2,
297: x_msg_count OUT NOCOPY number,
298: x_msg_data OUT NOCOPY varchar2,
299: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
300: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
301: x_set_id OUT NOCOPY number,
302: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
303: )

Line 300: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

296: x_return_status OUT NOCOPY varchar2,
297: x_msg_count OUT NOCOPY number,
298: x_msg_data OUT NOCOPY varchar2,
299: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
300: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
301: x_set_id OUT NOCOPY number,
302: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
303: )
304: IS

Line 302: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type

298: x_msg_data OUT NOCOPY varchar2,
299: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
300: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
301: x_set_id OUT NOCOPY number,
302: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
303: )
304: IS
305: l_api_name CONSTANT varchar2(30) := 'Create_Set_And_Elements';
306: l_api_version CONSTANT number := 1.0;

Line 373: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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_rec in CS_Knowledge_PUB.set_def_rec_type,
374: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
375: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type := null,
376: x_set_id OUT NOCOPY number
377: ) is

Line 374: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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_rec in CS_Knowledge_PUB.set_def_rec_type,
374: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
375: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type := null,
376: x_set_id OUT NOCOPY number
377: ) is
378: l_api_name CONSTANT varchar2(30) := 'Create_Set';

Line 375: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type := null,

371: x_msg_count OUT NOCOPY number,
372: x_msg_data OUT NOCOPY varchar2,
373: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
374: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
375: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type := null,
376: x_set_id OUT NOCOPY number
377: ) is
378: l_api_name CONSTANT varchar2(30) := 'Create_Set';
379: l_api_version CONSTANT number := 1.0;

Line 448: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

444: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
445: x_return_status OUT NOCOPY varchar2,
446: x_msg_count OUT NOCOPY number,
447: x_msg_data OUT NOCOPY varchar2,
448: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
449:
450: x_element_id OUT NOCOPY number
451: ) is
452: l_api_name CONSTANT varchar2(30) := 'Create_Element';

Line 516: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

512: x_msg_data OUT NOCOPY varchar2,
513: --p_sets_c in OUT NOCOPY general_csr_type,
514: p_pos_query_str in varchar2,
515: p_neg_query_str in varchar2 := null,
516: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
517: p_other_criteria in varchar2 := NULL,
518: p_rows in number,
519: p_start_score in number := null,
520: p_start_id in number := null,

Line 521: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type

517: p_other_criteria in varchar2 := NULL,
518: p_rows in number,
519: p_start_score in number := null,
520: p_start_id in number := null,
521: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type
522: )is
523: l_api_name CONSTANT varchar2(30) := 'Find_Sets_Matching';
524: l_api_version CONSTANT number := 1.0;
525: l_total_rows number :=0;

Line 1018: l_sms_res_tbl CS_Knowledge_PUB.set_res_tbl_type;

1014: )is
1015: err_num number;
1016: err_msg varchar2(100);
1017: l_days_cond varchar2(100) := '';
1018: l_sms_res_tbl CS_Knowledge_PUB.set_res_tbl_type;
1019: l_total_cnt pls_integer :=0;
1020: l_next_pos pls_integer :=0;
1021: l_ret_cnt pls_integer :=0;
1022: begin

Line 1377: l_search_option := CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX;

1373: -- 08/10/2004, klou, check search option
1374: if l_search_option is null then
1375: -- default to interMedia search, as this API is specifically for
1376: -- eMail center, and they always want interMedia search.
1377: l_search_option := CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX;
1378: end if;
1379:
1380: -- x_row_return_obj := cs_kb_rowret_obj_type(0, 0, 0);
1381: