APPS.OKL_INSURER_RANKINGS_PUB_W dependencies on JTF_DATE_TABLE

Line 11: , p5_a3 JTF_DATE_TABLE

7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_DATE_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 12: , p5_a4 JTF_DATE_TABLE

8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_DATE_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_300
16: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 32: , p5_a24 JTF_DATE_TABLE

28: , p5_a20 JTF_VARCHAR2_TABLE_300
29: , p5_a21 JTF_VARCHAR2_TABLE_300
30: , p5_a22 JTF_VARCHAR2_TABLE_300
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_DATE_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 34: , p5_a26 JTF_DATE_TABLE

30: , p5_a22 JTF_VARCHAR2_TABLE_300
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_DATE_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_DATE_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p6_a0 out nocopy JTF_NUMBER_TABLE
37: , p6_a1 out nocopy JTF_NUMBER_TABLE
38: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 39: , p6_a3 out nocopy JTF_DATE_TABLE

35: , p5_a27 JTF_NUMBER_TABLE
36: , p6_a0 out nocopy JTF_NUMBER_TABLE
37: , p6_a1 out nocopy JTF_NUMBER_TABLE
38: , p6_a2 out nocopy JTF_NUMBER_TABLE
39: , p6_a3 out nocopy JTF_DATE_TABLE
40: , p6_a4 out nocopy JTF_DATE_TABLE
41: , p6_a5 out nocopy JTF_NUMBER_TABLE
42: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 40: , p6_a4 out nocopy JTF_DATE_TABLE

36: , p6_a0 out nocopy JTF_NUMBER_TABLE
37: , p6_a1 out nocopy JTF_NUMBER_TABLE
38: , p6_a2 out nocopy JTF_NUMBER_TABLE
39: , p6_a3 out nocopy JTF_DATE_TABLE
40: , p6_a4 out nocopy JTF_DATE_TABLE
41: , p6_a5 out nocopy JTF_NUMBER_TABLE
42: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
44: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 60: , p6_a24 out nocopy JTF_DATE_TABLE

56: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
57: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
58: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
59: , p6_a23 out nocopy JTF_NUMBER_TABLE
60: , p6_a24 out nocopy JTF_DATE_TABLE
61: , p6_a25 out nocopy JTF_NUMBER_TABLE
62: , p6_a26 out nocopy JTF_DATE_TABLE
63: , p6_a27 out nocopy JTF_NUMBER_TABLE
64: );

Line 62: , p6_a26 out nocopy JTF_DATE_TABLE

58: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
59: , p6_a23 out nocopy JTF_NUMBER_TABLE
60: , p6_a24 out nocopy JTF_DATE_TABLE
61: , p6_a25 out nocopy JTF_NUMBER_TABLE
62: , p6_a26 out nocopy JTF_DATE_TABLE
63: , p6_a27 out nocopy JTF_NUMBER_TABLE
64: );
65: procedure insert_insurer_rankings(p_api_version NUMBER
66: , p_init_msg_list VARCHAR2

Line 135: , p5_a3 JTF_DATE_TABLE

131: , x_msg_data out nocopy VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_NUMBER_TABLE
135: , p5_a3 JTF_DATE_TABLE
136: , p5_a4 JTF_DATE_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_VARCHAR2_TABLE_100
139: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 136: , p5_a4 JTF_DATE_TABLE

132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_NUMBER_TABLE
135: , p5_a3 JTF_DATE_TABLE
136: , p5_a4 JTF_DATE_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_VARCHAR2_TABLE_100
139: , p5_a7 JTF_VARCHAR2_TABLE_300
140: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 156: , p5_a24 JTF_DATE_TABLE

152: , p5_a20 JTF_VARCHAR2_TABLE_300
153: , p5_a21 JTF_VARCHAR2_TABLE_300
154: , p5_a22 JTF_VARCHAR2_TABLE_300
155: , p5_a23 JTF_NUMBER_TABLE
156: , p5_a24 JTF_DATE_TABLE
157: , p5_a25 JTF_NUMBER_TABLE
158: , p5_a26 JTF_DATE_TABLE
159: , p5_a27 JTF_NUMBER_TABLE
160: );

Line 158: , p5_a26 JTF_DATE_TABLE

