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 239: p_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

235:
236: end Concat_Ids;
237:
238: FUNCTION Concat_Ids(
239: p_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
240: p_separator in varchar2
241: ) return varchar2 is
242: l_str varchar2(1990) := null;
243: i1 pls_integer;

Line 406: l_csr CS_Knowledge_PUB.general_csr_type;

402: /* New - uses bind variables */
403: FUNCTION Do_Elements_Exist_In_Set (
404: p_ele_id_tbl in cs_kb_number_tbl_type)
405: return varchar2 is
406: l_csr CS_Knowledge_PUB.general_csr_type;
407: l_sid number(15);
408: l_total pls_integer :=0;
409: l_count pls_integer := 0;
410: l_sqlstr1 varchar2(100) :=

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

1329: -- Add element
1330: FUNCTION Add_Element_To_Set(
1331: p_ele_id in number,
1332: p_set_id in number,
1333: p_assoc_degree in number := CS_Knowledge_PUB.G_POSITIVE_ASSOC,
1334: p_update_sets_b in varchar2
1335: ) return number is
1336: l_count pls_integer;
1337: l_date date;

Line 1433: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

1429: -- -- -- Copy from records to objects -- -- -- --
1430: --
1431:
1432: PROCEDURE Copy_Eledef_To_Obj(
1433: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
1434: x_ele_def_obj OUT NOCOPY cs_kb_ele_def_obj_type
1435: ) is
1436: begin
1437:

Line 1475: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1471: --
1472: -- Copy set def from record to object
1473: --
1474: PROCEDURE Copy_Setdef_To_Obj(
1475: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1476: x_set_def_obj OUT NOCOPY cs_kb_set_def_obj_type
1477: ) is
1478: begin
1479:

Line 1529: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1525: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1526: x_return_status OUT NOCOPY varchar2,
1527: x_msg_count OUT NOCOPY number,
1528: x_msg_data OUT NOCOPY varchar2,
1529: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1530: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1531: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1532: x_set_id OUT NOCOPY number
1533: )is

Line 1530: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

1526: x_return_status OUT NOCOPY varchar2,
1527: x_msg_count OUT NOCOPY number,
1528: x_msg_data OUT NOCOPY varchar2,
1529: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1530: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1531: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1532: x_set_id OUT NOCOPY number
1533: )is
1534: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 1531: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,

1527: x_msg_count OUT NOCOPY number,
1528: x_msg_data OUT NOCOPY varchar2,
1529: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1530: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1531: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1532: x_set_id OUT NOCOPY number
1533: )is
1534: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;
1535: i1 pls_integer;

Line 1534: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;

1530: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1531: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1532: x_set_id OUT NOCOPY number
1533: )is
1534: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;
1535: i1 pls_integer;
1536: begin
1537:
1538: Create_Set_And_Elements(

Line 1564: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY varchar2,
1562: x_msg_count OUT NOCOPY number,
1563: x_msg_data OUT NOCOPY varchar2,
1564: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1565: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1566: x_set_id OUT NOCOPY number,
1567: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1568: )

Line 1565: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

1561: x_return_status OUT NOCOPY varchar2,
1562: x_msg_count OUT NOCOPY number,
1563: x_msg_data OUT NOCOPY varchar2,
1564: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1565: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1566: x_set_id OUT NOCOPY number,
1567: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1568: )
1569: is

Line 1567: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type

1563: x_msg_data OUT NOCOPY varchar2,
1564: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1565: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1566: x_set_id OUT NOCOPY number,
1567: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1568: )
1569: is
1570: l_set_def_obj cs_kb_set_def_obj_type;
1571: l_ele_def_tbl cs_kb_ele_def_tbl_type;

Line 1612: x_element_id_tbl := cs_knowledge_pub.number15_tbl_type();

1608: end if;
1609:
1610: -- Create new element id table out param if it's not there
1611: if ( x_element_id_tbl is null) then
1612: x_element_id_tbl := cs_knowledge_pub.number15_tbl_type();
1613: end if;
1614:
1615: -- Copy the resulting element id's from obj to out record
1616: if ( l_element_id_tbl is not null ) then

Line 2052: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

