APPS.IBE_SEARCHUPDATE_PVT dependencies on IBE_SECTION_SEARCH_PART

Line 222: || 'IBE_SECTION_SEARCH_PART drop storage';

218: l_status_AppInfo ,
219: l_industry_AppInfo ,
220: l_oracle_schema_AppInfo )) then
221: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema_AppInfo || '.'
222: || 'IBE_SECTION_SEARCH_PART drop storage';
223: else
224: -- This happens only when application schema checking call
225: -- is wrong. It usually should not happen.
226: execute immediate 'truncate table IBE_SECTION_SEARCH_PART';

Line 226: execute immediate 'truncate table IBE_SECTION_SEARCH_PART';

222: || 'IBE_SECTION_SEARCH_PART drop storage';
223: else
224: -- This happens only when application schema checking call
225: -- is wrong. It usually should not happen.
226: execute immediate 'truncate table IBE_SECTION_SEARCH_PART';
227: end if ;
228:
229: for v_CompoundData in compCur loop --{
230: open allTopLevelSections(v_CompoundData.MSITE_ID,v_CompoundData.MSITE_ROOT_SECTION_ID);

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting into IBE_SECTION_SEARCH_PART' );

229: for v_CompoundData in compCur loop --{
230: open allTopLevelSections(v_CompoundData.MSITE_ID,v_CompoundData.MSITE_ROOT_SECTION_ID);
231: fetch allTopLevelSections bulk collect into l_toplevel_section_tbl;
232: close allTopLevelSections;
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting into IBE_SECTION_SEARCH_PART' );
234:
235: forall l_count2 in 1..l_toplevel_section_tbl.count
236: -- removed on 08/28/01 the minus for parent sections , this is because
237: -- anyway the parent sections cannot have items , look at bug 1917056

Line 241: insert into IBE_SECTION_SEARCH_PART

237: -- anyway the parent sections cannot have items , look at bug 1917056
238: -- also changed the 2nd minus to juts remove unpublished sections
239: -- compared to before where it was removing unpublished sections
240: -- for each given minisite by joining minisite_section table
241: insert into IBE_SECTION_SEARCH_PART
242: (inventory_item_id
243: , organization_id
244: , section_id
245: , minisite_id

Line 324: delete from ibe_section_search_part

320: l_index := 1;
321: FOR i IN 1..x_msite_ids.COUNT LOOP
322: FOR r2 IN c2(l_master_msite_id, x_msite_ids(i).msite_id,
323: x_msite_ids(i).msite_root_section_id) LOOP
324: delete from ibe_section_search_part
325: where inventory_item_id = r2.inventory_item_id
326: and minisite_id = x_msite_ids(i).msite_id;
327: END LOOP; -- end loop r2
328: END LOOP; -- end loop i

Line 336: || 'IBE_SECTION_SEARCH_PART exchange partition PART1 with table '

332: l_status_AppInfo ,
333: l_industry_AppInfo ,
334: l_oracle_schema_AppInfo )) then
335: EXECUTE IMMEDIATE 'ALTER TABLE ' || l_oracle_schema_AppInfo || '.'
336: || 'IBE_SECTION_SEARCH_PART exchange partition PART1 with table '
337: || l_oracle_schema_AppInfo || '.' || 'IBE_SECTION_SEARCH'
338: ||' including indexes without validation';
339: else
340: -- This happens only when application schema checking call

Line 344: 'alter table IBE_SECTION_SEARCH_PART exchange partition PART1 with table IBE_SECTION_SEARCH ' ||

340: -- This happens only when application schema checking call
341: -- is wrong. It usually should not happen.
342:
343: execute immediate
344: 'alter table IBE_SECTION_SEARCH_PART exchange partition PART1 with table IBE_SECTION_SEARCH ' ||
345: 'including indexes without validation' ;
346: end if;
347:
348: