DBA Data[Home] [Help]

APPS.AMS_ACTRESOURCE_CUHK 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;