[Home] [Help]
1: PACKAGE BODY ibe_search_setup_pvt AS
2: /* $Header: IBEVCSIB.pls 120.9 2012/04/11 10:52:23 scnagara ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | Redwood Shores, California, USA |
24: | ytian - bug12980419/13252575 -- Changed Fuzzy score to 1 |
25: | scnagara - bug13935780 -- Removed CTXSYS schema reference |
26: |___________________________________________________________________________|*/
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_search_setup_pvt';
29: G_FETCH_LIMIT CONSTANT NUMBER := 1000;
30:
31: -- for the test harness
32: G_TEST_FLAG_ON boolean := false;
131:
132: end if;
133:
134:
135: ibe_search_setup_pvt.search_move_data(l_errbuf,l_retcode);
136:
137: end Test_Search_Move_Data; --}
138: --}
139:
351: b.INVENTORY_ITEM_ID,
352: b.LANGUAGE,
353: b.DESCRIPTION,
354: b.LONG_DESCRIPTION,
355: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
356: a.web_status,
357: null
358: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
359: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and
391: b.INVENTORY_ITEM_ID,
392: b.LANGUAGE,
393: b.DESCRIPTION,
394: b.LONG_DESCRIPTION,
395: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
396: a.web_status,
397: null
398: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c
399: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
430: b.INVENTORY_ITEM_ID,
431: b.LANGUAGE,
432: b.DESCRIPTION,
433: b.LONG_DESCRIPTION,
434: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
435: a.web_status,
436: null
437: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
438: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
469: b.INVENTORY_ITEM_ID,
470: b.LANGUAGE,
471: b.DESCRIPTION,
472: b.LONG_DESCRIPTION,
473: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
474: a.web_status,
475: null
476: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
477: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
508: b.INVENTORY_ITEM_ID,
509: b.LANGUAGE,
510: b.DESCRIPTION,
511: b.LONG_DESCRIPTION,
512: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
513: a.web_status,
514: null
515: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
516: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
548: b.INVENTORY_ITEM_ID,
549: b.LANGUAGE,
550: b.DESCRIPTION,
551: b.LONG_DESCRIPTION,
552: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
553: a.web_status,
554: null
555: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
556: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Intermedia Index created , procedure completed sucessfully');
668: ----dbms_output.put_line('Intermedia Index created , procedure completed sucessfully');
669: end Search_Move_Data;
670:
671: end ibe_search_setup_pvt ;