2048: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2049: x_return_status OUT NOCOPY varchar2,
2050: x_msg_count OUT NOCOPY number,
2051: x_msg_data OUT NOCOPY varchar2,
2052: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
2053: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2054: x_set_id OUT NOCOPY number
2055: ) is
2056: l_set_def_obj cs_kb_set_def_obj_type;

Line 2053: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

2049: x_return_status OUT NOCOPY varchar2,
2050: x_msg_count OUT NOCOPY number,
2051: x_msg_data OUT NOCOPY varchar2,
2052: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
2053: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2054: x_set_id OUT NOCOPY number
2055: ) is
2056: l_set_def_obj cs_kb_set_def_obj_type;
2057: l_ele_id_tbl cs_kb_number_tbl_type

Line 2293: p_ele_assoc_tbl(i1)=CS_Knowledge_PUB.G_POSITIVE_ASSOC) then

2289:
2290:
2291: if(p_ele_assoc_tbl is null or p_ele_assoc_tbl.count<1 or
2292: p_ele_assoc_tbl(i1) is null or
2293: p_ele_assoc_tbl(i1)=CS_Knowledge_PUB.G_POSITIVE_ASSOC) then
2294: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;
2295: else
2296: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;
2297: end if;

Line 2294: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;

2290:
2291: if(p_ele_assoc_tbl is null or p_ele_assoc_tbl.count<1 or
2292: p_ele_assoc_tbl(i1) is null or
2293: p_ele_assoc_tbl(i1)=CS_Knowledge_PUB.G_POSITIVE_ASSOC) then
2294: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;
2295: else
2296: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;
2297: end if;
2298:

Line 2296: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;

2292: p_ele_assoc_tbl(i1) is null or
2293: p_ele_assoc_tbl(i1)=CS_Knowledge_PUB.G_POSITIVE_ASSOC) then
2294: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;
2295: else
2296: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;
2297: end if;
2298:
2299: OPEN Check_Dup_Ele_Insert( l_set_id, p_ele_id_tbl(i1) );
2300: FETCH Check_Dup_Ele_Insert INTO l_set_ele_count;

Line 2374: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

2370: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2371: x_return_status OUT NOCOPY varchar2,
2372: x_msg_count OUT NOCOPY number,
2373: x_msg_data OUT NOCOPY varchar2,
2374: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
2375: x_element_id OUT NOCOPY number
2376: ) is
2377: l_ele_def_obj cs_kb_ele_def_obj_type;
2378:

Line 2733: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY) --FUZZY

