[Home] [Help]
13: | NOTES
14: |This is primarily used for the triggers of mtl tables to update the
15: |IBE_CT_IMEDIA_SEARCH table .
16: |
17: |MTL_ITEM_CATEGORIES
18: |1) insert ,
19: |2) delete
20: |not sure if direct updates take place here
21: |
402: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
403: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
404: -- Check if item is under the category set specified by IBE_SEARCH_CATEGORY_SET
405: if l_search_category_set is not null then
406: select 1 into l_item_exists_count from mtl_item_categories
407: where inventory_item_id = p_inventory_item_id and
408: organization_id= p_organization_id and category_set_id=l_search_category_set
409: and rownum=1;
410: else ---- profile value NULL ie All Category Set Ids
407: where inventory_item_id = p_inventory_item_id and
408: organization_id= p_organization_id and category_set_id=l_search_category_set
409: and rownum=1;
410: else ---- profile value NULL ie All Category Set Ids
411: select 1 into l_item_exists_count from mtl_item_categories
412: where inventory_item_id = p_inventory_item_id and
413: organization_id= p_organization_id and rownum=1;
414: END If;
415:
486: old_inventory_item_id, b.LANGUAGE,
487: b.DESCRIPTION, b.LONG_DESCRIPTION,
488: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
489: d.category_set_id , new_web_status
490: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a
491: where b.INVENTORY_ITEM_ID = old_inventory_item_id
492: and b.ORGANIZATION_ID = old_organization_id
493: and b.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
494: and b.organization_id = d.organization_id
542: old_inventory_item_id, b.LANGUAGE,
543: b.DESCRIPTION, b.LONG_DESCRIPTION,
544: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),
545: d.category_set_id , new_web_status
546: from mtl_system_items_tl b ,mtl_item_categories d, mtl_system_items_b_kfv a
547: where b.INVENTORY_ITEM_ID = old_inventory_item_id
548: and b.ORGANIZATION_ID = old_organization_id
549: and b.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
550: and b.organization_id = d.organization_id
722: new_inventory_item_id, new_LANGUAGE,
723: new_DESCRIPTION, new_LONG_DESCRIPTION,
724: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
725: c.category_set_id , b.web_status
726: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
727: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
728: and b.organization_id = a.organization_id
729: and b.INVENTORY_ITEM_ID = new_inventory_item_id
730: and b.ORGANIZATION_ID = new_organization_id
749: new_inventory_item_id, new_LANGUAGE,
750: new_DESCRIPTION, new_LONG_DESCRIPTION,
751: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
752: c.category_set_id , b.web_status
753: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
754: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
755: and b.organization_id = a.organization_id
756: and b.INVENTORY_ITEM_ID = new_inventory_item_id
757: and b.ORGANIZATION_ID = new_organization_id
775: new_inventory_item_id, new_LANGUAGE,
776: new_DESCRIPTION, new_LONG_DESCRIPTION,
777: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),
778: c.category_set_id , b.web_status
779: from mtl_system_items_kfv a, mtl_system_items_b b, mtl_item_categories c
780: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
781: and b.organization_id = a.organization_id
782: and b.INVENTORY_ITEM_ID = new_inventory_item_id
783: and b.ORGANIZATION_ID = new_organization_id