The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_resource_pre(
x_resource_id IN OUT NOCOPY NUMBER,
x_object_version IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
x_return_status := FND_API.g_ret_sts_success;
PROCEDURE delete_resource_post(
p_resource_id IN NUMBER,
p_object_version IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
x_return_status := FND_API.g_ret_sts_success;
PROCEDURE update_resource_pre(
x_resource_rec IN OUT NOCOPY AMS_ActResource_PUB.act_Resource_rec_type,
x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
x_return_status := FND_API.g_ret_sts_success;
PROCEDURE update_resource_post(
p_resource_rec IN AMS_ActResource_PUB.act_Resource_rec_type,
x_return_status OUT NOCOPY VARCHAR2
)
IS
BEGIN
x_return_status := FND_API.g_ret_sts_success;