APPS.HZ_GEO_STRUCTURE_LEVELS_PKG dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 1: PACKAGE BODY HZ_GEO_STRUCTURE_LEVELS_PKG AS

1: PACKAGE BODY HZ_GEO_STRUCTURE_LEVELS_PKG AS
2: /*$Header: ARHGSTTB.pls 120.1 2005/07/28 02:05:31 baianand noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 24: INSERT INTO HZ_GEO_STRUCTURE_LEVELS (

20: BEGIN
21:
22: --dbms_output.put_line.PUT_LINE('relationship_type_id is '||to_char(x_relationship_type_id));
23:
24: INSERT INTO HZ_GEO_STRUCTURE_LEVELS (
25: geography_id,
26: geography_type,
27: parent_geography_type,
28: object_version_number,

Line 109: UPDATE HZ_GEO_STRUCTURE_LEVELS

105: x_program_login_id IN NUMBER
106: ) IS
107: BEGIN
108:
109: UPDATE HZ_GEO_STRUCTURE_LEVELS
110: SET
111: geography_id =
112: DECODE(x_geography_id,
113: NULL, geography_id,

Line 200: SELECT * FROM hz_geo_structure_levels

196: x_request_id IN NUMBER
197: ) IS
198:
199: CURSOR c IS
200: SELECT * FROM hz_geo_structure_levels
201: WHERE rowid = x_rowid
202: FOR UPDATE NOWAIT;
203: Recinfo c%ROWTYPE;
204:

Line 314: FROM HZ_GEO_STRUCTURE_LEVELS

310: x_geography_element_column,
311: x_created_by_module,
312: x_application_id,
313: x_program_login_id
314: FROM HZ_GEO_STRUCTURE_LEVELS
315: WHERE geography_id = x_geography_id
316: AND geography_type = x_geography_type
317: AND parent_geography_type = x_parent_geography_type;
318:

Line 337: DELETE FROM HZ_GEO_STRUCTURE_LEVELS

333:
334: ) IS
335: BEGIN
336:
337: DELETE FROM HZ_GEO_STRUCTURE_LEVELS
338: WHERE geography_id = x_geography_id
339: AND geography_type = x_geography_type
340: AND parent_geography_type = x_parent_geography_type;
341:

Line 348: END HZ_GEO_STRUCTURE_LEVELS_PKG;

344: END IF;
345:
346: END Delete_Row;
347:
348: END HZ_GEO_STRUCTURE_LEVELS_PKG;