APPS.HZ_GEOGRAPHIES_PKG dependencies on HZ_UTILITY_PUB

Line 1359: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1355:
1356: IF p_identifier_type = 'CODE' THEN
1357: UPDATE HZ_GEOGRAPHIES
1358: SET geography_code = l_identifier_value,
1359: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1360: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1361: WHERE geography_id = p_geography_id;
1362: END IF;
1363:

Line 1360: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1356: IF p_identifier_type = 'CODE' THEN
1357: UPDATE HZ_GEOGRAPHIES
1358: SET geography_code = l_identifier_value,
1359: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1360: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1361: WHERE geography_id = p_geography_id;
1362: END IF;
1363:
1364: IF p_identifier_type = 'NAME' THEN

Line 1367: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

1363:
1364: IF p_identifier_type = 'NAME' THEN
1365: UPDATE HZ_GEOGRAPHIES
1366: SET geography_name = l_identifier_value,
1367: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1368: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1369: WHERE geography_id = p_geography_id;
1370: END IF;
1371:

Line 1368: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

1364: IF p_identifier_type = 'NAME' THEN
1365: UPDATE HZ_GEOGRAPHIES
1366: SET geography_name = l_identifier_value,
1367: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1368: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1369: WHERE geography_id = p_geography_id;
1370: END IF;
1371:
1372: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME'/'CODE' in all the rows

Line 1378: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||

1374:
1375: IF (p_identifier_type='NAME' AND l_geo_element_col IS NOT NULL)THEN
1376:
1377: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||
1378: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1379: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1380: ' WHERE country_code = :l_country_code and '||
1381: l_geo_element_id||'= :l_geography_id '
1382: USING l_identifier_value, l_country_code, p_geography_id ;

Line 1379: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||

1375: IF (p_identifier_type='NAME' AND l_geo_element_col IS NOT NULL)THEN
1376:
1377: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||
1378: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1379: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1380: ' WHERE country_code = :l_country_code and '||
1381: l_geo_element_id||'= :l_geography_id '
1382: USING l_identifier_value, l_country_code, p_geography_id ;
1383:

Line 1389: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||

1385:
1386: IF p_identifier_type='CODE' THEN
1387: IF l_geo_element_col IN ('GEOGRAPHY_ELEMENT1','GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5') THEN
1388: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_code||'= :l_identifier_value '||
1389: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1390: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1391: ' WHERE country_code = :l_country_code and '||
1392: l_geo_element_id||'= :l_geography_id '
1393: USING l_identifier_value, l_country_code, p_geography_id;

Line 1390: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||

1386: IF p_identifier_type='CODE' THEN
1387: IF l_geo_element_col IN ('GEOGRAPHY_ELEMENT1','GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5') THEN
1388: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_code||'= :l_identifier_value '||
1389: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1390: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1391: ' WHERE country_code = :l_country_code and '||
1392: l_geo_element_id||'= :l_geography_id '
1393: USING l_identifier_value, l_country_code, p_geography_id;
1394: END IF;