DBA Data[Home] [Help]

APPS.JTF_NAV_TREE_ROOTS_PKG dependencies on JTF_NAV_TREE_ROOTS_S

Line 18: SELECT jtf_nav_tree_roots_s.nextval

14:
15: l_tree_root_id number := 0;
16:
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,

Line 288: SELECT jtf_nav_tree_roots_s.nextval

284: WHERE root_value = x_root_value;
285:
286: IF (SQL%NOTFOUND) THEN
287: -- Insert new record to _B table
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