APPS.EDR_IDX_XML_ELEMENT_PKG dependencies on EDR_IDX_XML_ELEMENT_B

Line 20: cursor C is select ROWID from EDR_IDX_XML_ELEMENT_B

16: X_LAST_UPDATE_LOGIN in NUMBER,
17: X_DISPLAY_NAME in VARCHAR2,
18: X_DESCRIPTION in VARCHAR2
19: ) is
20: cursor C is select ROWID from EDR_IDX_XML_ELEMENT_B
21: where ELEMENT_ID = X_ELEMENT_ID
22: ;
23: begin
24: --Bug 3783242 : Start

Line 28: insert into EDR_IDX_XML_ELEMENT_B (

24: --Bug 3783242 : Start
25: --comment the original insert statements
26: --and calling the new insert_row proc instead
27: /*
28: insert into EDR_IDX_XML_ELEMENT_B (
29: ELEMENT_ID,
30: XML_ELEMENT,
31: DTD_ROOT_ELEMENT,
32: APPLICATION_ID,

Line 148: insert into EDR_IDX_XML_ELEMENT_B (

144: end if;
145: --If a record was found, then the existing section name gets reused.
146: close C1;
147:
148: insert into EDR_IDX_XML_ELEMENT_B (
149: ELEMENT_ID,
150: XML_ELEMENT,
151: DTD_ROOT_ELEMENT,
152: APPLICATION_ID,

Line 226: from EDR_IDX_XML_ELEMENT_B

222: APPLICATION_ID,
223: INDEX_SECTION_NAME,
224: INDEX_TAG,
225: STATUS
226: from EDR_IDX_XML_ELEMENT_B
227: where ELEMENT_ID = X_ELEMENT_ID
228: for update of ELEMENT_ID nowait;
229: recinfo c%rowtype;
230:

Line 293: update EDR_IDX_XML_ELEMENT_B set

289: X_DISPLAY_NAME in VARCHAR2,
290: X_DESCRIPTION in VARCHAR2
291: ) is
292: begin
293: update EDR_IDX_XML_ELEMENT_B set
294: XML_ELEMENT = X_XML_ELEMENT,
295: DTD_ROOT_ELEMENT = X_DTD_ROOT_ELEMENT,
296: APPLICATION_ID = X_APPLICATION_ID,
297: INDEX_SECTION_NAME = X_INDEX_SECTION_NAME,

Line 367: delete from EDR_IDX_XML_ELEMENT_B

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: delete from EDR_IDX_XML_ELEMENT_B
368: where ELEMENT_ID = X_ELEMENT_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 381: from EDR_IDX_XML_ELEMENT_B B

377: begin
378: delete from EDR_IDX_XML_ELEMENT_TL T
379: where not exists
380: (select NULL
381: from EDR_IDX_XML_ELEMENT_B B
382: where B.ELEMENT_ID = T.ELEMENT_ID
383: );
384:
385: update EDR_IDX_XML_ELEMENT_TL T set (