APPS.HZ_ADDRESS_USAGES_PKG dependencies on HZ_ADDRESS_USAGES

Line 1: PACKAGE BODY HZ_ADDRESS_USAGES_PKG AS

1: PACKAGE BODY HZ_ADDRESS_USAGES_PKG AS
2: /*$Header: ARHGNRRB.pls 120.0 2005/07/28 02:17:34 baianand noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 21: INSERT INTO HZ_ADDRESS_USAGES (

17: BEGIN
18:
19: WHILE l_success = 'N' LOOP
20: BEGIN
21: INSERT INTO HZ_ADDRESS_USAGES (
22: usage_id,
23: map_id,
24: usage_code,
25: status_flag,

Line 37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,

33: application_id
34: )
35: VALUES (
36: DECODE(x_usage_id,
37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,

Line 38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,

34: )
35: VALUES (
36: DECODE(x_usage_id,
37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,
42: x_map_id),

Line 74: IF INSTR(SQLERRM, 'HZ_ADDRESS_USAGES_U1') <> 0 THEN

70: l_success := 'Y';
71:
72: EXCEPTION
73: WHEN DUP_VAL_ON_INDEX THEN
74: IF INSTR(SQLERRM, 'HZ_ADDRESS_USAGES_U1') <> 0 THEN
75: DECLARE
76: l_count NUMBER;
77: l_dummy VARCHAR2(1);
78: BEGIN

Line 81: SELECT HZ_ADDRESS_USAGES_S.NEXTVAL

77: l_dummy VARCHAR2(1);
78: BEGIN
79: l_count := 1;
80: WHILE l_count > 0 LOOP
81: SELECT HZ_ADDRESS_USAGES_S.NEXTVAL
82: INTO x_usage_id FROM dual;
83: BEGIN
84: SELECT 'Y' INTO l_dummy
85: FROM HZ_ADDRESS_USAGES

Line 85: FROM HZ_ADDRESS_USAGES

81: SELECT HZ_ADDRESS_USAGES_S.NEXTVAL
82: INTO x_usage_id FROM dual;
83: BEGIN
84: SELECT 'Y' INTO l_dummy
85: FROM HZ_ADDRESS_USAGES
86: WHERE usage_id = x_usage_id;
87: l_count := 1;
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN

Line 115: UPDATE HZ_ADDRESS_USAGES

111: x_application_id IN NUMBER
112: ) IS
113: BEGIN
114:
115: UPDATE HZ_ADDRESS_USAGES
116: SET
117: usage_id =
118: DECODE(x_usage_id,
119: NULL, usage_id,

Line 182: SELECT * FROM hz_address_usages

178: x_application_id IN NUMBER
179: ) IS
180:
181: CURSOR c IS
182: SELECT * FROM hz_address_usages
183: WHERE rowid = x_rowid
184: FOR UPDATE NOWAIT;
185: Recinfo c%ROWTYPE;
186:

Line 269: FROM HZ_ADDRESS_USAGES

265: x_usage_code,
266: x_status_flag,
267: x_created_by_module,
268: x_application_id
269: FROM HZ_ADDRESS_USAGES
270: WHERE usage_id = x_usage_id;
271:
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN

Line 287: DELETE FROM HZ_ADDRESS_USAGES

283: x_usage_id IN NUMBER
284: ) IS
285: BEGIN
286:
287: DELETE FROM HZ_ADDRESS_USAGES
288: WHERE usage_id = x_usage_id;
289:
290: IF ( SQL%NOTFOUND ) THEN
291: RAISE NO_DATA_FOUND;

Line 296: END HZ_ADDRESS_USAGES_PKG;

292: END IF;
293:
294: END Delete_Row;
295:
296: END HZ_ADDRESS_USAGES_PKG;