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

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

Line 404: l_csr CS_Knowledge_PUB.general_csr_type;

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

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

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

Line 1429: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

1425: -- -- -- Copy from records to objects -- -- -- --
1426: --
1427:
1428: PROCEDURE Copy_Eledef_To_Obj(
1429: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
1430: x_ele_def_obj OUT NOCOPY cs_kb_ele_def_obj_type
1431: ) is
1432: begin
1433:

Line 1471: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1467: --
1468: -- Copy set def from record to object
1469: --
1470: PROCEDURE Copy_Setdef_To_Obj(
1471: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1472: x_set_def_obj OUT NOCOPY cs_kb_set_def_obj_type
1473: ) is
1474: begin
1475:

Line 1525: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1521: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1522: x_return_status OUT NOCOPY varchar2,
1523: x_msg_count OUT NOCOPY number,
1524: x_msg_data OUT NOCOPY varchar2,
1525: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1526: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1527: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1528: x_set_id OUT NOCOPY number
1529: )is

Line 1526: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

1522: x_return_status OUT NOCOPY varchar2,
1523: x_msg_count OUT NOCOPY number,
1524: x_msg_data OUT NOCOPY varchar2,
1525: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1526: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1527: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1528: x_set_id OUT NOCOPY number
1529: )is
1530: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 1527: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,

1523: x_msg_count OUT NOCOPY number,
1524: x_msg_data OUT NOCOPY varchar2,
1525: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1526: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1527: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1528: x_set_id OUT NOCOPY number
1529: )is
1530: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;
1531: i1 pls_integer;

Line 1530: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;

1526: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1527: -- p_attrval_def_tbl in CS_Knowledge_PUB.attrval_def_tbl_type,
1528: x_set_id OUT NOCOPY number
1529: )is
1530: l_element_id_tbl CS_Knowledge_PUB.number15_tbl_type;
1531: i1 pls_integer;
1532: begin
1533:
1534: Create_Set_And_Elements(

Line 1560: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

1556: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1557: x_return_status OUT NOCOPY varchar2,
1558: x_msg_count OUT NOCOPY number,
1559: x_msg_data OUT NOCOPY varchar2,
1560: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1561: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1562: x_set_id OUT NOCOPY number,
1563: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1564: )

Line 1561: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,

1557: x_return_status OUT NOCOPY varchar2,
1558: x_msg_count OUT NOCOPY number,
1559: x_msg_data OUT NOCOPY varchar2,
1560: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1561: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1562: x_set_id OUT NOCOPY number,
1563: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1564: )
1565: is

Line 1563: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type

1559: x_msg_data OUT NOCOPY varchar2,
1560: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
1561: p_ele_def_tbl in CS_Knowledge_PUB.ele_def_tbl_type,
1562: x_set_id OUT NOCOPY number,
1563: x_element_id_tbl OUT NOCOPY CS_Knowledge_PUB.number15_tbl_type
1564: )
1565: is
1566: l_set_def_obj cs_kb_set_def_obj_type;
1567: l_ele_def_tbl cs_kb_ele_def_tbl_type;

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

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

Line 2048: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

2044: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2045: x_return_status OUT NOCOPY varchar2,
2046: x_msg_count OUT NOCOPY number,
2047: x_msg_data OUT NOCOPY varchar2,
2048: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
2049: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2050: x_set_id OUT NOCOPY number
2051: ) is
2052: l_set_def_obj cs_kb_set_def_obj_type;

Line 2049: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

2045: x_return_status OUT NOCOPY varchar2,
2046: x_msg_count OUT NOCOPY number,
2047: x_msg_data OUT NOCOPY varchar2,
2048: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,
2049: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2050: x_set_id OUT NOCOPY number
2051: ) is
2052: l_set_def_obj cs_kb_set_def_obj_type;
2053: l_ele_id_tbl cs_kb_number_tbl_type

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

2285:
2286:
2287: if(p_ele_assoc_tbl is null or p_ele_assoc_tbl.count<1 or
2288: p_ele_assoc_tbl(i1) is null or
2289: p_ele_assoc_tbl(i1)=CS_Knowledge_PUB.G_POSITIVE_ASSOC) then
2290: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;
2291: else
2292: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;
2293: end if;

Line 2290: l_assoc := CS_Knowledge_PUB.G_POSITIVE_ASSOC;

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

Line 2292: l_assoc := CS_Knowledge_PUB.G_NEGATIVE_ASSOC;

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

Line 2370: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

