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.JTFB_AK_ATTRIBUTES_PKG dependencies on AK_ATTRIBUTES

Line 1: package body jtfb_ak_attributes_pkg as

1: package body jtfb_ak_attributes_pkg as
2: /* $Header: jtfbatrb.pls 120.2 2005/10/25 05:25:41 psanyal ship $ */
3: --
4: --
5: procedure INSERT_ROW (

Line 54: cursor C is select ROWID from AK_ATTRIBUTES

50: X_LAST_UPDATE_DATE in DATE,
51: X_LAST_UPDATED_BY in NUMBER,
52: X_LAST_UPDATE_LOGIN in NUMBER
53: ) is
54: cursor C is select ROWID from AK_ATTRIBUTES
55: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
56: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
57:
58: begin

Line 59: insert into AK_ATTRIBUTES (

55: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
56: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
57:
58: begin
59: insert into AK_ATTRIBUTES (
60: ATTRIBUTE_APPLICATION_ID,
61: ATTRIBUTE_CODE,
62: ATTRIBUTE_LABEL_LENGTH,
63: ATTRIBUTE_VALUE_LENGTH,

Line 159: insert into AK_ATTRIBUTES_TL (

155: raise no_data_found;
156: end if;
157: close c;
158:
159: insert into AK_ATTRIBUTES_TL (
160: ATTRIBUTE_APPLICATION_ID,
161: ATTRIBUTE_CODE,
162: LANGUAGE,
163: NAME,

Line 191: from AK_ATTRIBUTES_TL T

187: from FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and not exists
190: (select NULL
191: from AK_ATTRIBUTES_TL T
192: where T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
193: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
194: and T.LANGUAGE = L.LANGUAGE_CODE);
195: end INSERT_ROW;

Line 279: from AK_ATTRIBUTES

275: ATTRIBUTE12,
276: ATTRIBUTE13,
277: ATTRIBUTE14,
278: ATTRIBUTE15
279: from AK_ATTRIBUTES
280: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
281: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
282: for update of ATTRIBUTE_APPLICATION_ID nowait;
283: recinfo c%rowtype;

Line 289: from AK_ATTRIBUTES_TL

285: cursor c1 is select
286: NAME,
287: ATTRIBUTE_LABEL_LONG,
288: DESCRIPTION
289: from AK_ATTRIBUTES_TL
290: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
291: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
292: and LANGUAGE = userenv('LANG')
293: for update of ATTRIBUTE_CODE nowait;

Line 483: update AK_ATTRIBUTES set

479: X_LAST_UPDATED_BY in NUMBER,
480: X_LAST_UPDATE_LOGIN in NUMBER
481: ) is
482: begin
483: update AK_ATTRIBUTES set
484: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
485: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
486: ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH,
487: ATTRIBUTE_VALUE_LENGTH = X_ATTRIBUTE_VALUE_LENGTH,

Line 533: update AK_ATTRIBUTES_TL set

529: if (sql%notfound) then
530: raise no_data_found;
531: end if;
532:
533: update AK_ATTRIBUTES_TL set
534: NAME = X_NAME,
535: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
536: DESCRIPTION = X_DESCRIPTION,
537:

Line 559: delete from AK_ATTRIBUTES

555: X_ATTRIBUTE_APPLICATION_ID in NUMBER,
556: X_ATTRIBUTE_CODE in VARCHAR2
557: ) is
558: begin
559: delete from AK_ATTRIBUTES
560: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
561: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
562: if (sql%notfound) then
563: raise no_data_found;

Line 574: delete from AK_ATTRIBUTES_TL

570: if (sql%notfound) then
571: null;
572: end if;
573:
574: delete from AK_ATTRIBUTES_TL
575: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
576: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
577: if (sql%notfound) then
578: raise no_data_found;

Line 587: delete from AK_ATTRIBUTES_TL T

583: --*****************************************************************************
584: procedure ADD_LANGUAGE
585: is
586: begin
587: delete from AK_ATTRIBUTES_TL T
588: where not exists
589: (select NULL
590: from AK_ATTRIBUTES B
591: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE

Line 590: from AK_ATTRIBUTES B

586: begin
587: delete from AK_ATTRIBUTES_TL T
588: where not exists
589: (select NULL
590: from AK_ATTRIBUTES B
591: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
592: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
593: );
594:

Line 595: update AK_ATTRIBUTES_TL T set (

591: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
592: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
593: );
594:
595: update AK_ATTRIBUTES_TL T set (
596: NAME,
597: ATTRIBUTE_LABEL_LONG,
598: ATTRIBUTE_LABEL_SHORT,
599: DESCRIPTION

Line 605: from AK_ATTRIBUTES_TL B

601: B.NAME,
602: B.ATTRIBUTE_LABEL_LONG,
603: B.ATTRIBUTE_LABEL_SHORT,
604: B.DESCRIPTION
605: from AK_ATTRIBUTES_TL B
606: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
607: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
608: and B.LANGUAGE = T.SOURCE_LANG)
609: where (

Line 617: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT

613: ) in (select
614: SUBT.ATTRIBUTE_CODE,
615: SUBT.ATTRIBUTE_APPLICATION_ID,
616: SUBT.LANGUAGE
617: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT
618: where SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
619: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
620: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
621: and (SUBB.NAME <> SUBT.NAME

Line 633: insert into AK_ATTRIBUTES_TL (

629: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
630: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
631: ));
632:
633: insert into AK_ATTRIBUTES_TL (
634: ATTRIBUTE_APPLICATION_ID,
635: ATTRIBUTE_CODE,
636: NAME,
637: ATTRIBUTE_LABEL_LONG,

Line 661: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L

657: B.LAST_UPDATE_DATE,
658: B.LAST_UPDATE_LOGIN,
659: L.LANGUAGE_CODE,
660: B.SOURCE_LANG
661: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L
662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL

Line 666: from AK_ATTRIBUTES_TL T

662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL
666: from AK_ATTRIBUTES_TL T
667: where T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
668: and T.ATTRIBUTE_APPLICATION_ID = B.ATTRIBUTE_APPLICATION_ID
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: end ADD_LANGUAGE;

Line 673: end jtfb_ak_attributes_pkg;

669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: end ADD_LANGUAGE;
671: --
672: --
673: end jtfb_ak_attributes_pkg;