DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEOGRAPHY_TYPES_PKG

Line 142: hz_geography_types_PKG.Insert_Row (

138: l_geography_type_name := initcap(p_geography_type_rec.geography_type);
139: END IF;
140:
141: -- call the table handler to create geography_type
142: hz_geography_types_PKG.Insert_Row (
143: x_rowid => l_rowid,
144: x_geography_type => UPPER(l_geography_type),
145: x_geography_type_name => l_geography_type_name,
146: x_object_version_number => 1,

Line 1280: hz_geography_types_PKG.Insert_Row (

1276: END IF;
1277:
1278: --dbms_output.put_line('l_geography_type_name is '||l_geography_type_name);
1279: -- call the table handler to create geography_type
1280: hz_geography_types_PKG.Insert_Row (
1281: x_rowid => l_rowid,
1282: x_geography_type => p_zone_type_rec.geography_type,
1283: x_geography_type_name => l_geography_type_name,
1284: x_object_version_number => 1,

Line 1575: hz_geography_types_PKG.update_row(

1571: END IF;
1572: --dbms_output.put_line('l_rowid is '|| l_rowid);
1573: --dbms_output.put_line('geography_type_name is '||p_geography_type_name);
1574: -- call table handler to update zone type
1575: hz_geography_types_PKG.update_row(
1576: x_rowid => l_rowid,
1577: x_geography_type => p_geography_type,
1578: x_geography_type_name => NULL,
1579: x_object_version_number => p_object_version_number,