APPS.JTFB_AK_ATTRIBUTES_PKG dependencies on AK_ATTRIBUTES_TL

Line 159: insert into AK_ATTRIBUTES_TL (

155: raise no_data_found;
156: end if;
157: close c;
158:
159: insert into AK_ATTRIBUTES_TL (
160: ATTRIBUTE_APPLICATION_ID,
161: ATTRIBUTE_CODE,
162: LANGUAGE,
163: NAME,

Line 191: from AK_ATTRIBUTES_TL T

187: from FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and not exists
190: (select NULL
191: from AK_ATTRIBUTES_TL T
192: where T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
193: and T.ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
194: and T.LANGUAGE = L.LANGUAGE_CODE);
195: end INSERT_ROW;

Line 289: from AK_ATTRIBUTES_TL

285: cursor c1 is select
286: NAME,
287: ATTRIBUTE_LABEL_LONG,
288: DESCRIPTION
289: from AK_ATTRIBUTES_TL
290: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
291: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
292: and LANGUAGE = userenv('LANG')
293: for update of ATTRIBUTE_CODE nowait;

Line 533: update AK_ATTRIBUTES_TL set

529: if (sql%notfound) then
530: raise no_data_found;
531: end if;
532:
533: update AK_ATTRIBUTES_TL set
534: NAME = X_NAME,
535: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
536: DESCRIPTION = X_DESCRIPTION,
537:

Line 574: delete from AK_ATTRIBUTES_TL

570: if (sql%notfound) then
571: null;
572: end if;
573:
574: delete from AK_ATTRIBUTES_TL
575: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
576: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
577: if (sql%notfound) then
578: raise no_data_found;

Line 587: delete from AK_ATTRIBUTES_TL T

583: --*****************************************************************************
584: procedure ADD_LANGUAGE
585: is
586: begin
587: delete from AK_ATTRIBUTES_TL T
588: where not exists
589: (select NULL
590: from AK_ATTRIBUTES B
591: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE

Line 595: update AK_ATTRIBUTES_TL T set (

591: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
592: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
593: );
594:
595: update AK_ATTRIBUTES_TL T set (
596: NAME,
597: ATTRIBUTE_LABEL_LONG,
598: ATTRIBUTE_LABEL_SHORT,
599: DESCRIPTION

Line 605: from AK_ATTRIBUTES_TL B

601: B.NAME,
602: B.ATTRIBUTE_LABEL_LONG,
603: B.ATTRIBUTE_LABEL_SHORT,
604: B.DESCRIPTION
605: from AK_ATTRIBUTES_TL B
606: where B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
607: and B.ATTRIBUTE_APPLICATION_ID = T.ATTRIBUTE_APPLICATION_ID
608: and B.LANGUAGE = T.SOURCE_LANG)
609: where (

Line 617: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT

613: ) in (select
614: SUBT.ATTRIBUTE_CODE,
615: SUBT.ATTRIBUTE_APPLICATION_ID,
616: SUBT.LANGUAGE
617: from AK_ATTRIBUTES_TL SUBB, AK_ATTRIBUTES_TL SUBT
618: where SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
619: and SUBB.ATTRIBUTE_APPLICATION_ID = SUBT.ATTRIBUTE_APPLICATION_ID
620: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
621: and (SUBB.NAME <> SUBT.NAME

Line 633: insert into AK_ATTRIBUTES_TL (

629: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
630: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
631: ));
632:
633: insert into AK_ATTRIBUTES_TL (
634: ATTRIBUTE_APPLICATION_ID,
635: ATTRIBUTE_CODE,
636: NAME,
637: ATTRIBUTE_LABEL_LONG,

Line 661: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L

657: B.LAST_UPDATE_DATE,
658: B.LAST_UPDATE_LOGIN,
659: L.LANGUAGE_CODE,
660: B.SOURCE_LANG
661: from AK_ATTRIBUTES_TL B, FND_LANGUAGES L
662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL

Line 666: from AK_ATTRIBUTES_TL T

662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL
666: from AK_ATTRIBUTES_TL T
667: where T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
668: and T.ATTRIBUTE_APPLICATION_ID = B.ATTRIBUTE_APPLICATION_ID
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: end ADD_LANGUAGE;