DBA Data[Home] [Help]

APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 59: select STATUS , DOMIDX_OPSTATUS , PARAMETERS from all_indexes where index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'

55: p_idx_cust_contacts IN VARCHAR2) IS
56:
57: cursor cust_index (p_schema IN VARCHAR2)is
58: /* Bug Fix: 4095863 */
59: select STATUS , DOMIDX_OPSTATUS , PARAMETERS from all_indexes where index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'
60: and owner = p_schema;
61:
62: x_dummy BOOLEAN;
63: x_status varchar2(30);

Line 106: where err_index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'

102: x_dom_index_status IS NOT NULL AND x_dom_index_status = 'VALID'
103: THEN
104: select count(1) into l_count
105: from ctxsys.ctx_index_errors
106: where err_index_name = 'HZ_CUST_ACCT_SITES_ALL_T1'
107: and rownum =1;
108: IF l_count <> 1 THEN
109: /* Bug Fix: 4095863 */
110: l_pos := instr(x_parameters,'siteud1');

Line 114: EXECUTE IMMEDIATE ' ALTER INDEX ' || x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1 REBUILD

110: l_pos := instr(x_parameters,'siteud1');
111: IF ((l_pos <> 0 AND l_datastore = 'APPS.siteud') OR
112: (l_pos = 0 AND l_datastore = 'APPS.siteud1'))
113: THEN
114: EXECUTE IMMEDIATE ' ALTER INDEX ' || x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1 REBUILD
115: online parameters (''' || l_param_str || ''') PARALLEL ' ;
116: END IF;
117: /* Index is valid */
118: SYNC_INDEX(x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1', idx_retcode , idx_err);

Line 118: SYNC_INDEX(x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1', idx_retcode , idx_err);

114: EXECUTE IMMEDIATE ' ALTER INDEX ' || x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1 REBUILD
115: online parameters (''' || l_param_str || ''') PARALLEL ' ;
116: END IF;
117: /* Index is valid */
118: SYNC_INDEX(x_index_owner || '.HZ_CUST_ACCT_SITES_ALL_T1', idx_retcode , idx_err);
119: IF idx_retcode = 1 THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122: --to populate the profile option

Line 132: x_drop_index := 'drop index '||x_index_owner||'.'|| 'HZ_CUST_ACCT_SITES_ALL_T1 force';

128: RETURN;
129: END IF;
130: END IF;
131: /* Index is invalid */
132: x_drop_index := 'drop index '||x_index_owner||'.'|| 'HZ_CUST_ACCT_SITES_ALL_T1 force';
133: EXECUTE IMMEDIATE x_drop_index;
134: END IF;
135: close cust_index;
136:

Line 165: 'HZ_CUST_ACCT_SITES_ALL_T1 on HZ_CUST_ACCT_SITES_ALL '||

161: END;
162:
163: IF l_idx_mem <> '0' THEN
164: x_index_string := 'create index '||x_index_owner||'.'||
165: 'HZ_CUST_ACCT_SITES_ALL_T1 on HZ_CUST_ACCT_SITES_ALL '||
166: '(ADDRESS_TEXT) indextype is ctxsys.context ' ||
167: 'parameters ('' datastore ' || l_datastore ||
168: ' stoplist ctxsys.empty_stoplist lexer APPS.text_lexer ' ||
169: ' memory ' || l_idx_mem || ' '') PARALLEL ONLINE';

Line 172: 'HZ_CUST_ACCT_SITES_ALL_T1 on HZ_CUST_ACCT_SITES_ALL '||

168: ' stoplist ctxsys.empty_stoplist lexer APPS.text_lexer ' ||
169: ' memory ' || l_idx_mem || ' '') PARALLEL ONLINE';
170: ELSE
171: x_index_string := 'create index '||x_index_owner||'.'||
172: 'HZ_CUST_ACCT_SITES_ALL_T1 on HZ_CUST_ACCT_SITES_ALL '||
173: '(ADDRESS_TEXT) indextype is ctxsys.context '||
174: 'parameters ('' datastore ' || l_datastore ||
175: ' stoplist ctxsys.empty_stoplist lexer APPS.text_lexer ' ||' '') PARALLEL ONLINE';
176: END IF;

Line 246: APPS.HZ_CUST_ACCT_SITES_ALL ac

242: FOR sites in (
243: SELECT cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
244: loc.province||' '||loc.postal_code || ' ' cust_address
245: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
246: APPS.HZ_CUST_ACCT_SITES_ALL ac
247: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
248: AND loc.LOCATION_ID = ps.LOCATION_ID
249: AND ac.ROWID = rid)
250: LOOP

Line 364: APPS.HZ_CUST_ACCT_SITES_ALL ac

360: FOR sites in (
361: SELECT ac.status, cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3 ||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
362: loc.province||' '||loc.postal_code || ' ' cust_address
363: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
364: APPS.HZ_CUST_ACCT_SITES_ALL ac
365: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
366: AND loc.LOCATION_ID = ps.LOCATION_ID
367: AND ac.ROWID = rid)
368: LOOP