APPS.HZ_GNR_UTIL_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2452: -- fix for bug # 4169728. Set address_text to null in hz_cust_acct_sites_all table if,

2448: TIMEZONE_ID = l_new_location_rec.timezone_id,
2449: ADDRESS_KEY = l_new_location_rec.address_key
2450: WHERE LOCATION_ID = p_location_id;
2451:
2452: -- fix for bug # 4169728. Set address_text to null in hz_cust_acct_sites_all table if,
2453: -- city, state, province or postal_code changes in hz_location table.
2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,
2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)

Line 2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,

2450: WHERE LOCATION_ID = p_location_id;
2451:
2452: -- fix for bug # 4169728. Set address_text to null in hz_cust_acct_sites_all table if,
2453: -- city, state, province or postal_code changes in hz_location table.
2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,
2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

Line 2463: UPDATE hz_cust_acct_sites_all cas

2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2460: THEN
2461: NULL;
2462: ELSE
2463: UPDATE hz_cust_acct_sites_all cas
2464: SET cas.address_text = null
2465: WHERE cas.address_text IS NOT NULL
2466: AND EXISTS
2467: ( SELECT 1