APPS.HZ_PARTY_STAGE dependencies on CONTAINS

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

1232: -- by executing the folowing SQL. If this SQL errors out, it means the section doesnt exist
1233: -- or equivalently there are no placeholders.
1234: check_section_str :=
1235: 'SELECT 1 FROM '||l_table_name||
1236: ' WHERE ROWNUM=1 AND CONTAINS(concat_col,''({CHECK} within M'||l_next_misc_section||')'')>0';
1237: log('Check STR ' ||check_section_str);
1238: BEGIN
1239: EXECUTE IMMEDIATE check_section_str;
1240: -- if section exists DO NOT REBUILD

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

2145: l_req_id := 1;
2146: BEGIN
2147: SELECT 1 INTO T FROM HZ_STAGED_PARTIES
2148: WHERE ROWNUM=1
2149: AND CONTAINS (concat_col, 'dummy_string')>0;
2150: EXCEPTION
2151: WHEN NO_DATA_FOUND THEN
2152: UPDATE HZ_DQM_STAGE_LOG
2153: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2180:
2181: BEGIN
2182: SELECT 1 INTO T FROM HZ_STAGED_PARTY_SITES
2183: WHERE ROWNUM=1
2184: AND CONTAINS (concat_col, 'dummy_string')>0;
2185: EXCEPTION
2186: WHEN NO_DATA_FOUND THEN
2187: UPDATE HZ_DQM_STAGE_LOG
2188: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2220:
2221: BEGIN
2222: SELECT 1 INTO T FROM HZ_STAGED_CONTACTS
2223: WHERE ROWNUM=1
2224: AND CONTAINS (concat_col, 'dummy_string')>0;
2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN
2227: UPDATE HZ_DQM_STAGE_LOG
2228: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE

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

2260:
2261: BEGIN
2262: SELECT 1 INTO T FROM HZ_STAGED_CONTACT_POINTS
2263: WHERE ROWNUM=1
2264: AND CONTAINS (concat_col, 'dummy_string')>0;
2265: EXCEPTION
2266: WHEN NO_DATA_FOUND THEN
2267: UPDATE HZ_DQM_STAGE_LOG
2268: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE