[Home] [Help]
1: PACKAGE BODY ibe_search_setup_pvt AS
2: /* $Header: IBEVCSIB.pls 120.5 2008/04/16 08:41:57 mgiridha ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | Redwood Shores, California, USA |
21: | madesai - bug fix 4674288 -explicitly remove korean lobs lexer |
22: | mgiridha - bug 6924793 - changes to FP 11510 bug 6777665 |
23: |___________________________________________________________________________|*/
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_search_setup_pvt';
26: G_FETCH_LIMIT CONSTANT NUMBER := 1000;
27:
28: -- for the test harness
29: G_TEST_FLAG_ON boolean := false;
128:
129: end if;
130:
131:
132: ibe_search_setup_pvt.search_move_data(l_errbuf,l_retcode);
133:
134: end Test_Search_Move_Data; --}
135: --}
136:
310: b.INVENTORY_ITEM_ID,
311: b.LANGUAGE,
312: b.DESCRIPTION,
313: b.LONG_DESCRIPTION,
314: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
315: a.web_status,
316: null
317: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
318: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and
350: b.INVENTORY_ITEM_ID,
351: b.LANGUAGE,
352: b.DESCRIPTION,
353: b.LONG_DESCRIPTION,
354: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
355: a.web_status,
356: null
357: FROM mtl_system_items_b_kfv a,mtl_system_items_tl b,mtl_item_categories c
358: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
389: b.INVENTORY_ITEM_ID,
390: b.LANGUAGE,
391: b.DESCRIPTION,
392: b.LONG_DESCRIPTION,
393: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
394: a.web_status,
395: null
396: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
397: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
428: b.INVENTORY_ITEM_ID,
429: b.LANGUAGE,
430: b.DESCRIPTION,
431: b.LONG_DESCRIPTION,
432: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
433: a.web_status,
434: null
435: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
436: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
467: b.INVENTORY_ITEM_ID,
468: b.LANGUAGE,
469: b.DESCRIPTION,
470: b.LONG_DESCRIPTION,
471: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
472: a.web_status,
473: null
474: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
475: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
507: b.INVENTORY_ITEM_ID,
508: b.LANGUAGE,
509: b.DESCRIPTION,
510: b.LONG_DESCRIPTION,
511: ibe_search_setup_pvt.WriteToLob(b.DESCRIPTION,b.LONG_DESCRIPTION,a.concatenated_segments),
512: a.web_status,
513: null
514: FROM mtl_system_items_b_kfv a ,mtl_system_items_tl b , mtl_item_categories c
515: WHERE b.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID and b.organization_id = c.organization_id
625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Intermedia Index created , procedure completed sucessfully');
626: ----dbms_output.put_line('Intermedia Index created , procedure completed sucessfully');
627: end Search_Move_Data;
628:
629: end ibe_search_setup_pvt ;