APPS.JTFB_AK_REGION_ITEMS_PKG dependencies on AK_REGION_ITEMS_TL

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