APPS.HZ_LOCATION_V2PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2247: | hz_cust_acct_sites_all with the NULL value |

2243: | update_location_search |
2244: | |
2245: | DESCRIPTION |
2246: | This procedure updates the address_text column of |
2247: | hz_cust_acct_sites_all with the NULL value |
2248: | only to change the address_text column status |
2249: | so that interMedia index can be created on it to perform text searches. |
2250: | |
2251: | NOTE :- After Calling this procedure the user has to execute the |

Line 2272: HZ_CUST_ACCT_SITES_ALL ac

2268: IS
2269: Cursor c_locations(p_location_id NUMBER) IS
2270: SELECT ac.CUST_ACCT_SITE_ID
2271: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2272: HZ_CUST_ACCT_SITES_ALL ac
2273: WHERE loc.LOCATION_ID=p_location_id
2274: AND loc.LOCATION_ID = ps.LOCATION_ID
2275: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
2276: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

Line 2276: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

2272: HZ_CUST_ACCT_SITES_ALL ac
2273: WHERE loc.LOCATION_ID=p_location_id
2274: AND loc.LOCATION_ID = ps.LOCATION_ID
2275: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
2276: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
2277: l_siteidtab siteidtab;
2278:
2279: BEGIN
2280: savepoint update_location_search;

Line 2296: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);

2292: FETCH c_locations BULK COLLECT INTO l_siteidtab;
2293: CLOSE c_locations;
2294: IF l_siteidtab.COUNT >0 THEN
2295: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
2296: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
2297: END IF;
2298: END IF;
2299: EXCEPTION
2300: WHEN OTHERS THEN