APPS.JTF_NAV_VIEWBYS_PKG dependencies on JTF_NAV_VIEWBYS_TL

Line 42: insert into JTF_NAV_VIEWBYS_TL (

38: X_LAST_UPDATE_DATE,
39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN);
41:
42: insert into JTF_NAV_VIEWBYS_TL (
43: viewby_id,
44: VIEWBY_LABEL,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from JTF_NAV_VIEWBYS_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from JTF_NAV_VIEWBYS_TL T
67: where T.VIEWBY_id = l_viewby_id
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: end INSERT_ROW;

Line 95: update JTF_NAV_VIEWBYS_TL set

91: if (sql%notfound) then
92: raise no_data_found;
93: end if;
94:
95: update JTF_NAV_VIEWBYS_TL set
96: VIEWBY_LABEL = X_VIEWBY_LABEL,
97: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
98: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
99: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 126: from JTF_NAV_VIEWBYS_TL

122:
123: cursor c1 is select
124: VIEWBY_LABEL,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from JTF_NAV_VIEWBYS_TL
127: where VIEWBY_id = X_VIEWBY_id
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of VIEWBY_id nowait;
130: begin

Line 167: delete from JTF_NAV_VIEWBYS_TL

163:
164: procedure DELETE_ROW (
165: X_VIEWBY_id in number) is
166: begin
167: delete from JTF_NAV_VIEWBYS_TL
168: where VIEWBY_id = X_VIEWBY_id;
169:
170: if (sql%notfound) then
171: raise no_data_found;

Line 185: delete from JTF_NAV_VIEWBYS_TL T

181:
182: procedure ADD_LANGUAGE
183: is
184: begin
185: delete from JTF_NAV_VIEWBYS_TL T
186: where not exists
187: (select NULL
188: from JTF_NAV_VIEWBYS_B B
189: where B.VIEWBY_id = T.VIEWBY_id

Line 192: update JTF_NAV_VIEWBYS_TL T set (

188: from JTF_NAV_VIEWBYS_B B
189: where B.VIEWBY_id = T.VIEWBY_id
190: );
191:
192: update JTF_NAV_VIEWBYS_TL T set (
193: VIEWBY_LABEL
194: ) = (select
195: B.VIEWBY_LABEL
196: from JTF_NAV_VIEWBYS_TL B

Line 196: from JTF_NAV_VIEWBYS_TL B

192: update JTF_NAV_VIEWBYS_TL T set (
193: VIEWBY_LABEL
194: ) = (select
195: B.VIEWBY_LABEL
196: from JTF_NAV_VIEWBYS_TL B
197: where B.VIEWBY_id = T.VIEWBY_id
198: and B.LANGUAGE = T.SOURCE_LANG)
199: where (
200: T.VIEWBY_id,

Line 205: from JTF_NAV_VIEWBYS_TL SUBB, JTF_NAV_VIEWBYS_TL SUBT

201: T.LANGUAGE
202: ) in (select
203: SUBT.VIEWBY_id,
204: SUBT.LANGUAGE
205: from JTF_NAV_VIEWBYS_TL SUBB, JTF_NAV_VIEWBYS_TL SUBT
206: where SUBB.VIEWBY_id = SUBT.VIEWBY_id
207: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
208: and (SUBB.VIEWBY_LABEL <> SUBT.VIEWBY_LABEL
209: ));

Line 211: insert into JTF_NAV_VIEWBYS_TL (

207: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
208: and (SUBB.VIEWBY_LABEL <> SUBT.VIEWBY_LABEL
209: ));
210:
211: insert into JTF_NAV_VIEWBYS_TL (
212: VIEWBY_id,
213: VIEWBY_LABEL,
214: CREATED_BY,
215: CREATION_DATE,

Line 231: from JTF_NAV_VIEWBYS_TL B, FND_LANGUAGES L

227: B.LAST_UPDATE_DATE,
228: B.LAST_UPDATED_BY,
229: L.LANGUAGE_CODE,
230: B.SOURCE_LANG
231: from JTF_NAV_VIEWBYS_TL B, FND_LANGUAGES L
232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL

Line 236: from JTF_NAV_VIEWBYS_TL T

232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL
236: from JTF_NAV_VIEWBYS_TL T
237: where T.VIEWBY_id = B.VIEWBY_id
238: and T.LANGUAGE = L.LANGUAGE_CODE);
239: end ADD_LANGUAGE;
240:

Line 323: UPDATE jtf_nav_viewbys_tl SET

319: FROM jtf_nav_viewbys_b
320: WHERE viewby_value = x_viewby_value;
321:
322: -- Load The record to _TL table
323: UPDATE jtf_nav_viewbys_tl SET
324: viewby_label = x_viewby_label,
325: last_update_date = sysdate,
326: last_updated_by = user_id,
327: last_update_login = 0,

Line 334: INSERT INTO jtf_nav_viewbys_tl

330: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
331:
332: IF (SQL%NOTFOUND) THEN
333: -- Insert new record to _TL table
334: INSERT INTO jtf_nav_viewbys_tl
335: (viewby_id,
336: viewby_label,
337: creation_date,
338: created_by,

Line 358: FROM jtf_nav_viewbys_tl t

354: FROM fnd_languages l
355: WHERE l.installed_flag IN ('I', 'B')
356: AND NOT EXISTS
357: (SELECT NULL
358: FROM jtf_nav_viewbys_tl t
359: WHERE t.viewby_id = l_viewby_id
360: AND t.language = l.language_code);
361: END IF;
362: << end_load_row >>

Line 400: UPDATE jtf_nav_viewbys_tl SET

396: FROM jtf_nav_viewbys_b
397: WHERE viewby_value = x_viewby_value;
398:
399: -- Update the translation
400: UPDATE jtf_nav_viewbys_tl SET
401: viewby_label = x_viewby_label,
402: last_update_date = sysdate,
403: last_updated_by = user_id,
404: last_update_login = 0,