APPS.JTF_CALENDARS_PKG dependencies on JTF_CALENDARS_TL

Line 162: insert into JTF_CALENDARS_TL (

158: FND_GLOBAL.USER_ID,
159: NULL
160: );
161:
162: insert into JTF_CALENDARS_TL (
163: CALENDAR_ID,
164: CALENDAR_NAME,
165: DESCRIPTION,
166: CREATED_BY,

Line 188: from JTF_CALENDARS_TL T

184: from FND_LANGUAGES L
185: where L.INSTALLED_FLAG in ('I', 'B')
186: and not exists
187: (select NULL
188: from JTF_CALENDARS_TL T
189: where T.CALENDAR_ID = X_CALENDAR_ID
190: and T.LANGUAGE = L.LANGUAGE_CODE);
191: /*
192: open c;

Line 258: from JTF_CALENDARS_TL

254: cursor c1 is select
255: CALENDAR_NAME,
256: DESCRIPTION,
257: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
258: from JTF_CALENDARS_TL
259: where CALENDAR_ID = X_CALENDAR_ID
260: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
261: for update of CALENDAR_ID nowait;
262: begin

Line 463: update JTF_CALENDARS_TL set

459: if (sql%notfound) then
460: raise no_data_found;
461: end if;
462:
463: update JTF_CALENDARS_TL set
464: CALENDAR_NAME = X_CALENDAR_NAME,
465: DESCRIPTION = X_DESCRIPTION,
466: LAST_UPDATE_DATE = sysdate,
467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 489: Update JTF_CALENDARS_TL set

485: X_LAST_UPDATE_LOGIN in number)
486: is
487: begin
488:
489: Update JTF_CALENDARS_TL set
490: calendar_name = nvl(X_CALENDAR_NAME,calendar_name),
491: description = nvl(X_DESCRIPTION,description),
492: last_update_date = nvl(x_last_update_date,sysdate),
493: last_updated_by = x_last_updated_by,

Line 505: delete from JTF_CALENDARS_TL

501: procedure DELETE_ROW (
502: X_CALENDAR_ID in NUMBER
503: ) is
504: begin
505: delete from JTF_CALENDARS_TL
506: where CALENDAR_ID = X_CALENDAR_ID;
507:
508: if (sql%notfound) then
509: raise no_data_found;

Line 523: delete from JTF_CALENDARS_TL T

519:
520: procedure ADD_LANGUAGE
521: is
522: begin
523: delete from JTF_CALENDARS_TL T
524: where not exists
525: (select NULL
526: from JTF_CALENDARS_B B
527: where B.CALENDAR_ID = T.CALENDAR_ID

Line 530: update JTF_CALENDARS_TL T set (

526: from JTF_CALENDARS_B B
527: where B.CALENDAR_ID = T.CALENDAR_ID
528: );
529:
530: update JTF_CALENDARS_TL T set (
531: CALENDAR_NAME,
532: DESCRIPTION
533: ) = (select
534: B.CALENDAR_NAME,

Line 536: from JTF_CALENDARS_TL B

532: DESCRIPTION
533: ) = (select
534: B.CALENDAR_NAME,
535: B.DESCRIPTION
536: from JTF_CALENDARS_TL B
537: where B.CALENDAR_ID = T.CALENDAR_ID
538: and B.LANGUAGE = T.SOURCE_LANG)
539: where (
540: T.CALENDAR_ID,

Line 545: from JTF_CALENDARS_TL SUBB, JTF_CALENDARS_TL SUBT

541: T.LANGUAGE
542: ) in (select
543: SUBT.CALENDAR_ID,
544: SUBT.LANGUAGE
545: from JTF_CALENDARS_TL SUBB, JTF_CALENDARS_TL SUBT
546: where SUBB.CALENDAR_ID = SUBT.CALENDAR_ID
547: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
548: and (SUBB.CALENDAR_NAME <> SUBT.CALENDAR_NAME
549: or (SUBB.CALENDAR_NAME is null and SUBT.CALENDAR_NAME is not null)

Line 556: insert into JTF_CALENDARS_TL (

552: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
553: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
554: ));
555:
556: insert into JTF_CALENDARS_TL (
557: CALENDAR_ID,
558: CALENDAR_NAME,
559: DESCRIPTION,
560: CREATED_BY,

Line 578: from JTF_CALENDARS_TL B, FND_LANGUAGES L

574: B.LAST_UPDATE_DATE,
575: B.LAST_UPDATE_LOGIN,
576: L.LANGUAGE_CODE,
577: B.SOURCE_LANG
578: from JTF_CALENDARS_TL B, FND_LANGUAGES L
579: where L.INSTALLED_FLAG in ('I', 'B')
580: and B.LANGUAGE = userenv('LANG')
581: and not exists
582: (select NULL

Line 583: from JTF_CALENDARS_TL T

579: where L.INSTALLED_FLAG in ('I', 'B')
580: and B.LANGUAGE = userenv('LANG')
581: and not exists
582: (select NULL
583: from JTF_CALENDARS_TL T
584: where T.CALENDAR_ID = B.CALENDAR_ID
585: and T.LANGUAGE = L.LANGUAGE_CODE);
586: end ADD_LANGUAGE;
587: /*************************************************************************/