1 PACKAGE CN_PLAN_TEXTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvspts.pls 115.9 2002/11/21 21:18:55 hlchen ship $ */
3
4 TYPE plan_text_rec_type IS RECORD
5 (
6 PLAN_TEXT_ID NUMBER := NULL,
7 ROLE_ID NUMBER := NULL,
8 SEQUENCE_ID NUMBER := NULL,
9 QUOTA_CATEGORY_ID NUMBER := NULL,
10 TEXT_TYPE CN_PLAN_TEXTS.TEXT_TYPE%TYPE := NULL,
11 TEXT CN_PLAN_TEXTS.TEXT%TYPE := NULL,
12 TEXT2 CN_PLAN_TEXTS.TEXT2%TYPE := NULL,
13 OBJECT_VERSION_NUMBER NUMBER := NULL,
14 ROLE_MODEL_ID NUMBER := NULL
15 );
16
17 TYPE plan_text_tbl_type IS
18 TABLE OF plan_text_rec_type INDEX BY BINARY_INTEGER;
19
20
21 TYPE quota_cate_rec_type IS RECORD
22 (
23 QUOTA_CATE_ID NUMBER := NULL,
24 QUOTA_NAME VARCHAR2(80) := NULL
25 );
26
27 TYPE quota_cate_tbl_type IS
28 TABLE OF quota_cate_rec_type INDEX BY BINARY_INTEGER;
29
30 -- Global variable that represent missing values.
31
32 G_MISS_PLAN_TEXT_REC plan_text_rec_type;
33 G_MISS_PLAN_TEXT_TBL plan_text_tbl_type;
34 G_MISS_QUOTA_CATE_REC quota_cate_rec_type;
35 G_MISS_QUOTA_CATE_TBL quota_cate_tbl_type;
36
37
38 -- Start of comments
39 -- API name : Create_Plan_Text
40 -- Type : Private.
41 -- Function :
42 -- Pre-reqs : None.
43 -- Parameters :
44 -- IN : p_api_version IN NUMBER Required
45 -- p_init_msg_list IN VARCHAR2 Optional
46 -- Default = FND_API.G_FALSE
47 -- p_commit IN VARCHAR2 Optional
48 -- Default = FND_API.G_FALSE
49 -- p_validation_level IN NUMBER Optional
50 -- Default = FND_API.G_VALID_LEVEL_FULL
51 -- p_plan_text IN plan_text_rec_type
52 -- OUT : x_return_status OUT VARCHAR2(1)
53 -- x_msg_count OUT NUMBER
54 -- x_msg_data OUT VARCHAR2(2000)
55 -- Version : Current version 1.0
56 -- Notes : Note text
57 --
58 -- End of comments
59 PROCEDURE Create_Plan_Text
60 (p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_plan_text IN plan_text_rec_type,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69
70
71 -- Start of comments
72 -- API name : Update_Plan_Text
73 -- Type : Private.
74 -- Function :
75 -- Pre-reqs : None.
76 -- Parameters :
77 -- IN : p_api_version IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2 Optional
79 -- Default = FND_API.G_FALSE
80 -- p_commit IN VARCHAR2 Optional
81 -- Default = FND_API.G_FALSE
82 -- p_validation_level IN NUMBER Optional
83 -- Default = FND_API.G_VALID_LEVEL_FULL
84 -- p_plan_text IN plan_text_rec_type
85 -- OUT : x_return_status OUT VARCHAR2(1)
86 -- x_msg_count OUT NUMBER
87 -- x_msg_data OUT VARCHAR2(2000)
88 -- Version : Current version 1.0
89 -- Notes : Note text
90 --
91 -- End of comments
92 PROCEDURE Update_Plan_Text
93 (p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97 p_plan_text IN plan_text_rec_type,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2 );
101
102
103
104 -- Start of comments
105 -- API name : Delete_Plan_Text
106 -- Type : Private.
107 -- Function :
108 -- Pre-reqs : None.
109 -- Parameters :
110 -- IN : p_api_version IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- Default = FND_API.G_FALSE
113 -- p_commit IN VARCHAR2 Optional
114 -- Default = FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Optional
116 -- Default = FND_API.G_VALID_LEVEL_FULL
117 -- p_plan_text IN plan_text_rec_type
118 -- OUT : x_return_status OUT VARCHAR2(1)
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2(2000)
121 -- Version : Current version 1.0
122 -- Notes : Note text
123 --
124 -- End of comments
125 PROCEDURE Delete_Plan_Text
126 (p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128 p_commit IN VARCHAR2 := FND_API.G_FALSE,
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 p_plan_text IN plan_text_rec_type,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2);
134
135
136
137 -- Start of comments
138 -- API name : Get_Plan_Texts
139 -- Type : Private.
140 -- Function :
141 -- Pre-reqs : None.
142 -- Parameters :
143 -- IN : p_api_version IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional
145 -- Default = FND_API.G_FALSE
146 -- p_commit IN VARCHAR2 Optional
147 -- Default = FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional
149 -- Default = FND_API.G_VALID_LEVEL_FULL
150 -- p_role_id IN NUMBER
151 -- p_role_model_id IN NUMBER
152 -- OUT : x_return_status OUT VARCHAR2(1)
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2(2000)
155 -- x_plan_texts OUT plan_text_tbl_type
156 -- x_updatable OUT VARCHAR2(1)
157 -- Version : Current version 1.0
158 -- Notes : Note text
159 --
160 -- End of comments
161 PROCEDURE Get_Plan_Texts
162 (p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164 p_commit IN VARCHAR2 := FND_API.G_FALSE,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 p_role_id IN NUMBER,
167 p_role_model_id IN NUMBER,
168 x_plan_texts OUT NOCOPY plan_text_tbl_type,
169 x_updatable OUT NOCOPY VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2);
173
174
175 -- Start of comments
176 -- API name : Get_Fixed_Quota_Cates
177 -- Type : Private.
178 -- Function :
179 -- Pre-reqs : None.
180 -- Parameters :
181 -- IN : p_api_version IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional
183 -- Default = FND_API.G_FALSE
184 -- p_commit IN VARCHAR2 Optional
185 -- Default = FND_API.G_FALSE
186 -- p_validation_level IN NUMBER Optional
187 -- Default = FND_API.G_VALID_LEVEL_FULL
188 -- p_role_id IN NUMBER
189 -- p_role_model_id IN NUMBER
190 -- OUT : x_return_status OUT VARCHAR2(1)
191 -- x_msg_count OUT NUMBER
192 -- x_msg_data OUT VARCHAR2(2000)
193 -- x_quota_cates OUT quota_cate_tbl_type
194 -- Version : Current version 1.0
195 -- Notes : Note text
196 --
197 -- End of comments
198 PROCEDURE Get_Fixed_Quota_Cates (
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 p_role_id IN NUMBER,
204 p_role_model_id IN NUMBER,
205 x_quota_cates OUT NOCOPY quota_cate_tbl_type,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2);
209
210
211 -- Start of comments
212 -- API name : Get_Var_Quota_Cates
213 -- Type : Private.
214 -- Function :
215 -- Pre-reqs : None.
216 -- Parameters :
217 -- IN : p_api_version IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional
219 -- Default = FND_API.G_FALSE
220 -- p_commit IN VARCHAR2 Optional
221 -- Default = FND_API.G_FALSE
222 -- p_validation_level IN NUMBER Optional
223 -- Default = FND_API.G_VALID_LEVEL_FULL
224 -- p_role_id IN NUMBER
225 -- p_role_model_id IN NUMBER
226 -- OUT : x_return_status OUT VARCHAR2(1)
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2(2000)
229 -- x_quota_cates OUT quota_cate_tbl_type
230 -- Version : Current version 1.0
231 -- Notes : Note text
232 --
233 -- End of comments
234 PROCEDURE Get_Var_Quota_Cates (
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237 p_commit IN VARCHAR2 := FND_API.G_FALSE,
238 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
239 p_role_id IN NUMBER,
240 p_role_model_id IN NUMBER,
241 x_quota_cates OUT NOCOPY quota_cate_tbl_type,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2);
245
246 -- Start of comments
247 -- API name : Get_Quota_Cates
248 -- Type : Private.
249 -- Function :
250 -- Pre-reqs : None.
251 -- Parameters :
252 -- IN : p_api_version IN NUMBER Required
253 -- p_init_msg_list IN VARCHAR2 Optional
254 -- Default = FND_API.G_FALSE
255 -- p_commit IN VARCHAR2 Optional
256 -- Default = FND_API.G_FALSE
257 -- p_validation_level IN NUMBER Optional
258 -- Default = FND_API.G_VALID_LEVEL_FULL
259 -- p_role_id IN NUMBER
260 -- p_role_model_id IN NUMBER
261 -- OUT : x_return_status OUT VARCHAR2(1)
262 -- x_msg_count OUT NUMBER
263 -- x_msg_data OUT VARCHAR2(2000)
264 -- x_quota_cates OUT quota_cate_tbl_type
265 -- Version : Current version 1.0
266 -- Notes : Note text
267 --
268 -- End of comments
269 PROCEDURE Get_Quota_Cates (
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 p_commit IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 p_role_id IN NUMBER,
275 p_role_model_id IN NUMBER,
276 p_quota_cate_type IN VARCHAR2,
277 x_quota_cates OUT NOCOPY quota_cate_tbl_type,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2);
281
282
283 -- Start of comments
284 -- API name : Get_Role_Name
285 -- Type : Private.
286 -- Function :
287 -- Pre-reqs : None.
288 -- Parameters :
289 -- IN : p_api_version IN NUMBER Required
290 -- p_init_msg_list IN VARCHAR2 Optional
291 -- Default = FND_API.G_FALSE
292 -- p_commit IN VARCHAR2 Optional
293 -- Default = FND_API.G_FALSE
294 -- p_validation_level IN NUMBER Optional
295 -- Default = FND_API.G_VALID_LEVEL_FULL
296 -- p_role_id IN NUMBER
297 -- p_role_model_id IN NUMBER
298 -- OUT : x_return_status OUT VARCHAR2(1)
299 -- x_msg_count OUT NUMBER
300 -- x_msg_data OUT VARCHAR2(2000)
304 --
301 -- x_role_name OUT VARCHAR2(80)
302 -- Version : Current version 1.0
303 -- Notes : Note text
305 -- End of comments
306 PROCEDURE Get_Role_Name
307 (p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309 p_commit IN VARCHAR2 := FND_API.G_FALSE,
313 x_role_name OUT NOCOPY VARCHAR2,
310 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311 p_role_id IN NUMBER,
312 p_role_model_id IN NUMBER,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2);
317
318
319 -- Start of comments
320 -- API name : Get_Plan_Text
321 -- Type : Private.
322 -- Function :
323 -- Pre-reqs : None.
324 -- Parameters :
325 -- IN :
326 -- p_role_id IN NUMBER Required
327 -- p_text_type IN VARCHAR2 Optional
328 -- p_role_model_id IN NUMBER Optional
329 -- p_quota_category_id IN NUMBER Optional
330 -- Version : Current version 1.0
331 -- Notes : Returns the value of the plan text else null.
332 --
333 -- End of comments
334 FUNCTION Get_Text (
335 p_role_id IN NUMBER,
336 p_text_type IN VARCHAR2,
337 p_quota_category_id IN NUMBER := NULL,
338 p_role_model_id IN NUMBER := NULL)
339 RETURN VARCHAR2 ;
340
341
342
343 END CN_PLAN_TEXTS_PVT;