APPS.AK_ATTRIBUTES_PKG dependencies on AK_ATTRIBUTES_TL

Line 166: insert into AK_ATTRIBUTES_TL (

162: raise no_data_found;
163: end if;
164: close c;
165:
166: insert into AK_ATTRIBUTES_TL (
167: ATTRIBUTE_APPLICATION_ID,
168: ATTRIBUTE_CODE,
169: LANGUAGE,
170: NAME,

Line 198: from AK_ATTRIBUTES_TL T

194: from FND_LANGUAGES L
195: where L.INSTALLED_FLAG in ('I', 'B')
196: and not exists
197: (select NULL
198: from AK_ATTRIBUTES_TL T
199: where T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
200: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
201: and T.LANGUAGE = L.LANGUAGE_CODE);
202: end INSERT_ROW;

Line 302: from AK_ATTRIBUTES_TL

298: NAME,
299: ATTRIBUTE_LABEL_LONG,
300: ATTRIBUTE_LABEL_SHORT,
301: DESCRIPTION
302: from AK_ATTRIBUTES_TL
303: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
304: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
305: and LANGUAGE = userenv('LANG')
306: for update of ATTRIBUTE_CODE nowait;

Line 561: update AK_ATTRIBUTES_TL set

557: if (sql%notfound) then
558: raise no_data_found;
559: end if;
560:
561: update AK_ATTRIBUTES_TL set
562: NAME = X_NAME,
563: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
564: ATTRIBUTE_LABEL_SHORT = X_ATTRIBUTE_LABEL_SHORT,
565: DESCRIPTION = X_DESCRIPTION,

Line 599: delete from AK_ATTRIBUTES_TL

595: if (sql%notfound) then
596: null;
597: end if;
598:
599: delete from AK_ATTRIBUTES_TL
600: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
601: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
602: if (sql%notfound) then
603: raise no_data_found;

Line 617: delete from AK_ATTRIBUTES_TL T

613: /* as a quick workaround to fix the time-consuming table handler issue */
614: /* Eventually we'll need to turn them into a separate fix_language procedure */
615: /*
616:
617: delete from AK_ATTRIBUTES_TL T
618: where not exists
619: (select NULL
620: from AK_ATTRIBUTES B
621: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE

Line 625: update AK_ATTRIBUTES_TL T set (

621: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
622: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
623: );
624:
625: update AK_ATTRIBUTES_TL T set (
626: NAME,
627: ATTRIBUTE_LABEL_LONG,
628: ATTRIBUTE_LABEL_SHORT,
629: DESCRIPTION

Line 635: from AK_ATTRIBUTES_TL B

631: B.NAME,
632: B.ATTRIBUTE_LABEL_LONG,
633: B.ATTRIBUTE_LABEL_SHORT,
634: B.DESCRIPTION
635: from AK_ATTRIBUTES_TL B
636: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
637: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
638: and B.LANGUAGE = T.SOURCE_LANG)
639: where (

Line 647: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT

643: ) in (select
644: SUBT.ATTRIBUTE_CODE,
645: SUBT.ATTRIBUTE_APPLICATION_ID,
646: SUBT.LANGUAGE
647: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT
648: where SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
649: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
650: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
651: and (SUBB.NAME <> SUBT.NAME

Line 664: insert /*+ append parallel(tt) */ into AK_ATTRIBUTES_TL tt (

660: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
661: ));
662: */
663:
664: insert /*+ append parallel(tt) */ into AK_ATTRIBUTES_TL tt (
665: ATTRIBUTE_APPLICATION_ID,
666: ATTRIBUTE_CODE,
667: NAME,
668: ATTRIBUTE_LABEL_LONG,

Line 693: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L

689: B.LAST_UPDATE_DATE,
690: B.LAST_UPDATE_LOGIN,
691: L.LANGUAGE_CODE,
692: B.SOURCE_LANG
693: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L
694: where L.INSTALLED_FLAG in ('I', 'B')
695: and B.LANGUAGE = userenv('LANG')
696: ) v, AK_ATTRIBUTES_TL t
697: where T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE

Line 696: ) v, AK_ATTRIBUTES_TL t

692: B.SOURCE_LANG
693: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L
694: where L.INSTALLED_FLAG in ('I', 'B')
695: and B.LANGUAGE = userenv('LANG')
696: ) v, AK_ATTRIBUTES_TL t
697: where T.ATTRIBUTE_CODE(+) = v.ATTRIBUTE_CODE
698: and T.ATTRIBUTE_APPLICATION_ID(+) = v.ATTRIBUTE_APPLICATION_ID
699: and T.LANGUAGE(+) = v.LANGUAGE_CODE
700: and T.ATTRIBUTE_CODE is NULL