APPS.JTF_CAL_EXCEPTIONS_PKG dependencies on JTF_CAL_EXCEPTIONS_TL

Line 170: insert into JTF_CAL_EXCEPTIONS_TL (

166: FND_GLOBAL.USER_ID,
167: NULL
168: );
169:
170: insert into JTF_CAL_EXCEPTIONS_TL (
171: EXCEPTION_ID,
172: EXCEPTION_NAME,
173: DESCRIPTION,
174: CREATION_DATE,

Line 196: from JTF_CAL_EXCEPTIONS_TL T

192: from FND_LANGUAGES L
193: where L.INSTALLED_FLAG in ('I', 'B')
194: and not exists
195: (select NULL
196: from JTF_CAL_EXCEPTIONS_TL T
197: where T.EXCEPTION_ID = X_EXCEPTION_ID
198: and T.LANGUAGE = L.LANGUAGE_CODE);
199: /*
200: open c;

Line 266: from JTF_CAL_EXCEPTIONS_TL

262: cursor c1 is select
263: EXCEPTION_NAME,
264: DESCRIPTION,
265: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
266: from JTF_CAL_EXCEPTIONS_TL
267: where EXCEPTION_ID = X_EXCEPTION_ID
268: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
269: for update of EXCEPTION_ID nowait;
270: begin

Line 472: JTF_CAL_EXCEPTIONS_TL set

468: raise no_data_found;
469: end if;
470:
471: update
472: JTF_CAL_EXCEPTIONS_TL set
473: EXCEPTION_NAME = X_EXCEPTION_NAME,
474: DESCRIPTION = X_DESCRIPTION,
475: LAST_UPDATE_DATE = sysdate,
476: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 498: Update JTF_CAL_EXCEPTIONS_TL set

494: X_LAST_UPDATE_LOGIN in number)
495: is
496: begin
497:
498: Update JTF_CAL_EXCEPTIONS_TL set
499: exception_name = nvl(X_EXCEPTION_NAME,exception_name),
500: description = nvl(X_DESCRIPTION,description),
501: last_update_date = nvl(x_last_update_date,sysdate),
502: last_updated_by = x_last_updated_by,

Line 514: delete from JTF_CAL_EXCEPTIONS_TL

510: procedure DELETE_ROW (
511: X_EXCEPTION_ID in NUMBER
512: ) is
513: begin
514: delete from JTF_CAL_EXCEPTIONS_TL
515: where EXCEPTION_ID = X_EXCEPTION_ID;
516:
517: if (sql%notfound) then
518: raise no_data_found;

Line 532: delete from JTF_CAL_EXCEPTIONS_TL T

528:
529: procedure ADD_LANGUAGE
530: is
531: begin
532: delete from JTF_CAL_EXCEPTIONS_TL T
533: where not exists
534: (select NULL
535: from JTF_CAL_EXCEPTIONS_B B
536: where B.EXCEPTION_ID = T.EXCEPTION_ID

Line 539: update JTF_CAL_EXCEPTIONS_TL T set (

535: from JTF_CAL_EXCEPTIONS_B B
536: where B.EXCEPTION_ID = T.EXCEPTION_ID
537: );
538:
539: update JTF_CAL_EXCEPTIONS_TL T set (
540: EXCEPTION_NAME,
541: DESCRIPTION
542: ) = (select
543: B.EXCEPTION_NAME,

Line 545: from JTF_CAL_EXCEPTIONS_TL B

541: DESCRIPTION
542: ) = (select
543: B.EXCEPTION_NAME,
544: B.DESCRIPTION
545: from JTF_CAL_EXCEPTIONS_TL B
546: where B.EXCEPTION_ID = T.EXCEPTION_ID
547: and B.LANGUAGE = T.SOURCE_LANG)
548: where (
549: T.EXCEPTION_ID,

Line 554: from JTF_CAL_EXCEPTIONS_TL SUBB, JTF_CAL_EXCEPTIONS_TL SUBT

550: T.LANGUAGE
551: ) in (select
552: SUBT.EXCEPTION_ID,
553: SUBT.LANGUAGE
554: from JTF_CAL_EXCEPTIONS_TL SUBB, JTF_CAL_EXCEPTIONS_TL SUBT
555: where SUBB.EXCEPTION_ID = SUBT.EXCEPTION_ID
556: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
557: and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
558: or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)

Line 565: insert into JTF_CAL_EXCEPTIONS_TL (

561: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
562: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
563: ));
564:
565: insert into JTF_CAL_EXCEPTIONS_TL (
566: EXCEPTION_ID,
567: EXCEPTION_NAME,
568: DESCRIPTION,
569: CREATED_BY,

Line 587: from JTF_CAL_EXCEPTIONS_TL B, FND_LANGUAGES L

583: B.LAST_UPDATE_DATE,
584: B.LAST_UPDATE_LOGIN,
585: L.LANGUAGE_CODE,
586: B.SOURCE_LANG
587: from JTF_CAL_EXCEPTIONS_TL B, FND_LANGUAGES L
588: where L.INSTALLED_FLAG in ('I', 'B')
589: and B.LANGUAGE = userenv('LANG')
590: and not exists
591: (select NULL

Line 592: from JTF_CAL_EXCEPTIONS_TL T

588: where L.INSTALLED_FLAG in ('I', 'B')
589: and B.LANGUAGE = userenv('LANG')
590: and not exists
591: (select NULL
592: from JTF_CAL_EXCEPTIONS_TL T
593: where T.EXCEPTION_ID = B.EXCEPTION_ID
594: and T.LANGUAGE = L.LANGUAGE_CODE);
595: end ADD_LANGUAGE;
596: /*************************************************************************/