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.FND_DOCUMENT_ENTITIES_PKG dependencies on FND_DOCUMENT_ENTITIES

Line 1: PACKAGE BODY fnd_document_entities_pkg AS

1: PACKAGE BODY fnd_document_entities_pkg AS
2: /* $Header: AFAKDOCB.pls 115.14 2004/02/06 20:50:21 blash ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 23: cursor C is select ROWID from FND_DOCUMENT_ENTITIES

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from FND_DOCUMENT_ENTITIES
24: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE;
25: begin
26:
27: insert into FND_DOCUMENT_ENTITIES (

Line 27: insert into FND_DOCUMENT_ENTITIES (

23: cursor C is select ROWID from FND_DOCUMENT_ENTITIES
24: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE;
25: begin
26:
27: insert into FND_DOCUMENT_ENTITIES (
28: DOCUMENT_ENTITY_ID,
29: DATA_OBJECT_CODE,
30: APPLICATION_ID,
31: TABLE_NAME,

Line 66: insert into FND_DOCUMENT_ENTITIES_TL (

62: raise no_data_found;
63: end if;
64: close c;
65:
66: insert into FND_DOCUMENT_ENTITIES_TL (
67: DOCUMENT_ENTITY_ID,
68: DATA_OBJECT_CODE,
69: LANGUAGE,
70: USER_ENTITY_NAME,

Line 94: from FND_DOCUMENT_ENTITIES_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from FND_DOCUMENT_ENTITIES_TL T
95: where T.DATA_OBJECT_CODE = X_DATA_OBJECT_CODE
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97: end INSERT_ROW;
98:

Line 120: from FND_DOCUMENT_ENTITIES

116: PK2_COLUMN,
117: PK3_COLUMN,
118: PK4_COLUMN,
119: PK5_COLUMN
120: from FND_DOCUMENT_ENTITIES
121: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE
122: for update of DOCUMENT_ENTITY_ID nowait;
123: recinfo c%rowtype;
124:

Line 128: from FND_DOCUMENT_ENTITIES_TL

124:
125: cursor c1 is select
126: USER_ENTITY_NAME,
127: USER_ENTITY_PROMPT
128: from FND_DOCUMENT_ENTITIES_TL
129: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE
130: and LANGUAGE = userenv('LANG')
131: for update of DOCUMENT_ENTITY_ID nowait;
132: tlinfo c1%rowtype;

Line 199: update FND_DOCUMENT_ENTITIES set

195: X_LAST_UPDATED_BY in NUMBER,
196: X_LAST_UPDATE_LOGIN in NUMBER
197: ) is
198: begin
199: update FND_DOCUMENT_ENTITIES set
200: DOCUMENT_ENTITY_ID = X_DOCUMENT_ENTITY_ID,
201: DATA_OBJECT_CODE = X_DATA_OBJECT_CODE,
202: APPLICATION_ID = X_APPLICATION_ID,
203: TABLE_NAME = X_TABLE_NAME,

Line 217: update FND_DOCUMENT_ENTITIES_TL set

213: if (sql%notfound) then
214: raise no_data_found;
215: end if;
216:
217: update FND_DOCUMENT_ENTITIES_TL set
218: USER_ENTITY_NAME = X_USER_ENTITY_NAME,
219: USER_ENTITY_PROMPT = X_USER_ENTITY_PROMPT,
220: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
221: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 235: delete from FND_DOCUMENT_ENTITIES

231: X_DOCUMENT_ENTITY_ID in NUMBER,
232: X_DATA_OBJECT_CODE in VARCHAR2
233: ) is
234: begin
235: delete from FND_DOCUMENT_ENTITIES
236: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE;
237:
238: if (sql%notfound) then
239: raise no_data_found;

Line 242: delete from FND_DOCUMENT_ENTITIES_TL

238: if (sql%notfound) then
239: raise no_data_found;
240: end if;
241:
242: delete from FND_DOCUMENT_ENTITIES_TL
243: where DATA_OBJECT_CODE = X_DATA_OBJECT_CODE;
244: if (sql%notfound) then
245: raise no_data_found;
246: end if;

Line 259: delete from FND_DOCUMENT_ENTITIES_TL T

255: /* as a quick workaround to fix the time-consuming table handler issue */
256: /* Eventually we'll need to turn them into a separate fix_language procedure */
257: /*
258:
259: delete from FND_DOCUMENT_ENTITIES_TL T
260: where not exists
261: (select NULL
262: from FND_DOCUMENT_ENTITIES B
263: where B.DATA_OBJECT_CODE = T.DATA_OBJECT_CODE

Line 262: from FND_DOCUMENT_ENTITIES B

258:
259: delete from FND_DOCUMENT_ENTITIES_TL T
260: where not exists
261: (select NULL
262: from FND_DOCUMENT_ENTITIES B
263: where B.DATA_OBJECT_CODE = T.DATA_OBJECT_CODE
264: );
265:
266: update FND_DOCUMENT_ENTITIES_TL T set (

Line 266: update FND_DOCUMENT_ENTITIES_TL T set (

262: from FND_DOCUMENT_ENTITIES B
263: where B.DATA_OBJECT_CODE = T.DATA_OBJECT_CODE
264: );
265:
266: update FND_DOCUMENT_ENTITIES_TL T set (
267: USER_ENTITY_NAME,
268: USER_ENTITY_PROMPT
269: ) = (select
270: B.USER_ENTITY_NAME,

Line 272: from FND_DOCUMENT_ENTITIES_TL B

268: USER_ENTITY_PROMPT
269: ) = (select
270: B.USER_ENTITY_NAME,
271: B.USER_ENTITY_PROMPT
272: from FND_DOCUMENT_ENTITIES_TL B
273: where B.DATA_OBJECT_CODE = T.DATA_OBJECT_CODE
274: and B.LANGUAGE = T.SOURCE_LANG)
275: where (
276: T.DOCUMENT_ENTITY_ID,

Line 281: from FND_DOCUMENT_ENTITIES_TL SUBB, FND_DOCUMENT_ENTITIES_TL SUBT

277: T.LANGUAGE
278: ) in (select
279: SUBT.DOCUMENT_ENTITY_ID,
280: SUBT.LANGUAGE
281: from FND_DOCUMENT_ENTITIES_TL SUBB, FND_DOCUMENT_ENTITIES_TL SUBT
282: where SUBB.DATA_OBJECT_CODE = SUBT.DATA_OBJECT_CODE
283: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
284: and (SUBB.USER_ENTITY_NAME <> SUBT.USER_ENTITY_NAME
285: or SUBB.USER_ENTITY_PROMPT <> SUBT.USER_ENTITY_PROMPT

Line 289: insert into FND_DOCUMENT_ENTITIES_TL (

285: or SUBB.USER_ENTITY_PROMPT <> SUBT.USER_ENTITY_PROMPT
286: ));
287: */
288:
289: insert into FND_DOCUMENT_ENTITIES_TL (
290: DOCUMENT_ENTITY_ID,
291: DATA_OBJECT_CODE,
292: LANGUAGE,
293: USER_ENTITY_NAME,

Line 313: from FND_DOCUMENT_ENTITIES_TL M, FND_LANGUAGES B, FND_LANGUAGES L

309: M.CREATED_BY,
310: M.LAST_UPDATE_DATE,
311: M.LAST_UPDATED_BY,
312: M.LAST_UPDATE_LOGIN
313: from FND_DOCUMENT_ENTITIES_TL M, FND_LANGUAGES B, FND_LANGUAGES L
314: where B.INSTALLED_FLAG = 'B'
315: and L.INSTALLED_FLAG in ('I', 'B')
316: and M.LANGUAGE = userenv('LANG')
317: and not exists

Line 319: from FND_DOCUMENT_ENTITIES_TL T

315: and L.INSTALLED_FLAG in ('I', 'B')
316: and M.LANGUAGE = userenv('LANG')
317: and not exists
318: (select NULL
319: from FND_DOCUMENT_ENTITIES_TL T
320: where T.DATA_OBJECT_CODE = M.DATA_OBJECT_CODE
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;
323:

Line 333: update fnd_document_entities_tl set

329: X_OWNER in varchar2) IS
330:
331: begin
332:
333: update fnd_document_entities_tl set
334: user_entity_name = nvl(X_USER_ENTITY_NAME,user_entity_name),
335: user_entity_prompt = nvl(X_USER_ENTITY_PROMPT,user_entity_prompt),
336: last_update_date = sysdate,
337: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 370: from fnd_document_entities_tl

366: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
367:
368: select LAST_UPDATED_BY, LAST_UPDATE_DATE
369: into db_luby, db_ludate
370: from fnd_document_entities_tl
371: where data_object_code = X_DATA_OBJECT_CODE
372: and LANGUAGE = userenv('LANG');
373:
374: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 376: update fnd_document_entities_tl set

372: and LANGUAGE = userenv('LANG');
373:
374: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
375: db_ludate, X_CUSTOM_MODE)) then
376: update fnd_document_entities_tl set
377: user_entity_name = nvl(X_USER_ENTITY_NAME,user_entity_name),
378: user_entity_prompt = nvl(X_USER_ENTITY_PROMPT,user_entity_prompt),
379: last_update_date = f_ludate,
380: last_updated_by = f_luby,

