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