[Home] [Help]
PACKAGE BODY: APPS.PV_ENTYATTMAP_PUB_W
Source
1 package body pv_entyattmap_pub_w as
2 /* $Header: pvrweamb.pls 120.0 2005/05/27 15:33:38 appldev noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_entyattmap(p_api_version_number NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , p_identity_resource_id NUMBER
27 , x_mapping_id out nocopy NUMBER
28 , x_return_status out nocopy VARCHAR2
29 , x_msg_count out nocopy NUMBER
30 , x_msg_data out nocopy VARCHAR2
31 , p5_a0 NUMBER := 0-1962.0724
32 , p5_a1 DATE := fnd_api.g_miss_date
33 , p5_a2 NUMBER := 0-1962.0724
34 , p5_a3 DATE := fnd_api.g_miss_date
35 , p5_a4 NUMBER := 0-1962.0724
36 , p5_a5 NUMBER := 0-1962.0724
37 , p5_a6 NUMBER := 0-1962.0724
38 , p5_a7 NUMBER := 0-1962.0724
39 , p5_a8 NUMBER := 0-1962.0724
40 , p5_a9 NUMBER := 0-1962.0724
41 , p5_a10 DATE := fnd_api.g_miss_date
42 , p5_a11 NUMBER := 0-1962.0724
43 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
44 , p5_a13 NUMBER := 0-1962.0724
45 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
46 , p5_a15 NUMBER := 0-1962.0724
47 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
48 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
49 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
50 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
51 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
52 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
53 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
54 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
55 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
56 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
57 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
58 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
59 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
60 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
61 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
62 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
63 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
64 )
65
66 as
67 ddp_entyattmap_rec pv_rule_rectype_pub.entyattmap_rec_type;
68 ddindx binary_integer; indx binary_integer;
69 begin
70
71 -- copy data to the local IN or IN-OUT args, if any
72
73
74
75
76
77 ddp_entyattmap_rec.mapping_id := rosetta_g_miss_num_map(p5_a0);
78 ddp_entyattmap_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);
79 ddp_entyattmap_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);
80 ddp_entyattmap_rec.creation_date := rosetta_g_miss_date_in_map(p5_a3);
81 ddp_entyattmap_rec.created_by := rosetta_g_miss_num_map(p5_a4);
82 ddp_entyattmap_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);
83 ddp_entyattmap_rec.object_version_number := rosetta_g_miss_num_map(p5_a6);
84 ddp_entyattmap_rec.request_id := rosetta_g_miss_num_map(p5_a7);
85 ddp_entyattmap_rec.program_application_id := rosetta_g_miss_num_map(p5_a8);
86 ddp_entyattmap_rec.program_id := rosetta_g_miss_num_map(p5_a9);
87 ddp_entyattmap_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
88 ddp_entyattmap_rec.process_rule_id := rosetta_g_miss_num_map(p5_a11);
89 ddp_entyattmap_rec.source_attr_type := p5_a12;
90 ddp_entyattmap_rec.source_attr_id := rosetta_g_miss_num_map(p5_a13);
91 ddp_entyattmap_rec.target_attr_type := p5_a14;
92 ddp_entyattmap_rec.target_attr_id := rosetta_g_miss_num_map(p5_a15);
93 ddp_entyattmap_rec.operator := p5_a16;
94 ddp_entyattmap_rec.attribute_category := p5_a17;
95 ddp_entyattmap_rec.attribute1 := p5_a18;
96 ddp_entyattmap_rec.attribute2 := p5_a19;
97 ddp_entyattmap_rec.attribute3 := p5_a20;
98 ddp_entyattmap_rec.attribute4 := p5_a21;
99 ddp_entyattmap_rec.attribute5 := p5_a22;
100 ddp_entyattmap_rec.attribute6 := p5_a23;
101 ddp_entyattmap_rec.attribute7 := p5_a24;
102 ddp_entyattmap_rec.attribute8 := p5_a25;
103 ddp_entyattmap_rec.attribute9 := p5_a26;
104 ddp_entyattmap_rec.attribute10 := p5_a27;
105 ddp_entyattmap_rec.attribute11 := p5_a28;
106 ddp_entyattmap_rec.attribute12 := p5_a29;
107 ddp_entyattmap_rec.attribute13 := p5_a30;
108 ddp_entyattmap_rec.attribute14 := p5_a31;
109 ddp_entyattmap_rec.attribute15 := p5_a32;
110
111
112
113
114
115 -- here's the delegated call to the old PL/SQL routine
116 pv_entyattmap_pub.create_entyattmap(p_api_version_number,
117 p_init_msg_list,
118 p_commit,
119 p_validation_level,
120 p_identity_resource_id,
121 ddp_entyattmap_rec,
122 x_mapping_id,
123 x_return_status,
124 x_msg_count,
125 x_msg_data);
126
127 -- copy data back from the local variables to OUT or IN-OUT args, if any
128
129
130
131
132
133
134
135
136
137 end;
138
139 procedure update_entyattmap(p_api_version_number NUMBER
140 , p_init_msg_list VARCHAR2
141 , p_commit VARCHAR2
142 , p_validation_level NUMBER
143 , p_identity_resource_id NUMBER
144 , x_return_status out nocopy VARCHAR2
145 , x_msg_count out nocopy NUMBER
146 , x_msg_data out nocopy VARCHAR2
147 , p5_a0 NUMBER := 0-1962.0724
148 , p5_a1 DATE := fnd_api.g_miss_date
149 , p5_a2 NUMBER := 0-1962.0724
150 , p5_a3 DATE := fnd_api.g_miss_date
151 , p5_a4 NUMBER := 0-1962.0724
152 , p5_a5 NUMBER := 0-1962.0724
153 , p5_a6 NUMBER := 0-1962.0724
154 , p5_a7 NUMBER := 0-1962.0724
155 , p5_a8 NUMBER := 0-1962.0724
156 , p5_a9 NUMBER := 0-1962.0724
157 , p5_a10 DATE := fnd_api.g_miss_date
158 , p5_a11 NUMBER := 0-1962.0724
159 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a13 NUMBER := 0-1962.0724
161 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a15 NUMBER := 0-1962.0724
163 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
168 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
169 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
170 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
171 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
172 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
173 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
174 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
175 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
176 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
177 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
178 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
180 )
181
182 as
183 ddp_entyattmap_rec pv_rule_rectype_pub.entyattmap_rec_type;
184 ddindx binary_integer; indx binary_integer;
185 begin
186
187 -- copy data to the local IN or IN-OUT args, if any
188
189
190
191
192
193 ddp_entyattmap_rec.mapping_id := rosetta_g_miss_num_map(p5_a0);
194 ddp_entyattmap_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);
195 ddp_entyattmap_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);
196 ddp_entyattmap_rec.creation_date := rosetta_g_miss_date_in_map(p5_a3);
197 ddp_entyattmap_rec.created_by := rosetta_g_miss_num_map(p5_a4);
198 ddp_entyattmap_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);
199 ddp_entyattmap_rec.object_version_number := rosetta_g_miss_num_map(p5_a6);
200 ddp_entyattmap_rec.request_id := rosetta_g_miss_num_map(p5_a7);
201 ddp_entyattmap_rec.program_application_id := rosetta_g_miss_num_map(p5_a8);
202 ddp_entyattmap_rec.program_id := rosetta_g_miss_num_map(p5_a9);
203 ddp_entyattmap_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
204 ddp_entyattmap_rec.process_rule_id := rosetta_g_miss_num_map(p5_a11);
205 ddp_entyattmap_rec.source_attr_type := p5_a12;
206 ddp_entyattmap_rec.source_attr_id := rosetta_g_miss_num_map(p5_a13);
207 ddp_entyattmap_rec.target_attr_type := p5_a14;
208 ddp_entyattmap_rec.target_attr_id := rosetta_g_miss_num_map(p5_a15);
209 ddp_entyattmap_rec.operator := p5_a16;
210 ddp_entyattmap_rec.attribute_category := p5_a17;
211 ddp_entyattmap_rec.attribute1 := p5_a18;
212 ddp_entyattmap_rec.attribute2 := p5_a19;
213 ddp_entyattmap_rec.attribute3 := p5_a20;
214 ddp_entyattmap_rec.attribute4 := p5_a21;
215 ddp_entyattmap_rec.attribute5 := p5_a22;
216 ddp_entyattmap_rec.attribute6 := p5_a23;
217 ddp_entyattmap_rec.attribute7 := p5_a24;
218 ddp_entyattmap_rec.attribute8 := p5_a25;
219 ddp_entyattmap_rec.attribute9 := p5_a26;
220 ddp_entyattmap_rec.attribute10 := p5_a27;
221 ddp_entyattmap_rec.attribute11 := p5_a28;
222 ddp_entyattmap_rec.attribute12 := p5_a29;
223 ddp_entyattmap_rec.attribute13 := p5_a30;
224 ddp_entyattmap_rec.attribute14 := p5_a31;
225 ddp_entyattmap_rec.attribute15 := p5_a32;
226
227
228
229
230 -- here's the delegated call to the old PL/SQL routine
231 pv_entyattmap_pub.update_entyattmap(p_api_version_number,
232 p_init_msg_list,
233 p_commit,
234 p_validation_level,
235 p_identity_resource_id,
236 ddp_entyattmap_rec,
237 x_return_status,
238 x_msg_count,
239 x_msg_data);
240
241 -- copy data back from the local variables to OUT or IN-OUT args, if any
242
243
244
245
246
247
248
249
250 end;
251
252 procedure delete_entyattmap(p_api_version_number NUMBER
253 , p_init_msg_list VARCHAR2
254 , p_commit VARCHAR2
255 , p_validation_level NUMBER
256 , p_identity_resource_id NUMBER
257 , x_return_status out nocopy VARCHAR2
258 , x_msg_count out nocopy NUMBER
259 , x_msg_data out nocopy VARCHAR2
260 , p5_a0 NUMBER := 0-1962.0724
261 , p5_a1 DATE := fnd_api.g_miss_date
262 , p5_a2 NUMBER := 0-1962.0724
263 , p5_a3 DATE := fnd_api.g_miss_date
264 , p5_a4 NUMBER := 0-1962.0724
265 , p5_a5 NUMBER := 0-1962.0724
266 , p5_a6 NUMBER := 0-1962.0724
267 , p5_a7 NUMBER := 0-1962.0724
268 , p5_a8 NUMBER := 0-1962.0724
269 , p5_a9 NUMBER := 0-1962.0724
270 , p5_a10 DATE := fnd_api.g_miss_date
271 , p5_a11 NUMBER := 0-1962.0724
272 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a13 NUMBER := 0-1962.0724
274 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a15 NUMBER := 0-1962.0724
276 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
277 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
281 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
282 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
283 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
284 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
285 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
286 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
288 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
289 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
290 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
291 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
292 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
293 )
294
295 as
296 ddp_entyattmap_rec pv_rule_rectype_pub.entyattmap_rec_type;
297 ddindx binary_integer; indx binary_integer;
298 begin
299
300 -- copy data to the local IN or IN-OUT args, if any
301
302
303
304
305
306 ddp_entyattmap_rec.mapping_id := rosetta_g_miss_num_map(p5_a0);
307 ddp_entyattmap_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);
308 ddp_entyattmap_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);
309 ddp_entyattmap_rec.creation_date := rosetta_g_miss_date_in_map(p5_a3);
310 ddp_entyattmap_rec.created_by := rosetta_g_miss_num_map(p5_a4);
311 ddp_entyattmap_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);
312 ddp_entyattmap_rec.object_version_number := rosetta_g_miss_num_map(p5_a6);
313 ddp_entyattmap_rec.request_id := rosetta_g_miss_num_map(p5_a7);
314 ddp_entyattmap_rec.program_application_id := rosetta_g_miss_num_map(p5_a8);
315 ddp_entyattmap_rec.program_id := rosetta_g_miss_num_map(p5_a9);
316 ddp_entyattmap_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a10);
317 ddp_entyattmap_rec.process_rule_id := rosetta_g_miss_num_map(p5_a11);
318 ddp_entyattmap_rec.source_attr_type := p5_a12;
319 ddp_entyattmap_rec.source_attr_id := rosetta_g_miss_num_map(p5_a13);
320 ddp_entyattmap_rec.target_attr_type := p5_a14;
321 ddp_entyattmap_rec.target_attr_id := rosetta_g_miss_num_map(p5_a15);
322 ddp_entyattmap_rec.operator := p5_a16;
323 ddp_entyattmap_rec.attribute_category := p5_a17;
324 ddp_entyattmap_rec.attribute1 := p5_a18;
325 ddp_entyattmap_rec.attribute2 := p5_a19;
326 ddp_entyattmap_rec.attribute3 := p5_a20;
327 ddp_entyattmap_rec.attribute4 := p5_a21;
328 ddp_entyattmap_rec.attribute5 := p5_a22;
329 ddp_entyattmap_rec.attribute6 := p5_a23;
330 ddp_entyattmap_rec.attribute7 := p5_a24;
331 ddp_entyattmap_rec.attribute8 := p5_a25;
332 ddp_entyattmap_rec.attribute9 := p5_a26;
333 ddp_entyattmap_rec.attribute10 := p5_a27;
334 ddp_entyattmap_rec.attribute11 := p5_a28;
335 ddp_entyattmap_rec.attribute12 := p5_a29;
336 ddp_entyattmap_rec.attribute13 := p5_a30;
337 ddp_entyattmap_rec.attribute14 := p5_a31;
338 ddp_entyattmap_rec.attribute15 := p5_a32;
339
340
341
342
343 -- here's the delegated call to the old PL/SQL routine
344 pv_entyattmap_pub.delete_entyattmap(p_api_version_number,
345 p_init_msg_list,
346 p_commit,
347 p_validation_level,
348 p_identity_resource_id,
349 ddp_entyattmap_rec,
350 x_return_status,
351 x_msg_count,
352 x_msg_data);
353
354 -- copy data back from the local variables to OUT or IN-OUT args, if any
355
356
357
358
359
360
361
362
363 end;
364
365 end pv_entyattmap_pub_w;