DBA Data[Home] [Help]

APPS.AK_OBJECTS_PKG dependencies on AK_OBJECTS_TL

Line 107: insert into AK_OBJECTS_TL (

103: raise no_data_found;
104: end if;
105: close c;
106:
107: insert into AK_OBJECTS_TL (
108: DATABASE_OBJECT_NAME,
109: LANGUAGE,
110: NAME,
111: DESCRIPTION,

Line 133: from AK_OBJECTS_TL T

129: from FND_LANGUAGES L
130: where L.INSTALLED_FLAG in ('I', 'B')
131: and not exists
132: (select NULL
133: from AK_OBJECTS_TL T
134: where T.DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
135: and T.LANGUAGE = L.LANGUAGE_CODE);
136: end INSERT_ROW;
137:

Line 196: from AK_OBJECTS_TL

192:
193: cursor c1 is select
194: NAME,
195: DESCRIPTION
196: from AK_OBJECTS_TL
197: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
198: and LANGUAGE = userenv('LANG')
199: for update of DATABASE_OBJECT_NAME nowait;
200: tlinfo c1%rowtype;

Line 366: update AK_OBJECTS_TL set

362: if (sql%notfound) then
363: raise no_data_found;
364: end if;
365:
366: update AK_OBJECTS_TL set
367: NAME = X_NAME,
368: DESCRIPTION = X_DESCRIPTION,
369: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
370: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 392: delete from AK_OBJECTS_TL

388: if (sql%notfound) then
389: raise no_data_found;
390: end if;
391:
392: delete from AK_OBJECTS_TL
393: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME;
394: if (sql%notfound) then
395: raise no_data_found;
396: end if;

Line 408: delete from AK_OBJECTS_TL T

404: /* The following delete and update statements are commented out */
405: /* as a quick workaround to fix the time-consuming table handler issue */
406: /* Eventually we'll need to turn them into a separate fix_language procedure */
407: /*
408: delete from AK_OBJECTS_TL T
409: where not exists
410: (select NULL
411: from AK_OBJECTS B
412: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME

Line 415: update AK_OBJECTS_TL T set (

411: from AK_OBJECTS B
412: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
413: );
414:
415: update AK_OBJECTS_TL T set (
416: NAME,
417: DESCRIPTION
418: ) = (select
419: B.NAME,

Line 421: from AK_OBJECTS_TL B

417: DESCRIPTION
418: ) = (select
419: B.NAME,
420: B.DESCRIPTION
421: from AK_OBJECTS_TL B
422: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
423: and B.LANGUAGE = T.SOURCE_LANG)
424: where (
425: T.DATABASE_OBJECT_NAME,

Line 430: from AK_OBJECTS_TL SUBB, AK_OBJECTS_TL SUBT

426: T.LANGUAGE
427: ) in (select
428: SUBT.DATABASE_OBJECT_NAME,
429: SUBT.LANGUAGE
430: from AK_OBJECTS_TL SUBB, AK_OBJECTS_TL SUBT
431: where SUBB.DATABASE_OBJECT_NAME = SUBT.DATABASE_OBJECT_NAME
432: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
433: and (SUBB.NAME <> SUBT.NAME
434: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 442: insert /*+ append parallel(tt) */ into AK_OBJECTS_TL tt (

438: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
439: ));
440: */
441:
442: insert /*+ append parallel(tt) */ into AK_OBJECTS_TL tt (
443: DATABASE_OBJECT_NAME,
444: NAME,
445: DESCRIPTION,
446: CREATED_BY,

Line 465: from AK_OBJECTS_TL B, FND_LANGUAGES L

461: B.LAST_UPDATE_DATE,
462: B.LAST_UPDATE_LOGIN,
463: L.LANGUAGE_CODE,
464: B.SOURCE_LANG
465: from AK_OBJECTS_TL B, FND_LANGUAGES L
466: where L.INSTALLED_FLAG in ('I', 'B')
467: and B.LANGUAGE = userenv('LANG')
468: ) v, AK_OBJECTS_TL T
469: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME

Line 468: ) v, AK_OBJECTS_TL T

464: B.SOURCE_LANG
465: from AK_OBJECTS_TL B, FND_LANGUAGES L
466: where L.INSTALLED_FLAG in ('I', 'B')
467: and B.LANGUAGE = userenv('LANG')
468: ) v, AK_OBJECTS_TL T
469: where T.DATABASE_OBJECT_NAME(+) = v.DATABASE_OBJECT_NAME
470: and T.LANGUAGE(+) = v.LANGUAGE_CODE
471: and T.DATABASE_OBJECT_NAME is NULL;
472: