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_SIT_PVT_W

Source


1 package okl_sit_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLISITS.pls 120.1 2005/07/30 09:40:05 asawanka noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy okl_sit_pvt.sit_tbl_type, 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_DATE_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_200
15     );
16   procedure rosetta_table_copy_out_p2(t okl_sit_pvt.sit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17     , a1 out nocopy JTF_NUMBER_TABLE
18     , a2 out nocopy JTF_NUMBER_TABLE
19     , a3 out nocopy JTF_NUMBER_TABLE
20     , a4 out nocopy JTF_NUMBER_TABLE
21     , a5 out nocopy JTF_NUMBER_TABLE
22     , a6 out nocopy JTF_NUMBER_TABLE
23     , a7 out nocopy JTF_DATE_TABLE
24     , a8 out nocopy JTF_NUMBER_TABLE
25     , a9 out nocopy JTF_DATE_TABLE
26     , a10 out nocopy JTF_NUMBER_TABLE
27     , a11 out nocopy JTF_VARCHAR2_TABLE_200
28     );
29 
30   procedure rosetta_table_copy_in_p5(t out nocopy okl_sit_pvt.sitv_tbl_type, a0 JTF_NUMBER_TABLE
31     , a1 JTF_NUMBER_TABLE
32     , a2 JTF_NUMBER_TABLE
33     , a3 JTF_NUMBER_TABLE
34     , a4 JTF_NUMBER_TABLE
35     , a5 JTF_NUMBER_TABLE
36     , a6 JTF_NUMBER_TABLE
37     , a7 JTF_DATE_TABLE
38     , a8 JTF_NUMBER_TABLE
39     , a9 JTF_DATE_TABLE
40     , a10 JTF_NUMBER_TABLE
41     , a11 JTF_VARCHAR2_TABLE_200
42     );
43   procedure rosetta_table_copy_out_p5(t okl_sit_pvt.sitv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44     , a1 out nocopy JTF_NUMBER_TABLE
45     , a2 out nocopy JTF_NUMBER_TABLE
46     , a3 out nocopy JTF_NUMBER_TABLE
47     , a4 out nocopy JTF_NUMBER_TABLE
48     , a5 out nocopy JTF_NUMBER_TABLE
49     , a6 out nocopy JTF_NUMBER_TABLE
50     , a7 out nocopy JTF_DATE_TABLE
51     , a8 out nocopy JTF_NUMBER_TABLE
52     , a9 out nocopy JTF_DATE_TABLE
53     , a10 out nocopy JTF_NUMBER_TABLE
54     , a11 out nocopy JTF_VARCHAR2_TABLE_200
55     );
56 
57   procedure insert_row(p_api_version  NUMBER
58     , p_init_msg_list  VARCHAR2
59     , x_return_status out nocopy  VARCHAR2
60     , x_msg_count out nocopy  NUMBER
61     , x_msg_data out nocopy  VARCHAR2
62     , p6_a0 out nocopy  NUMBER
63     , p6_a1 out nocopy  NUMBER
64     , p6_a2 out nocopy  NUMBER
65     , p6_a3 out nocopy  NUMBER
66     , p6_a4 out nocopy  NUMBER
67     , p6_a5 out nocopy  NUMBER
68     , p6_a6 out nocopy  NUMBER
69     , p6_a7 out nocopy  DATE
70     , p6_a8 out nocopy  NUMBER
71     , p6_a9 out nocopy  DATE
72     , p6_a10 out nocopy  NUMBER
73     , p6_a11 out nocopy  VARCHAR2
74     , p5_a0  NUMBER := 0-1962.0724
75     , p5_a1  NUMBER := 0-1962.0724
76     , p5_a2  NUMBER := 0-1962.0724
77     , p5_a3  NUMBER := 0-1962.0724
78     , p5_a4  NUMBER := 0-1962.0724
79     , p5_a5  NUMBER := 0-1962.0724
80     , p5_a6  NUMBER := 0-1962.0724
81     , p5_a7  DATE := fnd_api.g_miss_date
82     , p5_a8  NUMBER := 0-1962.0724
83     , p5_a9  DATE := fnd_api.g_miss_date
84     , p5_a10  NUMBER := 0-1962.0724
85     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
86   );
87   procedure insert_row(p_api_version  NUMBER
88     , p_init_msg_list  VARCHAR2
89     , x_return_status out nocopy  VARCHAR2
90     , x_msg_count out nocopy  NUMBER
91     , x_msg_data out nocopy  VARCHAR2
92     , p5_a0 JTF_NUMBER_TABLE
93     , p5_a1 JTF_NUMBER_TABLE
94     , p5_a2 JTF_NUMBER_TABLE
95     , p5_a3 JTF_NUMBER_TABLE
96     , p5_a4 JTF_NUMBER_TABLE
97     , p5_a5 JTF_NUMBER_TABLE
98     , p5_a6 JTF_NUMBER_TABLE
99     , p5_a7 JTF_DATE_TABLE
100     , p5_a8 JTF_NUMBER_TABLE
101     , p5_a9 JTF_DATE_TABLE
102     , p5_a10 JTF_NUMBER_TABLE
103     , p5_a11 JTF_VARCHAR2_TABLE_200
104     , p6_a0 out nocopy JTF_NUMBER_TABLE
105     , p6_a1 out nocopy JTF_NUMBER_TABLE
106     , p6_a2 out nocopy JTF_NUMBER_TABLE
107     , p6_a3 out nocopy JTF_NUMBER_TABLE
108     , p6_a4 out nocopy JTF_NUMBER_TABLE
109     , p6_a5 out nocopy JTF_NUMBER_TABLE
110     , p6_a6 out nocopy JTF_NUMBER_TABLE
111     , p6_a7 out nocopy JTF_DATE_TABLE
112     , p6_a8 out nocopy JTF_NUMBER_TABLE
113     , p6_a9 out nocopy JTF_DATE_TABLE
114     , p6_a10 out nocopy JTF_NUMBER_TABLE
115     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
116   );
117   procedure lock_row(p_api_version  NUMBER
118     , p_init_msg_list  VARCHAR2
119     , x_return_status out nocopy  VARCHAR2
120     , x_msg_count out nocopy  NUMBER
121     , x_msg_data out nocopy  VARCHAR2
122     , p5_a0  NUMBER := 0-1962.0724
123     , p5_a1  NUMBER := 0-1962.0724
124     , p5_a2  NUMBER := 0-1962.0724
125     , p5_a3  NUMBER := 0-1962.0724
126     , p5_a4  NUMBER := 0-1962.0724
127     , p5_a5  NUMBER := 0-1962.0724
128     , p5_a6  NUMBER := 0-1962.0724
129     , p5_a7  DATE := fnd_api.g_miss_date
130     , p5_a8  NUMBER := 0-1962.0724
131     , p5_a9  DATE := fnd_api.g_miss_date
132     , p5_a10  NUMBER := 0-1962.0724
133     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
134   );
135   procedure lock_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_DATE_TABLE
148     , p5_a8 JTF_NUMBER_TABLE
149     , p5_a9 JTF_DATE_TABLE
150     , p5_a10 JTF_NUMBER_TABLE
151     , p5_a11 JTF_VARCHAR2_TABLE_200
152   );
153   procedure update_row(p_api_version  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , x_return_status out nocopy  VARCHAR2
156     , x_msg_count out nocopy  NUMBER
157     , x_msg_data out nocopy  VARCHAR2
158     , p6_a0 out nocopy  NUMBER
159     , p6_a1 out nocopy  NUMBER
160     , p6_a2 out nocopy  NUMBER
161     , p6_a3 out nocopy  NUMBER
162     , p6_a4 out nocopy  NUMBER
163     , p6_a5 out nocopy  NUMBER
164     , p6_a6 out nocopy  NUMBER
165     , p6_a7 out nocopy  DATE
166     , p6_a8 out nocopy  NUMBER
167     , p6_a9 out nocopy  DATE
168     , p6_a10 out nocopy  NUMBER
169     , p6_a11 out nocopy  VARCHAR2
170     , p5_a0  NUMBER := 0-1962.0724
171     , p5_a1  NUMBER := 0-1962.0724
172     , p5_a2  NUMBER := 0-1962.0724
173     , p5_a3  NUMBER := 0-1962.0724
174     , p5_a4  NUMBER := 0-1962.0724
175     , p5_a5  NUMBER := 0-1962.0724
176     , p5_a6  NUMBER := 0-1962.0724
177     , p5_a7  DATE := fnd_api.g_miss_date
178     , p5_a8  NUMBER := 0-1962.0724
179     , p5_a9  DATE := fnd_api.g_miss_date
180     , p5_a10  NUMBER := 0-1962.0724
181     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
182   );
183   procedure update_row(p_api_version  NUMBER
184     , p_init_msg_list  VARCHAR2
185     , x_return_status out nocopy  VARCHAR2
186     , x_msg_count out nocopy  NUMBER
187     , x_msg_data out nocopy  VARCHAR2
188     , p5_a0 JTF_NUMBER_TABLE
189     , p5_a1 JTF_NUMBER_TABLE
190     , p5_a2 JTF_NUMBER_TABLE
191     , p5_a3 JTF_NUMBER_TABLE
192     , p5_a4 JTF_NUMBER_TABLE
193     , p5_a5 JTF_NUMBER_TABLE
194     , p5_a6 JTF_NUMBER_TABLE
195     , p5_a7 JTF_DATE_TABLE
196     , p5_a8 JTF_NUMBER_TABLE
197     , p5_a9 JTF_DATE_TABLE
198     , p5_a10 JTF_NUMBER_TABLE
199     , p5_a11 JTF_VARCHAR2_TABLE_200
200     , p6_a0 out nocopy JTF_NUMBER_TABLE
201     , p6_a1 out nocopy JTF_NUMBER_TABLE
202     , p6_a2 out nocopy JTF_NUMBER_TABLE
203     , p6_a3 out nocopy JTF_NUMBER_TABLE
204     , p6_a4 out nocopy JTF_NUMBER_TABLE
205     , p6_a5 out nocopy JTF_NUMBER_TABLE
206     , p6_a6 out nocopy JTF_NUMBER_TABLE
207     , p6_a7 out nocopy JTF_DATE_TABLE
208     , p6_a8 out nocopy JTF_NUMBER_TABLE
209     , p6_a9 out nocopy JTF_DATE_TABLE
210     , p6_a10 out nocopy JTF_NUMBER_TABLE
211     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
212   );
213   procedure delete_row(p_api_version  NUMBER
214     , p_init_msg_list  VARCHAR2
215     , x_return_status out nocopy  VARCHAR2
216     , x_msg_count out nocopy  NUMBER
217     , x_msg_data out nocopy  VARCHAR2
218     , p5_a0  NUMBER := 0-1962.0724
219     , p5_a1  NUMBER := 0-1962.0724
220     , p5_a2  NUMBER := 0-1962.0724
221     , p5_a3  NUMBER := 0-1962.0724
222     , p5_a4  NUMBER := 0-1962.0724
223     , p5_a5  NUMBER := 0-1962.0724
224     , p5_a6  NUMBER := 0-1962.0724
225     , p5_a7  DATE := fnd_api.g_miss_date
226     , p5_a8  NUMBER := 0-1962.0724
227     , p5_a9  DATE := fnd_api.g_miss_date
228     , p5_a10  NUMBER := 0-1962.0724
229     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
230   );
231   procedure delete_row(p_api_version  NUMBER
232     , p_init_msg_list  VARCHAR2
233     , x_return_status out nocopy  VARCHAR2
234     , x_msg_count out nocopy  NUMBER
235     , x_msg_data out nocopy  VARCHAR2
236     , p5_a0 JTF_NUMBER_TABLE
237     , p5_a1 JTF_NUMBER_TABLE
238     , p5_a2 JTF_NUMBER_TABLE
239     , p5_a3 JTF_NUMBER_TABLE
240     , p5_a4 JTF_NUMBER_TABLE
241     , p5_a5 JTF_NUMBER_TABLE
242     , p5_a6 JTF_NUMBER_TABLE
243     , p5_a7 JTF_DATE_TABLE
244     , p5_a8 JTF_NUMBER_TABLE
245     , p5_a9 JTF_DATE_TABLE
246     , p5_a10 JTF_NUMBER_TABLE
247     , p5_a11 JTF_VARCHAR2_TABLE_200
248   );
249   procedure validate_row(p_api_version  NUMBER
250     , p_init_msg_list  VARCHAR2
251     , x_return_status out nocopy  VARCHAR2
252     , x_msg_count out nocopy  NUMBER
253     , x_msg_data out nocopy  VARCHAR2
254     , p5_a0  NUMBER := 0-1962.0724
255     , p5_a1  NUMBER := 0-1962.0724
256     , p5_a2  NUMBER := 0-1962.0724
257     , p5_a3  NUMBER := 0-1962.0724
258     , p5_a4  NUMBER := 0-1962.0724
259     , p5_a5  NUMBER := 0-1962.0724
260     , p5_a6  NUMBER := 0-1962.0724
261     , p5_a7  DATE := fnd_api.g_miss_date
262     , p5_a8  NUMBER := 0-1962.0724
263     , p5_a9  DATE := fnd_api.g_miss_date
264     , p5_a10  NUMBER := 0-1962.0724
265     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
266   );
267   procedure validate_row(p_api_version  NUMBER
268     , p_init_msg_list  VARCHAR2
269     , x_return_status out nocopy  VARCHAR2
270     , x_msg_count out nocopy  NUMBER
271     , x_msg_data out nocopy  VARCHAR2
272     , p5_a0 JTF_NUMBER_TABLE
273     , p5_a1 JTF_NUMBER_TABLE
274     , p5_a2 JTF_NUMBER_TABLE
275     , p5_a3 JTF_NUMBER_TABLE
276     , p5_a4 JTF_NUMBER_TABLE
277     , p5_a5 JTF_NUMBER_TABLE
278     , p5_a6 JTF_NUMBER_TABLE
279     , p5_a7 JTF_DATE_TABLE
280     , p5_a8 JTF_NUMBER_TABLE
281     , p5_a9 JTF_DATE_TABLE
282     , p5_a10 JTF_NUMBER_TABLE
283     , p5_a11 JTF_VARCHAR2_TABLE_200
284   );
285 end okl_sit_pvt_w;