APPS.HZ_GEO_STRUCT_MAP_DTL_PVT dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 1: PACKAGE BODY HZ_GEO_STRUCT_MAP_DTL_PVT AS

1: PACKAGE BODY HZ_GEO_STRUCT_MAP_DTL_PVT AS
2: /*$Header: ARHGEMDB.pls 120.2 2005/09/01 20:02:05 baianand noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 16: INSERT INTO HZ_GEO_STRUCT_MAP_DTL (

12:
13:
14: BEGIN
15:
16: INSERT INTO HZ_GEO_STRUCT_MAP_DTL (
17: map_id,
18: loc_seq_num,
19: loc_component,
20: geography_type,

Line 66: UPDATE HZ_GEO_STRUCT_MAP_DTL

62: x_geo_element_col IN VARCHAR2
63: ) IS
64: BEGIN
65:
66: UPDATE HZ_GEO_STRUCT_MAP_DTL
67: SET
68: map_id =
69: DECODE(x_map_id,
70: NULL, map_id,

Line 115: SELECT * FROM hz_geo_struct_map_dtl

111: x_geo_element_col IN VARCHAR2
112: ) IS
113:
114: CURSOR c IS
115: SELECT * FROM hz_geo_struct_map_dtl
116: WHERE rowid = x_rowid
117: FOR UPDATE NOWAIT;
118: Recinfo c%ROWTYPE;
119:

Line 174: FROM HZ_GEO_STRUCT_MAP_DTL

170: x_map_id,
171: x_loc_seq_num,
172: x_loc_component,
173: x_geography_type
174: FROM HZ_GEO_STRUCT_MAP_DTL
175: WHERE map_id = x_map_id;
176:
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN

Line 192: DELETE FROM hz_geo_struct_map_dtl

188: x_map_id IN NUMBER
189: ) IS
190: BEGIN
191:
192: DELETE FROM hz_geo_struct_map_dtl
193: WHERE map_id = x_map_id;
194:
195: IF (SQL%NOTFOUND) THEN
196: RAISE NO_DATA_FOUND;

Line 208: DELETE FROM hz_geo_struct_map_dtl

204: x_geography_type IN VARCHAR2
205: ) IS
206: BEGIN
207:
208: DELETE FROM hz_geo_struct_map_dtl
209: WHERE map_id = x_map_id
210: AND geography_type = x_geography_type;
211:
212: IF (SQL%NOTFOUND) THEN

Line 218: END HZ_GEO_STRUCT_MAP_DTL_PVT;

214: END IF;
215:
216: END Delete_Row;
217:
218: END HZ_GEO_STRUCT_MAP_DTL_PVT;