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

Source


1 package iex_score_pub_w as
2   /* $Header: iexwscrs.pls 120.6 2004/11/08 19:20:19 clchang ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_2000
7     );
8   procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE
9     , a1 out nocopy JTF_NUMBER_TABLE
10     , a2 out nocopy JTF_NUMBER_TABLE
11     , a3 out nocopy JTF_VARCHAR2_TABLE_2000
12     );
13 
14   procedure rosetta_table_copy_in_p3(t out nocopy iex_score_pub.score_tbl_type, a0 JTF_NUMBER_TABLE
15     , a1 JTF_VARCHAR2_TABLE_300
16     , a2 JTF_DATE_TABLE
17     , a3 JTF_NUMBER_TABLE
18     , a4 JTF_DATE_TABLE
19     , a5 JTF_NUMBER_TABLE
20     , a6 JTF_NUMBER_TABLE
21     , a7 JTF_VARCHAR2_TABLE_200
22     , a8 JTF_VARCHAR2_TABLE_100
23     , a9 JTF_DATE_TABLE
24     , a10 JTF_DATE_TABLE
25     , a11 JTF_NUMBER_TABLE
26     , a12 JTF_VARCHAR2_TABLE_100
27     , a13 JTF_NUMBER_TABLE
28     , a14 JTF_VARCHAR2_TABLE_100
29     , a15 JTF_NUMBER_TABLE
30     , a16 JTF_NUMBER_TABLE
31     , a17 JTF_NUMBER_TABLE
32     , a18 JTF_NUMBER_TABLE
33     , a19 JTF_DATE_TABLE
34     , a20 JTF_VARCHAR2_TABLE_100
35     , a21 JTF_VARCHAR2_TABLE_100
36     , a22 JTF_VARCHAR2_TABLE_1000
37     , a23 JTF_VARCHAR2_TABLE_1000
38     , a24 JTF_VARCHAR2_TABLE_100
39     );
40   procedure rosetta_table_copy_out_p3(t iex_score_pub.score_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41     , a1 out nocopy JTF_VARCHAR2_TABLE_300
42     , a2 out nocopy JTF_DATE_TABLE
43     , a3 out nocopy JTF_NUMBER_TABLE
44     , a4 out nocopy JTF_DATE_TABLE
45     , a5 out nocopy JTF_NUMBER_TABLE
46     , a6 out nocopy JTF_NUMBER_TABLE
47     , a7 out nocopy JTF_VARCHAR2_TABLE_200
48     , a8 out nocopy JTF_VARCHAR2_TABLE_100
49     , a9 out nocopy JTF_DATE_TABLE
50     , a10 out nocopy JTF_DATE_TABLE
51     , a11 out nocopy JTF_NUMBER_TABLE
52     , a12 out nocopy JTF_VARCHAR2_TABLE_100
53     , a13 out nocopy JTF_NUMBER_TABLE
54     , a14 out nocopy JTF_VARCHAR2_TABLE_100
55     , a15 out nocopy JTF_NUMBER_TABLE
56     , a16 out nocopy JTF_NUMBER_TABLE
57     , a17 out nocopy JTF_NUMBER_TABLE
58     , a18 out nocopy JTF_NUMBER_TABLE
59     , a19 out nocopy JTF_DATE_TABLE
60     , a20 out nocopy JTF_VARCHAR2_TABLE_100
61     , a21 out nocopy JTF_VARCHAR2_TABLE_100
62     , a22 out nocopy JTF_VARCHAR2_TABLE_1000
63     , a23 out nocopy JTF_VARCHAR2_TABLE_1000
64     , a24 out nocopy JTF_VARCHAR2_TABLE_100
65     );
66 
67   procedure rosetta_table_copy_in_p7(t out nocopy iex_score_pub.score_comp_tbl_type, a0 JTF_NUMBER_TABLE
68     , a1 JTF_NUMBER_TABLE
69     , a2 JTF_NUMBER_TABLE
70     , a3 JTF_VARCHAR2_TABLE_100
71     , a4 JTF_NUMBER_TABLE
72     , a5 JTF_DATE_TABLE
73     , a6 JTF_NUMBER_TABLE
74     , a7 JTF_DATE_TABLE
75     , a8 JTF_NUMBER_TABLE
76     , a9 JTF_NUMBER_TABLE
77     );
78   procedure rosetta_table_copy_out_p7(t iex_score_pub.score_comp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79     , a1 out nocopy JTF_NUMBER_TABLE
80     , a2 out nocopy JTF_NUMBER_TABLE
81     , a3 out nocopy JTF_VARCHAR2_TABLE_100
82     , a4 out nocopy JTF_NUMBER_TABLE
83     , a5 out nocopy JTF_DATE_TABLE
84     , a6 out nocopy JTF_NUMBER_TABLE
85     , a7 out nocopy JTF_DATE_TABLE
86     , a8 out nocopy JTF_NUMBER_TABLE
87     , a9 out nocopy JTF_NUMBER_TABLE
88     );
89 
90   procedure rosetta_table_copy_in_p11(t out nocopy iex_score_pub.score_comp_det_tbl_type, a0 JTF_NUMBER_TABLE
91     , a1 JTF_NUMBER_TABLE
92     , a2 JTF_NUMBER_TABLE
93     , a3 JTF_NUMBER_TABLE
94     , a4 JTF_VARCHAR2_TABLE_2000
95     , a5 JTF_NUMBER_TABLE
96     , a6 JTF_NUMBER_TABLE
97     , a7 JTF_NUMBER_TABLE
98     , a8 JTF_DATE_TABLE
99     , a9 JTF_NUMBER_TABLE
100     , a10 JTF_DATE_TABLE
101     , a11 JTF_NUMBER_TABLE
102     , a12 JTF_NUMBER_TABLE
103     );
104   procedure rosetta_table_copy_out_p11(t iex_score_pub.score_comp_det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105     , a1 out nocopy JTF_NUMBER_TABLE
106     , a2 out nocopy JTF_NUMBER_TABLE
107     , a3 out nocopy JTF_NUMBER_TABLE
108     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
109     , a5 out nocopy JTF_NUMBER_TABLE
110     , a6 out nocopy JTF_NUMBER_TABLE
111     , a7 out nocopy JTF_NUMBER_TABLE
112     , a8 out nocopy JTF_DATE_TABLE
113     , a9 out nocopy JTF_NUMBER_TABLE
114     , a10 out nocopy JTF_DATE_TABLE
115     , a11 out nocopy JTF_NUMBER_TABLE
116     , a12 out nocopy JTF_NUMBER_TABLE
117     );
118 
119   procedure rosetta_table_copy_in_p15(t out nocopy iex_score_pub.score_comp_type_tbl_type, a0 JTF_NUMBER_TABLE
120     , a1 JTF_NUMBER_TABLE
121     , a2 JTF_NUMBER_TABLE
122     , a3 JTF_NUMBER_TABLE
123     , a4 JTF_DATE_TABLE
124     , a5 JTF_NUMBER_TABLE
125     , a6 JTF_NUMBER_TABLE
126     , a7 JTF_DATE_TABLE
127     , a8 JTF_NUMBER_TABLE
128     , a9 JTF_VARCHAR2_TABLE_2000
129     , a10 JTF_VARCHAR2_TABLE_100
130     , a11 JTF_VARCHAR2_TABLE_100
131     , a12 JTF_VARCHAR2_TABLE_100
132     , a13 JTF_VARCHAR2_TABLE_100
133     , a14 JTF_VARCHAR2_TABLE_100
134     , a15 JTF_VARCHAR2_TABLE_100
135     , a16 JTF_VARCHAR2_TABLE_100
136     , a17 JTF_NUMBER_TABLE
137     );
138   procedure rosetta_table_copy_out_p15(t iex_score_pub.score_comp_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
139     , a1 out nocopy JTF_NUMBER_TABLE
140     , a2 out nocopy JTF_NUMBER_TABLE
141     , a3 out nocopy JTF_NUMBER_TABLE
142     , a4 out nocopy JTF_DATE_TABLE
143     , a5 out nocopy JTF_NUMBER_TABLE
144     , a6 out nocopy JTF_NUMBER_TABLE
145     , a7 out nocopy JTF_DATE_TABLE
146     , a8 out nocopy JTF_NUMBER_TABLE
147     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
148     , a10 out nocopy JTF_VARCHAR2_TABLE_100
149     , a11 out nocopy JTF_VARCHAR2_TABLE_100
150     , a12 out nocopy JTF_VARCHAR2_TABLE_100
151     , a13 out nocopy JTF_VARCHAR2_TABLE_100
152     , a14 out nocopy JTF_VARCHAR2_TABLE_100
153     , a15 out nocopy JTF_VARCHAR2_TABLE_100
154     , a16 out nocopy JTF_VARCHAR2_TABLE_100
155     , a17 out nocopy JTF_NUMBER_TABLE
156     );
157 
158   procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE);
159   procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
160 
161   procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE);
162   procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
163 
164   procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE);
165   procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE);
166 
167   procedure create_score(p_api_version  NUMBER
168     , p_init_msg_list  VARCHAR2
169     , p_commit  VARCHAR2
170     , p3_a0  NUMBER
171     , p3_a1  VARCHAR2
172     , p3_a2  DATE
173     , p3_a3  NUMBER
174     , p3_a4  DATE
175     , p3_a5  NUMBER
176     , p3_a6  NUMBER
177     , p3_a7  VARCHAR2
178     , p3_a8  VARCHAR2
179     , p3_a9  DATE
180     , p3_a10  DATE
181     , p3_a11  NUMBER
182     , p3_a12  VARCHAR2
183     , p3_a13  NUMBER
184     , p3_a14  VARCHAR2
185     , p3_a15  NUMBER
186     , p3_a16  NUMBER
187     , p3_a17  NUMBER
188     , p3_a18  NUMBER
189     , p3_a19  DATE
190     , p3_a20  VARCHAR2
191     , p3_a21  VARCHAR2
192     , p3_a22  VARCHAR2
193     , p3_a23  VARCHAR2
194     , p3_a24  VARCHAR2
195     , x_dup_status out nocopy  VARCHAR2
196     , x_return_status out nocopy  VARCHAR2
197     , x_msg_count out nocopy  NUMBER
198     , x_msg_data out nocopy  VARCHAR2
199     , x_score_id out nocopy  NUMBER
200   );
201   procedure update_score(p_api_version  NUMBER
202     , p_init_msg_list  VARCHAR2
203     , p_commit  VARCHAR2
204     , p3_a0 JTF_NUMBER_TABLE
205     , p3_a1 JTF_VARCHAR2_TABLE_300
206     , p3_a2 JTF_DATE_TABLE
207     , p3_a3 JTF_NUMBER_TABLE
208     , p3_a4 JTF_DATE_TABLE
209     , p3_a5 JTF_NUMBER_TABLE
210     , p3_a6 JTF_NUMBER_TABLE
211     , p3_a7 JTF_VARCHAR2_TABLE_200
212     , p3_a8 JTF_VARCHAR2_TABLE_100
213     , p3_a9 JTF_DATE_TABLE
214     , p3_a10 JTF_DATE_TABLE
215     , p3_a11 JTF_NUMBER_TABLE
216     , p3_a12 JTF_VARCHAR2_TABLE_100
217     , p3_a13 JTF_NUMBER_TABLE
218     , p3_a14 JTF_VARCHAR2_TABLE_100
219     , p3_a15 JTF_NUMBER_TABLE
220     , p3_a16 JTF_NUMBER_TABLE
221     , p3_a17 JTF_NUMBER_TABLE
222     , p3_a18 JTF_NUMBER_TABLE
223     , p3_a19 JTF_DATE_TABLE
224     , p3_a20 JTF_VARCHAR2_TABLE_100
225     , p3_a21 JTF_VARCHAR2_TABLE_100
226     , p3_a22 JTF_VARCHAR2_TABLE_1000
227     , p3_a23 JTF_VARCHAR2_TABLE_1000
228     , p3_a24 JTF_VARCHAR2_TABLE_100
229     , x_dup_status out nocopy  VARCHAR2
230     , x_return_status out nocopy  VARCHAR2
231     , x_msg_count out nocopy  NUMBER
232     , x_msg_data out nocopy  VARCHAR2
233   );
234   procedure delete_score(p_api_version  NUMBER
235     , p_init_msg_list  VARCHAR2
236     , p_commit  VARCHAR2
237     , p_score_id_tbl JTF_NUMBER_TABLE
238     , x_return_status out nocopy  VARCHAR2
239     , x_msg_count out nocopy  NUMBER
240     , x_msg_data out nocopy  VARCHAR2
241   );
242   procedure create_score_comp(p_api_version  NUMBER
243     , p_init_msg_list  VARCHAR2
244     , p_commit  VARCHAR2
245     , p3_a0  NUMBER
246     , p3_a1  NUMBER
247     , p3_a2  NUMBER
248     , p3_a3  VARCHAR2
249     , p3_a4  NUMBER
250     , p3_a5  DATE
251     , p3_a6  NUMBER
252     , p3_a7  DATE
253     , p3_a8  NUMBER
254     , p3_a9  NUMBER
255     , x_return_status out nocopy  VARCHAR2
256     , x_msg_count out nocopy  NUMBER
257     , x_msg_data out nocopy  VARCHAR2
258     , x_score_comp_id out nocopy  NUMBER
259   );
260   procedure update_score_comp(p_api_version  NUMBER
261     , p_init_msg_list  VARCHAR2
262     , p_commit  VARCHAR2
263     , p3_a0 JTF_NUMBER_TABLE
264     , p3_a1 JTF_NUMBER_TABLE
265     , p3_a2 JTF_NUMBER_TABLE
266     , p3_a3 JTF_VARCHAR2_TABLE_100
267     , p3_a4 JTF_NUMBER_TABLE
268     , p3_a5 JTF_DATE_TABLE
269     , p3_a6 JTF_NUMBER_TABLE
270     , p3_a7 JTF_DATE_TABLE
271     , p3_a8 JTF_NUMBER_TABLE
272     , p3_a9 JTF_NUMBER_TABLE
273     , x_return_status out nocopy  VARCHAR2
274     , x_msg_count out nocopy  NUMBER
275     , x_msg_data out nocopy  VARCHAR2
276   );
277   procedure delete_score_comp(p_api_version  NUMBER
278     , p_init_msg_list  VARCHAR2
279     , p_commit  VARCHAR2
280     , p_score_id  NUMBER
281     , p_score_comp_id_tbl JTF_NUMBER_TABLE
282     , x_return_status out nocopy  VARCHAR2
283     , x_msg_count out nocopy  NUMBER
284     , x_msg_data out nocopy  VARCHAR2
285   );
286   procedure create_score_comp_type(p_api_version  NUMBER
287     , p_init_msg_list  VARCHAR2
288     , p_commit  VARCHAR2
289     , p3_a0  NUMBER
290     , p3_a1  NUMBER
291     , p3_a2  NUMBER
292     , p3_a3  NUMBER
293     , p3_a4  DATE
294     , p3_a5  NUMBER
295     , p3_a6  NUMBER
296     , p3_a7  DATE
297     , p3_a8  NUMBER
298     , p3_a9  VARCHAR2
299     , p3_a10  VARCHAR2
300     , p3_a11  VARCHAR2
301     , p3_a12  VARCHAR2
302     , p3_a13  VARCHAR2
303     , p3_a14  VARCHAR2
304     , p3_a15  VARCHAR2
305     , p3_a16  VARCHAR2
306     , p3_a17  NUMBER
307     , x_dup_status out nocopy  VARCHAR2
308     , x_return_status out nocopy  VARCHAR2
309     , x_msg_count out nocopy  NUMBER
310     , x_msg_data out nocopy  VARCHAR2
311     , x_score_comp_type_id out nocopy  NUMBER
312   );
313   procedure update_score_comp_type(p_api_version  NUMBER
314     , p_init_msg_list  VARCHAR2
315     , p_commit  VARCHAR2
316     , p3_a0 JTF_NUMBER_TABLE
317     , p3_a1 JTF_NUMBER_TABLE
318     , p3_a2 JTF_NUMBER_TABLE
319     , p3_a3 JTF_NUMBER_TABLE
320     , p3_a4 JTF_DATE_TABLE
321     , p3_a5 JTF_NUMBER_TABLE
322     , p3_a6 JTF_NUMBER_TABLE
323     , p3_a7 JTF_DATE_TABLE
324     , p3_a8 JTF_NUMBER_TABLE
325     , p3_a9 JTF_VARCHAR2_TABLE_2000
326     , p3_a10 JTF_VARCHAR2_TABLE_100
327     , p3_a11 JTF_VARCHAR2_TABLE_100
328     , p3_a12 JTF_VARCHAR2_TABLE_100
329     , p3_a13 JTF_VARCHAR2_TABLE_100
330     , p3_a14 JTF_VARCHAR2_TABLE_100
331     , p3_a15 JTF_VARCHAR2_TABLE_100
332     , p3_a16 JTF_VARCHAR2_TABLE_100
333     , p3_a17 JTF_NUMBER_TABLE
334     , x_dup_status out nocopy  VARCHAR2
335     , x_return_status out nocopy  VARCHAR2
336     , x_msg_count out nocopy  NUMBER
337     , x_msg_data out nocopy  VARCHAR2
338   );
339   procedure delete_score_comp_type(p_api_version  NUMBER
340     , p_init_msg_list  VARCHAR2
341     , p_commit  VARCHAR2
342     , p3_a0 JTF_NUMBER_TABLE
343     , p3_a1 JTF_NUMBER_TABLE
344     , p3_a2 JTF_NUMBER_TABLE
345     , p3_a3 JTF_NUMBER_TABLE
346     , p3_a4 JTF_DATE_TABLE
347     , p3_a5 JTF_NUMBER_TABLE
348     , p3_a6 JTF_NUMBER_TABLE
349     , p3_a7 JTF_DATE_TABLE
350     , p3_a8 JTF_NUMBER_TABLE
351     , p3_a9 JTF_VARCHAR2_TABLE_2000
352     , p3_a10 JTF_VARCHAR2_TABLE_100
353     , p3_a11 JTF_VARCHAR2_TABLE_100
354     , p3_a12 JTF_VARCHAR2_TABLE_100
355     , p3_a13 JTF_VARCHAR2_TABLE_100
356     , p3_a14 JTF_VARCHAR2_TABLE_100
357     , p3_a15 JTF_VARCHAR2_TABLE_100
358     , p3_a16 JTF_VARCHAR2_TABLE_100
359     , p3_a17 JTF_NUMBER_TABLE
360     , x_return_status out nocopy  VARCHAR2
361     , x_msg_count out nocopy  NUMBER
362     , x_msg_data out nocopy  VARCHAR2
363   );
364   procedure create_score_comp_det(p_api_version  NUMBER
365     , p_init_msg_list  VARCHAR2
366     , p_commit  VARCHAR2
367     , p3_a0 in out nocopy JTF_NUMBER_TABLE
368     , p3_a1 in out nocopy JTF_NUMBER_TABLE
369     , p3_a2 in out nocopy JTF_NUMBER_TABLE
370     , p3_a3 in out nocopy JTF_NUMBER_TABLE
371     , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
372     , p3_a5 in out nocopy JTF_NUMBER_TABLE
373     , p3_a6 in out nocopy JTF_NUMBER_TABLE
374     , p3_a7 in out nocopy JTF_NUMBER_TABLE
375     , p3_a8 in out nocopy JTF_DATE_TABLE
376     , p3_a9 in out nocopy JTF_NUMBER_TABLE
377     , p3_a10 in out nocopy JTF_DATE_TABLE
378     , p3_a11 in out nocopy JTF_NUMBER_TABLE
379     , p3_a12 in out nocopy JTF_NUMBER_TABLE
380     , x_return_status out nocopy  VARCHAR2
381     , x_msg_count out nocopy  NUMBER
382     , x_msg_data out nocopy  VARCHAR2
383   );
384   procedure update_score_comp_det(p_api_version  NUMBER
385     , p_init_msg_list  VARCHAR2
386     , p_commit  VARCHAR2
387     , p3_a0 JTF_NUMBER_TABLE
388     , p3_a1 JTF_NUMBER_TABLE
389     , p3_a2 JTF_NUMBER_TABLE
390     , p3_a3 JTF_NUMBER_TABLE
391     , p3_a4 JTF_VARCHAR2_TABLE_2000
392     , p3_a5 JTF_NUMBER_TABLE
393     , p3_a6 JTF_NUMBER_TABLE
394     , p3_a7 JTF_NUMBER_TABLE
395     , p3_a8 JTF_DATE_TABLE
396     , p3_a9 JTF_NUMBER_TABLE
397     , p3_a10 JTF_DATE_TABLE
398     , p3_a11 JTF_NUMBER_TABLE
399     , p3_a12 JTF_NUMBER_TABLE
400     , x_return_status out nocopy  VARCHAR2
401     , x_msg_count out nocopy  NUMBER
402     , x_msg_data out nocopy  VARCHAR2
403   );
404   procedure delete_score_comp_det(p_api_version  NUMBER
405     , p_init_msg_list  VARCHAR2
406     , p_commit  VARCHAR2
407     , p_score_comp_id  NUMBER
408     , p_score_comp_det_id_tbl JTF_NUMBER_TABLE
409     , x_return_status out nocopy  VARCHAR2
410     , x_msg_count out nocopy  NUMBER
411     , x_msg_data out nocopy  VARCHAR2
412   );
413 end iex_score_pub_w;