2729: substr(l_string, 1, len-1); --from beg till char before space
2730:
2731: if (first_word = TRUE)
2732: then
2733: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY) --FUZZY
2734: then
2735: q_word := '?'''||l_criteria_word||'''';
2736: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM) --SYNONYM
2737: then

Line 2736: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM) --SYNONYM

2732: then
2733: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY) --FUZZY
2734: then
2735: q_word := '?'''||l_criteria_word||'''';
2736: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM) --SYNONYM
2737: then
2738: q_word := 'SYN('||l_criteria_word||')';
2739: else
2740: q_word := ''''||l_criteria_word||'''';

Line 2743: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)

2739: else
2740: q_word := ''''||l_criteria_word||'''';
2741: end if;
2742: else
2743: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2744: then
2745: l_operator := ' & ';
2746: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2747: then

Line 2746: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)

2742: else
2743: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2744: then
2745: l_operator := ' & ';
2746: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2747: then
2748: l_operator := ' | ';
2749: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2750: then

Line 2749: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2745: l_operator := ' & ';
2746: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2747: then
2748: l_operator := ' | ';
2749: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2750: then
2751: l_operator := ' , ?';
2752: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2753: then

Line 2752: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)

2748: l_operator := ' | ';
2749: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2750: then
2751: l_operator := ' , ?';
2752: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2753: then
2754: l_operator := ' , SYN';
2755: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2756: then

Line 2755: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)

2751: l_operator := ' , ?';
2752: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2753: then
2754: l_operator := ' , SYN';
2755: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2756: then
2757: l_operator := ' , ';
2758: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2759: then

Line 2758: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)

2754: l_operator := ' , SYN';
2755: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2756: then
2757: l_operator := ' , ';
2758: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2759: then
2760: l_operator := ' ';
2761: else -- if other cases
2762: l_operator := ' , ';

Line 2764: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)

2760: l_operator := ' ';
2761: else -- if other cases
2762: l_operator := ' , ';
2763: end if;
2764: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2765: then
2766: q_word := q_word||l_operator||'('||l_criteria_word||')';
2767: else
2768: q_word := q_word||l_operator||''''||l_criteria_word||'''';

Line 2909: -- p_search_option NUMBER: search option, as defined in CS_KNOWLEDGE_PUB

2905: -- Add the next term to the query string according to search option
2906: -- Parameters:
2907: -- p_string VARCHAR2: the running keyword string
2908: -- p_term VARCHAR2: the term to append
2909: -- p_search_option NUMBER: search option, as defined in CS_KNOWLEDGE_PUB
2910: -- Returns:
2911: -- Query string with the term appended using the appropriate search operator
2912: -- Since 12.0
2913: --

Line 2930: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2926: end if;
2927:
2928: if( trim(l_string) is null ) -- first term
2929: then
2930: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2931: then
2932: l_string := '?'''|| p_term ||'''';
2933: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2934: then

Line 2933: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)

2929: then
2930: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2931: then
2932: l_string := '?'''|| p_term ||'''';
2933: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2934: then
2935: l_string := 'SYN('|| p_term ||')';
2936: else
2937: l_string := p_term;

Line 2940: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)

2936: else
2937: l_string := p_term;
2938: end if;
2939: else -- subsequent terms
2940: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2941: then
2942: l_operator := ' & ';
2943: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2944: then

Line 2943: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)

2939: else -- subsequent terms
2940: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2941: then
2942: l_operator := ' & ';
2943: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2944: then
2945: l_operator := ' | ';
2946: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2947: then

Line 2946: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2942: l_operator := ' & ';
2943: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2944: then
2945: l_operator := ' | ';
2946: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2947: then
2948: l_operator := ' , ?';
2949: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2950: then

Line 2949: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)

2945: l_operator := ' | ';
2946: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2947: then
2948: l_operator := ' , ?';
2949: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2950: then
2951: l_operator := ' , SYN';
2952: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2953: then

Line 2952: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)

2948: l_operator := ' , ?';
2949: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2950: then
2951: l_operator := ' , SYN';
2952: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2953: then
2954: l_operator := ' , ';
2955: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2956: then

Line 2955: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)

2951: l_operator := ' , SYN';
2952: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2953: then
2954: l_operator := ' , ';
2955: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2956: then
2957: l_operator := ' ';
2958: else -- if other cases
2959: l_operator := ' , ';

Line 2961: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)

2957: l_operator := ' ';
2958: else -- if other cases
2959: l_operator := ' , ';
2960: end if;
2961: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_SYNONYM)
2962: then
2963: l_string := l_string || l_operator||'('|| p_term||')' ;
2964: else
2965: l_string := l_string || l_operator|| p_term ;

Line 3059: l_phrase := Replace_Whitespace(l_phrase, CS_KNOWLEDGE_PUB.MATCH_PHRASE);

3055: LOOP
3056: --dbms_output.put_line('Phrase[' || l_counter || '] = ' || l_phrase_list(l_counter));
3057: --process each phrase as an exact phrase
3058: l_phrase := Escape_Special_Char( l_phrase_list(l_counter) );
3059: l_phrase := Replace_Whitespace(l_phrase, CS_KNOWLEDGE_PUB.MATCH_PHRASE);
3060: l_phrase := '(' || l_phrase || ')';
3061: l_processed_keyword :=
3062: Append_Query_Term(l_processed_keyword, l_phrase, p_search_option);
3063: l_counter := l_phrase_list.NEXT(l_counter);

Line 3172: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or

3168: -- If the Search option chosen is THEME Search or if there is
3169: -- no search option chosen, then rewrite the raw text query
3170: -- with the theme search query and concatenate it with a regular
3171: -- non-theme based rewritten query
3172: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or
3173: p_search_option is null) --DEFAULT
3174: then
3175: l_keyword_query :=
3176: Build_Keyword_Query

Line 3208: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type )

3204: -- (1) -calls (2)
3205: --
3206: FUNCTION Build_Solution_Text_Query
3207: ( p_raw_text in varchar2,
3208: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
3209: return varchar2
3210: is
3211: l_number number;
3212: begin

Line 3223: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3219: -- CONTAINS predicate for a solution search
3220: -- (2) calls (3)
3221: FUNCTION Build_Solution_Text_Query
3222: ( p_raw_text in varchar2,
3223: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3224: p_search_option in number )
3225: return varchar2
3226: is
3227: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3227: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3223: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3224: p_search_option in number )
3225: return varchar2
3226: is
3227: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3228: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3229: begin
3230: return Build_Solution_Text_Query(
3231: p_raw_text, p_solution_type_id_tbl,

Line 3228: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3224: p_search_option in number )
3225: return varchar2
3226: is
3227: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3228: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3229: begin
3230: return Build_Solution_Text_Query(
3231: p_raw_text, p_solution_type_id_tbl,
3232: l_product_id_tbl, l_platform_id_tbl, p_search_option);

Line 3241: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3237: -- CONTAINS predicate for a solution search
3238: -- (3) calls (4)
3239: FUNCTION Build_Solution_Text_Query
3240: ( p_raw_text in varchar2,
3241: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3242: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3243: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3244: p_search_option in number )
3245: return varchar2

Line 3242: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3238: -- (3) calls (4)
3239: FUNCTION Build_Solution_Text_Query
3240: ( p_raw_text in varchar2,
3241: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3242: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3243: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3244: p_search_option in number )
3245: return varchar2
3246: is

Line 3243: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3239: FUNCTION Build_Solution_Text_Query
3240: ( p_raw_text in varchar2,
3241: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3242: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3243: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3244: p_search_option in number )
3245: return varchar2
3246: is
3247: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3247: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3243: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3244: p_search_option in number )
3245: return varchar2
3246: is
3247: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3248: begin
3249: return Build_Solution_Text_Query(
3250: p_raw_text, p_solution_type_id_tbl,
3251: p_product_id_tbl, p_platform_id_tbl, l_category_id_tbl, p_search_option);

Line 3260: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3256: -- CONTAINS predicate for a solution search
3257: -- (4) calls (5)
3258: FUNCTION Build_Solution_Text_Query
3259: ( p_raw_text in varchar2,
3260: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3264: p_search_option in number )

Line 3261: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3257: -- (4) calls (5)
3258: FUNCTION Build_Solution_Text_Query
3259: ( p_raw_text in varchar2,
3260: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3264: p_search_option in number )
3265: return varchar2

Line 3262: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3258: FUNCTION Build_Solution_Text_Query
3259: ( p_raw_text in varchar2,
3260: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3264: p_search_option in number )
3265: return varchar2
3266: is

Line 3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3259: ( p_raw_text in varchar2,
3260: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3264: p_search_option in number )
3265: return varchar2
3266: is
3267: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3267: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3263: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3264: p_search_option in number )
3265: return varchar2
3266: is
3267: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3268: begin
3269: return Build_Solution_Text_Query(
3270: p_raw_text, p_solution_type_id_tbl,
3271: p_product_id_tbl, p_platform_id_tbl, p_category_id_tbl,

Line 3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3278: -- Handles keywords, solution type, products, platforms, category,
3279: -- solution number and statement id
3280: FUNCTION Build_Solution_Text_Query
3281: ( p_raw_text in varchar2,
3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

Line 3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3279: -- solution number and statement id
3280: FUNCTION Build_Solution_Text_Query
3281: ( p_raw_text in varchar2,
3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3287: p_search_option in number )

Line 3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3280: FUNCTION Build_Solution_Text_Query
3281: ( p_raw_text in varchar2,
3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3287: p_search_option in number )
3288: return varchar2

Line 3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3281: ( p_raw_text in varchar2,
3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3287: p_search_option in number )
3288: return varchar2
3289: is

Line 3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3282: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3283: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3284: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3285: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3286: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3287: p_search_option in number )
3288: return varchar2
3289: is
3290: l_query_str varchar2(30000) := p_raw_text;

Line 3381: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)

3377: --(SMARTSCORE), remove all logic in this block.
3378: null;
3379: Else -- when p_raw_text is not null
3380:
3381: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)
3382: then
3383: l_query_str := Build_Intermedia_Query( l_query_str, p_search_option);
3384: end if;
3385:

Line 3595: if (p_search_option = CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX) -- Intermedia Syntax

3591: l_query_str varchar2(30000) := p_qry_string;
3592:
3593: begin
3594:
3595: if (p_search_option = CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX) -- Intermedia Syntax
3596: then
3597: return l_query_str;
3598: end if;
3599:

Line 3610: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type

3606: -- (3468629)
3607: -- Make the old API backward compatible.
3608: FUNCTION Build_Statement_Text_Query
3609: ( p_raw_text in varchar2,
3610: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
3611: )
3612: return varchar2
3613: is
3614: begin

Line 3618: CS_KNOWLEDGE_PUB.MATCH_ACCUM -- default to Accumulate

3614: begin
3615: Return Build_Statement_Text_Query (
3616: p_raw_text,
3617: p_statement_type_id_tbl,
3618: CS_KNOWLEDGE_PUB.MATCH_ACCUM -- default to Accumulate
3619: );
3620: end Build_Statement_Text_Query;
3621:
3622:

Line 3625: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3621:
3622:
3623: FUNCTION Build_Statement_Text_Query
3624: ( p_raw_text in varchar2,
3625: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3626: p_search_option in number
3627: )
3628: return varchar2
3629: is

Line 3701: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)

3697: l_query_str := l_raw_text;
3698:
3699: --3. Process l_raw_text
3700: If l_query_str is not null Then
3701: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)
3702: Then
3703: l_query_str := Build_Intermedia_Query(
3704: l_query_str,
3705: p_search_option);

Line 3801: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3797: x_msg_count OUT NOCOPY number,
3798: x_msg_data OUT NOCOPY varchar2,
3799: p_pos_query_str in varchar2,
3800: p_neg_query_str in varchar2 := null,
3801: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3802: p_other_criteria in varchar2 := NULL,
3803: p_rows in number,
3804: p_start_score in number := null,
3805: p_start_id in number := null,

Line 3808: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

3804: p_start_score in number := null,
3805: p_start_id in number := null,
3806: p_start_row in number, -- := 1,
3807: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3808: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3809: x_total_rows OUT NOCOPY number,
3810: p_search_option in number := null
3811: )is
3812: l_api_name CONSTANT varchar2(30) := 'Find_Sets_Matching';

Line 3817: l_sets_csr CS_Knowledge_PUB.general_csr_type;

3813: l_api_version CONSTANT number := 1.0;
3814: l_type_cond varchar2(500) := null;
3815: l_types varchar2(1000);
3816: l_qstr varchar2(1990);
3817: l_sets_csr CS_Knowledge_PUB.general_csr_type;
3818: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
3819: l_score_cond varchar2(100) := null;
3820: l_id_cond varchar2(100) := null;
3821: l_end_row number;

Line 3818: l_set_rec CS_Knowledge_PUB.set_res_rec_type;

3814: l_type_cond varchar2(500) := null;
3815: l_types varchar2(1000);
3816: l_qstr varchar2(1990);
3817: l_sets_csr CS_Knowledge_PUB.general_csr_type;
3818: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
3819: l_score_cond varchar2(100) := null;
3820: l_id_cond varchar2(100) := null;
3821: l_end_row number;
3822: --l_str_p varchar2(2000) := p_pos_query_str;

Line 3877: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();

3873:
3874: -- -- -- -- begin my code -- -- -- -- --
3875:
3876: if(x_set_tbl is null) then
3877: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();
3878: end if;
3879:
3880: --process strings
3881: if(p_pos_query_str is not null) then

Line 3981: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);

3977: p_start_row => p_start_row,
3978: p_get_total_flag => p_get_total_flag,
3979: x_set_tbl => x_set_tbl,
3980: x_total_rows => x_total_rows,
3981: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
3982: else
3983: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3985: IF FND_MSG_PUB.Check_Msg_Level

Line 4009: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4005: x_msg_count OUT NOCOPY number,
4006: x_msg_data OUT NOCOPY varchar2,
4007: p_pos_query_str in varchar2,
4008: --p_neg_query_str in varchar2 := null,
4009: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4010: p_other_criteria in varchar2,
4011: p_other_value in number,
4012: p_rows in number,
4013: p_start_score in number := null,

Line 4017: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

4013: p_start_score in number := null,
4014: p_start_id in number := null,
4015: p_start_row in number, -- := 1,
4016: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
4017: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
4018: x_total_rows OUT NOCOPY number,
4019: p_search_option in number := null
4020: )is
4021: l_api_name CONSTANT varchar2(30) := 'Find_Sets_Matching';

Line 4026: l_sets_csr CS_Knowledge_PUB.general_csr_type;

4022: l_api_version CONSTANT number := 1.0;
4023: l_type_cond varchar2(500) := null;
4024: l_types varchar2(1000);
4025: l_qstr varchar2(1990);
4026: l_sets_csr CS_Knowledge_PUB.general_csr_type;
4027: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
4028: l_score_cond varchar2(100) := null;
4029: l_id_cond varchar2(100) := null;
4030: l_end_row number;

Line 4027: l_set_rec CS_Knowledge_PUB.set_res_rec_type;

4023: l_type_cond varchar2(500) := null;
4024: l_types varchar2(1000);
4025: l_qstr varchar2(1990);
4026: l_sets_csr CS_Knowledge_PUB.general_csr_type;
4027: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
4028: l_score_cond varchar2(100) := null;
4029: l_id_cond varchar2(100) := null;
4030: l_end_row number;
4031: --l_str_p varchar2(2000) := p_pos_query_str;

Line 4083: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();

4079:
4080: -- -- -- -- begin my code -- -- -- -- --
4081:
4082: if(x_set_tbl is null) then
4083: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();
4084: end if;
4085:
4086: --process strings
4087: if(p_pos_query_str is not null) then

Line 4184: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);

4180: p_start_row => p_start_row,
4181: p_get_total_flag => p_get_total_flag,
4182: x_set_tbl => x_set_tbl,
4183: x_total_rows => x_total_rows,
4184: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
4185: else
4186: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4188: IF FND_MSG_PUB.Check_Msg_Level

Line 4230: If p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM Then

4226: Fetch Get_Frequency_Csr Into l_not_use_freq;
4227: Close Get_Frequency_Csr;
4228:
4229: If l_not_use_freq = 'N' Then
4230: If p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM Then
4231: -- For Accum operator, add magicword as
4232: -- e.g. (A, B, C, magicword*0.1*0.1*0.1)
4233: Open Get_Magic_Word_Csr;
4234: Fetch Get_Magic_Word_Csr Into l_magic_word;

Line 4264: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL

4260: p_query_str := p_query_str||', '''||l_magic_word
4261: ||'''*'||l_freq_term_weight;
4262: End If;
4263:
4264: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL
4265: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then
4266: -- For ALL operator and Exact Phrase, amplify score by 100
4267: p_query_str := '('||p_query_str||')*10*10';
4268: Else

Line 4265: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then

4261: ||'''*'||l_freq_term_weight;
4262: End If;
4263:
4264: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL
4265: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then
4266: -- For ALL operator and Exact Phrase, amplify score by 100
4267: p_query_str := '('||p_query_str||')*10*10';
4268: Else
4269: null;

