DBA Data[Home] [Help]

APPS.OKL_PRTFL_LINES_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_VARCHAR2_TABLE_300
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_DATE_TABLE
12: , p5_a4 JTF_DATE_TABLE

Line 10: , p5_a2 JTF_NUMBER_TABLE

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

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_100
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_2000

Line 17: , p5_a9 JTF_NUMBER_TABLE

13: , p5_a5 JTF_DATE_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_100
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_2000
21: , p5_a13 JTF_NUMBER_TABLE

Line 18: , p5_a10 JTF_NUMBER_TABLE

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

Line 19: , p5_a11 JTF_NUMBER_TABLE

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

Line 21: , p5_a13 JTF_NUMBER_TABLE

17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_2000
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE

Line 22: , p5_a14 JTF_NUMBER_TABLE

18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_2000
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_300

Line 23: , p5_a15 JTF_NUMBER_TABLE

19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_2000
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_300
27: , p5_a19 JTF_VARCHAR2_TABLE_300

Line 24: , p5_a16 JTF_NUMBER_TABLE

20: , p5_a12 JTF_VARCHAR2_TABLE_2000
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p5_a18 JTF_VARCHAR2_TABLE_300
27: , p5_a19 JTF_VARCHAR2_TABLE_300
28: , p5_a20 JTF_VARCHAR2_TABLE_300

Line 42: , p5_a34 JTF_NUMBER_TABLE

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

Line 44: , p5_a36 JTF_NUMBER_TABLE

40: , p5_a32 JTF_VARCHAR2_TABLE_300
41: , p5_a33 JTF_VARCHAR2_TABLE_300
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p5_a38 JTF_NUMBER_TABLE
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 46: , p5_a38 JTF_NUMBER_TABLE

42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p5_a38 JTF_NUMBER_TABLE
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_VARCHAR2_TABLE_100
49: , p5_a41 JTF_VARCHAR2_TABLE_100
50: , p5_a42 JTF_NUMBER_TABLE

Line 50: , p5_a42 JTF_NUMBER_TABLE

46: , p5_a38 JTF_NUMBER_TABLE
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_VARCHAR2_TABLE_100
49: , p5_a41 JTF_VARCHAR2_TABLE_100
50: , p5_a42 JTF_NUMBER_TABLE
51: , p5_a43 JTF_DATE_TABLE
52: , p6_a0 out nocopy JTF_NUMBER_TABLE
53: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
54: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 52: , p6_a0 out nocopy JTF_NUMBER_TABLE

48: , p5_a40 JTF_VARCHAR2_TABLE_100
49: , p5_a41 JTF_VARCHAR2_TABLE_100
50: , p5_a42 JTF_NUMBER_TABLE
51: , p5_a43 JTF_DATE_TABLE
52: , p6_a0 out nocopy JTF_NUMBER_TABLE
53: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
54: , p6_a2 out nocopy JTF_NUMBER_TABLE
55: , p6_a3 out nocopy JTF_DATE_TABLE
56: , p6_a4 out nocopy JTF_DATE_TABLE

Line 54: , p6_a2 out nocopy JTF_NUMBER_TABLE

50: , p5_a42 JTF_NUMBER_TABLE
51: , p5_a43 JTF_DATE_TABLE
52: , p6_a0 out nocopy JTF_NUMBER_TABLE
53: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
54: , p6_a2 out nocopy JTF_NUMBER_TABLE
55: , p6_a3 out nocopy JTF_DATE_TABLE
56: , p6_a4 out nocopy JTF_DATE_TABLE
57: , p6_a5 out nocopy JTF_DATE_TABLE
58: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , p6_a8 out nocopy JTF_NUMBER_TABLE

56: , p6_a4 out nocopy JTF_DATE_TABLE
57: , p6_a5 out nocopy JTF_DATE_TABLE
58: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
60: , p6_a8 out nocopy JTF_NUMBER_TABLE
61: , p6_a9 out nocopy JTF_NUMBER_TABLE
62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000

Line 61: , p6_a9 out nocopy JTF_NUMBER_TABLE

57: , p6_a5 out nocopy JTF_DATE_TABLE
58: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
60: , p6_a8 out nocopy JTF_NUMBER_TABLE
61: , p6_a9 out nocopy JTF_NUMBER_TABLE
62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 62: , p6_a10 out nocopy JTF_NUMBER_TABLE

58: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
60: , p6_a8 out nocopy JTF_NUMBER_TABLE
61: , p6_a9 out nocopy JTF_NUMBER_TABLE
62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 63: , p6_a11 out nocopy JTF_NUMBER_TABLE

59: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
60: , p6_a8 out nocopy JTF_NUMBER_TABLE
61: , p6_a9 out nocopy JTF_NUMBER_TABLE
62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE
67: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 65: , p6_a13 out nocopy JTF_NUMBER_TABLE

