1 PACKAGE PV_Pg_Enrq_Init_Sources_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvpeis.pls 115.2 2002/12/10 20:36:52 jkylee ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Pg_Enrq_Init_Sources_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- enrq_init_sources_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- initiation_source_id
29 -- object_version_number
30 -- enrl_request_id
31 -- prev_membership_id
32 -- enrl_change_rule_id
33 -- created_by
34 -- creation_date
35 -- last_updated_by
36 -- last_update_date
37 -- last_update_login
38 --
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 enrq_init_sources_rec_type IS RECORD
50 (
51 initiation_source_id NUMBER,
52 object_version_number NUMBER,
53 enrl_request_id NUMBER,
54 prev_membership_id NUMBER,
55 enrl_change_rule_id NUMBER,
56 created_by NUMBER,
57 creation_date DATE,
58 last_updated_by NUMBER,
59 last_update_date DATE,
60 last_update_login NUMBER
61 );
62
63 g_miss_enrq_init_sources_rec enrq_init_sources_rec_type := NULL;
64 TYPE enrq_init_sources_tbl_type IS TABLE OF enrq_init_sources_rec_type INDEX BY BINARY_INTEGER;
65 g_miss_enrq_init_sources_tbl enrq_init_sources_tbl_type;
66
67 -- ==============================================================================
68 -- Start of Comments
69 -- ==============================================================================
70 -- API Name
71 -- Create_Pg_Enrq_Init_Sources
72 -- Type
73 -- Private
74 -- Pre-Req
75 --
76 -- Parameters
77 --
78 -- IN
79 -- p_api_version_number IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
81 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
83 -- p_enrq_init_sources_rec IN enrq_init_sources_rec_type Required
84 --
85 -- OUT
86 -- x_return_status OUT VARCHAR2
87 -- x_msg_count OUT NUMBER
88 -- x_msg_data OUT VARCHAR2
89 -- Version : Current version 1.0
90 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
91 -- and basic operation, developer must manually add parameters and business logic as necessary.
92 --
93 -- History
94 --
95 -- NOTE
96 --
97 -- End of Comments
98 -- ==============================================================================
99
100 PROCEDURE Create_Pg_Enrq_Init_Sources(
101 p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109
110 p_enrq_init_sources_rec IN enrq_init_sources_rec_type := g_miss_enrq_init_sources_rec,
111 x_initiation_source_id OUT NOCOPY NUMBER
112 );
113
114 -- ==============================================================================
115 -- Start of Comments
116 -- ==============================================================================
117 -- API Name
118 -- Update_Pg_Enrq_Init_Sources
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_enrq_init_sources_rec IN enrq_init_sources_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 -- History
141 --
142 -- NOTE
143 --
144 -- End of Comments
145 -- ==============================================================================
146
147 PROCEDURE Update_Pg_Enrq_Init_Sources(
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_enrq_init_sources_rec IN enrq_init_sources_rec_type
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Delete_Pg_Enrq_Init_Sources
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_initiation_source_id IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- History
188 --
189 -- NOTE
190 --
191 -- End of Comments
192 -- ==============================================================================
193
194 PROCEDURE Delete_Pg_Enrq_Init_Sources(
195 p_api_version_number IN NUMBER,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197 p_commit IN VARCHAR2 := FND_API.G_FALSE,
198 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_initiation_source_id IN NUMBER,
203 p_object_version_number IN NUMBER
204 );
205
206 -- ==============================================================================
207 -- Start of Comments
208 -- ==============================================================================
209 -- API Name
210 -- Lock_Pg_Enrq_Init_Sources
211 -- Type
212 -- Private
213 -- Pre-Req
214 --
215 -- Parameters
216 --
217 -- IN
218 -- p_api_version_number IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222 -- p_enrq_init_sources_rec IN enrq_init_sources_rec_type Required
223 --
224 -- OUT
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- Version : Current version 1.0
229 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
230 -- and basic operation, developer must manually add parameters and business logic as necessary.
231 --
232 -- History
233 --
234 -- NOTE
235 --
236 -- End of Comments
237 -- ==============================================================================
238
239 PROCEDURE Lock_Pg_Enrq_Init_Sources(
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 p_initiation_source_id IN NUMBER,
248 p_object_version IN NUMBER
249 );
250
251
252 -- ==============================================================================
253 -- Start of Comments
254 -- ==============================================================================
255 -- API Name
256 -- Validate_Pg_Init_Src
257 --
258 -- Version : Current version 1.0
259 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
260 -- For create: G_CREATE, for update: G_UPDATE
261 -- Note: 1. This is automated generated item level validation procedure.
262 -- The actual validation detail is needed to be added.
263 -- 2. We can also validate table instead of record. There will be an option for user to choose.
264 --
265 -- History
266 --
267 -- NOTE
268 --
269 -- End of Comments
270 -- ==============================================================================
271
272
273 PROCEDURE Validate_Pg_Init_Src(
274 p_api_version_number IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277 p_enrq_init_sources_rec IN enrq_init_sources_rec_type,
278 p_validation_mode IN VARCHAR2,
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 -- Start of Comments
286 -- ==============================================================================
287 -- API Name
288 -- Enrq_Init_Sources_Items
289 --
290 -- Version : Current version 1.0
291 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
292 -- For create: G_CREATE, for update: G_UPDATE
293 -- Note: 1. This is automated generated item level validation procedure.
294 -- The actual validation detail is needed to be added.
295 -- 2. Validate the unique keys, lookups here
296 --
297 -- History
298 --
299 -- NOTE
300 --
301 -- End of Comments
302 -- ==============================================================================
303
304
305 PROCEDURE Check_Init_Src_Items (
306 P_enrq_init_sources_rec IN enrq_init_sources_rec_type,
307 p_validation_mode IN VARCHAR2,
308 x_return_status OUT NOCOPY VARCHAR2
309 );
310
311 -- ==============================================================================
312 -- Start of Comments
313 -- ==============================================================================
314 -- API Name
315 -- Validate_Init_Src_Rec
316 --
317 -- Version : Current version 1.0
318 -- p_validation_mode is a constant defined in PV_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 -- History
325 --
326 -- NOTE
327 --
328 -- End of Comments
329 -- ==============================================================================
330
331
332 PROCEDURE Validate_Init_Src_Rec (
333 p_api_version_number IN NUMBER,
334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338 p_enrq_init_sources_rec IN enrq_init_sources_rec_type
339 );
340 END PV_Pg_Enrq_Init_Sources_PVT;