APPS.HZ_GEOGRAPHY_RANGES_PKG dependencies on HZ_GEOGRAPHY_RANGES

Line 1: PACKAGE BODY HZ_GEOGRAPHY_RANGES_PKG AS

1: PACKAGE BODY HZ_GEOGRAPHY_RANGES_PKG AS
2: /*$Header: ARHGRGTB.pls 115.0 2003/02/01 02:52:22 rnalluri noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 24: INSERT INTO HZ_GEOGRAPHY_RANGES (

20:
21:
22: BEGIN
23:
24: INSERT INTO HZ_GEOGRAPHY_RANGES (
25: geography_id,
26: geography_from,
27: start_date,
28: object_version_number,

Line 120: UPDATE HZ_GEOGRAPHY_RANGES

116: x_program_login_id IN NUMBER
117: ) IS
118: BEGIN
119:
120: UPDATE HZ_GEOGRAPHY_RANGES
121: SET
122: geography_id =
123: DECODE(x_geography_id,
124: NULL, geography_id,

Line 229: SELECT * FROM hz_geography_ranges

225: x_request_id IN NUMBER
226: ) IS
227:
228: CURSOR c IS
229: SELECT * FROM hz_geography_ranges
230: WHERE rowid = x_rowid
231: FOR UPDATE NOWAIT;
232: Recinfo c%ROWTYPE;
233:

Line 361: FROM HZ_GEOGRAPHY_RANGES

357: x_master_ref_geography_id,
358: x_created_by_module,
359: x_application_id,
360: x_program_login_id
361: FROM HZ_GEOGRAPHY_RANGES
362: WHERE geography_id = x_geography_id
363: AND geography_from = x_geography_from
364: AND start_date = x_start_date;
365:

Line 383: DELETE FROM HZ_GEOGRAPHY_RANGES

379: x_start_date IN DATE
380: ) IS
381: BEGIN
382:
383: DELETE FROM HZ_GEOGRAPHY_RANGES
384: WHERE geography_id = x_geography_id
385: AND geography_from = x_geography_from
386: AND start_date = x_start_date;
387:

Line 394: END HZ_GEOGRAPHY_RANGES_PKG;

390: END IF;
391:
392: END Delete_Row;
393:
394: END HZ_GEOGRAPHY_RANGES_PKG;