APPS.AK_REGION_ITEMS_PKG dependencies on AK_REGION_ITEMS_TL

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 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 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 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 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