APPS.AK_FOREIGN_KEYS_PKG dependencies on AK_FOREIGN_KEYS_TL

Line 101: insert into AK_FOREIGN_KEYS_TL (

97: raise no_data_found;
98: end if;
99: close c;
100:
101: insert into AK_FOREIGN_KEYS_TL (
102: FOREIGN_KEY_NAME,
103: LANGUAGE,
104: FROM_TO_NAME,
105: FROM_TO_DESCRIPTION,

Line 131: from AK_FOREIGN_KEYS_TL T

127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from AK_FOREIGN_KEYS_TL T
132: where T.FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
133: and T.LANGUAGE = L.LANGUAGE_CODE);
134: end INSERT_ROW;
135: --*****************************************************************************

Line 286: from AK_FOREIGN_KEYS_TL

282: FROM_TO_NAME,
283: FROM_TO_DESCRIPTION,
284: TO_FROM_NAME,
285: TO_FROM_DESCRIPTION
286: from AK_FOREIGN_KEYS_TL
287: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
288: and LANGUAGE = userenv('LANG')
289: for update of FOREIGN_KEY_NAME nowait;
290: tlinfo c1%rowtype;

Line 562: update AK_FOREIGN_KEYS_TL set

558: if (sql%notfound) then
559: raise no_data_found;
560: end if;
561:
562: update AK_FOREIGN_KEYS_TL set
563: FROM_TO_NAME = X_FROM_TO_NAME,
564: FROM_TO_DESCRIPTION = X_FROM_TO_DESCRIPTION,
565: TO_FROM_NAME = X_TO_FROM_NAME,
566: TO_FROM_DESCRIPTION = X_TO_FROM_DESCRIPTION,

Line 645: delete from AK_FOREIGN_KEYS_TL

641: if (sql%notfound) then
642: raise no_data_found;
643: end if;
644:
645: delete from AK_FOREIGN_KEYS_TL
646: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
647: if (sql%notfound) then
648: raise no_data_found;
649: end if;

Line 684: delete from AK_FOREIGN_KEYS_TL T

680: /* as a quick workaround to fix the time-consuming table handler issue */
681: /* Eventually we'll need to turn them into a separate fix_language procedure */
682: /*
683:
684: delete from AK_FOREIGN_KEYS_TL T
685: where not exists
686: (select NULL
687: from AK_FOREIGN_KEYS B
688: where B.FOREIGN_KEY_NAME = T.FOREIGN_KEY_NAME

Line 691: update AK_FOREIGN_KEYS_TL T set (

687: from AK_FOREIGN_KEYS B
688: where B.FOREIGN_KEY_NAME = T.FOREIGN_KEY_NAME
689: );
690:
691: update AK_FOREIGN_KEYS_TL T set (
692: FROM_TO_NAME,
693: FROM_TO_DESCRIPTION,
694: TO_FROM_NAME,
695: TO_FROM_DESCRIPTION

Line 701: from AK_FOREIGN_KEYS_TL B

697: B.FROM_TO_NAME,
698: B.FROM_TO_DESCRIPTION,
699: B.TO_FROM_NAME,
700: B.TO_FROM_DESCRIPTION
701: from AK_FOREIGN_KEYS_TL B
702: where B.FOREIGN_KEY_NAME = T.FOREIGN_KEY_NAME
703: and B.LANGUAGE = T.SOURCE_LANG)
704: where (
705: T.FOREIGN_KEY_NAME,

Line 710: from AK_FOREIGN_KEYS_TL SUBB, AK_FOREIGN_KEYS_TL SUBT

706: T.LANGUAGE
707: ) in (select
708: SUBT.FOREIGN_KEY_NAME,
709: SUBT.LANGUAGE
710: from AK_FOREIGN_KEYS_TL SUBB, AK_FOREIGN_KEYS_TL SUBT
711: where SUBB.FOREIGN_KEY_NAME = SUBT.FOREIGN_KEY_NAME
712: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
713: and (SUBB.FROM_TO_NAME <> SUBT.FROM_TO_NAME
714: or (SUBB.FROM_TO_NAME is null and SUBT.FROM_TO_NAME is not null)

Line 729: insert /*+ append parallel(tt) */ into AK_FOREIGN_KEYS_TL tt (

725: ));
726:
727: */
728:
729: insert /*+ append parallel(tt) */ into AK_FOREIGN_KEYS_TL tt (
730: FOREIGN_KEY_NAME,
731: FROM_TO_NAME,
732: FROM_TO_DESCRIPTION,
733: TO_FROM_NAME,

Line 756: from AK_FOREIGN_KEYS_TL B, FND_LANGUAGES L

752: B.LAST_UPDATE_DATE,
753: B.LAST_UPDATE_LOGIN,
754: L.LANGUAGE_CODE,
755: B.SOURCE_LANG
756: from AK_FOREIGN_KEYS_TL B, FND_LANGUAGES L
757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: ) v, AK_FOREIGN_KEYS_TL T
760: where T.FOREIGN_KEY_NAME(+) = v.FOREIGN_KEY_NAME

Line 759: ) v, AK_FOREIGN_KEYS_TL T

755: B.SOURCE_LANG
756: from AK_FOREIGN_KEYS_TL B, FND_LANGUAGES L
757: where L.INSTALLED_FLAG in ('I', 'B')
758: and B.LANGUAGE = userenv('LANG')
759: ) v, AK_FOREIGN_KEYS_TL T
760: where T.FOREIGN_KEY_NAME(+) = v.FOREIGN_KEY_NAME
761: and T.LANGUAGE(+) = v.LANGUAGE_CODE
762: and T.FOREIGN_KEY_NAME is NULL;
763: