1 PACKAGE PV_PRGM_BENEFITS_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvppbs.pls 115.7 2003/11/07 06:13:57 ktsao ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_BENEFITS_PVT
7 -- Purpose
8 --
9 -- History
10 -- 28-FEB-2002 Jessica.Lee Created
11 -- 1-APR-2002 Peter.Nixon Modified
12 -- Changed benefit_id NUMBER to benefit_code VARCHAR2
13 -- 24-SEP-2003 Karen.Tsao Modified for 11.5.10
14 -- 02-OCT-2003 Karen.Tsao Modified prgm_benefits_rec_type to add responsibility_id
15 -- 06-NOV-2003 Karen.Tsao Took out column responsibility_id
16 -- NOTE
17 --
18 -- End of Comments
19 -- ===============================================================
20
21
22 --===================================================================
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name
26 -- prgm_benefits_rec_type
27 -- -------------------------------------------------------
28 -- Parameters:
29 -- program_benefits_id
30 -- program_id
31 -- benefit_code
32 -- last_update_login
33 -- object_version_number
34 -- last_update_date
35 -- last_updated_by
36 -- created_by
37 -- creation_date
38 --
39 -- Required
40 --
41 -- Defaults
42 --
43 -- Note: This is automatic generated record definition, it includes all columns
44 -- defined in the table, developer must manually add or delete some of the attributes.
45 --
46 -- End of Comments
47 --
48 --===================================================================
49 TYPE prgm_benefits_rec_type IS RECORD
50 (
51 program_benefits_id NUMBER
52 ,program_id NUMBER
53 ,benefit_code VARCHAR2(30)
54 ,benefit_id NUMBER
55 ,benefit_type_code VARCHAR2(30)
56 ,delete_flag VARCHAR2(1)
57 ,last_update_login NUMBER
58 ,object_version_number NUMBER
59 ,last_update_date DATE
60 ,last_updated_by NUMBER
61 ,created_by NUMBER
62 ,creation_date DATE
63
64 );
65
66 g_miss_prgm_benefits_rec prgm_benefits_rec_type;
67 TYPE program_benefits_tbl_type IS TABLE OF prgm_benefits_rec_type INDEX BY BINARY_INTEGER;
68 g_miss_program_benefits_tbl program_benefits_tbl_type;
69
70
71
72
73 -- ==============================================================================
74 -- Start of Comments
75 -- ==============================================================================
76 -- API Name
77 -- Create_Prgm_Benefits
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_prgm_benefits_rec IN prgm_benefits_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 -- End of Comments
100 -- ==============================================================================
101 PROCEDURE Create_Prgm_Benefits(
102 p_api_version_number IN NUMBER
103 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
105 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
106
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110
111 ,p_prgm_benefits_rec IN prgm_benefits_rec_type := g_miss_prgm_benefits_rec
112 ,x_program_benefits_id OUT NOCOPY NUMBER
113 );
114
115
116
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Prgm_Benefits
123 -- Type
124 -- Private
125 -- Pre-Req
126 --
127 -- Parameters
128 --
129 -- IN
130 -- p_api_version_number IN NUMBER Required
131 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134 -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
135 --
136 -- OUT
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- End of Comments
145 -- ==============================================================================
146 PROCEDURE Update_Prgm_Benefits(
147 p_api_version_number IN NUMBER
148 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155
156 ,p_prgm_benefits_rec IN prgm_benefits_rec_type
157 );
158
159
160
161
162 -- ==============================================================================
163 -- Start of Comments
164 -- ==============================================================================
165 -- API Name
166 -- Delete_Prgm_Benefits
167 -- Type
168 -- Private
169 -- Pre-Req
170 --
171 -- Parameters
172 --
173 -- IN
174 -- p_api_version_number IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178 -- p_program_benefits_id IN NUMBER
179 -- p_object_version_number IN NUMBER Optional Default = NULL
180 --
181 -- OUT
182 -- x_return_status OUT VARCHAR2
183 -- x_msg_count OUT NUMBER
184 -- x_msg_data OUT VARCHAR2
185 -- Version : Current version 1.0
186 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
187 -- and basic operation, developer must manually add parameters and business logic as necessary.
188 --
189 -- End of Comments
190 -- =============================================================================
191 PROCEDURE Delete_Prgm_Benefits(
192 p_api_version_number IN NUMBER
193 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_msg_count OUT NOCOPY NUMBER
199 ,x_msg_data OUT NOCOPY VARCHAR2
200
201 ,p_program_benefits_id IN NUMBER
202 ,p_object_version_number IN NUMBER
203 );
204
205
206
207 -- ==============================================================================
208 -- Start of Comments
209 -- ==============================================================================
210 -- API Name
211 -- Lock_Prgm_Benefits
212 -- Type
213 -- Private
214 -- Pre-Req
215 --
216 -- Parameters
217 --
218 -- IN
219 -- p_api_version_number IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223 -- p_prgm_benefits_rec IN prgm_benefits_rec_type Required
224 --
225 -- OUT
226 -- x_return_status OUT VARCHAR2
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2
229 -- Version : Current version 1.0
230 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
231 -- and basic operation, developer must manually add parameters and business logic as necessary.
232 --
233 -- End of Comments
234 -- ==============================================================================
235 PROCEDURE Lock_Prgm_Benefits(
236 p_api_version_number IN NUMBER
237 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238
239 ,x_return_status OUT NOCOPY VARCHAR2
240 ,x_msg_count OUT NOCOPY NUMBER
241 ,x_msg_data OUT NOCOPY VARCHAR2
242
243 ,px_program_benefits_id IN NUMBER
244 ,p_object_version IN NUMBER
245 );
246
247
248
249
250 -- ==============================================================================
251 -- Start of Comments
252 -- ==============================================================================
253 -- API Name
254 -- Validate_Prgm_Benefits
255 --
256 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
257 -- For create: G_CREATE, for update: G_UPDATE
258 -- Note: 1. This is automated generated item level validation procedure.
259 -- The actual validation detail is needed to be added.
260 -- 2. We can also validate table instead of record. There will be an option for user to choose.
261 -- End of Comments
262 -- =======================================
263 PROCEDURE Validate_Prgm_Benefits(
264 p_api_version_number IN NUMBER
265 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
266 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
267 ,p_prgm_benefits_rec IN prgm_benefits_rec_type
268 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
269
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
277
278 -- ==============================================================================
279 -- Start of Comments
280 -- ==============================================================================
281 -- API Name
282 -- Check_Items
283 --
284 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
285 -- For create: G_CREATE, for update: G_UPDATE
286 -- Note: 1. This is automated generated item level validation PROCEDURE.
287 -- The actual validation detail is needed to be added.
288 -- 2. Validate the unique keys, lookups here
289 -- ==============================================================================
290 -- End of Comments
291 -- ==============================================================================
292 PROCEDURE Check_Items (
293 p_prgm_benefits_rec IN prgm_benefits_rec_type
294 ,p_validation_mode IN VARCHAR2
295
296 ,x_return_status OUT NOCOPY VARCHAR2
297 );
298
299
300
301
302 -- ==============================================================================
303 -- Start of Comments
304 -- ==============================================================================
305 -- API Name
306 -- Validate_rec
307 -- Record level validation procedures
308 --
309 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
310 -- For create: G_CREATE, for update: G_UPDATE
311 -- Note: 1. This is automated generated item level validation PROCEDURE.
312 -- The actual validation detail is needed to be added.
313 -- 2. Developer can manually added inter-field level validation.
314 -- ==============================================================================
315 -- End of Comments
316 -- ==============================================================================
317 PROCEDURE Validate_Rec(
318 p_api_version_number IN NUMBER
319 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320
321 ,x_return_status OUT NOCOPY VARCHAR2
322 ,x_msg_count OUT NOCOPY NUMBER
323 ,x_msg_data OUT NOCOPY VARCHAR2
324
325 ,p_prgm_benefits_rec IN prgm_benefits_rec_type
326 ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
327 );
328
329
330
331
332 -- ==============================================================================
333 -- Start of Comments
334 -- ==============================================================================
335 -- API Name
336 -- Complete_Rec
337 --
338 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
339 -- For create: G_CREATE, for update: G_UPDATE
340 -- Note: 1. This is automated generated item level validation PROCEDURE.
341 -- The actual validation detail is needed to be added.
342 -- 2. Developer can manually added inter-field level validation.
343 -- ==============================================================================
344 -- End of Comments
345 -- ==============================================================================
346 PROCEDURE Complete_Rec (
347 p_prgm_benefits_rec IN prgm_benefits_rec_type
348 ,x_complete_rec OUT NOCOPY prgm_benefits_rec_type
349 );
350
351
352 END PV_PRGM_BENEFITS_PVT;