[Home] [Help]
PACKAGE: APPS.OKL_AM_AMORTIZE_PVT_W
Source
1 package okl_am_amortize_pvt_w as
2 /* $Header: OKLETATS.pls 120.6 2007/11/08 06:02:48 veramach ship $ */
3 procedure create_offlease_asset_trx(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 , p_kle_id NUMBER
9 , p_early_termination_yn VARCHAR2
10 , p_quote_eff_date date
11 , p_quote_accpt_date date
12 );
13 procedure create_offlease_asset_trx(p_api_version NUMBER
14 , p_init_msg_list VARCHAR2
15 , x_return_status out nocopy VARCHAR2
16 , x_msg_count out nocopy NUMBER
17 , x_msg_data out nocopy VARCHAR2
18 , p_contract_id NUMBER
19 , p_early_termination_yn VARCHAR2
20 , p_quote_eff_date date
21 , p_quote_accpt_date date
22 );
23 procedure update_offlease_asset_trx(p_api_version NUMBER
24 , p_init_msg_list VARCHAR2
25 , x_return_status out nocopy VARCHAR2
26 , x_msg_count out nocopy NUMBER
27 , x_msg_data out nocopy VARCHAR2
28 , p5_a0 NUMBER := 0-1962.0724
29 , p5_a1 NUMBER := 0-1962.0724
30 , p5_a2 NUMBER := 0-1962.0724
31 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
32 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
35 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
36 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
37 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
39 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
41 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
42 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
43 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
44 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
45 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
46 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
47 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
48 , p5_a20 NUMBER := 0-1962.0724
49 , p5_a21 DATE := fnd_api.g_miss_date
50 , p5_a22 NUMBER := 0-1962.0724
51 , p5_a23 DATE := fnd_api.g_miss_date
52 , p5_a24 NUMBER := 0-1962.0724
53 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
54 , p5_a26 NUMBER := 0-1962.0724
55 , p5_a27 DATE := fnd_api.g_miss_date
56 , p5_a28 NUMBER := 0-1962.0724
57 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
58 , p5_a30 NUMBER := 0-1962.0724
59 , p5_a31 NUMBER := 0-1962.0724
60 , p5_a32 NUMBER := 0-1962.0724
61 , p5_a33 NUMBER := 0-1962.0724
62 , p5_a34 DATE := fnd_api.g_miss_date
63 , p6_a0 NUMBER := 0-1962.0724
64 , p6_a1 NUMBER := 0-1962.0724
65 , p6_a2 VARCHAR2 := fnd_api.g_miss_char
66 , p6_a3 NUMBER := 0-1962.0724
67 , p6_a4 NUMBER := 0-1962.0724
68 , p6_a5 NUMBER := 0-1962.0724
69 , p6_a6 NUMBER := 0-1962.0724
70 , p6_a7 NUMBER := 0-1962.0724
71 , p6_a8 NUMBER := 0-1962.0724
72 , p6_a9 NUMBER := 0-1962.0724
73 , p6_a10 NUMBER := 0-1962.0724
74 , p6_a11 NUMBER := 0-1962.0724
75 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
76 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
77 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
78 , p6_a15 NUMBER := 0-1962.0724
79 , p6_a16 NUMBER := 0-1962.0724
80 , p6_a17 NUMBER := 0-1962.0724
81 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
82 , p6_a19 NUMBER := 0-1962.0724
83 , p6_a20 NUMBER := 0-1962.0724
84 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
85 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
86 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
87 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
88 , p6_a25 DATE := fnd_api.g_miss_date
89 , p6_a26 DATE := fnd_api.g_miss_date
90 , p6_a27 DATE := fnd_api.g_miss_date
91 , p6_a28 NUMBER := 0-1962.0724
92 , p6_a29 NUMBER := 0-1962.0724
93 , p6_a30 NUMBER := 0-1962.0724
94 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
95 , p6_a32 NUMBER := 0-1962.0724
96 , p6_a33 NUMBER := 0-1962.0724
97 , p6_a34 NUMBER := 0-1962.0724
98 , p6_a35 NUMBER := 0-1962.0724
99 , p6_a36 DATE := fnd_api.g_miss_date
100 , p6_a37 NUMBER := 0-1962.0724
101 , p6_a38 VARCHAR2 := fnd_api.g_miss_char
102 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
103 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
104 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
105 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
106 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
107 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
108 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
109 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
110 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
111 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
112 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
113 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
114 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
115 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
116 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
117 , p6_a54 NUMBER := 0-1962.0724
118 , p6_a55 DATE := fnd_api.g_miss_date
119 , p6_a56 NUMBER := 0-1962.0724
120 , p6_a57 DATE := fnd_api.g_miss_date
121 , p6_a58 NUMBER := 0-1962.0724
122 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
123 , p6_a60 NUMBER := 0-1962.0724
124 , p6_a61 NUMBER := 0-1962.0724
125 , p6_a62 NUMBER := 0-1962.0724
126 , p6_a63 NUMBER := 0-1962.0724
127 , p6_a64 NUMBER := 0-1962.0724
128 , p6_a65 NUMBER := 0-1962.0724
129 , p6_a66 NUMBER := 0-1962.0724
130 , p6_a67 NUMBER := 0-1962.0724
131 , p6_a68 NUMBER := 0-1962.0724
132 , p6_a69 DATE := fnd_api.g_miss_date
133 , p6_a70 NUMBER := 0-1962.0724
134 , p6_a71 NUMBER := 0-1962.0724
135 , p6_a72 NUMBER := 0-1962.0724
136 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
137 , p6_a74 NUMBER := 0-1962.0724
138 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
139 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
140 , p6_a77 NUMBER := 0-1962.0724
141 , p6_a78 DATE := fnd_api.g_miss_date
142 , p6_a79 NUMBER := 0-1962.0724
143 , p6_a80 NUMBER := 0-1962.0724
144 , p6_a81 NUMBER := 0-1962.0724
145 );
146 procedure update_offlease_asset_trx(p_api_version NUMBER
147 , p_init_msg_list VARCHAR2
148 , x_return_status out nocopy VARCHAR2
149 , x_msg_count out nocopy NUMBER
150 , x_msg_data out nocopy VARCHAR2
151 , p5_a0 JTF_NUMBER_TABLE
152 , p5_a1 JTF_NUMBER_TABLE
153 , p5_a2 JTF_NUMBER_TABLE
154 , p5_a3 JTF_VARCHAR2_TABLE_100
155 , p5_a4 JTF_VARCHAR2_TABLE_500
156 , p5_a5 JTF_VARCHAR2_TABLE_500
157 , p5_a6 JTF_VARCHAR2_TABLE_500
158 , p5_a7 JTF_VARCHAR2_TABLE_500
159 , p5_a8 JTF_VARCHAR2_TABLE_500
160 , p5_a9 JTF_VARCHAR2_TABLE_500
161 , p5_a10 JTF_VARCHAR2_TABLE_500
162 , p5_a11 JTF_VARCHAR2_TABLE_500
163 , p5_a12 JTF_VARCHAR2_TABLE_500
164 , p5_a13 JTF_VARCHAR2_TABLE_500
165 , p5_a14 JTF_VARCHAR2_TABLE_500
166 , p5_a15 JTF_VARCHAR2_TABLE_500
167 , p5_a16 JTF_VARCHAR2_TABLE_500
168 , p5_a17 JTF_VARCHAR2_TABLE_500
169 , p5_a18 JTF_VARCHAR2_TABLE_500
170 , p5_a19 JTF_VARCHAR2_TABLE_100
171 , p5_a20 JTF_NUMBER_TABLE
172 , p5_a21 JTF_DATE_TABLE
173 , p5_a22 JTF_NUMBER_TABLE
174 , p5_a23 JTF_DATE_TABLE
175 , p5_a24 JTF_NUMBER_TABLE
176 , p5_a25 JTF_VARCHAR2_TABLE_100
177 , p5_a26 JTF_NUMBER_TABLE
178 , p5_a27 JTF_DATE_TABLE
179 , p5_a28 JTF_NUMBER_TABLE
180 , p5_a29 JTF_VARCHAR2_TABLE_4000
181 , p5_a30 JTF_NUMBER_TABLE
182 , p5_a31 JTF_NUMBER_TABLE
183 , p5_a32 JTF_NUMBER_TABLE
184 , p5_a33 JTF_NUMBER_TABLE
185 , p5_a34 JTF_DATE_TABLE
186 , p6_a0 JTF_NUMBER_TABLE
187 , p6_a1 JTF_NUMBER_TABLE
188 , p6_a2 JTF_VARCHAR2_TABLE_100
189 , p6_a3 JTF_NUMBER_TABLE
190 , p6_a4 JTF_NUMBER_TABLE
191 , p6_a5 JTF_NUMBER_TABLE
192 , p6_a6 JTF_NUMBER_TABLE
193 , p6_a7 JTF_NUMBER_TABLE
194 , p6_a8 JTF_NUMBER_TABLE
195 , p6_a9 JTF_NUMBER_TABLE
196 , p6_a10 JTF_NUMBER_TABLE
197 , p6_a11 JTF_NUMBER_TABLE
198 , p6_a12 JTF_VARCHAR2_TABLE_100
199 , p6_a13 JTF_VARCHAR2_TABLE_100
200 , p6_a14 JTF_VARCHAR2_TABLE_2000
201 , p6_a15 JTF_NUMBER_TABLE
202 , p6_a16 JTF_NUMBER_TABLE
203 , p6_a17 JTF_NUMBER_TABLE
204 , p6_a18 JTF_VARCHAR2_TABLE_100
205 , p6_a19 JTF_NUMBER_TABLE
206 , p6_a20 JTF_NUMBER_TABLE
207 , p6_a21 JTF_VARCHAR2_TABLE_100
208 , p6_a22 JTF_VARCHAR2_TABLE_100
209 , p6_a23 JTF_VARCHAR2_TABLE_100
210 , p6_a24 JTF_VARCHAR2_TABLE_100
211 , p6_a25 JTF_DATE_TABLE
212 , p6_a26 JTF_DATE_TABLE
213 , p6_a27 JTF_DATE_TABLE
214 , p6_a28 JTF_NUMBER_TABLE
215 , p6_a29 JTF_NUMBER_TABLE
216 , p6_a30 JTF_NUMBER_TABLE
217 , p6_a31 JTF_VARCHAR2_TABLE_100
218 , p6_a32 JTF_NUMBER_TABLE
219 , p6_a33 JTF_NUMBER_TABLE
220 , p6_a34 JTF_NUMBER_TABLE
221 , p6_a35 JTF_NUMBER_TABLE
222 , p6_a36 JTF_DATE_TABLE
223 , p6_a37 JTF_NUMBER_TABLE
224 , p6_a38 JTF_VARCHAR2_TABLE_100
225 , p6_a39 JTF_VARCHAR2_TABLE_500
226 , p6_a40 JTF_VARCHAR2_TABLE_500
227 , p6_a41 JTF_VARCHAR2_TABLE_500
228 , p6_a42 JTF_VARCHAR2_TABLE_500
229 , p6_a43 JTF_VARCHAR2_TABLE_500
230 , p6_a44 JTF_VARCHAR2_TABLE_500
231 , p6_a45 JTF_VARCHAR2_TABLE_500
232 , p6_a46 JTF_VARCHAR2_TABLE_500
233 , p6_a47 JTF_VARCHAR2_TABLE_500
234 , p6_a48 JTF_VARCHAR2_TABLE_500
235 , p6_a49 JTF_VARCHAR2_TABLE_500
236 , p6_a50 JTF_VARCHAR2_TABLE_500
237 , p6_a51 JTF_VARCHAR2_TABLE_500
238 , p6_a52 JTF_VARCHAR2_TABLE_500
239 , p6_a53 JTF_VARCHAR2_TABLE_500
240 , p6_a54 JTF_NUMBER_TABLE
241 , p6_a55 JTF_DATE_TABLE
242 , p6_a56 JTF_NUMBER_TABLE
243 , p6_a57 JTF_DATE_TABLE
244 , p6_a58 JTF_NUMBER_TABLE
245 , p6_a59 JTF_VARCHAR2_TABLE_100
246 , p6_a60 JTF_NUMBER_TABLE
247 , p6_a61 JTF_NUMBER_TABLE
248 , p6_a62 JTF_NUMBER_TABLE
249 , p6_a63 JTF_NUMBER_TABLE
250 , p6_a64 JTF_NUMBER_TABLE
251 , p6_a65 JTF_NUMBER_TABLE
252 , p6_a66 JTF_NUMBER_TABLE
253 , p6_a67 JTF_NUMBER_TABLE
254 , p6_a68 JTF_NUMBER_TABLE
255 , p6_a69 JTF_DATE_TABLE
256 , p6_a70 JTF_NUMBER_TABLE
257 , p6_a71 JTF_NUMBER_TABLE
258 , p6_a72 JTF_NUMBER_TABLE
259 , p6_a73 JTF_VARCHAR2_TABLE_100
260 , p6_a74 JTF_NUMBER_TABLE
261 , p6_a75 JTF_VARCHAR2_TABLE_100
262 , p6_a76 JTF_VARCHAR2_TABLE_100
263 , p6_a77 JTF_NUMBER_TABLE
264 , p6_a78 JTF_DATE_TABLE
265 , p6_a79 JTF_NUMBER_TABLE
266 , p6_a80 JTF_NUMBER_TABLE
267 , p6_a81 JTF_NUMBER_TABLE
268 , x_record_status out nocopy VARCHAR2
269 );
270 procedure update_depreciation(p_api_version NUMBER
271 , p_init_msg_list VARCHAR2
272 , x_return_status out nocopy VARCHAR2
273 , x_msg_count out nocopy NUMBER
274 , x_msg_data out nocopy VARCHAR2
275 , p5_a0 NUMBER := 0-1962.0724
276 , p5_a1 NUMBER := 0-1962.0724
277 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a3 NUMBER := 0-1962.0724
279 , p5_a4 NUMBER := 0-1962.0724
280 , p5_a5 DATE := fnd_api.g_miss_date
281 , p5_a6 NUMBER := 0-1962.0724
282 );
283 end okl_am_amortize_pvt_w;