1 PACKAGE PV_PRGM_PMT_MODE_PVT AS
2 /* $Header: pvxvppms.pls 120.0 2005/05/27 15:29:57 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_PMT_MODE_PVT
7 -- Purpose
8 --
9 -- History
10 -- 26-APR-2002 Peter.Nixon Created
11 -- 30-APR-2002 Peter.Nixon Modified
12 -- NOTE
13 --
14 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
15 -- All rights reserved.
16 --
17 -- End of Comments
18 -- ===============================================================
19
20
21
22 --===================================================================
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name
26 -- prgm_pmt_mode_rec_type
27 -- -------------------------------------------------------
28 -- Parameters:
29 -- program_payment_mode_id
30 -- program_id
31 -- geo_hierarchy_id
32 -- mode_of_payment
33 -- last_update_date
34 -- last_updated_by
35 -- creation_date
36 -- created_by
37 -- last_update_login
38 -- object_version_number
39 -- mode_type
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE prgm_pmt_mode_rec_type IS RECORD
52 (
53 -- Following are the changes made for the new API standars
54
55 -- program_payment_mode_id NUMBER := FND_API.G_MISS_NUM
56 -- ,program_id NUMBER := FND_API.G_MISS_NUM
57 -- ,geo_hierarchy_id NUMBER := FND_API.G_MISS_NUM
58 -- ,mode_of_payment VARCHAR2(15) := FND_API.G_MISS_CHAR
59 -- ,last_update_date DATE := FND_API.G_MISS_DATE
60 -- ,last_updated_by NUMBER := FND_API.G_MISS_NUM
61 -- ,creation_date DATE := FND_API.G_MISS_DATE
62 -- ,created_by NUMBER := FND_API.G_MISS_NUM
63 -- ,last_update_login NUMBER := FND_API.G_MISS_NUM
64 -- ,object_version_number NUMBER := FND_API.G_MISS_NUM
65
66 program_payment_mode_id NUMBER
67 ,program_id NUMBER
68 ,geo_hierarchy_id NUMBER
69 ,mode_of_payment VARCHAR2(15)
70 ,last_update_date DATE
71 ,last_updated_by NUMBER
72 ,creation_date DATE
73 ,created_by NUMBER
74 ,last_update_login NUMBER
75 ,object_version_number NUMBER
76 ,mode_type VARCHAR2(15)
77
78
79 );
80
81 g_miss_prgm_pmt_mode_rec prgm_pmt_mode_rec_type;
82 TYPE prgm_pmt_mode_tbl_type IS TABLE OF prgm_pmt_mode_rec_type INDEX BY BINARY_INTEGER;
83 g_miss_prgm_pmt_mode_tbl prgm_pmt_mode_tbl_type;
84
85
86
87
88 -- ==============================================================================
89 -- Start of Comments
90 -- ==============================================================================
91 -- API Name
92 -- Create_Prgm_Pmt_Mode
93 -- Type
94 -- Private
95 -- Pre-Req
96 --
97 -- Parameters
98 --
99 -- IN
100 -- p_api_version_number IN NUMBER Required
101 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
104 -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
105 --
106 -- OUT
107 -- x_return_status OUT VARCHAR2
108 -- x_msg_count OUT NUMBER
109 -- x_msg_data OUT VARCHAR2
110 -- Version : Current version 1.0
111 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
112 -- and basic operation, developer must manually add parameters and business logic as necessary.
113 --
114 -- End of Comments
115 -- ==============================================================================
116 PROCEDURE Create_Prgm_Pmt_Mode(
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_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type := g_miss_prgm_pmt_mode_rec
127 ,x_program_payment_mode_id OUT NOCOPY NUMBER
128 );
129
130
131
132
133 -- ==============================================================================
134 -- Start of Comments
135 -- ==============================================================================
136 -- API Name
137 -- Update_Prgm_Pmt_Mode
138 -- Type
139 -- Private
140 -- Pre-Req
141 --
142 -- Parameters
143 --
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149 -- p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type Required
150 --
151 -- OUT
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 -- Version : Current version 1.0
156 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
157 -- and basic operation, developer must manually add parameters and business logic as necessary.
158 --
159 -- End of Comments
160 -- ==============================================================================
161 PROCEDURE Update_Prgm_Pmt_Mode(
162 p_api_version_number IN NUMBER
163 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
164 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
165 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
166
167 ,x_return_status OUT NOCOPY VARCHAR2
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170
171 ,p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
172 );
173
174
175
176
177 -- ==============================================================================
178 -- Start of Comments
179 -- ==============================================================================
180 -- API Name
181 -- Delete_Prgm_Pmt_Mode
182 -- Type
183 -- Private
184 -- Pre-Req
185 --
186 -- Parameters
187 --
188 -- IN
189 -- p_api_version_number IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193 -- p_program_payment_mode_id IN NUMBER
194 -- p_object_version_number IN NUMBER Optional Default = NULL
195 --
196 -- OUT
197 -- x_return_status OUT VARCHAR2
198 -- x_msg_count OUT NUMBER
199 -- x_msg_data OUT VARCHAR2
200 -- Version : Current version 1.0
201 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
202 -- and basic operation, developer must manually add parameters and business logic as necessary.
203 --
204 -- End of Comments
205 -- ==============================================================================
206 PROCEDURE Delete_Prgm_Pmt_Mode(
207 p_api_version_number IN NUMBER
208 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
210 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
211
212 ,x_return_status OUT NOCOPY VARCHAR2
213 ,x_msg_count OUT NOCOPY NUMBER
214 ,x_msg_data OUT NOCOPY VARCHAR2
215
216 ,p_program_payment_mode_id IN NUMBER
217 ,p_object_version_number IN NUMBER
218 );
219
220
221
222 -- ==============================================================================
223 -- Start of Comments
224 -- ==============================================================================
225 -- API Name
226 -- Lock_Prgm_Pmt_Mode
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_prgm_pmt_mode_rec IN prgm_pmt_mode_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 -- End of Comments
249 -- ==============================================================================
250 PROCEDURE Lock_Prgm_Pmt_Mode(
251 p_api_version_number IN NUMBER
252 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
253
254 ,x_return_status OUT NOCOPY VARCHAR2
255 ,x_msg_count OUT NOCOPY NUMBER
256 ,x_msg_data OUT NOCOPY VARCHAR2
257
258 ,p_program_payment_mode_id IN NUMBER
259 ,p_object_version IN NUMBER
260 );
261
262
263
264
265 -- ==============================================================================
266 -- Start of Comments
267 -- ==============================================================================
268 -- API Name
269 -- Validate_Prgm_Pmt_Mode
270 --
271 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
272 -- For create: G_CREATE, for update: G_UPDATE
273 -- Note: 1. This is automated generated item level validation procedure.
274 -- The actual validation detail is needed to be added.
275 -- 2. We can also validate table instead of record. There will be an option for user to choose.
276 -- End of Comments
277 -- =======================================
278 PROCEDURE Validate_Prgm_Pmt_Mode(
279 p_api_version_number IN NUMBER
280 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
281 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
282 ,p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
283 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
284
285 ,x_return_status OUT NOCOPY VARCHAR2
286 ,x_msg_count OUT NOCOPY NUMBER
287 ,x_msg_data OUT NOCOPY VARCHAR2
288 );
289
290
291
292
293 -- ==============================================================================
294 -- Start of Comments
295 -- ==============================================================================
296 -- API Name
297 -- Check_Items
298 --
299 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
300 -- For create: G_CREATE, for update: G_UPDATE
301 -- Note: 1. This is automated generated item level validation PROCEDURE.
302 -- The actual validation detail is needed to be added.
303 -- 2. Validate the unique keys, lookups here
304 -- ==============================================================================
305 -- End of Comments
306 -- ==============================================================================
307 PROCEDURE Check_Items (
308 p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
309 ,p_validation_mode IN VARCHAR2
310
311 ,x_return_status OUT NOCOPY VARCHAR2
312 );
313
314
315
316
317 -- ==============================================================================
318 -- Start of Comments
319 -- ==============================================================================
320 -- API Name
321 -- Validate_rec
322 -- Record level validation procedures
323 --
324 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
325 -- For create: G_CREATE, for update: G_UPDATE
326 -- Note: 1. This is automated generated item level validation PROCEDURE.
327 -- The actual validation detail is needed to be added.
328 -- 2. Developer can manually added inter-field level validation.
329 -- ==============================================================================
330 -- End of Comments
331 -- ==============================================================================
332 PROCEDURE Validate_Rec(
333 p_api_version_number IN NUMBER
334 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
335
336 ,x_return_status OUT NOCOPY VARCHAR2
337 ,x_msg_count OUT NOCOPY NUMBER
338 ,x_msg_data OUT NOCOPY VARCHAR2
339
340 ,p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
341 ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
342 );
343
344
345
346
347 -- ==============================================================================
348 -- Start of Comments
349 -- ==============================================================================
350 -- API Name
351 -- Complete_Rec
352 --
353 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
354 -- For create: G_CREATE, for update: G_UPDATE
355 -- Note: 1. This is automated generated item level validation PROCEDURE.
356 -- The actual validation detail is needed to be added.
357 -- 2. Developer can manually added inter-field level validation.
358 -- ==============================================================================
359 -- End of Comments
360 -- ==============================================================================
361 PROCEDURE Complete_Rec (
362 p_prgm_pmt_mode_rec IN prgm_pmt_mode_rec_type
363 ,x_complete_rec OUT NOCOPY prgm_pmt_mode_rec_type
364 );
365
366 END PV_PRGM_PMT_MODE_PVT;