APPS.JTF_NAV_TREE_ROOTS_PKG dependencies on JTF_NAV_TREE_ROOTS_TL

Line 41: insert into JTF_NAV_TREE_ROOTS_TL (

37: X_LAST_UPDATE_DATE,
38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN);
40:
41: insert into JTF_NAV_TREE_ROOTS_TL (
42: tree_root_id,
43: ROOT_LABEL,
44: CREATED_BY,
45: CREATION_DATE,

Line 65: from JTF_NAV_TREE_ROOTS_TL T

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

Line 94: update JTF_NAV_TREE_ROOTS_TL set

90: if (sql%notfound) then
91: raise no_data_found;
92: end if;
93:
94: update JTF_NAV_TREE_ROOTS_TL set
95: ROOT_LABEL = X_ROOT_LABEL,
96: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
97: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
98: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 125: from JTF_NAV_TREE_ROOTS_TL

121:
122: cursor c1 is select
123: ROOT_LABEL,
124: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
125: from JTF_NAV_TREE_ROOTS_TL
126: where tree_root_id = x_tree_root_id
127: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
128: for update of tree_root_id nowait;
129: begin

Line 167: delete from JTF_NAV_TREE_ROOTS_TL

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

Line 185: delete from JTF_NAV_TREE_ROOTS_TL T

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

Line 192: update JTF_NAV_TREE_ROOTS_TL T set (

188: from JTF_NAV_TREE_ROOTS_B B
189: where B.tree_root_id = T.tree_root_id
190: );
191:
192: update JTF_NAV_TREE_ROOTS_TL T set (
193: ROOT_LABEL
194: ) = (select
195: B.ROOT_LABEL
196: from JTF_NAV_TREE_ROOTS_TL B

Line 196: from JTF_NAV_TREE_ROOTS_TL B

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

Line 205: from JTF_NAV_TREE_ROOTS_TL SUBB, JTF_NAV_TREE_ROOTS_TL SUBT

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

Line 211: insert into JTF_NAV_TREE_ROOTS_TL (

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

Line 231: from JTF_NAV_TREE_ROOTS_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_TREE_ROOTS_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_TREE_ROOTS_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_TREE_ROOTS_TL T
237: where T.tree_root_id = B.tree_root_id
238: and T.LANGUAGE = L.LANGUAGE_CODE);
239: end ADD_LANGUAGE;
240:

Line 322: UPDATE jtf_nav_tree_roots_tl SET

318: FROM jtf_nav_tree_roots_b
319: WHERE root_value = x_root_value;
320:
321: -- Load The record to _TL table
322: UPDATE jtf_nav_tree_roots_tl SET
323: root_label = x_root_label,
324: last_update_date = sysdate,
325: last_updated_by = user_id,
326: last_update_login = 0,

Line 333: INSERT INTO jtf_nav_tree_roots_tl

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

Line 357: FROM jtf_nav_tree_roots_tl t

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

Line 399: UPDATE jtf_nav_tree_roots_tl SET

395: FROM jtf_nav_tree_roots_b
396: WHERE root_value = x_root_value;
397:
398: -- Update the translation
399: UPDATE jtf_nav_tree_roots_tl SET
400: root_label = x_root_label,
401: last_update_date = sysdate,
402: last_updated_by = user_id,
403: last_update_login = 0,