APPS.JTF_NAV_TABS_PKG dependencies on JTF_NAV_TABS_TL

Line 51: insert into JTF_NAV_TABS_TL (

47: X_LAST_UPDATE_DATE,
48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN);
50:
51: insert into JTF_NAV_TABS_TL (
52: CREATED_BY,
53: CREATION_DATE,
54: LAST_UPDATE_LOGIN,
55: LAST_UPDATE_DATE,

Line 75: from JTF_NAV_TABS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from JTF_NAV_TABS_TL T
76: where T.TAB_id = l_tab_id
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: end INSERT_ROW;

Line 108: update JTF_NAV_TABS_TL set

104: if (sql%notfound) then
105: raise no_data_found;
106: end if;
107:
108: update JTF_NAV_TABS_TL set
109: TAB_LABEL = X_TAB_LABEL,
110: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
111: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
112: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 141: from JTF_NAV_TABS_TL

137:
138: cursor c1 is select
139: TAB_LABEL,
140: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
141: from JTF_NAV_TABS_TL
142: where TAB_id = X_TAB_id
143: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
144: for update of TAB_id nowait;
145: begin

Line 183: delete from JTF_NAV_TABS_TL

179: end LOCK_ROW;
180:
181: procedure DELETE_ROW (X_TAB_id in NUMBER) IS
182: begin
183: delete from JTF_NAV_TABS_TL
184: where TAB_id = X_TAB_id;
185:
186: if (sql%notfound) then
187: raise no_data_found;

Line 201: delete from JTF_NAV_TABS_TL T

197:
198: procedure ADD_LANGUAGE
199: is
200: begin
201: delete from JTF_NAV_TABS_TL T
202: where not exists
203: (select NULL
204: from JTF_NAV_TABS_B B
205: where B.TAB_id = T.TAB_id

Line 208: update JTF_NAV_TABS_TL T set (

204: from JTF_NAV_TABS_B B
205: where B.TAB_id = T.TAB_id
206: );
207:
208: update JTF_NAV_TABS_TL T set (
209: TAB_LABEL
210: ) = (select
211: B.TAB_LABEL
212: from JTF_NAV_TABS_TL B

Line 212: from JTF_NAV_TABS_TL B

208: update JTF_NAV_TABS_TL T set (
209: TAB_LABEL
210: ) = (select
211: B.TAB_LABEL
212: from JTF_NAV_TABS_TL B
213: where B.TAB_id = T.TAB_id
214: and B.LANGUAGE = T.SOURCE_LANG)
215: where (
216: T.TAB_id,

Line 221: from JTF_NAV_TABS_TL SUBB, JTF_NAV_TABS_TL SUBT

217: T.LANGUAGE
218: ) in (select
219: SUBT.TAB_id,
220: SUBT.LANGUAGE
221: from JTF_NAV_TABS_TL SUBB, JTF_NAV_TABS_TL SUBT
222: where SUBB.TAB_id = SUBT.TAB_id
223: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
224: and (SUBB.TAB_LABEL <> SUBT.TAB_LABEL
225: ));

Line 227: insert into JTF_NAV_TABS_TL (

223: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
224: and (SUBB.TAB_LABEL <> SUBT.TAB_LABEL
225: ));
226:
227: insert into JTF_NAV_TABS_TL (
228: CREATED_BY,
229: CREATION_DATE,
230: LAST_UPDATE_LOGIN,
231: LAST_UPDATE_DATE,

Line 247: from JTF_NAV_TABS_TL B, FND_LANGUAGES L

243: B.TAB_id,
244: B.TAB_LABEL,
245: L.LANGUAGE_CODE,
246: B.SOURCE_LANG
247: from JTF_NAV_TABS_TL B, FND_LANGUAGES L
248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL

Line 252: from JTF_NAV_TABS_TL T

248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL
252: from JTF_NAV_TABS_TL T
253: where T.TAB_id = B.TAB_id
254: and T.LANGUAGE = L.LANGUAGE_CODE);
255: end ADD_LANGUAGE;
256:

Line 339: UPDATE jtf_nav_tabs_tl SET

335: FROM jtf_nav_tabs_b
336: WHERE tab_value = x_tab_value;
337:
338: -- Load The record to _TL table
339: UPDATE jtf_nav_tabs_tl SET
340: tab_label = x_tab_label,
341: last_update_date = sysdate,
342: last_updated_by = user_id,
343: last_update_login = 0,

Line 350: INSERT INTO jtf_nav_tabs_tl

346: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
347:
348: IF (SQL%NOTFOUND) THEN
349: -- Insert new record to _TL table
350: INSERT INTO jtf_nav_tabs_tl
351: (tab_id,
352: tab_label,
353: creation_date,
354: created_by,

Line 374: FROM jtf_nav_tabs_tl t

370: FROM fnd_languages l
371: WHERE l.installed_flag IN ('I', 'B')
372: AND NOT EXISTS
373: (SELECT NULL
374: FROM jtf_nav_tabs_tl t
375: WHERE t.tab_id = l_tab_id
376: AND t.language = l.language_code);
377: END IF;
378: << end_load_row >>

Line 416: UPDATE jtf_nav_tabs_tl SET

412: FROM jtf_nav_tabs_b
413: WHERE tab_value = x_tab_value;
414:
415: -- Update the translation
416: UPDATE jtf_nav_tabs_tl SET
417: tab_label = x_tab_label,
418: last_update_date = sysdate,
419: last_updated_by = user_id,
420: last_update_login = 0,