eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_SEARCH_PVT dependencies on IBE_CT_IMEDIA_SEARCH

Line 15: |IBE_CT_IMEDIA_SEARCH table .

Line 92: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED/NULL');

88: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
89:
90: IF l_search_web_status = 'PUBLISHED' or l_search_web_status is NULL THEN
91:
92: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED/NULL');
93: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
94: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
95: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
96: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID

Line 93: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

89:
90: IF l_search_web_status = 'PUBLISHED' or l_search_web_status is NULL THEN
91:
92: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED/NULL');
93: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
94: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
95: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
96: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
97: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 100: ibe_ct_imedia_search_s1.nextval,

96: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
97: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
98: , CATEGORY_SET_ID, WEB_STATUS)
99: SELECT
100: ibe_ct_imedia_search_s1.nextval,
101: 0, FND_GLOBAL.user_id,
102: SYSDATE, FND_GLOBAL.user_id,
103: SYSDATE, FND_GLOBAL.conc_login_id,
104: new_category_id , new_organization_id ,

Line 120: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED_UNPUBLISHED');

116: and a.web_status = 'PUBLISHED';
117:
118: ELSIF l_search_web_status ='PUBLISHED_UNPUBLISHED' THEN
119:
120: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED_UNPUBLISHED');
121: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
122: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
123: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
124: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID

Line 121: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

117:
118: ELSIF l_search_web_status ='PUBLISHED_UNPUBLISHED' THEN
119:
120: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status PUBLISHED_UNPUBLISHED');
121: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
122: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
123: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
124: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
125: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 128: ibe_ct_imedia_search_s1.nextval,

124: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
125: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
126: , CATEGORY_SET_ID, WEB_STATUS)
127: SELECT
128: ibe_ct_imedia_search_s1.nextval,
129: 0, FND_GLOBAL.user_id,
130: SYSDATE, FND_GLOBAL.user_id,
131: SYSDATE, FND_GLOBAL.conc_login_id,
132: new_category_id , new_organization_id ,

Line 146: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status ALL');

142: and a.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID
143: and a.ORGANIZATION_ID = c.organization_id
144: and a.web_status IN ('PUBLISHED', 'UNPUBLISHED');
145: ELSE
146: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status ALL');
147: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
148: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
149: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
150: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID

Line 147: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

143: and a.ORGANIZATION_ID = c.organization_id
144: and a.web_status IN ('PUBLISHED', 'UNPUBLISHED');
145: ELSE
146: --dbms_output.put_line('inserting into ibe_ct_imedia_search table for web status ALL');
147: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
148: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
149: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
150: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
151: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 154: ibe_ct_imedia_search_s1.nextval,

150: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
151: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
152: , CATEGORY_SET_ID, WEB_STATUS)
153: SELECT
154: ibe_ct_imedia_search_s1.nextval,
155: 0, FND_GLOBAL.user_id,
156: SYSDATE, FND_GLOBAL.user_id,
157: SYSDATE, FND_GLOBAL.conc_login_id,
158: new_category_id , new_organization_id ,

Line 192: delete from ibe_ct_imedia_search c

188: old_organization_id number)
189: is
190: begin
191:
192: delete from ibe_ct_imedia_search c
193: where c.CATEGORY_ID = old_category_id
194: and c.CATEGORY_SET_ID = old_category_set_id
195: and c.INVENTORY_ITEM_ID = old_inventory_item_id
196: and c.ORGANIZATION_ID = old_organization_id ;

Line 246: update ibe_ct_imedia_search c

242: --||':newOrgId='||new_organization_id);
243:
244: IF old_category_set_id = new_category_set_id THEN
245: --dbms_output.put_line('Updating data :old category set id = new category set id');
246: update ibe_ct_imedia_search c
247: set CATEGORY_ID = new_category_id,
248: CATEGORY_SET_ID = new_category_set_id,
249: LAST_UPDATE_DATE = sysdate,
250: INVENTORY_ITEM_ID = new_inventory_item_id,

Line 264: update ibe_ct_imedia_search c

