APPS.AK_REGIONS_PKG dependencies on AK_REGIONS_TL

Line 183: insert into AK_REGIONS_TL (

179: raise no_data_found;
180: end if;
181: close c;
182:
183: insert into AK_REGIONS_TL (
184: REGION_APPLICATION_ID,
185: REGION_CODE,
186: LANGUAGE,
187: NAME,

Line 211: from AK_REGIONS_TL T

207: from FND_LANGUAGES L
208: where L.INSTALLED_FLAG in ('I', 'B')
209: and not exists
210: (select NULL
211: from AK_REGIONS_TL T
212: where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
213: and T.REGION_CODE = X_REGION_CODE
214: and T.LANGUAGE = L.LANGUAGE_CODE);
215: end INSERT_ROW;

Line 325: from AK_REGIONS_TL

321:
322: cursor c1 is select
323: NAME,
324: DESCRIPTION
325: from AK_REGIONS_TL
326: where REGION_CODE = X_REGION_CODE
327: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
328: and LANGUAGE = userenv('LANG')
329: for update of REGION_CODE nowait;

Line 618: update AK_REGIONS_TL set

614: if (sql%notfound) then
615: raise no_data_found;
616: end if;
617:
618: update AK_REGIONS_TL set
619: NAME = X_NAME,
620: DESCRIPTION = X_DESCRIPTION,
621: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
622: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 646: delete from AK_REGIONS_TL

642: if (sql%notfound) then
643: raise no_data_found;
644: end if;
645:
646: delete from AK_REGIONS_TL
647: where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
648: and REGION_CODE = X_REGION_CODE;
649:
650: if (sql%notfound) then

Line 664: delete from AK_REGIONS_TL T

660: /* The following delete and update statements are commented out */
661: /* as a quick workaround to fix the time-consuming table handler issue */
662: /* Eventually we'll need to turn them into a separate fix_language procedure */
663: /*
664: delete from AK_REGIONS_TL T
665: where not exists
666: (select NULL
667: from AK_REGIONS B
668: where B.REGION_CODE = T.REGION_CODE

Line 672: update AK_REGIONS_TL T set (

668: where B.REGION_CODE = T.REGION_CODE
669: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
670: );
671:
672: update AK_REGIONS_TL T set (
673: NAME,
674: DESCRIPTION
675: ) = (select
676: B.NAME,

Line 678: from AK_REGIONS_TL B

674: DESCRIPTION
675: ) = (select
676: B.NAME,
677: B.DESCRIPTION
678: from AK_REGIONS_TL B
679: where B.REGION_CODE = T.REGION_CODE
680: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
681: and B.LANGUAGE = T.SOURCE_LANG)
682: where (

Line 690: from AK_REGIONS_TL SUBB, AK_REGIONS_TL SUBT

686: ) in (select
687: SUBT.REGION_CODE,
688: SUBT.REGION_APPLICATION_ID,
689: SUBT.LANGUAGE
690: from AK_REGIONS_TL SUBB, AK_REGIONS_TL SUBT
691: where SUBB.REGION_CODE = SUBT.REGION_CODE
692: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
693: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
694: and (SUBB.NAME <> SUBT.NAME

Line 701: insert /*+ append parallel(tt) */ into AK_REGIONS_TL tt (

697: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
698: ));
699: */
700:
701: insert /*+ append parallel(tt) */ into AK_REGIONS_TL tt (
702: REGION_APPLICATION_ID,
703: REGION_CODE,
704: NAME,
705: DESCRIPTION,

Line 726: from AK_REGIONS_TL B, FND_LANGUAGES L

722: B.LAST_UPDATE_DATE,
723: B.LAST_UPDATE_LOGIN,
724: L.LANGUAGE_CODE,
725: B.SOURCE_LANG
726: from AK_REGIONS_TL B, FND_LANGUAGES L
727: where L.INSTALLED_FLAG in ('I', 'B')
728: and B.LANGUAGE = userenv('LANG')
729: ) v, AK_REGIONS_TL t
730: where T.REGION_CODE(+) = v.REGION_CODE

Line 729: ) v, AK_REGIONS_TL t

725: B.SOURCE_LANG
726: from AK_REGIONS_TL B, FND_LANGUAGES L
727: where L.INSTALLED_FLAG in ('I', 'B')
728: and B.LANGUAGE = userenv('LANG')
729: ) v, AK_REGIONS_TL t
730: where T.REGION_CODE(+) = v.REGION_CODE
731: and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
732: and T.LANGUAGE(+) = v.LANGUAGE_CODE
733: and T.REGION_CODE is NULL