154: , p5_a22 JTF_VARCHAR2_TABLE_300
155: , p5_a23 JTF_NUMBER_TABLE
156: , p5_a24 JTF_DATE_TABLE
157: , p5_a25 JTF_NUMBER_TABLE
158: , p5_a26 JTF_DATE_TABLE
159: , p5_a27 JTF_NUMBER_TABLE
160: );
161: procedure lock_insurer_rankings(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2

Line 203: , p5_a3 JTF_DATE_TABLE

199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_DATE_TABLE
204: , p5_a4 JTF_DATE_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_VARCHAR2_TABLE_100
207: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 204: , p5_a4 JTF_DATE_TABLE

200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_DATE_TABLE
204: , p5_a4 JTF_DATE_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_VARCHAR2_TABLE_100
207: , p5_a7 JTF_VARCHAR2_TABLE_300
208: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 224: , p5_a24 JTF_DATE_TABLE

220: , p5_a20 JTF_VARCHAR2_TABLE_300
221: , p5_a21 JTF_VARCHAR2_TABLE_300
222: , p5_a22 JTF_VARCHAR2_TABLE_300
223: , p5_a23 JTF_NUMBER_TABLE
224: , p5_a24 JTF_DATE_TABLE
225: , p5_a25 JTF_NUMBER_TABLE
226: , p5_a26 JTF_DATE_TABLE
227: , p5_a27 JTF_NUMBER_TABLE
228: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 226: , p5_a26 JTF_DATE_TABLE

222: , p5_a22 JTF_VARCHAR2_TABLE_300
223: , p5_a23 JTF_NUMBER_TABLE
224: , p5_a24 JTF_DATE_TABLE
225: , p5_a25 JTF_NUMBER_TABLE
226: , p5_a26 JTF_DATE_TABLE
227: , p5_a27 JTF_NUMBER_TABLE
228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_NUMBER_TABLE
230: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 231: , p6_a3 out nocopy JTF_DATE_TABLE

227: , p5_a27 JTF_NUMBER_TABLE
228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_NUMBER_TABLE
230: , p6_a2 out nocopy JTF_NUMBER_TABLE
231: , p6_a3 out nocopy JTF_DATE_TABLE
232: , p6_a4 out nocopy JTF_DATE_TABLE
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
235: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 232: , p6_a4 out nocopy JTF_DATE_TABLE

228: , p6_a0 out nocopy JTF_NUMBER_TABLE
229: , p6_a1 out nocopy JTF_NUMBER_TABLE
230: , p6_a2 out nocopy JTF_NUMBER_TABLE
231: , p6_a3 out nocopy JTF_DATE_TABLE
232: , p6_a4 out nocopy JTF_DATE_TABLE
233: , p6_a5 out nocopy JTF_NUMBER_TABLE
234: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
235: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
236: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 252: , p6_a24 out nocopy JTF_DATE_TABLE

248: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
249: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
250: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
251: , p6_a23 out nocopy JTF_NUMBER_TABLE
252: , p6_a24 out nocopy JTF_DATE_TABLE
253: , p6_a25 out nocopy JTF_NUMBER_TABLE
254: , p6_a26 out nocopy JTF_DATE_TABLE
255: , p6_a27 out nocopy JTF_NUMBER_TABLE
256: );

Line 254: , p6_a26 out nocopy JTF_DATE_TABLE

250: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
251: , p6_a23 out nocopy JTF_NUMBER_TABLE
252: , p6_a24 out nocopy JTF_DATE_TABLE
253: , p6_a25 out nocopy JTF_NUMBER_TABLE
254: , p6_a26 out nocopy JTF_DATE_TABLE
255: , p6_a27 out nocopy JTF_NUMBER_TABLE
256: );
257: procedure update_insurer_rankings(p_api_version NUMBER
258: , p_init_msg_list VARCHAR2

Line 327: , p5_a3 JTF_DATE_TABLE

323: , x_msg_data out nocopy VARCHAR2
324: , p5_a0 JTF_NUMBER_TABLE
325: , p5_a1 JTF_NUMBER_TABLE
326: , p5_a2 JTF_NUMBER_TABLE
327: , p5_a3 JTF_DATE_TABLE
328: , p5_a4 JTF_DATE_TABLE
329: , p5_a5 JTF_NUMBER_TABLE
330: , p5_a6 JTF_VARCHAR2_TABLE_100
331: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 328: , p5_a4 JTF_DATE_TABLE

324: , p5_a0 JTF_NUMBER_TABLE
325: , p5_a1 JTF_NUMBER_TABLE
326: , p5_a2 JTF_NUMBER_TABLE
327: , p5_a3 JTF_DATE_TABLE
328: , p5_a4 JTF_DATE_TABLE
329: , p5_a5 JTF_NUMBER_TABLE
330: , p5_a6 JTF_VARCHAR2_TABLE_100
331: , p5_a7 JTF_VARCHAR2_TABLE_300
332: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 348: , p5_a24 JTF_DATE_TABLE

344: , p5_a20 JTF_VARCHAR2_TABLE_300
345: , p5_a21 JTF_VARCHAR2_TABLE_300
346: , p5_a22 JTF_VARCHAR2_TABLE_300
347: , p5_a23 JTF_NUMBER_TABLE
348: , p5_a24 JTF_DATE_TABLE
349: , p5_a25 JTF_NUMBER_TABLE
350: , p5_a26 JTF_DATE_TABLE
351: , p5_a27 JTF_NUMBER_TABLE
352: );

Line 350: , p5_a26 JTF_DATE_TABLE

346: , p5_a22 JTF_VARCHAR2_TABLE_300
347: , p5_a23 JTF_NUMBER_TABLE
348: , p5_a24 JTF_DATE_TABLE
349: , p5_a25 JTF_NUMBER_TABLE
350: , p5_a26 JTF_DATE_TABLE
351: , p5_a27 JTF_NUMBER_TABLE
352: );
353: procedure delete_insurer_rankings(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2

Line 395: , p5_a3 JTF_DATE_TABLE

391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_NUMBER_TABLE
394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_DATE_TABLE
396: , p5_a4 JTF_DATE_TABLE
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_VARCHAR2_TABLE_100
399: , p5_a7 JTF_VARCHAR2_TABLE_300

Line 396: , p5_a4 JTF_DATE_TABLE

392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_NUMBER_TABLE
394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_DATE_TABLE
396: , p5_a4 JTF_DATE_TABLE
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_VARCHAR2_TABLE_100
399: , p5_a7 JTF_VARCHAR2_TABLE_300
400: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 416: , p5_a24 JTF_DATE_TABLE

412: , p5_a20 JTF_VARCHAR2_TABLE_300
413: , p5_a21 JTF_VARCHAR2_TABLE_300
414: , p5_a22 JTF_VARCHAR2_TABLE_300
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_DATE_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: );

Line 418: , p5_a26 JTF_DATE_TABLE

414: , p5_a22 JTF_VARCHAR2_TABLE_300
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_DATE_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: );
421: procedure validate_insurer_rankings(p_api_version NUMBER
422: , p_init_msg_list VARCHAR2