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.ICX_POR_CTX_DESC dependencies on ICX_POR_INTERMEDIA_INDEX

Line 100: ICX_POR_INTERMEDIA_INDEX.rebuild_index;

96: --Debugging
97: icx_por_ext_utl.debug('start to rebuild index');
98: xErrLoc := 940;
99: -- rebuild the intermedia or context indexes
100: ICX_POR_INTERMEDIA_INDEX.rebuild_index;
101: xErrLoc := 1000;
102: --Debugging
103: icx_por_ext_utl.debug('rebuild index done');
104: END IF;

Line 142: ICX_POR_INTERMEDIA_INDEX.drop_index;

138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;
143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');
144:
145: populateBaseAttributes('N', 'N', p_log_type);
146: icx_por_ext_utl.debug('populateDescAll, populateBaseAttributes done ');

Line 154: ICX_POR_INTERMEDIA_INDEX.create_index;

150:
151: populateCategoryAttributes('N', 'N', p_log_type);
152: icx_por_ext_utl.debug('populateDescAll, populateCategoryAttributes done ');
153:
154: ICX_POR_INTERMEDIA_INDEX.create_index;
155: icx_por_ext_utl.debug('populateDescAll, create_index done ');
156:
157: -- disable the intermedia index concurrent program once it has been run successfully
158: -- we will use FND API FND_PROGRAM.ENABLE_PROGRAM for achieving the same

Line 952: --plsqlBlock := 'BEGIN icx_por_intermedia_index.rebuild_index; END;';

948: cursorID := DBMS_SQL.open_cursor;
949: xErrLoc := 120;
950: IF version >= 8.1 THEN
951: --smallya Bug: 1713602 commented out the old package call and replaced it with the new one 04/06/2001--
952: --plsqlBlock := 'BEGIN icx_por_intermedia_index.rebuild_index; END;';
953: plsqlBlock := 'BEGIN ICX_POR_INTERMEDIA_INDEX.rebuild_index; END;';
954: /*icx_por_intermedia_index.rebuild_index;*/
955: ELSE
956: plsqlBlock := 'BEGIN icx_item_context_index_create.rebuild_item_context(''N''); END;';

Line 953: plsqlBlock := 'BEGIN ICX_POR_INTERMEDIA_INDEX.rebuild_index; END;';

949: xErrLoc := 120;
950: IF version >= 8.1 THEN
951: --smallya Bug: 1713602 commented out the old package call and replaced it with the new one 04/06/2001--
952: --plsqlBlock := 'BEGIN icx_por_intermedia_index.rebuild_index; END;';
953: plsqlBlock := 'BEGIN ICX_POR_INTERMEDIA_INDEX.rebuild_index; END;';
954: /*icx_por_intermedia_index.rebuild_index;*/
955: ELSE
956: plsqlBlock := 'BEGIN icx_item_context_index_create.rebuild_item_context(''N''); END;';
957: /*icx_item_context_index_create.rebuild_item_context('N');*/

Line 954: /icx_por_intermedia_index.rebuild_index;/

950: IF version >= 8.1 THEN
951: --smallya Bug: 1713602 commented out the old package call and replaced it with the new one 04/06/2001--
952: --plsqlBlock := 'BEGIN icx_por_intermedia_index.rebuild_index; END;';
953: plsqlBlock := 'BEGIN ICX_POR_INTERMEDIA_INDEX.rebuild_index; END;';
954: /*icx_por_intermedia_index.rebuild_index;*/
955: ELSE
956: plsqlBlock := 'BEGIN icx_item_context_index_create.rebuild_item_context(''N''); END;';
957: /*icx_item_context_index_create.rebuild_item_context('N');*/
958: END IF;