APPS.ICX_CAT_POPULATE_MI_GRP SQL Statements

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

Line: 76

    SELECT COUNT(*)
    INTO l_tmp_count
    FROM mtl_system_items_kfv mi
    WHERE mi.inventory_item_id = p_inventory_item_id
    AND mi.organization_id = p_organization_id;

Line: 89

    SELECT COUNT(*)
    INTO l_tmp_count
    FROM mtl_system_items_tl mtl
    WHERE mtl.inventory_item_id = p_inventory_item_id
    AND mtl.organization_id = p_organization_id
    AND mtl.language = mtl.source_lang;

Line: 103

    SELECT COUNT(*)
    INTO l_tmp_count
    FROM mtl_item_categories mic
    WHERE mic.inventory_item_id = p_inventory_item_id
    AND mic.organization_id = p_organization_id
    AND mic.category_set_id = 2;

Line: 127

  IF (P_DML_TYPE = 'DELETE') THEN
    -- Info: Deleting an item from the master org also deletes the items from its child orgs
    l_err_loc := 800;

Line: 130

    ICX_CAT_POPULATE_MI_PVT.populateItemDelete(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);

Line: 394

  IF (P_DML_TYPE = 'DELETE') THEN
    l_err_loc := 1000;

Line: 396

    ICX_CAT_POPULATE_MI_PVT.populateItemCatgDelete(P_INVENTORY_ITEM_ID, P_ORGANIZATION_ID);