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_AM_CREATE_QUOTE_PUB_W

Source


1 package okl_am_create_quote_pub_w as
2   /* $Header: OKLUCQTS.pls 120.4 2007/11/02 21:04:08 rmunjulu ship $ */
3   procedure advance_contract_search(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200
9     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
10     , p6_a2 out nocopy JTF_NUMBER_TABLE
11     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
12     , p6_a4 out nocopy JTF_DATE_TABLE
13     , p6_a5 out nocopy JTF_DATE_TABLE
14     , p6_a6 out nocopy JTF_DATE_TABLE
15     , p6_a7 out nocopy JTF_DATE_TABLE
16     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
17     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
18     , p6_a10 out nocopy JTF_NUMBER_TABLE
19     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
20     , p5_a0  VARCHAR2 := fnd_api.g_miss_char
21     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
22     , p5_a2  NUMBER := 0-1962.0724
23     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
24     , p5_a4  DATE := fnd_api.g_miss_date
25     , p5_a5  DATE := fnd_api.g_miss_date
26     , p5_a6  DATE := fnd_api.g_miss_date
27     , p5_a7  DATE := fnd_api.g_miss_date
28     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
29     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
30     , p5_a10  NUMBER := 0-1962.0724
31     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
32   );
33   procedure create_terminate_quote(p_api_version  NUMBER
34     , p_init_msg_list  VARCHAR2
35     , x_return_status out nocopy  VARCHAR2
36     , x_msg_count out nocopy  NUMBER
37     , x_msg_data out nocopy  VARCHAR2
38     , p6_a0 JTF_NUMBER_TABLE
39     , p6_a1 JTF_VARCHAR2_TABLE_200
40     , p6_a2 JTF_NUMBER_TABLE
41     , p6_a3 JTF_NUMBER_TABLE
42     , p6_a4 JTF_VARCHAR2_TABLE_200
43     , p7_a0 JTF_NUMBER_TABLE
44     , p7_a1 JTF_NUMBER_TABLE
45     , p7_a2 JTF_NUMBER_TABLE
46     , p7_a3 JTF_NUMBER_TABLE
47     , p7_a4 JTF_DATE_TABLE
48     , p7_a5 JTF_VARCHAR2_TABLE_100
49     , p7_a6 JTF_NUMBER_TABLE
50     , p7_a7 JTF_NUMBER_TABLE
51     , p7_a8 JTF_VARCHAR2_TABLE_600
52     , p7_a9 JTF_VARCHAR2_TABLE_100
53     , p7_a10 JTF_VARCHAR2_TABLE_100
54     , p7_a11 JTF_VARCHAR2_TABLE_200
55     , p7_a12 JTF_VARCHAR2_TABLE_100
56     , p7_a13 JTF_VARCHAR2_TABLE_100
57     , p7_a14 JTF_VARCHAR2_TABLE_200
58     , p7_a15 JTF_NUMBER_TABLE
59     , p7_a16 JTF_DATE_TABLE
60     , p7_a17 JTF_NUMBER_TABLE
61     , p7_a18 JTF_DATE_TABLE
62     , p7_a19 JTF_NUMBER_TABLE
63     , p8_a0 out nocopy  NUMBER
64     , p8_a1 out nocopy  NUMBER
65     , p8_a2 out nocopy  VARCHAR2
66     , p8_a3 out nocopy  VARCHAR2
67     , p8_a4 out nocopy  VARCHAR2
68     , p8_a5 out nocopy  VARCHAR2
69     , p8_a6 out nocopy  VARCHAR2
70     , p8_a7 out nocopy  VARCHAR2
71     , p8_a8 out nocopy  VARCHAR2
72     , p8_a9 out nocopy  NUMBER
73     , p8_a10 out nocopy  NUMBER
74     , p8_a11 out nocopy  NUMBER
75     , p8_a12 out nocopy  NUMBER
76     , p8_a13 out nocopy  VARCHAR2
77     , p8_a14 out nocopy  VARCHAR2
78     , p8_a15 out nocopy  VARCHAR2
79     , p8_a16 out nocopy  DATE
80     , p8_a17 out nocopy  DATE
81     , p8_a18 out nocopy  DATE
82     , p8_a19 out nocopy  DATE
83     , p8_a20 out nocopy  VARCHAR2
84     , p8_a21 out nocopy  VARCHAR2
85     , p8_a22 out nocopy  NUMBER
86     , p8_a23 out nocopy  NUMBER
87     , p8_a24 out nocopy  NUMBER
88     , p8_a25 out nocopy  NUMBER
89     , p8_a26 out nocopy  DATE
90     , p8_a27 out nocopy  DATE
91     , p8_a28 out nocopy  NUMBER
92     , p8_a29 out nocopy  NUMBER
93     , p8_a30 out nocopy  VARCHAR2
94     , p8_a31 out nocopy  DATE
95     , p8_a32 out nocopy  VARCHAR2
96     , p8_a33 out nocopy  NUMBER
97     , p8_a34 out nocopy  DATE
98     , p8_a35 out nocopy  NUMBER
99     , p8_a36 out nocopy  NUMBER
100     , p8_a37 out nocopy  VARCHAR2
101     , p8_a38 out nocopy  VARCHAR2
102     , p8_a39 out nocopy  VARCHAR2
103     , p8_a40 out nocopy  DATE
104     , p8_a41 out nocopy  VARCHAR2
105     , p8_a42 out nocopy  VARCHAR2
106     , p8_a43 out nocopy  VARCHAR2
107     , p8_a44 out nocopy  VARCHAR2
108     , p8_a45 out nocopy  VARCHAR2
109     , p8_a46 out nocopy  VARCHAR2
110     , p8_a47 out nocopy  VARCHAR2
111     , p8_a48 out nocopy  VARCHAR2
112     , p8_a49 out nocopy  VARCHAR2
113     , p8_a50 out nocopy  VARCHAR2
114     , p8_a51 out nocopy  VARCHAR2
115     , p8_a52 out nocopy  VARCHAR2
116     , p8_a53 out nocopy  VARCHAR2
117     , p8_a54 out nocopy  VARCHAR2
118     , p8_a55 out nocopy  VARCHAR2
119     , p8_a56 out nocopy  VARCHAR2
120     , p8_a57 out nocopy  DATE
121     , p8_a58 out nocopy  NUMBER
122     , p8_a59 out nocopy  NUMBER
123     , p8_a60 out nocopy  NUMBER
124     , p8_a61 out nocopy  NUMBER
125     , p8_a62 out nocopy  NUMBER
126     , p8_a63 out nocopy  DATE
127     , p8_a64 out nocopy  NUMBER
128     , p8_a65 out nocopy  DATE
129     , p8_a66 out nocopy  NUMBER
130     , p8_a67 out nocopy  DATE
131     , p8_a68 out nocopy  NUMBER
132     , p8_a69 out nocopy  NUMBER
133     , p8_a70 out nocopy  VARCHAR2
134     , p8_a71 out nocopy  NUMBER
135     , p8_a72 out nocopy  NUMBER
136     , p8_a73 out nocopy  NUMBER
137     , p8_a74 out nocopy  NUMBER
138     , p8_a75 out nocopy  NUMBER
139     , p8_a76 out nocopy  VARCHAR2
140     , p8_a77 out nocopy  VARCHAR2
141     , p8_a78 out nocopy  VARCHAR2
142     , p8_a79 out nocopy  NUMBER
143     , p8_a80 out nocopy  DATE
144     , p8_a81 out nocopy  NUMBER
145     , p8_a82 out nocopy  VARCHAR2
146     , p9_a0 out nocopy JTF_NUMBER_TABLE
147     , p9_a1 out nocopy JTF_NUMBER_TABLE
148     , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
149     , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
150     , p9_a4 out nocopy JTF_NUMBER_TABLE
151     , p9_a5 out nocopy JTF_NUMBER_TABLE
152     , p9_a6 out nocopy JTF_NUMBER_TABLE
153     , p9_a7 out nocopy JTF_NUMBER_TABLE
154     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
155     , p9_a9 out nocopy JTF_NUMBER_TABLE
156     , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
157     , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
158     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
159     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
160     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
161     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
162     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
163     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500
164     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
165     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
166     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
167     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
168     , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
169     , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
170     , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
171     , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
172     , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
173     , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
174     , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
175     , p9_a29 out nocopy JTF_NUMBER_TABLE
176     , p9_a30 out nocopy JTF_NUMBER_TABLE
177     , p9_a31 out nocopy JTF_NUMBER_TABLE
178     , p9_a32 out nocopy JTF_NUMBER_TABLE
179     , p9_a33 out nocopy JTF_DATE_TABLE
180     , p9_a34 out nocopy JTF_NUMBER_TABLE
181     , p9_a35 out nocopy JTF_DATE_TABLE
182     , p9_a36 out nocopy JTF_NUMBER_TABLE
183     , p9_a37 out nocopy JTF_DATE_TABLE
184     , p9_a38 out nocopy JTF_NUMBER_TABLE
185     , p9_a39 out nocopy JTF_DATE_TABLE
186     , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
187     , p9_a41 out nocopy JTF_NUMBER_TABLE
188     , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
189     , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
190     , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200
191     , p9_a45 out nocopy JTF_NUMBER_TABLE
192     , p9_a46 out nocopy JTF_NUMBER_TABLE
193     , p9_a47 out nocopy JTF_NUMBER_TABLE
194     , p9_a48 out nocopy JTF_NUMBER_TABLE
195     , p9_a49 out nocopy JTF_NUMBER_TABLE
196     , p9_a50 out nocopy JTF_NUMBER_TABLE
197     , p9_a51 out nocopy JTF_NUMBER_TABLE
198     , p9_a52 out nocopy JTF_NUMBER_TABLE
199     , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
200     , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
201     , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
202     , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
203     , p9_a57 out nocopy JTF_NUMBER_TABLE
204     , p9_a58 out nocopy JTF_DATE_TABLE
205     , p9_a59 out nocopy JTF_DATE_TABLE
206     , p9_a60 out nocopy JTF_NUMBER_TABLE
207     , p10_a0 out nocopy JTF_NUMBER_TABLE
208     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
209     , p10_a2 out nocopy JTF_NUMBER_TABLE
210     , p10_a3 out nocopy JTF_NUMBER_TABLE
211     , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
212     , p5_a0  NUMBER := 0-1962.0724
213     , p5_a1  NUMBER := 0-1962.0724
214     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
215     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
216     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
218     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
219     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
220     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a9  NUMBER := 0-1962.0724
222     , p5_a10  NUMBER := 0-1962.0724
223     , p5_a11  NUMBER := 0-1962.0724
224     , p5_a12  NUMBER := 0-1962.0724
225     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a16  DATE := fnd_api.g_miss_date
229     , p5_a17  DATE := fnd_api.g_miss_date
230     , p5_a18  DATE := fnd_api.g_miss_date
231     , p5_a19  DATE := fnd_api.g_miss_date
232     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a22  NUMBER := 0-1962.0724
235     , p5_a23  NUMBER := 0-1962.0724
236     , p5_a24  NUMBER := 0-1962.0724
237     , p5_a25  NUMBER := 0-1962.0724
238     , p5_a26  DATE := fnd_api.g_miss_date
239     , p5_a27  DATE := fnd_api.g_miss_date
240     , p5_a28  NUMBER := 0-1962.0724
241     , p5_a29  NUMBER := 0-1962.0724
242     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a31  DATE := fnd_api.g_miss_date
244     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
245     , p5_a33  NUMBER := 0-1962.0724
246     , p5_a34  DATE := fnd_api.g_miss_date
247     , p5_a35  NUMBER := 0-1962.0724
248     , p5_a36  NUMBER := 0-1962.0724
249     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
250     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
251     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
252     , p5_a40  DATE := fnd_api.g_miss_date
253     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
254     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
255     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
256     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
257     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
258     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
259     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
260     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
261     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
262     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
263     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
264     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
265     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
266     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
267     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
268     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
269     , p5_a57  DATE := fnd_api.g_miss_date
270     , p5_a58  NUMBER := 0-1962.0724
271     , p5_a59  NUMBER := 0-1962.0724
272     , p5_a60  NUMBER := 0-1962.0724
273     , p5_a61  NUMBER := 0-1962.0724
274     , p5_a62  NUMBER := 0-1962.0724
275     , p5_a63  DATE := fnd_api.g_miss_date
276     , p5_a64  NUMBER := 0-1962.0724
277     , p5_a65  DATE := fnd_api.g_miss_date
278     , p5_a66  NUMBER := 0-1962.0724
279     , p5_a67  DATE := fnd_api.g_miss_date
280     , p5_a68  NUMBER := 0-1962.0724
281     , p5_a69  NUMBER := 0-1962.0724
282     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
283     , p5_a71  NUMBER := 0-1962.0724
284     , p5_a72  NUMBER := 0-1962.0724
285     , p5_a73  NUMBER := 0-1962.0724
286     , p5_a74  NUMBER := 0-1962.0724
287     , p5_a75  NUMBER := 0-1962.0724
288     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
289     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
290     , p5_a78  VARCHAR2 := fnd_api.g_miss_char
291     , p5_a79  NUMBER := 0-1962.0724
292     , p5_a80  DATE := fnd_api.g_miss_date
293     , p5_a81  NUMBER := 0-1962.0724
294     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
295   );
296 end okl_am_create_quote_pub_w;