APPS.OKL_INS_CLAIMS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

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: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_300
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_300
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 11: , p5_a3 JTF_NUMBER_TABLE

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

Line 20: , p5_a12 JTF_NUMBER_TABLE

16: , p5_a8 JTF_DATE_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_2000
18: , p5_a10 JTF_VARCHAR2_TABLE_300
19: , p5_a11 JTF_VARCHAR2_TABLE_300
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
24: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 38: , p5_a30 JTF_NUMBER_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_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE

Line 39: , p5_a31 JTF_NUMBER_TABLE

35: , p5_a27 JTF_VARCHAR2_TABLE_500
36: , p5_a28 JTF_VARCHAR2_TABLE_500
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE

Line 40: , p5_a32 JTF_NUMBER_TABLE

36: , p5_a28 JTF_VARCHAR2_TABLE_500
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE

Line 41: , p5_a33 JTF_NUMBER_TABLE

37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE

Line 43: , p5_a35 JTF_NUMBER_TABLE

39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE

Line 45: , p5_a37 JTF_NUMBER_TABLE

41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 47: , p5_a39 JTF_NUMBER_TABLE

43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 48: , p6_a0 out nocopy JTF_NUMBER_TABLE

44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , p6_a1 out nocopy JTF_NUMBER_TABLE

45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_DATE_TABLE
47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , p6_a3 out nocopy JTF_NUMBER_TABLE

47: , p5_a39 JTF_NUMBER_TABLE
48: , p6_a0 out nocopy JTF_NUMBER_TABLE
49: , p6_a1 out nocopy JTF_NUMBER_TABLE
50: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , p6_a3 out nocopy JTF_NUMBER_TABLE
52: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
55: , p6_a7 out nocopy JTF_DATE_TABLE

Line 60: , p6_a12 out nocopy JTF_NUMBER_TABLE

56: , p6_a8 out nocopy JTF_DATE_TABLE
57: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
58: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
59: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
60: , p6_a12 out nocopy JTF_NUMBER_TABLE
61: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
62: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
63: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
64: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 78: , p6_a30 out nocopy JTF_NUMBER_TABLE

74: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
75: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
76: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
77: , p6_a29 out nocopy JTF_DATE_TABLE
78: , p6_a30 out nocopy JTF_NUMBER_TABLE
79: , p6_a31 out nocopy JTF_NUMBER_TABLE
80: , p6_a32 out nocopy JTF_NUMBER_TABLE
81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE

Line 79: , p6_a31 out nocopy JTF_NUMBER_TABLE

75: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
76: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
77: , p6_a29 out nocopy JTF_DATE_TABLE
78: , p6_a30 out nocopy JTF_NUMBER_TABLE
79: , p6_a31 out nocopy JTF_NUMBER_TABLE
80: , p6_a32 out nocopy JTF_NUMBER_TABLE
81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE
83: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a32 out nocopy JTF_NUMBER_TABLE

76: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
77: , p6_a29 out nocopy JTF_DATE_TABLE
78: , p6_a30 out nocopy JTF_NUMBER_TABLE
79: , p6_a31 out nocopy JTF_NUMBER_TABLE
80: , p6_a32 out nocopy JTF_NUMBER_TABLE
81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE

Line 81: , p6_a33 out nocopy JTF_NUMBER_TABLE

77: , p6_a29 out nocopy JTF_DATE_TABLE
78: , p6_a30 out nocopy JTF_NUMBER_TABLE
79: , p6_a31 out nocopy JTF_NUMBER_TABLE
80: , p6_a32 out nocopy JTF_NUMBER_TABLE
81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 83: , p6_a35 out nocopy JTF_NUMBER_TABLE

79: , p6_a31 out nocopy JTF_NUMBER_TABLE
80: , p6_a32 out nocopy JTF_NUMBER_TABLE
81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 85: , p6_a37 out nocopy JTF_NUMBER_TABLE

