[Home] [Help]
PACKAGE: APPS.FND_APPTREE
Source
1 PACKAGE fnd_apptree AS
2 /* $Header: AFTREES.pls 120.2 2005/10/24 06:08:36 mzasowsk ship $ */
3
4
5 TYPE node_rec_type IS record (state number
6 ,depth number
7 ,label varchar2(80)
8 ,icon varchar2(30)
9 ,value varchar2(3900)
10 ,type varchar2(30));
11
12 TYPE node_tbl_type IS TABLE OF node_rec_type
13 INDEX BY BINARY_INTEGER;
14
15 PROCEDURE get_folder_properties (l_folder_id number,
16 l_obj_name OUT NOCOPY /* file.sql.39 change */ varchar2,
17 l_node_label OUT NOCOPY /* file.sql.39 change */ varchar2,
18 l_folder_type OUT NOCOPY /* file.sql.39 change */ varchar2,
19 l_value OUT NOCOPY /* file.sql.39 change */ varchar2,
20 l_sequence OUT NOCOPY /* file.sql.39 change */ number,
21 l_parent_folder_id OUT NOCOPY /* file.sql.39 change */ number,
22 l_user_id OUT NOCOPY /* file.sql.39 change */ number,
23 l_public_flag OUT NOCOPY /* file.sql.39 change */ varchar2);
24
25 FUNCTION insert_folder(l_obj_name VARCHAR2,
26 l_node_label VARCHAR2,
27 l_folder_type VARCHAR2,
28 l_value VARCHAR2,
29 l_parent_folder_id NUMBER,
30 l_public_flag VARCHAR2,
31 l_language VARCHAR2,
32 l_user_id NUMBER,
33 after_folder_id NUMBER default null) RETURN NUMBER;
34
35 PROCEDURE update_folder (l_folder_id number,
36 l_user_id number,
37 l_obj_name varchar2 default 'APPTREE_NULL',
38 l_node_label VARCHAR2 default 'APPTREE_NULL',
39 l_folder_type VARCHAR2 default 'APPTREE_NULL',
40 l_value VARCHAR2 default 'APPTREE_NULL',
41 l_sequence NUMBER default -99,
42 l_parent_folder_id NUMBER default -99,
43 l_public_flag VARCHAR2 default 'APPTREE_NULL',
44 l_language VARCHAR2 default 'APPTREE_NULL');
45
46 FUNCTION unique_name(requested_folder_name varchar2,
47 l_parent_folder_id number,
48 l_obj_name varchar2,
49 l_user_id number) return varchar2;
50
51 PROCEDURE delete_folder(l_folder_id number);
52
53 FUNCTION move_folder( l_folder_id number
54 ,l_parent_folder_id number
55 ,after_folder_id number
56 ,l_user_id number
57 ,l_obj_name varchar) return number ;
58
59
60 END fnd_apptree;