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_REGION_ITEMS_PKG dependencies on AK_REGION_ITEMS

Line 1: package body jtfb_ak_region_items_pkg as

1: package body jtfb_ak_region_items_pkg as
2: /* $Header: jtfbrgib.pls 120.2 2005/10/25 05:29:43 psanyal ship $ */
3: --
4: --
5: procedure INSERT_ROW (

Line 91: cursor C is select ROWID from AK_REGION_ITEMS

87: X_ATTRIBUTE13 in VARCHAR2,
88: X_ATTRIBUTE14 in VARCHAR2,
89: X_ATTRIBUTE15 in VARCHAR2
90: ) is
91: cursor C is select ROWID from AK_REGION_ITEMS
92: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
93: and REGION_CODE = X_REGION_CODE
94: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
95: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 97: L_HORIZONTAL_ALIGNMENT Ak_Region_items.horizontal_alignment%type;

93: and REGION_CODE = X_REGION_CODE
94: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
95: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
96:
97: L_HORIZONTAL_ALIGNMENT Ak_Region_items.horizontal_alignment%type;
98:
99: begin
100: L_HORIZONTAL_ALIGNMENT := X_HORIZONTAL_ALIGNMENT;
101: if(L_HORIZONTAL_ALIGNMENT is NULL)

Line 105: insert into AK_REGION_ITEMS (

101: if(L_HORIZONTAL_ALIGNMENT is NULL)
102: then L_HORIZONTAL_ALIGNMENT := 'LEFT';
103: end if;
104:
105: insert into AK_REGION_ITEMS (
106: REGION_APPLICATION_ID,
107: REGION_CODE,
108: ATTRIBUTE_APPLICATION_ID,
109: ATTRIBUTE_CODE,

Line 283: insert into AK_REGION_ITEMS_TL (

279: raise no_data_found;
280: end if;
281: close c;
282:
283: insert into AK_REGION_ITEMS_TL (
284: REGION_APPLICATION_ID,
285: REGION_CODE,
286: ATTRIBUTE_APPLICATION_ID,
287: ATTRIBUTE_CODE,

Line 317: from AK_REGION_ITEMS_TL T

313: from FND_LANGUAGES L
314: where L.INSTALLED_FLAG in ('I', 'B')
315: and not exists
316: (select NULL
317: from AK_REGION_ITEMS_TL T
318: where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
319: and T.REGION_CODE = X_REGION_CODE
320: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
321: and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 478: from AK_REGION_ITEMS

474: ENTITY_ID,
475: ANCHOR,
476: POPLIST_VIEW_USAGE_NAME,
477: SORTBY_VIEW_ATTRIBUTE_NAME
478: from AK_REGION_ITEMS
479: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
480: and REGION_CODE = X_REGION_CODE
481: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
482: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 489: from AK_REGION_ITEMS_TL

485:
486: cursor c1 is select
487: ATTRIBUTE_LABEL_LONG,
488: DESCRIPTION
489: from AK_REGION_ITEMS_TL
490: where REGION_CODE = X_REGION_CODE
491: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
492: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
493: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID

Line 810: L_HORIZONTAL_ALIGNMENT Ak_Region_items.horizontal_alignment%type;

806: X_ATTRIBUTE14 in VARCHAR2,
807: X_ATTRIBUTE15 in VARCHAR2
808: ) is
809:
810: L_HORIZONTAL_ALIGNMENT Ak_Region_items.horizontal_alignment%type;
811:
812: begin
813: L_HORIZONTAL_ALIGNMENT := X_HORIZONTAL_ALIGNMENT;
814: if(L_HORIZONTAL_ALIGNMENT is NULL)

Line 818: update AK_REGION_ITEMS set

814: if(L_HORIZONTAL_ALIGNMENT is NULL)
815: then L_HORIZONTAL_ALIGNMENT := 'LEFT';
816: end if;
817:
818: update AK_REGION_ITEMS set
819: REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
820: REGION_CODE = X_REGION_CODE,
821: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
822: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,

Line 909: update AK_REGION_ITEMS_TL set

905: if (sql%notfound) then
906: raise no_data_found;
907: end if;
908:
909: update AK_REGION_ITEMS_TL set
910: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
911: DESCRIPTION = X_DESCRIPTION,
912:
913: LAST_UPDATE_DATE = sysdate,

Line 935: delete from AK_REGION_ITEMS

931: X_ATTRIBUTE_APPLICATION_ID in NUMBER,
932: X_ATTRIBUTE_CODE in VARCHAR2
933: ) is
934: begin
935: delete from AK_REGION_ITEMS
936: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
937: and REGION_CODE = X_REGION_CODE
938: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
939: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 945: delete from AK_REGION_ITEMS_TL

941: if (sql%notfound) then
942: raise no_data_found;
943: end if;
944:
945: delete from AK_REGION_ITEMS_TL
946: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
947: and REGION_CODE = X_REGION_CODE
948: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
949: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 958: delete from AK_REGION_ITEMS_TL T

954:
955: procedure ADD_LANGUAGE
956: is
957: begin
958: delete from AK_REGION_ITEMS_TL T
959: where not exists
960: (select NULL
961: from AK_REGION_ITEMS B
962: where B.REGION_CODE = T.REGION_CODE

Line 961: from AK_REGION_ITEMS B

957: begin
958: delete from AK_REGION_ITEMS_TL T
959: where not exists
960: (select NULL
961: from AK_REGION_ITEMS B
962: where B.REGION_CODE = T.REGION_CODE
963: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
964: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
965: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID

Line 968: update AK_REGION_ITEMS_TL T set (

964: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
965: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
966: );
967:
968: update AK_REGION_ITEMS_TL T set (
969: ATTRIBUTE_LABEL_LONG,
970: ATTRIBUTE_LABEL_SHORT
971: ) = (select
972: B.ATTRIBUTE_LABEL_LONG,

Line 974: from AK_REGION_ITEMS_TL B

970: ATTRIBUTE_LABEL_SHORT
971: ) = (select
972: B.ATTRIBUTE_LABEL_LONG,
973: B.ATTRIBUTE_LABEL_SHORT
974: from AK_REGION_ITEMS_TL B
975: where B.REGION_CODE = T.REGION_CODE
976: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
977: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
978: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID

Line 992: from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT

988: SUBT.REGION_APPLICATION_ID,
989: SUBT.ATTRIBUTE_CODE,
990: SUBT.ATTRIBUTE_APPLICATION_ID,
991: SUBT.LANGUAGE
992: from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT
993: where SUBB.REGION_CODE = SUBT.REGION_CODE
994: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
995: and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
996: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID

Line 1006: insert into AK_REGION_ITEMS_TL (

1002: or (SUBB.ATTRIBUTE_LABEL_SHORT is null and SUBT.ATTRIBUTE_LABEL_SHORT is not null)
1003: or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
1004: ));
1005:
1006: insert into AK_REGION_ITEMS_TL (
1007: REGION_APPLICATION_ID,
1008: REGION_CODE,
1009: ATTRIBUTE_APPLICATION_ID,
1010: ATTRIBUTE_CODE,

Line 1034: from AK_REGION_ITEMS_TL B, FND_LANGUAGES L

1030: B.LAST_UPDATE_DATE,
1031: B.LAST_UPDATE_LOGIN,
1032: L.LANGUAGE_CODE,
1033: B.SOURCE_LANG
1034: from AK_REGION_ITEMS_TL B, FND_LANGUAGES L
1035: where L.INSTALLED_FLAG in ('I', 'B')
1036: and B.LANGUAGE = userenv('LANG')
1037: and not exists
1038: (select NULL

Line 1039: from AK_REGION_ITEMS_TL T

1035: where L.INSTALLED_FLAG in ('I', 'B')
1036: and B.LANGUAGE = userenv('LANG')
1037: and not exists
1038: (select NULL
1039: from AK_REGION_ITEMS_TL T
1040: where T.REGION_CODE = B.REGION_CODE
1041: and T.REGION_APPLICATION_ID = B.REGION_APPLICATION_ID
1042: and T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
1043: and T.ATTRIBUTE_APPLICATION_ID = B.ATTRIBUTE_APPLICATION_ID

Line 1048: end jtfb_ak_region_items_pkg;

1044: and T.LANGUAGE = L.LANGUAGE_CODE);
1045: end ADD_LANGUAGE;
1046: --
1047: --
1048: end jtfb_ak_region_items_pkg;