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.ASF_USER_PREFERENCE_PUB_W

Source


1 package body asf_user_preference_pub_w as
2   /* $Header: asfupfwb.pls 115.3 2003/01/28 22:14:23 avijayak ship $ */
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   -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7   function rosetta_g_miss_date_in_map(d date) return date as
8   begin
9     if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10     return d;
11   end;
12 
13   function rosetta_g_miss_num_map(n number) return number as
14     a number := fnd_api.g_miss_num;
15     b number := 0-1962.0724;
16   begin
17     if n=a then return b; end if;
18     if n=b then return a; end if;
19     return n;
20   end;
21 
22   procedure create_preference(x_return_status out nocopy  VARCHAR2
23     , x_msg_count out nocopy  NUMBER
24     , x_msg_data out nocopy  VARCHAR2
25     , p0_a0  NUMBER := 0-1962.0724
26     , p0_a1  NUMBER := 0-1962.0724
27     , p0_a2  NUMBER := 0-1962.0724
28     , p0_a3  DATE := fnd_api.g_miss_date
29     , p0_a4  NUMBER := 0-1962.0724
30     , p0_a5  DATE := fnd_api.g_miss_date
31     , p0_a6  NUMBER := 0-1962.0724
32     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
33     , p0_a8  NUMBER := 0-1962.0724
34     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
35     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
36     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
37     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
38     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
39     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
40     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
41     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
42     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
43     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
44     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
45     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
46     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
47     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
48     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
49     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
50     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
51     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
52     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
53   )
54 
55   as
56     ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;
57     ddindx binary_integer; indx binary_integer;
58   begin
59 
60     -- copy data to the local IN or IN-OUT args, if any
61     ddp_user_preference_rec.preference_id := rosetta_g_miss_num_map(p0_a0);
62     ddp_user_preference_rec.user_id := rosetta_g_miss_num_map(p0_a1);
63     ddp_user_preference_rec.created_by := rosetta_g_miss_num_map(p0_a2);
64     ddp_user_preference_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
65     ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
66     ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
67     ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
68     ddp_user_preference_rec.owner_table_name := p0_a7;
69     ddp_user_preference_rec.owner_table_id := rosetta_g_miss_num_map(p0_a8);
70     ddp_user_preference_rec.category := p0_a9;
71     ddp_user_preference_rec.preference_code := p0_a10;
72     ddp_user_preference_rec.preference_value := p0_a11;
73     ddp_user_preference_rec.attribute_category := p0_a12;
74     ddp_user_preference_rec.attribute1 := p0_a13;
75     ddp_user_preference_rec.attribute2 := p0_a14;
76     ddp_user_preference_rec.attribute3 := p0_a15;
77     ddp_user_preference_rec.attribute4 := p0_a16;
78     ddp_user_preference_rec.attribute5 := p0_a17;
79     ddp_user_preference_rec.attribute6 := p0_a18;
80     ddp_user_preference_rec.attribute7 := p0_a19;
81     ddp_user_preference_rec.attribute8 := p0_a20;
82     ddp_user_preference_rec.attribute9 := p0_a21;
83     ddp_user_preference_rec.attribute10 := p0_a22;
84     ddp_user_preference_rec.attribute11 := p0_a23;
85     ddp_user_preference_rec.attribute12 := p0_a24;
86     ddp_user_preference_rec.attribute13 := p0_a25;
87     ddp_user_preference_rec.attribute14 := p0_a26;
88     ddp_user_preference_rec.attribute15 := p0_a27;
89 
90 
91 
92 
93     -- here's the delegated call to the old PL/SQL routine
94     asf_user_preference_pub.create_preference(ddp_user_preference_rec,
95       x_return_status,
96       x_msg_count,
97       x_msg_data);
98 
99     -- copy data back from the local variables to OUT or IN-OUT args, if any
100 
101 
102 
103   end;
104 
105   procedure update_preference(x_return_status out nocopy  VARCHAR2
106     , x_msg_count out nocopy  NUMBER
107     , x_msg_data out nocopy  VARCHAR2
108     , p0_a0  NUMBER := 0-1962.0724
109     , p0_a1  NUMBER := 0-1962.0724
110     , p0_a2  NUMBER := 0-1962.0724
111     , p0_a3  DATE := fnd_api.g_miss_date
112     , p0_a4  NUMBER := 0-1962.0724
113     , p0_a5  DATE := fnd_api.g_miss_date
114     , p0_a6  NUMBER := 0-1962.0724
115     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
116     , p0_a8  NUMBER := 0-1962.0724
117     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
118     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
119     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
120     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
121     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
122     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
123     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
124     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
125     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
126     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
127     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
128     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
129     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
130     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
131     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
132     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
133     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
134     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
136   )
137 
138   as
139     ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;
140     ddindx binary_integer; indx binary_integer;
141   begin
142 
143     -- copy data to the local IN or IN-OUT args, if any
144     ddp_user_preference_rec.preference_id := rosetta_g_miss_num_map(p0_a0);
145     ddp_user_preference_rec.user_id := rosetta_g_miss_num_map(p0_a1);
146     ddp_user_preference_rec.created_by := rosetta_g_miss_num_map(p0_a2);
147     ddp_user_preference_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
148     ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
149     ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
150     ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
151     ddp_user_preference_rec.owner_table_name := p0_a7;
152     ddp_user_preference_rec.owner_table_id := rosetta_g_miss_num_map(p0_a8);
153     ddp_user_preference_rec.category := p0_a9;
154     ddp_user_preference_rec.preference_code := p0_a10;
155     ddp_user_preference_rec.preference_value := p0_a11;
156     ddp_user_preference_rec.attribute_category := p0_a12;
157     ddp_user_preference_rec.attribute1 := p0_a13;
158     ddp_user_preference_rec.attribute2 := p0_a14;
159     ddp_user_preference_rec.attribute3 := p0_a15;
160     ddp_user_preference_rec.attribute4 := p0_a16;
161     ddp_user_preference_rec.attribute5 := p0_a17;
162     ddp_user_preference_rec.attribute6 := p0_a18;
163     ddp_user_preference_rec.attribute7 := p0_a19;
164     ddp_user_preference_rec.attribute8 := p0_a20;
165     ddp_user_preference_rec.attribute9 := p0_a21;
166     ddp_user_preference_rec.attribute10 := p0_a22;
167     ddp_user_preference_rec.attribute11 := p0_a23;
168     ddp_user_preference_rec.attribute12 := p0_a24;
169     ddp_user_preference_rec.attribute13 := p0_a25;
170     ddp_user_preference_rec.attribute14 := p0_a26;
171     ddp_user_preference_rec.attribute15 := p0_a27;
172 
173 
174 
175 
176     -- here's the delegated call to the old PL/SQL routine
177     asf_user_preference_pub.update_preference(ddp_user_preference_rec,
178       x_return_status,
179       x_msg_count,
180       x_msg_data);
181 
182     -- copy data back from the local variables to OUT or IN-OUT args, if any
183 
184 
185 
186   end;
187 
188   procedure delete_preference(x_return_status out nocopy  VARCHAR2
189     , x_msg_count out nocopy  NUMBER
190     , x_msg_data out nocopy  VARCHAR2
191     , p0_a0  NUMBER := 0-1962.0724
192     , p0_a1  NUMBER := 0-1962.0724
193     , p0_a2  NUMBER := 0-1962.0724
194     , p0_a3  DATE := fnd_api.g_miss_date
195     , p0_a4  NUMBER := 0-1962.0724
196     , p0_a5  DATE := fnd_api.g_miss_date
197     , p0_a6  NUMBER := 0-1962.0724
198     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
199     , p0_a8  NUMBER := 0-1962.0724
200     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
201     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
202     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
204     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
209     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
210     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
212     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
213     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
214     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
215     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
216     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
217     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
218     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
219   )
220 
221   as
222     ddp_user_preference_rec asf_user_preference_pub.user_preference_rec_type;
223     ddindx binary_integer; indx binary_integer;
224   begin
225 
226     -- copy data to the local IN or IN-OUT args, if any
227     ddp_user_preference_rec.preference_id := rosetta_g_miss_num_map(p0_a0);
228     ddp_user_preference_rec.user_id := rosetta_g_miss_num_map(p0_a1);
229     ddp_user_preference_rec.created_by := rosetta_g_miss_num_map(p0_a2);
230     ddp_user_preference_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
231     ddp_user_preference_rec.last_updated_by := rosetta_g_miss_num_map(p0_a4);
232     ddp_user_preference_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a5);
233     ddp_user_preference_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
234     ddp_user_preference_rec.owner_table_name := p0_a7;
235     ddp_user_preference_rec.owner_table_id := rosetta_g_miss_num_map(p0_a8);
236     ddp_user_preference_rec.category := p0_a9;
237     ddp_user_preference_rec.preference_code := p0_a10;
238     ddp_user_preference_rec.preference_value := p0_a11;
239     ddp_user_preference_rec.attribute_category := p0_a12;
240     ddp_user_preference_rec.attribute1 := p0_a13;
241     ddp_user_preference_rec.attribute2 := p0_a14;
242     ddp_user_preference_rec.attribute3 := p0_a15;
243     ddp_user_preference_rec.attribute4 := p0_a16;
244     ddp_user_preference_rec.attribute5 := p0_a17;
245     ddp_user_preference_rec.attribute6 := p0_a18;
246     ddp_user_preference_rec.attribute7 := p0_a19;
247     ddp_user_preference_rec.attribute8 := p0_a20;
248     ddp_user_preference_rec.attribute9 := p0_a21;
249     ddp_user_preference_rec.attribute10 := p0_a22;
250     ddp_user_preference_rec.attribute11 := p0_a23;
251     ddp_user_preference_rec.attribute12 := p0_a24;
252     ddp_user_preference_rec.attribute13 := p0_a25;
253     ddp_user_preference_rec.attribute14 := p0_a26;
254     ddp_user_preference_rec.attribute15 := p0_a27;
255 
256 
257 
258 
259     -- here's the delegated call to the old PL/SQL routine
260     asf_user_preference_pub.delete_preference(ddp_user_preference_rec,
261       x_return_status,
262       x_msg_count,
263       x_msg_data);
264 
265     -- copy data back from the local variables to OUT or IN-OUT args, if any
266 
267 
268 
269   end;
270 
271 end asf_user_preference_pub_w;