DBA Data[Home] [Help]

APPS.OKL_INS_RATES_PUB_W dependencies on JTF_DATE_TABLE

Line 18: , p5_a10 JTF_DATE_TABLE

14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 19: , p5_a11 JTF_DATE_TABLE

15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_500
23: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 38: , p5_a30 JTF_DATE_TABLE

34: , p5_a26 JTF_VARCHAR2_TABLE_500
35: , p5_a27 JTF_VARCHAR2_TABLE_500
36: , p5_a28 JTF_VARCHAR2_TABLE_500
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 40: , p5_a32 JTF_DATE_TABLE

36: , p5_a28 JTF_VARCHAR2_TABLE_500
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p6_a0 out nocopy JTF_NUMBER_TABLE
43: , p6_a1 out nocopy JTF_NUMBER_TABLE
44: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 52: , p6_a10 out nocopy JTF_DATE_TABLE

48: , p6_a6 out nocopy JTF_NUMBER_TABLE
49: , p6_a7 out nocopy JTF_NUMBER_TABLE
50: , p6_a8 out nocopy JTF_NUMBER_TABLE
51: , p6_a9 out nocopy JTF_NUMBER_TABLE
52: , p6_a10 out nocopy JTF_DATE_TABLE
53: , p6_a11 out nocopy JTF_DATE_TABLE
54: , p6_a12 out nocopy JTF_NUMBER_TABLE
55: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
56: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 53: , p6_a11 out nocopy JTF_DATE_TABLE

49: , p6_a7 out nocopy JTF_NUMBER_TABLE
50: , p6_a8 out nocopy JTF_NUMBER_TABLE
51: , p6_a9 out nocopy JTF_NUMBER_TABLE
52: , p6_a10 out nocopy JTF_DATE_TABLE
53: , p6_a11 out nocopy JTF_DATE_TABLE
54: , p6_a12 out nocopy JTF_NUMBER_TABLE
55: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
56: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
57: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 72: , p6_a30 out nocopy JTF_DATE_TABLE

68: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
70: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
71: , p6_a29 out nocopy JTF_NUMBER_TABLE
72: , p6_a30 out nocopy JTF_DATE_TABLE
73: , p6_a31 out nocopy JTF_NUMBER_TABLE
74: , p6_a32 out nocopy JTF_DATE_TABLE
75: , p6_a33 out nocopy JTF_NUMBER_TABLE
76: );

Line 74: , p6_a32 out nocopy JTF_DATE_TABLE

70: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
71: , p6_a29 out nocopy JTF_NUMBER_TABLE
72: , p6_a30 out nocopy JTF_DATE_TABLE
73: , p6_a31 out nocopy JTF_NUMBER_TABLE
74: , p6_a32 out nocopy JTF_DATE_TABLE
75: , p6_a33 out nocopy JTF_NUMBER_TABLE
76: );
77: procedure insert_ins_rates(p_api_version NUMBER
78: , p_init_msg_list VARCHAR2

Line 166: , p5_a10 JTF_DATE_TABLE

162: , p5_a6 JTF_NUMBER_TABLE
163: , p5_a7 JTF_NUMBER_TABLE
164: , p5_a8 JTF_NUMBER_TABLE
165: , p5_a9 JTF_NUMBER_TABLE
166: , p5_a10 JTF_DATE_TABLE
167: , p5_a11 JTF_DATE_TABLE
168: , p5_a12 JTF_NUMBER_TABLE
169: , p5_a13 JTF_VARCHAR2_TABLE_100
170: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 167: , p5_a11 JTF_DATE_TABLE

163: , p5_a7 JTF_NUMBER_TABLE
164: , p5_a8 JTF_NUMBER_TABLE
165: , p5_a9 JTF_NUMBER_TABLE
166: , p5_a10 JTF_DATE_TABLE
167: , p5_a11 JTF_DATE_TABLE
168: , p5_a12 JTF_NUMBER_TABLE
169: , p5_a13 JTF_VARCHAR2_TABLE_100
170: , p5_a14 JTF_VARCHAR2_TABLE_500
171: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 186: , p5_a30 JTF_DATE_TABLE

182: , p5_a26 JTF_VARCHAR2_TABLE_500
183: , p5_a27 JTF_VARCHAR2_TABLE_500
184: , p5_a28 JTF_VARCHAR2_TABLE_500
185: , p5_a29 JTF_NUMBER_TABLE
186: , p5_a30 JTF_DATE_TABLE
187: , p5_a31 JTF_NUMBER_TABLE
188: , p5_a32 JTF_DATE_TABLE
189: , p5_a33 JTF_NUMBER_TABLE
190: );

