1 PACKAGE AMS_Cal_Crt_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvccts.pls 115.3 2003/03/08 14:17:53 cgoyal noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Cal_Crt_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- cal_crt_rec_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- criteria_id
29 -- object_type_code
30 -- custom_setup_id
31 -- activity_type_code
32 -- activity_id
33 -- status_id
34 -- priority_id
35 -- object_id
36 -- criteria_start_date
37 -- criteria_end_date
38 -- criteria_deleted
39 -- criteria_enabled
40 -- last_update_date
41 -- last_updated_by
42 -- creation_date
43 -- created_by
44 -- last_update_login
45 -- object_version_number
46 --
47 -- Required
48 --
49 -- Defaults
50 --
51 -- Note: This is automatic generated record definition, it includes all columns
52 -- defined in the table, developer must manually add or delete some of the attributes.
53 --
54 -- End of Comments
55
56 --===================================================================
57 TYPE cal_crt_rec_rec_type IS RECORD
58 (
59 criteria_id NUMBER,
60 object_type_code VARCHAR2(30),
61 custom_setup_id NUMBER,
62 activity_type_code VARCHAR2(30),
63 activity_id NUMBER,
64 status_id NUMBER,
65 priority_id VARCHAR2(30),
66 object_id NUMBER,
67 criteria_start_date DATE,
68 criteria_end_date DATE,
69 criteria_deleted VARCHAR2(1),
70 criteria_enabled VARCHAR2(1),
71 last_update_date DATE,
72 last_updated_by NUMBER,
73 creation_date DATE,
74 created_by NUMBER,
75 last_update_login NUMBER,
76 object_version_number NUMBER
77 );
78
79 g_miss_cal_crt_rec_rec cal_crt_rec_rec_type := NULL;
80 TYPE cal_crt_rec_tbl_type IS TABLE OF cal_crt_rec_rec_type INDEX BY BINARY_INTEGER;
81 g_miss_cal_crt_rec_tbl cal_crt_rec_tbl_type;
82
83 -- ==============================================================================
84 -- Start of Comments
85 -- ==============================================================================
86 -- API Name
87 -- Create_Cal_Crt
88 -- Type
89 -- Private
90 -- Pre-Req
91 --
92 -- Parameters
93 --
94 -- IN
95 -- p_api_version_number IN NUMBER Required
96 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
97 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
98 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
99 -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
100 --
101 -- OUT
102 -- x_return_status OUT VARCHAR2
103 -- x_msg_count OUT NUMBER
104 -- x_msg_data OUT VARCHAR2
105 -- Version : Current version 1.0
106 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
107 -- and basic operation, developer must manually add parameters and business logic as necessary.
108 --
109 -- History
110 --
111 -- NOTE
112 --
113 -- End of Comments
114 -- ==============================================================================
115
116 PROCEDURE Create_Cal_Crt(
117 p_api_version_number IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 p_commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125
126 p_cal_crt_rec_rec IN cal_crt_rec_rec_type := g_miss_cal_crt_rec_rec,
127 x_criteria_id OUT NOCOPY NUMBER
128 );
129
130 -- ==============================================================================
131 -- Start of Comments
132 -- ==============================================================================
133 -- API Name
134 -- Update_Cal_Crt
135 -- Type
136 -- Private
137 -- Pre-Req
138 --
139 -- Parameters
140 --
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146 -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
147 --
148 -- OUT
149 -- x_return_status OUT VARCHAR2
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2
152 -- Version : Current version 1.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- History
157 --
158 -- NOTE
159 --
160 -- End of Comments
161 -- ==============================================================================
162
163 PROCEDURE Update_Cal_Crt(
164 p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172
173 p_cal_crt_rec_rec IN cal_crt_rec_rec_type
174 );
175
176 -- ==============================================================================
177 -- Start of Comments
178 -- ==============================================================================
179 -- API Name
180 -- Delete_Cal_Crt
181 -- Type
182 -- Private
183 -- Pre-Req
184 --
185 -- Parameters
186 --
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192 -- p_criteria_id IN NUMBER
193 -- p_object_version_number IN NUMBER Optional Default = NULL
194 --
195 -- OUT
196 -- x_return_status OUT VARCHAR2
197 -- x_msg_count OUT NUMBER
198 -- x_msg_data OUT VARCHAR2
199 -- Version : Current version 1.0
200 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
201 -- and basic operation, developer must manually add parameters and business logic as necessary.
202 --
203 -- History
204 --
205 -- NOTE
206 --
207 -- End of Comments
208 -- ==============================================================================
209
210 PROCEDURE Delete_Cal_Crt(
211 p_api_version_number IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_criteria_id IN NUMBER,
219 p_object_version_number IN NUMBER
220 );
221
222 -- ==============================================================================
223 -- Start of Comments
224 -- ==============================================================================
225 -- API Name
226 -- Lock_Cal_Crt
227 -- Type
228 -- Private
229 -- Pre-Req
230 --
231 -- Parameters
232 --
233 -- IN
234 -- p_api_version_number IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238 -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
239 --
240 -- OUT
241 -- x_return_status OUT VARCHAR2
242 -- x_msg_count OUT NUMBER
243 -- x_msg_data OUT VARCHAR2
244 -- Version : Current version 1.0
245 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
246 -- and basic operation, developer must manually add parameters and business logic as necessary.
247 --
248 -- History
249 --
250 -- NOTE
251 --
252 -- End of Comments
253 -- ==============================================================================
254
255 PROCEDURE Lock_Cal_Crt(
256 p_api_version_number IN NUMBER,
257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262
263 p_criteria_id IN NUMBER,
264 p_object_version IN NUMBER
265 );
266
267
268 -- ==============================================================================
269 -- Start of Comments
270 -- ==============================================================================
271 -- API Name
272 -- Validate_Cal_Crt
273 --
274 -- Version : Current version 1.0
275 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
276 -- For create: G_CREATE, for update: G_UPDATE
277 -- Note: 1. This is automated generated item level validation procedure.
278 -- The actual validation detail is needed to be added.
279 -- 2. We can also validate table instead of record. There will be an option for user to choose.
280 --
281 -- History
282 --
283 -- NOTE
284 --
285 -- End of Comments
286 -- ==============================================================================
287
288
289 PROCEDURE Validate_Cal_Crt(
290 p_api_version_number IN NUMBER,
291 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 p_cal_crt_rec_rec IN cal_crt_rec_rec_type,
294 p_validation_mode IN VARCHAR2,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2
298 );
299
300 -- ==============================================================================
301 -- Start of Comments
302 -- ==============================================================================
303 -- API Name
304 -- Cal_Crt_Rec_Items
305 --
306 -- Version : Current version 1.0
307 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
308 -- For create: G_CREATE, for update: G_UPDATE
309 -- Note: 1. This is automated generated item level validation procedure.
310 -- The actual validation detail is needed to be added.
311 -- 2. Validate the unique keys, lookups here
312 --
313 -- History
314 --
315 -- NOTE
316 --
317 -- End of Comments
318 -- ==============================================================================
319
320
321 PROCEDURE Check_Cal_Crt_Rec_Items (
322 P_cal_crt_rec_rec IN cal_crt_rec_rec_type,
323 p_validation_mode IN VARCHAR2,
324 x_return_status OUT NOCOPY VARCHAR2
325 );
326
327 -- ==============================================================================
328 -- Start of Comments
329 -- ==============================================================================
330 -- API Name
331 -- Validate_Cal_Crt_Rec_Rec
332 --
333 -- Version : Current version 1.0
334 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 -- 2. Developer can manually added inter-field level validation.
339 --
340 -- History
341 --
342 -- NOTE
343 --
344 -- End of Comments
345 -- ==============================================================================
346
347
348 PROCEDURE Validate_Cal_Crt_Rec_Rec (
349 p_api_version_number IN NUMBER,
350 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351 x_return_status OUT NOCOPY VARCHAR2,
352 x_msg_count OUT NOCOPY NUMBER,
353 x_msg_data OUT NOCOPY VARCHAR2,
354 p_cal_crt_rec_rec IN cal_crt_rec_rec_type
355 );
356 END AMS_Cal_Crt_PVT;