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.AK_OBJECTS_PKG dependencies on AK_OBJECTS

Line 1: package body AK_OBJECTS_PKG as

1: package body AK_OBJECTS_PKG as
2: /* $Header: AKDOBJTB.pls 120.3 2006/01/25 15:58:21 tshort ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_DATABASE_OBJECT_NAME in VARCHAR2,

Line 36: cursor C is select ROWID from AK_OBJECTS

32: X_ATTRIBUTE13 in VARCHAR2,
33: X_ATTRIBUTE14 in VARCHAR2,
34: X_ATTRIBUTE15 in VARCHAR2
35: ) is
36: cursor C is select ROWID from AK_OBJECTS
37: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME;
38: begin
39: insert into AK_OBJECTS (
40: DATABASE_OBJECT_NAME,

Line 39: insert into AK_OBJECTS (

35: ) is
36: cursor C is select ROWID from AK_OBJECTS
37: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME;
38: begin
39: insert into AK_OBJECTS (
40: DATABASE_OBJECT_NAME,
41: APPLICATION_ID,
42: PRIMARY_KEY_NAME,
43: DEFAULTING_API_PKG,

Line 107: insert into AK_OBJECTS_TL (

103: raise no_data_found;
104: end if;
105: close c;
106:
107: insert into AK_OBJECTS_TL (
108: DATABASE_OBJECT_NAME,
109: LANGUAGE,
110: NAME,
111: DESCRIPTION,

Line 133: from AK_OBJECTS_TL T

129: from FND_LANGUAGES L
130: where L.INSTALLED_FLAG in ('I', 'B')
131: and not exists
132: (select NULL
133: from AK_OBJECTS_TL T
134: where T.DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
135: and T.LANGUAGE = L.LANGUAGE_CODE);
136: end INSERT_ROW;
137:

Line 188: from AK_OBJECTS

184: DEFAULTING_API_PKG,
185: DEFAULTING_API_PROC,
186: VALIDATION_API_PKG,
187: VALIDATION_API_PROC
188: from AK_OBJECTS
189: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
190: for update of DATABASE_OBJECT_NAME nowait;
191: recinfo c%rowtype;
192:

Line 196: from AK_OBJECTS_TL

192:
193: cursor c1 is select
194: NAME,
195: DESCRIPTION
196: from AK_OBJECTS_TL
197: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
198: and LANGUAGE = userenv('LANG')
199: for update of DATABASE_OBJECT_NAME nowait;
200: tlinfo c1%rowtype;

Line 334: update AK_OBJECTS set

330: X_ATTRIBUTE14 in VARCHAR2,
331: X_ATTRIBUTE15 in VARCHAR2
332: ) is
333: begin
334: update AK_OBJECTS set
335: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
336: ATTRIBUTE1 = X_ATTRIBUTE1,
337: ATTRIBUTE2 = X_ATTRIBUTE2,
338: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 366: update AK_OBJECTS_TL set

362: if (sql%notfound) then
363: raise no_data_found;
364: end if;
365:
366: update AK_OBJECTS_TL set
367: NAME = X_NAME,
368: DESCRIPTION = X_DESCRIPTION,
369: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
370: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 385: delete from AK_OBJECTS

381: procedure DELETE_ROW (
382: X_DATABASE_OBJECT_NAME in VARCHAR2
383: ) is
384: begin
385: delete from AK_OBJECTS
386: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME;
387:
388: if (sql%notfound) then
389: raise no_data_found;

Line 392: delete from AK_OBJECTS_TL

388: if (sql%notfound) then
389: raise no_data_found;
390: end if;
391:
392: delete from AK_OBJECTS_TL
393: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME;
394: if (sql%notfound) then
395: raise no_data_found;
396: end if;

Line 408: delete from AK_OBJECTS_TL T

404: /* The following delete and update statements are commented out */
405: /* as a quick workaround to fix the time-consuming table handler issue */
406: /* Eventually we'll need to turn them into a separate fix_language procedure */
407: /*
408: delete from AK_OBJECTS_TL T
409: where not exists
410: (select NULL
411: from AK_OBJECTS B
412: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME

Line 411: from AK_OBJECTS B

407: /*
408: delete from AK_OBJECTS_TL T
409: where not exists
410: (select NULL
411: from AK_OBJECTS B
412: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
413: );
414:
415: update AK_OBJECTS_TL T set (

Line 415: update AK_OBJECTS_TL T set (

411: from AK_OBJECTS B
412: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
413: );
414:
415: update AK_OBJECTS_TL T set (
416: NAME,
417: DESCRIPTION
418: ) = (select
419: B.NAME,

Line 421: from AK_OBJECTS_TL B

417: DESCRIPTION
418: ) = (select
419: B.NAME,
420: B.DESCRIPTION
421: from AK_OBJECTS_TL B
422: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
423: and B.LANGUAGE = T.SOURCE_LANG)
424: where (
425: T.DATABASE_OBJECT_NAME,

Line 430: from AK_OBJECTS_TL SUBB, AK_OBJECTS_TL SUBT

426: T.LANGUAGE
427: ) in (select
428: SUBT.DATABASE_OBJECT_NAME,
429: SUBT.LANGUAGE
430: from AK_OBJECTS_TL SUBB, AK_OBJECTS_TL SUBT
431: where SUBB.DATABASE_OBJECT_NAME = SUBT.DATABASE_OBJECT_NAME
432: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
433: and (SUBB.NAME <> SUBT.NAME
434: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 442: insert /+ append parallel(tt) / into AK_OBJECTS_TL tt (

438: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
439: ));
440: */
441:
442: insert /*+ append parallel(tt) */ into AK_OBJECTS_TL tt (
443: DATABASE_OBJECT_NAME,
444: NAME,
445: DESCRIPTION,
446: CREATED_BY,

Line 465: from AK_OBJECTS_TL B, FND_LANGUAGES L

461: B.LAST_UPDATE_DATE,
462: B.LAST_UPDATE_LOGIN,
463: L.LANGUAGE_CODE,
464: B.SOURCE_LANG
465: from AK_OBJECTS_TL B, FND_LANGUAGES L
466: where L.INSTALLED_FLAG in ('I', 'B')
467: and B.LANGUAGE = userenv('LANG')
468: ) v, AK_OBJECTS_TL T
469: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME

Line 468: ) v, AK_OBJECTS_TL T

464: B.SOURCE_LANG
465: from AK_OBJECTS_TL B, FND_LANGUAGES L
466: where L.INSTALLED_FLAG in ('I', 'B')
467: and B.LANGUAGE = userenv('LANG')
468: ) v, AK_OBJECTS_TL T
469: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME
470: and T.LANGUAGE(+) = v.LANGUAGE_CODE
471: and T.DATABASE_OBJECT_NAME is NULL;
472:

Line 475: end AK_OBJECTS_PKG;

471: and T.DATABASE_OBJECT_NAME is NULL;
472:
473: end ADD_LANGUAGE;
474:
475: end AK_OBJECTS_PKG;