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: APPS.AMS_DM_SCORE_PVT_W

Source


1 package ams_dm_score_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswdmss.pls 120.1 2005/06/15 23:58:35 appldev  $ */
3   procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_DATE_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_DATE_TABLE
21     , a18 JTF_DATE_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_NUMBER_TABLE
24     , a21 JTF_NUMBER_TABLE
25     , a22 JTF_NUMBER_TABLE
26     , a23 JTF_VARCHAR2_TABLE_100
27     , a24 JTF_NUMBER_TABLE
28     , a25 JTF_NUMBER_TABLE
29     , a26 JTF_NUMBER_TABLE
30     , a27 JTF_NUMBER_TABLE
31     , a28 JTF_VARCHAR2_TABLE_300
32     , a29 JTF_VARCHAR2_TABLE_200
33     , a30 JTF_VARCHAR2_TABLE_1000
34     , a31 JTF_VARCHAR2_TABLE_100
35     , a32 JTF_VARCHAR2_TABLE_200
36     , a33 JTF_VARCHAR2_TABLE_200
37     , a34 JTF_VARCHAR2_TABLE_200
38     , a35 JTF_VARCHAR2_TABLE_200
39     , a36 JTF_VARCHAR2_TABLE_200
40     , a37 JTF_VARCHAR2_TABLE_200
41     , a38 JTF_VARCHAR2_TABLE_200
42     , a39 JTF_VARCHAR2_TABLE_200
43     , a40 JTF_VARCHAR2_TABLE_200
44     , a41 JTF_VARCHAR2_TABLE_200
45     , a42 JTF_VARCHAR2_TABLE_200
46     , a43 JTF_VARCHAR2_TABLE_200
47     , a44 JTF_VARCHAR2_TABLE_200
48     , a45 JTF_VARCHAR2_TABLE_200
49     , a46 JTF_VARCHAR2_TABLE_200
50     );
51   procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
52     , a1 OUT NOCOPY JTF_DATE_TABLE
53     , a2 OUT NOCOPY JTF_NUMBER_TABLE
54     , a3 OUT NOCOPY JTF_DATE_TABLE
55     , a4 OUT NOCOPY JTF_NUMBER_TABLE
56     , a5 OUT NOCOPY JTF_NUMBER_TABLE
57     , a6 OUT NOCOPY JTF_NUMBER_TABLE
58     , a7 OUT NOCOPY JTF_NUMBER_TABLE
59     , a8 OUT NOCOPY JTF_NUMBER_TABLE
60     , a9 OUT NOCOPY JTF_NUMBER_TABLE
61     , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
62     , a11 OUT NOCOPY JTF_DATE_TABLE
63     , a12 OUT NOCOPY JTF_NUMBER_TABLE
64     , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
65     , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
66     , a15 OUT NOCOPY JTF_DATE_TABLE
67     , a16 OUT NOCOPY JTF_NUMBER_TABLE
68     , a17 OUT NOCOPY JTF_DATE_TABLE
69     , a18 OUT NOCOPY JTF_DATE_TABLE
70     , a19 OUT NOCOPY JTF_NUMBER_TABLE
71     , a20 OUT NOCOPY JTF_NUMBER_TABLE
72     , a21 OUT NOCOPY JTF_NUMBER_TABLE
73     , a22 OUT NOCOPY JTF_NUMBER_TABLE
74     , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_100
75     , a24 OUT NOCOPY JTF_NUMBER_TABLE
76     , a25 OUT NOCOPY JTF_NUMBER_TABLE
77     , a26 OUT NOCOPY JTF_NUMBER_TABLE
78     , a27 OUT NOCOPY JTF_NUMBER_TABLE
79     , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_300
80     , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
81     , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
82     , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_100
83     , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_200
84     , a33 OUT NOCOPY JTF_VARCHAR2_TABLE_200
85     , a34 OUT NOCOPY JTF_VARCHAR2_TABLE_200
86     , a35 OUT NOCOPY JTF_VARCHAR2_TABLE_200
87     , a36 OUT NOCOPY JTF_VARCHAR2_TABLE_200
88     , a37 OUT NOCOPY JTF_VARCHAR2_TABLE_200
89     , a38 OUT NOCOPY JTF_VARCHAR2_TABLE_200
90     , a39 OUT NOCOPY JTF_VARCHAR2_TABLE_200
91     , a40 OUT NOCOPY JTF_VARCHAR2_TABLE_200
92     , a41 OUT NOCOPY JTF_VARCHAR2_TABLE_200
93     , a42 OUT NOCOPY JTF_VARCHAR2_TABLE_200
94     , a43 OUT NOCOPY JTF_VARCHAR2_TABLE_200
95     , a44 OUT NOCOPY JTF_VARCHAR2_TABLE_200
96     , a45 OUT NOCOPY JTF_VARCHAR2_TABLE_200
97     , a46 OUT NOCOPY JTF_VARCHAR2_TABLE_200
98     );
99 
100   procedure check_score_items(p_validation_mode  VARCHAR2
101     , x_return_status OUT NOCOPY  VARCHAR2
102     , p0_a0  NUMBER := 0-1962.0724
103     , p0_a1  DATE := fnd_api.g_miss_date
104     , p0_a2  NUMBER := 0-1962.0724
105     , p0_a3  DATE := fnd_api.g_miss_date
106     , p0_a4  NUMBER := 0-1962.0724
107     , p0_a5  NUMBER := 0-1962.0724
108     , p0_a6  NUMBER := 0-1962.0724
109     , p0_a7  NUMBER := 0-1962.0724
110     , p0_a8  NUMBER := 0-1962.0724
111     , p0_a9  NUMBER := 0-1962.0724
112     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
113     , p0_a11  DATE := fnd_api.g_miss_date
114     , p0_a12  NUMBER := 0-1962.0724
115     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
116     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
117     , p0_a15  DATE := fnd_api.g_miss_date
118     , p0_a16  NUMBER := 0-1962.0724
119     , p0_a17  DATE := fnd_api.g_miss_date
120     , p0_a18  DATE := fnd_api.g_miss_date
121     , p0_a19  NUMBER := 0-1962.0724
122     , p0_a20  NUMBER := 0-1962.0724
123     , p0_a21  NUMBER := 0-1962.0724
124     , p0_a22  NUMBER := 0-1962.0724
125     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
126     , p0_a24  NUMBER := 0-1962.0724
127     , p0_a25  NUMBER := 0-1962.0724
128     , p0_a26  NUMBER := 0-1962.0724
129     , p0_a27  NUMBER := 0-1962.0724
130     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
131     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
132     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
133     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
134     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a33  VARCHAR2 := fnd_api.g_miss_char
136     , p0_a34  VARCHAR2 := fnd_api.g_miss_char
137     , p0_a35  VARCHAR2 := fnd_api.g_miss_char
138     , p0_a36  VARCHAR2 := fnd_api.g_miss_char
139     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
140     , p0_a38  VARCHAR2 := fnd_api.g_miss_char
141     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
142     , p0_a40  VARCHAR2 := fnd_api.g_miss_char
143     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
144     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
145     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
146     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
147     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
148     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
149   );
150   procedure create_score(p_api_version  NUMBER
151     , p_init_msg_list  VARCHAR2
152     , p_commit  VARCHAR2
153     , p_validation_level  NUMBER
154     , x_return_status OUT NOCOPY  VARCHAR2
155     , x_msg_count OUT NOCOPY  NUMBER
156     , x_msg_data OUT NOCOPY  VARCHAR2
157     , x_custom_setup_id OUT NOCOPY  NUMBER
158     , x_score_id OUT NOCOPY  NUMBER
159     , p7_a0  NUMBER := 0-1962.0724
160     , p7_a1  DATE := fnd_api.g_miss_date
161     , p7_a2  NUMBER := 0-1962.0724
162     , p7_a3  DATE := fnd_api.g_miss_date
163     , p7_a4  NUMBER := 0-1962.0724
164     , p7_a5  NUMBER := 0-1962.0724
165     , p7_a6  NUMBER := 0-1962.0724
166     , p7_a7  NUMBER := 0-1962.0724
167     , p7_a8  NUMBER := 0-1962.0724
168     , p7_a9  NUMBER := 0-1962.0724
169     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
170     , p7_a11  DATE := fnd_api.g_miss_date
171     , p7_a12  NUMBER := 0-1962.0724
172     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
173     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
174     , p7_a15  DATE := fnd_api.g_miss_date
175     , p7_a16  NUMBER := 0-1962.0724
176     , p7_a17  DATE := fnd_api.g_miss_date
177     , p7_a18  DATE := fnd_api.g_miss_date
178     , p7_a19  NUMBER := 0-1962.0724
179     , p7_a20  NUMBER := 0-1962.0724
180     , p7_a21  NUMBER := 0-1962.0724
181     , p7_a22  NUMBER := 0-1962.0724
182     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
183     , p7_a24  NUMBER := 0-1962.0724
184     , p7_a25  NUMBER := 0-1962.0724
185     , p7_a26  NUMBER := 0-1962.0724
186     , p7_a27  NUMBER := 0-1962.0724
187     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
188     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
189     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
190     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
191     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
192     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
193     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
194     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
195     , p7_a36  VARCHAR2 := fnd_api.g_miss_char
196     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
197     , p7_a38  VARCHAR2 := fnd_api.g_miss_char
198     , p7_a39  VARCHAR2 := fnd_api.g_miss_char
199     , p7_a40  VARCHAR2 := fnd_api.g_miss_char
200     , p7_a41  VARCHAR2 := fnd_api.g_miss_char
201     , p7_a42  VARCHAR2 := fnd_api.g_miss_char
202     , p7_a43  VARCHAR2 := fnd_api.g_miss_char
203     , p7_a44  VARCHAR2 := fnd_api.g_miss_char
204     , p7_a45  VARCHAR2 := fnd_api.g_miss_char
205     , p7_a46  VARCHAR2 := fnd_api.g_miss_char
206   );
207   procedure update_score(p_api_version  NUMBER
208     , p_init_msg_list  VARCHAR2
209     , p_commit  VARCHAR2
210     , p_validation_level  NUMBER
211     , x_return_status OUT NOCOPY  VARCHAR2
212     , x_msg_count OUT NOCOPY  NUMBER
213     , x_msg_data OUT NOCOPY  VARCHAR2
214     , x_object_version_number OUT NOCOPY  NUMBER
215     , p7_a0  NUMBER := 0-1962.0724
216     , p7_a1  DATE := fnd_api.g_miss_date
217     , p7_a2  NUMBER := 0-1962.0724
218     , p7_a3  DATE := fnd_api.g_miss_date
219     , p7_a4  NUMBER := 0-1962.0724
220     , p7_a5  NUMBER := 0-1962.0724
221     , p7_a6  NUMBER := 0-1962.0724
222     , p7_a7  NUMBER := 0-1962.0724
223     , p7_a8  NUMBER := 0-1962.0724
224     , p7_a9  NUMBER := 0-1962.0724
225     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
226     , p7_a11  DATE := fnd_api.g_miss_date
227     , p7_a12  NUMBER := 0-1962.0724
228     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
229     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
230     , p7_a15  DATE := fnd_api.g_miss_date
231     , p7_a16  NUMBER := 0-1962.0724
232     , p7_a17  DATE := fnd_api.g_miss_date
233     , p7_a18  DATE := fnd_api.g_miss_date
234     , p7_a19  NUMBER := 0-1962.0724
235     , p7_a20  NUMBER := 0-1962.0724
236     , p7_a21  NUMBER := 0-1962.0724
237     , p7_a22  NUMBER := 0-1962.0724
238     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
239     , p7_a24  NUMBER := 0-1962.0724
240     , p7_a25  NUMBER := 0-1962.0724
241     , p7_a26  NUMBER := 0-1962.0724
242     , p7_a27  NUMBER := 0-1962.0724
243     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
244     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
245     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
246     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
247     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
248     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
249     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
250     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
251     , p7_a36  VARCHAR2 := fnd_api.g_miss_char
252     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
253     , p7_a38  VARCHAR2 := fnd_api.g_miss_char
254     , p7_a39  VARCHAR2 := fnd_api.g_miss_char
255     , p7_a40  VARCHAR2 := fnd_api.g_miss_char
256     , p7_a41  VARCHAR2 := fnd_api.g_miss_char
257     , p7_a42  VARCHAR2 := fnd_api.g_miss_char
258     , p7_a43  VARCHAR2 := fnd_api.g_miss_char
259     , p7_a44  VARCHAR2 := fnd_api.g_miss_char
260     , p7_a45  VARCHAR2 := fnd_api.g_miss_char
261     , p7_a46  VARCHAR2 := fnd_api.g_miss_char
262   );
263   procedure validate_score_rec(p_api_version  NUMBER
264     , p_init_msg_list  VARCHAR2
265     , p_validation_mode  VARCHAR2
266     , x_return_status OUT NOCOPY  VARCHAR2
267     , x_msg_count OUT NOCOPY  NUMBER
268     , x_msg_data OUT NOCOPY  VARCHAR2
269     , p6_a0  NUMBER := 0-1962.0724
270     , p6_a1  DATE := fnd_api.g_miss_date
271     , p6_a2  NUMBER := 0-1962.0724
272     , p6_a3  DATE := fnd_api.g_miss_date
273     , p6_a4  NUMBER := 0-1962.0724
274     , p6_a5  NUMBER := 0-1962.0724
275     , p6_a6  NUMBER := 0-1962.0724
276     , p6_a7  NUMBER := 0-1962.0724
277     , p6_a8  NUMBER := 0-1962.0724
278     , p6_a9  NUMBER := 0-1962.0724
279     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
280     , p6_a11  DATE := fnd_api.g_miss_date
281     , p6_a12  NUMBER := 0-1962.0724
282     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
283     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
284     , p6_a15  DATE := fnd_api.g_miss_date
285     , p6_a16  NUMBER := 0-1962.0724
286     , p6_a17  DATE := fnd_api.g_miss_date
287     , p6_a18  DATE := fnd_api.g_miss_date
288     , p6_a19  NUMBER := 0-1962.0724
289     , p6_a20  NUMBER := 0-1962.0724
290     , p6_a21  NUMBER := 0-1962.0724
291     , p6_a22  NUMBER := 0-1962.0724
292     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
293     , p6_a24  NUMBER := 0-1962.0724
294     , p6_a25  NUMBER := 0-1962.0724
295     , p6_a26  NUMBER := 0-1962.0724
296     , p6_a27  NUMBER := 0-1962.0724
297     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
298     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
299     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
300     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
301     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
302     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
303     , p6_a34  VARCHAR2 := fnd_api.g_miss_char
304     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
305     , p6_a36  VARCHAR2 := fnd_api.g_miss_char
306     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
307     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
308     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
309     , p6_a40  VARCHAR2 := fnd_api.g_miss_char
310     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
311     , p6_a42  VARCHAR2 := fnd_api.g_miss_char
312     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
313     , p6_a44  VARCHAR2 := fnd_api.g_miss_char
314     , p6_a45  VARCHAR2 := fnd_api.g_miss_char
315     , p6_a46  VARCHAR2 := fnd_api.g_miss_char
316   );
317   procedure validate_score(p_api_version  NUMBER
318     , p_init_msg_list  VARCHAR2
319     , p_validation_level  NUMBER
320     , p_validation_mode  VARCHAR2
321     , x_return_status OUT NOCOPY  VARCHAR2
322     , x_msg_count OUT NOCOPY  NUMBER
323     , x_msg_data OUT NOCOPY  VARCHAR2
324     , p4_a0  NUMBER := 0-1962.0724
325     , p4_a1  DATE := fnd_api.g_miss_date
326     , p4_a2  NUMBER := 0-1962.0724
327     , p4_a3  DATE := fnd_api.g_miss_date
328     , p4_a4  NUMBER := 0-1962.0724
329     , p4_a5  NUMBER := 0-1962.0724
330     , p4_a6  NUMBER := 0-1962.0724
331     , p4_a7  NUMBER := 0-1962.0724
332     , p4_a8  NUMBER := 0-1962.0724
333     , p4_a9  NUMBER := 0-1962.0724
334     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
335     , p4_a11  DATE := fnd_api.g_miss_date
336     , p4_a12  NUMBER := 0-1962.0724
337     , p4_a13  VARCHAR2 := fnd_api.g_miss_char
338     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
339     , p4_a15  DATE := fnd_api.g_miss_date
340     , p4_a16  NUMBER := 0-1962.0724
341     , p4_a17  DATE := fnd_api.g_miss_date
342     , p4_a18  DATE := fnd_api.g_miss_date
343     , p4_a19  NUMBER := 0-1962.0724
344     , p4_a20  NUMBER := 0-1962.0724
345     , p4_a21  NUMBER := 0-1962.0724
346     , p4_a22  NUMBER := 0-1962.0724
347     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
348     , p4_a24  NUMBER := 0-1962.0724
349     , p4_a25  NUMBER := 0-1962.0724
350     , p4_a26  NUMBER := 0-1962.0724
351     , p4_a27  NUMBER := 0-1962.0724
352     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
353     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
354     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
355     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
356     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
357     , p4_a33  VARCHAR2 := fnd_api.g_miss_char
358     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
359     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
360     , p4_a36  VARCHAR2 := fnd_api.g_miss_char
361     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
362     , p4_a38  VARCHAR2 := fnd_api.g_miss_char
363     , p4_a39  VARCHAR2 := fnd_api.g_miss_char
364     , p4_a40  VARCHAR2 := fnd_api.g_miss_char
365     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
366     , p4_a42  VARCHAR2 := fnd_api.g_miss_char
367     , p4_a43  VARCHAR2 := fnd_api.g_miss_char
368     , p4_a44  VARCHAR2 := fnd_api.g_miss_char
369     , p4_a45  VARCHAR2 := fnd_api.g_miss_char
370     , p4_a46  VARCHAR2 := fnd_api.g_miss_char
371   );
372   procedure copy_score(p_api_version  NUMBER
373     , p_init_msg_list  VARCHAR2
374     , p_commit  VARCHAR2
375     , p_validation_level  NUMBER
376     , x_return_status OUT NOCOPY  VARCHAR2
377     , x_msg_count OUT NOCOPY  NUMBER
378     , x_msg_data OUT NOCOPY  VARCHAR2
379     , p_source_object_id  NUMBER
380     , p_attributes_table JTF_VARCHAR2_TABLE_100
381     , p9_a0 JTF_VARCHAR2_TABLE_100
382     , p9_a1 JTF_VARCHAR2_TABLE_4000
383     , x_new_object_id OUT NOCOPY  NUMBER
384     , x_custom_setup_id OUT NOCOPY  NUMBER
385   );
386 end ams_dm_score_pvt_w;