1 PACKAGE PV_Ge_Notif_Rules_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvgnrs.pls 120.1 2005/06/28 10:33:43 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Ge_Notif_Rules_PVT
7 -- Purpose
8 --
9 -- History
10 -- 15 Nov 2002 anubhavk created
11 -- 19 Nov 2002 anubhavk Updated - For NOCOPY by running nocopy.sh
12 --
13 -- NOTE
14 --
15 -- This Api is generated with Latest version of
16 -- Rosetta, where g_miss indicates NULL and
17 -- NULL indicates missing value. Rosetta Version 1.55
18 -- End of Comments
19 -- ===============================================================
20
21 -- Default number of records fetch per call
22 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23 --===================================================================
24 -- Start of Comments
25 -- -------------------------------------------------------
26 -- Record name
27 -- ge_notif_rules_rec_type
28 -- -------------------------------------------------------
29 -- Parameters:
30 -- notif_rule_id
31 -- object_version_number
32 -- arc_notif_for_entity_code
33 -- notif_for_entity_id
34 -- wf_item_type_code
35 -- notif_type_code
36 -- active_flag
37 -- repeat_freq_unit
38 -- repeat_freq_value
39 -- send_notif_before_unit
40 -- send_notif_before_value
41 -- send_notif_after_unit
42 -- send_notif_after_value
43 -- repeat_until_unit
44 -- repeat_until_value
45 -- created_by
46 -- creation_date
47 -- last_updated_by
48 -- last_update_date
49 -- last_update_login
50 --
51 -- Required
52 --
53 -- Defaults
54 --
55 -- Note: This is automatic generated record definition, it includes all columns
56 -- defined in the table, developer must manually add or delete some of the attributes.
57 --
58 -- End of Comments
59
60 --===================================================================
61 TYPE ge_notif_rules_rec_type IS RECORD
62 (
63 notif_rule_id NUMBER,
64 object_version_number NUMBER,
65 arc_notif_for_entity_code VARCHAR2(30),
66 notif_for_entity_id NUMBER,
67 wf_item_type_code VARCHAR2(30),
68 notif_type_code VARCHAR2(30),
69 active_flag VARCHAR2(1),
70 repeat_freq_unit VARCHAR2(30),
71 repeat_freq_value NUMBER,
72 send_notif_before_unit VARCHAR2(30),
73 send_notif_before_value NUMBER,
74 send_notif_after_unit VARCHAR2(30),
75 send_notif_after_value NUMBER,
76 repeat_until_unit VARCHAR2(30),
77 repeat_until_value NUMBER,
78 created_by NUMBER,
79 creation_date DATE,
80 last_updated_by NUMBER,
81 last_update_date DATE,
82 last_update_login NUMBER,
83 notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84 notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85 notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86
87
88 );
89
90 g_miss_ge_notif_rules_rec ge_notif_rules_rec_type := NULL;
91 TYPE ge_notif_rules_tbl_type IS TABLE OF ge_notif_rules_rec_type INDEX BY BINARY_INTEGER;
92 g_miss_ge_notif_rules_tbl ge_notif_rules_tbl_type;
93
94 -- ==============================================================================
95 -- Start of Comments
96 -- ==============================================================================
97 -- API Name
98 -- Create_Ge_Notif_Rules
99 -- Type
100 -- Private
101 -- Pre-Req
102 --
103 -- Parameters
104 --
105 -- IN
106 -- p_api_version_number IN NUMBER Required
107 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110 -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111 --
112 -- OUT
113 -- x_return_status OUT VARCHAR2
114 -- x_msg_count OUT NUMBER
115 -- x_msg_data OUT VARCHAR2
116 -- Version : Current version 1.0
117 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
118 -- and basic operation, developer must manually add parameters and business logic as necessary.
119 --
120 -- History
121 --
122 -- NOTE
123 --
124 -- End of Comments
125 -- ==============================================================================
126
127 PROCEDURE Create_Ge_Notif_Rules(
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_ge_notif_rules_rec IN ge_notif_rules_rec_type := g_miss_ge_notif_rules_rec,
138 x_notif_rule_id OUT NOCOPY NUMBER
139 );
140
141 -- ==============================================================================
142 -- Start of Comments
143 -- ==============================================================================
144 -- API Name
145 -- Copy_Row
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_src_object_id IN NUMBER Required
158 -- p_tar_object_id IN NUMBER Required
159 --
160 -- OUT
161 -- x_return_status OUT VARCHAR2
162 -- x_msg_count OUT NUMBER
163 -- x_msg_data OUT VARCHAR2
164 -- Version : Current version 1.0
165 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
166 -- and basic operation, developer must manually add parameters and business logic as necessary.
167 --
168 -- History
169 --
170 -- NOTE
171 --
172 -- End of Comments
173 -- ==============================================================================
174 PROCEDURE Copy_Row
175 (
176 p_api_version_number IN NUMBER
177 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180 ,x_return_status OUT NOCOPY VARCHAR2
181 ,x_msg_count OUT NOCOPY NUMBER
182 ,x_msg_data OUT NOCOPY VARCHAR2
183 ,p_src_object_id IN NUMBER
184 ,p_tar_object_id IN NUMBER
185 );
186
187 -- ==============================================================================
188 -- Start of Comments
189 -- ==============================================================================
190 -- API Name
191 -- Update_Ge_Notif_Rules
192 -- Type
193 -- Private
194 -- Pre-Req
195 --
196 -- Parameters
197 --
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203 -- p_ge_notif_rules_rec IN ge_notif_rules_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 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
211 -- and basic operation, developer must manually add parameters and business logic as necessary.
212 --
213 -- History
214 --
215 -- NOTE
216 --
217 -- End of Comments
218 -- ==============================================================================
219
220 PROCEDURE Update_Ge_Notif_Rules(
221 p_api_version_number IN NUMBER,
222 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223 p_commit IN VARCHAR2 := FND_API.G_FALSE,
224 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229
230 p_ge_notif_rules_rec IN ge_notif_rules_rec_type
231 );
232
233 -- ==============================================================================
234 -- Start of Comments
235 -- ==============================================================================
236 -- API Name
237 -- Delete_Ge_Notif_Rules
238 -- Type
239 -- Private
240 -- Pre-Req
241 --
242 -- Parameters
243 --
244 -- IN
245 -- p_api_version_number IN NUMBER Required
246 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249 -- p_notif_rule_id IN NUMBER
250 -- p_object_version_number IN NUMBER Optional Default = NULL
251 --
252 -- OUT
253 -- x_return_status OUT VARCHAR2
254 -- x_msg_count OUT NUMBER
255 -- x_msg_data OUT VARCHAR2
256 -- Version : Current version 1.0
257 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
258 -- and basic operation, developer must manually add parameters and business logic as necessary.
259 --
260 -- History
261 --
262 -- NOTE
263 --
264 -- End of Comments
265 -- ==============================================================================
266
267 PROCEDURE Delete_Ge_Notif_Rules(
268 p_api_version_number IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270 p_commit IN VARCHAR2 := FND_API.G_FALSE,
271 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_notif_rule_id IN NUMBER,
276 p_object_version_number IN NUMBER
277 );
278
279 -- ==============================================================================
280 -- Start of Comments
281 -- ==============================================================================
282 -- API Name
283 -- Lock_Ge_Notif_Rules
284 -- Type
285 -- Private
286 -- Pre-Req
287 --
288 -- Parameters
289 --
290 -- IN
291 -- p_api_version_number IN NUMBER Required
292 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295 -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296 --
297 -- OUT
298 -- x_return_status OUT VARCHAR2
299 -- x_msg_count OUT NUMBER
300 -- x_msg_data OUT VARCHAR2
301 -- Version : Current version 1.0
302 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
303 -- and basic operation, developer must manually add parameters and business logic as necessary.
304 --
305 -- History
306 --
307 -- NOTE
308 --
309 -- End of Comments
310 -- ==============================================================================
311
312 PROCEDURE Lock_Ge_Notif_Rules(
313 p_api_version_number IN NUMBER,
314 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319
320 p_notif_rule_id IN NUMBER,
321 p_object_version IN NUMBER
322 );
323
324
325 -- ==============================================================================
326 -- Start of Comments
327 -- ==============================================================================
328 -- API Name
329 -- Validate_Ge_Notif_Rules
330 --
331 -- Version : Current version 1.0
332 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
333 -- For create: G_CREATE, for update: G_UPDATE
334 -- Note: 1. This is automated generated item level validation procedure.
335 -- The actual validation detail is needed to be added.
336 -- 2. We can also validate table instead of record. There will be an option for user to choose.
337 --
338 -- History
339 --
340 -- NOTE
341 --
342 -- End of Comments
343 -- ==============================================================================
344
345
346 PROCEDURE Validate_Ge_Notif_Rules(
347 p_api_version_number IN NUMBER,
348 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350 p_ge_notif_rules_rec IN ge_notif_rules_rec_type,
351 p_validation_mode 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 -- Start of Comments
359 -- ==============================================================================
360 -- API Name
361 -- Ge_Notif_Rules_Items
362 --
363 -- Version : Current version 1.0
364 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
365 -- For create: G_CREATE, for update: G_UPDATE
366 -- Note: 1. This is automated generated item level validation procedure.
367 -- The actual validation detail is needed to be added.
368 -- 2. Validate the unique keys, lookups here
369 --
370 -- History
371 --
372 -- NOTE
373 --
374 -- End of Comments
375 -- ==============================================================================
376
377
378 PROCEDURE Check_Ge_Notif_Rules_Items (
379 P_ge_notif_rules_rec IN ge_notif_rules_rec_type,
380 p_validation_mode IN VARCHAR2,
381 x_return_status OUT NOCOPY VARCHAR2
382 );
383
384 -- ==============================================================================
385 -- Start of Comments
386 -- ==============================================================================
387 -- API Name
388 -- Validate_Ge_Notif_Rules_Rec
389 --
390 -- Version : Current version 1.0
391 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
392 -- For create: G_CREATE, for update: G_UPDATE
393 -- Note: 1. This is automated generated item level validation procedure.
394 -- The actual validation detail is needed to be added.
395 -- 2. Developer can manually added inter-field level validation.
396 --
397 -- History
398 --
399 -- NOTE
400 --
401 -- End of Comments
402 -- ==============================================================================
403
404
405 PROCEDURE Validate_Ge_Notif_Rules_Rec (
406 p_api_version_number IN NUMBER,
407 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
408 x_return_status OUT NOCOPY VARCHAR2,
409 x_msg_count OUT NOCOPY NUMBER,
410 x_msg_data OUT NOCOPY VARCHAR2,
411 p_ge_notif_rules_rec IN ge_notif_rules_rec_type
412 );
413
414 PROCEDURE Create_Ge_Notif_Rules_Rec (
415 p_api_version_number IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417 p_commit IN VARCHAR2 := FND_API.G_FALSE,
418 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419
420 x_return_status OUT NOCOPY VARCHAR2,
421 x_msg_count OUT NOCOPY NUMBER,
422 x_msg_data OUT NOCOPY VARCHAR2,
423 p_programId IN NUMBER
424 );
425
426
427 END PV_Ge_Notif_Rules_PVT;