APPS.HZ_GNR_UTIL_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

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

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

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

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

Line 2468: UPDATE hz_cust_acct_sites_all cas

2464: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2465: THEN
2466: NULL;
2467: ELSE
2468: UPDATE hz_cust_acct_sites_all cas
2469: SET cas.address_text = null
2470: WHERE cas.address_text IS NOT NULL
2471: AND EXISTS
2472: ( SELECT 1