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.HZ_DQM_SEARCH_UTIL dependencies on CONTAINS

Line 183: x_contains_str IN OUT NOCOPY VARCHAR2) IS

179:
180: PROCEDURE add_attribute (
181: p_tx_str IN VARCHAR2,
182: p_match_str IN VARCHAR2,
183: x_contains_str IN OUT NOCOPY VARCHAR2) IS
184: BEGIN
185: IF p_tx_str IS NOT NULL THEN
186: IF x_contains_str IS NOT NULL THEN
187: x_contains_str := x_contains_str || p_match_str;

Line 186: IF x_contains_str IS NOT NULL THEN

182: p_match_str IN VARCHAR2,
183: x_contains_str IN OUT NOCOPY VARCHAR2) IS
184: BEGIN
185: IF p_tx_str IS NOT NULL THEN
186: IF x_contains_str IS NOT NULL THEN
187: x_contains_str := x_contains_str || p_match_str;
188: END IF;
189: x_contains_str := x_contains_str || '('||
190: p_tx_str || ')';

Line 187: x_contains_str := x_contains_str || p_match_str;

183: x_contains_str IN OUT NOCOPY VARCHAR2) IS
184: BEGIN
185: IF p_tx_str IS NOT NULL THEN
186: IF x_contains_str IS NOT NULL THEN
187: x_contains_str := x_contains_str || p_match_str;
188: END IF;
189: x_contains_str := x_contains_str || '('||
190: p_tx_str || ')';
191: END IF;

Line 189: x_contains_str := x_contains_str || '('||

185: IF p_tx_str IS NOT NULL THEN
186: IF x_contains_str IS NOT NULL THEN
187: x_contains_str := x_contains_str || p_match_str;
188: END IF;
189: x_contains_str := x_contains_str || '('||
190: p_tx_str || ')';
191: END IF;
192: EXCEPTION
193: WHEN OTHERS THEN

Line 205: x_contains_str IN OUT NOCOPY VARCHAR2) IS

201: PROCEDURE add_attribute_with_denorm (
202: p_tx_str IN VARCHAR2,
203: p_match_str IN VARCHAR2,
204: p_denorm_str IN VARCHAR2,
205: x_contains_str IN OUT NOCOPY VARCHAR2) IS
206: BEGIN
207: IF p_tx_str IS NOT NULL THEN
208: IF x_contains_str IS NOT NULL THEN
209: x_contains_str := x_contains_str || p_match_str;

Line 208: IF x_contains_str IS NOT NULL THEN

204: p_denorm_str IN VARCHAR2,
205: x_contains_str IN OUT NOCOPY VARCHAR2) IS
206: BEGIN
207: IF p_tx_str IS NOT NULL THEN
208: IF x_contains_str IS NOT NULL THEN
209: x_contains_str := x_contains_str || p_match_str;
210: END IF;
211: x_contains_str := x_contains_str || '('||
212: p_tx_str;

Line 209: x_contains_str := x_contains_str || p_match_str;

205: x_contains_str IN OUT NOCOPY VARCHAR2) IS
206: BEGIN
207: IF p_tx_str IS NOT NULL THEN
208: IF x_contains_str IS NOT NULL THEN
209: x_contains_str := x_contains_str || p_match_str;
210: END IF;
211: x_contains_str := x_contains_str || '('||
212: p_tx_str;
213: IF p_denorm_str IS NOT NULL THEN

Line 211: x_contains_str := x_contains_str || '('||

207: IF p_tx_str IS NOT NULL THEN
208: IF x_contains_str IS NOT NULL THEN
209: x_contains_str := x_contains_str || p_match_str;
210: END IF;
211: x_contains_str := x_contains_str || '('||
212: p_tx_str;
213: IF p_denorm_str IS NOT NULL THEN
214: x_contains_str := x_contains_str || ' AND ('||p_denorm_str ||'))';
215: ELSE

Line 214: x_contains_str := x_contains_str || ' AND ('||p_denorm_str ||'))';

210: END IF;
211: x_contains_str := x_contains_str || '('||
212: p_tx_str;
213: IF p_denorm_str IS NOT NULL THEN
214: x_contains_str := x_contains_str || ' AND ('||p_denorm_str ||'))';
215: ELSE
216: x_contains_str := x_contains_str || ')';
217: END IF;
218: END IF;

Line 216: x_contains_str := x_contains_str || ')';

212: p_tx_str;
213: IF p_denorm_str IS NOT NULL THEN
214: x_contains_str := x_contains_str || ' AND ('||p_denorm_str ||'))';
215: ELSE
216: x_contains_str := x_contains_str || ')';
217: END IF;
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN

