eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_FLOW_PAGES_PKG dependencies on AK_FLOW_PAGES

Line 1: package body AK_FLOW_PAGES_PKG as

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

Line 35: cursor C is select ROWID from AK_FLOW_PAGES

31: X_ATTRIBUTE13 in VARCHAR2,
32: X_ATTRIBUTE14 in VARCHAR2,
33: X_ATTRIBUTE15 in VARCHAR2
34: ) is
35: cursor C is select ROWID from AK_FLOW_PAGES
36: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
37: and FLOW_CODE = X_FLOW_CODE
38: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
39: and PAGE_CODE = X_PAGE_CODE;

Line 41: insert into AK_FLOW_PAGES (

37: and FLOW_CODE = X_FLOW_CODE
38: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
39: and PAGE_CODE = X_PAGE_CODE;
40: begin
41: insert into AK_FLOW_PAGES (
42: FLOW_APPLICATION_ID,
43: FLOW_CODE,
44: PAGE_APPLICATION_ID,
45: PAGE_CODE,

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 192: from AK_FLOW_PAGES

188: ATTRIBUTE_CATEGORY,
189: ATTRIBUTE1,
190: ATTRIBUTE2,
191: ATTRIBUTE3
192: from AK_FLOW_PAGES
193: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
194: and FLOW_CODE = X_FLOW_CODE
195: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
196: and 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 330: update AK_FLOW_PAGES set

326: X_ATTRIBUTE14 in VARCHAR2,
327: X_ATTRIBUTE15 in VARCHAR2
328: ) is
329: begin
330: update AK_FLOW_PAGES set
331: FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID,
332: FLOW_CODE = X_FLOW_CODE,
333: PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID,
334: 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 388: delete from AK_FLOW_PAGES

384: X_PAGE_APPLICATION_ID in NUMBER,
385: X_PAGE_CODE in VARCHAR2
386: ) is
387: begin
388: delete from AK_FLOW_PAGES
389: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
390: and FLOW_CODE = X_FLOW_CODE
391: and PAGE_APPLICATION_ID = X_PAGE_APPLICATION_ID
392: and PAGE_CODE = X_PAGE_CODE;

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 420: from AK_FLOW_PAGES B

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
422: and B.FLOW_APPLICATION_ID = T.FLOW_APPLICATION_ID
423: and B.PAGE_CODE = T.PAGE_CODE
424: and B.PAGE_APPLICATION_ID = T.PAGE_APPLICATION_ID

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

Line 510: end AK_FLOW_PAGES_PKG;

506: and T.PAGE_APPLICATION_ID is NULL;
507:
508: end ADD_LANGUAGE;
509:
510: end AK_FLOW_PAGES_PKG;