2366: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2367: x_return_status OUT NOCOPY varchar2,
2368: x_msg_count OUT NOCOPY number,
2369: x_msg_data OUT NOCOPY varchar2,
2370: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,
2371: x_element_id OUT NOCOPY number
2372: ) is
2373: l_ele_def_obj cs_kb_ele_def_obj_type;
2374:

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

2725: substr(l_string, 1, len-1); --from beg till char before space
2726:
2727: if (first_word = TRUE)
2728: then
2729: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY) --FUZZY
2730: then
2731: q_word := '?'''||l_criteria_word||'''';
2732: else
2733: q_word := ''''||l_criteria_word||'''';

Line 2736: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)

2732: else
2733: q_word := ''''||l_criteria_word||'''';
2734: end if;
2735: else
2736: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2737: then
2738: l_operator := ' & ';
2739: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2740: then

Line 2739: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)

2735: else
2736: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2737: then
2738: l_operator := ' & ';
2739: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2740: then
2741: l_operator := ' | ';
2742: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2743: then

Line 2742: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2738: l_operator := ' & ';
2739: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2740: then
2741: l_operator := ' | ';
2742: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2743: then
2744: l_operator := ' , ?';
2745: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2746: then

Line 2745: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)

2741: l_operator := ' | ';
2742: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2743: then
2744: l_operator := ' , ?';
2745: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2746: then
2747: l_operator := ' , ';
2748: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2749: then

Line 2748: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)

2744: l_operator := ' , ?';
2745: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2746: then
2747: l_operator := ' , ';
2748: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2749: then
2750: l_operator := ' ';
2751: else -- if other cases
2752: l_operator := ' , ';

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

2890: -- Add the next term to the query string according to search option
2891: -- Parameters:
2892: -- p_string VARCHAR2: the running keyword string
2893: -- p_term VARCHAR2: the term to append
2894: -- p_search_option NUMBER: search option, as defined in CS_KNOWLEDGE_PUB
2895: -- Returns:
2896: -- Query string with the term appended using the appropriate search operator
2897: -- Since 12.0
2898: --

Line 2915: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2911: end if;
2912:
2913: if( trim(l_string) is null ) -- first term
2914: then
2915: if (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2916: then
2917: l_string := '?'''|| p_term ||'''';
2918: else
2919: l_string := p_term;

Line 2922: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)

2918: else
2919: l_string := p_term;
2920: end if;
2921: else -- subsequent terms
2922: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2923: then
2924: l_operator := ' & ';
2925: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2926: then

Line 2925: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)

2921: else -- subsequent terms
2922: if (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL)
2923: then
2924: l_operator := ' & ';
2925: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2926: then
2927: l_operator := ' | ';
2928: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2929: then

Line 2928: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)

2924: l_operator := ' & ';
2925: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ANY)
2926: then
2927: l_operator := ' | ';
2928: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2929: then
2930: l_operator := ' , ?';
2931: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2932: then

Line 2931: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)

2927: l_operator := ' | ';
2928: elsif (p_search_option = CS_KNOWLEDGE_PUB.FUZZY)
2929: then
2930: l_operator := ' , ?';
2931: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2932: then
2933: l_operator := ' , ';
2934: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2935: then

Line 2934: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)

2930: l_operator := ' , ?';
2931: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM)
2932: then
2933: l_operator := ' , ';
2934: elsif (p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE)
2935: then
2936: l_operator := ' ';
2937: else -- if other cases
2938: l_operator := ' , ';

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

3030: LOOP
3031: --dbms_output.put_line('Phrase[' || l_counter || '] = ' || l_phrase_list(l_counter));
3032: --process each phrase as an exact phrase
3033: l_phrase := Escape_Special_Char( l_phrase_list(l_counter) );
3034: l_phrase := Replace_Whitespace(l_phrase, CS_KNOWLEDGE_PUB.MATCH_PHRASE);
3035: l_phrase := '(' || l_phrase || ')';
3036: l_processed_keyword :=
3037: Append_Query_Term(l_processed_keyword, l_phrase, p_search_option);
3038: l_counter := l_phrase_list.NEXT(l_counter);

Line 3147: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or

3143: -- If the Search option chosen is THEME Search or if there is
3144: -- no search option chosen, then rewrite the raw text query
3145: -- with the theme search query and concatenate it with a regular
3146: -- non-theme based rewritten query
3147: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or
3148: p_search_option is null) --DEFAULT
3149: then
3150: l_keyword_query :=
3151: Build_Keyword_Query

Line 3183: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type )

3179: -- (1) -calls (2)
3180: --
3181: FUNCTION Build_Solution_Text_Query
3182: ( p_raw_text in varchar2,
3183: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
3184: return varchar2
3185: is
3186: l_number number;
3187: begin

Line 3198: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3194: -- CONTAINS predicate for a solution search
3195: -- (2) calls (3)
3196: FUNCTION Build_Solution_Text_Query
3197: ( p_raw_text in varchar2,
3198: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3199: p_search_option in number )
3200: return varchar2
3201: is
3202: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3202: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3198: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3199: p_search_option in number )
3200: return varchar2
3201: is
3202: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3203: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3204: begin
3205: return Build_Solution_Text_Query(
3206: p_raw_text, p_solution_type_id_tbl,

Line 3203: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3199: p_search_option in number )
3200: return varchar2
3201: is
3202: l_product_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3203: l_platform_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3204: begin
3205: return Build_Solution_Text_Query(
3206: p_raw_text, p_solution_type_id_tbl,
3207: l_product_id_tbl, l_platform_id_tbl, p_search_option);

Line 3216: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3212: -- CONTAINS predicate for a solution search
3213: -- (3) calls (4)
3214: FUNCTION Build_Solution_Text_Query
3215: ( p_raw_text in varchar2,
3216: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3217: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3218: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3219: p_search_option in number )
3220: return varchar2

Line 3217: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3213: -- (3) calls (4)
3214: FUNCTION Build_Solution_Text_Query
3215: ( p_raw_text in varchar2,
3216: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3217: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3218: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3219: p_search_option in number )
3220: return varchar2
3221: is

Line 3218: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3214: FUNCTION Build_Solution_Text_Query
3215: ( p_raw_text in varchar2,
3216: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3217: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3218: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3219: p_search_option in number )
3220: return varchar2
3221: is
3222: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3222: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3218: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3219: p_search_option in number )
3220: return varchar2
3221: is
3222: l_category_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3223: begin
3224: return Build_Solution_Text_Query(
3225: p_raw_text, p_solution_type_id_tbl,
3226: p_product_id_tbl, p_platform_id_tbl, l_category_id_tbl, p_search_option);

Line 3235: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3231: -- CONTAINS predicate for a solution search
3232: -- (4) calls (5)
3233: FUNCTION Build_Solution_Text_Query
3234: ( p_raw_text in varchar2,
3235: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3236: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3237: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3239: p_search_option in number )

Line 3236: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3232: -- (4) calls (5)
3233: FUNCTION Build_Solution_Text_Query
3234: ( p_raw_text in varchar2,
3235: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3236: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3237: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3239: p_search_option in number )
3240: return varchar2

Line 3237: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3233: FUNCTION Build_Solution_Text_Query
3234: ( p_raw_text in varchar2,
3235: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3236: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3237: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3239: p_search_option in number )
3240: return varchar2
3241: is

Line 3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3234: ( p_raw_text in varchar2,
3235: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3236: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3237: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3239: p_search_option in number )
3240: return varchar2
3241: is
3242: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;

Line 3242: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;

3238: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3239: p_search_option in number )
3240: return varchar2
3241: is
3242: l_statement_id_tbl CS_Knowledge_PUB.number15_tbl_type;
3243: begin
3244: return Build_Solution_Text_Query(
3245: p_raw_text, p_solution_type_id_tbl,
3246: p_product_id_tbl, p_platform_id_tbl, p_category_id_tbl,

Line 3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3253: -- Handles keywords, solution type, products, platforms, category,
3254: -- solution number and statement id
3255: FUNCTION Build_Solution_Text_Query
3256: ( p_raw_text in varchar2,
3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

Line 3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3254: -- solution number and statement id
3255: FUNCTION Build_Solution_Text_Query
3256: ( p_raw_text in varchar2,
3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_search_option in number )

Line 3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3255: FUNCTION Build_Solution_Text_Query
3256: ( p_raw_text in varchar2,
3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_search_option in number )
3263: return varchar2

Line 3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3256: ( p_raw_text in varchar2,
3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_search_option in number )
3263: return varchar2
3264: is

Line 3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3257: p_solution_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3258: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3259: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3260: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3261: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3262: p_search_option in number )
3263: return varchar2
3264: is
3265: l_query_str varchar2(30000) := p_raw_text;

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

3352: --(SMARTSCORE), remove all logic in this block.
3353: null;
3354: Else -- when p_raw_text is not null
3355:
3356: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)
3357: then
3358: l_query_str := Build_Intermedia_Query( l_query_str, p_search_option);
3359: end if;
3360:

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

3566: l_query_str varchar2(30000) := p_qry_string;
3567:
3568: begin
3569:
3570: if (p_search_option = CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX) -- Intermedia Syntax
3571: then
3572: return l_query_str;
3573: end if;
3574:

Line 3585: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type

3581: -- (3468629)
3582: -- Make the old API backward compatible.
3583: FUNCTION Build_Statement_Text_Query
3584: ( p_raw_text in varchar2,
3585: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type
3586: )
3587: return varchar2
3588: is
3589: begin

Line 3593: CS_KNOWLEDGE_PUB.MATCH_ACCUM -- default to Accumulate

3589: begin
3590: Return Build_Statement_Text_Query (
3591: p_raw_text,
3592: p_statement_type_id_tbl,
3593: CS_KNOWLEDGE_PUB.MATCH_ACCUM -- default to Accumulate
3594: );
3595: end Build_Statement_Text_Query;
3596:
3597:

Line 3600: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3596:
3597:
3598: FUNCTION Build_Statement_Text_Query
3599: ( p_raw_text in varchar2,
3600: p_statement_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3601: p_search_option in number
3602: )
3603: return varchar2
3604: is

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

3672: l_query_str := l_raw_text;
3673:
3674: --3. Process l_raw_text
3675: If l_query_str is not null Then
3676: If (p_search_option <> CS_KNOWLEDGE_PUB.INTERMEDIA_SYNTAX)
3677: Then
3678: l_query_str := Build_Intermedia_Query(
3679: l_query_str,
3680: p_search_option);

Line 3776: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3772: x_msg_count OUT NOCOPY number,
3773: x_msg_data OUT NOCOPY varchar2,
3774: p_pos_query_str in varchar2,
3775: p_neg_query_str in varchar2 := null,
3776: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3777: p_other_criteria in varchar2 := NULL,
3778: p_rows in number,
3779: p_start_score in number := null,
3780: p_start_id in number := null,

Line 3783: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

3779: p_start_score in number := null,
3780: p_start_id in number := null,
3781: p_start_row in number, -- := 1,
3782: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3783: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3784: x_total_rows OUT NOCOPY number,
3785: p_search_option in number := null
3786: )is
3787: l_api_name CONSTANT varchar2(30) := 'Find_Sets_Matching';

Line 3792: l_sets_csr CS_Knowledge_PUB.general_csr_type;

3788: l_api_version CONSTANT number := 1.0;
3789: l_type_cond varchar2(500) := null;
3790: l_types varchar2(1000);
3791: l_qstr varchar2(1990);
3792: l_sets_csr CS_Knowledge_PUB.general_csr_type;
3793: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
3794: l_score_cond varchar2(100) := null;
3795: l_id_cond varchar2(100) := null;
3796: l_end_row number;

Line 3793: l_set_rec CS_Knowledge_PUB.set_res_rec_type;

3789: l_type_cond varchar2(500) := null;
3790: l_types varchar2(1000);
3791: l_qstr varchar2(1990);
3792: l_sets_csr CS_Knowledge_PUB.general_csr_type;
3793: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
3794: l_score_cond varchar2(100) := null;
3795: l_id_cond varchar2(100) := null;
3796: l_end_row number;
3797: --l_str_p varchar2(2000) := p_pos_query_str;

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

3848:
3849: -- -- -- -- begin my code -- -- -- -- --
3850:
3851: if(x_set_tbl is null) then
3852: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();
3853: end if;
3854:
3855: --process strings
3856: if(p_pos_query_str is not null) then

Line 3956: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);

3952: p_start_row => p_start_row,
3953: p_get_total_flag => p_get_total_flag,
3954: x_set_tbl => x_set_tbl,
3955: x_total_rows => x_total_rows,
3956: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
3957: else
3958: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3960: IF FND_MSG_PUB.Check_Msg_Level

Line 3984: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

3980: x_msg_count OUT NOCOPY number,
3981: x_msg_data OUT NOCOPY varchar2,
3982: p_pos_query_str in varchar2,
3983: --p_neg_query_str in varchar2 := null,
3984: p_type_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
3985: p_other_criteria in varchar2,
3986: p_other_value in number,
3987: p_rows in number,
3988: p_start_score in number := null,

Line 3992: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,

3988: p_start_score in number := null,
3989: p_start_id in number := null,
3990: p_start_row in number, -- := 1,
3991: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3992: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3993: x_total_rows OUT NOCOPY number,
3994: p_search_option in number := null
3995: )is
3996: l_api_name CONSTANT varchar2(30) := 'Find_Sets_Matching';

Line 4001: l_sets_csr CS_Knowledge_PUB.general_csr_type;

3997: l_api_version CONSTANT number := 1.0;
3998: l_type_cond varchar2(500) := null;
3999: l_types varchar2(1000);
4000: l_qstr varchar2(1990);
4001: l_sets_csr CS_Knowledge_PUB.general_csr_type;
4002: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
4003: l_score_cond varchar2(100) := null;
4004: l_id_cond varchar2(100) := null;
4005: l_end_row number;

Line 4002: l_set_rec CS_Knowledge_PUB.set_res_rec_type;

3998: l_type_cond varchar2(500) := null;
3999: l_types varchar2(1000);
4000: l_qstr varchar2(1990);
4001: l_sets_csr CS_Knowledge_PUB.general_csr_type;
4002: l_set_rec CS_Knowledge_PUB.set_res_rec_type;
4003: l_score_cond varchar2(100) := null;
4004: l_id_cond varchar2(100) := null;
4005: l_end_row number;
4006: --l_str_p varchar2(2000) := p_pos_query_str;

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

4054:
4055: -- -- -- -- begin my code -- -- -- -- --
4056:
4057: if(x_set_tbl is null) then
4058: x_set_tbl := cs_knowledge_pub.set_res_tbl_type();
4059: end if;
4060:
4061: --process strings
4062: if(p_pos_query_str is not null) then

Line 4159: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);

4155: p_start_row => p_start_row,
4156: p_get_total_flag => p_get_total_flag,
4157: x_set_tbl => x_set_tbl,
4158: x_total_rows => x_total_rows,
4159: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
4160: else
4161: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4163: IF FND_MSG_PUB.Check_Msg_Level

Line 4205: If p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM Then

4201: Fetch Get_Frequency_Csr Into l_not_use_freq;
4202: Close Get_Frequency_Csr;
4203:
4204: If l_not_use_freq = 'N' Then
4205: If p_search_option = CS_KNOWLEDGE_PUB.MATCH_ACCUM Then
4206: -- For Accum operator, add magicword as
4207: -- e.g. (A, B, C, magicword*0.1*0.1*0.1)
4208: Open Get_Magic_Word_Csr;
4209: Fetch Get_Magic_Word_Csr Into l_magic_word;

Line 4239: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL

4235: p_query_str := p_query_str||', '''||l_magic_word
4236: ||'''*'||l_freq_term_weight;
4237: End If;
4238:
4239: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL
4240: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then
4241: -- For ALL operator and Exact Phrase, amplify score by 100
4242: p_query_str := '('||p_query_str||')*10*10';
4243: Else

Line 4240: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then

4236: ||'''*'||l_freq_term_weight;
4237: End If;
4238:
4239: Elsif p_search_option = CS_KNOWLEDGE_PUB.MATCH_ALL
4240: OR p_search_option = CS_KNOWLEDGE_PUB.MATCH_PHRASE Then
4241: -- For ALL operator and Exact Phrase, amplify score by 100
4242: p_query_str := '('||p_query_str||')*10*10';
4243: Else
4244: null;

