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