APPS.EDR_FILES_PKG dependencies on EDR_FILES_B

Line 38: cursor C is select ROWID from EDR_FILES_B

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER)
37: is
38: cursor C is select ROWID from EDR_FILES_B
39: where FILE_ID = X_FILE_ID
40: ;
41: begin
42: insert into EDR_FILES_B (

Line 42: insert into EDR_FILES_B (

38: cursor C is select ROWID from EDR_FILES_B
39: where FILE_ID = X_FILE_ID
40: ;
41: begin
42: insert into EDR_FILES_B (
43: FILE_ID,
44: FILE_NAME,
45: ORIGINAL_FILE_NAME,
46: VERSION_LABEL,

Line 202: from EDR_FILES_B

198: ATTRIBUTE12,
199: ATTRIBUTE13,
200: ATTRIBUTE14,
201: ATTRIBUTE15
202: from EDR_FILES_B
203: where FILE_ID = X_FILE_ID
204: for update of FILE_ID nowait;
205: recinfo c%rowtype;
206: cursor c1 is select

Line 321: update EDR_FILES_B set

317: X_LAST_UPDATED_BY in NUMBER,
318: X_LAST_UPDATE_LOGIN in NUMBER
319: ) is
320: begin
321: update EDR_FILES_B set
322: FILE_NAME = X_FILE_NAME,
323: ORIGINAL_FILE_NAME = X_ORIGINAL_FILE_NAME,
324: VERSION_LABEL = X_VERSION_LABEL,
325: CATEGORY_ID = X_CATEGORY_ID,

Line 374: delete from EDR_FILES_B

370: where FILE_ID = X_FILE_ID;
371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374: delete from EDR_FILES_B
375: where FILE_ID = X_FILE_ID;
376: if (sql%notfound) then
377: raise no_data_found;
378: end if;

Line 387: from EDR_FILES_B B

383: begin
384: delete from EDR_FILES_TL T
385: where not exists
386: (select NULL
387: from EDR_FILES_B B
388: where B.FILE_ID = T.FILE_ID
389: );
390: update EDR_FILES_TL T set (
391: DESCRIPTION