APPS.HZ_ADDRESS_USAGE_DTLS_PKG dependencies on HZ_ADDRESS_USAGE_DTLS

Line 1: PACKAGE BODY HZ_ADDRESS_USAGE_DTLS_PKG AS

1: PACKAGE BODY HZ_ADDRESS_USAGE_DTLS_PKG AS
2: /*$Header: ARHGNRTB.pls 120.1 2005/08/26 17:54:23 baianand noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 20: INSERT INTO HZ_ADDRESS_USAGE_DTLS (

16: BEGIN
17:
18: -- WHILE l_success = 'N' LOOP
19: -- BEGIN
20: INSERT INTO HZ_ADDRESS_USAGE_DTLS (
21: usage_dtl_id,
22: usage_id,
23: geography_type,
24: created_by,

Line 35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,

31: application_id
32: )
33: VALUES (
34: DECODE(x_usage_dtl_id,
35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,

Line 36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,

32: )
33: VALUES (
34: DECODE(x_usage_dtl_id,
35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_usage_id),

Line 69: IF INSTR(SQLERRM, 'HZ_ADDRESS_USAGE_DTLS_U1') <> 0 THEN

65: l_success := 'Y';
66:
67: EXCEPTION
68: WHEN DUP_VAL_ON_INDEX THEN
69: IF INSTR(SQLERRM, 'HZ_ADDRESS_USAGE_DTLS_U1') <> 0 THEN
70: DECLARE
71: l_count NUMBER;
72: l_dummy VARCHAR2(1);
73: BEGIN

Line 76: SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL

72: l_dummy VARCHAR2(1);
73: BEGIN
74: l_count := 1;
75: WHILE l_count > 0 LOOP
76: SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL
77: INTO x_usage_dtl_id FROM dual;
78: BEGIN
79: SELECT 'Y' INTO l_dummy
80: FROM HZ_ADDRESS_USAGE_DTLS

Line 80: FROM HZ_ADDRESS_USAGE_DTLS

76: SELECT HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL
77: INTO x_usage_dtl_id FROM dual;
78: BEGIN
79: SELECT 'Y' INTO l_dummy
80: FROM HZ_ADDRESS_USAGE_DTLS
81: WHERE usage_dtl_id = x_usage_dtl_id;
82: l_count := 1;
83: EXCEPTION
84: WHEN NO_DATA_FOUND THEN

Line 107: UPDATE HZ_ADDRESS_USAGE_DTLS

103: x_application_id IN NUMBER
104: ) IS
105: BEGIN
106:
107: UPDATE HZ_ADDRESS_USAGE_DTLS
108: SET
109: usage_dtl_id =
110: DECODE(x_usage_dtl_id,
111: NULL, usage_dtl_id,

Line 168: SELECT * FROM hz_address_usage_dtls

164: x_application_id IN NUMBER
165: ) IS
166:
167: CURSOR c IS
168: SELECT * FROM hz_address_usage_dtls
169: WHERE rowid = x_rowid
170: FOR UPDATE NOWAIT;
171: Recinfo c%ROWTYPE;
172:

Line 249: FROM HZ_ADDRESS_USAGE_DTLS

245: x_usage_id,
246: x_geography_type,
247: x_created_by_module,
248: x_application_id
249: FROM HZ_ADDRESS_USAGE_DTLS
250: WHERE usage_dtl_id = x_usage_dtl_id;
251:
252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN

Line 267: DELETE FROM HZ_ADDRESS_USAGE_DTLS

263: x_usage_dtl_id IN NUMBER
264: ) IS
265: BEGIN
266:
267: DELETE FROM HZ_ADDRESS_USAGE_DTLS
268: WHERE usage_dtl_id = x_usage_dtl_id;
269:
270: IF ( SQL%NOTFOUND ) THEN
271: RAISE NO_DATA_FOUND;

Line 276: END HZ_ADDRESS_USAGE_DTLS_PKG;

272: END IF;
273:
274: END Delete_Row;
275:
276: END HZ_ADDRESS_USAGE_DTLS_PKG;