Line 230: p_rec_contains_str IN VARCHAR2,

226: END add_attribute_with_denorm;
227:
228:
229: PROCEDURE add_search_record (
230: p_rec_contains_str IN VARCHAR2,
231: p_filter_str IN VARCHAR2,
232: x_contains_str IN OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: IF p_rec_contains_str IS NOT NULL THEN

Line 232: x_contains_str IN OUT NOCOPY VARCHAR2) IS

228:
229: PROCEDURE add_search_record (
230: p_rec_contains_str IN VARCHAR2,
231: p_filter_str IN VARCHAR2,
232: x_contains_str IN OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: IF p_rec_contains_str IS NOT NULL THEN
235: IF x_contains_str IS NOT NULL THEN
236: x_contains_str := x_contains_str || ' OR ';

Line 234: IF p_rec_contains_str IS NOT NULL THEN

230: p_rec_contains_str IN VARCHAR2,
231: p_filter_str IN VARCHAR2,
232: x_contains_str IN OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: IF p_rec_contains_str IS NOT NULL THEN
235: IF x_contains_str IS NOT NULL THEN
236: x_contains_str := x_contains_str || ' OR ';
237: END IF;
238: IF p_filter_str IS NOT NULL THEN

Line 235: IF x_contains_str IS NOT NULL THEN

231: p_filter_str IN VARCHAR2,
232: x_contains_str IN OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: IF p_rec_contains_str IS NOT NULL THEN
235: IF x_contains_str IS NOT NULL THEN
236: x_contains_str := x_contains_str || ' OR ';
237: END IF;
238: IF p_filter_str IS NOT NULL THEN
239: x_contains_str :=

Line 236: x_contains_str := x_contains_str || ' OR ';

232: x_contains_str IN OUT NOCOPY VARCHAR2) IS
233: BEGIN
234: IF p_rec_contains_str IS NOT NULL THEN
235: IF x_contains_str IS NOT NULL THEN
236: x_contains_str := x_contains_str || ' OR ';
237: END IF;
238: IF p_filter_str IS NOT NULL THEN
239: x_contains_str :=
240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';

Line 239: x_contains_str :=

235: IF x_contains_str IS NOT NULL THEN
236: x_contains_str := x_contains_str || ' OR ';
237: END IF;
238: IF p_filter_str IS NOT NULL THEN
239: x_contains_str :=
240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';
241: ELSE
242: x_contains_str :=
243: x_contains_str || '('|| p_rec_contains_str || ')';

Line 240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';

236: x_contains_str := x_contains_str || ' OR ';
237: END IF;
238: IF p_filter_str IS NOT NULL THEN
239: x_contains_str :=
240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';
241: ELSE
242: x_contains_str :=
243: x_contains_str || '('|| p_rec_contains_str || ')';
244: END IF;

Line 242: x_contains_str :=

238: IF p_filter_str IS NOT NULL THEN
239: x_contains_str :=
240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';
241: ELSE
242: x_contains_str :=
243: x_contains_str || '('|| p_rec_contains_str || ')';
244: END IF;
245: END IF;
246: EXCEPTION

Line 243: x_contains_str || '('|| p_rec_contains_str || ')';

239: x_contains_str :=
240: x_contains_str || '((' || p_rec_contains_str || ') AND '||p_filter_str||')';
241: ELSE
242: x_contains_str :=
243: x_contains_str || '('|| p_rec_contains_str || ')';
244: END IF;
245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN

Line 472: AND CONTAINS (concat_col, 'dummy_string')>0;

468:
469: BEGIN
470: SELECT 1 INTO T FROM HZ_STAGED_PARTIES
471: WHERE ROWNUM=1
472: AND CONTAINS (concat_col, 'dummy_string')>0;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: NULL;
476: WHEN OTHERS THEN

Line 482: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

478: END;
479: BEGIN
480: SELECT 1 INTO T FROM HZ_STAGED_PARTY_SITES
481: WHERE ROWNUM=1
482: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;
483: EXCEPTION
484: WHEN NO_DATA_FOUND THEN
485: NULL;
486: WHEN OTHERS THEN

Line 492: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

488: END;
489: BEGIN
490: SELECT 1 INTO T FROM HZ_STAGED_CONTACTS
491: WHERE ROWNUM=1
492: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN
495: NULL;
496: WHEN OTHERS THEN

Line 502: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

498: END;
499: BEGIN
500: SELECT 1 INTO T FROM HZ_STAGED_CONTACT_POINTS
501: WHERE ROWNUM=1
502: AND CONTAINS (CONCAT_COL, 'dummy_string')>0;
503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
505: NULL;
506: WHEN OTHERS THEN