APPS.HZ_DSS_GROUPS_PUB dependencies on HZ_DSS_SECURED_ENTITIES

Line 2123: * The create_secured_entity procedure creates a Secured Entity entry (HZ_DSS_SECURED_ENTITIES)

2119: /**
2120: * PROCEDURE create_secured_entity
2121: *
2122: * DESCRIPTION
2123: * The create_secured_entity procedure creates a Secured Entity entry (HZ_DSS_SECURED_ENTITIES)
2124: * for a Data Sharing Group.
2125: *
2126: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2127: *

Line 2308: HZ_DSS_SECURED_ENTITIES_PKG.Insert_Row (

2304: RAISE FND_API.G_EXC_ERROR;
2305: END IF;
2306:
2307: -- Call the low level table handler
2308: HZ_DSS_SECURED_ENTITIES_PKG.Insert_Row (
2309: x_rowid => row_id ,
2310: x_dss_group_code => p_dss_secured_entity.dss_group_code,
2311: x_entity_id => p_dss_secured_entity.entity_id,
2312: x_status => nvl(p_dss_secured_entity.status,'A'),

Line 2407: FROM hz_dss_secured_entities

2403: -- check whether record has been updated by another user. If not, lock it.
2404: BEGIN
2405: SELECT object_version_number, dss_instance_set_id, rowid, status
2406: INTO l_object_version_number, l_dss_instance_set_id , l_rowid, l_status
2407: FROM hz_dss_secured_entities
2408: WHERE dss_group_code = p_dss_secured_entity.dss_group_code
2409: AND entity_id = p_dss_secured_entity.entity_id
2410: FOR UPDATE NOWAIT;
2411: EXCEPTION

Line 2423: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SECURED_ENTITIES');

2419: l_object_version_number IS NULL) OR
2420: (x_object_version_number = l_object_version_number))
2421: THEN
2422: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2423: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SECURED_ENTITIES');
2424: FND_MSG_PUB.ADD;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:

Line 2475: HZ_DSS_SECURED_ENTITIES_PKG.Update_Row (

2471:
2472: END IF;
2473:
2474: -- Call the low level table handler
2475: HZ_DSS_SECURED_ENTITIES_PKG.Update_Row (
2476: x_rowid => l_rowid,
2477: x_status => p_dss_secured_entity.status,
2478: x_dss_instance_set_id => l_dss_instance_set_id ,
2479: x_object_version_number => x_object_version_number