APPS.HZ_DSS_SETUP_PUB dependencies on HZ_DSS_ENTITIES

Line 132: HZ_DSS_ENTITIES_PKG.Insert_Row (

128: END IF;
129: END IF;
130:
131: -- Call the low level table handler default status to A
132: HZ_DSS_ENTITIES_PKG.Insert_Row (
133: x_rowid => row_id,
134: x_entity_id => x_entity_id,
135: x_status => nvl(p_dss_entity_profile.status,'A') ,
136: x_object_id => p_dss_entity_profile.object_id,

Line 218: l_object_id HZ_DSS_ENTITIES.OBJECT_ID%TYPE;

214: x_msg_data OUT NOCOPY VARCHAR2
215: ) IS
216: l_object_version_number NUMBER;
217: l_rowid ROWID;
218: l_object_id HZ_DSS_ENTITIES.OBJECT_ID%TYPE;
219: l_instance_set_id HZ_DSS_ENTITIES.INSTANCE_SET_ID%TYPE;
220:
221: BEGIN
222:

Line 219: l_instance_set_id HZ_DSS_ENTITIES.INSTANCE_SET_ID%TYPE;

215: ) IS
216: l_object_version_number NUMBER;
217: l_rowid ROWID;
218: l_object_id HZ_DSS_ENTITIES.OBJECT_ID%TYPE;
219: l_instance_set_id HZ_DSS_ENTITIES.INSTANCE_SET_ID%TYPE;
220:
221: BEGIN
222:
223: -- standard start of API savepoint

Line 239: FROM HZ_DSS_ENTITIES

235:
236: BEGIN
237: SELECT object_version_number, rowid , object_id, instance_set_id
238: INTO l_object_version_number, l_rowid , l_object_id , l_instance_set_id
239: FROM HZ_DSS_ENTITIES
240: WHERE entity_id = p_dss_entity_profile.entity_id
241: FOR UPDATE NOWAIT;
242: EXCEPTION
243: WHEN NO_DATA_FOUND THEN

Line 253: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_ENTITIES');

249: IF NOT ((x_object_version_number is null and l_object_version_number is null)
250: OR (x_object_version_number = l_object_version_number))
251: THEN
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
253: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_ENTITIES');
254: FND_MSG_PUB.ADD;
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257:

Line 329: HZ_DSS_ENTITIES_PKG.Update_Row (

325: END IF;
326:
327:
328: -- Call the low level table handler
329: HZ_DSS_ENTITIES_PKG.Update_Row (
330: x_rowid => l_rowid,
331: x_status => p_dss_entity_profile.status,
332: x_object_id => p_dss_entity_profile.object_id,
333: x_instance_set_id => p_dss_entity_profile.instance_set_id,