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.FND_CONCURRENT_QUEUES_PKG dependencies on FND_CONCURRENT_QUEUES

Line 1: package body FND_CONCURRENT_QUEUES_PKG as

1: package body FND_CONCURRENT_QUEUES_PKG as
2: /* $Header: AFCPDCQB.pls 120.2 2005/08/19 18:50:39 tkamiya ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 53: cursor C is select ROWID from FND_CONCURRENT_QUEUES

49: X_LAST_UPDATE_DATE in DATE,
50: X_LAST_UPDATED_BY in NUMBER,
51: X_LAST_UPDATE_LOGIN in NUMBER
52: ) is
53: cursor C is select ROWID from FND_CONCURRENT_QUEUES
54: where APPLICATION_ID = X_APPLICATION_ID
55: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID
56: ;
57: begin

Line 58: insert into FND_CONCURRENT_QUEUES (

54: where APPLICATION_ID = X_APPLICATION_ID
55: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID
56: ;
57: begin
58: insert into FND_CONCURRENT_QUEUES (
59: RESOURCE_CONSUMER_GROUP,
60: APPLICATION_ID,
61: CONCURRENT_QUEUE_ID,
62: CONCURRENT_QUEUE_NAME,

Line 150: insert into FND_CONCURRENT_QUEUES_TL (

146: X_LAST_UPDATED_BY,
147: X_LAST_UPDATE_LOGIN
148: );
149:
150: insert into FND_CONCURRENT_QUEUES_TL (
151: USER_CONCURRENT_QUEUE_NAME,
152: APPLICATION_ID,
153: CONCURRENT_QUEUE_ID,
154: CONCURRENT_QUEUE_NAME,

Line 180: from FND_CONCURRENT_QUEUES_TL T

176: from FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and not exists
179: (select NULL
180: from FND_CONCURRENT_QUEUES_TL T
181: where T.APPLICATION_ID = X_APPLICATION_ID
182: and T.CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID
183: and T.LANGUAGE = L.LANGUAGE_CODE);
184:

Line 276: from FND_CONCURRENT_QUEUES

272: ATTRIBUTE10,
273: ATTRIBUTE11,
274: ATTRIBUTE12,
275: ENABLED_FLAG
276: from FND_CONCURRENT_QUEUES
277: where APPLICATION_ID = X_APPLICATION_ID
278: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID
279: for update of APPLICATION_ID nowait;
280: recinfo c%rowtype;

Line 286: from FND_CONCURRENT_QUEUES_TL

282: cursor c1 is select
283: DESCRIPTION,
284: USER_CONCURRENT_QUEUE_NAME,
285: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
286: from FND_CONCURRENT_QUEUES_TL
287: where APPLICATION_ID = X_APPLICATION_ID
288: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID
289: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
290: for update of APPLICATION_ID nowait;

Line 439: update FND_CONCURRENT_QUEUES set

435: X_LAST_UPDATED_BY in NUMBER,
436: X_LAST_UPDATE_LOGIN in NUMBER
437: ) is
438: begin
439: update FND_CONCURRENT_QUEUES set
440: RESOURCE_CONSUMER_GROUP = X_RESOURCE_CONSUMER_GROUP,
441: CONCURRENT_QUEUE_NAME = X_CONCURRENT_QUEUE_NAME,
442: PROCESSOR_APPLICATION_ID = X_PROCESSOR_APPLICATION_ID,
443: CONCURRENT_PROCESSOR_ID = X_CONCURRENT_PROCESSOR_ID,

Line 487: update FND_CONCURRENT_QUEUES_TL set

483: if (sql%notfound) then
484: raise no_data_found;
485: end if;
486:
487: update FND_CONCURRENT_QUEUES_TL set
488: DESCRIPTION = X_DESCRIPTION,
489: USER_CONCURRENT_QUEUE_NAME = X_USER_CONCURRENT_QUEUE_NAME,
490: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
491: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 508: delete from FND_CONCURRENT_QUEUES_TL

504: X_APPLICATION_ID in NUMBER,
505: X_CONCURRENT_QUEUE_ID in NUMBER
506: ) is
507: begin
508: delete from FND_CONCURRENT_QUEUES_TL
509: where APPLICATION_ID = X_APPLICATION_ID
510: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID;
511:
512: if (sql%notfound) then

Line 516: delete from FND_CONCURRENT_QUEUES

512: if (sql%notfound) then
513: raise no_data_found;
514: end if;
515:
516: delete from FND_CONCURRENT_QUEUES
517: where APPLICATION_ID = X_APPLICATION_ID
518: and CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID;
519:
520: if (sql%notfound) then

Line 535: delete from FND_CONCURRENT_QUEUES_TL T

531: /* as a quick workaround to fix the time-consuming table handler issue */
532: /* Eventually we'll need to turn them into a separate fix_language procedure */
533: /*
534:
535: delete from FND_CONCURRENT_QUEUES_TL T
536: where not exists
537: (select NULL
538: from FND_CONCURRENT_QUEUES B
539: where B.APPLICATION_ID = T.APPLICATION_ID

Line 538: from FND_CONCURRENT_QUEUES B

534:
535: delete from FND_CONCURRENT_QUEUES_TL T
536: where not exists
537: (select NULL
538: from FND_CONCURRENT_QUEUES B
539: where B.APPLICATION_ID = T.APPLICATION_ID
540: and B.CONCURRENT_QUEUE_ID = T.CONCURRENT_QUEUE_ID
541: );
542:

Line 543: update FND_CONCURRENT_QUEUES_TL T set (

539: where B.APPLICATION_ID = T.APPLICATION_ID
540: and B.CONCURRENT_QUEUE_ID = T.CONCURRENT_QUEUE_ID
541: );
542:
543: update FND_CONCURRENT_QUEUES_TL T set (
544: DESCRIPTION,
545: USER_CONCURRENT_QUEUE_NAME
546: ) = (select
547: B.DESCRIPTION,

Line 549: from FND_CONCURRENT_QUEUES_TL B

545: USER_CONCURRENT_QUEUE_NAME
546: ) = (select
547: B.DESCRIPTION,
548: B.USER_CONCURRENT_QUEUE_NAME
549: from FND_CONCURRENT_QUEUES_TL B
550: where B.APPLICATION_ID = T.APPLICATION_ID
551: and B.CONCURRENT_QUEUE_ID = T.CONCURRENT_QUEUE_ID
552: and B.LANGUAGE = T.SOURCE_LANG)
553: where (

Line 561: from FND_CONCURRENT_QUEUES_TL SUBB, FND_CONCURRENT_QUEUES_TL SUBT

557: ) in (select
558: SUBT.APPLICATION_ID,
559: SUBT.CONCURRENT_QUEUE_ID,
560: SUBT.LANGUAGE
561: from FND_CONCURRENT_QUEUES_TL SUBB, FND_CONCURRENT_QUEUES_TL SUBT
562: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
563: and SUBB.CONCURRENT_QUEUE_ID = SUBT.CONCURRENT_QUEUE_ID
564: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
565: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 575: insert into FND_CONCURRENT_QUEUES_TL (

571: ));
572:
573: */
574:
575: insert into FND_CONCURRENT_QUEUES_TL (
576: USER_CONCURRENT_QUEUE_NAME,
577: APPLICATION_ID,
578: CONCURRENT_QUEUE_ID,
579: CONCURRENT_QUEUE_NAME,

Line 601: from FND_CONCURRENT_QUEUES_TL B, FND_LANGUAGES L

597: B.LAST_UPDATE_LOGIN,
598: B.DESCRIPTION,
599: L.LANGUAGE_CODE,
600: B.SOURCE_LANG
601: from FND_CONCURRENT_QUEUES_TL B, FND_LANGUAGES L
602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL

Line 606: from FND_CONCURRENT_QUEUES_TL T

602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL
606: from FND_CONCURRENT_QUEUES_TL T
607: where T.APPLICATION_ID = B.APPLICATION_ID
608: and T.CONCURRENT_QUEUE_ID = B.CONCURRENT_QUEUE_ID
609: and T.LANGUAGE = L.LANGUAGE_CODE);
610: end ADD_LANGUAGE;

Line 612: end FND_CONCURRENT_QUEUES_PKG;

608: and T.CONCURRENT_QUEUE_ID = B.CONCURRENT_QUEUE_ID
609: and T.LANGUAGE = L.LANGUAGE_CODE);
610: end ADD_LANGUAGE;
611:
612: end FND_CONCURRENT_QUEUES_PKG;