APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PAY_US_GEO_UPD_PKG

Line 52: pay_us_geo_upd_pkg.update_county_name and pay_us_geo_upd_pkg.update_city_name

48: This will save unnecessary execution of complete Geocode procedures in
49: presence of only City Name and County Name changes. If only City Name
50: and County Name changes are present, then the "Geocode Upgrade Concurrent Program"
51: Request will be skipped for that year and individual procedures
52: pay_us_geo_upd_pkg.update_county_name and pay_us_geo_upd_pkg.update_city_name
53: will take care of the County Name and City Name updates */
54:
55: cursor c_geo_check_us_assignments (p_patch_name in varchar)
56: is

Line 450: pay_us_geo_upd_pkg.update_county_name(l_id,p_mode,l_patch_name,'EXTERNAL');

446: END IF;
447:
448: IF l_county_changes > 0 THEN
449:
450: pay_us_geo_upd_pkg.update_county_name(l_id,p_mode,l_patch_name,'EXTERNAL');
451:
452: END IF;
453:
454: l_city_changes := 0;

Line 462: pay_us_geo_upd_pkg.update_city_name(l_id,p_mode,l_patch_name,'EXTERNAL');

458: close c_geo_city_changes;
459:
460: IF l_city_changes > 0 THEN
461:
462: pay_us_geo_upd_pkg.update_city_name(l_id,p_mode,l_patch_name,'EXTERNAL');
463:
464: END IF;
465:
466: END IF; --l_us_count IF