1 PACKAGE PV_Ge_Chklst_Resp_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvgcrs.pls 115.3 2002/12/10 10:22:44 anubhavk ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Ge_Chklst_Resp_PVT
7 -- Purpose
8 --
9 -- History
10 -- 15 Nov 2002 anubhavk created
11 -- 19 Nov 2002 anubhavk Updated - For NOCOPY by running nocopy.sh
12 --
13 -- NOTE
14 --
15 -- This Api is generated with Latest version of
16 -- Rosetta, where g_miss indicates NULL and
17 -- NULL indicates missing value. Rosetta Version 1.55
18 -- End of Comments
19 -- ===============================================================
20
21 -- Default number of records fetch per call
22 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23 --===================================================================
24 -- Start of Comments
25 -- -------------------------------------------------------
26 -- Record name
27 -- ge_chklst_resp_rec_type
28 -- -------------------------------------------------------
29 -- Parameters:
30 -- chklst_response_id
31 -- checklist_item_id
32 -- object_version_number
33 -- arc_response_for_entity_code
34 -- response_flag
35 -- response_for_entity_id
36 -- created_by
37 -- creation_date
38 -- last_updated_by
39 -- last_update_date
40 -- last_update_login
41 --
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 --===================================================================
52 TYPE ge_chklst_resp_rec_type IS RECORD
53 (
54 chklst_response_id NUMBER,
55 checklist_item_id NUMBER,
56 object_version_number NUMBER,
57 arc_response_for_entity_code VARCHAR2(30),
58 response_flag VARCHAR2(1),
59 response_for_entity_id NUMBER,
60 created_by NUMBER,
61 creation_date DATE,
62 last_updated_by NUMBER,
63 last_update_date DATE,
64 last_update_login NUMBER
65 );
66
67 g_miss_ge_chklst_resp_rec ge_chklst_resp_rec_type := NULL;
68 TYPE ge_chklst_resp_tbl_type IS TABLE OF ge_chklst_resp_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_ge_chklst_resp_tbl ge_chklst_resp_tbl_type;
70
71 -- ==============================================================================
72 -- Start of Comments
73 -- ==============================================================================
74 -- API Name
75 -- Create_Ge_Chklst_Resp
76 -- Type
77 -- Private
78 -- Pre-Req
79 --
80 -- Parameters
81 --
82 -- IN
83 -- p_api_version_number IN NUMBER Required
84 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87 -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
88 --
89 -- OUT
90 -- x_return_status OUT VARCHAR2
91 -- x_msg_count OUT NUMBER
92 -- x_msg_data OUT VARCHAR2
93 -- Version : Current version 1.0
94 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
95 -- and basic operation, developer must manually add parameters and business logic as necessary.
96 --
97 -- History
98 --
99 -- NOTE
100 --
101 -- End of Comments
102 -- ==============================================================================
103
104 PROCEDURE Create_Ge_Chklst_Resp(
105 p_api_version_number IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113
114 p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type := g_miss_ge_chklst_resp_rec,
115 x_chklst_response_id OUT NOCOPY NUMBER
116 );
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Ge_Chklst_Resp
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_ge_chklst_resp_rec IN ge_chklst_resp_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 -- History
145 --
146 -- NOTE
147 --
148 -- End of Comments
149 -- ==============================================================================
150
151 PROCEDURE Update_Ge_Chklst_Resp(
152 p_api_version_number IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type
162 );
163
164 -- ==============================================================================
165 -- Start of Comments
166 -- ==============================================================================
167 -- API Name
168 -- Delete_Ge_Chklst_Resp
169 -- Type
170 -- Private
171 -- Pre-Req
172 --
173 -- Parameters
174 --
175 -- IN
176 -- p_api_version_number IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180 -- p_chklst_response_id IN NUMBER
181 -- p_object_version_number IN NUMBER Optional Default = NULL
182 --
183 -- OUT
184 -- x_return_status OUT VARCHAR2
185 -- x_msg_count OUT NUMBER
186 -- x_msg_data OUT VARCHAR2
187 -- Version : Current version 1.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- History
192 --
193 -- NOTE
194 --
195 -- End of Comments
196 -- ==============================================================================
197
198 PROCEDURE Delete_Ge_Chklst_Resp(
199 p_api_version_number IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_chklst_response_id IN NUMBER,
207 p_object_version_number IN NUMBER
208 );
209
210 -- ==============================================================================
211 -- Start of Comments
212 -- ==============================================================================
213 -- API Name
214 -- Lock_Ge_Chklst_Resp
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_ge_chklst_resp_rec IN ge_chklst_resp_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 -- History
237 --
238 -- NOTE
239 --
240 -- End of Comments
241 -- ==============================================================================
242
243 PROCEDURE Lock_Ge_Chklst_Resp(
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 p_chklst_response_id IN NUMBER,
252 p_object_version IN NUMBER
253 );
254
255
256 -- ==============================================================================
257 -- Start of Comments
258 -- ==============================================================================
259 -- API Name
260 -- Validate_Ge_Chklst_Resp
261 --
262 -- Version : Current version 1.0
263 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
264 -- For create: G_CREATE, for update: G_UPDATE
265 -- Note: 1. This is automated generated item level validation procedure.
266 -- The actual validation detail is needed to be added.
267 -- 2. We can also validate table instead of record. There will be an option for user to choose.
268 --
269 -- History
270 --
271 -- NOTE
272 --
273 -- End of Comments
274 -- ==============================================================================
275
276
277 PROCEDURE Validate_Ge_Chklst_Resp(
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281 p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
282 p_validation_mode IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 -- ==============================================================================
289 -- Start of Comments
290 -- ==============================================================================
294 -- Version : Current version 1.0
291 -- API Name
292 -- Ge_Chklst_Resp_Items
293 --
295 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
296 -- For create: G_CREATE, for update: G_UPDATE
297 -- Note: 1. This is automated generated item level validation procedure.
298 -- The actual validation detail is needed to be added.
299 -- 2. Validate the unique keys, lookups here
300 --
301 -- History
302 --
303 -- NOTE
304 --
305 -- End of Comments
306 -- ==============================================================================
307
308
309 PROCEDURE Check_Ge_Chklst_Resp_Items (
310 P_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
311 p_validation_mode IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2
313 );
314
315 -- ==============================================================================
316 -- Start of Comments
317 -- ==============================================================================
318 -- API Name
319 -- Validate_Ge_Chklst_Resp_Rec
320 --
321 -- Version : Current version 1.0
322 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. Developer can manually added inter-field level validation.
327 --
328 -- History
329 --
330 -- NOTE
331 --
332 -- End of Comments
333 -- ==============================================================================
334
335
336 PROCEDURE Validate_Ge_Chklst_Resp_Rec (
337 p_api_version_number IN NUMBER,
338 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type
343 );
344
345
346 PROCEDURE Create_Enrq_Responses (
347 p_api_version_number IN NUMBER,
348 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349 p_commit IN VARCHAR2 := FND_API.G_FALSE,
350 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 p_programId IN NUMBER,
356 p_enrollmentId IN NUMBER
357 );
358
359 END PV_Ge_Chklst_Resp_PVT;