APPS.HZ_PARTY_STAGE dependencies on CONTAINS

Line 1248: ' WHERE ROWNUM=1 AND CONTAINS(concat_col,''({CHECK} within M'||l_next_misc_section||')'')>0';

1244: -- by executing the folowing SQL. If this SQL errors out, it means the section doesnt exist
1245: -- or equivalently there are no placeholders.
1246: check_section_str :=
1247: 'SELECT 1 FROM '||l_table_name||
1248: ' WHERE ROWNUM=1 AND CONTAINS(concat_col,''({CHECK} within M'||l_next_misc_section||')'')>0';
1249: log('Check STR ' ||check_section_str);
1250: BEGIN
1251: EXECUTE IMMEDIATE check_section_str;
1252: -- if section exists DO NOT REBUILD

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

2161: l_req_id := 1;
2162: BEGIN
2163: SELECT 1 INTO T FROM HZ_STAGED_PARTIES
2164: WHERE ROWNUM=1
2165: AND CONTAINS (concat_col, 'dummy_string')>0;
2166: EXCEPTION
2167: WHEN NO_DATA_FOUND THEN
2168: UPDATE HZ_DQM_STAGE_LOG
2169: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2196:
2197: BEGIN
2198: SELECT 1 INTO T FROM HZ_STAGED_PARTY_SITES
2199: WHERE ROWNUM=1
2200: AND CONTAINS (concat_col, 'dummy_string')>0;
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: UPDATE HZ_DQM_STAGE_LOG
2204: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2236:
2237: BEGIN
2238: SELECT 1 INTO T FROM HZ_STAGED_CONTACTS
2239: WHERE ROWNUM=1
2240: AND CONTAINS (concat_col, 'dummy_string')>0;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: UPDATE HZ_DQM_STAGE_LOG
2244: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2276:
2277: BEGIN
2278: SELECT 1 INTO T FROM HZ_STAGED_CONTACT_POINTS
2279: WHERE ROWNUM=1
2280: AND CONTAINS (concat_col, 'dummy_string')>0;
2281: EXCEPTION
2282: WHEN NO_DATA_FOUND THEN
2283: UPDATE HZ_DQM_STAGE_LOG
2284: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE