APPS.FND_CONCURRENT_QUEUES_PKG dependencies on FND_CONCURRENT_QUEUES_TL

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 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 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 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 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;