[Home] [Help]
PACKAGE: APPS.CSC_PROF_MODULE_GROUPS_PVT
Source
1 PACKAGE CSC_PROF_MODULE_GROUPS_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpmgs.pls 115.15 2002/12/09 08:43:50 agaddam ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_MODULE_GROUPS_PVT
5 -- Purpose :
6 -- History :
7 -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
8 -- from the definition for the performance reason
9 -- NOTE :
10 -- End of Comments
11
12 -- Default number of records fetch per call
13 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
14 -- *******************************************************
15 -- Start of Comments
16 -- -------------------------------------------------------
17 -- Record name:PROF_MODULE_GRP_Rec_Type
18 -- -------------------------------------------------------
19 -- Parameters:
20 -- MODULE_GROUP_ID
21 -- FORM_FUNCTION_ID
22 -- PARTY_TYPE
23 -- GROUP_ID
24 -- DASHBOARD_GROUP_FLAG
25 -- CURRENCY_CODE
26 -- LAST_UPDATE_DATE
27 -- LAST_UPDATED_BY
28 -- CREATION_DATE
29 -- CREATED_BY
30 -- LAST_UPDATE_LOGIN
31 -- SEEDED_FLAG
32 -- APPLICATION_ID
33 -- DASHBOARD_GROUP_ID
34 --
35 -- Required:
36 -- Defaults:
37 --
38 -- End of Comments
39
40 TYPE PROF_MODULE_GRP_Rec_Type IS RECORD
41 (
42 MODULE_GROUP_ID NUMBER,
43 FORM_FUNCTION_ID NUMBER,
44 FORM_FUNCTION_NAME VARCHAR2(30),
45 RESPONSIBILITY_ID NUMBER,
46 RESP_APPL_ID NUMBER,
47 PARTY_TYPE VARCHAR2(30),
48 GROUP_ID NUMBER,
49 DASHBOARD_GROUP_FLAG VARCHAR2(3),
50 CURRENCY_CODE VARCHAR2(15),
51 LAST_UPDATE_DATE DATE,
52 LAST_UPDATED_BY NUMBER,
53 CREATION_DATE DATE,
54 CREATED_BY NUMBER,
55 LAST_UPDATE_LOGIN NUMBER,
56 SEEDED_FLAG VARCHAR2(3),
57 APPLICATION_ID NUMBER,
58 DASHBOARD_GROUP_ID NUMBER
59 );
60
61 G_MISS_PROF_MODULE_GRP_REC PROF_MODULE_GRP_Rec_Type;
62 TYPE PROF_MODULE_GRP_Tbl_Type IS TABLE OF PROF_MODULE_GRP_Rec_Type
63 INDEX BY BINARY_INTEGER;
64 G_MISS_PROF_MODULE_GRP_TBL PROF_MODULE_GRP_Tbl_Type;
65
66 -- *******************************************************
67 -- Start of Comments
68 -- *******************************************************
69 -- API Name: Create_prof_module_groups
70 -- Type : Private
71 -- Pre-Req :
72 -- Parameters:
73 -- IN
74 -- p_api_version_number IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
79 --
80 -- OUT:
81 -- x_return_status OUT VARCHAR2
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2
84 --
85 -- End of Comments
86 --
87
88 PROCEDURE Create_prof_module_groups(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
92 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
93 PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
94 p_FORM_FUNCTION_ID NUMBER,
95 p_FORM_FUNCTION_NAME VARCHAR2,
96 p_RESPONSIBILITY_ID NUMBER,
97 p_RESP_APPL_ID NUMBER,
98 p_PARTY_TYPE VARCHAR2,
99 p_GROUP_ID NUMBER,
100 p_DASHBOARD_GROUP_FLAG VARCHAR2,
101 p_CURRENCY_CODE VARCHAR2,
102 p_LAST_UPDATE_DATE DATE,
103 p_LAST_UPDATED_BY NUMBER,
104 p_CREATION_DATE DATE,
105 p_CREATED_BY NUMBER,
106 p_LAST_UPDATE_LOGIN NUMBER,
107 p_SEEDED_FLAG VARCHAR2,
108 p_APPLICATION_ID NUMBER,
109 p_DASHBOARD_GROUP_ID NUMBER,
110 X_Return_Status OUT NOCOPY VARCHAR2,
111 X_Msg_Count OUT NOCOPY NUMBER,
112 X_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115
116 PROCEDURE Create_prof_module_groups(
117 P_Api_Version_Number IN NUMBER,
118 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
119 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
120 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
121 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type := G_MISS_PROF_MODULE_GRP_REC,
122 PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
123 X_Return_Status OUT NOCOPY VARCHAR2,
124 X_Msg_Count OUT NOCOPY NUMBER,
125 X_Msg_Data OUT NOCOPY VARCHAR2
126 );
127
128 -- *******************************************************
129 -- Start of Comments
130 -- *******************************************************
131 -- API Name: Update_prof_module_groups
132 -- Type : Private
133 -- Pre-Req :
134 -- Parameters:
135 -- IN
136 -- p_api_version_number IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
142 --
143 -- OUT:
144 -- x_return_status OUT VARCHAR2
145 -- x_msg_count OUT NUMBER
146 -- x_msg_data OUT VARCHAR2
147 --
148 -- End of Comments
149 --
150 PROCEDURE Update_prof_module_groups(
151 P_Api_Version_Number IN NUMBER,
152 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
153 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
155 P_MODULE_GROUP_ID NUMBER,
156 p_FORM_FUNCTION_ID NUMBER,
157 p_FORM_FUNCTION_NAME VARCHAR2,
158 p_RESPONSIBILITY_ID NUMBER,
159 p_RESP_APPL_ID NUMBER,
160 p_PARTY_TYPE VARCHAR2,
161 p_GROUP_ID NUMBER,
162 p_DASHBOARD_GROUP_FLAG VARCHAR2,
163 p_CURRENCY_CODE VARCHAR2,
164 p_LAST_UPDATE_DATE DATE,
165 p_LAST_UPDATED_BY NUMBER,
166 p_CREATION_DATE DATE DEFAULT NULL,
167 p_CREATED_BY NUMBER DEFAULT NULL,
168 p_LAST_UPDATE_LOGIN NUMBER,
169 p_SEEDED_FLAG VARCHAR2,
170 p_APPLICATION_ID NUMBER,
171 p_DASHBOARD_GROUP_ID NUMBER,
172 X_Return_Status OUT NOCOPY VARCHAR2,
173 X_Msg_Count OUT NOCOPY NUMBER,
174 X_Msg_Data OUT NOCOPY VARCHAR2
175 );
176
177 PROCEDURE Update_prof_module_groups(
178 P_Api_Version_Number IN NUMBER,
179 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
180 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
181 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
182 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
183 X_Return_Status OUT NOCOPY VARCHAR2,
184 X_Msg_Count OUT NOCOPY NUMBER,
185 X_Msg_Data OUT NOCOPY VARCHAR2
186 );
187
188 -- *******************************************************
189 -- Start of Comments
190 -- *******************************************************
191 -- API Name: Delete_prof_module_groups
192 -- Type : Private
193 -- Pre-Req :
194 -- Parameters:
195 -- IN
196 -- p_api_version_number IN NUMBER Required
197 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
201 -- P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type Required
202 --
203 -- OUT:
204 -- x_return_status OUT VARCHAR2
205 -- x_msg_count OUT NUMBER
206 -- x_msg_data OUT VARCHAR2
207 --
208 -- End of Comments
209 --
210
211 PROCEDURE Delete_prof_module_groups(
212 P_Api_Version_Number IN NUMBER,
213 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
214 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
215 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
216 P_PROF_MODULE_GRP_Id IN NUMBER,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221
222
223
224
225 -- Start of Comments
226 --
227 -- Item level validation procedures
228 --
229 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
230 -- For create: G_CREATE, for update: G_UPDATE
231 -- Note: 1. This is automated generated item level validation procedure.
232 -- The actual validation detail is needed to be added.
233 --
234 -- End of Comments
235
236 PROCEDURE Validate_MODULE_GROUP_ID (
237 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
238 P_Validation_mode IN VARCHAR2,
239 P_MODULE_GROUP_ID IN NUMBER,
240 X_Return_Status OUT NOCOPY VARCHAR2,
241 X_Msg_Count OUT NOCOPY NUMBER,
242 X_Msg_Data OUT NOCOPY VARCHAR2
243 );
244
245 -- Start of Comments
246 --
247 -- Item level validation procedures
248 --
249 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
250 -- For create: G_CREATE, for update: G_UPDATE
251 -- Note: 1. This is automated generated item level validation procedure.
252 -- The actual validation detail is needed to be added.
253 --
254 -- End of Comments
255
256 PROCEDURE Validate_FORM_FUNCTION_ID (
257 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
258 P_Validation_mode IN VARCHAR2,
259 P_FORM_FUNCTION_ID IN NUMBER,
260 X_Return_Status OUT NOCOPY VARCHAR2,
261 X_Msg_Count OUT NOCOPY NUMBER,
262 X_Msg_Data OUT NOCOPY VARCHAR2
263 );
264
265 -- Start of Comments
266 --
267 -- Item level validation procedures
268 --
269 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
270 -- For create: G_CREATE, for update: G_UPDATE
271 -- Note: 1. This is automated generated item level validation procedure.
272 -- The actual validation detail is needed to be added.
273 --
274 -- End of Comments
275
276 PROCEDURE Validate_RESPONSIBILITY_ID (
277 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
278 P_Validation_mode IN VARCHAR2,
279 P_RESPONSIBILITY_ID IN NUMBER,
280 p_RESP_APPL_ID IN NUMBER,
281 X_Return_Status OUT NOCOPY VARCHAR2,
282 X_Msg_Count OUT NOCOPY NUMBER,
283 X_Msg_Data OUT NOCOPY VARCHAR2
284 );
285
286
287 PROCEDURE Validate_PARTY_TYPE (
288 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
289 P_Validation_mode IN VARCHAR2,
290 P_PARTY_TYPE IN VARCHAR2,
291 X_Return_Status OUT NOCOPY VARCHAR2,
292 X_Msg_Count OUT NOCOPY NUMBER,
293 X_Msg_Data OUT NOCOPY VARCHAR2
294 );
295
296 -- Start of Comments
297 --
298 -- Item level validation procedures
299 --
300 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
301 -- For create: G_CREATE, for update: G_UPDATE
302 -- Note: 1. This is automated generated item level validation procedure.
303 -- The actual validation detail is needed to be added.
304 --
305 -- End of Comments
306
307 PROCEDURE Validate_GROUP_ID (
308 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
309 P_Validation_mode IN VARCHAR2,
310 P_GROUP_ID IN NUMBER,
311 P_PARTY_TYPE IN VARCHAR2,
312 X_Return_Status OUT NOCOPY VARCHAR2,
313 X_Msg_Count OUT NOCOPY NUMBER,
314 X_Msg_Data OUT NOCOPY VARCHAR2
315 );
316
317 -- Start of Comments
318 --
319 -- Item level validation procedures
320 --
321 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
322 -- For create: G_CREATE, for update: G_UPDATE
323 -- Note: 1. This is automated generated item level validation procedure.
324 -- The actual validation detail is needed to be added.
325 --
326 -- End of Comments
327
328 PROCEDURE Validate_DASHBOARD_GROUP_FLAG (
329 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
330 P_Validation_mode IN VARCHAR2,
331 P_DASHBOARD_GROUP_FLAG IN VARCHAR2,
332 X_Return_Status OUT NOCOPY VARCHAR2,
333 X_Msg_Count OUT NOCOPY NUMBER,
334 X_Msg_Data OUT NOCOPY VARCHAR2
335 );
336
337 -- Start of Comments
338 --
339 -- Item level validation procedures
340 --
341 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
342 -- For create: G_CREATE, for update: G_UPDATE
343 -- Note: 1. This is automated generated item level validation procedure.
344 -- The actual validation detail is needed to be added.
345 --
346 -- End of Comments
347
348 PROCEDURE Validate_CURRENCY_CODE (
349 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
350 P_Validation_mode IN VARCHAR2,
351 P_CURRENCY_CODE IN VARCHAR2,
352 X_Return_Status OUT NOCOPY VARCHAR2,
353 X_Msg_Count OUT NOCOPY NUMBER,
354 X_Msg_Data OUT NOCOPY VARCHAR2
355 );
356
357
358 PROCEDURE Validate_PROF_MODULE_GRP_Rec(
359 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
360 P_Validation_mode IN VARCHAR2,
361 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
362 X_Return_Status OUT NOCOPY VARCHAR2,
363 X_Msg_Count OUT NOCOPY NUMBER,
364 X_Msg_Data OUT NOCOPY VARCHAR2
365 );
366
367
368 -- Start of Comments
369 --
370 -- validation procedures
371 --
372 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
373 -- For create: G_CREATE, for update: G_UPDATE
374 -- Note: 1. This is automated generated item level validation procedure.
375 -- The actual validation detail is needed to be added.
376 -- 2. We can also validate table instead of record. There will be an option for user to choose.
377 -- End of Comments
378
379 PROCEDURE Validate_prof_module_groups(
380 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
381 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
382 P_Validation_mode IN VARCHAR2,
383 P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
384 X_Return_Status OUT NOCOPY VARCHAR2,
385 X_Msg_Count OUT NOCOPY NUMBER,
386 X_Msg_Data OUT NOCOPY VARCHAR2
387 );
388
389 -- Start of Comments
390 --
391 -- Item level validation procedures
392 --
393 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
394 -- For create: G_CREATE, for update: G_UPDATE
395 -- Note: 1. This is automated generated item level validation procedure.
396 -- The actual validation detail is needed to be added.
397 --
398 -- End of Comments
399
400
401 PROCEDURE Validate_DASHBOARD_GROUP_ID (
402 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
403 P_Validation_mode IN VARCHAR2,
404 P_DASHBOARD_GROUP_ID IN NUMBER,
405 P_PARTY_TYPE IN VARCHAR2,
406 X_Return_Status OUT NOCOPY VARCHAR2,
407 X_Msg_Count OUT NOCOPY NUMBER,
408 X_Msg_Data OUT NOCOPY VARCHAR2
409 );
410
411 End CSC_PROF_MODULE_GROUPS_PVT;