81: , p6_a33 out nocopy JTF_NUMBER_TABLE
82: , p6_a34 out nocopy JTF_DATE_TABLE
83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE
88: );
89: procedure insert_ins_claims(p_api_version NUMBER

Line 87: , p6_a39 out nocopy JTF_NUMBER_TABLE

83: , p6_a35 out nocopy JTF_NUMBER_TABLE
84: , p6_a36 out nocopy JTF_DATE_TABLE
85: , p6_a37 out nocopy JTF_NUMBER_TABLE
86: , p6_a38 out nocopy JTF_DATE_TABLE
87: , p6_a39 out nocopy JTF_NUMBER_TABLE
88: );
89: procedure insert_ins_claims(p_api_version NUMBER
90: , p_init_msg_list VARCHAR2
91: , x_return_status out nocopy VARCHAR2

Line 180: , p5_a0 JTF_NUMBER_TABLE

176: , p_init_msg_list VARCHAR2
177: , x_return_status out nocopy VARCHAR2
178: , x_msg_count out nocopy NUMBER
179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_300
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 181: , p5_a1 JTF_NUMBER_TABLE

177: , x_return_status out nocopy VARCHAR2
178: , x_msg_count out nocopy NUMBER
179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_300
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_VARCHAR2_TABLE_100
185: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 183: , p5_a3 JTF_NUMBER_TABLE

179: , x_msg_data out nocopy VARCHAR2
180: , p5_a0 JTF_NUMBER_TABLE
181: , p5_a1 JTF_NUMBER_TABLE
182: , p5_a2 JTF_VARCHAR2_TABLE_300
183: , p5_a3 JTF_NUMBER_TABLE
184: , p5_a4 JTF_VARCHAR2_TABLE_100
185: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , p5_a6 JTF_VARCHAR2_TABLE_100
187: , p5_a7 JTF_DATE_TABLE

Line 192: , p5_a12 JTF_NUMBER_TABLE

188: , p5_a8 JTF_DATE_TABLE
189: , p5_a9 JTF_VARCHAR2_TABLE_2000
190: , p5_a10 JTF_VARCHAR2_TABLE_300
191: , p5_a11 JTF_VARCHAR2_TABLE_300
192: , p5_a12 JTF_NUMBER_TABLE
193: , p5_a13 JTF_VARCHAR2_TABLE_100
194: , p5_a14 JTF_VARCHAR2_TABLE_500
195: , p5_a15 JTF_VARCHAR2_TABLE_500
196: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 210: , p5_a30 JTF_NUMBER_TABLE

206: , p5_a26 JTF_VARCHAR2_TABLE_500
207: , p5_a27 JTF_VARCHAR2_TABLE_500
208: , p5_a28 JTF_VARCHAR2_TABLE_500
209: , p5_a29 JTF_DATE_TABLE
210: , p5_a30 JTF_NUMBER_TABLE
211: , p5_a31 JTF_NUMBER_TABLE
212: , p5_a32 JTF_NUMBER_TABLE
213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE

Line 211: , p5_a31 JTF_NUMBER_TABLE

207: , p5_a27 JTF_VARCHAR2_TABLE_500
208: , p5_a28 JTF_VARCHAR2_TABLE_500
209: , p5_a29 JTF_DATE_TABLE
210: , p5_a30 JTF_NUMBER_TABLE
211: , p5_a31 JTF_NUMBER_TABLE
212: , p5_a32 JTF_NUMBER_TABLE
213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE
215: , p5_a35 JTF_NUMBER_TABLE

Line 212: , p5_a32 JTF_NUMBER_TABLE

208: , p5_a28 JTF_VARCHAR2_TABLE_500
209: , p5_a29 JTF_DATE_TABLE
210: , p5_a30 JTF_NUMBER_TABLE
211: , p5_a31 JTF_NUMBER_TABLE
212: , p5_a32 JTF_NUMBER_TABLE
213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE

Line 213: , p5_a33 JTF_NUMBER_TABLE

209: , p5_a29 JTF_DATE_TABLE
210: , p5_a30 JTF_NUMBER_TABLE
211: , p5_a31 JTF_NUMBER_TABLE
212: , p5_a32 JTF_NUMBER_TABLE
213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE

Line 215: , p5_a35 JTF_NUMBER_TABLE

211: , p5_a31 JTF_NUMBER_TABLE
212: , p5_a32 JTF_NUMBER_TABLE
213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE

Line 217: , p5_a37 JTF_NUMBER_TABLE

213: , p5_a33 JTF_NUMBER_TABLE
214: , p5_a34 JTF_DATE_TABLE
215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE
220: );
221: procedure lock_ins_claims(p_api_version NUMBER

Line 219: , p5_a39 JTF_NUMBER_TABLE

215: , p5_a35 JTF_NUMBER_TABLE
216: , p5_a36 JTF_DATE_TABLE
217: , p5_a37 JTF_NUMBER_TABLE
218: , p5_a38 JTF_DATE_TABLE
219: , p5_a39 JTF_NUMBER_TABLE
220: );
221: procedure lock_ins_claims(p_api_version NUMBER
222: , p_init_msg_list VARCHAR2
223: , x_return_status out nocopy VARCHAR2

Line 272: , p5_a0 JTF_NUMBER_TABLE

268: , p_init_msg_list VARCHAR2
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_300
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 273: , p5_a1 JTF_NUMBER_TABLE

269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_300
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 275: , p5_a3 JTF_NUMBER_TABLE

271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_300
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_VARCHAR2_TABLE_100
278: , p5_a6 JTF_VARCHAR2_TABLE_100
279: , p5_a7 JTF_DATE_TABLE

Line 284: , p5_a12 JTF_NUMBER_TABLE

280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_VARCHAR2_TABLE_2000
282: , p5_a10 JTF_VARCHAR2_TABLE_300
283: , p5_a11 JTF_VARCHAR2_TABLE_300
284: , p5_a12 JTF_NUMBER_TABLE
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_VARCHAR2_TABLE_500
287: , p5_a15 JTF_VARCHAR2_TABLE_500
288: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 302: , p5_a30 JTF_NUMBER_TABLE

298: , p5_a26 JTF_VARCHAR2_TABLE_500
299: , p5_a27 JTF_VARCHAR2_TABLE_500
300: , p5_a28 JTF_VARCHAR2_TABLE_500
301: , p5_a29 JTF_DATE_TABLE
302: , p5_a30 JTF_NUMBER_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_NUMBER_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE

Line 303: , p5_a31 JTF_NUMBER_TABLE

299: , p5_a27 JTF_VARCHAR2_TABLE_500
300: , p5_a28 JTF_VARCHAR2_TABLE_500
301: , p5_a29 JTF_DATE_TABLE
302: , p5_a30 JTF_NUMBER_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_NUMBER_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE
307: , p5_a35 JTF_NUMBER_TABLE

Line 304: , p5_a32 JTF_NUMBER_TABLE

300: , p5_a28 JTF_VARCHAR2_TABLE_500
301: , p5_a29 JTF_DATE_TABLE
302: , p5_a30 JTF_NUMBER_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_NUMBER_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE

Line 305: , p5_a33 JTF_NUMBER_TABLE

301: , p5_a29 JTF_DATE_TABLE
302: , p5_a30 JTF_NUMBER_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_NUMBER_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE

Line 307: , p5_a35 JTF_NUMBER_TABLE

303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_NUMBER_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE

Line 309: , p5_a37 JTF_NUMBER_TABLE

305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_DATE_TABLE
307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 311: , p5_a39 JTF_NUMBER_TABLE

307: , p5_a35 JTF_NUMBER_TABLE
308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
315: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 312: , p6_a0 out nocopy JTF_NUMBER_TABLE

308: , p5_a36 JTF_DATE_TABLE
309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 313: , p6_a1 out nocopy JTF_NUMBER_TABLE

309: , p5_a37 JTF_NUMBER_TABLE
310: , p5_a38 JTF_DATE_TABLE
311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 315: , p6_a3 out nocopy JTF_NUMBER_TABLE

311: , p5_a39 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
315: , p6_a3 out nocopy JTF_NUMBER_TABLE
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a7 out nocopy JTF_DATE_TABLE

Line 324: , p6_a12 out nocopy JTF_NUMBER_TABLE

320: , p6_a8 out nocopy JTF_DATE_TABLE
321: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
322: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
323: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a12 out nocopy JTF_NUMBER_TABLE
325: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
327: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
328: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 342: , p6_a30 out nocopy JTF_NUMBER_TABLE

338: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
339: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: , p6_a31 out nocopy JTF_NUMBER_TABLE
344: , p6_a32 out nocopy JTF_NUMBER_TABLE
345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE

Line 343: , p6_a31 out nocopy JTF_NUMBER_TABLE

339: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: , p6_a31 out nocopy JTF_NUMBER_TABLE
344: , p6_a32 out nocopy JTF_NUMBER_TABLE
345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE
347: , p6_a35 out nocopy JTF_NUMBER_TABLE

Line 344: , p6_a32 out nocopy JTF_NUMBER_TABLE

340: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: , p6_a31 out nocopy JTF_NUMBER_TABLE
344: , p6_a32 out nocopy JTF_NUMBER_TABLE
345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE

Line 345: , p6_a33 out nocopy JTF_NUMBER_TABLE

341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: , p6_a31 out nocopy JTF_NUMBER_TABLE
344: , p6_a32 out nocopy JTF_NUMBER_TABLE
345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE

Line 347: , p6_a35 out nocopy JTF_NUMBER_TABLE

343: , p6_a31 out nocopy JTF_NUMBER_TABLE
344: , p6_a32 out nocopy JTF_NUMBER_TABLE
345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 349: , p6_a37 out nocopy JTF_NUMBER_TABLE

345: , p6_a33 out nocopy JTF_NUMBER_TABLE
346: , p6_a34 out nocopy JTF_DATE_TABLE
347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE
352: );
353: procedure update_ins_claims(p_api_version NUMBER

Line 351: , p6_a39 out nocopy JTF_NUMBER_TABLE

347: , p6_a35 out nocopy JTF_NUMBER_TABLE
348: , p6_a36 out nocopy JTF_DATE_TABLE
349: , p6_a37 out nocopy JTF_NUMBER_TABLE
350: , p6_a38 out nocopy JTF_DATE_TABLE
351: , p6_a39 out nocopy JTF_NUMBER_TABLE
352: );
353: procedure update_ins_claims(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2
355: , x_return_status out nocopy VARCHAR2

Line 444: , p5_a0 JTF_NUMBER_TABLE

440: , p_init_msg_list VARCHAR2
441: , x_return_status out nocopy VARCHAR2
442: , x_msg_count out nocopy NUMBER
443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_300
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 445: , p5_a1 JTF_NUMBER_TABLE

441: , x_return_status out nocopy VARCHAR2
442: , x_msg_count out nocopy NUMBER
443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_300
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_VARCHAR2_TABLE_100
449: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 447: , p5_a3 JTF_NUMBER_TABLE

443: , x_msg_data out nocopy VARCHAR2
444: , p5_a0 JTF_NUMBER_TABLE
445: , p5_a1 JTF_NUMBER_TABLE
446: , p5_a2 JTF_VARCHAR2_TABLE_300
447: , p5_a3 JTF_NUMBER_TABLE
448: , p5_a4 JTF_VARCHAR2_TABLE_100
449: , p5_a5 JTF_VARCHAR2_TABLE_100
450: , p5_a6 JTF_VARCHAR2_TABLE_100
451: , p5_a7 JTF_DATE_TABLE

Line 456: , p5_a12 JTF_NUMBER_TABLE

452: , p5_a8 JTF_DATE_TABLE
453: , p5_a9 JTF_VARCHAR2_TABLE_2000
454: , p5_a10 JTF_VARCHAR2_TABLE_300
455: , p5_a11 JTF_VARCHAR2_TABLE_300
456: , p5_a12 JTF_NUMBER_TABLE
457: , p5_a13 JTF_VARCHAR2_TABLE_100
458: , p5_a14 JTF_VARCHAR2_TABLE_500
459: , p5_a15 JTF_VARCHAR2_TABLE_500
460: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 474: , p5_a30 JTF_NUMBER_TABLE

470: , p5_a26 JTF_VARCHAR2_TABLE_500
471: , p5_a27 JTF_VARCHAR2_TABLE_500
472: , p5_a28 JTF_VARCHAR2_TABLE_500
473: , p5_a29 JTF_DATE_TABLE
474: , p5_a30 JTF_NUMBER_TABLE
475: , p5_a31 JTF_NUMBER_TABLE
476: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE

Line 475: , p5_a31 JTF_NUMBER_TABLE

471: , p5_a27 JTF_VARCHAR2_TABLE_500
472: , p5_a28 JTF_VARCHAR2_TABLE_500
473: , p5_a29 JTF_DATE_TABLE
474: , p5_a30 JTF_NUMBER_TABLE
475: , p5_a31 JTF_NUMBER_TABLE
476: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE
479: , p5_a35 JTF_NUMBER_TABLE

Line 476: , p5_a32 JTF_NUMBER_TABLE

472: , p5_a28 JTF_VARCHAR2_TABLE_500
473: , p5_a29 JTF_DATE_TABLE
474: , p5_a30 JTF_NUMBER_TABLE
475: , p5_a31 JTF_NUMBER_TABLE
476: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE

Line 477: , p5_a33 JTF_NUMBER_TABLE

473: , p5_a29 JTF_DATE_TABLE
474: , p5_a30 JTF_NUMBER_TABLE
475: , p5_a31 JTF_NUMBER_TABLE
476: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE

Line 479: , p5_a35 JTF_NUMBER_TABLE

475: , p5_a31 JTF_NUMBER_TABLE
476: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE

Line 481: , p5_a37 JTF_NUMBER_TABLE

477: , p5_a33 JTF_NUMBER_TABLE
478: , p5_a34 JTF_DATE_TABLE
479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE
484: );
485: procedure delete_ins_claims(p_api_version NUMBER

Line 483: , p5_a39 JTF_NUMBER_TABLE

479: , p5_a35 JTF_NUMBER_TABLE
480: , p5_a36 JTF_DATE_TABLE
481: , p5_a37 JTF_NUMBER_TABLE
482: , p5_a38 JTF_DATE_TABLE
483: , p5_a39 JTF_NUMBER_TABLE
484: );
485: procedure delete_ins_claims(p_api_version NUMBER
486: , p_init_msg_list VARCHAR2
487: , x_return_status out nocopy VARCHAR2

Line 536: , p5_a0 JTF_NUMBER_TABLE

532: , p_init_msg_list VARCHAR2
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_300
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 537: , p5_a1 JTF_NUMBER_TABLE

533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_300
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_VARCHAR2_TABLE_100
541: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 539: , p5_a3 JTF_NUMBER_TABLE

535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_300
539: , p5_a3 JTF_NUMBER_TABLE
540: , p5_a4 JTF_VARCHAR2_TABLE_100
541: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , p5_a6 JTF_VARCHAR2_TABLE_100
543: , p5_a7 JTF_DATE_TABLE

Line 548: , p5_a12 JTF_NUMBER_TABLE

544: , p5_a8 JTF_DATE_TABLE
545: , p5_a9 JTF_VARCHAR2_TABLE_2000
546: , p5_a10 JTF_VARCHAR2_TABLE_300
547: , p5_a11 JTF_VARCHAR2_TABLE_300
548: , p5_a12 JTF_NUMBER_TABLE
549: , p5_a13 JTF_VARCHAR2_TABLE_100
550: , p5_a14 JTF_VARCHAR2_TABLE_500
551: , p5_a15 JTF_VARCHAR2_TABLE_500
552: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 566: , p5_a30 JTF_NUMBER_TABLE

562: , p5_a26 JTF_VARCHAR2_TABLE_500
563: , p5_a27 JTF_VARCHAR2_TABLE_500
564: , p5_a28 JTF_VARCHAR2_TABLE_500
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_NUMBER_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: , p5_a32 JTF_NUMBER_TABLE
569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE

Line 567: , p5_a31 JTF_NUMBER_TABLE

563: , p5_a27 JTF_VARCHAR2_TABLE_500
564: , p5_a28 JTF_VARCHAR2_TABLE_500
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_NUMBER_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: , p5_a32 JTF_NUMBER_TABLE
569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE
571: , p5_a35 JTF_NUMBER_TABLE

Line 568: , p5_a32 JTF_NUMBER_TABLE

564: , p5_a28 JTF_VARCHAR2_TABLE_500
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_NUMBER_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: , p5_a32 JTF_NUMBER_TABLE
569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE

Line 569: , p5_a33 JTF_NUMBER_TABLE

565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_NUMBER_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: , p5_a32 JTF_NUMBER_TABLE
569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE

Line 571: , p5_a35 JTF_NUMBER_TABLE

567: , p5_a31 JTF_NUMBER_TABLE
568: , p5_a32 JTF_NUMBER_TABLE
569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE

Line 573: , p5_a37 JTF_NUMBER_TABLE

569: , p5_a33 JTF_NUMBER_TABLE
570: , p5_a34 JTF_DATE_TABLE
571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE
576: );
577: procedure validate_ins_claims(p_api_version NUMBER

Line 575: , p5_a39 JTF_NUMBER_TABLE

571: , p5_a35 JTF_NUMBER_TABLE
572: , p5_a36 JTF_DATE_TABLE
573: , p5_a37 JTF_NUMBER_TABLE
574: , p5_a38 JTF_DATE_TABLE
575: , p5_a39 JTF_NUMBER_TABLE
576: );
577: procedure validate_ins_claims(p_api_version NUMBER
578: , p_init_msg_list VARCHAR2
579: , x_return_status out nocopy VARCHAR2