61: , p6_a9 out nocopy JTF_NUMBER_TABLE
62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE
67: , p6_a15 out nocopy JTF_NUMBER_TABLE
68: , p6_a16 out nocopy JTF_NUMBER_TABLE
69: , p6_a17 out nocopy JTF_DATE_TABLE

Line 66: , p6_a14 out nocopy JTF_NUMBER_TABLE

62: , p6_a10 out nocopy JTF_NUMBER_TABLE
63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE
67: , p6_a15 out nocopy JTF_NUMBER_TABLE
68: , p6_a16 out nocopy JTF_NUMBER_TABLE
69: , p6_a17 out nocopy JTF_DATE_TABLE
70: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 67: , p6_a15 out nocopy JTF_NUMBER_TABLE

63: , p6_a11 out nocopy JTF_NUMBER_TABLE
64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE
67: , p6_a15 out nocopy JTF_NUMBER_TABLE
68: , p6_a16 out nocopy JTF_NUMBER_TABLE
69: , p6_a17 out nocopy JTF_DATE_TABLE
70: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
71: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300

Line 68: , p6_a16 out nocopy JTF_NUMBER_TABLE

64: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65: , p6_a13 out nocopy JTF_NUMBER_TABLE
66: , p6_a14 out nocopy JTF_NUMBER_TABLE
67: , p6_a15 out nocopy JTF_NUMBER_TABLE
68: , p6_a16 out nocopy JTF_NUMBER_TABLE
69: , p6_a17 out nocopy JTF_DATE_TABLE
70: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
71: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
72: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300

Line 86: , p6_a34 out nocopy JTF_NUMBER_TABLE

82: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
83: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
84: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
85: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a34 out nocopy JTF_NUMBER_TABLE
87: , p6_a35 out nocopy JTF_DATE_TABLE
88: , p6_a36 out nocopy JTF_NUMBER_TABLE
89: , p6_a37 out nocopy JTF_DATE_TABLE
90: , p6_a38 out nocopy JTF_NUMBER_TABLE

Line 88: , p6_a36 out nocopy JTF_NUMBER_TABLE

84: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
85: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
86: , p6_a34 out nocopy JTF_NUMBER_TABLE
87: , p6_a35 out nocopy JTF_DATE_TABLE
88: , p6_a36 out nocopy JTF_NUMBER_TABLE
89: , p6_a37 out nocopy JTF_DATE_TABLE
90: , p6_a38 out nocopy JTF_NUMBER_TABLE
91: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
92: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , p6_a38 out nocopy JTF_NUMBER_TABLE

86: , p6_a34 out nocopy JTF_NUMBER_TABLE
87: , p6_a35 out nocopy JTF_DATE_TABLE
88: , p6_a36 out nocopy JTF_NUMBER_TABLE
89: , p6_a37 out nocopy JTF_DATE_TABLE
90: , p6_a38 out nocopy JTF_NUMBER_TABLE
91: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
92: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
94: , p6_a42 out nocopy JTF_NUMBER_TABLE

Line 94: , p6_a42 out nocopy JTF_NUMBER_TABLE

