APPS.OKL_SRS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_srs_pvt_w as
2: /* $Header: OKLISRSS.pls 120.1 2005/07/15 07:39:22 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_srs_pvt_w as
2: /* $Header: OKLISRSS.pls 120.1 2005/07/15 07:39:22 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_200
35: , a2 out nocopy JTF_NUMBER_TABLE

Line 33: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_200
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 35: , a2 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_200
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_200
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 39: , a6 out nocopy JTF_NUMBER_TABLE

35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500
44: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 56: , a23 out nocopy JTF_NUMBER_TABLE

52: , a19 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE

Line 57: , a24 out nocopy JTF_NUMBER_TABLE

53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE

Line 58: , a25 out nocopy JTF_NUMBER_TABLE

54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );

Line 61: , a28 out nocopy JTF_NUMBER_TABLE

57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_200

Line 64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE

60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_200
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_NUMBER_TABLE

Line 66: , a2 JTF_NUMBER_TABLE

62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_200
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_NUMBER_TABLE

Line 68: , a4 JTF_NUMBER_TABLE

64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_200
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_500

Line 70: , a6 JTF_NUMBER_TABLE

66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_500
73: , a9 JTF_VARCHAR2_TABLE_500
74: , a10 JTF_VARCHAR2_TABLE_500

Line 71: , a7 JTF_NUMBER_TABLE

67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_500
73: , a9 JTF_VARCHAR2_TABLE_500
74: , a10 JTF_VARCHAR2_TABLE_500
75: , a11 JTF_VARCHAR2_TABLE_500

Line 87: , a23 JTF_NUMBER_TABLE

83: , a19 JTF_VARCHAR2_TABLE_500
84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE

Line 88: , a24 JTF_NUMBER_TABLE

84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE

Line 89: , a25 JTF_NUMBER_TABLE

85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );

Line 92: , a28 JTF_NUMBER_TABLE

88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_NUMBER_TABLE

Line 94: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_NUMBER_TABLE

Line 96: , a2 out nocopy JTF_NUMBER_TABLE

92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_NUMBER_TABLE

Line 98: , a4 out nocopy JTF_NUMBER_TABLE

94: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_NUMBER_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 100: , a6 out nocopy JTF_NUMBER_TABLE

96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_NUMBER_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500
103: , a9 out nocopy JTF_VARCHAR2_TABLE_500
104: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a7 out nocopy JTF_NUMBER_TABLE

97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_NUMBER_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500
103: , a9 out nocopy JTF_VARCHAR2_TABLE_500
104: , a10 out nocopy JTF_VARCHAR2_TABLE_500
105: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 117: , a23 out nocopy JTF_NUMBER_TABLE

113: , a19 out nocopy JTF_VARCHAR2_TABLE_500
114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE

Line 118: , a24 out nocopy JTF_NUMBER_TABLE

114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE

Line 119: , a25 out nocopy JTF_NUMBER_TABLE

115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );

Line 122: , a28 out nocopy JTF_NUMBER_TABLE

118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );
124:
125: procedure insert_row(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2

Line 194: , p5_a0 JTF_NUMBER_TABLE

190: , p_init_msg_list VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_VARCHAR2_TABLE_200
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_NUMBER_TABLE

Line 196: , p5_a2 JTF_NUMBER_TABLE

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

Line 198: , p5_a4 JTF_NUMBER_TABLE

194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_VARCHAR2_TABLE_200
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_NUMBER_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_NUMBER_TABLE
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 200: , p5_a6 JTF_NUMBER_TABLE

196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_NUMBER_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_NUMBER_TABLE
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_500
203: , p5_a9 JTF_VARCHAR2_TABLE_500
204: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 201: , p5_a7 JTF_NUMBER_TABLE

197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_NUMBER_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_NUMBER_TABLE
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_500
203: , p5_a9 JTF_VARCHAR2_TABLE_500
204: , p5_a10 JTF_VARCHAR2_TABLE_500
205: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 217: , p5_a23 JTF_NUMBER_TABLE

213: , p5_a19 JTF_VARCHAR2_TABLE_500
214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE

Line 218: , p5_a24 JTF_NUMBER_TABLE

214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE

Line 219: , p5_a25 JTF_NUMBER_TABLE

215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 222: , p5_a28 JTF_NUMBER_TABLE

218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 223: , p6_a0 out nocopy JTF_NUMBER_TABLE

219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 225: , p6_a2 out nocopy JTF_NUMBER_TABLE

221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_NUMBER_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 227: , p6_a4 out nocopy JTF_NUMBER_TABLE

223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_NUMBER_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_NUMBER_TABLE
230: , p6_a7 out nocopy JTF_NUMBER_TABLE
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 229: , p6_a6 out nocopy JTF_NUMBER_TABLE

225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_NUMBER_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_NUMBER_TABLE
230: , p6_a7 out nocopy JTF_NUMBER_TABLE
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
233: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 230: , p6_a7 out nocopy JTF_NUMBER_TABLE

226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_NUMBER_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_NUMBER_TABLE
230: , p6_a7 out nocopy JTF_NUMBER_TABLE
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
233: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
234: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 246: , p6_a23 out nocopy JTF_NUMBER_TABLE

242: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE

Line 247: , p6_a24 out nocopy JTF_NUMBER_TABLE

243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 248: , p6_a25 out nocopy JTF_NUMBER_TABLE

244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );

Line 251: , p6_a28 out nocopy JTF_NUMBER_TABLE

247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );
253: procedure lock_row(p_api_version NUMBER
254: , p_init_msg_list VARCHAR2
255: , x_return_status out nocopy VARCHAR2

Line 293: , p5_a0 JTF_NUMBER_TABLE

289: , p_init_msg_list VARCHAR2
290: , x_return_status out nocopy VARCHAR2
291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2
293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_200
295: , p5_a2 JTF_NUMBER_TABLE
296: , p5_a3 JTF_VARCHAR2_TABLE_100
297: , p5_a4 JTF_NUMBER_TABLE

Line 295: , p5_a2 JTF_NUMBER_TABLE

291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2
293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_200
295: , p5_a2 JTF_NUMBER_TABLE
296: , p5_a3 JTF_VARCHAR2_TABLE_100
297: , p5_a4 JTF_NUMBER_TABLE
298: , p5_a5 JTF_DATE_TABLE
299: , p5_a6 JTF_NUMBER_TABLE

Line 297: , p5_a4 JTF_NUMBER_TABLE

293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_200
295: , p5_a2 JTF_NUMBER_TABLE
296: , p5_a3 JTF_VARCHAR2_TABLE_100
297: , p5_a4 JTF_NUMBER_TABLE
298: , p5_a5 JTF_DATE_TABLE
299: , p5_a6 JTF_NUMBER_TABLE
300: , p5_a7 JTF_NUMBER_TABLE
301: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 299: , p5_a6 JTF_NUMBER_TABLE

295: , p5_a2 JTF_NUMBER_TABLE
296: , p5_a3 JTF_VARCHAR2_TABLE_100
297: , p5_a4 JTF_NUMBER_TABLE
298: , p5_a5 JTF_DATE_TABLE
299: , p5_a6 JTF_NUMBER_TABLE
300: , p5_a7 JTF_NUMBER_TABLE
301: , p5_a8 JTF_VARCHAR2_TABLE_500
302: , p5_a9 JTF_VARCHAR2_TABLE_500
303: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 300: , p5_a7 JTF_NUMBER_TABLE

296: , p5_a3 JTF_VARCHAR2_TABLE_100
297: , p5_a4 JTF_NUMBER_TABLE
298: , p5_a5 JTF_DATE_TABLE
299: , p5_a6 JTF_NUMBER_TABLE
300: , p5_a7 JTF_NUMBER_TABLE
301: , p5_a8 JTF_VARCHAR2_TABLE_500
302: , p5_a9 JTF_VARCHAR2_TABLE_500
303: , p5_a10 JTF_VARCHAR2_TABLE_500
304: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 316: , p5_a23 JTF_NUMBER_TABLE

312: , p5_a19 JTF_VARCHAR2_TABLE_500
313: , p5_a20 JTF_VARCHAR2_TABLE_500
314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE

Line 317: , p5_a24 JTF_NUMBER_TABLE

313: , p5_a20 JTF_VARCHAR2_TABLE_500
314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE

Line 318: , p5_a25 JTF_NUMBER_TABLE

314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE
322: );

Line 321: , p5_a28 JTF_NUMBER_TABLE

317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE
322: );
323: procedure update_row(p_api_version NUMBER
324: , p_init_msg_list VARCHAR2
325: , x_return_status out nocopy VARCHAR2

Line 392: , p5_a0 JTF_NUMBER_TABLE

388: , p_init_msg_list VARCHAR2
389: , x_return_status out nocopy VARCHAR2
390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_VARCHAR2_TABLE_200
394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_NUMBER_TABLE

Line 394: , p5_a2 JTF_NUMBER_TABLE

390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_VARCHAR2_TABLE_200
394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_NUMBER_TABLE
397: , p5_a5 JTF_DATE_TABLE
398: , p5_a6 JTF_NUMBER_TABLE

Line 396: , p5_a4 JTF_NUMBER_TABLE

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

Line 398: , p5_a6 JTF_NUMBER_TABLE

394: , p5_a2 JTF_NUMBER_TABLE
395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_NUMBER_TABLE
397: , p5_a5 JTF_DATE_TABLE
398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_NUMBER_TABLE
400: , p5_a8 JTF_VARCHAR2_TABLE_500
401: , p5_a9 JTF_VARCHAR2_TABLE_500
402: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 399: , p5_a7 JTF_NUMBER_TABLE

395: , p5_a3 JTF_VARCHAR2_TABLE_100
396: , p5_a4 JTF_NUMBER_TABLE
397: , p5_a5 JTF_DATE_TABLE
398: , p5_a6 JTF_NUMBER_TABLE
399: , p5_a7 JTF_NUMBER_TABLE
400: , p5_a8 JTF_VARCHAR2_TABLE_500
401: , p5_a9 JTF_VARCHAR2_TABLE_500
402: , p5_a10 JTF_VARCHAR2_TABLE_500
403: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 415: , p5_a23 JTF_NUMBER_TABLE

411: , p5_a19 JTF_VARCHAR2_TABLE_500
412: , p5_a20 JTF_VARCHAR2_TABLE_500
413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE

Line 416: , p5_a24 JTF_NUMBER_TABLE

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

Line 417: , p5_a25 JTF_NUMBER_TABLE

413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 420: , p5_a28 JTF_NUMBER_TABLE

416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , p6_a2 out nocopy JTF_NUMBER_TABLE
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p6_a0 out nocopy JTF_NUMBER_TABLE

417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , p6_a2 out nocopy JTF_NUMBER_TABLE
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 423: , p6_a2 out nocopy JTF_NUMBER_TABLE

419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , p6_a2 out nocopy JTF_NUMBER_TABLE
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a4 out nocopy JTF_NUMBER_TABLE
426: , p6_a5 out nocopy JTF_DATE_TABLE
427: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 425: , p6_a4 out nocopy JTF_NUMBER_TABLE

421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , p6_a2 out nocopy JTF_NUMBER_TABLE
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a4 out nocopy JTF_NUMBER_TABLE
426: , p6_a5 out nocopy JTF_DATE_TABLE
427: , p6_a6 out nocopy JTF_NUMBER_TABLE
428: , p6_a7 out nocopy JTF_NUMBER_TABLE
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 427: , p6_a6 out nocopy JTF_NUMBER_TABLE

423: , p6_a2 out nocopy JTF_NUMBER_TABLE
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a4 out nocopy JTF_NUMBER_TABLE
426: , p6_a5 out nocopy JTF_DATE_TABLE
427: , p6_a6 out nocopy JTF_NUMBER_TABLE
428: , p6_a7 out nocopy JTF_NUMBER_TABLE
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 428: , p6_a7 out nocopy JTF_NUMBER_TABLE

424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a4 out nocopy JTF_NUMBER_TABLE
426: , p6_a5 out nocopy JTF_DATE_TABLE
427: , p6_a6 out nocopy JTF_NUMBER_TABLE
428: , p6_a7 out nocopy JTF_NUMBER_TABLE
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
432: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 444: , p6_a23 out nocopy JTF_NUMBER_TABLE

440: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE

Line 445: , p6_a24 out nocopy JTF_NUMBER_TABLE

441: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 446: , p6_a25 out nocopy JTF_NUMBER_TABLE

442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE
450: );

Line 449: , p6_a28 out nocopy JTF_NUMBER_TABLE

445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE
450: );
451: procedure delete_row(p_api_version NUMBER
452: , p_init_msg_list VARCHAR2
453: , x_return_status out nocopy VARCHAR2

Line 491: , p5_a0 JTF_NUMBER_TABLE

487: , p_init_msg_list VARCHAR2
488: , x_return_status out nocopy VARCHAR2
489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_200
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_VARCHAR2_TABLE_100
495: , p5_a4 JTF_NUMBER_TABLE

Line 493: , p5_a2 JTF_NUMBER_TABLE

489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_200
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_VARCHAR2_TABLE_100
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_DATE_TABLE
497: , p5_a6 JTF_NUMBER_TABLE

Line 495: , p5_a4 JTF_NUMBER_TABLE

491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_200
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_VARCHAR2_TABLE_100
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_DATE_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_NUMBER_TABLE
499: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 497: , p5_a6 JTF_NUMBER_TABLE

493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_VARCHAR2_TABLE_100
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_DATE_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_NUMBER_TABLE
499: , p5_a8 JTF_VARCHAR2_TABLE_500
500: , p5_a9 JTF_VARCHAR2_TABLE_500
501: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 498: , p5_a7 JTF_NUMBER_TABLE

494: , p5_a3 JTF_VARCHAR2_TABLE_100
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_DATE_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_NUMBER_TABLE
499: , p5_a8 JTF_VARCHAR2_TABLE_500
500: , p5_a9 JTF_VARCHAR2_TABLE_500
501: , p5_a10 JTF_VARCHAR2_TABLE_500
502: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 514: , p5_a23 JTF_NUMBER_TABLE

510: , p5_a19 JTF_VARCHAR2_TABLE_500
511: , p5_a20 JTF_VARCHAR2_TABLE_500
512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE

Line 515: , p5_a24 JTF_NUMBER_TABLE

511: , p5_a20 JTF_VARCHAR2_TABLE_500
512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE

Line 516: , p5_a25 JTF_NUMBER_TABLE

512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: );

Line 519: , p5_a28 JTF_NUMBER_TABLE

515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: );
521: procedure validate_row(p_api_version NUMBER
522: , p_init_msg_list VARCHAR2
523: , x_return_status out nocopy VARCHAR2

Line 561: , p5_a0 JTF_NUMBER_TABLE

557: , p_init_msg_list VARCHAR2
558: , x_return_status out nocopy VARCHAR2
559: , x_msg_count out nocopy NUMBER
560: , x_msg_data out nocopy VARCHAR2
561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_200
563: , p5_a2 JTF_NUMBER_TABLE
564: , p5_a3 JTF_VARCHAR2_TABLE_100
565: , p5_a4 JTF_NUMBER_TABLE

Line 563: , p5_a2 JTF_NUMBER_TABLE

559: , x_msg_count out nocopy NUMBER
560: , x_msg_data out nocopy VARCHAR2
561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_200
563: , p5_a2 JTF_NUMBER_TABLE
564: , p5_a3 JTF_VARCHAR2_TABLE_100
565: , p5_a4 JTF_NUMBER_TABLE
566: , p5_a5 JTF_DATE_TABLE
567: , p5_a6 JTF_NUMBER_TABLE

Line 565: , p5_a4 JTF_NUMBER_TABLE

561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_200
563: , p5_a2 JTF_NUMBER_TABLE
564: , p5_a3 JTF_VARCHAR2_TABLE_100
565: , p5_a4 JTF_NUMBER_TABLE
566: , p5_a5 JTF_DATE_TABLE
567: , p5_a6 JTF_NUMBER_TABLE
568: , p5_a7 JTF_NUMBER_TABLE
569: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 567: , p5_a6 JTF_NUMBER_TABLE

563: , p5_a2 JTF_NUMBER_TABLE
564: , p5_a3 JTF_VARCHAR2_TABLE_100
565: , p5_a4 JTF_NUMBER_TABLE
566: , p5_a5 JTF_DATE_TABLE
567: , p5_a6 JTF_NUMBER_TABLE
568: , p5_a7 JTF_NUMBER_TABLE
569: , p5_a8 JTF_VARCHAR2_TABLE_500
570: , p5_a9 JTF_VARCHAR2_TABLE_500
571: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 568: , p5_a7 JTF_NUMBER_TABLE

564: , p5_a3 JTF_VARCHAR2_TABLE_100
565: , p5_a4 JTF_NUMBER_TABLE
566: , p5_a5 JTF_DATE_TABLE
567: , p5_a6 JTF_NUMBER_TABLE
568: , p5_a7 JTF_NUMBER_TABLE
569: , p5_a8 JTF_VARCHAR2_TABLE_500
570: , p5_a9 JTF_VARCHAR2_TABLE_500
571: , p5_a10 JTF_VARCHAR2_TABLE_500
572: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 584: , p5_a23 JTF_NUMBER_TABLE

580: , p5_a19 JTF_VARCHAR2_TABLE_500
581: , p5_a20 JTF_VARCHAR2_TABLE_500
582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE

Line 585: , p5_a24 JTF_NUMBER_TABLE

581: , p5_a20 JTF_VARCHAR2_TABLE_500
582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE

Line 586: , p5_a25 JTF_NUMBER_TABLE

582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE
590: );

Line 589: , p5_a28 JTF_NUMBER_TABLE

585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE
590: );
591: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
592: , p0_a1 JTF_VARCHAR2_TABLE_200
593: , p0_a2 JTF_NUMBER_TABLE

Line 591: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE

587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE
590: );
591: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
592: , p0_a1 JTF_VARCHAR2_TABLE_200
593: , p0_a2 JTF_NUMBER_TABLE
594: , p0_a3 JTF_VARCHAR2_TABLE_100
595: , p0_a4 JTF_NUMBER_TABLE

Line 593: , p0_a2 JTF_NUMBER_TABLE

589: , p5_a28 JTF_NUMBER_TABLE
590: );
591: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
592: , p0_a1 JTF_VARCHAR2_TABLE_200
593: , p0_a2 JTF_NUMBER_TABLE
594: , p0_a3 JTF_VARCHAR2_TABLE_100
595: , p0_a4 JTF_NUMBER_TABLE
596: , p0_a5 JTF_DATE_TABLE
597: , p0_a6 JTF_NUMBER_TABLE

Line 595: , p0_a4 JTF_NUMBER_TABLE

591: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
592: , p0_a1 JTF_VARCHAR2_TABLE_200
593: , p0_a2 JTF_NUMBER_TABLE
594: , p0_a3 JTF_VARCHAR2_TABLE_100
595: , p0_a4 JTF_NUMBER_TABLE
596: , p0_a5 JTF_DATE_TABLE
597: , p0_a6 JTF_NUMBER_TABLE
598: , p0_a7 JTF_NUMBER_TABLE
599: , p0_a8 JTF_VARCHAR2_TABLE_500

Line 597: , p0_a6 JTF_NUMBER_TABLE

593: , p0_a2 JTF_NUMBER_TABLE
594: , p0_a3 JTF_VARCHAR2_TABLE_100
595: , p0_a4 JTF_NUMBER_TABLE
596: , p0_a5 JTF_DATE_TABLE
597: , p0_a6 JTF_NUMBER_TABLE
598: , p0_a7 JTF_NUMBER_TABLE
599: , p0_a8 JTF_VARCHAR2_TABLE_500
600: , p0_a9 JTF_VARCHAR2_TABLE_500
601: , p0_a10 JTF_VARCHAR2_TABLE_500

Line 598: , p0_a7 JTF_NUMBER_TABLE

594: , p0_a3 JTF_VARCHAR2_TABLE_100
595: , p0_a4 JTF_NUMBER_TABLE
596: , p0_a5 JTF_DATE_TABLE
597: , p0_a6 JTF_NUMBER_TABLE
598: , p0_a7 JTF_NUMBER_TABLE
599: , p0_a8 JTF_VARCHAR2_TABLE_500
600: , p0_a9 JTF_VARCHAR2_TABLE_500
601: , p0_a10 JTF_VARCHAR2_TABLE_500
602: , p0_a11 JTF_VARCHAR2_TABLE_500

Line 614: , p0_a23 JTF_NUMBER_TABLE

610: , p0_a19 JTF_VARCHAR2_TABLE_500
611: , p0_a20 JTF_VARCHAR2_TABLE_500
612: , p0_a21 JTF_VARCHAR2_TABLE_500
613: , p0_a22 JTF_VARCHAR2_TABLE_500
614: , p0_a23 JTF_NUMBER_TABLE
615: , p0_a24 JTF_NUMBER_TABLE
616: , p0_a25 JTF_NUMBER_TABLE
617: , p0_a26 JTF_DATE_TABLE
618: , p0_a27 JTF_DATE_TABLE

Line 615: , p0_a24 JTF_NUMBER_TABLE

611: , p0_a20 JTF_VARCHAR2_TABLE_500
612: , p0_a21 JTF_VARCHAR2_TABLE_500
613: , p0_a22 JTF_VARCHAR2_TABLE_500
614: , p0_a23 JTF_NUMBER_TABLE
615: , p0_a24 JTF_NUMBER_TABLE
616: , p0_a25 JTF_NUMBER_TABLE
617: , p0_a26 JTF_DATE_TABLE
618: , p0_a27 JTF_DATE_TABLE
619: , p0_a28 JTF_NUMBER_TABLE

Line 616: , p0_a25 JTF_NUMBER_TABLE

612: , p0_a21 JTF_VARCHAR2_TABLE_500
613: , p0_a22 JTF_VARCHAR2_TABLE_500
614: , p0_a23 JTF_NUMBER_TABLE
615: , p0_a24 JTF_NUMBER_TABLE
616: , p0_a25 JTF_NUMBER_TABLE
617: , p0_a26 JTF_DATE_TABLE
618: , p0_a27 JTF_DATE_TABLE
619: , p0_a28 JTF_NUMBER_TABLE
620: );

Line 619: , p0_a28 JTF_NUMBER_TABLE

615: , p0_a24 JTF_NUMBER_TABLE
616: , p0_a25 JTF_NUMBER_TABLE
617: , p0_a26 JTF_DATE_TABLE
618: , p0_a27 JTF_DATE_TABLE
619: , p0_a28 JTF_NUMBER_TABLE
620: );
621: procedure insert_row_per(p_api_version NUMBER
622: , p_init_msg_list VARCHAR2
623: , x_return_status out nocopy VARCHAR2