DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS_PKG

Line 507: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (

503: END IF;*/
504:
505:
506: -- call table handler to insert a row in HZ_GEO_STRUCTURE_LEVELS
507: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
508: x_rowid => l_rowid,
509: x_geography_id => p_geo_structure_rec.geography_id,
510: x_geography_type => p_geo_structure_rec.geography_type,
511: x_parent_geography_type => p_geo_structure_rec.parent_geography_type,

Line 566: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (

562: RAISE FND_API.G_EXC_ERROR;
563: END IF;*/
564:
565: -- insert a row in hz_geo_structure_levels with new relationship_type_id
566: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
567: x_rowid => l_rowid,
568: x_geography_id => p_geo_structure_rec.geography_id,
569: x_geography_type => p_geo_structure_rec.geography_type,
570: x_parent_geography_type => p_geo_structure_rec.parent_geography_type,

Line 720: HZ_GEO_STRUCTURE_LEVELS_PKG.Update_Row (

716: --dbms_output.put_line('l_count is '|| to_char(l_count));
717: EXCEPTION WHEN NO_DATA_FOUND THEN
718: --dbms_output.put_line('before update');
719: --call table handler to update row
720: HZ_GEO_STRUCTURE_LEVELS_PKG.Update_Row (
721: x_rowid => l_rowid,
722: x_geography_id => p_geography_id,
723: x_geography_type => p_geography_type,
724: x_parent_geography_type => p_parent_geography_type,

Line 956: HZ_GEO_STRUCTURE_LEVELS_PKG.Delete_Row (

952: END;
953:
954:
955: -- call table handler to delete the row
956: HZ_GEO_STRUCTURE_LEVELS_PKG.Delete_Row (
957: x_geography_id => p_geography_id,
958: x_geography_type => p_geography_type,
959: x_parent_geography_type => p_parent_geography_type
960: );