DBA Data[Home] [Help]

APPS.OKL_REP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_rep_pvt_w as
2: /* $Header: OKLIREPS.pls 120.0 2007/12/10 18:28:01 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
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_rep_pvt_w as
2: /* $Header: OKLIREPS.pls 120.0 2007/12/10 18:28:01 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_NUMBER_TABLE

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: );

Line 24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
28: , a4 out nocopy JTF_NUMBER_TABLE

Line 26: , a2 out nocopy JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: , a4 out nocopy JTF_NUMBER_TABLE

24: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_VARCHAR2_TABLE_300
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_VARCHAR2_TABLE_100
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: , a7 out nocopy JTF_VARCHAR2_TABLE_100
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a12 out nocopy JTF_NUMBER_TABLE

32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a10 out nocopy JTF_DATE_TABLE
35: , a11 out nocopy JTF_DATE_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE

Line 38: , a14 out nocopy JTF_NUMBER_TABLE

34: , a10 out nocopy JTF_DATE_TABLE
35: , a11 out nocopy JTF_DATE_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_VARCHAR2_TABLE_100
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a16 out nocopy JTF_NUMBER_TABLE

36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_DATE_TABLE
40: , a16 out nocopy JTF_NUMBER_TABLE
41: , a17 out nocopy JTF_VARCHAR2_TABLE_100
42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_100
44: );

Line 46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE

42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_100
44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE

Line 48: , a2 JTF_NUMBER_TABLE

44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100

Line 50: , a4 JTF_NUMBER_TABLE

46: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_VARCHAR2_TABLE_300
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_VARCHAR2_TABLE_100
50: , a4 JTF_NUMBER_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_VARCHAR2_TABLE_100
53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100

Line 57: , a11 JTF_NUMBER_TABLE

53: , a7 JTF_DATE_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_DATE_TABLE
57: , a11 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_DATE_TABLE
61: , a15 JTF_NUMBER_TABLE

Line 59: , a13 JTF_NUMBER_TABLE

55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_DATE_TABLE
57: , a11 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_DATE_TABLE
61: , a15 JTF_NUMBER_TABLE
62: );
63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 61: , a15 JTF_NUMBER_TABLE

57: , a11 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_DATE_TABLE
61: , a15 JTF_NUMBER_TABLE
62: );
63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE

Line 63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

59: , a13 JTF_NUMBER_TABLE
60: , a14 JTF_DATE_TABLE
61: , a15 JTF_NUMBER_TABLE
62: );
63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE

Line 65: , a2 out nocopy JTF_NUMBER_TABLE

61: , a15 JTF_NUMBER_TABLE
62: );
63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a4 out nocopy JTF_NUMBER_TABLE

63: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_300
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_VARCHAR2_TABLE_100
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a11 out nocopy JTF_NUMBER_TABLE

70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_VARCHAR2_TABLE_100
72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
77: , a14 out nocopy JTF_DATE_TABLE
78: , a15 out nocopy JTF_NUMBER_TABLE

Line 76: , a13 out nocopy JTF_NUMBER_TABLE

72: , a9 out nocopy JTF_VARCHAR2_TABLE_100
73: , a10 out nocopy JTF_DATE_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
77: , a14 out nocopy JTF_DATE_TABLE
78: , a15 out nocopy JTF_NUMBER_TABLE
79: );
80:

Line 78: , a15 out nocopy JTF_NUMBER_TABLE

74: , a11 out nocopy JTF_NUMBER_TABLE
75: , a12 out nocopy JTF_DATE_TABLE
76: , a13 out nocopy JTF_NUMBER_TABLE
77: , a14 out nocopy JTF_DATE_TABLE
78: , a15 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100

Line 81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE

77: , a14 out nocopy JTF_DATE_TABLE
78: , a15 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_VARCHAR2_TABLE_100
83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_300

Line 87: , a6 JTF_NUMBER_TABLE

83: , a2 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_300
86: , a5 JTF_VARCHAR2_TABLE_2000
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_DATE_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_DATE_TABLE
91: , a10 JTF_NUMBER_TABLE

Line 89: , a8 JTF_NUMBER_TABLE

85: , a4 JTF_VARCHAR2_TABLE_300
86: , a5 JTF_VARCHAR2_TABLE_2000
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_DATE_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_DATE_TABLE
91: , a10 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 91: , a10 JTF_NUMBER_TABLE

87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_DATE_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_DATE_TABLE
91: , a10 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_DATE_TABLE
91: , a10 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 99: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 101: , a8 out nocopy JTF_NUMBER_TABLE

97: , a4 out nocopy JTF_VARCHAR2_TABLE_300
98: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a6 out nocopy JTF_NUMBER_TABLE
100: , a7 out nocopy JTF_DATE_TABLE
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_DATE_TABLE
103: , a10 out nocopy JTF_NUMBER_TABLE
104: );
105:

Line 103: , a10 out nocopy JTF_NUMBER_TABLE

99: , a6 out nocopy JTF_NUMBER_TABLE
100: , a7 out nocopy JTF_DATE_TABLE
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_DATE_TABLE
103: , a10 out nocopy JTF_NUMBER_TABLE
104: );
105:
106: procedure insert_row(p_api_version NUMBER
107: , p_init_msg_list VARCHAR2

Line 157: , p5_a0 JTF_NUMBER_TABLE

153: , p_init_msg_list VARCHAR2
154: , x_return_status out nocopy VARCHAR2
155: , x_msg_count out nocopy NUMBER
156: , x_msg_data out nocopy VARCHAR2
157: , p5_a0 JTF_NUMBER_TABLE
158: , p5_a1 JTF_VARCHAR2_TABLE_300
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE

Line 159: , p5_a2 JTF_NUMBER_TABLE

155: , x_msg_count out nocopy NUMBER
156: , x_msg_data out nocopy VARCHAR2
157: , p5_a0 JTF_NUMBER_TABLE
158: , p5_a1 JTF_VARCHAR2_TABLE_300
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 161: , p5_a4 JTF_NUMBER_TABLE

157: , p5_a0 JTF_NUMBER_TABLE
158: , p5_a1 JTF_VARCHAR2_TABLE_300
159: , p5_a2 JTF_NUMBER_TABLE
160: , p5_a3 JTF_VARCHAR2_TABLE_100
161: , p5_a4 JTF_NUMBER_TABLE
162: , p5_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a6 JTF_VARCHAR2_TABLE_100
164: , p5_a7 JTF_VARCHAR2_TABLE_100
165: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 169: , p5_a12 JTF_NUMBER_TABLE

165: , p5_a8 JTF_VARCHAR2_TABLE_100
166: , p5_a9 JTF_VARCHAR2_TABLE_2000
167: , p5_a10 JTF_DATE_TABLE
168: , p5_a11 JTF_DATE_TABLE
169: , p5_a12 JTF_NUMBER_TABLE
170: , p5_a13 JTF_DATE_TABLE
171: , p5_a14 JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE

Line 171: , p5_a14 JTF_NUMBER_TABLE

167: , p5_a10 JTF_DATE_TABLE
168: , p5_a11 JTF_DATE_TABLE
169: , p5_a12 JTF_NUMBER_TABLE
170: , p5_a13 JTF_DATE_TABLE
171: , p5_a14 JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 173: , p5_a16 JTF_NUMBER_TABLE

169: , p5_a12 JTF_NUMBER_TABLE
170: , p5_a13 JTF_DATE_TABLE
171: , p5_a14 JTF_NUMBER_TABLE
172: , p5_a15 JTF_DATE_TABLE
173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 177: , p6_a0 out nocopy JTF_NUMBER_TABLE

173: , p5_a16 JTF_NUMBER_TABLE
174: , p5_a17 JTF_VARCHAR2_TABLE_100
175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 179: , p6_a2 out nocopy JTF_NUMBER_TABLE

175: , p5_a18 JTF_VARCHAR2_TABLE_100
176: , p5_a19 JTF_VARCHAR2_TABLE_100
177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , p6_a4 out nocopy JTF_NUMBER_TABLE

177: , p6_a0 out nocopy JTF_NUMBER_TABLE
178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
179: , p6_a2 out nocopy JTF_NUMBER_TABLE
180: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a4 out nocopy JTF_NUMBER_TABLE
182: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , p6_a12 out nocopy JTF_NUMBER_TABLE

185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
187: , p6_a10 out nocopy JTF_DATE_TABLE
188: , p6_a11 out nocopy JTF_DATE_TABLE
189: , p6_a12 out nocopy JTF_NUMBER_TABLE
190: , p6_a13 out nocopy JTF_DATE_TABLE
191: , p6_a14 out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 191: , p6_a14 out nocopy JTF_NUMBER_TABLE

187: , p6_a10 out nocopy JTF_DATE_TABLE
188: , p6_a11 out nocopy JTF_DATE_TABLE
189: , p6_a12 out nocopy JTF_NUMBER_TABLE
190: , p6_a13 out nocopy JTF_DATE_TABLE
191: , p6_a14 out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p6_a16 out nocopy JTF_NUMBER_TABLE

189: , p6_a12 out nocopy JTF_NUMBER_TABLE
190: , p6_a13 out nocopy JTF_DATE_TABLE
191: , p6_a14 out nocopy JTF_NUMBER_TABLE
192: , p6_a15 out nocopy JTF_DATE_TABLE
193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 197: , p7_a0 in out nocopy JTF_NUMBER_TABLE

193: , p6_a16 out nocopy JTF_NUMBER_TABLE
194: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 199: , p7_a2 in out nocopy JTF_NUMBER_TABLE

195: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE
202: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p7_a4 in out nocopy JTF_NUMBER_TABLE

197: , p7_a0 in out nocopy JTF_NUMBER_TABLE
198: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a2 in out nocopy JTF_NUMBER_TABLE
200: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p7_a4 in out nocopy JTF_NUMBER_TABLE
202: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
204: );
205: procedure insert_row(p_api_version NUMBER

Line 210: , p5_a0 JTF_NUMBER_TABLE

206: , p_init_msg_list VARCHAR2
207: , x_return_status out nocopy VARCHAR2
208: , x_msg_count out nocopy NUMBER
209: , x_msg_data out nocopy VARCHAR2
210: , p5_a0 JTF_NUMBER_TABLE
211: , p5_a1 JTF_VARCHAR2_TABLE_300
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE

Line 212: , p5_a2 JTF_NUMBER_TABLE

208: , x_msg_count out nocopy NUMBER
209: , x_msg_data out nocopy VARCHAR2
210: , p5_a0 JTF_NUMBER_TABLE
211: , p5_a1 JTF_VARCHAR2_TABLE_300
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 214: , p5_a4 JTF_NUMBER_TABLE

210: , p5_a0 JTF_NUMBER_TABLE
211: , p5_a1 JTF_VARCHAR2_TABLE_300
212: , p5_a2 JTF_NUMBER_TABLE
213: , p5_a3 JTF_VARCHAR2_TABLE_100
214: , p5_a4 JTF_NUMBER_TABLE
215: , p5_a5 JTF_VARCHAR2_TABLE_100
216: , p5_a6 JTF_VARCHAR2_TABLE_100
217: , p5_a7 JTF_VARCHAR2_TABLE_100
218: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 222: , p5_a12 JTF_NUMBER_TABLE

218: , p5_a8 JTF_VARCHAR2_TABLE_100
219: , p5_a9 JTF_VARCHAR2_TABLE_2000
220: , p5_a10 JTF_DATE_TABLE
221: , p5_a11 JTF_DATE_TABLE
222: , p5_a12 JTF_NUMBER_TABLE
223: , p5_a13 JTF_DATE_TABLE
224: , p5_a14 JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE

Line 224: , p5_a14 JTF_NUMBER_TABLE

220: , p5_a10 JTF_DATE_TABLE
221: , p5_a11 JTF_DATE_TABLE
222: , p5_a12 JTF_NUMBER_TABLE
223: , p5_a13 JTF_DATE_TABLE
224: , p5_a14 JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 226: , p5_a16 JTF_NUMBER_TABLE

222: , p5_a12 JTF_NUMBER_TABLE
223: , p5_a13 JTF_DATE_TABLE
224: , p5_a14 JTF_NUMBER_TABLE
225: , p5_a15 JTF_DATE_TABLE
226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 230: , p6_a0 out nocopy JTF_NUMBER_TABLE

226: , p5_a16 JTF_NUMBER_TABLE
227: , p5_a17 JTF_VARCHAR2_TABLE_100
228: , p5_a18 JTF_VARCHAR2_TABLE_100
229: , p5_a19 JTF_VARCHAR2_TABLE_100
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
234: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 232: , p6_a2 out nocopy JTF_NUMBER_TABLE

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

Line 234: , p6_a4 out nocopy JTF_NUMBER_TABLE

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

Line 242: , p6_a12 out nocopy JTF_NUMBER_TABLE

238: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_DATE_TABLE
242: , p6_a12 out nocopy JTF_NUMBER_TABLE
243: , p6_a13 out nocopy JTF_DATE_TABLE
244: , p6_a14 out nocopy JTF_NUMBER_TABLE
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 244: , p6_a14 out nocopy JTF_NUMBER_TABLE

240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_DATE_TABLE
242: , p6_a12 out nocopy JTF_NUMBER_TABLE
243: , p6_a13 out nocopy JTF_DATE_TABLE
244: , p6_a14 out nocopy JTF_NUMBER_TABLE
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE
247: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , p6_a16 out nocopy JTF_NUMBER_TABLE

242: , p6_a12 out nocopy JTF_NUMBER_TABLE
243: , p6_a13 out nocopy JTF_DATE_TABLE
244: , p6_a14 out nocopy JTF_NUMBER_TABLE
245: , p6_a15 out nocopy JTF_DATE_TABLE
246: , p6_a16 out nocopy JTF_NUMBER_TABLE
247: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
250: );

Line 282: , p5_a0 JTF_NUMBER_TABLE

278: , p_init_msg_list VARCHAR2
279: , x_return_status out nocopy VARCHAR2
280: , x_msg_count out nocopy NUMBER
281: , x_msg_data out nocopy VARCHAR2
282: , p5_a0 JTF_NUMBER_TABLE
283: , p5_a1 JTF_VARCHAR2_TABLE_300
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE

Line 284: , p5_a2 JTF_NUMBER_TABLE

280: , x_msg_count out nocopy NUMBER
281: , x_msg_data out nocopy VARCHAR2
282: , p5_a0 JTF_NUMBER_TABLE
283: , p5_a1 JTF_VARCHAR2_TABLE_300
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 286: , p5_a4 JTF_NUMBER_TABLE

282: , p5_a0 JTF_NUMBER_TABLE
283: , p5_a1 JTF_VARCHAR2_TABLE_300
284: , p5_a2 JTF_NUMBER_TABLE
285: , p5_a3 JTF_VARCHAR2_TABLE_100
286: , p5_a4 JTF_NUMBER_TABLE
287: , p5_a5 JTF_VARCHAR2_TABLE_100
288: , p5_a6 JTF_VARCHAR2_TABLE_100
289: , p5_a7 JTF_VARCHAR2_TABLE_100
290: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 294: , p5_a12 JTF_NUMBER_TABLE

290: , p5_a8 JTF_VARCHAR2_TABLE_100
291: , p5_a9 JTF_VARCHAR2_TABLE_2000
292: , p5_a10 JTF_DATE_TABLE
293: , p5_a11 JTF_DATE_TABLE
294: , p5_a12 JTF_NUMBER_TABLE
295: , p5_a13 JTF_DATE_TABLE
296: , p5_a14 JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE

Line 296: , p5_a14 JTF_NUMBER_TABLE

292: , p5_a10 JTF_DATE_TABLE
293: , p5_a11 JTF_DATE_TABLE
294: , p5_a12 JTF_NUMBER_TABLE
295: , p5_a13 JTF_DATE_TABLE
296: , p5_a14 JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 298: , p5_a16 JTF_NUMBER_TABLE

294: , p5_a12 JTF_NUMBER_TABLE
295: , p5_a13 JTF_DATE_TABLE
296: , p5_a14 JTF_NUMBER_TABLE
297: , p5_a15 JTF_DATE_TABLE
298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 302: , p6_a0 in out nocopy JTF_NUMBER_TABLE

298: , p5_a16 JTF_NUMBER_TABLE
299: , p5_a17 JTF_VARCHAR2_TABLE_100
300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 304: , p6_a2 in out nocopy JTF_NUMBER_TABLE

300: , p5_a18 JTF_VARCHAR2_TABLE_100
301: , p5_a19 JTF_VARCHAR2_TABLE_100
302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE
307: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p6_a4 in out nocopy JTF_NUMBER_TABLE

302: , p6_a0 in out nocopy JTF_NUMBER_TABLE
303: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a2 in out nocopy JTF_NUMBER_TABLE
305: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
306: , p6_a4 in out nocopy JTF_NUMBER_TABLE
307: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
309: );
310: procedure lock_row(p_api_version NUMBER

Line 315: , p5_a0 JTF_NUMBER_TABLE

311: , p_init_msg_list VARCHAR2
312: , x_return_status out nocopy VARCHAR2
313: , x_msg_count out nocopy NUMBER
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_300
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE

Line 317: , p5_a2 JTF_NUMBER_TABLE

313: , x_msg_count out nocopy NUMBER
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_300
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 319: , p5_a4 JTF_NUMBER_TABLE

315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_300
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_VARCHAR2_TABLE_100
321: , p5_a6 JTF_VARCHAR2_TABLE_100
322: , p5_a7 JTF_VARCHAR2_TABLE_100
323: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 327: , p5_a12 JTF_NUMBER_TABLE

323: , p5_a8 JTF_VARCHAR2_TABLE_100
324: , p5_a9 JTF_VARCHAR2_TABLE_2000
325: , p5_a10 JTF_DATE_TABLE
326: , p5_a11 JTF_DATE_TABLE
327: , p5_a12 JTF_NUMBER_TABLE
328: , p5_a13 JTF_DATE_TABLE
329: , p5_a14 JTF_NUMBER_TABLE
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE

Line 329: , p5_a14 JTF_NUMBER_TABLE

325: , p5_a10 JTF_DATE_TABLE
326: , p5_a11 JTF_DATE_TABLE
327: , p5_a12 JTF_NUMBER_TABLE
328: , p5_a13 JTF_DATE_TABLE
329: , p5_a14 JTF_NUMBER_TABLE
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE
332: , p5_a17 JTF_VARCHAR2_TABLE_100
333: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 331: , p5_a16 JTF_NUMBER_TABLE

327: , p5_a12 JTF_NUMBER_TABLE
328: , p5_a13 JTF_DATE_TABLE
329: , p5_a14 JTF_NUMBER_TABLE
330: , p5_a15 JTF_DATE_TABLE
331: , p5_a16 JTF_NUMBER_TABLE
332: , p5_a17 JTF_VARCHAR2_TABLE_100
333: , p5_a18 JTF_VARCHAR2_TABLE_100
334: , p5_a19 JTF_VARCHAR2_TABLE_100
335: );

Line 387: , p5_a0 JTF_NUMBER_TABLE

383: , p_init_msg_list VARCHAR2
384: , x_return_status out nocopy VARCHAR2
385: , x_msg_count out nocopy NUMBER
386: , x_msg_data out nocopy VARCHAR2
387: , p5_a0 JTF_NUMBER_TABLE
388: , p5_a1 JTF_VARCHAR2_TABLE_300
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE

Line 389: , p5_a2 JTF_NUMBER_TABLE

385: , x_msg_count out nocopy NUMBER
386: , x_msg_data out nocopy VARCHAR2
387: , p5_a0 JTF_NUMBER_TABLE
388: , p5_a1 JTF_VARCHAR2_TABLE_300
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 391: , p5_a4 JTF_NUMBER_TABLE

387: , p5_a0 JTF_NUMBER_TABLE
388: , p5_a1 JTF_VARCHAR2_TABLE_300
389: , p5_a2 JTF_NUMBER_TABLE
390: , p5_a3 JTF_VARCHAR2_TABLE_100
391: , p5_a4 JTF_NUMBER_TABLE
392: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a6 JTF_VARCHAR2_TABLE_100
394: , p5_a7 JTF_VARCHAR2_TABLE_100
395: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 399: , p5_a12 JTF_NUMBER_TABLE

395: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a9 JTF_VARCHAR2_TABLE_2000
397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_DATE_TABLE
399: , p5_a12 JTF_NUMBER_TABLE
400: , p5_a13 JTF_DATE_TABLE
401: , p5_a14 JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE

Line 401: , p5_a14 JTF_NUMBER_TABLE

397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_DATE_TABLE
399: , p5_a12 JTF_NUMBER_TABLE
400: , p5_a13 JTF_DATE_TABLE
401: , p5_a14 JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 403: , p5_a16 JTF_NUMBER_TABLE

399: , p5_a12 JTF_NUMBER_TABLE
400: , p5_a13 JTF_DATE_TABLE
401: , p5_a14 JTF_NUMBER_TABLE
402: , p5_a15 JTF_DATE_TABLE
403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 407: , p6_a0 out nocopy JTF_NUMBER_TABLE

403: , p5_a16 JTF_NUMBER_TABLE
404: , p5_a17 JTF_VARCHAR2_TABLE_100
405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 409: , p6_a2 out nocopy JTF_NUMBER_TABLE

405: , p5_a18 JTF_VARCHAR2_TABLE_100
406: , p5_a19 JTF_VARCHAR2_TABLE_100
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 411: , p6_a4 out nocopy JTF_NUMBER_TABLE

407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , p6_a2 out nocopy JTF_NUMBER_TABLE
410: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a4 out nocopy JTF_NUMBER_TABLE
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p6_a12 out nocopy JTF_NUMBER_TABLE

415: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
417: , p6_a10 out nocopy JTF_DATE_TABLE
418: , p6_a11 out nocopy JTF_DATE_TABLE
419: , p6_a12 out nocopy JTF_NUMBER_TABLE
420: , p6_a13 out nocopy JTF_DATE_TABLE
421: , p6_a14 out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 421: , p6_a14 out nocopy JTF_NUMBER_TABLE

417: , p6_a10 out nocopy JTF_DATE_TABLE
418: , p6_a11 out nocopy JTF_DATE_TABLE
419: , p6_a12 out nocopy JTF_NUMBER_TABLE
420: , p6_a13 out nocopy JTF_DATE_TABLE
421: , p6_a14 out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , p6_a16 out nocopy JTF_NUMBER_TABLE

419: , p6_a12 out nocopy JTF_NUMBER_TABLE
420: , p6_a13 out nocopy JTF_DATE_TABLE
421: , p6_a14 out nocopy JTF_NUMBER_TABLE
422: , p6_a15 out nocopy JTF_DATE_TABLE
423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 427: , p7_a0 in out nocopy JTF_NUMBER_TABLE

423: , p6_a16 out nocopy JTF_NUMBER_TABLE
424: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 429: , p7_a2 in out nocopy JTF_NUMBER_TABLE

425: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE
432: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 431: , p7_a4 in out nocopy JTF_NUMBER_TABLE

427: , p7_a0 in out nocopy JTF_NUMBER_TABLE
428: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
429: , p7_a2 in out nocopy JTF_NUMBER_TABLE
430: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
431: , p7_a4 in out nocopy JTF_NUMBER_TABLE
432: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
434: );
435: procedure update_row(p_api_version NUMBER

Line 440: , p5_a0 JTF_NUMBER_TABLE

436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_VARCHAR2_TABLE_300
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE

Line 442: , p5_a2 JTF_NUMBER_TABLE

438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_VARCHAR2_TABLE_300
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 444: , p5_a4 JTF_NUMBER_TABLE

440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_VARCHAR2_TABLE_300
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_VARCHAR2_TABLE_100
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 452: , p5_a12 JTF_NUMBER_TABLE

448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_VARCHAR2_TABLE_2000
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_DATE_TABLE
452: , p5_a12 JTF_NUMBER_TABLE
453: , p5_a13 JTF_DATE_TABLE
454: , p5_a14 JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE

Line 454: , p5_a14 JTF_NUMBER_TABLE

450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_DATE_TABLE
452: , p5_a12 JTF_NUMBER_TABLE
453: , p5_a13 JTF_DATE_TABLE
454: , p5_a14 JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 456: , p5_a16 JTF_NUMBER_TABLE

452: , p5_a12 JTF_NUMBER_TABLE
453: , p5_a13 JTF_DATE_TABLE
454: , p5_a14 JTF_NUMBER_TABLE
455: , p5_a15 JTF_DATE_TABLE
456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 460: , p6_a0 out nocopy JTF_NUMBER_TABLE

456: , p5_a16 JTF_NUMBER_TABLE
457: , p5_a17 JTF_VARCHAR2_TABLE_100
458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 462: , p6_a2 out nocopy JTF_NUMBER_TABLE

458: , p5_a18 JTF_VARCHAR2_TABLE_100
459: , p5_a19 JTF_VARCHAR2_TABLE_100
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 464: , p6_a4 out nocopy JTF_NUMBER_TABLE

460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_NUMBER_TABLE
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 472: , p6_a12 out nocopy JTF_NUMBER_TABLE

468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
470: , p6_a10 out nocopy JTF_DATE_TABLE
471: , p6_a11 out nocopy JTF_DATE_TABLE
472: , p6_a12 out nocopy JTF_NUMBER_TABLE
473: , p6_a13 out nocopy JTF_DATE_TABLE
474: , p6_a14 out nocopy JTF_NUMBER_TABLE
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 474: , p6_a14 out nocopy JTF_NUMBER_TABLE

470: , p6_a10 out nocopy JTF_DATE_TABLE
471: , p6_a11 out nocopy JTF_DATE_TABLE
472: , p6_a12 out nocopy JTF_NUMBER_TABLE
473: , p6_a13 out nocopy JTF_DATE_TABLE
474: , p6_a14 out nocopy JTF_NUMBER_TABLE
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE
477: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 476: , p6_a16 out nocopy JTF_NUMBER_TABLE

472: , p6_a12 out nocopy JTF_NUMBER_TABLE
473: , p6_a13 out nocopy JTF_DATE_TABLE
474: , p6_a14 out nocopy JTF_NUMBER_TABLE
475: , p6_a15 out nocopy JTF_DATE_TABLE
476: , p6_a16 out nocopy JTF_NUMBER_TABLE
477: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
479: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
480: );

Line 512: , p5_a0 JTF_NUMBER_TABLE

508: , p_init_msg_list VARCHAR2
509: , x_return_status out nocopy VARCHAR2
510: , x_msg_count out nocopy NUMBER
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_VARCHAR2_TABLE_300
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE

Line 514: , p5_a2 JTF_NUMBER_TABLE

510: , x_msg_count out nocopy NUMBER
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_VARCHAR2_TABLE_300
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 516: , p5_a4 JTF_NUMBER_TABLE

512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_VARCHAR2_TABLE_300
514: , p5_a2 JTF_NUMBER_TABLE
515: , p5_a3 JTF_VARCHAR2_TABLE_100
516: , p5_a4 JTF_NUMBER_TABLE
517: , p5_a5 JTF_VARCHAR2_TABLE_100
518: , p5_a6 JTF_VARCHAR2_TABLE_100
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 524: , p5_a12 JTF_NUMBER_TABLE

520: , p5_a8 JTF_VARCHAR2_TABLE_100
521: , p5_a9 JTF_VARCHAR2_TABLE_2000
522: , p5_a10 JTF_DATE_TABLE
523: , p5_a11 JTF_DATE_TABLE
524: , p5_a12 JTF_NUMBER_TABLE
525: , p5_a13 JTF_DATE_TABLE
526: , p5_a14 JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE

Line 526: , p5_a14 JTF_NUMBER_TABLE

522: , p5_a10 JTF_DATE_TABLE
523: , p5_a11 JTF_DATE_TABLE
524: , p5_a12 JTF_NUMBER_TABLE
525: , p5_a13 JTF_DATE_TABLE
526: , p5_a14 JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 528: , p5_a16 JTF_NUMBER_TABLE

524: , p5_a12 JTF_NUMBER_TABLE
525: , p5_a13 JTF_DATE_TABLE
526: , p5_a14 JTF_NUMBER_TABLE
527: , p5_a15 JTF_DATE_TABLE
528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 532: , p6_a0 in out nocopy JTF_NUMBER_TABLE

528: , p5_a16 JTF_NUMBER_TABLE
529: , p5_a17 JTF_VARCHAR2_TABLE_100
530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 534: , p6_a2 in out nocopy JTF_NUMBER_TABLE

530: , p5_a18 JTF_VARCHAR2_TABLE_100
531: , p5_a19 JTF_VARCHAR2_TABLE_100
532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE
537: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 536: , p6_a4 in out nocopy JTF_NUMBER_TABLE

532: , p6_a0 in out nocopy JTF_NUMBER_TABLE
533: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a2 in out nocopy JTF_NUMBER_TABLE
535: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
536: , p6_a4 in out nocopy JTF_NUMBER_TABLE
537: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
539: );
540: procedure delete_row(p_api_version NUMBER

Line 545: , p5_a0 JTF_NUMBER_TABLE

541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
543: , x_msg_count out nocopy NUMBER
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_VARCHAR2_TABLE_300
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE

Line 547: , p5_a2 JTF_NUMBER_TABLE

543: , x_msg_count out nocopy NUMBER
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_VARCHAR2_TABLE_300
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 549: , p5_a4 JTF_NUMBER_TABLE

545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_VARCHAR2_TABLE_300
547: , p5_a2 JTF_NUMBER_TABLE
548: , p5_a3 JTF_VARCHAR2_TABLE_100
549: , p5_a4 JTF_NUMBER_TABLE
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 557: , p5_a12 JTF_NUMBER_TABLE

553: , p5_a8 JTF_VARCHAR2_TABLE_100
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_DATE_TABLE
556: , p5_a11 JTF_DATE_TABLE
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_DATE_TABLE
559: , p5_a14 JTF_NUMBER_TABLE
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE

Line 559: , p5_a14 JTF_NUMBER_TABLE

555: , p5_a10 JTF_DATE_TABLE
556: , p5_a11 JTF_DATE_TABLE
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_DATE_TABLE
559: , p5_a14 JTF_NUMBER_TABLE
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE
562: , p5_a17 JTF_VARCHAR2_TABLE_100
563: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 561: , p5_a16 JTF_NUMBER_TABLE

557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_DATE_TABLE
559: , p5_a14 JTF_NUMBER_TABLE
560: , p5_a15 JTF_DATE_TABLE
561: , p5_a16 JTF_NUMBER_TABLE
562: , p5_a17 JTF_VARCHAR2_TABLE_100
563: , p5_a18 JTF_VARCHAR2_TABLE_100
564: , p5_a19 JTF_VARCHAR2_TABLE_100
565: );

Line 597: , p5_a0 JTF_NUMBER_TABLE

593: , p_init_msg_list VARCHAR2
594: , x_return_status out nocopy VARCHAR2
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
597: , p5_a0 JTF_NUMBER_TABLE
598: , p5_a1 JTF_VARCHAR2_TABLE_300
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE

Line 599: , p5_a2 JTF_NUMBER_TABLE

595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
597: , p5_a0 JTF_NUMBER_TABLE
598: , p5_a1 JTF_VARCHAR2_TABLE_300
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 601: , p5_a4 JTF_NUMBER_TABLE

597: , p5_a0 JTF_NUMBER_TABLE
598: , p5_a1 JTF_VARCHAR2_TABLE_300
599: , p5_a2 JTF_NUMBER_TABLE
600: , p5_a3 JTF_VARCHAR2_TABLE_100
601: , p5_a4 JTF_NUMBER_TABLE
602: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a6 JTF_VARCHAR2_TABLE_100
604: , p5_a7 JTF_VARCHAR2_TABLE_100
605: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 609: , p5_a12 JTF_NUMBER_TABLE

605: , p5_a8 JTF_VARCHAR2_TABLE_100
606: , p5_a9 JTF_VARCHAR2_TABLE_2000
607: , p5_a10 JTF_DATE_TABLE
608: , p5_a11 JTF_DATE_TABLE
609: , p5_a12 JTF_NUMBER_TABLE
610: , p5_a13 JTF_DATE_TABLE
611: , p5_a14 JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE

Line 611: , p5_a14 JTF_NUMBER_TABLE

607: , p5_a10 JTF_DATE_TABLE
608: , p5_a11 JTF_DATE_TABLE
609: , p5_a12 JTF_NUMBER_TABLE
610: , p5_a13 JTF_DATE_TABLE
611: , p5_a14 JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 613: , p5_a16 JTF_NUMBER_TABLE

609: , p5_a12 JTF_NUMBER_TABLE
610: , p5_a13 JTF_DATE_TABLE
611: , p5_a14 JTF_NUMBER_TABLE
612: , p5_a15 JTF_DATE_TABLE
613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 617: , p6_a0 in out nocopy JTF_NUMBER_TABLE

613: , p5_a16 JTF_NUMBER_TABLE
614: , p5_a17 JTF_VARCHAR2_TABLE_100
615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 619: , p6_a2 in out nocopy JTF_NUMBER_TABLE

615: , p5_a18 JTF_VARCHAR2_TABLE_100
616: , p5_a19 JTF_VARCHAR2_TABLE_100
617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE
622: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 621: , p6_a4 in out nocopy JTF_NUMBER_TABLE

617: , p6_a0 in out nocopy JTF_NUMBER_TABLE
618: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p6_a2 in out nocopy JTF_NUMBER_TABLE
620: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
621: , p6_a4 in out nocopy JTF_NUMBER_TABLE
622: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
624: );
625: procedure validate_row(p_api_version NUMBER

Line 630: , p5_a0 JTF_NUMBER_TABLE

626: , p_init_msg_list VARCHAR2
627: , x_return_status out nocopy VARCHAR2
628: , x_msg_count out nocopy NUMBER
629: , x_msg_data out nocopy VARCHAR2
630: , p5_a0 JTF_NUMBER_TABLE
631: , p5_a1 JTF_VARCHAR2_TABLE_300
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE

Line 632: , p5_a2 JTF_NUMBER_TABLE

628: , x_msg_count out nocopy NUMBER
629: , x_msg_data out nocopy VARCHAR2
630: , p5_a0 JTF_NUMBER_TABLE
631: , p5_a1 JTF_VARCHAR2_TABLE_300
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 634: , p5_a4 JTF_NUMBER_TABLE

630: , p5_a0 JTF_NUMBER_TABLE
631: , p5_a1 JTF_VARCHAR2_TABLE_300
632: , p5_a2 JTF_NUMBER_TABLE
633: , p5_a3 JTF_VARCHAR2_TABLE_100
634: , p5_a4 JTF_NUMBER_TABLE
635: , p5_a5 JTF_VARCHAR2_TABLE_100
636: , p5_a6 JTF_VARCHAR2_TABLE_100
637: , p5_a7 JTF_VARCHAR2_TABLE_100
638: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 642: , p5_a12 JTF_NUMBER_TABLE

638: , p5_a8 JTF_VARCHAR2_TABLE_100
639: , p5_a9 JTF_VARCHAR2_TABLE_2000
640: , p5_a10 JTF_DATE_TABLE
641: , p5_a11 JTF_DATE_TABLE
642: , p5_a12 JTF_NUMBER_TABLE
643: , p5_a13 JTF_DATE_TABLE
644: , p5_a14 JTF_NUMBER_TABLE
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE

Line 644: , p5_a14 JTF_NUMBER_TABLE

640: , p5_a10 JTF_DATE_TABLE
641: , p5_a11 JTF_DATE_TABLE
642: , p5_a12 JTF_NUMBER_TABLE
643: , p5_a13 JTF_DATE_TABLE
644: , p5_a14 JTF_NUMBER_TABLE
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE
647: , p5_a17 JTF_VARCHAR2_TABLE_100
648: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 646: , p5_a16 JTF_NUMBER_TABLE

642: , p5_a12 JTF_NUMBER_TABLE
643: , p5_a13 JTF_DATE_TABLE
644: , p5_a14 JTF_NUMBER_TABLE
645: , p5_a15 JTF_DATE_TABLE
646: , p5_a16 JTF_NUMBER_TABLE
647: , p5_a17 JTF_VARCHAR2_TABLE_100
648: , p5_a18 JTF_VARCHAR2_TABLE_100
649: , p5_a19 JTF_VARCHAR2_TABLE_100
650: );