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