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

Source


1 package ozf_reason_pvt_w AUTHID CURRENT_USER as
2   /* $Header: ozfwreas.pls 120.3 2006/05/17 01:16:43 sshivali ship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     );
10   procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11     , a1 out nocopy JTF_NUMBER_TABLE
12     , a2 out nocopy JTF_NUMBER_TABLE
13     , a3 out nocopy JTF_NUMBER_TABLE
14     , a4 out nocopy JTF_VARCHAR2_TABLE_100
15     , a5 out nocopy JTF_VARCHAR2_TABLE_100
16     );
17 
18   procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE
19     , a1 JTF_NUMBER_TABLE
20     , a2 JTF_DATE_TABLE
21     , a3 JTF_NUMBER_TABLE
22     , a4 JTF_DATE_TABLE
23     , a5 JTF_NUMBER_TABLE
24     , a6 JTF_NUMBER_TABLE
25     , a7 JTF_VARCHAR2_TABLE_100
26     , a8 JTF_DATE_TABLE
27     , a9 JTF_DATE_TABLE
28     , a10 JTF_VARCHAR2_TABLE_100
29     , a11 JTF_VARCHAR2_TABLE_200
30     , a12 JTF_VARCHAR2_TABLE_200
31     , a13 JTF_VARCHAR2_TABLE_200
32     , a14 JTF_VARCHAR2_TABLE_200
33     , a15 JTF_VARCHAR2_TABLE_200
34     , a16 JTF_VARCHAR2_TABLE_200
35     , a17 JTF_VARCHAR2_TABLE_200
36     , a18 JTF_VARCHAR2_TABLE_200
37     , a19 JTF_VARCHAR2_TABLE_200
38     , a20 JTF_VARCHAR2_TABLE_200
39     , a21 JTF_VARCHAR2_TABLE_200
40     , a22 JTF_VARCHAR2_TABLE_200
41     , a23 JTF_VARCHAR2_TABLE_200
42     , a24 JTF_VARCHAR2_TABLE_200
43     , a25 JTF_VARCHAR2_TABLE_200
44     , a26 JTF_VARCHAR2_TABLE_100
45     , a27 JTF_VARCHAR2_TABLE_2000
46     , a28 JTF_NUMBER_TABLE
47     , a29 JTF_VARCHAR2_TABLE_100
48     , a30 JTF_VARCHAR2_TABLE_100
49     , a31 JTF_VARCHAR2_TABLE_100
50     , a32 JTF_NUMBER_TABLE
51     , a33 JTF_VARCHAR2_TABLE_100
52     );
53   procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54     , a1 out nocopy JTF_NUMBER_TABLE
55     , a2 out nocopy JTF_DATE_TABLE
56     , a3 out nocopy JTF_NUMBER_TABLE
57     , a4 out nocopy JTF_DATE_TABLE
58     , a5 out nocopy JTF_NUMBER_TABLE
59     , a6 out nocopy JTF_NUMBER_TABLE
60     , a7 out nocopy JTF_VARCHAR2_TABLE_100
61     , a8 out nocopy JTF_DATE_TABLE
62     , a9 out nocopy JTF_DATE_TABLE
63     , a10 out nocopy JTF_VARCHAR2_TABLE_100
64     , a11 out nocopy JTF_VARCHAR2_TABLE_200
65     , a12 out nocopy JTF_VARCHAR2_TABLE_200
66     , a13 out nocopy JTF_VARCHAR2_TABLE_200
67     , a14 out nocopy JTF_VARCHAR2_TABLE_200
68     , a15 out nocopy JTF_VARCHAR2_TABLE_200
69     , a16 out nocopy JTF_VARCHAR2_TABLE_200
70     , a17 out nocopy JTF_VARCHAR2_TABLE_200
71     , a18 out nocopy JTF_VARCHAR2_TABLE_200
72     , a19 out nocopy JTF_VARCHAR2_TABLE_200
73     , a20 out nocopy JTF_VARCHAR2_TABLE_200
74     , a21 out nocopy JTF_VARCHAR2_TABLE_200
75     , a22 out nocopy JTF_VARCHAR2_TABLE_200
76     , a23 out nocopy JTF_VARCHAR2_TABLE_200
77     , a24 out nocopy JTF_VARCHAR2_TABLE_200
78     , a25 out nocopy JTF_VARCHAR2_TABLE_200
79     , a26 out nocopy JTF_VARCHAR2_TABLE_100
80     , a27 out nocopy JTF_VARCHAR2_TABLE_2000
81     , a28 out nocopy JTF_NUMBER_TABLE
82     , a29 out nocopy JTF_VARCHAR2_TABLE_100
83     , a30 out nocopy JTF_VARCHAR2_TABLE_100
84     , a31 out nocopy JTF_VARCHAR2_TABLE_100
85     , a32 out nocopy JTF_NUMBER_TABLE
86     , a33 out nocopy JTF_VARCHAR2_TABLE_100
87     );
88 
89   procedure create_reason(p_api_version_number  NUMBER
90     , p_init_msg_list  VARCHAR2
91     , p_commit  VARCHAR2
92     , p_validation_level  NUMBER
93     , x_return_status out nocopy  VARCHAR2
94     , x_msg_count out nocopy  NUMBER
95     , x_msg_data out nocopy  VARCHAR2
96     , p7_a0  NUMBER
97     , p7_a1  NUMBER
98     , p7_a2  DATE
99     , p7_a3  NUMBER
100     , p7_a4  DATE
101     , p7_a5  NUMBER
102     , p7_a6  NUMBER
103     , p7_a7  VARCHAR2
104     , p7_a8  DATE
105     , p7_a9  DATE
106     , p7_a10  VARCHAR2
107     , p7_a11  VARCHAR2
108     , p7_a12  VARCHAR2
109     , p7_a13  VARCHAR2
110     , p7_a14  VARCHAR2
111     , p7_a15  VARCHAR2
112     , p7_a16  VARCHAR2
113     , p7_a17  VARCHAR2
114     , p7_a18  VARCHAR2
115     , p7_a19  VARCHAR2
116     , p7_a20  VARCHAR2
117     , p7_a21  VARCHAR2
118     , p7_a22  VARCHAR2
119     , p7_a23  VARCHAR2
120     , p7_a24  VARCHAR2
121     , p7_a25  VARCHAR2
122     , p7_a26  VARCHAR2
123     , p7_a27  VARCHAR2
124     , p7_a28  NUMBER
125     , p7_a29  VARCHAR2
126     , p7_a30  VARCHAR2
127     , p7_a31  VARCHAR2
128     , p7_a32  NUMBER
129     , p7_a33  VARCHAR2
130     , x_reason_code_id out nocopy  NUMBER
131   );
132   procedure update_reason(p_api_version_number  NUMBER
133     , p_init_msg_list  VARCHAR2
134     , p_commit  VARCHAR2
135     , p_validation_level  NUMBER
136     , x_return_status out nocopy  VARCHAR2
137     , x_msg_count out nocopy  NUMBER
138     , x_msg_data out nocopy  VARCHAR2
139     , p7_a0  NUMBER
140     , p7_a1  NUMBER
141     , p7_a2  DATE
142     , p7_a3  NUMBER
143     , p7_a4  DATE
144     , p7_a5  NUMBER
145     , p7_a6  NUMBER
146     , p7_a7  VARCHAR2
147     , p7_a8  DATE
148     , p7_a9  DATE
149     , p7_a10  VARCHAR2
150     , p7_a11  VARCHAR2
151     , p7_a12  VARCHAR2
152     , p7_a13  VARCHAR2
153     , p7_a14  VARCHAR2
154     , p7_a15  VARCHAR2
155     , p7_a16  VARCHAR2
156     , p7_a17  VARCHAR2
157     , p7_a18  VARCHAR2
158     , p7_a19  VARCHAR2
159     , p7_a20  VARCHAR2
160     , p7_a21  VARCHAR2
161     , p7_a22  VARCHAR2
162     , p7_a23  VARCHAR2
163     , p7_a24  VARCHAR2
164     , p7_a25  VARCHAR2
165     , p7_a26  VARCHAR2
166     , p7_a27  VARCHAR2
167     , p7_a28  NUMBER
168     , p7_a29  VARCHAR2
169     , p7_a30  VARCHAR2
170     , p7_a31  VARCHAR2
171     , p7_a32  NUMBER
172     , p7_a33  VARCHAR2
173     , x_object_version_number out nocopy  NUMBER
174   );
175   procedure update_actions(p_api_version_number  NUMBER
176     , p_init_msg_list  VARCHAR2
177     , p_commit  VARCHAR2
178     , p_validation_level  NUMBER
179     , x_return_status out nocopy  VARCHAR2
180     , x_msg_count out nocopy  NUMBER
181     , x_msg_data out nocopy  VARCHAR2
182     , p7_a0 JTF_NUMBER_TABLE
183     , p7_a1 JTF_NUMBER_TABLE
184     , p7_a2 JTF_NUMBER_TABLE
185     , p7_a3 JTF_NUMBER_TABLE
186     , p7_a4 JTF_VARCHAR2_TABLE_100
187     , p7_a5 JTF_VARCHAR2_TABLE_100
188   );
189   procedure check_unique_action(p0_a0  NUMBER
190     , p0_a1  NUMBER
191     , p0_a2  NUMBER
192     , p0_a3  NUMBER
193     , p0_a4  VARCHAR2
194     , p0_a5  VARCHAR2
195     , p_validation_mode  VARCHAR2
196     , x_return_status out nocopy  VARCHAR2
197   );
198   procedure validate_reason_rec(p_api_version_number  NUMBER
199     , p_init_msg_list  VARCHAR2
200     , x_return_status out nocopy  VARCHAR2
201     , x_msg_count out nocopy  NUMBER
202     , x_msg_data out nocopy  VARCHAR2
203     , p5_a0  NUMBER
204     , p5_a1  NUMBER
205     , p5_a2  DATE
206     , p5_a3  NUMBER
207     , p5_a4  DATE
208     , p5_a5  NUMBER
209     , p5_a6  NUMBER
210     , p5_a7  VARCHAR2
211     , p5_a8  DATE
212     , p5_a9  DATE
213     , p5_a10  VARCHAR2
214     , p5_a11  VARCHAR2
215     , p5_a12  VARCHAR2
216     , p5_a13  VARCHAR2
217     , p5_a14  VARCHAR2
218     , p5_a15  VARCHAR2
219     , p5_a16  VARCHAR2
220     , p5_a17  VARCHAR2
221     , p5_a18  VARCHAR2
222     , p5_a19  VARCHAR2
223     , p5_a20  VARCHAR2
224     , p5_a21  VARCHAR2
225     , p5_a22  VARCHAR2
226     , p5_a23  VARCHAR2
227     , p5_a24  VARCHAR2
228     , p5_a25  VARCHAR2
229     , p5_a26  VARCHAR2
230     , p5_a27  VARCHAR2
231     , p5_a28  NUMBER
232     , p5_a29  VARCHAR2
233     , p5_a30  VARCHAR2
234     , p5_a31  VARCHAR2
235     , p5_a32  NUMBER
236     , p5_a33  VARCHAR2
237   );
238   procedure validate_reason(p_api_version_number  NUMBER
239     , p_init_msg_list  VARCHAR2
240     , p_validation_level  NUMBER
241     , p3_a0  NUMBER
242     , p3_a1  NUMBER
243     , p3_a2  DATE
244     , p3_a3  NUMBER
245     , p3_a4  DATE
246     , p3_a5  NUMBER
247     , p3_a6  NUMBER
248     , p3_a7  VARCHAR2
249     , p3_a8  DATE
250     , p3_a9  DATE
251     , p3_a10  VARCHAR2
252     , p3_a11  VARCHAR2
253     , p3_a12  VARCHAR2
254     , p3_a13  VARCHAR2
255     , p3_a14  VARCHAR2
256     , p3_a15  VARCHAR2
257     , p3_a16  VARCHAR2
258     , p3_a17  VARCHAR2
259     , p3_a18  VARCHAR2
260     , p3_a19  VARCHAR2
261     , p3_a20  VARCHAR2
262     , p3_a21  VARCHAR2
263     , p3_a22  VARCHAR2
264     , p3_a23  VARCHAR2
265     , p3_a24  VARCHAR2
266     , p3_a25  VARCHAR2
267     , p3_a26  VARCHAR2
268     , p3_a27  VARCHAR2
269     , p3_a28  NUMBER
270     , p3_a29  VARCHAR2
271     , p3_a30  VARCHAR2
272     , p3_a31  VARCHAR2
273     , p3_a32  NUMBER
274     , p3_a33  VARCHAR2
275     , x_return_status out nocopy  VARCHAR2
276     , x_msg_count out nocopy  NUMBER
277     , x_msg_data out nocopy  VARCHAR2
278   );
279   procedure complete_reason_rec(p0_a0  NUMBER
280     , p0_a1  NUMBER
281     , p0_a2  DATE
282     , p0_a3  NUMBER
283     , p0_a4  DATE
284     , p0_a5  NUMBER
285     , p0_a6  NUMBER
286     , p0_a7  VARCHAR2
287     , p0_a8  DATE
288     , p0_a9  DATE
289     , p0_a10  VARCHAR2
290     , p0_a11  VARCHAR2
291     , p0_a12  VARCHAR2
292     , p0_a13  VARCHAR2
293     , p0_a14  VARCHAR2
294     , p0_a15  VARCHAR2
295     , p0_a16  VARCHAR2
296     , p0_a17  VARCHAR2
297     , p0_a18  VARCHAR2
298     , p0_a19  VARCHAR2
299     , p0_a20  VARCHAR2
300     , p0_a21  VARCHAR2
301     , p0_a22  VARCHAR2
302     , p0_a23  VARCHAR2
303     , p0_a24  VARCHAR2
304     , p0_a25  VARCHAR2
305     , p0_a26  VARCHAR2
306     , p0_a27  VARCHAR2
307     , p0_a28  NUMBER
308     , p0_a29  VARCHAR2
309     , p0_a30  VARCHAR2
310     , p0_a31  VARCHAR2
311     , p0_a32  NUMBER
312     , p0_a33  VARCHAR2
313     , p1_a0 out nocopy  NUMBER
314     , p1_a1 out nocopy  NUMBER
315     , p1_a2 out nocopy  DATE
316     , p1_a3 out nocopy  NUMBER
317     , p1_a4 out nocopy  DATE
318     , p1_a5 out nocopy  NUMBER
319     , p1_a6 out nocopy  NUMBER
320     , p1_a7 out nocopy  VARCHAR2
321     , p1_a8 out nocopy  DATE
322     , p1_a9 out nocopy  DATE
323     , p1_a10 out nocopy  VARCHAR2
324     , p1_a11 out nocopy  VARCHAR2
325     , p1_a12 out nocopy  VARCHAR2
326     , p1_a13 out nocopy  VARCHAR2
327     , p1_a14 out nocopy  VARCHAR2
328     , p1_a15 out nocopy  VARCHAR2
329     , p1_a16 out nocopy  VARCHAR2
330     , p1_a17 out nocopy  VARCHAR2
331     , p1_a18 out nocopy  VARCHAR2
332     , p1_a19 out nocopy  VARCHAR2
333     , p1_a20 out nocopy  VARCHAR2
334     , p1_a21 out nocopy  VARCHAR2
335     , p1_a22 out nocopy  VARCHAR2
336     , p1_a23 out nocopy  VARCHAR2
337     , p1_a24 out nocopy  VARCHAR2
338     , p1_a25 out nocopy  VARCHAR2
339     , p1_a26 out nocopy  VARCHAR2
340     , p1_a27 out nocopy  VARCHAR2
341     , p1_a28 out nocopy  NUMBER
342     , p1_a29 out nocopy  VARCHAR2
343     , p1_a30 out nocopy  VARCHAR2
344     , p1_a31 out nocopy  VARCHAR2
345     , p1_a32 out nocopy  NUMBER
346     , p1_a33 out nocopy  VARCHAR2
347     , x_return_status out nocopy  VARCHAR2
348   );
349 end ozf_reason_pvt_w;