APPS.AMS_ITEM_REVISION_PUB SQL Statements

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

Line: 99

PROCEDURE Update_Item_Revision
(
   p_api_version             IN   NUMBER
,  p_init_msg_list           IN   VARCHAR2   :=  FND_API.g_FALSE
,  p_commit                  IN   VARCHAR2   :=  FND_API.g_FALSE
,  p_validation_level        IN   NUMBER     :=  FND_API.g_VALID_LEVEL_FULL
,  x_return_status           OUT NOCOPY  VARCHAR2
,  x_msg_count               OUT NOCOPY  NUMBER
,  x_msg_data                OUT NOCOPY  VARCHAR2
,  p_Item_Revision_rec       IN   Item_Revision_rec_type
)
IS

l_Item_Revision_rec  INV_ITEM_REVISION_PUB.Item_Revision_rec_type;

Line: 137

 INV_ITEM_REVISION_PUB.update_Item_Revision
(
   p_api_version             =>  l_api_version
,  p_init_msg_list           =>  l_init_msg_list
,  p_commit                  =>  l_commit
,  p_validation_level        =>  l_validation_level
,  x_return_status           =>  x_return_status
,  x_msg_count               =>  x_msg_count
,  x_msg_data                =>  x_msg_data
,  p_Item_Revision_rec       =>  l_Item_Revision_rec
) ;

Line: 186

PROCEDURE Delete_Item_Revision
(
   p_api_version             IN   NUMBER
,  p_init_msg_list           IN   VARCHAR2   :=  FND_API.g_FALSE
,  p_commit                  IN   VARCHAR2   :=  FND_API.g_FALSE
,  p_validation_level        IN   NUMBER     :=  FND_API.g_VALID_LEVEL_FULL
,  x_return_status           OUT NOCOPY  VARCHAR2
,  x_msg_count               OUT NOCOPY  NUMBER
,  x_msg_data                OUT NOCOPY  VARCHAR2
,  p_inventory_item_id       IN   NUMBER
,  p_organization_id         IN   NUMBER
,  p_revision                IN   VARCHAR2
,  p_object_version_number   IN   NUMBER
)
IS


l_api_version                NUMBER ;

Line: 229

 INV_ITEM_REVISION_PUB.delete_Item_Revision
(
   p_api_version             =>  l_api_version
,  p_init_msg_list           =>  l_init_msg_list
,  p_commit                  =>  l_commit
,  p_validation_level        =>  l_validation_level
,  x_return_status           =>  x_return_status
,  x_msg_count               =>  x_msg_count
,  x_msg_data                =>  x_msg_data
,  p_inventory_item_id       =>  l_inventory_item_id
,  p_organization_id         =>  l_organization_id
,  p_revision                =>  l_revision
,  p_object_version_number   =>  l_object_version_number
) ;