APPS.AK_FOREIGN_KEYS_PKG dependencies on AK_FOREIGN_KEYS

Line 1: package body AK_FOREIGN_KEYS_PKG as

1: package body AK_FOREIGN_KEYS_PKG as
2: /* $Header: AKDOBFKB.pls 120.3 2006/01/25 15:57:40 tshort ship $ */
3: --*****************************************************************************
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 36: cursor C is select ROWID from AK_FOREIGN_KEYS

32: X_ATTRIBUTE13 in VARCHAR2,
33: X_ATTRIBUTE14 in VARCHAR2,
34: X_ATTRIBUTE15 in VARCHAR2
35: ) is
36: cursor C is select ROWID from AK_FOREIGN_KEYS
37: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
38: begin
39: insert into AK_FOREIGN_KEYS (
40: FOREIGN_KEY_NAME,

Line 39: insert into AK_FOREIGN_KEYS (

35: ) is
36: cursor C is select ROWID from AK_FOREIGN_KEYS
37: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
38: begin
39: insert into AK_FOREIGN_KEYS (
40: FOREIGN_KEY_NAME,
41: DATABASE_OBJECT_NAME,
42: UNIQUE_KEY_NAME,
43: APPLICATION_ID,

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 276: from AK_FOREIGN_KEYS

272: ATTRIBUTE12,
273: ATTRIBUTE13,
274: ATTRIBUTE14,
275: ATTRIBUTE15
276: from AK_FOREIGN_KEYS
277: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
278: for update of FOREIGN_KEY_NAME nowait;
279: recinfo c%rowtype;
280:

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 533: update AK_FOREIGN_KEYS set

529: X_ATTRIBUTE14 in VARCHAR2,
530: X_ATTRIBUTE15 in VARCHAR2
531: ) is
532: begin
533: update AK_FOREIGN_KEYS set
534: FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME,
535: DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME,
536: UNIQUE_KEY_NAME = X_UNIQUE_KEY_NAME,
537: APPLICATION_ID = X_APPLICATION_ID,

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 638: delete from AK_FOREIGN_KEYS

634: procedure DELETE_ROW (
635: X_FOREIGN_KEY_NAME in VARCHAR2
636: ) is
637: begin
638: delete from AK_FOREIGN_KEYS
639: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
640:
641: if (sql%notfound) then
642: raise no_data_found;

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 687: from AK_FOREIGN_KEYS B

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
689: );
690:
691: update AK_FOREIGN_KEYS_TL T set (

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:

Line 766: end AK_FOREIGN_KEYS_PKG;

762: and T.FOREIGN_KEY_NAME is NULL;
763:
764: end ADD_LANGUAGE;
765: --*****************************************************************************
766: end AK_FOREIGN_KEYS_PKG;