[Home] [Help]
PACKAGE: APPS.IBC_DIRECTORY_NODE_GRP
Source
1 PACKAGE Ibc_Directory_Node_Grp AUTHID CURRENT_USER AS
2 /* $Header: ibcgdnds.pls 115.5 2003/08/14 18:29:42 enunez ship $ */
3
4 -- Purpose: API to Populate Content Type.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- vicho 11/08/2002 Removed Default GMiss in Type Record
11
12
13 -- Package name : Ibc_Directory_Node_Grp
14 -- Purpose :
15 -- History :
16 -- NOTE :
17 -- End of Comments
18
19
20
21 -- Default number of records fetch per call
22 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23 IBC_APPL_ID NUMBER := 549;
24 G_ROOT_NODE_ID NUMBER := 1;
25
26 TYPE Directory_Node_Rec_Type IS RECORD(
27 DIRECTORY_NODE_ID NUMBER
28 , NODE_TYPE VARCHAR2(30)
29 , NODE_STATUS VARCHAR2(30)
30 , DIRECTORY_PATH VARCHAR2(4000)
31 , DIRECTORY_NODE_CODE VARCHAR2(100)
32 , DIRECTORY_NODE_NAME VARCHAR2(240)
33 , DESCRIPTION VARCHAR2(2000)
34 , CREATED_BY NUMBER
35 , CREATION_DATE DATE
36 , LAST_UPDATED_BY NUMBER
37 , LAST_UPDATE_DATE DATE
38 , LAST_UPDATE_LOGIN NUMBER
39 , OBJECT_VERSION_NUMBER NUMBER
40 );
41
42 G_MISS_Directory_Node_REC Directory_Node_Rec_Type;
43
44 TYPE Directory_Node_TBL_Type IS TABLE OF Directory_Node_Rec_Type;
45
46 G_MISS_Directory_Node_TBL Directory_Node_TBL_Type;
47
48
49 -- *******************************************************
50 -- Start of Comments
51 -- *******************************************************
52 -- API Name: Create_Directory_Node
53 -- Type : Public
54 -- Pre-Req :
55 -- Parameters:
56 -- IN
57 -- p_api_version_number IN NUMBER Required
58 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
59 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
60 -- P_Directory_Node_Rec IN Directory_Node_Rec_Type Required
61 -- P_Sub_Directory_Tbl IN Sub_Directory_Tbl_Type Required
62 --
63 -- OUT:
64 -- x_return_status OUT VARCHAR2
65 -- x_msg_count OUT NUMBER
66 -- x_msg_data OUT VARCHAR2
67 --
68 -- End of Comments
69 --
70 PROCEDURE Create_Directory_Node(
71 P_Api_Version_Number IN NUMBER,
72 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
73 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
74 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
76 p_parent_dir_node_id IN NUMBER DEFAULT 0,
77 x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
78 X_Return_Status OUT NOCOPY VARCHAR2,
79 X_Msg_Count OUT NOCOPY NUMBER,
80 X_Msg_Data OUT NOCOPY VARCHAR2
81 );
82
83
84 -- *******************************************************
85 -- Start of Comments
86 -- *******************************************************
87 -- API Name: Update_Directory_Node
88 -- Type : Public
89 -- Pre-Req :
90 -- Parameters:
91 -- IN
92 -- p_api_version_number IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95 -- P_Directory_Node_Rec IN Directory_Node_Rec_Type Required
96 -- P_Sub_Directory_Tbl IN Sub_Directory_Tbl_Type Required
97 --
98 -- OUT:
99 -- x_return_status OUT VARCHAR2
100 -- x_msg_count OUT NUMBER
101 -- x_msg_data OUT VARCHAR2
102 --
103 -- End of Comments
104 --
105
106
107 PROCEDURE Update_Directory_Node(
108 P_Api_Version_Number IN NUMBER,
109 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
110 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
111 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
113 p_parent_dir_node_id IN NUMBER,
114 x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
115 X_Return_Status OUT NOCOPY VARCHAR2,
116 X_Msg_Count OUT NOCOPY NUMBER,
117 X_Msg_Data OUT NOCOPY VARCHAR2
118 );
119
120 -- *******************************************************
121 -- Start of Comments
122 -- *******************************************************
123 -- API Name: Delete_Directory_Node
124 -- Type : Public
125 -- Pre-Req :
126 -- Parameters:
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- P_Directory_Node_Code IN VARCHAR2 Required
132 --
133 -- OUT:
134 -- x_return_status OUT VARCHAR2
135 -- x_msg_count OUT NUMBER
136 -- x_msg_data OUT VARCHAR2
137 --
138 -- End of Comments
139 --
140
141 PROCEDURE delete_Directory_Node(
142 P_Api_Version_Number IN NUMBER,
143 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 P_Directory_Node_ID IN NUMBER,
147 X_Return_Status OUT NOCOPY VARCHAR2,
148 X_Msg_Count OUT NOCOPY NUMBER,
149 X_Msg_Data OUT NOCOPY VARCHAR2
150 );
151
152 FUNCTION get_directory_node_rec RETURN Ibc_Directory_Node_Grp.Directory_Node_rec_type;
153
154 PROCEDURE Move_Directory_Node(
155 P_Api_Version_Number IN NUMBER,
156 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 p_Current_parent_node_id IN NUMBER,
160 p_New_parent_node_id IN NUMBER,
161 p_Directory_node_id IN NUMBER,
162 X_Return_Status OUT NOCOPY VARCHAR2,
163 X_Msg_Count OUT NOCOPY NUMBER,
164 X_Msg_Data OUT NOCOPY VARCHAR2
165 );
166
167 END Ibc_Directory_Node_Grp;