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_ADJ_NEW_LINE_PVT_W

Source


1 package ozf_adj_new_line_pvt_w as
2   /* $Header: ozfwanls.pls 120.0 2006/03/30 13:55:44 rssharma noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ozf_adj_new_line_pvt.adj_new_line_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_NUMBER_TABLE
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_DATE_TABLE
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_DATE_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_DATE_TABLE
21     , a18 JTF_NUMBER_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_NUMBER_TABLE
24     );
25   procedure rosetta_table_copy_out_p3(t ozf_adj_new_line_pvt.adj_new_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
26     , a1 out nocopy JTF_NUMBER_TABLE
27     , a2 out nocopy JTF_NUMBER_TABLE
28     , a3 out nocopy JTF_NUMBER_TABLE
29     , a4 out nocopy JTF_VARCHAR2_TABLE_100
30     , a5 out nocopy JTF_NUMBER_TABLE
31     , a6 out nocopy JTF_VARCHAR2_TABLE_100
32     , a7 out nocopy JTF_VARCHAR2_TABLE_100
33     , a8 out nocopy JTF_NUMBER_TABLE
34     , a9 out nocopy JTF_VARCHAR2_TABLE_100
35     , a10 out nocopy JTF_NUMBER_TABLE
36     , a11 out nocopy JTF_NUMBER_TABLE
37     , a12 out nocopy JTF_NUMBER_TABLE
38     , a13 out nocopy JTF_DATE_TABLE
39     , a14 out nocopy JTF_DATE_TABLE
40     , a15 out nocopy JTF_DATE_TABLE
41     , a16 out nocopy JTF_NUMBER_TABLE
42     , a17 out nocopy JTF_DATE_TABLE
43     , a18 out nocopy JTF_NUMBER_TABLE
44     , a19 out nocopy JTF_NUMBER_TABLE
45     , a20 out nocopy JTF_NUMBER_TABLE
46     );
47 
48   procedure rosetta_table_copy_in_p7(t out nocopy ozf_adj_new_line_pvt.adj_new_disc_tbl_type, a0 JTF_NUMBER_TABLE
49     , a1 JTF_NUMBER_TABLE
50     , a2 JTF_NUMBER_TABLE
51     , a3 JTF_NUMBER_TABLE
52     , a4 JTF_VARCHAR2_TABLE_100
53     , a5 JTF_NUMBER_TABLE
54     , a6 JTF_VARCHAR2_TABLE_100
55     , a7 JTF_VARCHAR2_TABLE_100
56     , a8 JTF_NUMBER_TABLE
57     , a9 JTF_VARCHAR2_TABLE_100
58     , a10 JTF_NUMBER_TABLE
59     , a11 JTF_NUMBER_TABLE
60     , a12 JTF_NUMBER_TABLE
61     , a13 JTF_NUMBER_TABLE
62     , a14 JTF_VARCHAR2_TABLE_100
63     , a15 JTF_VARCHAR2_TABLE_100
64     , a16 JTF_VARCHAR2_TABLE_300
65     , a17 JTF_VARCHAR2_TABLE_100
66     , a18 JTF_VARCHAR2_TABLE_100
67     , a19 JTF_DATE_TABLE
68     , a20 JTF_DATE_TABLE
69     , a21 JTF_DATE_TABLE
70     , a22 JTF_NUMBER_TABLE
71     , a23 JTF_DATE_TABLE
72     , a24 JTF_NUMBER_TABLE
73     , a25 JTF_NUMBER_TABLE
74     , a26 JTF_NUMBER_TABLE
75     , a27 JTF_NUMBER_TABLE
76     );
77   procedure rosetta_table_copy_out_p7(t ozf_adj_new_line_pvt.adj_new_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78     , a1 out nocopy JTF_NUMBER_TABLE
79     , a2 out nocopy JTF_NUMBER_TABLE
80     , a3 out nocopy JTF_NUMBER_TABLE
81     , a4 out nocopy JTF_VARCHAR2_TABLE_100
82     , a5 out nocopy JTF_NUMBER_TABLE
83     , a6 out nocopy JTF_VARCHAR2_TABLE_100
84     , a7 out nocopy JTF_VARCHAR2_TABLE_100
85     , a8 out nocopy JTF_NUMBER_TABLE
86     , a9 out nocopy JTF_VARCHAR2_TABLE_100
87     , a10 out nocopy JTF_NUMBER_TABLE
88     , a11 out nocopy JTF_NUMBER_TABLE
89     , a12 out nocopy JTF_NUMBER_TABLE
90     , a13 out nocopy JTF_NUMBER_TABLE
91     , a14 out nocopy JTF_VARCHAR2_TABLE_100
92     , a15 out nocopy JTF_VARCHAR2_TABLE_100
93     , a16 out nocopy JTF_VARCHAR2_TABLE_300
94     , a17 out nocopy JTF_VARCHAR2_TABLE_100
95     , a18 out nocopy JTF_VARCHAR2_TABLE_100
96     , a19 out nocopy JTF_DATE_TABLE
97     , a20 out nocopy JTF_DATE_TABLE
98     , a21 out nocopy JTF_DATE_TABLE
99     , a22 out nocopy JTF_NUMBER_TABLE
100     , a23 out nocopy JTF_DATE_TABLE
101     , a24 out nocopy JTF_NUMBER_TABLE
102     , a25 out nocopy JTF_NUMBER_TABLE
103     , a26 out nocopy JTF_NUMBER_TABLE
104     , a27 out nocopy JTF_NUMBER_TABLE
105     );
106 
107   procedure create_adj_new_line(p_api_version_number  NUMBER
108     , p_init_msg_list  VARCHAR2
109     , p_commit  VARCHAR2
110     , p_validation_level  NUMBER
111     , x_return_status out nocopy  VARCHAR2
112     , x_msg_count out nocopy  NUMBER
113     , x_msg_data out nocopy  VARCHAR2
114     , p7_a0  NUMBER := 0-1962.0724
115     , p7_a1  NUMBER := 0-1962.0724
116     , p7_a2  NUMBER := 0-1962.0724
117     , p7_a3  NUMBER := 0-1962.0724
118     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
119     , p7_a5  NUMBER := 0-1962.0724
120     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
121     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
122     , p7_a8  NUMBER := 0-1962.0724
123     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
124     , p7_a10  NUMBER := 0-1962.0724
125     , p7_a11  NUMBER := 0-1962.0724
126     , p7_a12  NUMBER := 0-1962.0724
127     , p7_a13  DATE := fnd_api.g_miss_date
128     , p7_a14  DATE := fnd_api.g_miss_date
129     , p7_a15  DATE := fnd_api.g_miss_date
130     , p7_a16  NUMBER := 0-1962.0724
131     , p7_a17  DATE := fnd_api.g_miss_date
132     , p7_a18  NUMBER := 0-1962.0724
133     , p7_a19  NUMBER := 0-1962.0724
134     , p7_a20  NUMBER := 0-1962.0724
135     , x_offer_adj_new_line_id out nocopy  NUMBER
136   );
137   procedure update_adj_new_line(p_api_version_number  NUMBER
138     , p_init_msg_list  VARCHAR2
139     , p_commit  VARCHAR2
140     , p_validation_level  NUMBER
141     , x_return_status out nocopy  VARCHAR2
142     , x_msg_count out nocopy  NUMBER
143     , x_msg_data out nocopy  VARCHAR2
144     , p7_a0  NUMBER := 0-1962.0724
145     , p7_a1  NUMBER := 0-1962.0724
146     , p7_a2  NUMBER := 0-1962.0724
147     , p7_a3  NUMBER := 0-1962.0724
148     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
149     , p7_a5  NUMBER := 0-1962.0724
150     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
151     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
152     , p7_a8  NUMBER := 0-1962.0724
153     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
154     , p7_a10  NUMBER := 0-1962.0724
155     , p7_a11  NUMBER := 0-1962.0724
156     , p7_a12  NUMBER := 0-1962.0724
157     , p7_a13  DATE := fnd_api.g_miss_date
158     , p7_a14  DATE := fnd_api.g_miss_date
159     , p7_a15  DATE := fnd_api.g_miss_date
160     , p7_a16  NUMBER := 0-1962.0724
161     , p7_a17  DATE := fnd_api.g_miss_date
162     , p7_a18  NUMBER := 0-1962.0724
163     , p7_a19  NUMBER := 0-1962.0724
164     , p7_a20  NUMBER := 0-1962.0724
165     , x_object_version_number out nocopy  NUMBER
166   );
167   procedure validate_adj_new_line(p_api_version_number  NUMBER
168     , p_init_msg_list  VARCHAR2
169     , p_validation_level  NUMBER
170     , p_validation_mode  VARCHAR2
171     , x_return_status out nocopy  VARCHAR2
172     , x_msg_count out nocopy  NUMBER
173     , x_msg_data out nocopy  VARCHAR2
174     , p4_a0  NUMBER := 0-1962.0724
175     , p4_a1  NUMBER := 0-1962.0724
176     , p4_a2  NUMBER := 0-1962.0724
177     , p4_a3  NUMBER := 0-1962.0724
178     , p4_a4  VARCHAR2 := fnd_api.g_miss_char
179     , p4_a5  NUMBER := 0-1962.0724
180     , p4_a6  VARCHAR2 := fnd_api.g_miss_char
181     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
182     , p4_a8  NUMBER := 0-1962.0724
183     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
184     , p4_a10  NUMBER := 0-1962.0724
185     , p4_a11  NUMBER := 0-1962.0724
186     , p4_a12  NUMBER := 0-1962.0724
187     , p4_a13  DATE := fnd_api.g_miss_date
188     , p4_a14  DATE := fnd_api.g_miss_date
189     , p4_a15  DATE := fnd_api.g_miss_date
190     , p4_a16  NUMBER := 0-1962.0724
191     , p4_a17  DATE := fnd_api.g_miss_date
192     , p4_a18  NUMBER := 0-1962.0724
193     , p4_a19  NUMBER := 0-1962.0724
194     , p4_a20  NUMBER := 0-1962.0724
195   );
196   procedure check_adj_new_line_items(p_validation_mode  VARCHAR2
197     , x_return_status out nocopy  VARCHAR2
198     , p0_a0  NUMBER := 0-1962.0724
199     , p0_a1  NUMBER := 0-1962.0724
200     , p0_a2  NUMBER := 0-1962.0724
201     , p0_a3  NUMBER := 0-1962.0724
202     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
203     , p0_a5  NUMBER := 0-1962.0724
204     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
205     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
206     , p0_a8  NUMBER := 0-1962.0724
207     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
208     , p0_a10  NUMBER := 0-1962.0724
209     , p0_a11  NUMBER := 0-1962.0724
210     , p0_a12  NUMBER := 0-1962.0724
211     , p0_a13  DATE := fnd_api.g_miss_date
212     , p0_a14  DATE := fnd_api.g_miss_date
213     , p0_a15  DATE := fnd_api.g_miss_date
214     , p0_a16  NUMBER := 0-1962.0724
215     , p0_a17  DATE := fnd_api.g_miss_date
216     , p0_a18  NUMBER := 0-1962.0724
217     , p0_a19  NUMBER := 0-1962.0724
218     , p0_a20  NUMBER := 0-1962.0724
219   );
220   procedure validate_adj_new_line_rec(p_api_version_number  NUMBER
221     , p_init_msg_list  VARCHAR2
222     , x_return_status out nocopy  VARCHAR2
223     , x_msg_count out nocopy  NUMBER
224     , x_msg_data out nocopy  VARCHAR2
225     , p5_a0  NUMBER := 0-1962.0724
226     , p5_a1  NUMBER := 0-1962.0724
227     , p5_a2  NUMBER := 0-1962.0724
228     , p5_a3  NUMBER := 0-1962.0724
229     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a5  NUMBER := 0-1962.0724
231     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a8  NUMBER := 0-1962.0724
234     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a10  NUMBER := 0-1962.0724
236     , p5_a11  NUMBER := 0-1962.0724
237     , p5_a12  NUMBER := 0-1962.0724
238     , p5_a13  DATE := fnd_api.g_miss_date
239     , p5_a14  DATE := fnd_api.g_miss_date
240     , p5_a15  DATE := fnd_api.g_miss_date
241     , p5_a16  NUMBER := 0-1962.0724
242     , p5_a17  DATE := fnd_api.g_miss_date
243     , p5_a18  NUMBER := 0-1962.0724
244     , p5_a19  NUMBER := 0-1962.0724
245     , p5_a20  NUMBER := 0-1962.0724
246   );
247   procedure create_adj_new_disc(p_api_version_number  NUMBER
248     , p_init_msg_list  VARCHAR2
249     , p_commit  VARCHAR2
250     , p_validation_level  NUMBER
251     , x_return_status out nocopy  VARCHAR2
252     , x_msg_count out nocopy  NUMBER
253     , x_msg_data out nocopy  VARCHAR2
254     , p7_a0  NUMBER := 0-1962.0724
255     , p7_a1  NUMBER := 0-1962.0724
256     , p7_a2  NUMBER := 0-1962.0724
257     , p7_a3  NUMBER := 0-1962.0724
258     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
259     , p7_a5  NUMBER := 0-1962.0724
260     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
261     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
262     , p7_a8  NUMBER := 0-1962.0724
263     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
264     , p7_a10  NUMBER := 0-1962.0724
265     , p7_a11  NUMBER := 0-1962.0724
266     , p7_a12  NUMBER := 0-1962.0724
267     , p7_a13  NUMBER := 0-1962.0724
268     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
269     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
270     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
271     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
272     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
273     , p7_a19  DATE := fnd_api.g_miss_date
274     , p7_a20  DATE := fnd_api.g_miss_date
275     , p7_a21  DATE := fnd_api.g_miss_date
276     , p7_a22  NUMBER := 0-1962.0724
277     , p7_a23  DATE := fnd_api.g_miss_date
278     , p7_a24  NUMBER := 0-1962.0724
279     , p7_a25  NUMBER := 0-1962.0724
280     , p7_a26  NUMBER := 0-1962.0724
281     , p7_a27  NUMBER := 0-1962.0724
282     , x_offer_adj_new_line_id out nocopy  NUMBER
283   );
284   procedure update_adj_new_disc(p_api_version_number  NUMBER
285     , p_init_msg_list  VARCHAR2
286     , p_commit  VARCHAR2
287     , p_validation_level  NUMBER
288     , x_return_status out nocopy  VARCHAR2
289     , x_msg_count out nocopy  NUMBER
290     , x_msg_data out nocopy  VARCHAR2
291     , p7_a0  NUMBER := 0-1962.0724
292     , p7_a1  NUMBER := 0-1962.0724
293     , p7_a2  NUMBER := 0-1962.0724
294     , p7_a3  NUMBER := 0-1962.0724
295     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
296     , p7_a5  NUMBER := 0-1962.0724
297     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
298     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
299     , p7_a8  NUMBER := 0-1962.0724
300     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
301     , p7_a10  NUMBER := 0-1962.0724
302     , p7_a11  NUMBER := 0-1962.0724
303     , p7_a12  NUMBER := 0-1962.0724
304     , p7_a13  NUMBER := 0-1962.0724
305     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
306     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
307     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
308     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
309     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
310     , p7_a19  DATE := fnd_api.g_miss_date
311     , p7_a20  DATE := fnd_api.g_miss_date
312     , p7_a21  DATE := fnd_api.g_miss_date
313     , p7_a22  NUMBER := 0-1962.0724
314     , p7_a23  DATE := fnd_api.g_miss_date
315     , p7_a24  NUMBER := 0-1962.0724
316     , p7_a25  NUMBER := 0-1962.0724
317     , p7_a26  NUMBER := 0-1962.0724
318     , p7_a27  NUMBER := 0-1962.0724
319     , x_object_version_number out nocopy  NUMBER
320   );
321 end ozf_adj_new_line_pvt_w;