Line 188: , p5_a32 JTF_DATE_TABLE

184: , p5_a28 JTF_VARCHAR2_TABLE_500
185: , p5_a29 JTF_NUMBER_TABLE
186: , p5_a30 JTF_DATE_TABLE
187: , p5_a31 JTF_NUMBER_TABLE
188: , p5_a32 JTF_DATE_TABLE
189: , p5_a33 JTF_NUMBER_TABLE
190: );
191: procedure lock_ins_rates(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2

Line 246: , p5_a10 JTF_DATE_TABLE

242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_NUMBER_TABLE
246: , p5_a10 JTF_DATE_TABLE
247: , p5_a11 JTF_DATE_TABLE
248: , p5_a12 JTF_NUMBER_TABLE
249: , p5_a13 JTF_VARCHAR2_TABLE_100
250: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 247: , p5_a11 JTF_DATE_TABLE

243: , p5_a7 JTF_NUMBER_TABLE
244: , p5_a8 JTF_NUMBER_TABLE
245: , p5_a9 JTF_NUMBER_TABLE
246: , p5_a10 JTF_DATE_TABLE
247: , p5_a11 JTF_DATE_TABLE
248: , p5_a12 JTF_NUMBER_TABLE
249: , p5_a13 JTF_VARCHAR2_TABLE_100
250: , p5_a14 JTF_VARCHAR2_TABLE_500
251: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 266: , p5_a30 JTF_DATE_TABLE

262: , p5_a26 JTF_VARCHAR2_TABLE_500
263: , p5_a27 JTF_VARCHAR2_TABLE_500
264: , p5_a28 JTF_VARCHAR2_TABLE_500
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_DATE_TABLE
267: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a32 JTF_DATE_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 268: , p5_a32 JTF_DATE_TABLE

264: , p5_a28 JTF_VARCHAR2_TABLE_500
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_DATE_TABLE
267: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a32 JTF_DATE_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 280: , p6_a10 out nocopy JTF_DATE_TABLE

276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_NUMBER_TABLE
278: , p6_a8 out nocopy JTF_NUMBER_TABLE
279: , p6_a9 out nocopy JTF_NUMBER_TABLE
280: , p6_a10 out nocopy JTF_DATE_TABLE
281: , p6_a11 out nocopy JTF_DATE_TABLE
282: , p6_a12 out nocopy JTF_NUMBER_TABLE
283: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 281: , p6_a11 out nocopy JTF_DATE_TABLE

277: , p6_a7 out nocopy JTF_NUMBER_TABLE
278: , p6_a8 out nocopy JTF_NUMBER_TABLE
279: , p6_a9 out nocopy JTF_NUMBER_TABLE
280: , p6_a10 out nocopy JTF_DATE_TABLE
281: , p6_a11 out nocopy JTF_DATE_TABLE
282: , p6_a12 out nocopy JTF_NUMBER_TABLE
283: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
285: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 300: , p6_a30 out nocopy JTF_DATE_TABLE

296: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
297: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
298: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a32 out nocopy JTF_DATE_TABLE
303: , p6_a33 out nocopy JTF_NUMBER_TABLE
304: );

Line 302: , p6_a32 out nocopy JTF_DATE_TABLE

