1 PACKAGE PV_PARTNER_PGM_TYPE_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvppts.pls 115.4 2002/12/10 20:48:58 ktsao ship $*/
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PARTNER_PGM_TYPE_PVT
7 -- Purpose
8 --
9 -- History
10 -- 22-APR-2002 Peter.Nixon Created
11 -- 11-JUN-2002 Karen.Tsao Modified to reverse logic of G_MISS_XXX and NULL.
12 --
13 -- NOTE
14 --
15 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
16 -- All rights reserved.
17 --
18 -- End of Comments
19 -- ===============================================================
20
21
22
23 --===================================================================
24 -- Start of Comments
25 -- -------------------------------------------------------
26 -- Record name
27 -- ptr_prgm_type_rec_type
28 -- -------------------------------------------------------
29 -- Parameters:
30 -- PROGRAM_TYPE_ID
31 -- active_flag
32 -- enabled_flag
33 -- object_version_number
34 -- creation_date
35 -- created_by
36 -- last_update_date
37 -- last_updated_by
38 -- last_update_login
39 -- security_group_id
40 -- program_type_name
41 -- program_type_description
42 --
43 -- Required
44 --
45 -- Defaults
46 --
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51
52 --===================================================================
53 TYPE ptr_prgm_type_rec_type IS RECORD
54 (
55 PROGRAM_TYPE_ID NUMBER
56 ,active_flag VARCHAR2(1)
57 ,enabled_flag VARCHAR2(1)
58 ,object_version_number NUMBER
59 ,creation_date DATE
60 ,created_by NUMBER
61 ,last_update_date DATE
62 ,last_updated_by NUMBER
63 ,last_update_login NUMBER
64 ,program_type_name VARCHAR2(60)
65 ,program_type_description VARCHAR2(240)
66 ,source_lang VARCHAR2(4)
67 );
68
69
70 g_miss_ptr_prgm_type_rec ptr_prgm_type_rec_type;
71 TYPE ptr_prgm_type_tbl_type IS TABLE OF ptr_prgm_type_rec_type INDEX BY BINARY_INTEGER;
72 g_miss_ptr_prgm_type_tbl ptr_prgm_type_tbl_type;
73
74 -- ==============================================================================
75 -- Start of Comments
76 -- ==============================================================================
77 -- API Name
78 -- Create_Partner_Pgm_Type
79 -- Type
80 -- Private
81 -- Pre-Req
82 --
83 -- Parameters
84 --
85 -- IN
86 -- p_api_version_number IN NUMBER Required
87 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90 -- p_ptr_pgrm_type_rec IN ptr_prgm_type_rec_type Required
91 --
92 -- OUT
93 -- x_return_status OUT VARCHAR2
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2
96 -- Version : Current version 1.0
97 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
98 -- and basic operation, developer must manually add parameters and business logic as necessary.
99 --
100 -- End of Comments
101 -- ==============================================================================
102 --
103 PROCEDURE Create_Partner_Pgm_Type(
104 p_api_version_number IN NUMBER
105 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
106 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
107 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type := g_miss_ptr_prgm_type_rec
112 ,x_PROGRAM_TYPE_ID OUT NOCOPY NUMBER
113 );
114
115
116
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Partner_Pgm_Type
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_ptr_prgm_type_rec IN ptr_prgm_type_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 --
147 PROCEDURE Update_Partner_Pgm_Type(
148 p_api_version_number IN NUMBER
149 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156
157 ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
158 );
159
160
161
162
163 -- ==============================================================================
164 -- Start of Comments
165 -- ==============================================================================
166 -- API Name
167 -- Delete_Partner_Program
168 -- This procedure performs a soft delete by calling the UPDATE table handler
169 -- and setting ENABLED_FLAG to 'N'.
170 -- Type
171 -- Private
172 -- Pre-Req
173 --
174 -- Parameters
175 --
176 -- IN
177 -- p_api_version_number IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181 -- p_PROGRAM_TYPE_ID IN NUMBER
182 -- p_object_version_number IN NUMBER Optional Default = NULL
183 --
184 -- OUT
185 -- x_return_status OUT VARCHAR2
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2
188 -- Version : Current version 1.0
189 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
190 -- and basic operation, developer must manually add parameters and business logic as necessary.
191 --
192 -- End of Comments
193 -- ==============================================================================
194 --
195 PROCEDURE Delete_Partner_Pgm_Type(
196 p_api_version_number IN NUMBER
197 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
200 ,x_return_status OUT NOCOPY VARCHAR2
201 ,x_msg_count OUT NOCOPY NUMBER
202 ,x_msg_data OUT NOCOPY VARCHAR2
203 ,p_PROGRAM_TYPE_ID IN NUMBER
204 ,p_object_version_number IN NUMBER
205 );
206
207
208
209
210 -- ==============================================================================
211 -- Start of Comments
212 -- ==============================================================================
213 -- API Name
214 -- Lock_Partner_Pgm_Type
215 -- Type
216 -- Private
217 -- Pre-Req
218 --
219 -- Parameters
220 --
221 -- IN
222 -- p_api_version_number IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226 -- p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type Required
227 --
228 -- OUT
229 -- x_return_status OUT VARCHAR2
230 -- x_msg_count OUT NUMBER
231 -- x_msg_data OUT VARCHAR2
232 -- Version : Current version 1.0
233 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
234 -- and basic operation, developer must manually add parameters and business logic as necessary.
235 --
236 -- End of Comments
237 -- ==============================================================================
238 --
239 PROCEDURE Lock_Partner_Pgm_Type(
240 p_api_version_number IN NUMBER
241 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
242
243 ,x_return_status OUT NOCOPY VARCHAR2
244 ,x_msg_count OUT NOCOPY NUMBER
245 ,x_msg_data OUT NOCOPY VARCHAR2
246
247 ,px_PROGRAM_TYPE_ID IN NUMBER
248 ,p_object_version IN NUMBER
249 );
250
251
252
253
254 -- ==============================================================================
255 -- Start of Comments
256 -- ==============================================================================
257 -- API Name
258 -- Validate_partner_pgm_type
259 --
260 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
261 -- For create: G_CREATE, for update: G_UPDATE
262 -- Note: 1. This is automated generated item level validation PROCEDURE.
263 -- The actual validation detail is needed to be added.
264 -- 2. We can also validate table instead of record. There will be an option for user to choose.
265 -- ==============================================================================
266 -- End of Comments
267 -- ==============================================================================
268 PROCEDURE Validate_partner_pgm_type(
269 p_api_version_number IN NUMBER
270 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272 ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
273 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
274 ,x_return_status OUT NOCOPY VARCHAR2
275 ,x_msg_count OUT NOCOPY NUMBER
276 ,x_msg_data OUT NOCOPY VARCHAR2
277 );
278
279
280
281 -- ==============================================================================
282 -- Start of Comments
283 -- ==============================================================================
284 -- API Name
285 -- Check_Items
286 --
287 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation PROCEDURE.
290 -- The actual validation detail is needed to be added.
291 -- 2. Validate the unique keys, lookups here
292 -- ==============================================================================
293 -- End of Comments
294 -- ==============================================================================
295 PROCEDURE Check_Items (
296 p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
297 ,p_validation_mode IN VARCHAR2
298 ,x_return_status OUT NOCOPY VARCHAR2
299 );
300
301
302
303
304 -- ==============================================================================
305 -- Start of Comments
306 -- ==============================================================================
307 -- API Name
308 -- Validate_Rec
309 -- Record level validation procedures
310 --
311 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
312 -- For create: G_CREATE, for update: G_UPDATE
313 -- Note: 1. This is automated generated item level validation PROCEDURE.
314 -- The actual validation detail is needed to be added.
315 -- 2. Developer can manually added inter-field level validation.
319 PROCEDURE Validate_Rec(
316 -- ==============================================================================
317 -- End of Comments
318 -- ==============================================================================
320 p_api_version_number IN NUMBER
321 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
322 ,x_return_status OUT NOCOPY VARCHAR2
323 ,x_msg_count OUT NOCOPY NUMBER
324 ,x_msg_data OUT NOCOPY VARCHAR2
325 ,p_ptr_prgm_type_rec IN ptr_prgm_type_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_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
348 ,x_complete_rec OUT NOCOPY ptr_prgm_type_rec_type
349 );
350
351
352 END PV_Partner_Pgm_Type_PVT;