Line 4284: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4280: -- This function also takes care the empty p_current_query case.
4281: FUNCTION Build_Smart_Score_Query
4282: (
4283: p_current_query in varchar2,
4284: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4285: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4286: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4287: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4288: ) return varchar2

Line 4285: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4281: FUNCTION Build_Smart_Score_Query
4282: (
4283: p_current_query in varchar2,
4284: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4285: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4286: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4287: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4288: ) return varchar2
4289: Is

Line 4286: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4282: (
4283: p_current_query in varchar2,
4284: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4285: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4286: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4287: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4288: ) return varchar2
4289: Is
4290: l_final_query VARCHAR2(4000) := '';

Line 4287: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type

4283: p_current_query in varchar2,
4284: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4285: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4286: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4287: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4288: ) return varchar2
4289: Is
4290: l_final_query VARCHAR2(4000) := '';
4291: l_temp_query VARCHAR2(2000) := '';

Line 4349: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )

4345: -- Handles statement id.
4346: -- By default, it generates an Accumulate string if more
4347: -- than one statement ids are given.
4348: FUNCTION Build_Related_Stmt_Text_Query
4349: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
4350: return varchar2
4351: is
4352: l_lang_str varchar2(200);
4353:

Line 4488: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or

4484: -- If the Search option chosen is THEME Search or if there is
4485: -- no search option chosen, then rewrite the raw text query
4486: -- with the theme search query and concatenate it with a regular
4487: -- non-theme based rewritten query
4488: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or
4489: p_search_option is null) --DEFAULT
4490: then
4491: l_keyword_query :=
4492: Build_Keyword_Query