APPS.HZ_DSS_ENTITIES_PKG dependencies on HZ_DSS_ENTITIES

Line 1: PACKAGE BODY HZ_DSS_ENTITIES_PKG AS

1: PACKAGE BODY HZ_DSS_ENTITIES_PKG AS
2: /* $Header: ARHPDSEB.pls 115.3 2003/01/07 19:25:24 jypandey noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 26: INSERT INTO HZ_DSS_ENTITIES (

22: BEGIN
23:
24: WHILE l_success = 'N' LOOP
25: BEGIN
26: INSERT INTO HZ_DSS_ENTITIES (
27: entity_id,
28: status,
29: object_id,
30: instance_set_id,

Line 47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,

43: object_version_number
44: )
45: VALUES (
46: DECODE(x_entity_id,
47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,
48: NULL, HZ_DSS_ENTITIES_S.NEXTVAL,
49: x_entity_id),
50: DECODE(x_status,
51: FND_API.G_MISS_CHAR, 'A',

Line 48: NULL, HZ_DSS_ENTITIES_S.NEXTVAL,

44: )
45: VALUES (
46: DECODE(x_entity_id,
47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,
48: NULL, HZ_DSS_ENTITIES_S.NEXTVAL,
49: x_entity_id),
50: DECODE(x_status,
51: FND_API.G_MISS_CHAR, 'A',
52: NULL, 'A',

Line 100: IF INSTR(SQLERRM, 'HZ_DSS_ENTITIES_U1') <> 0 THEN

96: l_success := 'Y';
97:
98: EXCEPTION
99: WHEN DUP_VAL_ON_INDEX THEN
100: IF INSTR(SQLERRM, 'HZ_DSS_ENTITIES_U1') <> 0 THEN
101: DECLARE
102: l_count NUMBER;
103: l_dummy VARCHAR2(1);
104: BEGIN

Line 107: SELECT HZ_DSS_ENTITIES_S.NEXTVAL

103: l_dummy VARCHAR2(1);
104: BEGIN
105: l_count := 1;
106: WHILE l_count > 0 LOOP
107: SELECT HZ_DSS_ENTITIES_S.NEXTVAL
108: INTO x_entity_id FROM dual;
109: BEGIN
110: SELECT 'Y' INTO l_dummy
111: FROM HZ_DSS_ENTITIES

Line 111: FROM HZ_DSS_ENTITIES

107: SELECT HZ_DSS_ENTITIES_S.NEXTVAL
108: INTO x_entity_id FROM dual;
109: BEGIN
110: SELECT 'Y' INTO l_dummy
111: FROM HZ_DSS_ENTITIES
112: WHERE entity_id = x_entity_id;
113: l_count := 1;
114: EXCEPTION
115: WHEN NO_DATA_FOUND THEN

Line 143: UPDATE HZ_DSS_ENTITIES

139: x_object_version_number IN NUMBER
140: ) IS
141: BEGIN
142:
143: UPDATE HZ_DSS_ENTITIES
144: SET
145: status =
146: DECODE(x_status,
147: NULL, status,

Line 226: SELECT * FROM hz_dss_entities

222: x_object_version_number IN NUMBER
223: ) IS
224:
225: CURSOR c IS
226: SELECT * FROM hz_dss_entities
227: WHERE rowid = x_rowid
228: FOR UPDATE NOWAIT;
229: Recinfo c%ROWTYPE;
230:

Line 345: FROM HZ_DSS_ENTITIES

341: x_parent_fk_column4,
342: x_parent_fk_column5,
343: x_group_assignment_level,
344: x_object_version_number
345: FROM HZ_DSS_ENTITIES
346: WHERE entity_id = x_entity_id;
347:
348: EXCEPTION
349: WHEN NO_DATA_FOUND THEN

Line 363: DELETE FROM HZ_DSS_ENTITIES

359: x_entity_id IN NUMBER
360: ) IS
361: BEGIN
362:
363: DELETE FROM HZ_DSS_ENTITIES
364: WHERE entity_id = x_entity_id;
365:
366: IF ( SQL%NOTFOUND ) THEN
367: RAISE NO_DATA_FOUND;

Line 372: END HZ_DSS_ENTITIES_PKG;

368: END IF;
369:
370: END Delete_Row;
371:
372: END HZ_DSS_ENTITIES_PKG;