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_SEARCHUPDATE_PVT dependencies on IBE_CT_IMEDIA_SEARCH

Line 12: -- | update script for updating search clob (ibe_ct_imedia_search

Line 68: TYPE t_id IS TABLE OF ibe_ct_imedia_search.IBE_CT_IMEDIA_SEARCH_ID%TYPE

64: l_root_section_id number;
65: l_sequence number;
66:
67:
68: TYPE t_id IS TABLE OF ibe_ct_imedia_search.IBE_CT_IMEDIA_SEARCH_ID%TYPE
69: INDEX BY BINARY_INTEGER;
70: TYPE t_version_number IS TABLE OF
71: ibe_ct_imedia_search.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE

Line 71: ibe_ct_imedia_search.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

67:
68: TYPE t_id IS TABLE OF ibe_ct_imedia_search.IBE_CT_IMEDIA_SEARCH_ID%TYPE
69: INDEX BY BINARY_INTEGER;
70: TYPE t_version_number IS TABLE OF
71: ibe_ct_imedia_search.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_creation_date IS TABLE OF ibe_ct_imedia_search.CREATION_DATE%TYPE
75: INDEX BY BINARY_INTEGER;

Line 72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE

68: TYPE t_id IS TABLE OF ibe_ct_imedia_search.IBE_CT_IMEDIA_SEARCH_ID%TYPE
69: INDEX BY BINARY_INTEGER;
70: TYPE t_version_number IS TABLE OF
71: ibe_ct_imedia_search.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_creation_date IS TABLE OF ibe_ct_imedia_search.CREATION_DATE%TYPE
75: INDEX BY BINARY_INTEGER;
76: TYPE t_last_updated_by IS TABLE OF ibe_ct_imedia_search.LAST_UPDATED_BY%TYPE

Line 74: TYPE t_creation_date IS TABLE OF ibe_ct_imedia_search.CREATION_DATE%TYPE

70: TYPE t_version_number IS TABLE OF
71: ibe_ct_imedia_search.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_creation_date IS TABLE OF ibe_ct_imedia_search.CREATION_DATE%TYPE
75: INDEX BY BINARY_INTEGER;
76: TYPE t_last_updated_by IS TABLE OF ibe_ct_imedia_search.LAST_UPDATED_BY%TYPE
77: INDEX BY BINARY_INTEGER;
78: TYPE t_last_updated_date IS TABLE OF

Line 76: TYPE t_last_updated_by IS TABLE OF ibe_ct_imedia_search.LAST_UPDATED_BY%TYPE

72: TYPE t_created_by IS TABLE OF ibe_ct_imedia_search.CREATED_BY%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_creation_date IS TABLE OF ibe_ct_imedia_search.CREATION_DATE%TYPE
75: INDEX BY BINARY_INTEGER;
76: TYPE t_last_updated_by IS TABLE OF ibe_ct_imedia_search.LAST_UPDATED_BY%TYPE
77: INDEX BY BINARY_INTEGER;
78: TYPE t_last_updated_date IS TABLE OF
79: ibe_ct_imedia_search.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
80: TYPE t_last_update_login IS TABLE OF

Line 79: ibe_ct_imedia_search.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

75: INDEX BY BINARY_INTEGER;
76: TYPE t_last_updated_by IS TABLE OF ibe_ct_imedia_search.LAST_UPDATED_BY%TYPE
77: INDEX BY BINARY_INTEGER;
78: TYPE t_last_updated_date IS TABLE OF
79: ibe_ct_imedia_search.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
80: TYPE t_last_update_login IS TABLE OF
81: ibe_ct_imedia_search.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
82: TYPE t_category_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_ID%TYPE
83: INDEX BY BINARY_INTEGER;

Line 81: ibe_ct_imedia_search.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

77: INDEX BY BINARY_INTEGER;
78: TYPE t_last_updated_date IS TABLE OF
79: ibe_ct_imedia_search.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
80: TYPE t_last_update_login IS TABLE OF
81: ibe_ct_imedia_search.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
82: TYPE t_category_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_ID%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE
85: INDEX BY BINARY_INTEGER;

Line 82: TYPE t_category_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_ID%TYPE

78: TYPE t_last_updated_date IS TABLE OF
79: ibe_ct_imedia_search.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
80: TYPE t_last_update_login IS TABLE OF
81: ibe_ct_imedia_search.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
82: TYPE t_category_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_ID%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_inventory_item_id IS TABLE OF

Line 84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE

80: TYPE t_last_update_login IS TABLE OF
81: ibe_ct_imedia_search.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
82: TYPE t_category_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_ID%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_inventory_item_id IS TABLE OF
87: ibe_ct_imedia_search.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88: TYPE t_language IS TABLE OF ibe_ct_imedia_search.LANGUAGE%TYPE

Line 87: ibe_ct_imedia_search.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

83: INDEX BY BINARY_INTEGER;
84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_inventory_item_id IS TABLE OF
87: ibe_ct_imedia_search.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88: TYPE t_language IS TABLE OF ibe_ct_imedia_search.LANGUAGE%TYPE
89: INDEX BY BINARY_INTEGER;
90: TYPE t_description IS TABLE OF ibe_ct_imedia_search.DESCRIPTION%TYPE
91: INDEX BY BINARY_INTEGER;

Line 88: TYPE t_language IS TABLE OF ibe_ct_imedia_search.LANGUAGE%TYPE

84: TYPE t_organization_id IS TABLE OF ibe_ct_imedia_search.ORGANIZATION_ID%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_inventory_item_id IS TABLE OF
87: ibe_ct_imedia_search.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88: TYPE t_language IS TABLE OF ibe_ct_imedia_search.LANGUAGE%TYPE
89: INDEX BY BINARY_INTEGER;
90: TYPE t_description IS TABLE OF ibe_ct_imedia_search.DESCRIPTION%TYPE
91: INDEX BY BINARY_INTEGER;
92: TYPE t_long_description IS TABLE OF

Line 90: TYPE t_description IS TABLE OF ibe_ct_imedia_search.DESCRIPTION%TYPE

86: TYPE t_inventory_item_id IS TABLE OF
87: ibe_ct_imedia_search.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
88: TYPE t_language IS TABLE OF ibe_ct_imedia_search.LANGUAGE%TYPE
89: INDEX BY BINARY_INTEGER;
90: TYPE t_description IS TABLE OF ibe_ct_imedia_search.DESCRIPTION%TYPE
91: INDEX BY BINARY_INTEGER;
92: TYPE t_long_description IS TABLE OF
93: ibe_ct_imedia_search.LONG_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
94: TYPE t_concatenated_segments IS TABLE OF

Line 93: ibe_ct_imedia_search.LONG_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

89: INDEX BY BINARY_INTEGER;
90: TYPE t_description IS TABLE OF ibe_ct_imedia_search.DESCRIPTION%TYPE
91: INDEX BY BINARY_INTEGER;
92: TYPE t_long_description IS TABLE OF
93: ibe_ct_imedia_search.LONG_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
94: TYPE t_concatenated_segments IS TABLE OF
95: mtl_system_items_b_kfv.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE
97: INDEX BY BINARY_INTEGER;

Line 96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE

92: TYPE t_long_description IS TABLE OF
93: ibe_ct_imedia_search.LONG_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
94: TYPE t_concatenated_segments IS TABLE OF
95: mtl_system_items_b_kfv.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_web_status IS TABLE OF ibe_ct_imedia_search.WEB_STATUS%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE t_section_id IS TABLE of ibe_dsp_sections_b.section_id%TYPE

Line 98: TYPE t_web_status IS TABLE OF ibe_ct_imedia_search.WEB_STATUS%TYPE

94: TYPE t_concatenated_segments IS TABLE OF
95: mtl_system_items_b_kfv.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_web_status IS TABLE OF ibe_ct_imedia_search.WEB_STATUS%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE t_section_id IS TABLE of ibe_dsp_sections_b.section_id%TYPE
101: INDEX BY BINARY_INTEGER;
102:

Line 369: --ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');

365: using 'ibe_sct_search_mv' ;
366: */
367: -- removing for now as it is very expenisve and time consuming to do
368: -- and unnecessary if you just add a new section etc
369: --ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');
370:
371: -- ========= ab start =============================================
372:
373: --Original Section Refresh logic in the program, including populating ibe_section_search table and refresh materialized view ibe_sct_search_mv;

Line 385: INSERT INTO ibe_ct_imedia_search

381: --Get search category set profile setting IBE_SEARCH_CATEGORY_SET;
382: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
383: ----dbms_output.put_line('search category set value='||l_search_category_set);
384: If (l_search_category_set is not null) Then
385: INSERT INTO ibe_ct_imedia_search
386: (IBE_CT_IMEDIA_SEARCH_ID,
387: INVENTORY_ITEM_ID,
388: OBJECT_VERSION_NUMBER,
389: CREATED_BY,

Line 386: (IBE_CT_IMEDIA_SEARCH_ID,

382: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
383: ----dbms_output.put_line('search category set value='||l_search_category_set);
384: If (l_search_category_set is not null) Then
385: INSERT INTO ibe_ct_imedia_search
386: (IBE_CT_IMEDIA_SEARCH_ID,
387: INVENTORY_ITEM_ID,
388: OBJECT_VERSION_NUMBER,
389: CREATED_BY,
390: CREATION_DATE,

Line 402: select ibe_ct_imedia_search_s1.nextval,

398: LONG_DESCRIPTION,
399: CATEGORY_SET_ID,
400: WEB_STATUS,
401: INDEXED_SEARCH)
402: select ibe_ct_imedia_search_s1.nextval,
403: t.INVENTORY_ITEM_ID,t.OBJECT_VERSION_NUMBER,t.CREATED_BY,t.CREATION_DATE,t.LAST_UPDATED_BY,
404: t.LAST_UPDATE_DATE,t.LAST_UPDATE_LOGIN,t.CATEGORY_ID,t.ORGANIZATION_ID,t.LANGUAGE,
405: t.DESCRIPTION,t.LONG_DESCRIPTION,t.CATEGORY_SET_ID,t.WEB_STATUS,
406: ibe_search_setup_pvt.WriteToLob(t.DESCRIPTION, t.LONG_DESCRIPTION, t.concatenated_segments)

Line 423: from IBE_CT_IMEDIA_SEARCH r

419: and a.web_status = 'PUBLISHED'
420: and a.INVENTORY_ITEM_ID = c.INVENTORY_ITEM_ID
421: and a.organization_id = c.organization_id
422: and not exists ( select r.INVENTORY_ITEM_ID ,r.ORGANIZATION_ID
423: from IBE_CT_IMEDIA_SEARCH r
424: where r.INVENTORY_ITEM_ID = b.INVENTORY_ITEM_ID
425: and r.ORGANIZATION_ID = b.ORGANIZATION_ID)
426: )t ;
427:

Line 437: --Check IBE_CT_IMEDIA_SEARCH_IM Index;

433: l_sequence:=l_sequence+1;
434: l_tmp:=l_tmp+1;
435:
436:
437: --Check IBE_CT_IMEDIA_SEARCH_IM Index;
438: select count(*)
439: into l_index_exists
440: from user_indexes
441: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';

Line 441: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';

437: --Check IBE_CT_IMEDIA_SEARCH_IM Index;
438: select count(*)
439: into l_index_exists
440: from user_indexes
441: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
442:
443: if(l_index_exists > 0 ) then
444: ----dbms_output.put_line('Before synchronizing the index');
445: --Synchronize the IBE_CT_IMEDIA_SEARCH_IM index by calling inter media synchronize procedure;

Line 445: --Synchronize the IBE_CT_IMEDIA_SEARCH_IM index by calling inter media synchronize procedure;

441: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
442:
443: if(l_index_exists > 0 ) then
444: ----dbms_output.put_line('Before synchronizing the index');
445: --Synchronize the IBE_CT_IMEDIA_SEARCH_IM index by calling inter media synchronize procedure;
446: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sync the intermedia index' );
447:
448: ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');
449:

Line 448: ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');

444: ----dbms_output.put_line('Before synchronizing the index');
445: --Synchronize the IBE_CT_IMEDIA_SEARCH_IM index by calling inter media synchronize procedure;
446: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sync the intermedia index' );
447:
448: ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');
449:
450: End if;
451: End if;
452: End if;