Line 421: -- Get document entity Id from fnd_document_entities.

417: from fnd_application
418: where application_short_name = X_APP_SHORT_NAME;
419:
420: begin
421: -- Get document entity Id from fnd_document_entities.
422: select document_entity_id, application_id
423: into l_document_entity_id, l_application_id
424: from fnd_document_entities
425: where data_object_code = X_DATA_OBJECT_CODE ;

Line 424: from fnd_document_entities

420: begin
421: -- Get document entity Id from fnd_document_entities.
422: select document_entity_id, application_id
423: into l_document_entity_id, l_application_id
424: from fnd_document_entities
425: where data_object_code = X_DATA_OBJECT_CODE ;
426:
427: UPDATE_ROW (
428: X_DOCUMENT_ENTITY_ID => l_document_entity_id,

Line 446: select fnd_document_entities_s.nextval

442:
443: exception
444: when no_data_found then
445:
446: select fnd_document_entities_s.nextval
447: into l_document_entity_id
448: from dual;
449:
450: INSERT_ROW (

Line 513: -- Get document entity Id from fnd_document_entities.

509: from fnd_application
510: where application_short_name = X_APP_SHORT_NAME;
511:
512: begin
513: -- Get document entity Id from fnd_document_entities.
514: select document_entity_id, application_id,
515: LAST_UPDATED_BY, LAST_UPDATE_DATE
516: into l_document_entity_id, l_application_id, db_luby, db_ludate
517: from fnd_document_entities

Line 517: from fnd_document_entities

513: -- Get document entity Id from fnd_document_entities.
514: select document_entity_id, application_id,
515: LAST_UPDATED_BY, LAST_UPDATE_DATE
516: into l_document_entity_id, l_application_id, db_luby, db_ludate
517: from fnd_document_entities
518: where data_object_code = X_DATA_OBJECT_CODE ;
519:
520: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
521: db_ludate, X_CUSTOM_MODE)) then

Line 542: select fnd_document_entities_s.nextval

538:
539: exception
540: when no_data_found then
541:
542: select fnd_document_entities_s.nextval
543: into l_document_entity_id
544: from dual;
545:
546: INSERT_ROW (

Line 567: end FND_DOCUMENT_ENTITIES_PKG;

563: X_LAST_UPDATE_LOGIN => 0 );
564: end;
565: end LOAD_ROW;
566:
567: end FND_DOCUMENT_ENTITIES_PKG;