298: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a32 out nocopy JTF_DATE_TABLE
303: , p6_a33 out nocopy JTF_NUMBER_TABLE
304: );
305: procedure update_ins_rates(p_api_version NUMBER
306: , p_init_msg_list VARCHAR2

Line 394: , p5_a10 JTF_DATE_TABLE

390: , p5_a6 JTF_NUMBER_TABLE
391: , p5_a7 JTF_NUMBER_TABLE
392: , p5_a8 JTF_NUMBER_TABLE
393: , p5_a9 JTF_NUMBER_TABLE
394: , p5_a10 JTF_DATE_TABLE
395: , p5_a11 JTF_DATE_TABLE
396: , p5_a12 JTF_NUMBER_TABLE
397: , p5_a13 JTF_VARCHAR2_TABLE_100
398: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 395: , p5_a11 JTF_DATE_TABLE

391: , p5_a7 JTF_NUMBER_TABLE
392: , p5_a8 JTF_NUMBER_TABLE
393: , p5_a9 JTF_NUMBER_TABLE
394: , p5_a10 JTF_DATE_TABLE
395: , p5_a11 JTF_DATE_TABLE
396: , p5_a12 JTF_NUMBER_TABLE
397: , p5_a13 JTF_VARCHAR2_TABLE_100
398: , p5_a14 JTF_VARCHAR2_TABLE_500
399: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 414: , p5_a30 JTF_DATE_TABLE

410: , p5_a26 JTF_VARCHAR2_TABLE_500
411: , p5_a27 JTF_VARCHAR2_TABLE_500
412: , p5_a28 JTF_VARCHAR2_TABLE_500
413: , p5_a29 JTF_NUMBER_TABLE
414: , p5_a30 JTF_DATE_TABLE
415: , p5_a31 JTF_NUMBER_TABLE
416: , p5_a32 JTF_DATE_TABLE
417: , p5_a33 JTF_NUMBER_TABLE
418: );

Line 416: , p5_a32 JTF_DATE_TABLE

412: , p5_a28 JTF_VARCHAR2_TABLE_500
413: , p5_a29 JTF_NUMBER_TABLE
414: , p5_a30 JTF_DATE_TABLE
415: , p5_a31 JTF_NUMBER_TABLE
416: , p5_a32 JTF_DATE_TABLE
417: , p5_a33 JTF_NUMBER_TABLE
418: );
419: procedure delete_ins_rates(p_api_version NUMBER
420: , p_init_msg_list VARCHAR2

Line 474: , p5_a10 JTF_DATE_TABLE

470: , p5_a6 JTF_NUMBER_TABLE
471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_NUMBER_TABLE
473: , p5_a9 JTF_NUMBER_TABLE
474: , p5_a10 JTF_DATE_TABLE
475: , p5_a11 JTF_DATE_TABLE
476: , p5_a12 JTF_NUMBER_TABLE
477: , p5_a13 JTF_VARCHAR2_TABLE_100
478: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 475: , p5_a11 JTF_DATE_TABLE

471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_NUMBER_TABLE
473: , p5_a9 JTF_NUMBER_TABLE
474: , p5_a10 JTF_DATE_TABLE
475: , p5_a11 JTF_DATE_TABLE
476: , p5_a12 JTF_NUMBER_TABLE
477: , p5_a13 JTF_VARCHAR2_TABLE_100
478: , p5_a14 JTF_VARCHAR2_TABLE_500
479: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 494: , p5_a30 JTF_DATE_TABLE

490: , p5_a26 JTF_VARCHAR2_TABLE_500
491: , p5_a27 JTF_VARCHAR2_TABLE_500
492: , p5_a28 JTF_VARCHAR2_TABLE_500
493: , p5_a29 JTF_NUMBER_TABLE
494: , p5_a30 JTF_DATE_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_DATE_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: );

Line 496: , p5_a32 JTF_DATE_TABLE

492: , p5_a28 JTF_VARCHAR2_TABLE_500
493: , p5_a29 JTF_NUMBER_TABLE
494: , p5_a30 JTF_DATE_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_DATE_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: );
499: procedure validate_ins_rates(p_api_version NUMBER
500: , p_init_msg_list VARCHAR2