168: , p_init_msg_list VARCHAR2
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_NUMBER_TABLE
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_NUMBER_TABLE
177: , p5_a5 JTF_NUMBER_TABLE
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_NUMBER_TABLE
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_300
179: , p5_a7 JTF_VARCHAR2_TABLE_800
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_NUMBER_TABLE
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_300
179: , p5_a7 JTF_VARCHAR2_TABLE_800
180: , p5_a8 JTF_VARCHAR2_TABLE_100
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_NUMBER_TABLE
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_300
179: , p5_a7 JTF_VARCHAR2_TABLE_800
180: , p5_a8 JTF_VARCHAR2_TABLE_100
181: , p5_a9 JTF_NUMBER_TABLE
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_300
179: , p5_a7 JTF_VARCHAR2_TABLE_800
180: , p5_a8 JTF_VARCHAR2_TABLE_100
181: , p5_a9 JTF_NUMBER_TABLE
182: , p5_a10 JTF_DATE_TABLE
183: , p5_a11 JTF_NUMBER_TABLE
184: , p5_a12 JTF_DATE_TABLE
185: , p5_a13 JTF_NUMBER_TABLE
179: , p5_a7 JTF_VARCHAR2_TABLE_800
180: , p5_a8 JTF_VARCHAR2_TABLE_100
181: , p5_a9 JTF_NUMBER_TABLE
182: , p5_a10 JTF_DATE_TABLE
183: , p5_a11 JTF_NUMBER_TABLE
184: , p5_a12 JTF_DATE_TABLE
185: , p5_a13 JTF_NUMBER_TABLE
186: );
187: procedure insert_dsfparameters(p_api_version NUMBER
181: , p5_a9 JTF_NUMBER_TABLE
182: , p5_a10 JTF_DATE_TABLE
183: , p5_a11 JTF_NUMBER_TABLE
184: , p5_a12 JTF_DATE_TABLE
185: , p5_a13 JTF_NUMBER_TABLE
186: );
187: procedure insert_dsfparameters(p_api_version NUMBER
188: , p_init_msg_list VARCHAR2
189: , x_return_status out nocopy VARCHAR2
188: , p_init_msg_list VARCHAR2
189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_NUMBER_TABLE
194: , p6_a2 JTF_VARCHAR2_TABLE_100
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
189: , x_return_status out nocopy VARCHAR2
190: , x_msg_count out nocopy NUMBER
191: , x_msg_data out nocopy VARCHAR2
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_NUMBER_TABLE
194: , p6_a2 JTF_VARCHAR2_TABLE_100
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
191: , x_msg_data out nocopy VARCHAR2
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_NUMBER_TABLE
194: , p6_a2 JTF_VARCHAR2_TABLE_100
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_VARCHAR2_TABLE_300
199: , p6_a7 JTF_VARCHAR2_TABLE_800
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_NUMBER_TABLE
194: , p6_a2 JTF_VARCHAR2_TABLE_100
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_VARCHAR2_TABLE_300
199: , p6_a7 JTF_VARCHAR2_TABLE_800
200: , p6_a8 JTF_VARCHAR2_TABLE_100
193: , p6_a1 JTF_NUMBER_TABLE
194: , p6_a2 JTF_VARCHAR2_TABLE_100
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_VARCHAR2_TABLE_300
199: , p6_a7 JTF_VARCHAR2_TABLE_800
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_VARCHAR2_TABLE_300
199: , p6_a7 JTF_VARCHAR2_TABLE_800
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_NUMBER_TABLE
202: , p6_a10 JTF_DATE_TABLE
203: , p6_a11 JTF_NUMBER_TABLE
204: , p6_a12 JTF_DATE_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
199: , p6_a7 JTF_VARCHAR2_TABLE_800
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_NUMBER_TABLE
202: , p6_a10 JTF_DATE_TABLE
203: , p6_a11 JTF_NUMBER_TABLE
204: , p6_a12 JTF_DATE_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p6_a9 JTF_NUMBER_TABLE
202: , p6_a10 JTF_DATE_TABLE
203: , p6_a11 JTF_NUMBER_TABLE
204: , p6_a12 JTF_DATE_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
202: , p6_a10 JTF_DATE_TABLE
203: , p6_a11 JTF_NUMBER_TABLE
204: , p6_a12 JTF_DATE_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
210: , p7_a4 out nocopy JTF_NUMBER_TABLE
203: , p6_a11 JTF_NUMBER_TABLE
204: , p6_a12 JTF_DATE_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
210: , p7_a4 out nocopy JTF_NUMBER_TABLE
211: , p7_a5 out nocopy JTF_NUMBER_TABLE
205: , p6_a13 JTF_NUMBER_TABLE
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
210: , p7_a4 out nocopy JTF_NUMBER_TABLE
211: , p7_a5 out nocopy JTF_NUMBER_TABLE
212: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
206: , p7_a0 out nocopy JTF_NUMBER_TABLE
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
210: , p7_a4 out nocopy JTF_NUMBER_TABLE
211: , p7_a5 out nocopy JTF_NUMBER_TABLE
212: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
214: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
207: , p7_a1 out nocopy JTF_NUMBER_TABLE
208: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
209: , p7_a3 out nocopy JTF_NUMBER_TABLE
210: , p7_a4 out nocopy JTF_NUMBER_TABLE
211: , p7_a5 out nocopy JTF_NUMBER_TABLE
212: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
214: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , p7_a9 out nocopy JTF_NUMBER_TABLE
211: , p7_a5 out nocopy JTF_NUMBER_TABLE
212: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
214: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , p7_a9 out nocopy JTF_NUMBER_TABLE
216: , p7_a10 out nocopy JTF_DATE_TABLE
217: , p7_a11 out nocopy JTF_NUMBER_TABLE
218: , p7_a12 out nocopy JTF_DATE_TABLE
219: , p7_a13 out nocopy JTF_NUMBER_TABLE
213: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
214: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , p7_a9 out nocopy JTF_NUMBER_TABLE
216: , p7_a10 out nocopy JTF_DATE_TABLE
217: , p7_a11 out nocopy JTF_NUMBER_TABLE
218: , p7_a12 out nocopy JTF_DATE_TABLE
219: , p7_a13 out nocopy JTF_NUMBER_TABLE
220: , p5_a0 NUMBER := 0-1962.0724
221: , p5_a1 NUMBER := 0-1962.0724
215: , p7_a9 out nocopy JTF_NUMBER_TABLE
216: , p7_a10 out nocopy JTF_DATE_TABLE
217: , p7_a11 out nocopy JTF_NUMBER_TABLE
218: , p7_a12 out nocopy JTF_DATE_TABLE
219: , p7_a13 out nocopy JTF_NUMBER_TABLE
220: , p5_a0 NUMBER := 0-1962.0724
221: , p5_a1 NUMBER := 0-1962.0724
222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
254: , p_init_msg_list VARCHAR2
255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p6_a0 JTF_NUMBER_TABLE
259: , p6_a1 JTF_NUMBER_TABLE
260: , p6_a2 JTF_VARCHAR2_TABLE_100
261: , p6_a3 JTF_NUMBER_TABLE
262: , p6_a4 JTF_NUMBER_TABLE
255: , x_return_status out nocopy VARCHAR2
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , p6_a0 JTF_NUMBER_TABLE
259: , p6_a1 JTF_NUMBER_TABLE
260: , p6_a2 JTF_VARCHAR2_TABLE_100
261: , p6_a3 JTF_NUMBER_TABLE
262: , p6_a4 JTF_NUMBER_TABLE
263: , p6_a5 JTF_NUMBER_TABLE
257: , x_msg_data out nocopy VARCHAR2
258: , p6_a0 JTF_NUMBER_TABLE
259: , p6_a1 JTF_NUMBER_TABLE
260: , p6_a2 JTF_VARCHAR2_TABLE_100
261: , p6_a3 JTF_NUMBER_TABLE
262: , p6_a4 JTF_NUMBER_TABLE
263: , p6_a5 JTF_NUMBER_TABLE
264: , p6_a6 JTF_VARCHAR2_TABLE_300
265: , p6_a7 JTF_VARCHAR2_TABLE_800
258: , p6_a0 JTF_NUMBER_TABLE
259: , p6_a1 JTF_NUMBER_TABLE
260: , p6_a2 JTF_VARCHAR2_TABLE_100
261: , p6_a3 JTF_NUMBER_TABLE
262: , p6_a4 JTF_NUMBER_TABLE
263: , p6_a5 JTF_NUMBER_TABLE
264: , p6_a6 JTF_VARCHAR2_TABLE_300
265: , p6_a7 JTF_VARCHAR2_TABLE_800
266: , p6_a8 JTF_VARCHAR2_TABLE_100
259: , p6_a1 JTF_NUMBER_TABLE
260: , p6_a2 JTF_VARCHAR2_TABLE_100
261: , p6_a3 JTF_NUMBER_TABLE
262: , p6_a4 JTF_NUMBER_TABLE
263: , p6_a5 JTF_NUMBER_TABLE
264: , p6_a6 JTF_VARCHAR2_TABLE_300
265: , p6_a7 JTF_VARCHAR2_TABLE_800
266: , p6_a8 JTF_VARCHAR2_TABLE_100
267: , p6_a9 JTF_NUMBER_TABLE
263: , p6_a5 JTF_NUMBER_TABLE
264: , p6_a6 JTF_VARCHAR2_TABLE_300
265: , p6_a7 JTF_VARCHAR2_TABLE_800
266: , p6_a8 JTF_VARCHAR2_TABLE_100
267: , p6_a9 JTF_NUMBER_TABLE
268: , p6_a10 JTF_DATE_TABLE
269: , p6_a11 JTF_NUMBER_TABLE
270: , p6_a12 JTF_DATE_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
265: , p6_a7 JTF_VARCHAR2_TABLE_800
266: , p6_a8 JTF_VARCHAR2_TABLE_100
267: , p6_a9 JTF_NUMBER_TABLE
268: , p6_a10 JTF_DATE_TABLE
269: , p6_a11 JTF_NUMBER_TABLE
270: , p6_a12 JTF_DATE_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a9 JTF_NUMBER_TABLE
268: , p6_a10 JTF_DATE_TABLE
269: , p6_a11 JTF_NUMBER_TABLE
270: , p6_a12 JTF_DATE_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 JTF_DATE_TABLE
269: , p6_a11 JTF_NUMBER_TABLE
270: , p6_a12 JTF_DATE_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
276: , p7_a4 out nocopy JTF_NUMBER_TABLE
269: , p6_a11 JTF_NUMBER_TABLE
270: , p6_a12 JTF_DATE_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
276: , p7_a4 out nocopy JTF_NUMBER_TABLE
277: , p7_a5 out nocopy JTF_NUMBER_TABLE
271: , p6_a13 JTF_NUMBER_TABLE
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
276: , p7_a4 out nocopy JTF_NUMBER_TABLE
277: , p7_a5 out nocopy JTF_NUMBER_TABLE
278: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
279: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
272: , p7_a0 out nocopy JTF_NUMBER_TABLE
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
276: , p7_a4 out nocopy JTF_NUMBER_TABLE
277: , p7_a5 out nocopy JTF_NUMBER_TABLE
278: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
279: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
280: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a1 out nocopy JTF_NUMBER_TABLE
274: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p7_a3 out nocopy JTF_NUMBER_TABLE
276: , p7_a4 out nocopy JTF_NUMBER_TABLE
277: , p7_a5 out nocopy JTF_NUMBER_TABLE
278: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
279: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
280: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
281: , p7_a9 out nocopy JTF_NUMBER_TABLE
277: , p7_a5 out nocopy JTF_NUMBER_TABLE
278: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
279: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
280: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
281: , p7_a9 out nocopy JTF_NUMBER_TABLE
282: , p7_a10 out nocopy JTF_DATE_TABLE
283: , p7_a11 out nocopy JTF_NUMBER_TABLE
284: , p7_a12 out nocopy JTF_DATE_TABLE
285: , p7_a13 out nocopy JTF_NUMBER_TABLE
279: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_800
280: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
281: , p7_a9 out nocopy JTF_NUMBER_TABLE
282: , p7_a10 out nocopy JTF_DATE_TABLE
283: , p7_a11 out nocopy JTF_NUMBER_TABLE
284: , p7_a12 out nocopy JTF_DATE_TABLE
285: , p7_a13 out nocopy JTF_NUMBER_TABLE
286: , p5_a0 NUMBER := 0-1962.0724
287: , p5_a1 NUMBER := 0-1962.0724
281: , p7_a9 out nocopy JTF_NUMBER_TABLE
282: , p7_a10 out nocopy JTF_DATE_TABLE
283: , p7_a11 out nocopy JTF_NUMBER_TABLE
284: , p7_a12 out nocopy JTF_DATE_TABLE
285: , p7_a13 out nocopy JTF_NUMBER_TABLE
286: , p5_a0 NUMBER := 0-1962.0724
287: , p5_a1 NUMBER := 0-1962.0724
288: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a3 VARCHAR2 := fnd_api.g_miss_char