[Home] [Help]
PACKAGE: APPS.CSC_GROUP_CHECKS_PVT
Source
1 PACKAGE CSC_GROUP_CHECKS_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpgcs.pls 120.1 2005/08/03 23:01:07 mmadhavi noship $ */
3 -- Start of Comments
4 -- Package name : CSC_GROUP_CHECKS_PVT
5 -- Purpose :
6 -- History :
7 -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
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:GROUP_CHK_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 -- GROUP_ID
20 -- CHECK_ID
21 -- CHECK_SEQUENCE
22 -- END_DATE_ACTIVE
23 -- START_DATE_ACTIVE
24 -- CATEGORY_CODE
25 -- CATEGORY_SEQUENCE
26 -- THRESHOLD_FLAG
27 -- CRITICAL_FLAG
28 -- SEEDED_FLAG
29 -- CREATED_BY
30 -- CREATION_DATE
31 -- LAST_UPDATED_BY
32 -- LAST_UPDATE_DATE
33 -- LAST_UPDATE_LOGIN
34 --
35 -- Required:
36 -- Defaults:
37 --
38 -- End of Comments
39
40 TYPE GROUP_CHK_Rec_Type IS RECORD
41 (
42 GROUP_ID NUMBER,
43 CHECK_ID NUMBER,
44 CHECK_SEQUENCE NUMBER,
45 END_DATE_ACTIVE DATE ,
46 START_DATE_ACTIVE DATE ,
47 CATEGORY_CODE VARCHAR2(30),
48 CATEGORY_SEQUENCE NUMBER ,
49 THRESHOLD_FLAG VARCHAR2(3),
50 CRITICAL_FLAG VARCHAR2(1), --mmadhavi added for JIT
51 SEEDED_FLAG VARCHAR2(3),
55 LAST_UPDATE_DATE DATE,
52 CREATED_BY NUMBER ,
53 CREATION_DATE DATE,
54 LAST_UPDATED_BY NUMBER,
56 LAST_UPDATE_LOGIN NUMBER
57 );
58
59 G_MISS_GROUP_CHK_REC GROUP_CHK_Rec_Type;
60 TYPE GROUP_CHK_Tbl_Type IS TABLE OF GROUP_CHK_Rec_Type
61 INDEX BY BINARY_INTEGER;
62 G_MISS_GROUP_CHK_TBL GROUP_CHK_Tbl_Type;
63
64 -- *******************************************************
65 -- Start of Comments
66 -- *******************************************************
67 -- API Name: Create_group_checks
68 -- Type : Private
69 -- Pre-Req :
70 -- Parameters:
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
75 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
76 -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
77 --
78 -- OUT:
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 1.0
83 --
84 -- End of Comments
85 --
86
87 PROCEDURE Create_group_checks(
88 P_Api_Version_Number IN NUMBER,
89 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92 P_GROUP_ID IN NUMBER ,
93 P_CHECK_ID IN NUMBER ,
94 P_END_DATE_ACTIVE IN DATE ,
95 P_START_DATE_ACTIVE IN DATE ,
96 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
97 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL,
98 P_THRESHOLD_FLAG IN VARCHAR2,
99 P_CRITICAL_FLAG IN VARCHAR2, --mmadhavi added for JIT project
100 P_SEEDED_FLAG IN VARCHAR2,
101 P_CREATED_BY IN NUMBER,
102 P_CREATION_DATE IN DATE,
103 P_LAST_UPDATED_BY IN NUMBER,
104 P_LAST_UPDATE_DATE IN DATE,
105 P_LAST_UPDATE_LOGIN IN NUMBER,
106 P_Check_Sequence 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
113 PROCEDURE Create_group_checks(
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_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119 -- X_Check_Sequence 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_group_checks
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_GROUP_CHK_Rec IN GROUP_CHK_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 PROCEDURE Update_group_checks(
149 P_Api_Version_Number IN NUMBER,
150 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
151 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
152 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
153 P_GROUP_ID IN NUMBER,
154 P_CHECK_ID IN NUMBER,
155 P_CHECK_SEQUENCE IN NUMBER,
156 P_END_DATE_ACTIVE IN DATE,
157 P_START_DATE_ACTIVE IN DATE,
158 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
159 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL,
160 P_THRESHOLD_FLAG IN VARCHAR2,
161 P_CRITICAL_FLAG IN VARCHAR2, --mmadhavi added for JIT project
162 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
163 P_CREATED_BY IN NUMBER DEFAULT NULL,
164 P_CREATION_DATE IN DATE DEFAULT NULL,
165 P_LAST_UPDATED_BY IN NUMBER,
166 P_LAST_UPDATE_DATE IN DATE,
167 P_LAST_UPDATE_LOGIN IN NUMBER,
168 X_Return_Status OUT NOCOPY VARCHAR2,
169 X_Msg_Count OUT NOCOPY NUMBER,
173
170 X_Msg_Data OUT NOCOPY VARCHAR2
171 );
172
174 PROCEDURE Update_group_checks(
175 P_Api_Version_Number IN NUMBER,
176 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
177 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
178 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
179 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
180 X_Return_Status OUT NOCOPY VARCHAR2,
181 X_Msg_Count OUT NOCOPY NUMBER,
182 X_Msg_Data OUT NOCOPY VARCHAR2
183 );
184
185 -- *******************************************************
186 -- Start of Comments
187 -- *******************************************************
188 -- API Name: Delete_group_checks
189 -- Type : Private
190 -- Pre-Req :
191 -- Parameters:
192 -- IN
193 -- p_api_version_number IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
196 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
197 -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
198 --
199 -- OUT:
200 -- x_return_status OUT VARCHAR2
201 -- x_msg_count OUT NUMBER
202 -- x_msg_data OUT VARCHAR2
203 -- Version : Current version 1.0
204 --
205 -- End of Comments
206 --
207 PROCEDURE Delete_group_checks(
208 P_Api_Version_Number IN NUMBER,
209 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
210 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
212 P_GROUP_ID IN NUMBER,
213 P_CHECK_ID IN NUMBER,
214 P_CHECK_SEQUENCE IN NUMBER,
215 X_Return_Status OUT NOCOPY VARCHAR2,
216 X_Msg_Count OUT NOCOPY NUMBER,
217 X_Msg_Data OUT NOCOPY VARCHAR2
218 );
219
220 -- Start of Comments
221 --
222 -- Item level validation procedures
223 --
224 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
225 -- For create: G_CREATE, for update: G_UPDATE
226 --
227 -- End of Commens
228
229 PROCEDURE Validate_GROUP_ID (
230 P_Api_Name IN VARCHAR2,
231 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
232 P_Validation_mode IN VARCHAR2,
233 P_GROUP_ID IN NUMBER,
234 X_Return_Status OUT NOCOPY VARCHAR2,
235 X_Msg_Count OUT NOCOPY NUMBER,
236 X_Msg_Data OUT NOCOPY VARCHAR2
237 );
238
239 -- Start of Comments
240 --
241 -- Item level validation procedures
242 --
243 --
244 -- End of Comments
245
246 PROCEDURE Validate_CHECK_ID (
247 P_Api_Name IN VARCHAR2,
248 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
249 P_Validation_mode IN VARCHAR2,
250 P_CHECK_ID IN NUMBER,
251 X_Return_Status OUT NOCOPY VARCHAR2,
252 X_Msg_Count OUT NOCOPY NUMBER,
253 X_Msg_Data OUT NOCOPY VARCHAR2
254 );
255
256 -- Start of Comments
257 --
258 -- Item level validation procedures
259 --
260 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
261 -- For create: G_CREATE, for update: G_UPDATE
262 --
263 -- End of Comments
264
265 PROCEDURE Validate_CHECK_SEQUENCE (
266 P_Api_Name IN VARCHAR2,
267 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
268 P_Validation_mode IN VARCHAR2,
269 P_CHECK_SEQUENCE IN NUMBER,
270 X_Return_Status OUT NOCOPY VARCHAR2,
271 X_Msg_Count OUT NOCOPY NUMBER,
272 X_Msg_Data OUT NOCOPY VARCHAR2
273 );
274
275
276 -- Start of Comments
277 --
278 -- Item level validation procedures
279 --
280 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
281 -- For create: G_CREATE, for update: G_UPDATE
282 --
283 -- End of Comments
284
285 PROCEDURE Validate_CATEGORY_CODE (
286 P_Api_Name IN VARCHAR2,
287 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
288 P_Validation_mode IN VARCHAR2,
289 P_CATEGORY_CODE IN VARCHAR2,
290 X_Return_Status OUT NOCOPY VARCHAR2,
291 X_Msg_Count OUT NOCOPY NUMBER,
292 X_Msg_Data OUT NOCOPY VARCHAR2
293 );
294
295 -- Start of Comments
296 --
297 -- Item level validation procedures
298 --
299 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
300 -- For create: G_CREATE, for update: G_UPDATE
301 --
302 -- End of Comments
303
304 PROCEDURE Validate_CATEGORY_SEQUENCE (
305 P_Api_Name IN VARCHAR2,
306 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307 P_Validation_mode IN VARCHAR2,
308 P_CHECK_ID IN NUMBER,
309 P_CATEGORY_SEQUENCE IN NUMBER,
313 );
310 X_Return_Status OUT NOCOPY VARCHAR2,
311 X_Msg_Count OUT NOCOPY NUMBER,
312 X_Msg_Data OUT NOCOPY VARCHAR2
314
315 -- Start of Comments
316 --
317 -- Item level validation procedures
318 --
319 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
320 -- For create: G_CREATE, for update: G_UPDATE
321 --
322 -- End of Comments
323
324 PROCEDURE Validate_THRESHOLD_FLAG (
325 P_Api_Name IN VARCHAR2,
326 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
327 P_Validation_mode IN VARCHAR2,
328 P_THRESHOLD_FLAG IN VARCHAR2,
329 X_Return_Status OUT NOCOPY VARCHAR2,
330 X_Msg_Count OUT NOCOPY NUMBER,
331 X_Msg_Data OUT NOCOPY VARCHAR2
332 );
333
334
335 -- Start of Comments
336 --
337 -- validation procedures
338 --
339 -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
340 -- For create: G_CREATE, for update: G_UPDATE
341 -- End of Comments
342
343 PROCEDURE Validate_group_checks(
344 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
345 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
346 P_Validation_mode IN VARCHAR2,
347 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
348 X_Return_Status OUT NOCOPY VARCHAR2,
349 X_Msg_Count OUT NOCOPY NUMBER,
350 X_Msg_Data OUT NOCOPY VARCHAR2
351 );
352 End CSC_GROUP_CHECKS_PVT;