1 PACKAGE PV_PRGM_PTR_TYPES_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvprps.pls 115.5 2003/05/01 18:52:18 ktsao ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_PTR_TYPES_PVT
7 -- Purpose
8 --
9 -- History
10 -- 28-FEB-2002 Paul.Ukken Created
11 -- 29-APR-2002 Peter.Nixon Modified
12 -- 14-JUN-2002 Karen.Tsao Modified to reverse logic of G_MISS_XXX and NULL.
13 -- 01-MAY-2003 Karen.Tsao Modified to partner_type in prgm_ptr_types_rec_type to VARCHAR2(30).
14 --
15 -- NOTE
16 --
17 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
18 -- All rights reserved.
19 --
20 -- End of Comments
21 -- ===============================================================
22
23 --===================================================================
24 -- Start of Comments
25 -- -------------------------------------------------------
26 -- Record name
27 -- prgm_ptr_types_rec_type
28 -- -------------------------------------------------------
29 -- Parameters:
30 -- program_partner_types_id
31 -- PROGRAM_TYPE_ID
32 -- partner_type
33 -- last_update_date
34 -- last_updated_by
35 -- creation_date
36 -- created_by
37 -- last_update_login
38 -- object_version_number
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_ptr_types_rec_type IS RECORD
50 (
51 program_partner_types_id NUMBER
52 ,PROGRAM_TYPE_ID NUMBER
53 ,partner_type VARCHAR2(30)
54 ,last_update_date DATE
55 ,last_updated_by NUMBER
56 ,creation_date DATE
57 ,created_by NUMBER
58 ,last_update_login NUMBER
59 ,object_version_number NUMBER
60
61 );
62
63 g_miss_prgm_ptr_types_rec prgm_ptr_types_rec_type;
64 TYPE prgm_ptr_types_rec_tbl_type IS TABLE OF prgm_ptr_types_rec_type INDEX BY BINARY_INTEGER;
65 g_miss_prgm_ptr_types_tbl prgm_ptr_types_rec_tbl_type;
66
67
68
69 -- ==============================================================================
70 -- Start of Comments
71 -- ==============================================================================
72 -- API Name
73 -- Create_Prgm_Ptr_Type
74 -- Type
75 -- Private
76 -- Pre-Req
77 --
78 -- Parameters
79 --
80 -- IN
81 -- p_api_version_number IN NUMBER Required
82 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85 -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
86 --
87 -- OUT
88 -- x_return_status OUT VARCHAR2
89 -- x_msg_count OUT NUMBER
90 -- x_msg_data OUT VARCHAR2
91 -- Version : Current version 1.0
92 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
93 -- and basic operation, developer must manually add parameters and business logic as necessary.
94 --
95 -- End of Comments
96 -- ==============================================================================
97 --
98 PROCEDURE Create_Prgm_Ptr_Type(
99 p_api_version_number IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
102 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type := g_miss_prgm_ptr_types_rec
107 ,x_program_partner_types_id OUT NOCOPY NUMBER
108 );
109
110
111
112
113
114 -- ==============================================================================
115 -- Start of Comments
116 -- ==============================================================================
117 -- API Name
118 -- Update_Prgm_Ptr_Type
119 -- Type
120 -- Private
121 -- Pre-Req
122 --
123 -- Parameters
124 --
125 -- IN
126 -- p_api_version_number IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130 -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
131 --
132 -- OUT
133 -- x_return_status OUT VARCHAR2
134 -- x_msg_count OUT NUMBER
135 -- x_msg_data OUT VARCHAR2
136 -- Version : Current version 1.0
137 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
138 -- and basic operation, developer must manually add parameters and business logic as necessary.
139 --
140 -- End of Comments
141 -- ==============================================================================
142 --
143 PROCEDURE Update_Prgm_Ptr_Type(
144 p_api_version_number IN NUMBER
145 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
146 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
147 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148 ,x_return_status OUT NOCOPY VARCHAR2
149 ,x_msg_count OUT NOCOPY NUMBER
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
152 );
153
154
155
156
157 -- ==============================================================================
158 -- Start of Comments
159 -- ==============================================================================
160 -- API Name
161 -- Delete_Prgm_Ptr_Type
162 -- Type
163 -- Private
164 -- Pre-Req
165 --
166 -- Parameters
167 --
168 -- IN
169 -- p_api_version_number IN NUMBER Required
170 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173 -- p_program_partner_types_id IN NUMBER
174 -- p_object_version_number IN NUMBER Optional Default = NULL
175 --
176 -- OUT
177 -- x_return_status OUT VARCHAR2
178 -- x_msg_count OUT NUMBER
179 -- x_msg_data OUT VARCHAR2
180 -- Version : Current version 1.0
181 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
182 -- and basic operation, developer must manually add parameters and business logic as necessary.
183 --
184 -- End of Comments
185 -- ==============================================================================
186 --
187 PROCEDURE Delete_Prgm_Ptr_Type(
188 p_api_version_number IN NUMBER
189 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
190 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
191 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
192 ,x_return_status OUT NOCOPY VARCHAR
193 ,x_msg_count OUT NOCOPY NUMBER
194 ,x_msg_data OUT NOCOPY VARCHAR2
195 ,p_program_partner_types_id IN NUMBER
196 ,p_object_version_number IN NUMBER
197 );
198
199
200
201
202
203 -- ==============================================================================
204 -- Start of Comments
205 -- ==============================================================================
206 -- API Name
207 -- Lock_Prgm_Ptr_Type
208 -- Type
209 -- Private
210 -- Pre-Req
211 --
212 -- Parameters
213 --
214 -- IN
215 -- p_api_version_number IN NUMBER Required
216 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219 -- p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type Required
220 --
221 -- OUT
222 -- x_return_status OUT VARCHAR2
223 -- x_msg_count OUT NUMBER
224 -- x_msg_data OUT VARCHAR2
225 -- Version : Current version 1.0
226 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
227 -- and basic operation, developer must manually add parameters and business logic as necessary.
228 --
229 -- End of Comments
230 -- ==============================================================================
231 --
232 PROCEDURE Lock_Prgm_Ptr_Type(
233 p_api_version_number IN NUMBER
234 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
235 ,x_return_status OUT NOCOPY VARCHAR2
236 ,x_msg_count OUT NOCOPY NUMBER
237 ,x_msg_data OUT NOCOPY VARCHAR2
238 ,p_program_partner_types_id IN NUMBER
239 ,p_object_version IN NUMBER
240 );
241
242
243
244
245 -- ==============================================================================
246 -- Start of Comments
247 -- ==============================================================================
248 -- API Name
249 -- Validate_Prgm_Ptr_Type
250 --
251 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
252 -- For create: G_CREATE, for update: G_UPDATE
253 -- Note: 1. This is automated generated item level validation PROCEDURE.
254 -- The actual validation detail is needed to be added.
255 -- 2. We can also validate table instead of record. There will be an option for user to choose.
256 -- ==============================================================================
257 -- End of Comments
258 -- ==============================================================================
259 PROCEDURE Validate_Prgm_Ptr_Type(
260 p_api_version_number IN NUMBER
261 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
263 ,p_validation_mode IN VARCHAR2
264 ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
265 ,x_return_status OUT NOCOPY VARCHAR2
266 ,x_msg_count OUT NOCOPY NUMBER
267 ,x_msg_data OUT NOCOPY VARCHAR2
268 );
269
270
271
272
273 -- ==============================================================================
274 -- Start of Comments
275 -- ==============================================================================
276 -- API Name
277 -- Check_Items
278 --
279 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
280 -- For create: G_CREATE, for update: G_UPDATE
281 -- Note: 1. This is automated generated item level validation PROCEDURE.
282 -- The actual validation detail is needed to be added.
283 -- 2. Validate the unique keys, lookups here
284 -- ==============================================================================
285 -- End of Comments
286 -- ==============================================================================
287 PROCEDURE Check_Items (
288 P_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
289 ,p_validation_mode IN VARCHAR2
290 ,x_return_status OUT NOCOPY VARCHAR2
291 );
292
293
294
295
296 -- ==============================================================================
297 -- Start of Comments
298 -- ==============================================================================
299 -- API Name
300 -- Validate_Rec
301 -- Record level validation procedures
302 --
303 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
304 -- For create: G_CREATE, for update: G_UPDATE
305 -- Note: 1. This is automated generated item level validation PROCEDURE.
306 -- The actual validation detail is needed to be added.
307 -- 2. Developer can manually added inter-field level validation.
308 -- ==============================================================================
309 -- End of Comments
310 -- ==============================================================================
311 PROCEDURE Validate_Rec(
312 p_api_version_number IN NUMBER
313 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314 ,x_return_status OUT NOCOPY VARCHAR2
315 ,x_msg_count OUT NOCOPY NUMBER
316 ,x_msg_data OUT NOCOPY VARCHAR
317 ,p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
318 );
319
320
321
322
323 -- ==============================================================================
324 -- Start of Comments
325 -- ==============================================================================
326 -- API Name
327 -- Complete_Rec
328 --
329 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
330 -- For create: G_CREATE, for update: G_UPDATE
331 -- Note: 1. This is automated generated item level validation PROCEDURE.
332 -- The actual validation detail is needed to be added.
333 -- 2. Developer can manually added inter-field level validation.
334 -- ==============================================================================
335 -- End of Comments
336 -- ==============================================================================
337 PROCEDURE Complete_Rec (
338 p_prgm_ptr_types_rec IN prgm_ptr_types_rec_type
339 ,x_complete_rec OUT NOCOPY prgm_ptr_types_rec_type
340 );
341
342
343
344 END PV_PRGM_PTR_TYPES_PVT;