APPS.JTF_AM_SCREEN_SETUPS_PKG dependencies on JTF_AM_SCREEN_SETUPS_TL

Line 132: insert into JTF_AM_SCREEN_SETUPS_TL (

128: X_LAST_UPDATED_BY,
129: X_LAST_UPDATE_LOGIN
130: );
131:
132: insert into JTF_AM_SCREEN_SETUPS_TL (
133: LAST_UPDATED_BY,
134: LAST_UPDATE_DATE,
135: LAST_UPDATE_LOGIN,
136: SECURITY_GROUP_ID,

Line 158: from JTF_AM_SCREEN_SETUPS_TL T

154: from FND_LANGUAGES L
155: where L.INSTALLED_FLAG in ('I', 'B')
156: and not exists
157: (select NULL
158: from JTF_AM_SCREEN_SETUPS_TL T
159: where T.SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
160: and T.LANGUAGE = L.LANGUAGE_CODE);
161:
162: open c;

Line 251: from JTF_AM_SCREEN_SETUPS_TL

247:
248: cursor c1 is select
249: PREFERENCE_NAME,
250: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
251: from JTF_AM_SCREEN_SETUPS_TL
252: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID
253: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
254: for update of SCREEN_SETUP_ID nowait;
255: begin

Line 436: update JTF_AM_SCREEN_SETUPS_TL set

432: if (sql%notfound) then
433: raise no_data_found;
434: end if;
435:
436: update JTF_AM_SCREEN_SETUPS_TL set
437: PREFERENCE_NAME = X_PREFERENCE_NAME,
438: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
439: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
440: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 454: delete from JTF_AM_SCREEN_SETUPS_TL

450: procedure DELETE_ROW (
451: X_SCREEN_SETUP_ID in NUMBER
452: ) is
453: begin
454: delete from JTF_AM_SCREEN_SETUPS_TL
455: where SCREEN_SETUP_ID = X_SCREEN_SETUP_ID;
456:
457: if (sql%notfound) then
458: raise no_data_found;

Line 472: delete from JTF_AM_SCREEN_SETUPS_TL T

468:
469: procedure ADD_LANGUAGE
470: is
471: begin
472: delete from JTF_AM_SCREEN_SETUPS_TL T
473: where not exists
474: (select NULL
475: from JTF_AM_SCREEN_SETUPS_B B
476: where B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID

Line 479: update JTF_AM_SCREEN_SETUPS_TL T set (

475: from JTF_AM_SCREEN_SETUPS_B B
476: where B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID
477: );
478:
479: update JTF_AM_SCREEN_SETUPS_TL T set (
480: PREFERENCE_NAME
481: ) = (select
482: B.PREFERENCE_NAME
483: from JTF_AM_SCREEN_SETUPS_TL B

Line 483: from JTF_AM_SCREEN_SETUPS_TL B

479: update JTF_AM_SCREEN_SETUPS_TL T set (
480: PREFERENCE_NAME
481: ) = (select
482: B.PREFERENCE_NAME
483: from JTF_AM_SCREEN_SETUPS_TL B
484: where B.SCREEN_SETUP_ID = T.SCREEN_SETUP_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (
487: T.SCREEN_SETUP_ID,

Line 492: from JTF_AM_SCREEN_SETUPS_TL SUBB, JTF_AM_SCREEN_SETUPS_TL SUBT

488: T.LANGUAGE
489: ) in (select
490: SUBT.SCREEN_SETUP_ID,
491: SUBT.LANGUAGE
492: from JTF_AM_SCREEN_SETUPS_TL SUBB, JTF_AM_SCREEN_SETUPS_TL SUBT
493: where SUBB.SCREEN_SETUP_ID = SUBT.SCREEN_SETUP_ID
494: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
495: and (SUBB.PREFERENCE_NAME <> SUBT.PREFERENCE_NAME
496: or (SUBB.PREFERENCE_NAME is null and SUBT.PREFERENCE_NAME is not null)

Line 500: insert into JTF_AM_SCREEN_SETUPS_TL (

496: or (SUBB.PREFERENCE_NAME is null and SUBT.PREFERENCE_NAME is not null)
497: or (SUBB.PREFERENCE_NAME is not null and SUBT.PREFERENCE_NAME is null)
498: ));
499:
500: insert into JTF_AM_SCREEN_SETUPS_TL (
501: LAST_UPDATED_BY,
502: LAST_UPDATE_DATE,
503: LAST_UPDATE_LOGIN,
504: SECURITY_GROUP_ID,

Line 522: from JTF_AM_SCREEN_SETUPS_TL B, FND_LANGUAGES L

518: B.CREATED_BY,
519: B.CREATION_DATE,
520: L.LANGUAGE_CODE,
521: B.SOURCE_LANG
522: from JTF_AM_SCREEN_SETUPS_TL B, FND_LANGUAGES L
523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL

Line 527: from JTF_AM_SCREEN_SETUPS_TL T

523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL
527: from JTF_AM_SCREEN_SETUPS_TL T
528: where T.SCREEN_SETUP_ID = B.SCREEN_SETUP_ID
529: and T.LANGUAGE = L.LANGUAGE_CODE);
530: end ADD_LANGUAGE;
531:

Line 689: Update jtf_am_screen_setups_tl set

685: x_last_updated_by in number,
686: x_last_update_login in number)
687: is
688: begin
689: Update jtf_am_screen_setups_tl set
690: preference_name = nvl(x_preference_name,preference_name),
691: last_update_date = nvl(x_last_update_date,sysdate),
692: last_updated_by = x_last_updated_by,
693: last_update_login = 0,