APPS.HZ_GEO_STRUCT_MAP_PVT dependencies on HZ_GEO_STRUCT_MAP

Line 1: PACKAGE BODY HZ_GEO_STRUCT_MAP_PVT AS

1: PACKAGE BODY HZ_GEO_STRUCT_MAP_PVT AS
2: /*$Header: ARHGEMMB.pls 115.1 2003/02/11 19:46:49 sachandr noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 15: INSERT INTO HZ_GEO_STRUCT_MAP (

11:
12:
13: BEGIN
14:
15: INSERT INTO HZ_GEO_STRUCT_MAP (
16: map_id,
17: country_code,
18: loc_tbl_name,
19: address_style,

Line 60: SELECT * FROM hz_geo_struct_map

56: x_address_style IN VARCHAR2
57: ) IS
58:
59: CURSOR c IS
60: SELECT * FROM hz_geo_struct_map
61: WHERE rowid = x_rowid
62: FOR UPDATE NOWAIT;
63: Recinfo c%ROWTYPE;
64:

Line 118: FROM HZ_GEO_STRUCT_MAP

114: x_map_id,
115: x_country_code,
116: x_loc_tbl_name,
117: x_address_style
118: FROM HZ_GEO_STRUCT_MAP
119: WHERE map_id = x_map_id;
120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN

Line 136: DELETE FROM hz_geo_struct_map

132: x_map_id IN NUMBER
133: ) IS
134: BEGIN
135:
136: DELETE FROM hz_geo_struct_map
137: WHERE map_id = x_map_id;
138:
139: IF (SQL%NOTFOUND) THEN
140: RAISE NO_DATA_FOUND;

Line 145: END HZ_GEO_STRUCT_MAP_PVT;

141: END IF;
142:
143: END Delete_Row;
144:
145: END HZ_GEO_STRUCT_MAP_PVT;