APPS.INV_ITEM_STATUS_PUB SQL Statements

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

Line: 7

PROCEDURE Update_Pending_Status (p_api_version   IN   NUMBER
				,p_Org_Id        IN   NUMBER  := NULL
				,p_Item_Id       IN   NUMBER  := NULL
                                ,p_init_msg_list IN   VARCHAR2:=  FND_API.G_FALSE
                                ,p_commit        IN   VARCHAR2:=  FND_API.g_FALSE
				,x_return_status OUT  NOCOPY VARCHAR2
                                ,x_msg_count     OUT  NOCOPY NUMBER
                                ,x_msg_data      OUT  NOCOPY VARCHAR2)
IS
   l_api_name        CONSTANT  VARCHAR2(30)  :=  'Update_Pending_Status';

Line: 56

      INV_ITEM_MSG.Write_List(p_delete => TRUE);

Line: 62

      INV_ITEM_MSG.Write_List(p_delete => TRUE);

Line: 64

END Update_Pending_Status;