APPS.AMS_ACTRESOURCE_VUHK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

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;

Line: 71

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;

Line: 131

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;

Line: 150

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;