APPS.HZ_DSS_SECURED_ENTITIES_PKG dependencies on HZ_DSS_SECURED_ENTITIES

Line 1: PACKAGE BODY HZ_DSS_SECURED_ENTITIES_PKG AS

1: PACKAGE BODY HZ_DSS_SECURED_ENTITIES_PKG AS
2: /* $Header: ARHPDSNB.pls 115.1 2002/09/30 06:27:03 cvijayan noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 19: INSERT INTO HZ_DSS_SECURED_ENTITIES (

15: BEGIN
16:
17: WHILE l_success = 'N' LOOP
18: BEGIN
19: INSERT INTO HZ_DSS_SECURED_ENTITIES (
20: dss_group_code,
21: entity_id,
22: status,
23: dss_instance_set_id,

Line 76: UPDATE HZ_DSS_SECURED_ENTITIES

72:
73: ) IS
74: BEGIN
75:
76: UPDATE HZ_DSS_SECURED_ENTITIES
77: SET
78: status =
79: DECODE(x_status,
80: NULL, status,

Line 123: SELECT * FROM HZ_DSS_SECURED_entities

119: x_object_version_number IN NUMBER
120: ) IS
121:
122: CURSOR c IS
123: SELECT * FROM HZ_DSS_SECURED_entities
124: WHERE rowid = x_rowid
125: FOR UPDATE NOWAIT;
126: Recinfo c%ROWTYPE;
127:

Line 194: FROM HZ_DSS_SECURED_ENTITIES

190: NVL(dss_instance_set_id, FND_API.G_MISS_NUM)
191: INTO
192: x_status,
193: x_dss_instance_set_id
194: FROM HZ_DSS_SECURED_ENTITIES
195: WHERE dss_group_code = x_dss_group_code
196: AND entity_id = x_entity_id ;
197:
198: EXCEPTION

Line 214: DELETE FROM HZ_DSS_SECURED_ENTITIES

210: x_entity_id IN NUMBER
211: ) IS
212: BEGIN
213:
214: DELETE FROM HZ_DSS_SECURED_ENTITIES
215: WHERE dss_group_code = x_dss_group_code
216: AND entity_id = x_entity_id ;
217:
218: IF ( SQL%NOTFOUND ) THEN

Line 224: END HZ_DSS_SECURED_ENTITIES_PKG;

220: END IF;
221:
222: END Delete_Row;
223:
224: END HZ_DSS_SECURED_ENTITIES_PKG;