DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHIES_PKG

Line 1727: -- It will call procedure HZ_GEOGRAPHIES_PKG.update_geo_element_cp

1723: x_application_id => NULL,
1724: x_program_login_id => NULL);
1725:
1726: -- Kick off conc prog if primary flag is Y and name or code has been updated
1727: -- It will call procedure HZ_GEOGRAPHIES_PKG.update_geo_element_cp
1728: IF ((l_geography_use = 'MASTER_REF') AND
1729: ((l_old_primary_flag = 'N' AND p_geo_identifier_rec.primary_flag = 'Y') OR
1730: ((l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'Y') AND
1731: (l_name_updated = 'Y'))

Line 1903: HZ_GEOGRAPHIES_PKG.insert_row(

1899: END IF;
1900:
1901: --dbms_output.put_line('before insert_row');
1902: --insert row into HZ_GEOGRAPHIES
1903: HZ_GEOGRAPHIES_PKG.insert_row(
1904: x_rowid => l_rowid,
1905: x_geography_id => x_geography_id,
1906: x_object_version_number => 1,
1907: x_geography_type => UPPER(p_master_geography_rec.geography_type),

Line 2179: HZ_GEOGRAPHIES_PKG.update_row(

2175: END IF;
2176: --dbms_output.put_line('After date validation '|| x_return_status);
2177:
2178: --call table handler to update the geography
2179: HZ_GEOGRAPHIES_PKG.update_row(
2180: x_rowid => l_rowid,
2181: x_geography_id => p_geography_id,
2182: x_object_version_number => p_object_version_number,
2183: x_geography_type => NULL,

Line 3061: HZ_GEOGRAPHIES_PKG.insert_row(

3057:
3058:
3059: -- call table handler to insert a row in hz_geographies
3060:
3061: HZ_GEOGRAPHIES_PKG.insert_row(
3062: x_rowid => l_rowid,
3063: x_geography_id => x_geography_id,
3064: x_object_version_number => 1,
3065: x_geography_type => p_zone_type,