APPS.HZ_LOCATION_V2PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2279: | hz_cust_acct_sites_all with the NULL value |

2275: | update_location_search |
2276: | |
2277: | DESCRIPTION |
2278: | This procedure updates the address_text column of |
2279: | hz_cust_acct_sites_all with the NULL value |
2280: | only to change the address_text column status |
2281: | so that interMedia index can be created on it to perform text searches. |
2282: | |
2283: | NOTE :- After Calling this procedure the user has to execute the |

Line 2304: HZ_CUST_ACCT_SITES_ALL ac

2300: IS
2301: Cursor c_locations(p_location_id NUMBER) IS
2302: SELECT ac.CUST_ACCT_SITE_ID
2303: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2304: HZ_CUST_ACCT_SITES_ALL ac
2305: WHERE loc.LOCATION_ID=p_location_id
2306: AND loc.LOCATION_ID = ps.LOCATION_ID
2307: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
2308: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

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

2304: HZ_CUST_ACCT_SITES_ALL ac
2305: WHERE loc.LOCATION_ID=p_location_id
2306: AND loc.LOCATION_ID = ps.LOCATION_ID
2307: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;
2308: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
2309: l_siteidtab siteidtab;
2310:
2311: BEGIN
2312: savepoint update_location_search;

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

2324: FETCH c_locations BULK COLLECT INTO l_siteidtab;
2325: CLOSE c_locations;
2326: IF l_siteidtab.COUNT >0 THEN
2327: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
2328: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
2329: END IF;
2330: END IF;
2331: EXCEPTION
2332: WHEN OTHERS THEN