APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_UTILITY_PUB

Line 1406: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1402: -- Bug 4579868 : ISSUE # 11
1403: -- denormalize upper code and not identifier_value directly
1404: -- SET geography_code = p_geo_identifier_rec.identifier_value
1405: SET geography_code = l_identifier_value,
1406: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1407: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1408: WHERE geography_id = p_geo_identifier_rec.geography_id;
1409: -- END IF;
1410:

Line 1407: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1403: -- denormalize upper code and not identifier_value directly
1404: -- SET geography_code = p_geo_identifier_rec.identifier_value
1405: SET geography_code = l_identifier_value,
1406: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1407: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1408: WHERE geography_id = p_geo_identifier_rec.geography_id;
1409: -- END IF;
1410:
1411: IF l_geo_element_col IS NOT NULL THEN

Line 1431: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1427: ----dbms_output.put_line('after de-normaloizing code');
1428: IF p_geo_identifier_rec.identifier_type='NAME' THEN
1429: UPDATE HZ_GEOGRAPHIES
1430: SET geography_name = p_geo_identifier_rec.identifier_value,
1431: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1432: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1433: WHERE geography_id = p_geo_identifier_rec.geography_id;
1434: IF l_geo_element_col IS NOT NULL THEN
1435: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||

Line 1432: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1428: IF p_geo_identifier_rec.identifier_type='NAME' THEN
1429: UPDATE HZ_GEOGRAPHIES
1430: SET geography_name = p_geo_identifier_rec.identifier_value,
1431: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1432: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1433: WHERE geography_id = p_geo_identifier_rec.geography_id;
1434: IF l_geo_element_col IS NOT NULL THEN
1435: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||
1436: ' WHERE country_code= :l_country_code '||

Line 1766: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1762:
1763: IF p_geo_identifier_rec.identifier_type = 'CODE' THEN
1764: UPDATE HZ_GEOGRAPHIES
1765: SET geography_code = l_new_geo_value,
1766: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1767: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1768: WHERE geography_id = p_geo_identifier_rec.geography_id
1769: AND geography_use = l_geography_use;
1770: END IF;

Line 1767: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1763: IF p_geo_identifier_rec.identifier_type = 'CODE' THEN
1764: UPDATE HZ_GEOGRAPHIES
1765: SET geography_code = l_new_geo_value,
1766: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1767: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1768: WHERE geography_id = p_geo_identifier_rec.geography_id
1769: AND geography_use = l_geography_use;
1770: END IF;
1771:

Line 1775: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1771:
1772: IF p_geo_identifier_rec.identifier_type = 'NAME' THEN
1773: UPDATE HZ_GEOGRAPHIES
1774: SET geography_name = l_new_geo_value,
1775: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1776: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1777: WHERE geography_id = p_geo_identifier_rec.geography_id
1778: AND geography_use = l_geography_use;
1779: END IF;

Line 1776: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1772: IF p_geo_identifier_rec.identifier_type = 'NAME' THEN
1773: UPDATE HZ_GEOGRAPHIES
1774: SET geography_name = l_new_geo_value,
1775: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1776: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1777: WHERE geography_id = p_geo_identifier_rec.geography_id
1778: AND geography_use = l_geography_use;
1779: END IF;
1780: END IF;