APPS.JTF_CAL_SHIFTS_PKG dependencies on JTF_CAL_SHIFTS_TL

Line 193: insert into JTF_CAL_SHIFTS_TL (

189: FND_GLOBAL.USER_ID,
190: NULL
191: );
192:
193: insert into JTF_CAL_SHIFTS_TL (
194: SHIFT_ID,
195: SHIFT_NAME,
196: DESCRIPTION,
197: CREATED_BY,

Line 219: from JTF_CAL_SHIFTS_TL T

215: from FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and not exists
218: (select NULL
219: from JTF_CAL_SHIFTS_TL T
220: where T.SHIFT_ID = X_SHIFT_ID
221: and T.LANGUAGE = L.LANGUAGE_CODE);
222: /*
223: open c;

Line 287: from JTF_CAL_SHIFTS_TL

283: cursor c1 is select
284: SHIFT_NAME,
285: DESCRIPTION,
286: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
287: from JTF_CAL_SHIFTS_TL
288: where SHIFT_ID = X_SHIFT_ID
289: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
290: for update of SHIFT_ID nowait;
291: begin

Line 493: update JTF_CAL_SHIFTS_TL set

489: if (sql%notfound) then
490: raise no_data_found;
491: end if;
492:
493: update JTF_CAL_SHIFTS_TL set
494: SHIFT_NAME = X_SHIFT_NAME,
495: DESCRIPTION = X_DESCRIPTION,
496: LAST_UPDATE_DATE = SYSDATE,
497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 519: Update JTF_CAL_SHIFTS_TL set

515: X_LAST_UPDATE_LOGIN in number)
516: is
517: begin
518:
519: Update JTF_CAL_SHIFTS_TL set
520: shift_name = nvl(X_SHIFT_NAME,shift_name),
521: description = nvl(X_DESCRIPTION,description),
522: last_update_date = nvl(x_last_update_date,sysdate),
523: last_updated_by = x_last_updated_by,

Line 556: delete from JTF_CAL_SHIFTS_TL

552: END IF; -- End of User Hook for DELETE
553: */
554: -- End of comment
555:
556: delete from JTF_CAL_SHIFTS_TL
557: where SHIFT_ID = X_SHIFT_ID;
558:
559: if (sql%notfound) then
560: raise no_data_found;

Line 574: delete from JTF_CAL_SHIFTS_TL T

570:
571: procedure ADD_LANGUAGE
572: is
573: begin
574: delete from JTF_CAL_SHIFTS_TL T
575: where not exists
576: (select NULL
577: from JTF_CAL_SHIFTS_B B
578: where B.SHIFT_ID = T.SHIFT_ID

Line 581: update JTF_CAL_SHIFTS_TL T set (

577: from JTF_CAL_SHIFTS_B B
578: where B.SHIFT_ID = T.SHIFT_ID
579: );
580:
581: update JTF_CAL_SHIFTS_TL T set (
582: SHIFT_NAME,
583: DESCRIPTION
584: ) = (select
585: B.SHIFT_NAME,

Line 587: from JTF_CAL_SHIFTS_TL B

583: DESCRIPTION
584: ) = (select
585: B.SHIFT_NAME,
586: B.DESCRIPTION
587: from JTF_CAL_SHIFTS_TL B
588: where B.SHIFT_ID = T.SHIFT_ID
589: and B.LANGUAGE = T.SOURCE_LANG)
590: where (
591: T.SHIFT_ID,

Line 596: from JTF_CAL_SHIFTS_TL SUBB, JTF_CAL_SHIFTS_TL SUBT

592: T.LANGUAGE
593: ) in (select
594: SUBT.SHIFT_ID,
595: SUBT.LANGUAGE
596: from JTF_CAL_SHIFTS_TL SUBB, JTF_CAL_SHIFTS_TL SUBT
597: where SUBB.SHIFT_ID = SUBT.SHIFT_ID
598: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
599: and (SUBB.SHIFT_NAME <> SUBT.SHIFT_NAME
600: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 605: insert into JTF_CAL_SHIFTS_TL (

601: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
602: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
603: ));
604:
605: insert into JTF_CAL_SHIFTS_TL (
606: SHIFT_ID,
607: SHIFT_NAME,
608: DESCRIPTION,
609: CREATED_BY,

Line 627: from JTF_CAL_SHIFTS_TL B, FND_LANGUAGES L

623: B.LAST_UPDATE_DATE,
624: B.LAST_UPDATE_LOGIN,
625: L.LANGUAGE_CODE,
626: B.SOURCE_LANG
627: from JTF_CAL_SHIFTS_TL B, FND_LANGUAGES L
628: where L.INSTALLED_FLAG in ('I', 'B')
629: and B.LANGUAGE = userenv('LANG')
630: and not exists
631: (select NULL

Line 632: from JTF_CAL_SHIFTS_TL T

628: where L.INSTALLED_FLAG in ('I', 'B')
629: and B.LANGUAGE = userenv('LANG')
630: and not exists
631: (select NULL
632: from JTF_CAL_SHIFTS_TL T
633: where T.SHIFT_ID = B.SHIFT_ID
634: and T.LANGUAGE = L.LANGUAGE_CODE);
635: end ADD_LANGUAGE;
636: /*************************************************************************/