1 PACKAGE AMS_Cat_Activity_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvcacs.pls 115.5 2002/12/30 05:37:42 cgoyal ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Cat_Activity_PVT
7 -- Purpose
8 --
9 -- History
10 -- 05-Nov-2001 musman Commented out the reference to security_group_id
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- cat_activity_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- cat_activity_id
27 -- object_version_number
28 -- category_id
29 -- activity_id
30 -- last_update_date
31 -- last_updated_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- security_group_id
36 -- attribute_category
37 -- attribute1
38 -- attribute2
39 -- attribute3
40 -- attribute4
41 -- attribute5
42 -- attribute6
43 -- attribute7
44 -- attribute8
45 -- attribute9
46 -- attribute10
47 -- attribute11
48 -- attribute12
49 -- attribute13
50 -- attribute14
51 -- attribute15
52 --
53 -- Required
54 --
55 -- Defaults
56 --
57 -- Note: This is automatic generated record definition, it includes all columns
58 -- defined in the table, developer must manually add or delete some of the attributes.
59 --
60 -- End of Comments
61
62 --===================================================================
63 TYPE cat_activity_rec_type IS RECORD
64 (
65 cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66 object_version_number NUMBER := FND_API.G_MISS_NUM,
67 category_id NUMBER := FND_API.G_MISS_NUM,
68 activity_id NUMBER := FND_API.G_MISS_NUM,
69 last_update_date DATE := FND_API.G_MISS_DATE,
70 last_updated_by NUMBER := FND_API.G_MISS_NUM,
71 creation_date DATE := FND_API.G_MISS_DATE,
72 created_by NUMBER := FND_API.G_MISS_NUM,
73 last_update_login NUMBER := FND_API.G_MISS_NUM,
74 --security_group_id NUMBER := FND_API.G_MISS_NUM,
75 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91 );
92
93 g_miss_cat_activity_rec cat_activity_rec_type;
94 TYPE cat_activity_tbl_type IS TABLE OF cat_activity_rec_type INDEX BY BINARY_INTEGER;
95 g_miss_cat_activity_tbl cat_activity_tbl_type;
96
97 -- ==============================================================================
98 -- Start of Comments
99 -- ==============================================================================
100 -- API Name
101 -- Create_Cat_Activity
102 -- Type
103 -- Private
104 -- Pre-Req
105 --
106 -- Parameters
107 --
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113 -- p_cat_activity_rec IN cat_activity_rec_type Required
114 --
115 -- OUT
116 -- x_return_status OUT VARCHAR2
117 -- x_msg_count OUT NUMBER
118 -- x_msg_data OUT VARCHAR2
119 -- Version : Current version 1.0
120 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
121 -- and basic operation, developer must manually add parameters and business logic as necessary.
122 --
123 -- End of Comments
124 -- ==============================================================================
125 --
126
127 PROCEDURE Create_Cat_Activity(
128 p_api_version_number IN NUMBER,
129 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130 p_commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136
137 p_cat_activity_rec IN cat_activity_rec_type := g_miss_cat_activity_rec,
138 x_cat_activity_id OUT NOCOPY NUMBER
139 );
140
141 -- ==============================================================================
142 -- Start of Comments
143 -- ==============================================================================
144 -- API Name
145 -- Update_Cat_Activity
146 -- Type
147 -- Private
148 -- Pre-Req
149 --
150 -- Parameters
151 --
152 -- IN
153 -- p_api_version_number IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157 -- p_cat_activity_rec IN cat_activity_rec_type Required
158 --
159 -- OUT
160 -- x_return_status OUT VARCHAR2
161 -- x_msg_count OUT NUMBER
162 -- x_msg_data OUT VARCHAR2
163 -- Version : Current version 1.0
164 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
165 -- and basic operation, developer must manually add parameters and business logic as necessary.
166 --
167 -- End of Comments
168 -- ==============================================================================
169 --
170
171 PROCEDURE Update_Cat_Activity(
172 p_api_version_number IN NUMBER,
173 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174 p_commit IN VARCHAR2 := FND_API.G_FALSE,
175 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180
181 p_cat_activity_rec IN cat_activity_rec_type,
182 x_object_version_number OUT NOCOPY NUMBER
183 );
184
185 -- ==============================================================================
186 -- Start of Comments
187 -- ==============================================================================
188 -- API Name
189 -- Delete_Cat_Activity
190 -- Type
191 -- Private
192 -- Pre-Req
193 --
194 -- Parameters
195 --
196 -- IN
197 -- p_api_version_number IN NUMBER Required
198 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201 -- p_CAT_ACTIVITY_ID IN NUMBER
202 -- p_object_version_number IN NUMBER Optional Default = NULL
203 --
204 -- OUT
205 -- x_return_status OUT VARCHAR2
206 -- x_msg_count OUT NUMBER
207 -- x_msg_data OUT VARCHAR2
208 -- Version : Current version 1.0
209 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
210 -- and basic operation, developer must manually add parameters and business logic as necessary.
211 --
212 -- End of Comments
213 -- ==============================================================================
214 --
215
216 PROCEDURE Delete_Cat_Activity(
217 p_api_version_number IN NUMBER,
218 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219 p_commit IN VARCHAR2 := FND_API.G_FALSE,
220 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_cat_activity_id IN NUMBER,
225 p_object_version_number IN NUMBER
226 );
227
228 -- ==============================================================================
229 -- Start of Comments
230 -- ==============================================================================
231 -- API Name
232 -- Lock_Cat_Activity
233 -- Type
234 -- Private
235 -- Pre-Req
236 --
237 -- Parameters
238 --
239 -- IN
240 -- p_api_version_number IN NUMBER Required
241 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244 -- p_cat_activity_rec IN cat_activity_rec_type Required
245 --
246 -- OUT
247 -- x_return_status OUT VARCHAR2
248 -- x_msg_count OUT NUMBER
249 -- x_msg_data OUT VARCHAR2
250 -- Version : Current version 1.0
251 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
252 -- and basic operation, developer must manually add parameters and business logic as necessary.
253 --
254 -- End of Comments
255 -- ==============================================================================
256 --
257
258 PROCEDURE Lock_Cat_Activity(
259 p_api_version_number IN NUMBER,
260 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265
266 p_cat_activity_id IN NUMBER,
267 p_object_version IN NUMBER
268 );
269
270
271 -- Start of Comments
272 --
273 -- validation procedures
274 --
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 -- End of Comments
281
282 PROCEDURE Validate_cat_activity(
283 p_api_version_number IN NUMBER,
284 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286 p_cat_activity_rec IN cat_activity_rec_type,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2
290 );
291
292 -- Start of Comments
293 --
294 -- validation procedures
295 --
296 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
297 -- For create: G_CREATE, for update: G_UPDATE
298 -- Note: 1. This is automated generated item level validation procedure.
299 -- The actual validation detail is needed to be added.
300 -- 2. Validate the unique keys, lookups here
301 -- End of Comments
302
303 PROCEDURE Check_cat_activity_Items (
304 P_cat_activity_rec IN cat_activity_rec_type,
305 p_validation_mode IN VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2
307 );
308
309 -- Start of Comments
310 --
311 -- Record level validation procedures
312 --
313 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
314 -- For create: G_CREATE, for update: G_UPDATE
315 -- Note: 1. This is automated generated item level validation procedure.
316 -- The actual validation detail is needed to be added.
317 -- 2. Developer can manually added inter-field level validation.
318 -- End of Comments
319
320 PROCEDURE Validate_cat_activity_rec(
321 p_api_version_number IN NUMBER,
322 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323 x_return_status OUT NOCOPY VARCHAR2,
324 x_msg_count OUT NOCOPY NUMBER,
325 x_msg_data OUT NOCOPY VARCHAR2,
326 p_cat_activity_rec IN cat_activity_rec_type
327 );
328 END AMS_Cat_Activity_PVT;