APPS.FND_APPTREE dependencies on FND_TREE_FOLDERS

Line 16: from fnd_tree_folders

12: l_public_flag OUT NOCOPY /* file.sql.39 change */ varchar2) IS
13: cursor props is
14: select obj_name, node_label, folder_type,
15: value, sequence, parent_folder_id, created_by, public_flag
16: from fnd_tree_folders
17: where folder_id = l_folder_id;
18: BEGIN
19: open props;
20: fetch props into l_obj_name, l_node_label, l_folder_type,

Line 43: from fnd_tree_folders

39: l_folder_id number;
40: l_after_seq number;
41: cursor max_seq_null_parent is
42: select max(sequence)
43: from fnd_tree_folders
44: where created_by = l_user_id
45: and parent_folder_id is null
46: and obj_name = l_obj_name;
47: cursor max_seq_in_parent is

Line 49: from fnd_tree_folders

45: and parent_folder_id is null
46: and obj_name = l_obj_name;
47: cursor max_seq_in_parent is
48: select max(sequence)
49: from fnd_tree_folders
50: where parent_folder_id = l_parent_folder_id;
51: cursor seq_of_folder is
52: select sequence
53: from fnd_tree_folders

Line 53: from fnd_tree_folders

49: from fnd_tree_folders
50: where parent_folder_id = l_parent_folder_id;
51: cursor seq_of_folder is
52: select sequence
53: from fnd_tree_folders
54: where folder_id = after_folder_id;
55: cursor next_seq_null_parent is
56: select min(sequence)
57: from fnd_tree_folders

Line 57: from fnd_tree_folders

53: from fnd_tree_folders
54: where folder_id = after_folder_id;
55: cursor next_seq_null_parent is
56: select min(sequence)
57: from fnd_tree_folders
58: where created_by = l_user_id
59: and parent_folder_id is null
60: and obj_name = l_obj_name
61: and sequence > l_after_seq;

Line 64: from fnd_tree_folders

60: and obj_name = l_obj_name
61: and sequence > l_after_seq;
62: cursor next_seq_in_parent is
63: select min(sequence)
64: from fnd_tree_folders
65: where parent_folder_id = l_parent_folder_id
66: and sequence > l_after_seq;
67: cursor next_folder_id is
68: select fnd_tree_folders_s.nextval

Line 68: select fnd_tree_folders_s.nextval

64: from fnd_tree_folders
65: where parent_folder_id = l_parent_folder_id
66: and sequence > l_after_seq;
67: cursor next_folder_id is
68: select fnd_tree_folders_s.nextval
69: from dual;
70: BEGIN
71: --
72: -- Determine the next sequence number.

Line 135: insert into fnd_tree_folders(

131: open next_folder_id;
132: fetch next_folder_id into l_folder_id;
133: close next_folder_id;
134: --
135: insert into fnd_tree_folders(
136: folder_id,
137: obj_name,
138: node_label,
139: folder_type,

Line 182: update fnd_tree_folders

178: l_public_flag VARCHAR2 default 'APPTREE_NULL',
179: l_language VARCHAR2 default 'APPTREE_NULL') IS
180: PRAGMA AUTONOMOUS_TRANSACTION;
181: BEGIN
182: update fnd_tree_folders
183: set
184: obj_name = decode(l_obj_name, 'APPTREE_NULL', obj_name, l_obj_name),
185: node_label = decode(l_node_label, 'APPTREE_NULL', node_label, l_node_label),
186: folder_type = decode(l_folder_type, 'APPTREE_NULL', folder_type, l_folder_type),

Line 205: from fnd_tree_folders

201: l_user_id number) return varchar2 is
202: trouble varchar2(1) := null;
203: cursor matches is
204: select '1'
205: from fnd_tree_folders
206: where ((l_parent_folder_id is null and parent_folder_id is null)
207: or (l_parent_folder_id is not null and parent_folder_id = l_parent_folder_id))
208: and obj_name = l_obj_name
209: and created_by = l_user_id

Line 228: from fnd_tree_folders f

224: PROCEDURE delete_folder(l_folder_id number) is
225: PRAGMA AUTONOMOUS_TRANSACTION;
226: BEGIN
227: delete
228: from fnd_tree_folders f
229: where f.folder_id in
230: (select h.folder_id
231: from fnd_tree_folders h
232: start with h.folder_id = l_folder_id

Line 231: from fnd_tree_folders h

227: delete
228: from fnd_tree_folders f
229: where f.folder_id in
230: (select h.folder_id
231: from fnd_tree_folders h
232: start with h.folder_id = l_folder_id
233: connect by prior h.folder_id = h.parent_folder_id);
234: --
235: commit;

Line 248: from fnd_tree_folders

244: l_next_seq number;
245: l_after_seq number;
246: cursor max_seq_null_parent is
247: select max(sequence)
248: from fnd_tree_folders
249: where created_by = l_user_id
250: and parent_folder_id is null
251: and obj_name = l_obj_name;
252: cursor max_seq_in_parent is

Line 254: from fnd_tree_folders

250: and parent_folder_id is null
251: and obj_name = l_obj_name;
252: cursor max_seq_in_parent is
253: select max(sequence)
254: from fnd_tree_folders
255: where parent_folder_id = l_parent_folder_id;
256: cursor seq_of_folder is
257: select sequence
258: from fnd_tree_folders

Line 258: from fnd_tree_folders

254: from fnd_tree_folders
255: where parent_folder_id = l_parent_folder_id;
256: cursor seq_of_folder is
257: select sequence
258: from fnd_tree_folders
259: where folder_id = after_folder_id;
260: cursor next_seq_null_parent is
261: select min(sequence)
262: from fnd_tree_folders

Line 262: from fnd_tree_folders

258: from fnd_tree_folders
259: where folder_id = after_folder_id;
260: cursor next_seq_null_parent is
261: select min(sequence)
262: from fnd_tree_folders
263: where created_by = l_user_id
264: and parent_folder_id is null
265: and obj_name = l_obj_name
266: and sequence > l_after_seq;

Line 269: from fnd_tree_folders

265: and obj_name = l_obj_name
266: and sequence > l_after_seq;
267: cursor next_seq_in_parent is
268: select min(sequence)
269: from fnd_tree_folders
270: where parent_folder_id = l_parent_folder_id
271: and sequence > l_after_seq;
272: BEGIN
273: --

Line 331: UPDATE fnd_tree_folders

327: l_next_seq := (l_next_seq + l_after_seq) / 2.0;
328: end if;
329: end if;
330:
331: UPDATE fnd_tree_folders
332: SET parent_folder_id = l_parent_folder_id
333: ,sequence = l_next_seq
334: ,last_update_date = sysdate
335: ,last_updated_by = l_user_id