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.IBC_CONTENT_SEARCH_PVT dependencies on IBC_CONTENT_SEARCH_PVT

Line 1: PACKAGE BODY Ibc_Content_Search_Pvt AS

1: PACKAGE BODY Ibc_Content_Search_Pvt AS
2: /* $Header: ibcvsrcb.pls 120.0 2005/09/01 21:40:35 srrangar noship $ */
3: TYPE WeakCurType IS REF CURSOR;
4: --
5: -- Private Utility function

Line 84: IF (p_search_option = Ibc_Content_Search_Pvt.FUZZY) --FUZZY

80: SUBSTR(l_string, 1, len-1); --from beg till char before space
81:
82: IF (first_word = TRUE)
83: THEN
84: IF (p_search_option = Ibc_Content_Search_Pvt.FUZZY) --FUZZY
85: THEN
86: q_word := '?'''||l_criteria_word||'''';
87: ELSE
88: q_word := ''''||l_criteria_word||'''';

Line 91: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)

87: ELSE
88: q_word := ''''||l_criteria_word||'''';
89: END IF;
90: ELSE
91: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)
92: THEN
93: l_operator := ' & ';
94: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
95: THEN

Line 94: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)

90: ELSE
91: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)
92: THEN
93: l_operator := ' & ';
94: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
95: THEN
96: l_operator := ' | ';
97: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
98: THEN

Line 97: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)

93: l_operator := ' & ';
94: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
95: THEN
96: l_operator := ' | ';
97: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
98: THEN
99: l_operator := ' , ?';
100: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
101: THEN

Line 100: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)

96: l_operator := ' | ';
97: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
98: THEN
99: l_operator := ' , ?';
100: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
101: THEN
102: l_operator := ' , ';
103: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)
104: THEN

Line 103: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)

99: l_operator := ' , ?';
100: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
101: THEN
102: l_operator := ' , ';
103: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)
104: THEN
105: l_operator := ' ';
106: ELSE -- if other cases
107: l_operator := ' , ';

Line 172: -- p_search_option NUMBER: search option, as defined in IBC_CONTENT_SEARCH_PVT

168: -- Add the next term to the query string according to search option
169: -- Parameters:
170: -- p_string VARCHAR2: the running keyword string
171: -- p_term VARCHAR2: the term to append
172: -- p_search_option NUMBER: search option, as defined in IBC_CONTENT_SEARCH_PVT
173: -- Returns:
174: -- Query string with the term appended using the appropriate search operator
175: -- Since 12.0
176: --

Line 193: IF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)

189: END IF;
190:
191: IF( trim(l_string) IS NULL ) -- first term
192: THEN
193: IF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
194: THEN
195: l_string := '?'''|| p_term ||'''';
196: ELSE
197: l_string := p_term;

Line 200: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)

196: ELSE
197: l_string := p_term;
198: END IF;
199: ELSE -- subsequent terms
200: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)
201: THEN
202: l_operator := ' & ';
203: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
204: THEN

Line 203: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)

199: ELSE -- subsequent terms
200: IF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ALL)
201: THEN
202: l_operator := ' & ';
203: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
204: THEN
205: l_operator := ' | ';
206: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
207: THEN

Line 206: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)

202: l_operator := ' & ';
203: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ANY)
204: THEN
205: l_operator := ' | ';
206: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
207: THEN
208: l_operator := ' , ?';
209: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
210: THEN

Line 209: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)

205: l_operator := ' | ';
206: ELSIF (p_search_option = Ibc_Content_Search_Pvt.FUZZY)
207: THEN
208: l_operator := ' , ?';
209: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
210: THEN
211: l_operator := ' , ';
212: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)
213: THEN

Line 212: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)

208: l_operator := ' , ?';
209: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_ACCUM)
210: THEN
211: l_operator := ' , ';
212: ELSIF (p_search_option = Ibc_Content_Search_Pvt.MATCH_PHRASE)
213: THEN
214: l_operator := ' ';
215: ELSE -- if other cases
216: l_operator := ' , ';

Line 312: l_phrase := Replace_Whitespace(l_phrase, Ibc_Content_Search_Pvt.MATCH_PHRASE);

308: LOOP
309: --dbms_output.put_line('Phrase[' || l_counter || '] = ' || l_phrase_list(l_counter));
310: --process each phrase as an exact phrase
311: l_phrase := Escape_Special_Char( l_phrase_list(l_counter) );
312: l_phrase := Replace_Whitespace(l_phrase, Ibc_Content_Search_Pvt.MATCH_PHRASE);
313: l_phrase := '(' || l_phrase || ')';
314: l_processed_keyword :=
315: Append_Query_Term(l_processed_keyword, l_phrase, p_search_option);
316: l_counter := l_phrase_list.NEXT(l_counter);

Line 407: IF (p_search_option = Ibc_Content_Search_Pvt.THEME_BASED OR

403: -- If the Search option chosen is THEME Search or if there is
404: -- no search option chosen, then rewrite the raw text query
405: -- with the theme search query and concatenate it with a regular
406: -- non-theme based rewritten query
407: IF (p_search_option = Ibc_Content_Search_Pvt.THEME_BASED OR
408: p_search_option IS NULL) --DEFAULT
409: THEN
410: l_keyword_query :=
411: Build_Keyword_Query

Line 463: IF (p_search_option = Ibc_Content_Search_Pvt.INTERMEDIA_SYNTAX) -- Intermedia Syntax

459: l_query_str VARCHAR2(30000) := p_qry_string;
460:
461: BEGIN
462:
463: IF (p_search_option = Ibc_Content_Search_Pvt.INTERMEDIA_SYNTAX) -- Intermedia Syntax
464: THEN
465: RETURN l_query_str;
466: END IF;
467:

Line 472: END Ibc_Content_Search_Pvt;

468: l_query_str := Build_Intermedia_Query( l_query_str, p_search_option);
469:
470: RETURN l_query_str;
471: END Build_Simple_Text_Query;
472: END Ibc_Content_Search_Pvt;