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

Line 1: package body AK_REGION_ITEMS_PKG as

1: package body AK_REGION_ITEMS_PKG as
2: /* $Header: AKDRGITB.pls 120.3 2006/01/25 15:31:51 tshort ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_REGION_APPLICATION_ID in NUMBER,

Line 99: cursor C is select ROWID from AK_REGION_ITEMS

95: X_ATTRIBUTE13 in VARCHAR2,
96: X_ATTRIBUTE14 in VARCHAR2,
97: X_ATTRIBUTE15 in VARCHAR2
98: ) is
99: cursor C is select ROWID from AK_REGION_ITEMS
100: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
101: and REGION_CODE = X_REGION_CODE
102: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
103: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 105: insert into AK_REGION_ITEMS (

101: and REGION_CODE = X_REGION_CODE
102: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
103: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
104: begin
105: insert into AK_REGION_ITEMS (
106: REGION_APPLICATION_ID,
107: REGION_CODE,
108: ATTRIBUTE_APPLICATION_ID,
109: ATTRIBUTE_CODE,

Line 297: insert into AK_REGION_ITEMS_TL (

293: raise no_data_found;
294: end if;
295: close c;
296:
297: insert into AK_REGION_ITEMS_TL (
298: REGION_APPLICATION_ID,
299: REGION_CODE,
300: ATTRIBUTE_APPLICATION_ID,
301: ATTRIBUTE_CODE,

Line 331: from AK_REGION_ITEMS_TL T

327: from FND_LANGUAGES L
328: where L.INSTALLED_FLAG in ('I', 'B')
329: and not exists
330: (select NULL
331: from AK_REGION_ITEMS_TL T
332: where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
333: and T.REGION_CODE = X_REGION_CODE
334: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
335: and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 507: from AK_REGION_ITEMS

503: ALS_MAX_LENGTH,
504: SORTBY_VIEW_ATTRIBUTE_NAME,
505: ICX_CUSTOM_CALL,
506: INITIAL_SORT_SEQUENCE
507: from AK_REGION_ITEMS
508: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
509: and REGION_CODE = X_REGION_CODE
510: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
511: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE

Line 519: from AK_REGION_ITEMS_TL

515: cursor c1 is select
516: ATTRIBUTE_LABEL_LONG,
517: ATTRIBUTE_LABEL_SHORT,
518: DESCRIPTION
519: from AK_REGION_ITEMS_TL
520: where REGION_CODE = X_REGION_CODE
521: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
522: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
523: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID

Line 874: update AK_REGION_ITEMS set

870: X_ATTRIBUTE14 in VARCHAR2,
871: X_ATTRIBUTE15 in VARCHAR2
872: ) is
873: begin
874: update AK_REGION_ITEMS set
875: REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
876: REGION_CODE = X_REGION_CODE,
877: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
878: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,

Line 971: update AK_REGION_ITEMS_TL set

967: if (sql%notfound) then
968: raise no_data_found;
969: end if;
970:
971: update AK_REGION_ITEMS_TL set
972: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
973: ATTRIBUTE_LABEL_SHORT = X_ATTRIBUTE_LABEL_SHORT,
974: DESCRIPTION = X_DESCRIPTION,
975: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 996: delete from AK_REGION_ITEMS

992: X_ATTRIBUTE_APPLICATION_ID in NUMBER,
993: X_ATTRIBUTE_CODE in VARCHAR2
994: ) is
995: begin
996: delete from AK_REGION_ITEMS
997: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
998: and REGION_CODE = X_REGION_CODE
999: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1000: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 1006: delete from AK_REGION_ITEMS_TL

1002: if (sql%notfound) then
1003: raise no_data_found;
1004: end if;
1005:
1006: delete from AK_REGION_ITEMS_TL
1007: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1008: and REGION_CODE = X_REGION_CODE
1009: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1010: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;

Line 1025: delete from AK_REGION_ITEMS_TL T

1021: /* The following delete and update statements are commented out */
1022: /* as a quick workaround to fix the time-consuming table handler issue */
1023: /* Eventually we'll need to turn them into a separate fix_language procedure */
1024: /*
1025: delete from AK_REGION_ITEMS_TL T
1026: where not exists
1027: (select NULL
1028: from AK_REGION_ITEMS B
1029: where B.REGION_CODE = T.REGION_CODE

Line 1028: from AK_REGION_ITEMS B

1024: /*
1025: delete from AK_REGION_ITEMS_TL T
1026: where not exists
1027: (select NULL
1028: from AK_REGION_ITEMS B
1029: where B.REGION_CODE = T.REGION_CODE
1030: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
1031: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
1032: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID

Line 1035: update AK_REGION_ITEMS_TL T set (

1031: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
1032: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
1033: );
1034:
1035: update AK_REGION_ITEMS_TL T set (
1036: ATTRIBUTE_LABEL_LONG,
1037: ATTRIBUTE_LABEL_SHORT,
1038: DESCRIPTION
1039: ) = (select

Line 1043: from AK_REGION_ITEMS_TL B

1039: ) = (select
1040: B.ATTRIBUTE_LABEL_LONG,
1041: B.ATTRIBUTE_LABEL_SHORT,
1042: B.DESCRIPTION
1043: from AK_REGION_ITEMS_TL B
1044: where B.REGION_CODE = T.REGION_CODE
1045: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
1046: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
1047: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID

Line 1061: from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT

1057: SUBT.REGION_APPLICATION_ID,
1058: SUBT.ATTRIBUTE_CODE,
1059: SUBT.ATTRIBUTE_APPLICATION_ID,
1060: SUBT.LANGUAGE
1061: from AK_REGION_ITEMS_TL SUBB, AK_REGION_ITEMS_TL SUBT
1062: where SUBB.REGION_CODE = SUBT.REGION_CODE
1063: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
1064: and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
1065: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID

Line 1076: insert /+ append parallel(tt) / into AK_REGION_ITEMS_TL tt (

1072: or (SUBB.ATTRIBUTE_LABEL_SHORT is not null and SUBT.ATTRIBUTE_LABEL_SHORT is null)
1073: ));
1074: */
1075:
1076: insert /*+ append parallel(tt) */ into AK_REGION_ITEMS_TL tt (
1077: REGION_APPLICATION_ID,
1078: REGION_CODE,
1079: ATTRIBUTE_APPLICATION_ID,
1080: ATTRIBUTE_CODE,

Line 1105: from AK_REGION_ITEMS_TL B, FND_LANGUAGES L

1101: B.LAST_UPDATE_DATE,
1102: B.LAST_UPDATE_LOGIN,
1103: L.LANGUAGE_CODE,
1104: B.SOURCE_LANG
1105: from AK_REGION_ITEMS_TL B, FND_LANGUAGES L
1106: where L.INSTALLED_FLAG in ('I', 'B')
1107: and B.LANGUAGE = userenv('LANG')
1108: ) v, ak_region_items_tl t
1109: where T.REGION_CODE(+) = v.REGION_CODE

Line 1108: ) v, ak_region_items_tl t

1104: B.SOURCE_LANG
1105: from AK_REGION_ITEMS_TL B, FND_LANGUAGES L
1106: where L.INSTALLED_FLAG in ('I', 'B')
1107: and B.LANGUAGE = userenv('LANG')
1108: ) v, ak_region_items_tl t
1109: where T.REGION_CODE(+) = v.REGION_CODE
1110: and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
1111: and T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE
1112: and T.ATTRIBUTE_APPLICATION_ID(+) = v.ATTRIBUTE_APPLICATION_ID

Line 1121: end AK_REGION_ITEMS_PKG;

1117: and T.ATTRIBUTE_APPLICATION_ID is NULL;
1118:
1119: end ADD_LANGUAGE;
1120:
1121: end AK_REGION_ITEMS_PKG;