260: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
261: ----dbms_output.put_line('Search category set='||l_search_category_set);
262: IF l_search_category_set is NULL THEN
263: ------dbms_output.put_line('Updating data :search category set is null');
264: update ibe_ct_imedia_search c
265: set CATEGORY_ID = new_category_id,
266: CATEGORY_SET_ID = new_category_set_id,
267: LAST_UPDATE_DATE = sysdate,
268: INVENTORY_ITEM_ID = new_inventory_item_id,

Line 291: update ibe_ct_imedia_search c

287: FETCH c_check_section_item_csr into l_temp;
288: IF c_check_section_item_csr%FOUND then
289: --- update the record
290: CLOSE c_check_section_item_csr;
291: update ibe_ct_imedia_search c
292: set CATEGORY_ID = new_category_id,
293: CATEGORY_SET_ID = new_category_set_id,
294: LAST_UPDATE_DATE = sysdate,
295: INVENTORY_ITEM_ID = new_inventory_item_id,

Line 305: DELETE ibe_ct_imedia_search where

301:
302: ELSE ------- c_check_section_item_csr NOT found-----------
303: -- delete the record -
304: CLOSE c_check_section_item_csr;
305: DELETE ibe_ct_imedia_search where
306: CATEGORY_ID = old_category_id
307: AND CATEGORY_SET_ID = old_category_set_id
308: AND INVENTORY_ITEM_ID = old_inventory_item_id
309: AND ORGANIZATION_ID = old_organization_id;

Line 313: DELETE ibe_ct_imedia_search where

309: AND ORGANIZATION_ID = old_organization_id;
310: END IF;
311:
312: ELSE ------l_use_category_search ='Y'--------
313: DELETE ibe_ct_imedia_search where
314: CATEGORY_ID = old_category_id
315: AND CATEGORY_SET_ID = old_category_set_id
316: AND INVENTORY_ITEM_ID = old_inventory_item_id
317: AND ORGANIZATION_ID = old_organization_id;

Line 322: --Insert item into ibe_ct_imedia_search table based on the new value and IBE_SEARCH_WEB_STATUS profile value;

318: END IF;
319:
320: ElSIF new_category_set_id = l_search_category_set THEN
321: ----dbms_output.put_line('Adding row :new category set id = l_search category set');
322: --Insert item into ibe_ct_imedia_search table based on the new value and IBE_SEARCH_WEB_STATUS profile value;
323:
324: select web_status into l_web_status from mtl_system_items_b
325: where inventory_item_id=new_inventory_item_id and organization_id= new_organization_id;
326: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);

Line 335: ----dbms_output.put_line ('Inserting into ibe_ct_imedia_search table');

331: OR l_search_web_status=l_web_status
332: OR (l_search_web_status='PUBLISHED_UNPUBLISHED' AND l_web_status='PUBLISHED')
333: OR (l_search_web_status='PUBLISHED_UNPUBLISHED' AND l_web_status='UNPUBLISHED')) THEN
334:
335: ----dbms_output.put_line ('Inserting into ibe_ct_imedia_search table');
336:
337: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
338: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
339: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN

Line 337: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

333: OR (l_search_web_status='PUBLISHED_UNPUBLISHED' AND l_web_status='UNPUBLISHED')) THEN
334:
335: ----dbms_output.put_line ('Inserting into ibe_ct_imedia_search table');
336:
337: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
338: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
339: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
340: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
341: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 344: ibe_ct_imedia_search_s1.nextval,

340: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
341: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
342: , CATEGORY_SET_ID, WEB_STATUS)
343: SELECT
344: ibe_ct_imedia_search_s1.nextval,
345: 0, FND_GLOBAL.user_id,
346: SYSDATE, FND_GLOBAL.user_id,
347: SYSDATE, FND_GLOBAL.conc_login_id,
348: new_category_id , new_organization_id ,

Line 381: delete from ibe_ct_imedia_search c

377: old_organization_id number)
378: is
379: begin
380:
381: delete from ibe_ct_imedia_search c
382: where c.INVENTORY_ITEM_ID = old_inventory_item_id
383: and c.ORGANIZATION_ID = old_organization_id ;
384:
385: end Item_Deleted ;

Line 424: -- the web_status in ibe_ct_imedia_search

