DBA Data[Home] [Help]

APPS.IBE_SEARCH_PVT dependencies on IBE_SEARCH_SETUP_PVT

Line 107: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,
105: new_inventory_item_id, b.LANGUAGE,
106: b.DESCRIPTION, b.LONG_DESCRIPTION,
107: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
108: new_category_set_id , a.web_status
109: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
110: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
111: and b.organization_id = a.organization_id

Line 135: ibe_search_setup_pvt.WriteToLob(b.description, b.long_description ,c.concatenated_segments),

131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,
133: new_inventory_item_id, b.LANGUAGE,
134: b.DESCRIPTION, b.LONG_DESCRIPTION,
135: ibe_search_setup_pvt.WriteToLob(b.description, b.long_description ,c.concatenated_segments),
136: new_category_set_id , a.web_status
137: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
138: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
139: and b.organization_id = a.organization_id

Line 161: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,
159: new_inventory_item_id, b.LANGUAGE,
160: b.DESCRIPTION, b.LONG_DESCRIPTION,
161: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
162: new_category_set_id , a.web_status
163: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
164: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
165: and b.organization_id = a.organization_id

Line 351: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),

347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,
349: new_inventory_item_id, b.LANGUAGE,
350: b.DESCRIPTION, b.LONG_DESCRIPTION,
351: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,c.concatenated_segments),
352: new_category_set_id , a.web_status
353: from mtl_system_items_b a ,mtl_system_items_tl b ,mtl_system_items_kfv c
354: where b.INVENTORY_ITEM_ID = a.INVENTORY_ITEM_ID
355: and b.organization_id = a.organization_id

Line 488: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),

484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,
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

Line 544: ibe_search_setup_pvt.WriteToLob(b.description , b.long_description ,a.concatenated_segments),

540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_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

Line 610: g.INDEXED_SEARCH = (select ibe_search_setup_pvt.WriteToLob(new_description , new_long_description,a.concatenated_segments)

606: g.language = new_language ,
607: g.LAST_UPDATE_DATE = sysdate ,
608: g.DESCRIPTION = new_description ,
609: g.LONG_DESCRIPTION = new_long_description ,
610: g.INDEXED_SEARCH = (select ibe_search_setup_pvt.WriteToLob(new_description , new_long_description,a.concatenated_segments)
611: from mtl_system_items_kfv a
612: where a.inventory_item_id = old_inventory_item_id
613: and a.organization_id = old_organization_id
614: )

Line 724: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),

720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_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

Line 751: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),

747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_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

Line 777: ibe_search_setup_pvt.WriteToLob(new_description , new_long_description ,a.concatenated_segments),

773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_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