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_OBJECT_ATTRIBUTES_PKG dependencies on AK_OBJECT_ATTRIBUTES

Line 1: package body AK_OBJECT_ATTRIBUTES_PKG as

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

Line 56: cursor C is select ROWID from AK_OBJECT_ATTRIBUTES

52: X_ATTRIBUTE13 in VARCHAR2,
53: X_ATTRIBUTE14 in VARCHAR2,
54: X_ATTRIBUTE15 in VARCHAR2
55: ) is
56: cursor C is select ROWID from AK_OBJECT_ATTRIBUTES
57: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
58: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
59: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
60: begin

Line 61: insert into AK_OBJECT_ATTRIBUTES (

57: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
58: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
59: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
60: begin
61: insert into AK_OBJECT_ATTRIBUTES (
62: DATABASE_OBJECT_NAME,
63: ATTRIBUTE_APPLICATION_ID,
64: ATTRIBUTE_CODE,
65: COLUMN_NAME,

Line 169: insert into AK_OBJECT_ATTRIBUTES_TL (

165: raise no_data_found;
166: end if;
167: close c;
168:
169: insert into AK_OBJECT_ATTRIBUTES_TL (
170: DATABASE_OBJECT_NAME,
171: ATTRIBUTE_APPLICATION_ID,
172: ATTRIBUTE_CODE,
173: LANGUAGE,

Line 197: from AK_OBJECT_ATTRIBUTES_TL T

193: from FND_LANGUAGES L
194: where L.INSTALLED_FLAG in ('I', 'B')
195: and not exists
196: (select NULL
197: from AK_OBJECT_ATTRIBUTES_TL T
198: where T.DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
199: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
200: and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
201: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 291: from AK_OBJECT_ATTRIBUTES

287: VALIDATION_API_PROC,
288: DEFAULT_VALUE_VARCHAR2,
289: DEFAULT_VALUE_NUMBER,
290: DEFAULT_VALUE_DATE
291: from AK_OBJECT_ATTRIBUTES
292: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
293: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
294: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
295: for update of DATABASE_OBJECT_NAME nowait;

Line 300: from AK_OBJECT_ATTRIBUTES_TL

296: recinfo c%rowtype;
297:
298: cursor c1 is select
299: ATTRIBUTE_LABEL_LONG
300: from AK_OBJECT_ATTRIBUTES_TL
301: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
302: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
303: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
304: and LANGUAGE = userenv('LANG')

Line 498: update AK_OBJECT_ATTRIBUTES set

494: X_ATTRIBUTE14 in VARCHAR2,
495: X_ATTRIBUTE15 in VARCHAR2
496: ) is
497: begin
498: update AK_OBJECT_ATTRIBUTES set
499: DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME,
500: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
501: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
502: COLUMN_NAME = X_COLUMN_NAME,

Line 551: update AK_OBJECT_ATTRIBUTES_TL set

547: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
548: if (sql%notfound) then
549: raise no_data_found;
550: end if;
551: update AK_OBJECT_ATTRIBUTES_TL set
552: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
553: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
554: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
555: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 572: delete from AK_OBJECT_ATTRIBUTES

568: X_ATTRIBUTE_APPLICATION_ID in NUMBER,
569: X_ATTRIBUTE_CODE in VARCHAR2
570: ) is
571: begin
572: delete from AK_OBJECT_ATTRIBUTES
573: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
574: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
575: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
576:

Line 581: delete from AK_OBJECT_ATTRIBUTES_TL

577: if (sql%notfound) then
578: raise no_data_found;
579: end if;
580:
581: delete from AK_OBJECT_ATTRIBUTES_TL
582: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
583: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
584: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
585: if (sql%notfound) then

Line 599: delete from AK_OBJECT_ATTRIBUTES_TL T

595: /* The following delete and update statements are commented out */
596: /* as a quick workaround to fix the time-consuming table handler issue */
597: /* Eventually we'll need to turn them into a separate fix_language procedure */
598: /*
599: delete from AK_OBJECT_ATTRIBUTES_TL T
600: where not exists
601: (select NULL
602: from AK_OBJECT_ATTRIBUTES B
603: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME

Line 602: from AK_OBJECT_ATTRIBUTES B

598: /*
599: delete from AK_OBJECT_ATTRIBUTES_TL T
600: where not exists
601: (select NULL
602: from AK_OBJECT_ATTRIBUTES B
603: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
604: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
605: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
606: );

Line 608: update AK_OBJECT_ATTRIBUTES_TL T set (

604: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
605: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
606: );
607:
608: update AK_OBJECT_ATTRIBUTES_TL T set (
609: ATTRIBUTE_LABEL_LONG,
610: ATTRIBUTE_LABEL_SHORT
611: ) = (select
612: B.ATTRIBUTE_LABEL_LONG,

Line 614: from AK_OBJECT_ATTRIBUTES_TL B

610: ATTRIBUTE_LABEL_SHORT
611: ) = (select
612: B.ATTRIBUTE_LABEL_LONG,
613: B.ATTRIBUTE_LABEL_SHORT
614: from AK_OBJECT_ATTRIBUTES_TL B
615: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
616: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
617: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
618: and B.LANGUAGE = T.SOURCE_LANG)

Line 629: from AK_OBJECT_ATTRIBUTES_TL SUBB, AK_OBJECT_ATTRIBUTES_TL SUBT

625: SUBT.DATABASE_OBJECT_NAME,
626: SUBT.ATTRIBUTE_CODE,
627: SUBT.ATTRIBUTE_APPLICATION_ID,
628: SUBT.LANGUAGE
629: from AK_OBJECT_ATTRIBUTES_TL SUBB, AK_OBJECT_ATTRIBUTES_TL SUBT
630: where SUBB.DATABASE_OBJECT_NAME = SUBT.DATABASE_OBJECT_NAME
631: and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
632: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
633: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 643: insert /+ append parallel(tt) / into AK_OBJECT_ATTRIBUTES_TL tt (

639: or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
640: ));
641: */
642:
643: insert /*+ append parallel(tt) */ into AK_OBJECT_ATTRIBUTES_TL tt (
644: DATABASE_OBJECT_NAME,
645: ATTRIBUTE_APPLICATION_ID,
646: ATTRIBUTE_CODE,
647: ATTRIBUTE_LABEL_LONG,

Line 670: from AK_OBJECT_ATTRIBUTES_TL B, FND_LANGUAGES L

666: B.LAST_UPDATE_DATE,
667: B.LAST_UPDATE_LOGIN,
668: L.LANGUAGE_CODE,
669: B.SOURCE_LANG
670: from AK_OBJECT_ATTRIBUTES_TL B, FND_LANGUAGES L
671: where L.INSTALLED_FLAG in ('I', 'B')
672: and B.LANGUAGE = userenv('LANG')
673: ) v, AK_OBJECT_ATTRIBUTES_TL T
674: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME

Line 673: ) v, AK_OBJECT_ATTRIBUTES_TL T

669: B.SOURCE_LANG
670: from AK_OBJECT_ATTRIBUTES_TL B, FND_LANGUAGES L
671: where L.INSTALLED_FLAG in ('I', 'B')
672: and B.LANGUAGE = userenv('LANG')
673: ) v, AK_OBJECT_ATTRIBUTES_TL T
674: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME
675: and T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE
676: and T.ATTRIBUTE_APPLICATION_ID(+) = v.ATTRIBUTE_APPLICATION_ID
677: and T.LANGUAGE(+) = v.LANGUAGE_CODE

Line 851: end AK_OBJECT_ATTRIBUTES_PKG;

847: end if;
848:
849: end ADD_REGION_ITEM;
850: --*****************************************************************************
851: end AK_OBJECT_ATTRIBUTES_PKG;