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

Source


1 package okl_irh_pvt_w as
2   /* $Header: OKLIIRHS.pls 120.1 2005/07/11 10:42:17 smadhava noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_DATE_TABLE
16     , a13 JTF_DATE_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_DATE_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_DATE_TABLE
22     , a19 JTF_NUMBER_TABLE
23     );
24   procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
25     , a1 out nocopy JTF_NUMBER_TABLE
26     , a2 out nocopy JTF_NUMBER_TABLE
27     , a3 out nocopy JTF_NUMBER_TABLE
28     , a4 out nocopy JTF_NUMBER_TABLE
29     , a5 out nocopy JTF_NUMBER_TABLE
30     , a6 out nocopy JTF_NUMBER_TABLE
31     , a7 out nocopy JTF_NUMBER_TABLE
32     , a8 out nocopy JTF_VARCHAR2_TABLE_100
33     , a9 out nocopy JTF_VARCHAR2_TABLE_100
34     , a10 out nocopy JTF_VARCHAR2_TABLE_100
35     , a11 out nocopy JTF_VARCHAR2_TABLE_100
36     , a12 out nocopy JTF_DATE_TABLE
37     , a13 out nocopy JTF_DATE_TABLE
38     , a14 out nocopy JTF_NUMBER_TABLE
39     , a15 out nocopy JTF_NUMBER_TABLE
40     , a16 out nocopy JTF_DATE_TABLE
41     , a17 out nocopy JTF_NUMBER_TABLE
42     , a18 out nocopy JTF_DATE_TABLE
43     , a19 out nocopy JTF_NUMBER_TABLE
44     );
45 
46   procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
47     , a1 JTF_NUMBER_TABLE
48     , a2 JTF_NUMBER_TABLE
49     , a3 JTF_NUMBER_TABLE
50     , a4 JTF_NUMBER_TABLE
51     , a5 JTF_NUMBER_TABLE
52     , a6 JTF_NUMBER_TABLE
53     , a7 JTF_NUMBER_TABLE
54     , a8 JTF_VARCHAR2_TABLE_100
55     , a9 JTF_VARCHAR2_TABLE_100
56     , a10 JTF_VARCHAR2_TABLE_100
57     , a11 JTF_VARCHAR2_TABLE_100
58     , a12 JTF_DATE_TABLE
59     , a13 JTF_DATE_TABLE
60     , a14 JTF_NUMBER_TABLE
61     , a15 JTF_NUMBER_TABLE
62     , a16 JTF_DATE_TABLE
63     , a17 JTF_NUMBER_TABLE
64     , a18 JTF_DATE_TABLE
65     , a19 JTF_NUMBER_TABLE
66     );
67   procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
68     , a1 out nocopy JTF_NUMBER_TABLE
69     , a2 out nocopy JTF_NUMBER_TABLE
70     , a3 out nocopy JTF_NUMBER_TABLE
71     , a4 out nocopy JTF_NUMBER_TABLE
72     , a5 out nocopy JTF_NUMBER_TABLE
73     , a6 out nocopy JTF_NUMBER_TABLE
74     , a7 out nocopy JTF_NUMBER_TABLE
75     , a8 out nocopy JTF_VARCHAR2_TABLE_100
76     , a9 out nocopy JTF_VARCHAR2_TABLE_100
77     , a10 out nocopy JTF_VARCHAR2_TABLE_100
78     , a11 out nocopy JTF_VARCHAR2_TABLE_100
79     , a12 out nocopy JTF_DATE_TABLE
80     , a13 out nocopy JTF_DATE_TABLE
81     , a14 out nocopy JTF_NUMBER_TABLE
82     , a15 out nocopy JTF_NUMBER_TABLE
83     , a16 out nocopy JTF_DATE_TABLE
84     , a17 out nocopy JTF_NUMBER_TABLE
85     , a18 out nocopy JTF_DATE_TABLE
86     , a19 out nocopy JTF_NUMBER_TABLE
87     );
88 
89   procedure insert_row(p_api_version  NUMBER
90     , p_init_msg_list  VARCHAR2
91     , x_return_status out nocopy  VARCHAR2
92     , x_msg_count out nocopy  NUMBER
93     , x_msg_data out nocopy  VARCHAR2
94     , p5_a0  NUMBER
95     , p5_a1  NUMBER
96     , p5_a2  NUMBER
97     , p5_a3  NUMBER
98     , p5_a4  NUMBER
99     , p5_a5  NUMBER
100     , p5_a6  NUMBER
101     , p5_a7  NUMBER
102     , p5_a8  VARCHAR2
103     , p5_a9  VARCHAR2
104     , p5_a10  VARCHAR2
105     , p5_a11  VARCHAR2
106     , p5_a12  DATE
107     , p5_a13  DATE
108     , p5_a14  NUMBER
109     , p5_a15  NUMBER
110     , p5_a16  DATE
111     , p5_a17  NUMBER
112     , p5_a18  DATE
113     , p5_a19  NUMBER
114     , p6_a0 out nocopy  NUMBER
115     , p6_a1 out nocopy  NUMBER
116     , p6_a2 out nocopy  NUMBER
117     , p6_a3 out nocopy  NUMBER
118     , p6_a4 out nocopy  NUMBER
119     , p6_a5 out nocopy  NUMBER
120     , p6_a6 out nocopy  NUMBER
121     , p6_a7 out nocopy  NUMBER
122     , p6_a8 out nocopy  VARCHAR2
123     , p6_a9 out nocopy  VARCHAR2
124     , p6_a10 out nocopy  VARCHAR2
125     , p6_a11 out nocopy  VARCHAR2
126     , p6_a12 out nocopy  DATE
127     , p6_a13 out nocopy  DATE
128     , p6_a14 out nocopy  NUMBER
129     , p6_a15 out nocopy  NUMBER
130     , p6_a16 out nocopy  DATE
131     , p6_a17 out nocopy  NUMBER
132     , p6_a18 out nocopy  DATE
133     , p6_a19 out nocopy  NUMBER
134   );
135   procedure insert_row(p_api_version  NUMBER
136     , p_init_msg_list  VARCHAR2
137     , x_return_status out nocopy  VARCHAR2
138     , x_msg_count out nocopy  NUMBER
139     , x_msg_data out nocopy  VARCHAR2
140     , p5_a0 JTF_NUMBER_TABLE
141     , p5_a1 JTF_NUMBER_TABLE
142     , p5_a2 JTF_NUMBER_TABLE
143     , p5_a3 JTF_NUMBER_TABLE
144     , p5_a4 JTF_NUMBER_TABLE
145     , p5_a5 JTF_NUMBER_TABLE
146     , p5_a6 JTF_NUMBER_TABLE
147     , p5_a7 JTF_NUMBER_TABLE
148     , p5_a8 JTF_VARCHAR2_TABLE_100
149     , p5_a9 JTF_VARCHAR2_TABLE_100
150     , p5_a10 JTF_VARCHAR2_TABLE_100
151     , p5_a11 JTF_VARCHAR2_TABLE_100
152     , p5_a12 JTF_DATE_TABLE
153     , p5_a13 JTF_DATE_TABLE
154     , p5_a14 JTF_NUMBER_TABLE
155     , p5_a15 JTF_NUMBER_TABLE
156     , p5_a16 JTF_DATE_TABLE
157     , p5_a17 JTF_NUMBER_TABLE
158     , p5_a18 JTF_DATE_TABLE
159     , p5_a19 JTF_NUMBER_TABLE
160     , p6_a0 out nocopy JTF_NUMBER_TABLE
161     , p6_a1 out nocopy JTF_NUMBER_TABLE
162     , p6_a2 out nocopy JTF_NUMBER_TABLE
163     , p6_a3 out nocopy JTF_NUMBER_TABLE
164     , p6_a4 out nocopy JTF_NUMBER_TABLE
165     , p6_a5 out nocopy JTF_NUMBER_TABLE
166     , p6_a6 out nocopy JTF_NUMBER_TABLE
167     , p6_a7 out nocopy JTF_NUMBER_TABLE
168     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
169     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
172     , p6_a12 out nocopy JTF_DATE_TABLE
173     , p6_a13 out nocopy JTF_DATE_TABLE
174     , p6_a14 out nocopy JTF_NUMBER_TABLE
175     , p6_a15 out nocopy JTF_NUMBER_TABLE
176     , p6_a16 out nocopy JTF_DATE_TABLE
177     , p6_a17 out nocopy JTF_NUMBER_TABLE
178     , p6_a18 out nocopy JTF_DATE_TABLE
179     , p6_a19 out nocopy JTF_NUMBER_TABLE
180   );
181   procedure update_row(p_api_version  NUMBER
182     , p_init_msg_list  VARCHAR2
183     , x_return_status out nocopy  VARCHAR2
184     , x_msg_count out nocopy  NUMBER
185     , x_msg_data out nocopy  VARCHAR2
186     , p5_a0  NUMBER
187     , p5_a1  NUMBER
188     , p5_a2  NUMBER
189     , p5_a3  NUMBER
190     , p5_a4  NUMBER
191     , p5_a5  NUMBER
192     , p5_a6  NUMBER
193     , p5_a7  NUMBER
194     , p5_a8  VARCHAR2
195     , p5_a9  VARCHAR2
196     , p5_a10  VARCHAR2
197     , p5_a11  VARCHAR2
198     , p5_a12  DATE
199     , p5_a13  DATE
200     , p5_a14  NUMBER
201     , p5_a15  NUMBER
202     , p5_a16  DATE
203     , p5_a17  NUMBER
204     , p5_a18  DATE
205     , p5_a19  NUMBER
206     , p6_a0 out nocopy  NUMBER
207     , p6_a1 out nocopy  NUMBER
208     , p6_a2 out nocopy  NUMBER
209     , p6_a3 out nocopy  NUMBER
210     , p6_a4 out nocopy  NUMBER
211     , p6_a5 out nocopy  NUMBER
212     , p6_a6 out nocopy  NUMBER
213     , p6_a7 out nocopy  NUMBER
214     , p6_a8 out nocopy  VARCHAR2
215     , p6_a9 out nocopy  VARCHAR2
216     , p6_a10 out nocopy  VARCHAR2
217     , p6_a11 out nocopy  VARCHAR2
218     , p6_a12 out nocopy  DATE
219     , p6_a13 out nocopy  DATE
220     , p6_a14 out nocopy  NUMBER
221     , p6_a15 out nocopy  NUMBER
222     , p6_a16 out nocopy  DATE
223     , p6_a17 out nocopy  NUMBER
224     , p6_a18 out nocopy  DATE
225     , p6_a19 out nocopy  NUMBER
226   );
227   procedure update_row(p_api_version  NUMBER
228     , p_init_msg_list  VARCHAR2
229     , x_return_status out nocopy  VARCHAR2
230     , x_msg_count out nocopy  NUMBER
231     , x_msg_data out nocopy  VARCHAR2
232     , p5_a0 JTF_NUMBER_TABLE
233     , p5_a1 JTF_NUMBER_TABLE
234     , p5_a2 JTF_NUMBER_TABLE
235     , p5_a3 JTF_NUMBER_TABLE
236     , p5_a4 JTF_NUMBER_TABLE
237     , p5_a5 JTF_NUMBER_TABLE
238     , p5_a6 JTF_NUMBER_TABLE
239     , p5_a7 JTF_NUMBER_TABLE
240     , p5_a8 JTF_VARCHAR2_TABLE_100
241     , p5_a9 JTF_VARCHAR2_TABLE_100
242     , p5_a10 JTF_VARCHAR2_TABLE_100
243     , p5_a11 JTF_VARCHAR2_TABLE_100
244     , p5_a12 JTF_DATE_TABLE
245     , p5_a13 JTF_DATE_TABLE
246     , p5_a14 JTF_NUMBER_TABLE
247     , p5_a15 JTF_NUMBER_TABLE
248     , p5_a16 JTF_DATE_TABLE
249     , p5_a17 JTF_NUMBER_TABLE
250     , p5_a18 JTF_DATE_TABLE
251     , p5_a19 JTF_NUMBER_TABLE
252     , p6_a0 out nocopy JTF_NUMBER_TABLE
253     , p6_a1 out nocopy JTF_NUMBER_TABLE
254     , p6_a2 out nocopy JTF_NUMBER_TABLE
255     , p6_a3 out nocopy JTF_NUMBER_TABLE
256     , p6_a4 out nocopy JTF_NUMBER_TABLE
257     , p6_a5 out nocopy JTF_NUMBER_TABLE
258     , p6_a6 out nocopy JTF_NUMBER_TABLE
259     , p6_a7 out nocopy JTF_NUMBER_TABLE
260     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
261     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
262     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
263     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
264     , p6_a12 out nocopy JTF_DATE_TABLE
265     , p6_a13 out nocopy JTF_DATE_TABLE
266     , p6_a14 out nocopy JTF_NUMBER_TABLE
267     , p6_a15 out nocopy JTF_NUMBER_TABLE
268     , p6_a16 out nocopy JTF_DATE_TABLE
269     , p6_a17 out nocopy JTF_NUMBER_TABLE
270     , p6_a18 out nocopy JTF_DATE_TABLE
271     , p6_a19 out nocopy JTF_NUMBER_TABLE
272   );
273   procedure delete_row(p_api_version  NUMBER
274     , p_init_msg_list  VARCHAR2
275     , x_return_status out nocopy  VARCHAR2
276     , x_msg_count out nocopy  NUMBER
277     , x_msg_data out nocopy  VARCHAR2
278     , p5_a0  NUMBER
279     , p5_a1  NUMBER
280     , p5_a2  NUMBER
281     , p5_a3  NUMBER
282     , p5_a4  NUMBER
283     , p5_a5  NUMBER
284     , p5_a6  NUMBER
285     , p5_a7  NUMBER
286     , p5_a8  VARCHAR2
287     , p5_a9  VARCHAR2
288     , p5_a10  VARCHAR2
289     , p5_a11  VARCHAR2
290     , p5_a12  DATE
291     , p5_a13  DATE
292     , p5_a14  NUMBER
293     , p5_a15  NUMBER
294     , p5_a16  DATE
295     , p5_a17  NUMBER
296     , p5_a18  DATE
297     , p5_a19  NUMBER
298   );
299   procedure delete_row(p_api_version  NUMBER
300     , p_init_msg_list  VARCHAR2
301     , x_return_status out nocopy  VARCHAR2
302     , x_msg_count out nocopy  NUMBER
303     , x_msg_data out nocopy  VARCHAR2
304     , p5_a0 JTF_NUMBER_TABLE
305     , p5_a1 JTF_NUMBER_TABLE
306     , p5_a2 JTF_NUMBER_TABLE
307     , p5_a3 JTF_NUMBER_TABLE
308     , p5_a4 JTF_NUMBER_TABLE
309     , p5_a5 JTF_NUMBER_TABLE
310     , p5_a6 JTF_NUMBER_TABLE
311     , p5_a7 JTF_NUMBER_TABLE
312     , p5_a8 JTF_VARCHAR2_TABLE_100
313     , p5_a9 JTF_VARCHAR2_TABLE_100
314     , p5_a10 JTF_VARCHAR2_TABLE_100
315     , p5_a11 JTF_VARCHAR2_TABLE_100
316     , p5_a12 JTF_DATE_TABLE
317     , p5_a13 JTF_DATE_TABLE
318     , p5_a14 JTF_NUMBER_TABLE
319     , p5_a15 JTF_NUMBER_TABLE
320     , p5_a16 JTF_DATE_TABLE
321     , p5_a17 JTF_NUMBER_TABLE
322     , p5_a18 JTF_DATE_TABLE
323     , p5_a19 JTF_NUMBER_TABLE
324   );
325 end okl_irh_pvt_w;