APPS.AK_FLOW_PAGES_PKG dependencies on AK_FLOW_PAGES_TL

Line 107: insert into AK_FLOW_PAGES_TL (

103: raise no_data_found;
104: end if;
105: close c;
106:
107: insert into AK_FLOW_PAGES_TL (
108: FLOW_APPLICATION_ID,
109: FLOW_CODE,
110: PAGE_APPLICATION_ID,
111: PAGE_CODE,

Line 139: from AK_FLOW_PAGES_TL T

135: from FND_LANGUAGES L
136: where L.INSTALLED_FLAG in ('I', 'B')
137: and not exists
138: (select NULL
139: from AK_FLOW_PAGES_TL T
140: where T.FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
141: and T.FLOW_CODE = X_FLOW_CODE
142: and T.PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
143: and T.PAGE_CODE = X_PAGE_CODE

Line 203: from AK_FLOW_PAGES_TL

199:
200: cursor c1 is select
201: NAME,
202: DESCRIPTION
203: from AK_FLOW_PAGES_TL
204: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
205: and FLOW_CODE = X_FLOW_CODE
206: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
207: and PAGE_CODE = X_PAGE_CODE

Line 364: update AK_FLOW_PAGES_TL set

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

Line 398: delete from AK_FLOW_PAGES_TL

394: if (sql%notfound) then
395: raise no_data_found;
396: end if;
397:
398: delete from AK_FLOW_PAGES_TL
399: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
400: and FLOW_CODE = X_FLOW_CODE
401: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
402: and PAGE_CODE = X_PAGE_CODE;

Line 417: delete from AK_FLOW_PAGES_TL T

413: /* as a quick workaround to fix the time-consuming table handler issue */
414: /* Eventually we'll need to turn them into a separate fix_language procedure */
415: /*
416:
417: delete from AK_FLOW_PAGES_TL T
418: where not exists
419: (select NULL
420: from AK_FLOW_PAGES B
421: where B.FLOW_CODE = T.FLOW_CODE

Line 427: update AK_FLOW_PAGES_TL T set (

423: and B.PAGE_CODE = T.PAGE_CODE
424: and B.PAGE_APPLICATION_ID = T.PAGE_APPLICATION_ID
425: );
426:
427: update AK_FLOW_PAGES_TL T set (
428: NAME,
429: DESCRIPTION
430: ) = (select
431: B.NAME,

Line 433: from AK_FLOW_PAGES_TL B

429: DESCRIPTION
430: ) = (select
431: B.NAME,
432: B.DESCRIPTION
433: from AK_FLOW_PAGES_TL B
434: where B.FLOW_CODE = T.FLOW_CODE
435: and B.FLOW_APPLICATION_ID = T.FLOW_APPLICATION_ID
436: and B.PAGE_CODE = T.PAGE_CODE
437: and B.PAGE_APPLICATION_ID = T.PAGE_APPLICATION_ID

Line 451: from AK_FLOW_PAGES_TL SUBB, AK_FLOW_PAGES_TL SUBT

447: SUBT.FLOW_APPLICATION_ID,
448: SUBT.PAGE_CODE,
449: SUBT.PAGE_APPLICATION_ID,
450: SUBT.LANGUAGE
451: from AK_FLOW_PAGES_TL SUBB, AK_FLOW_PAGES_TL SUBT
452: where SUBB.FLOW_CODE = SUBT.FLOW_CODE
453: and SUBB.FLOW_APPLICATION_ID = SUBT.FLOW_APPLICATION_ID
454: and SUBB.PAGE_CODE = SUBT.PAGE_CODE
455: and SUBB.PAGE_APPLICATION_ID = SUBT.PAGE_APPLICATION_ID

Line 465: insert /*+ append parallel(tt) */ into AK_FLOW_PAGES_TL tt (

461: ));
462:
463: */
464:
465: insert /*+ append parallel(tt) */ into AK_FLOW_PAGES_TL tt (
466: FLOW_APPLICATION_ID,
467: FLOW_CODE,
468: PAGE_APPLICATION_ID,
469: PAGE_CODE,

Line 494: from AK_FLOW_PAGES_TL B, FND_LANGUAGES L

490: B.LAST_UPDATE_DATE,
491: B.LAST_UPDATE_LOGIN,
492: L.LANGUAGE_CODE,
493: B.SOURCE_LANG
494: from AK_FLOW_PAGES_TL B, FND_LANGUAGES L
495: where L.INSTALLED_FLAG in ('I', 'B')
496: and B.LANGUAGE = userenv('LANG')
497: ) v, AK_FLOW_PAGES_TL T
498: where T.FLOW_CODE(+) = v.FLOW_CODE

Line 497: ) v, AK_FLOW_PAGES_TL T

493: B.SOURCE_LANG
494: from AK_FLOW_PAGES_TL B, FND_LANGUAGES L
495: where L.INSTALLED_FLAG in ('I', 'B')
496: and B.LANGUAGE = userenv('LANG')
497: ) v, AK_FLOW_PAGES_TL T
498: where T.FLOW_CODE(+) = v.FLOW_CODE
499: and T.FLOW_APPLICATION_ID(+) = v.FLOW_APPLICATION_ID
500: and T.PAGE_CODE(+) = v.PAGE_CODE
501: and T.PAGE_APPLICATION_ID(+) = v.PAGE_APPLICATION_ID