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 CS_KNOWLEDGE_PUB

Line 47: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type

43:
44: FUNCTION Build_Solution_Text_Query
45: (
46: p_raw_text in varchar2,
47: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
48: )
49: return varchar2;
50:
51: FUNCTION Build_Solution_Text_Query

Line 54: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

50:
51: FUNCTION Build_Solution_Text_Query
52: (
53: p_raw_text in varchar2,
54: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
55: p_search_option in number
56: )
57: return varchar2;
58:

Line 62: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

58:
59: FUNCTION Build_Solution_Text_Query
60: (
61: p_raw_text in varchar2,
62: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
63: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
64: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
65: p_search_option in number
66: )

Line 63: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

59: FUNCTION Build_Solution_Text_Query
60: (
61: p_raw_text in varchar2,
62: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
63: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
64: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
65: p_search_option in number
66: )
67: return varchar2;

Line 64: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

60: (
61: p_raw_text in varchar2,
62: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
63: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
64: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
65: p_search_option in number
66: )
67: return varchar2;
68:

Line 72: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

68:
69: FUNCTION Build_Solution_Text_Query
70: (
71: p_raw_text in varchar2,
72: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
73: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
74: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
75: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
76: p_search_option in number

Line 73: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

69: FUNCTION Build_Solution_Text_Query
70: (
71: p_raw_text in varchar2,
72: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
73: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
74: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
75: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
76: p_search_option in number
77: )

Line 74: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

70: (
71: p_raw_text in varchar2,
72: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
73: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
74: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
75: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
76: p_search_option in number
77: )
78: return varchar2;

Line 75: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

71: p_raw_text in varchar2,
72: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
73: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
74: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
75: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
76: p_search_option in number
77: )
78: return varchar2;
79:

Line 83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

79:
80: FUNCTION Build_Solution_Text_Query
81: (
82: p_raw_text in varchar2,
83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

Line 84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

80: FUNCTION Build_Solution_Text_Query
81: (
82: p_raw_text in varchar2,
83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
88: p_search_option in number

Line 85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

81: (
82: p_raw_text in varchar2,
83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
88: p_search_option in number
89: )

Line 86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

82: p_raw_text in varchar2,
83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
88: p_search_option in number
89: )
90: return varchar2;

Line 87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

83: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
84: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
85: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
86: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
87: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
88: p_search_option in number
89: )
90: return varchar2;
91:

Line 103: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type

99:
100: FUNCTION Build_Statement_Text_Query
101: (
102: p_raw_text in varchar2,
103: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
104: )
105: return varchar2;
106:
107: -- 3468629

Line 111: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

107: -- 3468629
108: FUNCTION Build_Statement_Text_Query
109: (
110: p_raw_text in varchar2,
111: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
112: p_search_option in number
113: )
114: return varchar2;
115:

Line 136: p_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

132: p_separator in varchar2
133: ) return varchar2;
134:
135: FUNCTION Concat_Ids(
136: p_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
137: p_separator in varchar2
138: ) return varchar2;
139:
140: FUNCTION Is_Set_Ele_Type_Valid(

Line 196: -- p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC

192: --FUNCTION Add_Element_To_Set_Ord(
193: -- p_set_id in number,
194: -- p_ele_id in number,
195: -- p_ele_order in number,
196: -- p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC
197: --) return number;
198:
199:
200: FUNCTION Add_Element_To_Set(

Line 203: p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC,

199:
200: FUNCTION Add_Element_To_Set(
201: p_ele_id in number,
202: p_set_id in number,
203: p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC,
204: p_update_sets_b in varchar2 default 'T'
205: ) return number;
206:
207: PROCEDURE Add_External_Links(

Line 301: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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,
302: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
303: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
304: x_set_id OUT NOCOPY number
305: );

Line 302: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

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,
302: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
303: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
304: x_set_id OUT NOCOPY number
305: );
306:

Line 303: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,

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,
302: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
303: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
304: x_set_id OUT NOCOPY number
305: );
306:
307: -- New (Post 8/03/00) Contributed element ids passed back

Line 316: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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,
317: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
318: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
319: x_set_id OUT NOCOPY number,
320: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type

Line 317: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

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,
317: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
318: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
319: x_set_id OUT NOCOPY number,
320: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
321: );

Line 318: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,

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,
317: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
318: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
319: x_set_id OUT NOCOPY number,
320: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
321: );
322:

Line 320: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type

316: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
317: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
318: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
319: x_set_id OUT NOCOPY number,
320: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
321: );
322:
323: PROCEDURE Create_Set(
324: p_api_version in number,

Line 331: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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,
332: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
333: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
334: x_set_id OUT NOCOPY number
335: );

Line 332: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
332: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
333: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
334: x_set_id OUT NOCOPY number
335: );
336:

Line 333: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,

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,
332: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
333: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
334: x_set_id OUT NOCOPY number
335: );
336:
337: PROCEDURE Create_Element(

Line 345: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

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,
346: x_element_id OUT NOCOPY number
347: );
348:
349:

Line 443: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
443: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
444: -- p_other_criteria in varchar2 := NULL,
445: -- p_rows in number,
446: -- p_start_score in number := null,
447: -- p_start_id in number := null,

Line 449: -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type,

445: -- p_rows in number,
446: -- p_start_score in number := null,
447: -- p_start_id in number := null,
448: -- p_start_row in number, -- := 1,
449: -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type,
450: -- p_search_option in number := null
451: --);
452:
453: --PROCEDURE Find_Eles_Related (

Line 460: -- p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
461: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
462: -- p_other_criteria in varchar2 := NULL,
463: -- p_rows in number,
464: -- p_start_score in number := null,

Line 461: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
461: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
462: -- p_other_criteria in varchar2 := NULL,
463: -- p_rows in number,
464: -- p_start_score in number := null,
465: -- p_start_id in number := null,

Line 467: -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type

463: -- p_rows in number,
464: -- p_start_score in number := null,
465: -- p_start_id in number := null,
466: -- p_start_row in number, -- := 1,
467: -- x_ele_tbl in OUT NOCOPY CS_Knowledge_PUB.ele_res_tbl_type
468: --);
469:
470: PROCEDURE Find_Sets_Matching (
471: p_api_version in number,

Line 479: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

475: x_msg_count OUT NOCOPY number,
476: x_msg_data OUT NOCOPY varchar2,
477: p_pos_query_str in varchar2,
478: p_neg_query_str in varchar2 := null,
479: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
480: p_other_criteria in varchar2 := NULL,
481: p_rows in number,
482: p_start_score in number := null,
483: p_start_id in number := null,

Line 486: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

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: );
490:

Line 500: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

496: x_msg_count OUT NOCOPY number,
497: x_msg_data OUT NOCOPY varchar2,
498: p_pos_query_str in varchar2,
499: -- p_neg_query_str in varchar2 := null,
500: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
501: p_other_criteria in varchar2,
502: p_other_value in Number,
503: p_rows in number,
504: p_start_score in number := null,

Line 508: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

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: );
512:

Line 520: -- p_pos_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
521: -- p_neg_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,
522: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
523: -- p_other_criteria in varchar2 := NULL,
524: -- p_rows in number,

Line 521: -- p_neg_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
521: -- p_neg_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,
522: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
523: -- p_other_criteria in varchar2 := NULL,
524: -- p_rows in number,
525: -- p_start_score in number := null,

Line 522: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

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,
521: -- p_neg_ele_tbl in CS_Knowledge_PUB.number15_tbl_type,
522: -- p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
523: -- p_other_criteria in varchar2 := NULL,
524: -- p_rows in number,
525: -- p_start_score in number := null,
526: -- p_start_id in number := null,

Line 528: -- x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type

524: -- p_rows in number,
525: -- p_start_score in number := null,
526: -- p_start_id in number := null,
527: -- p_start_row in number, -- := 1,
528: -- x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type
529: --);
530:
531:
532: PROCEDURE Process_Frequency_Keyword (

Line 540: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

536:
537: FUNCTION Build_Smart_Score_Query
538: (
539: p_current_query in varchar2,
540: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
541: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
542: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
543: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
544: )

Line 541: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

537: FUNCTION Build_Smart_Score_Query
538: (
539: p_current_query in varchar2,
540: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
541: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
542: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
543: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
544: )
545: return varchar2;

Line 542: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

538: (
539: p_current_query in varchar2,
540: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
541: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
542: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
543: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
544: )
545: return varchar2;
546:

Line 543: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type

539: p_current_query in varchar2,
540: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
541: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
542: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
543: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
544: )
545: return varchar2;
546:
547: FUNCTION Build_Related_Stmt_Text_Query

Line 548: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )

544: )
545: return varchar2;
546:
547: FUNCTION Build_Related_Stmt_Text_Query
548: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
549: Return VARCHAR2;
550:
551: FUNCTION Build_SR_Text_Query
552: (