[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_GROUPS_PVT
Source
1 PACKAGE CSC_PROFILE_GROUPS_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpgrs.pls 115.8 2002/12/03 18:29:49 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROFILE_GROUPS_PVT
5 -- Purpose :
6 -- History :
7 -- 29 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:PROF_GROUP_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- GROUP_ID
20 -- CREATED_BY
21 -- CREATION_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATE_LOGIN
25 -- GROUP_NAME
26 -- GROUP_NAME_CODE
27 -- DESCRIPTION
28 -- START_DATE_ACTIVE
29 -- END_DATE_ACTIVE
30 -- USE_IN_CUSTOMER_DASHBOARD
31 -- SEEDED_FLAG
32 -- APPLICATION_ID
33 --
34 --
35 -- End of Comments
36
37 TYPE PROF_GROUP_Rec_Type IS RECORD
38 (
39 GROUP_ID NUMBER,
40 CREATED_BY NUMBER,
41 CREATION_DATE DATE,
42 LAST_UPDATED_BY NUMBER,
43 LAST_UPDATE_DATE DATE,
44 LAST_UPDATE_LOGIN NUMBER,
45 GROUP_NAME VARCHAR2(240),
46 GROUP_NAME_CODE VARCHAR2(240),
47 DESCRIPTION VARCHAR2(720),
48 PARTY_TYPE VARCHAR2(30),
49 START_DATE_ACTIVE DATE,
50 END_DATE_ACTIVE DATE,
51 USE_IN_CUSTOMER_DASHBOARD VARCHAR2(3),
52 SEEDED_FLAG VARCHAR2(3),
53 OBJECT_VERSION_NUMBER NUMBER,
54 APPLICATION_ID NUMBER
55
56 );
57
58 G_MISS_PROF_GROUP_REC PROF_GROUP_Rec_Type;
59 TYPE PROF_GROUP_Tbl_Type IS TABLE OF PROF_GROUP_Rec_Type INDEX BY BINARY_INTEGER;
60 G_MISS_PROF_GROUP_TBL PROF_GROUP_Tbl_Type;
61
62 -- *******************************************************
63 -- Start of Comments
64 -- *******************************************************
65 -- API Name: Create_profile_groups
66 -- Type : Private
67 -- Pre-Req :
68 -- Parameters:
69 -- IN
70 -- p_api_version_number IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
75 --
76 -- OUT:
77 -- x_return_status OUT VARCHAR2
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 -- Version : Current version 1.0
81 --
82 -- End of Comments
83 --
84
85 PROCEDURE Create_profile_groups(
86 PX_Group_Id IN OUT NOCOPY NUMBER,
87 P_Api_Version_Number IN NUMBER,
88 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
89 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
91 P_GROUP_ID IN NUMBER DEFAULT NULL,
92 P_CREATED_BY IN NUMBER,
93 P_CREATION_DATE IN DATE,
94 P_LAST_UPDATED_BY IN NUMBER,
95 P_LAST_UPDATE_DATE IN DATE,
96 P_LAST_UPDATE_LOGIN IN NUMBER,
97 P_GROUP_NAME IN VARCHAR2,
98 P_GROUP_NAME_CODE IN VARCHAR2,
99 P_DESCRIPTION IN VARCHAR2,
100 P_PARTY_TYPE IN VARCHAR2,
101 P_START_DATE_ACTIVE IN DATE,
102 P_END_DATE_ACTIVE IN DATE,
103 P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2,
104 P_SEEDED_FLAG IN VARCHAR2,
105 X_Object_Version_Number OUT NOCOPY NUMBER,
106 P_APPLICATION_ID IN NUMBER,
107 X_Return_Status OUT NOCOPY VARCHAR2,
108 X_Msg_Count OUT NOCOPY NUMBER,
109 X_Msg_Data OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE Create_profile_groups(
113 PX_Group_Id IN OUT NOCOPY NUMBER,
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118 P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
119 X_Object_Version_Number OUT NOCOPY NUMBER,
120 X_Return_Status OUT NOCOPY VARCHAR2,
121 X_Msg_Count OUT NOCOPY NUMBER,
122 X_Msg_Data OUT NOCOPY VARCHAR2
123 );
124
125 -- *******************************************************
126 -- Start of Comments
127 -- *******************************************************
128 -- API Name: Update_profile_groups
129 -- Type : Private
130 -- Pre-Req :
131 -- Parameters:
132 -- IN
133 -- p_api_version_number IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
136 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
137 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
138 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
139 --
140 -- OUT:
141 -- x_return_status OUT VARCHAR2
142 -- x_msg_count OUT NUMBER
143 -- x_msg_data OUT VARCHAR2
144 -- Version : Current version 1.0
145 --
146 -- End of Comments
147 --
148
149
150 PROCEDURE Update_profile_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_GROUP_ID IN NUMBER ,
156 P_CREATED_BY IN NUMBER ,
157 P_CREATION_DATE IN DATE ,
158 P_LAST_UPDATED_BY IN NUMBER ,
159 P_LAST_UPDATE_DATE IN DATE ,
160 P_LAST_UPDATE_LOGIN IN NUMBER ,
161 P_GROUP_NAME IN VARCHAR2,
162 P_GROUP_NAME_CODE IN VARCHAR2,
163 P_DESCRIPTION IN VARCHAR2,
164 P_PARTY_TYPE IN VARCHAR2 ,
165 P_START_DATE_ACTIVE IN DATE ,
166 P_END_DATE_ACTIVE IN DATE ,
167 P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2,
168 P_SEEDED_FLAG IN VARCHAR2 ,
169 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
170 P_APPLICATION_ID IN NUMBER ,
171 X_Return_Status OUT NOCOPY VARCHAR2,
172 X_Msg_Count OUT NOCOPY NUMBER,
173 X_Msg_Data OUT NOCOPY VARCHAR2
174 );
175
176
177
178 PROCEDURE Update_profile_groups(
179 P_Api_Version_Number IN NUMBER,
180 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
181 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
182 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
183 P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
184 PX_Object_Version_Number IN OUT NOCOPY NUMBER,
185 X_Return_Status OUT NOCOPY VARCHAR2,
186 X_Msg_Count OUT NOCOPY NUMBER,
187 X_Msg_Data OUT NOCOPY VARCHAR2
188 );
189
190 -- *******************************************************
191 -- Start of Comments
192 -- *******************************************************
193 -- API Name: Delete_profile_groups
194 -- Type : Private
195 -- Pre-Req :
196 -- Parameters:
197 -- IN
198 -- p_api_version_number IN NUMBER Required
199 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
201 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
202 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
203 -- P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type Required
204 --
205 -- OUT:
206 -- x_return_status OUT VARCHAR2
207 -- x_msg_count OUT NUMBER
208 -- x_msg_data OUT VARCHAR2
209 -- Version : Current version 1.0
210 --
211 -- End of Comments
212 --
213
214 PROCEDURE Delete_profile_groups(
215 P_Api_Version_Number IN NUMBER,
216 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
217 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
218 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
219 P_GROUP_ID IN NUMBER,
220 P_OBJECT_VERSION_NUMBER IN NUMBER,
221 X_Return_Status OUT NOCOPY VARCHAR2,
222 X_Msg_Count OUT NOCOPY NUMBER,
223 X_Msg_Data OUT NOCOPY VARCHAR2
224 );
225
226
227 -- Start of Comments
228 --
229 -- Item level validation procedures
230 --
231 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
232 -- For create: G_CREATE, for update: G_UPDATE
233 --
234 -- End of Comments
235
236 PROCEDURE Validate_GROUP_NAME (
237 P_Api_Name IN VARCHAR2,
238 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
239 P_Validation_mode IN VARCHAR2,
240 P_GROUP_NAME IN VARCHAR2,
241 P_GROUP_ID IN NUMBER,
242 X_Return_Status OUT NOCOPY VARCHAR2,
243 X_Msg_Count OUT NOCOPY NUMBER,
244 X_Msg_Data OUT NOCOPY VARCHAR2
245 );
246
247 -- Start of Comments
248 --
249 -- Item level validation procedures
250 --
251 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
252 -- For create: G_CREATE, for update: G_UPDATE
253 --
254 -- End of Comments
255
256 PROCEDURE Validate_GROUP_NAME_CODE (
257 P_Api_Name IN VARCHAR2,
258 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
259 P_Validation_mode IN VARCHAR2,
260 P_GROUP_NAME_CODE IN VARCHAR2,
261 X_Return_Status OUT NOCOPY VARCHAR2,
262 X_Msg_Count OUT NOCOPY NUMBER,
263 X_Msg_Data OUT NOCOPY VARCHAR2
264 );
265
266 -- Start of Comments
267 --
268 -- Item level validation procedures
269 --
270 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
271 -- For create: G_CREATE, for update: G_UPDATE
272 --
273 -- End of Comments
274
275 PROCEDURE Validate_IN_CUST_DASHBOARD (
276 P_Api_Name IN VARCHAR2,
277 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
278 P_Validation_mode IN VARCHAR2,
279 P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2,
280 X_Return_Status OUT NOCOPY VARCHAR2,
281 X_Msg_Count OUT NOCOPY NUMBER,
282 X_Msg_Data OUT NOCOPY VARCHAR2
283 );
284
285 -- Start of Comments
286 --
287 -- Item level validation procedures
288 --
289 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
290 -- For create: G_CREATE, for update: G_UPDATE
291 --
292 -- End of Comments
293
294 PROCEDURE Validate_SEEDED_FLAG (
295 P_Api_Name IN VARCHAR2,
296 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
297 P_Validation_mode IN VARCHAR2,
298 P_SEEDED_FLAG IN VARCHAR2,
299 X_Return_Status OUT NOCOPY VARCHAR2,
300 X_Msg_Count OUT NOCOPY NUMBER,
301 X_Msg_Data OUT NOCOPY VARCHAR2
302 );
303
304
305 -- Start of Comments
306 --
307 -- validation procedures
308 --
309 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
310 -- For create: G_CREATE, for update: G_UPDATE
311 -- End of Comments
312
313 PROCEDURE Validate_profile_groups(
314 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
315 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
316 P_Validation_mode IN VARCHAR2,
317 P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
318 X_Return_Status OUT NOCOPY VARCHAR2,
319 X_Msg_Count OUT NOCOPY NUMBER,
320 X_Msg_Data OUT NOCOPY VARCHAR2
321 );
322 End CSC_PROFILE_GROUPS_PVT;