420: --WE will not insert new row when web_status flag
421: -- is updated to "PUBLISHED" because we already
422: -- have a data inserted through the concurrent program
423: -- regardless of web_status. We just need to update
424: -- the web_status in ibe_ct_imedia_search
425: -----------------------------------------------
426: procedure Item_Updated(
427: old_inventory_item_id number,
428: old_organization_id number,

Line 449: update ibe_ct_imedia_search

445: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
446:
447: IF l_search_web_status='ALL' THEN
448: --dbms_output.put_line('updating data;Web status =ALL');
449: update ibe_ct_imedia_search
450: set web_status = new_web_status
451: where inventory_item_id = old_inventory_item_id
452: and organization_id = old_organization_id;
453:

Line 465: --Insert item into ibe_ct_imedia_search;

461: l_item_exists:=Item_In_CatSetId_profile(old_inventory_item_id,old_organization_id);
462:
463: ----dbms_output.put_line('l_item_exists='||l_item_exists);
464: IF (l_item_exists>0) then
465: --Insert item into ibe_ct_imedia_search;
466: --dbms_output.put_line('Adding Row ;l_item_exists >0');
467:
468: -- ***inserting '' for the concatenated_segment in the clob
469: --as cannot access mtl_system_items_kfv.concatenated_segments value here.

Line 474: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

470: --Later on ItemTL_Updated trigger will be called which will update the
471: -- CLOB value ****.
472: -- Above comment is not valid changed below query for bug 6924793 mgiridha
473:
474: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
475: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
476: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
477: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
478: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 481: ibe_ct_imedia_search_s1.nextval,

477: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
478: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
479: , CATEGORY_SET_ID, WEB_STATUS)
480: SELECT
481: ibe_ct_imedia_search_s1.nextval,
482: 0, FND_GLOBAL.user_id,
483: SYSDATE, FND_GLOBAL.user_id,
484: SYSDATE, FND_GLOBAL.conc_login_id,
485: d.category_id , old_organization_id ,

Line 504: update ibe_ct_imedia_search

500: ELSE -- old_web_status IN ('PUBLISHED', 'UNPUBLISHED')
501: IF new_web_status IN ('PUBLISHED', 'UNPUBLISHED') THEN
502: ----dbms_output.put_line('updating... ,new_web_status IN (PUBLISHED, UNPUBLISHED');
503:
504: update ibe_ct_imedia_search
505: set web_status = new_web_status
506: where inventory_item_id = old_inventory_item_id
507: AND organization_id = old_organization_id;
508: END IF;

Line 521: --Insert item into ibe_ct_imedia_search;

517: -- need to check whether the item exists under the profile category_set_id value
518: l_item_exists:=Item_In_CatSetId_profile(old_inventory_item_id,old_organization_id);
519:
520: IF (l_item_exists>0) then
521: --Insert item into ibe_ct_imedia_search;
522: ----dbms_output.put_line('inserting row...: l_item_exists='||l_item_exists);
523:
524: --**** inserting '' for the concatenated_segment in the clob
525: --as cannot access mtl_system_items_kfv.concatenated_segments value here.

Line 530: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

526: --Later on ItemTL_Updated trigger will be called which will update the
527: -- CLOB value ****.
528: -- Above comment is not valid changed below query for bug 6924793 mgiridha
529:
530: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
531: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
532: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
533: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
534: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 537: ibe_ct_imedia_search_s1.nextval,

533: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
534: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
535: , CATEGORY_SET_ID, WEB_STATUS)
536: SELECT
537: ibe_ct_imedia_search_s1.nextval,
538: 0, FND_GLOBAL.user_id,
539: SYSDATE, FND_GLOBAL.user_id,
540: SYSDATE, FND_GLOBAL.conc_login_id,
541: d.category_id , old_organization_id ,

Line 556: -- Delete item from ibe_ct_imedia_search;

552: and d.organization_id = a.organization_id;
553:
554: END IF;
555: ELSE
556: -- Delete item from ibe_ct_imedia_search;
557: ----dbms_output.put_line('deleting from ibe_ct_imedia_search');
558: Delete from ibe_ct_imedia_search
559: where INVENTORY_ITEM_ID = old_inventory_item_id
560: and ORGANIZATION_ID = old_organization_id;