Line 4259: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4255: -- This function also takes care the empty p_current_query case.
4256: FUNCTION Build_Smart_Score_Query
4257: (
4258: p_current_query in varchar2,
4259: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4260: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4261: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4262: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4263: ) return varchar2

Line 4260: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4256: FUNCTION Build_Smart_Score_Query
4257: (
4258: p_current_query in varchar2,
4259: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4260: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4261: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4262: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4263: ) return varchar2
4264: Is

Line 4261: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,

4257: (
4258: p_current_query in varchar2,
4259: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4260: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4261: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4262: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4263: ) return varchar2
4264: Is
4265: l_final_query VARCHAR2(4000) := '';

Line 4262: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type

4258: p_current_query in varchar2,
4259: p_product_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4260: p_platform_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4261: p_category_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
4262: p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type
4263: ) return varchar2
4264: Is
4265: l_final_query VARCHAR2(4000) := '';
4266: l_temp_query VARCHAR2(2000) := '';

Line 4324: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )

4320: -- Handles statement id.
4321: -- By default, it generates an Accumulate string if more
4322: -- than one statement ids are given.
4323: FUNCTION Build_Related_Stmt_Text_Query
4324: ( p_statement_id_tbl in CS_Knowledge_PUB.number15_tbl_type )
4325: return varchar2
4326: is
4327: l_lang_str varchar2(200);
4328:

Line 4463: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or

4459: -- If the Search option chosen is THEME Search or if there is
4460: -- no search option chosen, then rewrite the raw text query
4461: -- with the theme search query and concatenate it with a regular
4462: -- non-theme based rewritten query
4463: if (p_search_option = CS_KNOWLEDGE_PUB.THEME_BASED or
4464: p_search_option is null) --DEFAULT
4465: then
4466: l_keyword_query :=
4467: Build_Keyword_Query