APPS.AMS_ITEM_CATEGORY_PVT SQL Statements

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

Line: 38

    SELECT item_owner_id
           FROM ams_item_attributes
    WHERE inventory_item_id = p_inventory_item_id
         AND organization_id = p_organization_id;

Line: 120

 PROCEDURE Delete_Category_Assignment
  (
    p_api_version       IN   NUMBER,
    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_errorcode         OUT NOCOPY  NUMBER,
    x_msg_count         OUT NOCOPY  NUMBER,
    x_msg_data          OUT NOCOPY  VARCHAR2,
    p_category_id       IN   NUMBER,
    p_category_set_id   IN   NUMBER,
    p_inventory_item_id IN   NUMBER,
    p_organization_id   IN   NUMBER
   )
   IS

    l_api_version            CONSTANT NUMBER  := 1.0;

Line: 143

   SELECT 1
   FROM mtl_item_categories
   WHERE organization_id = p_organization_id
   AND inventory_item_id = p_inventory_item_id;

Line: 149

    SELECT item_owner_id
    FROM ams_item_attributes
    WHERE inventory_item_id = p_inventory_item_id
    AND organization_id = p_organization_id;

Line: 167

        INV_ITEM_CATEGORY_PUB.Delete_Category_Assignment
           (p_api_version       =>   l_api_version,
            p_init_msg_list     =>   p_init_msg_list,
            p_commit            =>   p_commit,
            x_return_status     =>   x_return_status,
            x_errorcode         =>   x_errorcode ,
            x_msg_count         =>   x_msg_count,
            x_msg_data          =>   x_msg_data,
            p_category_id       =>   l_category_id,
            p_category_set_id   =>   l_category_set_id,
            p_inventory_item_id =>   l_inventory_item_id,
            p_organization_id   =>   l_organization_id
        );

Line: 258

  END Delete_Category_Assignment;