90: , p6_a38 out nocopy JTF_NUMBER_TABLE
91: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
92: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
94: , p6_a42 out nocopy JTF_NUMBER_TABLE
95: , p6_a43 out nocopy JTF_DATE_TABLE
96: );
97: procedure insert_prtfl_lines(p_api_version NUMBER
98: , p_init_msg_list VARCHAR2

Line 196: , p5_a0 JTF_NUMBER_TABLE

192: , p_init_msg_list VARCHAR2
193: , x_return_status out nocopy VARCHAR2
194: , x_msg_count out nocopy NUMBER
195: , x_msg_data out nocopy VARCHAR2
196: , p5_a0 JTF_NUMBER_TABLE
197: , p5_a1 JTF_VARCHAR2_TABLE_300
198: , p5_a2 JTF_NUMBER_TABLE
199: , p5_a3 JTF_DATE_TABLE
200: , p5_a4 JTF_DATE_TABLE

Line 198: , p5_a2 JTF_NUMBER_TABLE

194: , x_msg_count out nocopy NUMBER
195: , x_msg_data out nocopy VARCHAR2
196: , p5_a0 JTF_NUMBER_TABLE
197: , p5_a1 JTF_VARCHAR2_TABLE_300
198: , p5_a2 JTF_NUMBER_TABLE
199: , p5_a3 JTF_DATE_TABLE
200: , p5_a4 JTF_DATE_TABLE
201: , p5_a5 JTF_DATE_TABLE
202: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 204: , p5_a8 JTF_NUMBER_TABLE

200: , p5_a4 JTF_DATE_TABLE
201: , p5_a5 JTF_DATE_TABLE
202: , p5_a6 JTF_VARCHAR2_TABLE_100
203: , p5_a7 JTF_VARCHAR2_TABLE_100
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000

Line 205: , p5_a9 JTF_NUMBER_TABLE

201: , p5_a5 JTF_DATE_TABLE
202: , p5_a6 JTF_VARCHAR2_TABLE_100
203: , p5_a7 JTF_VARCHAR2_TABLE_100
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE

Line 206: , p5_a10 JTF_NUMBER_TABLE

202: , p5_a6 JTF_VARCHAR2_TABLE_100
203: , p5_a7 JTF_VARCHAR2_TABLE_100
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE

Line 207: , p5_a11 JTF_NUMBER_TABLE

203: , p5_a7 JTF_VARCHAR2_TABLE_100
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE
211: , p5_a15 JTF_NUMBER_TABLE

Line 209: , p5_a13 JTF_NUMBER_TABLE

205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE
211: , p5_a15 JTF_NUMBER_TABLE
212: , p5_a16 JTF_NUMBER_TABLE
213: , p5_a17 JTF_DATE_TABLE

Line 210: , p5_a14 JTF_NUMBER_TABLE

206: , p5_a10 JTF_NUMBER_TABLE
207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE
211: , p5_a15 JTF_NUMBER_TABLE
212: , p5_a16 JTF_NUMBER_TABLE
213: , p5_a17 JTF_DATE_TABLE
214: , p5_a18 JTF_VARCHAR2_TABLE_300

Line 211: , p5_a15 JTF_NUMBER_TABLE

207: , p5_a11 JTF_NUMBER_TABLE
208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE
211: , p5_a15 JTF_NUMBER_TABLE
212: , p5_a16 JTF_NUMBER_TABLE
213: , p5_a17 JTF_DATE_TABLE
214: , p5_a18 JTF_VARCHAR2_TABLE_300
215: , p5_a19 JTF_VARCHAR2_TABLE_300

Line 212: , p5_a16 JTF_NUMBER_TABLE

208: , p5_a12 JTF_VARCHAR2_TABLE_2000
209: , p5_a13 JTF_NUMBER_TABLE
210: , p5_a14 JTF_NUMBER_TABLE
211: , p5_a15 JTF_NUMBER_TABLE
212: , p5_a16 JTF_NUMBER_TABLE
213: , p5_a17 JTF_DATE_TABLE
214: , p5_a18 JTF_VARCHAR2_TABLE_300
215: , p5_a19 JTF_VARCHAR2_TABLE_300
216: , p5_a20 JTF_VARCHAR2_TABLE_300

Line 230: , p5_a34 JTF_NUMBER_TABLE

226: , p5_a30 JTF_VARCHAR2_TABLE_300
227: , p5_a31 JTF_VARCHAR2_TABLE_300
228: , p5_a32 JTF_VARCHAR2_TABLE_300
229: , p5_a33 JTF_VARCHAR2_TABLE_300
230: , p5_a34 JTF_NUMBER_TABLE
231: , p5_a35 JTF_DATE_TABLE
232: , p5_a36 JTF_NUMBER_TABLE
233: , p5_a37 JTF_DATE_TABLE
234: , p5_a38 JTF_NUMBER_TABLE

Line 232: , p5_a36 JTF_NUMBER_TABLE

228: , p5_a32 JTF_VARCHAR2_TABLE_300
229: , p5_a33 JTF_VARCHAR2_TABLE_300
230: , p5_a34 JTF_NUMBER_TABLE
231: , p5_a35 JTF_DATE_TABLE
232: , p5_a36 JTF_NUMBER_TABLE
233: , p5_a37 JTF_DATE_TABLE
234: , p5_a38 JTF_NUMBER_TABLE
235: , p5_a39 JTF_VARCHAR2_TABLE_100
236: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 234: , p5_a38 JTF_NUMBER_TABLE

230: , p5_a34 JTF_NUMBER_TABLE
231: , p5_a35 JTF_DATE_TABLE
232: , p5_a36 JTF_NUMBER_TABLE
233: , p5_a37 JTF_DATE_TABLE
234: , p5_a38 JTF_NUMBER_TABLE
235: , p5_a39 JTF_VARCHAR2_TABLE_100
236: , p5_a40 JTF_VARCHAR2_TABLE_100
237: , p5_a41 JTF_VARCHAR2_TABLE_100
238: , p5_a42 JTF_NUMBER_TABLE

Line 238: , p5_a42 JTF_NUMBER_TABLE

234: , p5_a38 JTF_NUMBER_TABLE
235: , p5_a39 JTF_VARCHAR2_TABLE_100
236: , p5_a40 JTF_VARCHAR2_TABLE_100
237: , p5_a41 JTF_VARCHAR2_TABLE_100
238: , p5_a42 JTF_NUMBER_TABLE
239: , p5_a43 JTF_DATE_TABLE
240: );
241: procedure lock_prtfl_lines(p_api_version NUMBER
242: , p_init_msg_list VARCHAR2

Line 296: , p5_a0 JTF_NUMBER_TABLE

292: , p_init_msg_list VARCHAR2
293: , x_return_status out nocopy VARCHAR2
294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_VARCHAR2_TABLE_300
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_DATE_TABLE
300: , p5_a4 JTF_DATE_TABLE

Line 298: , p5_a2 JTF_NUMBER_TABLE

294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_VARCHAR2_TABLE_300
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_DATE_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_DATE_TABLE
302: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 304: , p5_a8 JTF_NUMBER_TABLE

300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_DATE_TABLE
302: , p5_a6 JTF_VARCHAR2_TABLE_100
303: , p5_a7 JTF_VARCHAR2_TABLE_100
304: , p5_a8 JTF_NUMBER_TABLE
305: , p5_a9 JTF_NUMBER_TABLE
306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000

Line 305: , p5_a9 JTF_NUMBER_TABLE

301: , p5_a5 JTF_DATE_TABLE
302: , p5_a6 JTF_VARCHAR2_TABLE_100
303: , p5_a7 JTF_VARCHAR2_TABLE_100
304: , p5_a8 JTF_NUMBER_TABLE
305: , p5_a9 JTF_NUMBER_TABLE
306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE

Line 306: , p5_a10 JTF_NUMBER_TABLE

302: , p5_a6 JTF_VARCHAR2_TABLE_100
303: , p5_a7 JTF_VARCHAR2_TABLE_100
304: , p5_a8 JTF_NUMBER_TABLE
305: , p5_a9 JTF_NUMBER_TABLE
306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE

Line 307: , p5_a11 JTF_NUMBER_TABLE

303: , p5_a7 JTF_VARCHAR2_TABLE_100
304: , p5_a8 JTF_NUMBER_TABLE
305: , p5_a9 JTF_NUMBER_TABLE
306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE
311: , p5_a15 JTF_NUMBER_TABLE

Line 309: , p5_a13 JTF_NUMBER_TABLE

305: , p5_a9 JTF_NUMBER_TABLE
306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_NUMBER_TABLE
313: , p5_a17 JTF_DATE_TABLE

Line 310: , p5_a14 JTF_NUMBER_TABLE

306: , p5_a10 JTF_NUMBER_TABLE
307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_NUMBER_TABLE
313: , p5_a17 JTF_DATE_TABLE
314: , p5_a18 JTF_VARCHAR2_TABLE_300

Line 311: , p5_a15 JTF_NUMBER_TABLE

307: , p5_a11 JTF_NUMBER_TABLE
308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_NUMBER_TABLE
313: , p5_a17 JTF_DATE_TABLE
314: , p5_a18 JTF_VARCHAR2_TABLE_300
315: , p5_a19 JTF_VARCHAR2_TABLE_300

Line 312: , p5_a16 JTF_NUMBER_TABLE

308: , p5_a12 JTF_VARCHAR2_TABLE_2000
309: , p5_a13 JTF_NUMBER_TABLE
310: , p5_a14 JTF_NUMBER_TABLE
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_NUMBER_TABLE
313: , p5_a17 JTF_DATE_TABLE
314: , p5_a18 JTF_VARCHAR2_TABLE_300
315: , p5_a19 JTF_VARCHAR2_TABLE_300
316: , p5_a20 JTF_VARCHAR2_TABLE_300

Line 330: , p5_a34 JTF_NUMBER_TABLE

326: , p5_a30 JTF_VARCHAR2_TABLE_300
327: , p5_a31 JTF_VARCHAR2_TABLE_300
328: , p5_a32 JTF_VARCHAR2_TABLE_300
329: , p5_a33 JTF_VARCHAR2_TABLE_300
330: , p5_a34 JTF_NUMBER_TABLE
331: , p5_a35 JTF_DATE_TABLE
332: , p5_a36 JTF_NUMBER_TABLE
333: , p5_a37 JTF_DATE_TABLE
334: , p5_a38 JTF_NUMBER_TABLE

Line 332: , p5_a36 JTF_NUMBER_TABLE

328: , p5_a32 JTF_VARCHAR2_TABLE_300
329: , p5_a33 JTF_VARCHAR2_TABLE_300
330: , p5_a34 JTF_NUMBER_TABLE
331: , p5_a35 JTF_DATE_TABLE
332: , p5_a36 JTF_NUMBER_TABLE
333: , p5_a37 JTF_DATE_TABLE
334: , p5_a38 JTF_NUMBER_TABLE
335: , p5_a39 JTF_VARCHAR2_TABLE_100
336: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 334: , p5_a38 JTF_NUMBER_TABLE

330: , p5_a34 JTF_NUMBER_TABLE
331: , p5_a35 JTF_DATE_TABLE
332: , p5_a36 JTF_NUMBER_TABLE
333: , p5_a37 JTF_DATE_TABLE
334: , p5_a38 JTF_NUMBER_TABLE
335: , p5_a39 JTF_VARCHAR2_TABLE_100
336: , p5_a40 JTF_VARCHAR2_TABLE_100
337: , p5_a41 JTF_VARCHAR2_TABLE_100
338: , p5_a42 JTF_NUMBER_TABLE

Line 338: , p5_a42 JTF_NUMBER_TABLE

334: , p5_a38 JTF_NUMBER_TABLE
335: , p5_a39 JTF_VARCHAR2_TABLE_100
336: , p5_a40 JTF_VARCHAR2_TABLE_100
337: , p5_a41 JTF_VARCHAR2_TABLE_100
338: , p5_a42 JTF_NUMBER_TABLE
339: , p5_a43 JTF_DATE_TABLE
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 340: , p6_a0 out nocopy JTF_NUMBER_TABLE

336: , p5_a40 JTF_VARCHAR2_TABLE_100
337: , p5_a41 JTF_VARCHAR2_TABLE_100
338: , p5_a42 JTF_NUMBER_TABLE
339: , p5_a43 JTF_DATE_TABLE
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a2 out nocopy JTF_NUMBER_TABLE
343: , p6_a3 out nocopy JTF_DATE_TABLE
344: , p6_a4 out nocopy JTF_DATE_TABLE

Line 342: , p6_a2 out nocopy JTF_NUMBER_TABLE

338: , p5_a42 JTF_NUMBER_TABLE
339: , p5_a43 JTF_DATE_TABLE
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a2 out nocopy JTF_NUMBER_TABLE
343: , p6_a3 out nocopy JTF_DATE_TABLE
344: , p6_a4 out nocopy JTF_DATE_TABLE
345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 348: , p6_a8 out nocopy JTF_NUMBER_TABLE

344: , p6_a4 out nocopy JTF_DATE_TABLE
345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
347: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_NUMBER_TABLE
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000

Line 349: , p6_a9 out nocopy JTF_NUMBER_TABLE

345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
347: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_NUMBER_TABLE
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 350: , p6_a10 out nocopy JTF_NUMBER_TABLE

346: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
347: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_NUMBER_TABLE
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 351: , p6_a11 out nocopy JTF_NUMBER_TABLE

347: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_NUMBER_TABLE
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE
355: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 353: , p6_a13 out nocopy JTF_NUMBER_TABLE

349: , p6_a9 out nocopy JTF_NUMBER_TABLE
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE
355: , p6_a15 out nocopy JTF_NUMBER_TABLE
356: , p6_a16 out nocopy JTF_NUMBER_TABLE
357: , p6_a17 out nocopy JTF_DATE_TABLE

Line 354: , p6_a14 out nocopy JTF_NUMBER_TABLE

350: , p6_a10 out nocopy JTF_NUMBER_TABLE
351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE
355: , p6_a15 out nocopy JTF_NUMBER_TABLE
356: , p6_a16 out nocopy JTF_NUMBER_TABLE
357: , p6_a17 out nocopy JTF_DATE_TABLE
358: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 355: , p6_a15 out nocopy JTF_NUMBER_TABLE

351: , p6_a11 out nocopy JTF_NUMBER_TABLE
352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE
355: , p6_a15 out nocopy JTF_NUMBER_TABLE
356: , p6_a16 out nocopy JTF_NUMBER_TABLE
357: , p6_a17 out nocopy JTF_DATE_TABLE
358: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
359: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300

Line 356: , p6_a16 out nocopy JTF_NUMBER_TABLE

352: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353: , p6_a13 out nocopy JTF_NUMBER_TABLE
354: , p6_a14 out nocopy JTF_NUMBER_TABLE
355: , p6_a15 out nocopy JTF_NUMBER_TABLE
356: , p6_a16 out nocopy JTF_NUMBER_TABLE
357: , p6_a17 out nocopy JTF_DATE_TABLE
358: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
359: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
360: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300

Line 374: , p6_a34 out nocopy JTF_NUMBER_TABLE

370: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
371: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
372: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
373: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
374: , p6_a34 out nocopy JTF_NUMBER_TABLE
375: , p6_a35 out nocopy JTF_DATE_TABLE
376: , p6_a36 out nocopy JTF_NUMBER_TABLE
377: , p6_a37 out nocopy JTF_DATE_TABLE
378: , p6_a38 out nocopy JTF_NUMBER_TABLE

Line 376: , p6_a36 out nocopy JTF_NUMBER_TABLE

372: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
373: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
374: , p6_a34 out nocopy JTF_NUMBER_TABLE
375: , p6_a35 out nocopy JTF_DATE_TABLE
376: , p6_a36 out nocopy JTF_NUMBER_TABLE
377: , p6_a37 out nocopy JTF_DATE_TABLE
378: , p6_a38 out nocopy JTF_NUMBER_TABLE
379: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 378: , p6_a38 out nocopy JTF_NUMBER_TABLE

374: , p6_a34 out nocopy JTF_NUMBER_TABLE
375: , p6_a35 out nocopy JTF_DATE_TABLE
376: , p6_a36 out nocopy JTF_NUMBER_TABLE
377: , p6_a37 out nocopy JTF_DATE_TABLE
378: , p6_a38 out nocopy JTF_NUMBER_TABLE
379: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
381: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
382: , p6_a42 out nocopy JTF_NUMBER_TABLE

Line 382: , p6_a42 out nocopy JTF_NUMBER_TABLE

378: , p6_a38 out nocopy JTF_NUMBER_TABLE
379: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
381: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
382: , p6_a42 out nocopy JTF_NUMBER_TABLE
383: , p6_a43 out nocopy JTF_DATE_TABLE
384: );
385: procedure update_prtfl_lines(p_api_version NUMBER
386: , p_init_msg_list VARCHAR2

Line 484: , p5_a0 JTF_NUMBER_TABLE

480: , p_init_msg_list VARCHAR2
481: , x_return_status out nocopy VARCHAR2
482: , x_msg_count out nocopy NUMBER
483: , x_msg_data out nocopy VARCHAR2
484: , p5_a0 JTF_NUMBER_TABLE
485: , p5_a1 JTF_VARCHAR2_TABLE_300
486: , p5_a2 JTF_NUMBER_TABLE
487: , p5_a3 JTF_DATE_TABLE
488: , p5_a4 JTF_DATE_TABLE

Line 486: , p5_a2 JTF_NUMBER_TABLE

482: , x_msg_count out nocopy NUMBER
483: , x_msg_data out nocopy VARCHAR2
484: , p5_a0 JTF_NUMBER_TABLE
485: , p5_a1 JTF_VARCHAR2_TABLE_300
486: , p5_a2 JTF_NUMBER_TABLE
487: , p5_a3 JTF_DATE_TABLE
488: , p5_a4 JTF_DATE_TABLE
489: , p5_a5 JTF_DATE_TABLE
490: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 492: , p5_a8 JTF_NUMBER_TABLE

488: , p5_a4 JTF_DATE_TABLE
489: , p5_a5 JTF_DATE_TABLE
490: , p5_a6 JTF_VARCHAR2_TABLE_100
491: , p5_a7 JTF_VARCHAR2_TABLE_100
492: , p5_a8 JTF_NUMBER_TABLE
493: , p5_a9 JTF_NUMBER_TABLE
494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000

Line 493: , p5_a9 JTF_NUMBER_TABLE

489: , p5_a5 JTF_DATE_TABLE
490: , p5_a6 JTF_VARCHAR2_TABLE_100
491: , p5_a7 JTF_VARCHAR2_TABLE_100
492: , p5_a8 JTF_NUMBER_TABLE
493: , p5_a9 JTF_NUMBER_TABLE
494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE

Line 494: , p5_a10 JTF_NUMBER_TABLE

490: , p5_a6 JTF_VARCHAR2_TABLE_100
491: , p5_a7 JTF_VARCHAR2_TABLE_100
492: , p5_a8 JTF_NUMBER_TABLE
493: , p5_a9 JTF_NUMBER_TABLE
494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE

Line 495: , p5_a11 JTF_NUMBER_TABLE

491: , p5_a7 JTF_VARCHAR2_TABLE_100
492: , p5_a8 JTF_NUMBER_TABLE
493: , p5_a9 JTF_NUMBER_TABLE
494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE
499: , p5_a15 JTF_NUMBER_TABLE

Line 497: , p5_a13 JTF_NUMBER_TABLE

493: , p5_a9 JTF_NUMBER_TABLE
494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE
499: , p5_a15 JTF_NUMBER_TABLE
500: , p5_a16 JTF_NUMBER_TABLE
501: , p5_a17 JTF_DATE_TABLE

Line 498: , p5_a14 JTF_NUMBER_TABLE

494: , p5_a10 JTF_NUMBER_TABLE
495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE
499: , p5_a15 JTF_NUMBER_TABLE
500: , p5_a16 JTF_NUMBER_TABLE
501: , p5_a17 JTF_DATE_TABLE
502: , p5_a18 JTF_VARCHAR2_TABLE_300

Line 499: , p5_a15 JTF_NUMBER_TABLE

495: , p5_a11 JTF_NUMBER_TABLE
496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE
499: , p5_a15 JTF_NUMBER_TABLE
500: , p5_a16 JTF_NUMBER_TABLE
501: , p5_a17 JTF_DATE_TABLE
502: , p5_a18 JTF_VARCHAR2_TABLE_300
503: , p5_a19 JTF_VARCHAR2_TABLE_300

Line 500: , p5_a16 JTF_NUMBER_TABLE

496: , p5_a12 JTF_VARCHAR2_TABLE_2000
497: , p5_a13 JTF_NUMBER_TABLE
498: , p5_a14 JTF_NUMBER_TABLE
499: , p5_a15 JTF_NUMBER_TABLE
500: , p5_a16 JTF_NUMBER_TABLE
501: , p5_a17 JTF_DATE_TABLE
502: , p5_a18 JTF_VARCHAR2_TABLE_300
503: , p5_a19 JTF_VARCHAR2_TABLE_300
504: , p5_a20 JTF_VARCHAR2_TABLE_300

Line 518: , p5_a34 JTF_NUMBER_TABLE

514: , p5_a30 JTF_VARCHAR2_TABLE_300
515: , p5_a31 JTF_VARCHAR2_TABLE_300
516: , p5_a32 JTF_VARCHAR2_TABLE_300
517: , p5_a33 JTF_VARCHAR2_TABLE_300
518: , p5_a34 JTF_NUMBER_TABLE
519: , p5_a35 JTF_DATE_TABLE
520: , p5_a36 JTF_NUMBER_TABLE
521: , p5_a37 JTF_DATE_TABLE
522: , p5_a38 JTF_NUMBER_TABLE

Line 520: , p5_a36 JTF_NUMBER_TABLE

516: , p5_a32 JTF_VARCHAR2_TABLE_300
517: , p5_a33 JTF_VARCHAR2_TABLE_300
518: , p5_a34 JTF_NUMBER_TABLE
519: , p5_a35 JTF_DATE_TABLE
520: , p5_a36 JTF_NUMBER_TABLE
521: , p5_a37 JTF_DATE_TABLE
522: , p5_a38 JTF_NUMBER_TABLE
523: , p5_a39 JTF_VARCHAR2_TABLE_100
524: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 522: , p5_a38 JTF_NUMBER_TABLE

518: , p5_a34 JTF_NUMBER_TABLE
519: , p5_a35 JTF_DATE_TABLE
520: , p5_a36 JTF_NUMBER_TABLE
521: , p5_a37 JTF_DATE_TABLE
522: , p5_a38 JTF_NUMBER_TABLE
523: , p5_a39 JTF_VARCHAR2_TABLE_100
524: , p5_a40 JTF_VARCHAR2_TABLE_100
525: , p5_a41 JTF_VARCHAR2_TABLE_100
526: , p5_a42 JTF_NUMBER_TABLE

Line 526: , p5_a42 JTF_NUMBER_TABLE

522: , p5_a38 JTF_NUMBER_TABLE
523: , p5_a39 JTF_VARCHAR2_TABLE_100
524: , p5_a40 JTF_VARCHAR2_TABLE_100
525: , p5_a41 JTF_VARCHAR2_TABLE_100
526: , p5_a42 JTF_NUMBER_TABLE
527: , p5_a43 JTF_DATE_TABLE
528: );
529: procedure delete_prtfl_lines(p_api_version NUMBER
530: , p_init_msg_list VARCHAR2

Line 584: , p5_a0 JTF_NUMBER_TABLE

580: , p_init_msg_list VARCHAR2
581: , x_return_status out nocopy VARCHAR2
582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
584: , p5_a0 JTF_NUMBER_TABLE
585: , p5_a1 JTF_VARCHAR2_TABLE_300
586: , p5_a2 JTF_NUMBER_TABLE
587: , p5_a3 JTF_DATE_TABLE
588: , p5_a4 JTF_DATE_TABLE

Line 586: , p5_a2 JTF_NUMBER_TABLE

582: , x_msg_count out nocopy NUMBER
583: , x_msg_data out nocopy VARCHAR2
584: , p5_a0 JTF_NUMBER_TABLE
585: , p5_a1 JTF_VARCHAR2_TABLE_300
586: , p5_a2 JTF_NUMBER_TABLE
587: , p5_a3 JTF_DATE_TABLE
588: , p5_a4 JTF_DATE_TABLE
589: , p5_a5 JTF_DATE_TABLE
590: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 592: , p5_a8 JTF_NUMBER_TABLE

588: , p5_a4 JTF_DATE_TABLE
589: , p5_a5 JTF_DATE_TABLE
590: , p5_a6 JTF_VARCHAR2_TABLE_100
591: , p5_a7 JTF_VARCHAR2_TABLE_100
592: , p5_a8 JTF_NUMBER_TABLE
593: , p5_a9 JTF_NUMBER_TABLE
594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000

Line 593: , p5_a9 JTF_NUMBER_TABLE

589: , p5_a5 JTF_DATE_TABLE
590: , p5_a6 JTF_VARCHAR2_TABLE_100
591: , p5_a7 JTF_VARCHAR2_TABLE_100
592: , p5_a8 JTF_NUMBER_TABLE
593: , p5_a9 JTF_NUMBER_TABLE
594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE

Line 594: , p5_a10 JTF_NUMBER_TABLE

590: , p5_a6 JTF_VARCHAR2_TABLE_100
591: , p5_a7 JTF_VARCHAR2_TABLE_100
592: , p5_a8 JTF_NUMBER_TABLE
593: , p5_a9 JTF_NUMBER_TABLE
594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE

Line 595: , p5_a11 JTF_NUMBER_TABLE

591: , p5_a7 JTF_VARCHAR2_TABLE_100
592: , p5_a8 JTF_NUMBER_TABLE
593: , p5_a9 JTF_NUMBER_TABLE
594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE
599: , p5_a15 JTF_NUMBER_TABLE

Line 597: , p5_a13 JTF_NUMBER_TABLE

593: , p5_a9 JTF_NUMBER_TABLE
594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE
599: , p5_a15 JTF_NUMBER_TABLE
600: , p5_a16 JTF_NUMBER_TABLE
601: , p5_a17 JTF_DATE_TABLE

Line 598: , p5_a14 JTF_NUMBER_TABLE

594: , p5_a10 JTF_NUMBER_TABLE
595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE
599: , p5_a15 JTF_NUMBER_TABLE
600: , p5_a16 JTF_NUMBER_TABLE
601: , p5_a17 JTF_DATE_TABLE
602: , p5_a18 JTF_VARCHAR2_TABLE_300

Line 599: , p5_a15 JTF_NUMBER_TABLE

595: , p5_a11 JTF_NUMBER_TABLE
596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE
599: , p5_a15 JTF_NUMBER_TABLE
600: , p5_a16 JTF_NUMBER_TABLE
601: , p5_a17 JTF_DATE_TABLE
602: , p5_a18 JTF_VARCHAR2_TABLE_300
603: , p5_a19 JTF_VARCHAR2_TABLE_300

Line 600: , p5_a16 JTF_NUMBER_TABLE

596: , p5_a12 JTF_VARCHAR2_TABLE_2000
597: , p5_a13 JTF_NUMBER_TABLE
598: , p5_a14 JTF_NUMBER_TABLE
599: , p5_a15 JTF_NUMBER_TABLE
600: , p5_a16 JTF_NUMBER_TABLE
601: , p5_a17 JTF_DATE_TABLE
602: , p5_a18 JTF_VARCHAR2_TABLE_300
603: , p5_a19 JTF_VARCHAR2_TABLE_300
604: , p5_a20 JTF_VARCHAR2_TABLE_300

Line 618: , p5_a34 JTF_NUMBER_TABLE

614: , p5_a30 JTF_VARCHAR2_TABLE_300
615: , p5_a31 JTF_VARCHAR2_TABLE_300
616: , p5_a32 JTF_VARCHAR2_TABLE_300
617: , p5_a33 JTF_VARCHAR2_TABLE_300
618: , p5_a34 JTF_NUMBER_TABLE
619: , p5_a35 JTF_DATE_TABLE
620: , p5_a36 JTF_NUMBER_TABLE
621: , p5_a37 JTF_DATE_TABLE
622: , p5_a38 JTF_NUMBER_TABLE

Line 620: , p5_a36 JTF_NUMBER_TABLE

616: , p5_a32 JTF_VARCHAR2_TABLE_300
617: , p5_a33 JTF_VARCHAR2_TABLE_300
618: , p5_a34 JTF_NUMBER_TABLE
619: , p5_a35 JTF_DATE_TABLE
620: , p5_a36 JTF_NUMBER_TABLE
621: , p5_a37 JTF_DATE_TABLE
622: , p5_a38 JTF_NUMBER_TABLE
623: , p5_a39 JTF_VARCHAR2_TABLE_100
624: , p5_a40 JTF_VARCHAR2_TABLE_100

Line 622: , p5_a38 JTF_NUMBER_TABLE

618: , p5_a34 JTF_NUMBER_TABLE
619: , p5_a35 JTF_DATE_TABLE
620: , p5_a36 JTF_NUMBER_TABLE
621: , p5_a37 JTF_DATE_TABLE
622: , p5_a38 JTF_NUMBER_TABLE
623: , p5_a39 JTF_VARCHAR2_TABLE_100
624: , p5_a40 JTF_VARCHAR2_TABLE_100
625: , p5_a41 JTF_VARCHAR2_TABLE_100
626: , p5_a42 JTF_NUMBER_TABLE

Line 626: , p5_a42 JTF_NUMBER_TABLE

622: , p5_a38 JTF_NUMBER_TABLE
623: , p5_a39 JTF_VARCHAR2_TABLE_100
624: , p5_a40 JTF_VARCHAR2_TABLE_100
625: , p5_a41 JTF_VARCHAR2_TABLE_100
626: , p5_a42 JTF_NUMBER_TABLE
627: , p5_a43 JTF_DATE_TABLE
628: );
629: procedure validate_prtfl_lines(p_api_version NUMBER
630: , p_init_msg_list VARCHAR2