eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
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;