Line 557: ----dbms_output.put_line('deleting from ibe_ct_imedia_search');

553:
554: END IF;
555: ELSE
556: -- Delete item from ibe_ct_imedia_search;
557: ----dbms_output.put_line('deleting from ibe_ct_imedia_search');
558: Delete from ibe_ct_imedia_search
559: where INVENTORY_ITEM_ID = old_inventory_item_id
560: and ORGANIZATION_ID = old_organization_id;
561: END If;

Line 558: Delete from ibe_ct_imedia_search

554: END IF;
555: ELSE
556: -- Delete item from ibe_ct_imedia_search;
557: ----dbms_output.put_line('deleting from ibe_ct_imedia_search');
558: Delete from ibe_ct_imedia_search
559: where INVENTORY_ITEM_ID = old_inventory_item_id
560: and ORGANIZATION_ID = old_organization_id;
561: END If;
562: END IF;

Line 577: delete from ibe_ct_imedia_search c

573: old_language varchar2)
574: is
575: begin
576:
577: delete from ibe_ct_imedia_search c
578: where c.INVENTORY_ITEM_ID = old_inventory_item_id
579: and c.LANGUAGE = old_language
580: and c.ORGANIZATION_ID = old_organization_id ;
581:

Line 604: update IBE_CT_IMEDIA_SEARCH g

600: )
601: is
602: begin
603:
604: update IBE_CT_IMEDIA_SEARCH g
605: set
606: g.language = new_language ,
607: g.LAST_UPDATE_DATE = sysdate ,
608: g.DESCRIPTION = new_description ,

Line 710: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

706: ----dbms_output.put_line('l_search_web_status='||l_search_web_status);
707:
708: IF l_search_web_status = 'PUBLISHED' THEN
709: ----dbms_output.put_line('inserting row , web status PUBLISHED');
710: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
711: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
712: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
713: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
714: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 717: ibe_ct_imedia_search_s1.nextval,

713: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
714: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
715: , CATEGORY_SET_ID, WEB_STATUS)
716: SELECT
717: ibe_ct_imedia_search_s1.nextval,
718: 0, FND_GLOBAL.user_id,
719: SYSDATE, FND_GLOBAL.user_id,
720: SYSDATE, FND_GLOBAL.conc_login_id,
721: c.category_id , new_organization_id ,

Line 737: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

733: and b.web_status = 'PUBLISHED';
734:
735: ELSIF l_search_web_status = 'PUBLISHED_UNPUBLISHED' THEN
736: ----dbms_output.put_line('inserting row , web status PUBLISHED UNPUBLISHED');
737: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
738: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
739: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
740: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
741: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 744: ibe_ct_imedia_search_s1.nextval,

740: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
741: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
742: , CATEGORY_SET_ID, WEB_STATUS)
743: SELECT
744: ibe_ct_imedia_search_s1.nextval,
745: 0, FND_GLOBAL.user_id,
746: SYSDATE, FND_GLOBAL.user_id,
747: SYSDATE, FND_GLOBAL.conc_login_id,
748: c.category_id , new_organization_id ,

Line 763: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID

759: and a.ORGANIZATION_ID = c.organization_id
760: and b.web_status IN ('PUBLISHED', 'UNPUBLISHED');
761: ELSE
762: ----dbms_output.put_line('inserting row , web status ALL');
763: insert into ibe_ct_imedia_search (IBE_CT_IMEDIA_SEARCH_ID
764: , OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE
765: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
766: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
767: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH

Line 770: ibe_ct_imedia_search_s1.nextval,

766: , CATEGORY_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID
767: , LANGUAGE, DESCRIPTION, LONG_DESCRIPTION, INDEXED_SEARCH
768: , CATEGORY_SET_ID, WEB_STATUS)
769: SELECT
770: ibe_ct_imedia_search_s1.nextval,
771: 0, FND_GLOBAL.user_id,
772: SYSDATE, FND_GLOBAL.user_id,
773: SYSDATE, FND_GLOBAL.conc_login_id,
774: c.category_id , new_organization_id ,