APPS.JTF_NAV_TREE_ROOTS_PKG dependencies on JTF_NAV_TREE_ROOTS_B

Line 21: insert into JTF_NAV_TREE_ROOTS_B (

17: BEGIN
18: SELECT jtf_nav_tree_roots_s.nextval
19: INTO l_tree_root_id
20: FROM dual;
21: insert into JTF_NAV_TREE_ROOTS_B (
22: tree_root_id,
23: ROOT_VALUE,
24: VIEWBY_id,
25: SEQUENCE_NUMBER,

Line 81: update JTF_NAV_TREE_ROOTS_B SET

77: X_LAST_UPDATE_DATE in DATE,
78: X_LAST_UPDATED_BY in NUMBER,
79: X_LAST_UPDATE_LOGIN in NUMBER) is
80: begin
81: update JTF_NAV_TREE_ROOTS_B SET
82: root_value = x_root_value,
83: VIEWBY_id = X_VIEWBY_id,
84: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
85: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 117: from JTF_NAV_TREE_ROOTS_B

113: X_ROOT_LABEL in VARCHAR2) is
114:
115: cursor c IS
116: SELECT root_value, VIEWBY_id, SEQUENCE_NUMBER
117: from JTF_NAV_TREE_ROOTS_B
118: where tree_root_id = x_tree_root_id
119: for update of tree_root_id nowait;
120: recinfo c%rowtype;
121:

Line 174: delete from JTF_NAV_TREE_ROOTS_B

170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: delete from JTF_NAV_TREE_ROOTS_B
175: where tree_root_id = X_tree_ROOT_id;
176:
177: if (sql%notfound) then
178: raise no_data_found;

Line 188: from JTF_NAV_TREE_ROOTS_B B

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
190: );
191:
192: update JTF_NAV_TREE_ROOTS_TL T set (

Line 278: UPDATE jtf_nav_tree_roots_b SET

274: FROM jtf_nav_viewbys_b
275: WHERE viewby_value = x_viewby_value;
276:
277: -- Load The record to _B table
278: UPDATE jtf_nav_tree_roots_b SET
279: viewby_id = l_viewby_id,
280: sequence_number = x_sequence_number,
281: last_update_date = sysdate,
282: last_updated_by = user_id,

Line 292: INSERT INTO jtf_nav_tree_roots_b

288: SELECT jtf_nav_tree_roots_s.nextval
289: INTO l_tree_root_id
290: FROM dual;
291:
292: INSERT INTO jtf_nav_tree_roots_b
293: (tree_root_id,
294: root_value,
295: viewby_id,
296: sequence_number,

Line 318: FROM jtf_nav_tree_roots_b

314:
315: --select the tree root id
316: SELECT tree_root_id
317: INTO l_tree_root_id
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

Line 395: FROM jtf_nav_tree_roots_b

391:
392: --select the tree root id
393: SELECT tree_root_id
394: INTO l_tree_root_id
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