APPS.OKL_RCT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_rct_pvt_w as
2: /* $Header: OKLIRCTS.pls 120.0 2007/11/19 10:32:29 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rct_pvt.rct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_rct_pvt_w as
2: /* $Header: OKLIRCTS.pls 120.0 2007/11/19 10:32:29 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rct_pvt.rct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_DATE_TABLE
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_DATE_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_DATE_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a44 JTF_VARCHAR2_TABLE_100

43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 50: , a1 out nocopy JTF_VARCHAR2_TABLE_100

46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_NUMBER_TABLE

Line 51: , a2 out nocopy JTF_VARCHAR2_TABLE_100

47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p2(t okl_rct_pvt.rct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_NUMBER_TABLE
55: , a6 out nocopy JTF_NUMBER_TABLE

Line 60: , a11 out nocopy JTF_VARCHAR2_TABLE_100

56: , a7 out nocopy JTF_DATE_TABLE
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_NUMBER_TABLE
59: , a10 out nocopy JTF_NUMBER_TABLE
60: , a11 out nocopy JTF_VARCHAR2_TABLE_100
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_DATE_TABLE
63: , a14 out nocopy JTF_VARCHAR2_TABLE_100
64: , a15 out nocopy JTF_NUMBER_TABLE

Line 63: , a14 out nocopy JTF_VARCHAR2_TABLE_100

59: , a10 out nocopy JTF_NUMBER_TABLE
60: , a11 out nocopy JTF_VARCHAR2_TABLE_100
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_DATE_TABLE
63: , a14 out nocopy JTF_VARCHAR2_TABLE_100
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_NUMBER_TABLE
67: , a18 out nocopy JTF_DATE_TABLE

Line 69: , a20 out nocopy JTF_VARCHAR2_TABLE_100

65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_NUMBER_TABLE
67: , a18 out nocopy JTF_DATE_TABLE
68: , a19 out nocopy JTF_NUMBER_TABLE
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_500
71: , a22 out nocopy JTF_VARCHAR2_TABLE_500
72: , a23 out nocopy JTF_VARCHAR2_TABLE_500
73: , a24 out nocopy JTF_VARCHAR2_TABLE_500

Line 90: , a41 out nocopy JTF_VARCHAR2_TABLE_100

86: , a37 out nocopy JTF_DATE_TABLE
87: , a38 out nocopy JTF_NUMBER_TABLE
88: , a39 out nocopy JTF_DATE_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );

Line 92: , a43 out nocopy JTF_VARCHAR2_TABLE_100

88: , a39 out nocopy JTF_DATE_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE

Line 93: , a44 out nocopy JTF_VARCHAR2_TABLE_100

89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100

Line 97: , a1 JTF_VARCHAR2_TABLE_100

93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_VARCHAR2_TABLE_100
99: , a3 JTF_VARCHAR2_TABLE_100
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE

Line 98: , a2 JTF_VARCHAR2_TABLE_100

94: );
95:
96: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_VARCHAR2_TABLE_100
99: , a3 JTF_VARCHAR2_TABLE_100
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_DATE_TABLE

Line 99: , a3 JTF_VARCHAR2_TABLE_100

95:
96: procedure rosetta_table_copy_in_p5(t out nocopy okl_rct_pvt.okltrxcshreceipttltbltype, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_VARCHAR2_TABLE_100
99: , a3 JTF_VARCHAR2_TABLE_100
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_DATE_TABLE
103: , a7 JTF_NUMBER_TABLE

Line 108: , a1 out nocopy JTF_VARCHAR2_TABLE_100

104: , a8 JTF_DATE_TABLE
105: , a9 JTF_NUMBER_TABLE
106: );
107: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE

Line 109: , a2 out nocopy JTF_VARCHAR2_TABLE_100

105: , a9 JTF_NUMBER_TABLE
106: );
107: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_DATE_TABLE

Line 110: , a3 out nocopy JTF_VARCHAR2_TABLE_100

106: );
107: procedure rosetta_table_copy_out_p5(t okl_rct_pvt.okltrxcshreceipttltbltype, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_DATE_TABLE
114: , a7 out nocopy JTF_NUMBER_TABLE

Line 121: , a2 JTF_VARCHAR2_TABLE_100

117: );
118:
119: procedure rosetta_table_copy_in_p8(t out nocopy okl_rct_pvt.rctv_tbl_type, a0 JTF_NUMBER_TABLE
120: , a1 JTF_NUMBER_TABLE
121: , a2 JTF_VARCHAR2_TABLE_100
122: , a3 JTF_NUMBER_TABLE
123: , a4 JTF_NUMBER_TABLE
124: , a5 JTF_DATE_TABLE
125: , a6 JTF_NUMBER_TABLE

Line 127: , a8 JTF_VARCHAR2_TABLE_100

123: , a4 JTF_NUMBER_TABLE
124: , a5 JTF_DATE_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_NUMBER_TABLE
127: , a8 JTF_VARCHAR2_TABLE_100
128: , a9 JTF_VARCHAR2_TABLE_100
129: , a10 JTF_VARCHAR2_TABLE_100
130: , a11 JTF_DATE_TABLE
131: , a12 JTF_NUMBER_TABLE

Line 128: , a9 JTF_VARCHAR2_TABLE_100

124: , a5 JTF_DATE_TABLE
125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_NUMBER_TABLE
127: , a8 JTF_VARCHAR2_TABLE_100
128: , a9 JTF_VARCHAR2_TABLE_100
129: , a10 JTF_VARCHAR2_TABLE_100
130: , a11 JTF_DATE_TABLE
131: , a12 JTF_NUMBER_TABLE
132: , a13 JTF_NUMBER_TABLE

Line 129: , a10 JTF_VARCHAR2_TABLE_100

125: , a6 JTF_NUMBER_TABLE
126: , a7 JTF_NUMBER_TABLE
127: , a8 JTF_VARCHAR2_TABLE_100
128: , a9 JTF_VARCHAR2_TABLE_100
129: , a10 JTF_VARCHAR2_TABLE_100
130: , a11 JTF_DATE_TABLE
131: , a12 JTF_NUMBER_TABLE
132: , a13 JTF_NUMBER_TABLE
133: , a14 JTF_DATE_TABLE

Line 134: , a15 JTF_VARCHAR2_TABLE_100

130: , a11 JTF_DATE_TABLE
131: , a12 JTF_NUMBER_TABLE
132: , a13 JTF_NUMBER_TABLE
133: , a14 JTF_DATE_TABLE
134: , a15 JTF_VARCHAR2_TABLE_100
135: , a16 JTF_VARCHAR2_TABLE_2000
136: , a17 JTF_VARCHAR2_TABLE_100
137: , a18 JTF_VARCHAR2_TABLE_500
138: , a19 JTF_VARCHAR2_TABLE_500

Line 136: , a17 JTF_VARCHAR2_TABLE_100

132: , a13 JTF_NUMBER_TABLE
133: , a14 JTF_DATE_TABLE
134: , a15 JTF_VARCHAR2_TABLE_100
135: , a16 JTF_VARCHAR2_TABLE_2000
136: , a17 JTF_VARCHAR2_TABLE_100
137: , a18 JTF_VARCHAR2_TABLE_500
138: , a19 JTF_VARCHAR2_TABLE_500
139: , a20 JTF_VARCHAR2_TABLE_500
140: , a21 JTF_VARCHAR2_TABLE_500

Line 162: , a43 JTF_VARCHAR2_TABLE_100

158: , a39 JTF_DATE_TABLE
159: , a40 JTF_NUMBER_TABLE
160: , a41 JTF_DATE_TABLE
161: , a42 JTF_NUMBER_TABLE
162: , a43 JTF_VARCHAR2_TABLE_100
163: , a44 JTF_NUMBER_TABLE
164: , a45 JTF_VARCHAR2_TABLE_100
165: , a46 JTF_VARCHAR2_TABLE_100
166: );

Line 164: , a45 JTF_VARCHAR2_TABLE_100

160: , a41 JTF_DATE_TABLE
161: , a42 JTF_NUMBER_TABLE
162: , a43 JTF_VARCHAR2_TABLE_100
163: , a44 JTF_NUMBER_TABLE
164: , a45 JTF_VARCHAR2_TABLE_100
165: , a46 JTF_VARCHAR2_TABLE_100
166: );
167: procedure rosetta_table_copy_out_p8(t okl_rct_pvt.rctv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE

Line 165: , a46 JTF_VARCHAR2_TABLE_100

161: , a42 JTF_NUMBER_TABLE
162: , a43 JTF_VARCHAR2_TABLE_100
163: , a44 JTF_NUMBER_TABLE
164: , a45 JTF_VARCHAR2_TABLE_100
165: , a46 JTF_VARCHAR2_TABLE_100
166: );
167: procedure rosetta_table_copy_out_p8(t okl_rct_pvt.rctv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 169: , a2 out nocopy JTF_VARCHAR2_TABLE_100

165: , a46 JTF_VARCHAR2_TABLE_100
166: );
167: procedure rosetta_table_copy_out_p8(t okl_rct_pvt.rctv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
168: , a1 out nocopy JTF_NUMBER_TABLE
169: , a2 out nocopy JTF_VARCHAR2_TABLE_100
170: , a3 out nocopy JTF_NUMBER_TABLE
171: , a4 out nocopy JTF_NUMBER_TABLE
172: , a5 out nocopy JTF_DATE_TABLE
173: , a6 out nocopy JTF_NUMBER_TABLE

Line 175: , a8 out nocopy JTF_VARCHAR2_TABLE_100

171: , a4 out nocopy JTF_NUMBER_TABLE
172: , a5 out nocopy JTF_DATE_TABLE
173: , a6 out nocopy JTF_NUMBER_TABLE
174: , a7 out nocopy JTF_NUMBER_TABLE
175: , a8 out nocopy JTF_VARCHAR2_TABLE_100
176: , a9 out nocopy JTF_VARCHAR2_TABLE_100
177: , a10 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE

Line 176: , a9 out nocopy JTF_VARCHAR2_TABLE_100

172: , a5 out nocopy JTF_DATE_TABLE
173: , a6 out nocopy JTF_NUMBER_TABLE
174: , a7 out nocopy JTF_NUMBER_TABLE
175: , a8 out nocopy JTF_VARCHAR2_TABLE_100
176: , a9 out nocopy JTF_VARCHAR2_TABLE_100
177: , a10 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_NUMBER_TABLE

Line 177: , a10 out nocopy JTF_VARCHAR2_TABLE_100

173: , a6 out nocopy JTF_NUMBER_TABLE
174: , a7 out nocopy JTF_NUMBER_TABLE
175: , a8 out nocopy JTF_VARCHAR2_TABLE_100
176: , a9 out nocopy JTF_VARCHAR2_TABLE_100
177: , a10 out nocopy JTF_VARCHAR2_TABLE_100
178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_NUMBER_TABLE
181: , a14 out nocopy JTF_DATE_TABLE

Line 182: , a15 out nocopy JTF_VARCHAR2_TABLE_100

178: , a11 out nocopy JTF_DATE_TABLE
179: , a12 out nocopy JTF_NUMBER_TABLE
180: , a13 out nocopy JTF_NUMBER_TABLE
181: , a14 out nocopy JTF_DATE_TABLE
182: , a15 out nocopy JTF_VARCHAR2_TABLE_100
183: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
184: , a17 out nocopy JTF_VARCHAR2_TABLE_100
185: , a18 out nocopy JTF_VARCHAR2_TABLE_500
186: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 184: , a17 out nocopy JTF_VARCHAR2_TABLE_100

180: , a13 out nocopy JTF_NUMBER_TABLE
181: , a14 out nocopy JTF_DATE_TABLE
182: , a15 out nocopy JTF_VARCHAR2_TABLE_100
183: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
184: , a17 out nocopy JTF_VARCHAR2_TABLE_100
185: , a18 out nocopy JTF_VARCHAR2_TABLE_500
186: , a19 out nocopy JTF_VARCHAR2_TABLE_500
187: , a20 out nocopy JTF_VARCHAR2_TABLE_500
188: , a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 210: , a43 out nocopy JTF_VARCHAR2_TABLE_100

206: , a39 out nocopy JTF_DATE_TABLE
207: , a40 out nocopy JTF_NUMBER_TABLE
208: , a41 out nocopy JTF_DATE_TABLE
209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_NUMBER_TABLE
212: , a45 out nocopy JTF_VARCHAR2_TABLE_100
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
214: );

Line 212: , a45 out nocopy JTF_VARCHAR2_TABLE_100

208: , a41 out nocopy JTF_DATE_TABLE
209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_NUMBER_TABLE
212: , a45 out nocopy JTF_VARCHAR2_TABLE_100
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
214: );
215:
216: procedure insert_row(p_api_version NUMBER

Line 213: , a46 out nocopy JTF_VARCHAR2_TABLE_100

209: , a42 out nocopy JTF_NUMBER_TABLE
210: , a43 out nocopy JTF_VARCHAR2_TABLE_100
211: , a44 out nocopy JTF_NUMBER_TABLE
212: , a45 out nocopy JTF_VARCHAR2_TABLE_100
213: , a46 out nocopy JTF_VARCHAR2_TABLE_100
214: );
215:
216: procedure insert_row(p_api_version NUMBER
217: , p_init_msg_list VARCHAR2

Line 323: , p5_a2 JTF_VARCHAR2_TABLE_100

319: , x_msg_count out nocopy NUMBER
320: , x_msg_data out nocopy VARCHAR2
321: , p5_a0 JTF_NUMBER_TABLE
322: , p5_a1 JTF_NUMBER_TABLE
323: , p5_a2 JTF_VARCHAR2_TABLE_100
324: , p5_a3 JTF_NUMBER_TABLE
325: , p5_a4 JTF_NUMBER_TABLE
326: , p5_a5 JTF_DATE_TABLE
327: , p5_a6 JTF_NUMBER_TABLE

Line 329: , p5_a8 JTF_VARCHAR2_TABLE_100

325: , p5_a4 JTF_NUMBER_TABLE
326: , p5_a5 JTF_DATE_TABLE
327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_NUMBER_TABLE
329: , p5_a8 JTF_VARCHAR2_TABLE_100
330: , p5_a9 JTF_VARCHAR2_TABLE_100
331: , p5_a10 JTF_VARCHAR2_TABLE_100
332: , p5_a11 JTF_DATE_TABLE
333: , p5_a12 JTF_NUMBER_TABLE

Line 330: , p5_a9 JTF_VARCHAR2_TABLE_100

326: , p5_a5 JTF_DATE_TABLE
327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_NUMBER_TABLE
329: , p5_a8 JTF_VARCHAR2_TABLE_100
330: , p5_a9 JTF_VARCHAR2_TABLE_100
331: , p5_a10 JTF_VARCHAR2_TABLE_100
332: , p5_a11 JTF_DATE_TABLE
333: , p5_a12 JTF_NUMBER_TABLE
334: , p5_a13 JTF_NUMBER_TABLE

Line 331: , p5_a10 JTF_VARCHAR2_TABLE_100

327: , p5_a6 JTF_NUMBER_TABLE
328: , p5_a7 JTF_NUMBER_TABLE
329: , p5_a8 JTF_VARCHAR2_TABLE_100
330: , p5_a9 JTF_VARCHAR2_TABLE_100
331: , p5_a10 JTF_VARCHAR2_TABLE_100
332: , p5_a11 JTF_DATE_TABLE
333: , p5_a12 JTF_NUMBER_TABLE
334: , p5_a13 JTF_NUMBER_TABLE
335: , p5_a14 JTF_DATE_TABLE

Line 336: , p5_a15 JTF_VARCHAR2_TABLE_100

332: , p5_a11 JTF_DATE_TABLE
333: , p5_a12 JTF_NUMBER_TABLE
334: , p5_a13 JTF_NUMBER_TABLE
335: , p5_a14 JTF_DATE_TABLE
336: , p5_a15 JTF_VARCHAR2_TABLE_100
337: , p5_a16 JTF_VARCHAR2_TABLE_2000
338: , p5_a17 JTF_VARCHAR2_TABLE_100
339: , p5_a18 JTF_VARCHAR2_TABLE_500
340: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 338: , p5_a17 JTF_VARCHAR2_TABLE_100

334: , p5_a13 JTF_NUMBER_TABLE
335: , p5_a14 JTF_DATE_TABLE
336: , p5_a15 JTF_VARCHAR2_TABLE_100
337: , p5_a16 JTF_VARCHAR2_TABLE_2000
338: , p5_a17 JTF_VARCHAR2_TABLE_100
339: , p5_a18 JTF_VARCHAR2_TABLE_500
340: , p5_a19 JTF_VARCHAR2_TABLE_500
341: , p5_a20 JTF_VARCHAR2_TABLE_500
342: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 364: , p5_a43 JTF_VARCHAR2_TABLE_100

360: , p5_a39 JTF_DATE_TABLE
361: , p5_a40 JTF_NUMBER_TABLE
362: , p5_a41 JTF_DATE_TABLE
363: , p5_a42 JTF_NUMBER_TABLE
364: , p5_a43 JTF_VARCHAR2_TABLE_100
365: , p5_a44 JTF_NUMBER_TABLE
366: , p5_a45 JTF_VARCHAR2_TABLE_100
367: , p5_a46 JTF_VARCHAR2_TABLE_100
368: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 366: , p5_a45 JTF_VARCHAR2_TABLE_100

362: , p5_a41 JTF_DATE_TABLE
363: , p5_a42 JTF_NUMBER_TABLE
364: , p5_a43 JTF_VARCHAR2_TABLE_100
365: , p5_a44 JTF_NUMBER_TABLE
366: , p5_a45 JTF_VARCHAR2_TABLE_100
367: , p5_a46 JTF_VARCHAR2_TABLE_100
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_NUMBER_TABLE
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 367: , p5_a46 JTF_VARCHAR2_TABLE_100

363: , p5_a42 JTF_NUMBER_TABLE
364: , p5_a43 JTF_VARCHAR2_TABLE_100
365: , p5_a44 JTF_NUMBER_TABLE
366: , p5_a45 JTF_VARCHAR2_TABLE_100
367: , p5_a46 JTF_VARCHAR2_TABLE_100
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_NUMBER_TABLE
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

366: , p5_a45 JTF_VARCHAR2_TABLE_100
367: , p5_a46 JTF_VARCHAR2_TABLE_100
368: , p6_a0 out nocopy JTF_NUMBER_TABLE
369: , p6_a1 out nocopy JTF_NUMBER_TABLE
370: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a3 out nocopy JTF_NUMBER_TABLE
372: , p6_a4 out nocopy JTF_NUMBER_TABLE
373: , p6_a5 out nocopy JTF_DATE_TABLE
374: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 376: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

372: , p6_a4 out nocopy JTF_NUMBER_TABLE
373: , p6_a5 out nocopy JTF_DATE_TABLE
374: , p6_a6 out nocopy JTF_NUMBER_TABLE
375: , p6_a7 out nocopy JTF_NUMBER_TABLE
376: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
377: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a11 out nocopy JTF_DATE_TABLE
380: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 377: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

373: , p6_a5 out nocopy JTF_DATE_TABLE
374: , p6_a6 out nocopy JTF_NUMBER_TABLE
375: , p6_a7 out nocopy JTF_NUMBER_TABLE
376: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
377: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a11 out nocopy JTF_DATE_TABLE
380: , p6_a12 out nocopy JTF_NUMBER_TABLE
381: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 378: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

374: , p6_a6 out nocopy JTF_NUMBER_TABLE
375: , p6_a7 out nocopy JTF_NUMBER_TABLE
376: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
377: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a11 out nocopy JTF_DATE_TABLE
380: , p6_a12 out nocopy JTF_NUMBER_TABLE
381: , p6_a13 out nocopy JTF_NUMBER_TABLE
382: , p6_a14 out nocopy JTF_DATE_TABLE

Line 383: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

379: , p6_a11 out nocopy JTF_DATE_TABLE
380: , p6_a12 out nocopy JTF_NUMBER_TABLE
381: , p6_a13 out nocopy JTF_NUMBER_TABLE
382: , p6_a14 out nocopy JTF_DATE_TABLE
383: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
384: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
387: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 385: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

381: , p6_a13 out nocopy JTF_NUMBER_TABLE
382: , p6_a14 out nocopy JTF_DATE_TABLE
383: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
384: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
387: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
388: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 411: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

407: , p6_a39 out nocopy JTF_DATE_TABLE
408: , p6_a40 out nocopy JTF_NUMBER_TABLE
409: , p6_a41 out nocopy JTF_DATE_TABLE
410: , p6_a42 out nocopy JTF_NUMBER_TABLE
411: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a44 out nocopy JTF_NUMBER_TABLE
413: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
415: );

Line 413: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

409: , p6_a41 out nocopy JTF_DATE_TABLE
410: , p6_a42 out nocopy JTF_NUMBER_TABLE
411: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a44 out nocopy JTF_NUMBER_TABLE
413: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
415: );
416: procedure lock_row(p_api_version NUMBER
417: , p_init_msg_list VARCHAR2

Line 414: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

410: , p6_a42 out nocopy JTF_NUMBER_TABLE
411: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a44 out nocopy JTF_NUMBER_TABLE
413: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
415: );
416: procedure lock_row(p_api_version NUMBER
417: , p_init_msg_list VARCHAR2
418: , x_return_status out nocopy VARCHAR2

Line 476: , p5_a2 JTF_VARCHAR2_TABLE_100

472: , x_msg_count out nocopy NUMBER
473: , x_msg_data out nocopy VARCHAR2
474: , p5_a0 JTF_NUMBER_TABLE
475: , p5_a1 JTF_NUMBER_TABLE
476: , p5_a2 JTF_VARCHAR2_TABLE_100
477: , p5_a3 JTF_NUMBER_TABLE
478: , p5_a4 JTF_NUMBER_TABLE
479: , p5_a5 JTF_DATE_TABLE
480: , p5_a6 JTF_NUMBER_TABLE

Line 482: , p5_a8 JTF_VARCHAR2_TABLE_100

478: , p5_a4 JTF_NUMBER_TABLE
479: , p5_a5 JTF_DATE_TABLE
480: , p5_a6 JTF_NUMBER_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_VARCHAR2_TABLE_100
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_VARCHAR2_TABLE_100
485: , p5_a11 JTF_DATE_TABLE
486: , p5_a12 JTF_NUMBER_TABLE

Line 483: , p5_a9 JTF_VARCHAR2_TABLE_100

479: , p5_a5 JTF_DATE_TABLE
480: , p5_a6 JTF_NUMBER_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_VARCHAR2_TABLE_100
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_VARCHAR2_TABLE_100
485: , p5_a11 JTF_DATE_TABLE
486: , p5_a12 JTF_NUMBER_TABLE
487: , p5_a13 JTF_NUMBER_TABLE

Line 484: , p5_a10 JTF_VARCHAR2_TABLE_100

480: , p5_a6 JTF_NUMBER_TABLE
481: , p5_a7 JTF_NUMBER_TABLE
482: , p5_a8 JTF_VARCHAR2_TABLE_100
483: , p5_a9 JTF_VARCHAR2_TABLE_100
484: , p5_a10 JTF_VARCHAR2_TABLE_100
485: , p5_a11 JTF_DATE_TABLE
486: , p5_a12 JTF_NUMBER_TABLE
487: , p5_a13 JTF_NUMBER_TABLE
488: , p5_a14 JTF_DATE_TABLE

Line 489: , p5_a15 JTF_VARCHAR2_TABLE_100

485: , p5_a11 JTF_DATE_TABLE
486: , p5_a12 JTF_NUMBER_TABLE
487: , p5_a13 JTF_NUMBER_TABLE
488: , p5_a14 JTF_DATE_TABLE
489: , p5_a15 JTF_VARCHAR2_TABLE_100
490: , p5_a16 JTF_VARCHAR2_TABLE_2000
491: , p5_a17 JTF_VARCHAR2_TABLE_100
492: , p5_a18 JTF_VARCHAR2_TABLE_500
493: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 491: , p5_a17 JTF_VARCHAR2_TABLE_100

487: , p5_a13 JTF_NUMBER_TABLE
488: , p5_a14 JTF_DATE_TABLE
489: , p5_a15 JTF_VARCHAR2_TABLE_100
490: , p5_a16 JTF_VARCHAR2_TABLE_2000
491: , p5_a17 JTF_VARCHAR2_TABLE_100
492: , p5_a18 JTF_VARCHAR2_TABLE_500
493: , p5_a19 JTF_VARCHAR2_TABLE_500
494: , p5_a20 JTF_VARCHAR2_TABLE_500
495: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 517: , p5_a43 JTF_VARCHAR2_TABLE_100

513: , p5_a39 JTF_DATE_TABLE
514: , p5_a40 JTF_NUMBER_TABLE
515: , p5_a41 JTF_DATE_TABLE
516: , p5_a42 JTF_NUMBER_TABLE
517: , p5_a43 JTF_VARCHAR2_TABLE_100
518: , p5_a44 JTF_NUMBER_TABLE
519: , p5_a45 JTF_VARCHAR2_TABLE_100
520: , p5_a46 JTF_VARCHAR2_TABLE_100
521: );

Line 519: , p5_a45 JTF_VARCHAR2_TABLE_100

515: , p5_a41 JTF_DATE_TABLE
516: , p5_a42 JTF_NUMBER_TABLE
517: , p5_a43 JTF_VARCHAR2_TABLE_100
518: , p5_a44 JTF_NUMBER_TABLE
519: , p5_a45 JTF_VARCHAR2_TABLE_100
520: , p5_a46 JTF_VARCHAR2_TABLE_100
521: );
522: procedure update_row(p_api_version NUMBER
523: , p_init_msg_list VARCHAR2

Line 520: , p5_a46 JTF_VARCHAR2_TABLE_100

516: , p5_a42 JTF_NUMBER_TABLE
517: , p5_a43 JTF_VARCHAR2_TABLE_100
518: , p5_a44 JTF_NUMBER_TABLE
519: , p5_a45 JTF_VARCHAR2_TABLE_100
520: , p5_a46 JTF_VARCHAR2_TABLE_100
521: );
522: procedure update_row(p_api_version NUMBER
523: , p_init_msg_list VARCHAR2
524: , x_return_status out nocopy VARCHAR2

Line 629: , p5_a2 JTF_VARCHAR2_TABLE_100

625: , x_msg_count out nocopy NUMBER
626: , x_msg_data out nocopy VARCHAR2
627: , p5_a0 JTF_NUMBER_TABLE
628: , p5_a1 JTF_NUMBER_TABLE
629: , p5_a2 JTF_VARCHAR2_TABLE_100
630: , p5_a3 JTF_NUMBER_TABLE
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_DATE_TABLE
633: , p5_a6 JTF_NUMBER_TABLE

Line 635: , p5_a8 JTF_VARCHAR2_TABLE_100

631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_DATE_TABLE
633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_NUMBER_TABLE
635: , p5_a8 JTF_VARCHAR2_TABLE_100
636: , p5_a9 JTF_VARCHAR2_TABLE_100
637: , p5_a10 JTF_VARCHAR2_TABLE_100
638: , p5_a11 JTF_DATE_TABLE
639: , p5_a12 JTF_NUMBER_TABLE

Line 636: , p5_a9 JTF_VARCHAR2_TABLE_100

632: , p5_a5 JTF_DATE_TABLE
633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_NUMBER_TABLE
635: , p5_a8 JTF_VARCHAR2_TABLE_100
636: , p5_a9 JTF_VARCHAR2_TABLE_100
637: , p5_a10 JTF_VARCHAR2_TABLE_100
638: , p5_a11 JTF_DATE_TABLE
639: , p5_a12 JTF_NUMBER_TABLE
640: , p5_a13 JTF_NUMBER_TABLE

Line 637: , p5_a10 JTF_VARCHAR2_TABLE_100

633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_NUMBER_TABLE
635: , p5_a8 JTF_VARCHAR2_TABLE_100
636: , p5_a9 JTF_VARCHAR2_TABLE_100
637: , p5_a10 JTF_VARCHAR2_TABLE_100
638: , p5_a11 JTF_DATE_TABLE
639: , p5_a12 JTF_NUMBER_TABLE
640: , p5_a13 JTF_NUMBER_TABLE
641: , p5_a14 JTF_DATE_TABLE

Line 642: , p5_a15 JTF_VARCHAR2_TABLE_100

638: , p5_a11 JTF_DATE_TABLE
639: , p5_a12 JTF_NUMBER_TABLE
640: , p5_a13 JTF_NUMBER_TABLE
641: , p5_a14 JTF_DATE_TABLE
642: , p5_a15 JTF_VARCHAR2_TABLE_100
643: , p5_a16 JTF_VARCHAR2_TABLE_2000
644: , p5_a17 JTF_VARCHAR2_TABLE_100
645: , p5_a18 JTF_VARCHAR2_TABLE_500
646: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 644: , p5_a17 JTF_VARCHAR2_TABLE_100

640: , p5_a13 JTF_NUMBER_TABLE
641: , p5_a14 JTF_DATE_TABLE
642: , p5_a15 JTF_VARCHAR2_TABLE_100
643: , p5_a16 JTF_VARCHAR2_TABLE_2000
644: , p5_a17 JTF_VARCHAR2_TABLE_100
645: , p5_a18 JTF_VARCHAR2_TABLE_500
646: , p5_a19 JTF_VARCHAR2_TABLE_500
647: , p5_a20 JTF_VARCHAR2_TABLE_500
648: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 670: , p5_a43 JTF_VARCHAR2_TABLE_100

666: , p5_a39 JTF_DATE_TABLE
667: , p5_a40 JTF_NUMBER_TABLE
668: , p5_a41 JTF_DATE_TABLE
669: , p5_a42 JTF_NUMBER_TABLE
670: , p5_a43 JTF_VARCHAR2_TABLE_100
671: , p5_a44 JTF_NUMBER_TABLE
672: , p5_a45 JTF_VARCHAR2_TABLE_100
673: , p5_a46 JTF_VARCHAR2_TABLE_100
674: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 672: , p5_a45 JTF_VARCHAR2_TABLE_100

668: , p5_a41 JTF_DATE_TABLE
669: , p5_a42 JTF_NUMBER_TABLE
670: , p5_a43 JTF_VARCHAR2_TABLE_100
671: , p5_a44 JTF_NUMBER_TABLE
672: , p5_a45 JTF_VARCHAR2_TABLE_100
673: , p5_a46 JTF_VARCHAR2_TABLE_100
674: , p6_a0 out nocopy JTF_NUMBER_TABLE
675: , p6_a1 out nocopy JTF_NUMBER_TABLE
676: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 673: , p5_a46 JTF_VARCHAR2_TABLE_100

669: , p5_a42 JTF_NUMBER_TABLE
670: , p5_a43 JTF_VARCHAR2_TABLE_100
671: , p5_a44 JTF_NUMBER_TABLE
672: , p5_a45 JTF_VARCHAR2_TABLE_100
673: , p5_a46 JTF_VARCHAR2_TABLE_100
674: , p6_a0 out nocopy JTF_NUMBER_TABLE
675: , p6_a1 out nocopy JTF_NUMBER_TABLE
676: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 676: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

672: , p5_a45 JTF_VARCHAR2_TABLE_100
673: , p5_a46 JTF_VARCHAR2_TABLE_100
674: , p6_a0 out nocopy JTF_NUMBER_TABLE
675: , p6_a1 out nocopy JTF_NUMBER_TABLE
676: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a3 out nocopy JTF_NUMBER_TABLE
678: , p6_a4 out nocopy JTF_NUMBER_TABLE
679: , p6_a5 out nocopy JTF_DATE_TABLE
680: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 682: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

678: , p6_a4 out nocopy JTF_NUMBER_TABLE
679: , p6_a5 out nocopy JTF_DATE_TABLE
680: , p6_a6 out nocopy JTF_NUMBER_TABLE
681: , p6_a7 out nocopy JTF_NUMBER_TABLE
682: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
683: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
684: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
685: , p6_a11 out nocopy JTF_DATE_TABLE
686: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 683: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

679: , p6_a5 out nocopy JTF_DATE_TABLE
680: , p6_a6 out nocopy JTF_NUMBER_TABLE
681: , p6_a7 out nocopy JTF_NUMBER_TABLE
682: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
683: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
684: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
685: , p6_a11 out nocopy JTF_DATE_TABLE
686: , p6_a12 out nocopy JTF_NUMBER_TABLE
687: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 684: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

680: , p6_a6 out nocopy JTF_NUMBER_TABLE
681: , p6_a7 out nocopy JTF_NUMBER_TABLE
682: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
683: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
684: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
685: , p6_a11 out nocopy JTF_DATE_TABLE
686: , p6_a12 out nocopy JTF_NUMBER_TABLE
687: , p6_a13 out nocopy JTF_NUMBER_TABLE
688: , p6_a14 out nocopy JTF_DATE_TABLE

Line 689: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

685: , p6_a11 out nocopy JTF_DATE_TABLE
686: , p6_a12 out nocopy JTF_NUMBER_TABLE
687: , p6_a13 out nocopy JTF_NUMBER_TABLE
688: , p6_a14 out nocopy JTF_DATE_TABLE
689: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
690: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
691: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
692: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
693: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 691: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

687: , p6_a13 out nocopy JTF_NUMBER_TABLE
688: , p6_a14 out nocopy JTF_DATE_TABLE
689: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
690: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
691: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
692: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
693: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
694: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
695: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 717: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100

713: , p6_a39 out nocopy JTF_DATE_TABLE
714: , p6_a40 out nocopy JTF_NUMBER_TABLE
715: , p6_a41 out nocopy JTF_DATE_TABLE
716: , p6_a42 out nocopy JTF_NUMBER_TABLE
717: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a44 out nocopy JTF_NUMBER_TABLE
719: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
721: );

Line 719: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

715: , p6_a41 out nocopy JTF_DATE_TABLE
716: , p6_a42 out nocopy JTF_NUMBER_TABLE
717: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a44 out nocopy JTF_NUMBER_TABLE
719: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
721: );
722: procedure delete_row(p_api_version NUMBER
723: , p_init_msg_list VARCHAR2

Line 720: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

716: , p6_a42 out nocopy JTF_NUMBER_TABLE
717: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a44 out nocopy JTF_NUMBER_TABLE
719: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
721: );
722: procedure delete_row(p_api_version NUMBER
723: , p_init_msg_list VARCHAR2
724: , x_return_status out nocopy VARCHAR2

Line 782: , p5_a2 JTF_VARCHAR2_TABLE_100

778: , x_msg_count out nocopy NUMBER
779: , x_msg_data out nocopy VARCHAR2
780: , p5_a0 JTF_NUMBER_TABLE
781: , p5_a1 JTF_NUMBER_TABLE
782: , p5_a2 JTF_VARCHAR2_TABLE_100
783: , p5_a3 JTF_NUMBER_TABLE
784: , p5_a4 JTF_NUMBER_TABLE
785: , p5_a5 JTF_DATE_TABLE
786: , p5_a6 JTF_NUMBER_TABLE

Line 788: , p5_a8 JTF_VARCHAR2_TABLE_100

784: , p5_a4 JTF_NUMBER_TABLE
785: , p5_a5 JTF_DATE_TABLE
786: , p5_a6 JTF_NUMBER_TABLE
787: , p5_a7 JTF_NUMBER_TABLE
788: , p5_a8 JTF_VARCHAR2_TABLE_100
789: , p5_a9 JTF_VARCHAR2_TABLE_100
790: , p5_a10 JTF_VARCHAR2_TABLE_100
791: , p5_a11 JTF_DATE_TABLE
792: , p5_a12 JTF_NUMBER_TABLE

Line 789: , p5_a9 JTF_VARCHAR2_TABLE_100

785: , p5_a5 JTF_DATE_TABLE
786: , p5_a6 JTF_NUMBER_TABLE
787: , p5_a7 JTF_NUMBER_TABLE
788: , p5_a8 JTF_VARCHAR2_TABLE_100
789: , p5_a9 JTF_VARCHAR2_TABLE_100
790: , p5_a10 JTF_VARCHAR2_TABLE_100
791: , p5_a11 JTF_DATE_TABLE
792: , p5_a12 JTF_NUMBER_TABLE
793: , p5_a13 JTF_NUMBER_TABLE

Line 790: , p5_a10 JTF_VARCHAR2_TABLE_100

786: , p5_a6 JTF_NUMBER_TABLE
787: , p5_a7 JTF_NUMBER_TABLE
788: , p5_a8 JTF_VARCHAR2_TABLE_100
789: , p5_a9 JTF_VARCHAR2_TABLE_100
790: , p5_a10 JTF_VARCHAR2_TABLE_100
791: , p5_a11 JTF_DATE_TABLE
792: , p5_a12 JTF_NUMBER_TABLE
793: , p5_a13 JTF_NUMBER_TABLE
794: , p5_a14 JTF_DATE_TABLE

Line 795: , p5_a15 JTF_VARCHAR2_TABLE_100

791: , p5_a11 JTF_DATE_TABLE
792: , p5_a12 JTF_NUMBER_TABLE
793: , p5_a13 JTF_NUMBER_TABLE
794: , p5_a14 JTF_DATE_TABLE
795: , p5_a15 JTF_VARCHAR2_TABLE_100
796: , p5_a16 JTF_VARCHAR2_TABLE_2000
797: , p5_a17 JTF_VARCHAR2_TABLE_100
798: , p5_a18 JTF_VARCHAR2_TABLE_500
799: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 797: , p5_a17 JTF_VARCHAR2_TABLE_100

793: , p5_a13 JTF_NUMBER_TABLE
794: , p5_a14 JTF_DATE_TABLE
795: , p5_a15 JTF_VARCHAR2_TABLE_100
796: , p5_a16 JTF_VARCHAR2_TABLE_2000
797: , p5_a17 JTF_VARCHAR2_TABLE_100
798: , p5_a18 JTF_VARCHAR2_TABLE_500
799: , p5_a19 JTF_VARCHAR2_TABLE_500
800: , p5_a20 JTF_VARCHAR2_TABLE_500
801: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 823: , p5_a43 JTF_VARCHAR2_TABLE_100

819: , p5_a39 JTF_DATE_TABLE
820: , p5_a40 JTF_NUMBER_TABLE
821: , p5_a41 JTF_DATE_TABLE
822: , p5_a42 JTF_NUMBER_TABLE
823: , p5_a43 JTF_VARCHAR2_TABLE_100
824: , p5_a44 JTF_NUMBER_TABLE
825: , p5_a45 JTF_VARCHAR2_TABLE_100
826: , p5_a46 JTF_VARCHAR2_TABLE_100
827: );

Line 825: , p5_a45 JTF_VARCHAR2_TABLE_100

821: , p5_a41 JTF_DATE_TABLE
822: , p5_a42 JTF_NUMBER_TABLE
823: , p5_a43 JTF_VARCHAR2_TABLE_100
824: , p5_a44 JTF_NUMBER_TABLE
825: , p5_a45 JTF_VARCHAR2_TABLE_100
826: , p5_a46 JTF_VARCHAR2_TABLE_100
827: );
828: procedure validate_row(p_api_version NUMBER
829: , p_init_msg_list VARCHAR2

Line 826: , p5_a46 JTF_VARCHAR2_TABLE_100

822: , p5_a42 JTF_NUMBER_TABLE
823: , p5_a43 JTF_VARCHAR2_TABLE_100
824: , p5_a44 JTF_NUMBER_TABLE
825: , p5_a45 JTF_VARCHAR2_TABLE_100
826: , p5_a46 JTF_VARCHAR2_TABLE_100
827: );
828: procedure validate_row(p_api_version NUMBER
829: , p_init_msg_list VARCHAR2
830: , x_return_status out nocopy VARCHAR2

Line 888: , p5_a2 JTF_VARCHAR2_TABLE_100

884: , x_msg_count out nocopy NUMBER
885: , x_msg_data out nocopy VARCHAR2
886: , p5_a0 JTF_NUMBER_TABLE
887: , p5_a1 JTF_NUMBER_TABLE
888: , p5_a2 JTF_VARCHAR2_TABLE_100
889: , p5_a3 JTF_NUMBER_TABLE
890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_DATE_TABLE
892: , p5_a6 JTF_NUMBER_TABLE

Line 894: , p5_a8 JTF_VARCHAR2_TABLE_100

890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_DATE_TABLE
892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_NUMBER_TABLE
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_100
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_DATE_TABLE
898: , p5_a12 JTF_NUMBER_TABLE

Line 895: , p5_a9 JTF_VARCHAR2_TABLE_100

891: , p5_a5 JTF_DATE_TABLE
892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_NUMBER_TABLE
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_100
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_DATE_TABLE
898: , p5_a12 JTF_NUMBER_TABLE
899: , p5_a13 JTF_NUMBER_TABLE

Line 896: , p5_a10 JTF_VARCHAR2_TABLE_100

892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_NUMBER_TABLE
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_100
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_DATE_TABLE
898: , p5_a12 JTF_NUMBER_TABLE
899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_DATE_TABLE

Line 901: , p5_a15 JTF_VARCHAR2_TABLE_100

897: , p5_a11 JTF_DATE_TABLE
898: , p5_a12 JTF_NUMBER_TABLE
899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_DATE_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_2000
903: , p5_a17 JTF_VARCHAR2_TABLE_100
904: , p5_a18 JTF_VARCHAR2_TABLE_500
905: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 903: , p5_a17 JTF_VARCHAR2_TABLE_100

899: , p5_a13 JTF_NUMBER_TABLE
900: , p5_a14 JTF_DATE_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_2000
903: , p5_a17 JTF_VARCHAR2_TABLE_100
904: , p5_a18 JTF_VARCHAR2_TABLE_500
905: , p5_a19 JTF_VARCHAR2_TABLE_500
906: , p5_a20 JTF_VARCHAR2_TABLE_500
907: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 929: , p5_a43 JTF_VARCHAR2_TABLE_100

925: , p5_a39 JTF_DATE_TABLE
926: , p5_a40 JTF_NUMBER_TABLE
927: , p5_a41 JTF_DATE_TABLE
928: , p5_a42 JTF_NUMBER_TABLE
929: , p5_a43 JTF_VARCHAR2_TABLE_100
930: , p5_a44 JTF_NUMBER_TABLE
931: , p5_a45 JTF_VARCHAR2_TABLE_100
932: , p5_a46 JTF_VARCHAR2_TABLE_100
933: );

Line 931: , p5_a45 JTF_VARCHAR2_TABLE_100

927: , p5_a41 JTF_DATE_TABLE
928: , p5_a42 JTF_NUMBER_TABLE
929: , p5_a43 JTF_VARCHAR2_TABLE_100
930: , p5_a44 JTF_NUMBER_TABLE
931: , p5_a45 JTF_VARCHAR2_TABLE_100
932: , p5_a46 JTF_VARCHAR2_TABLE_100
933: );
934: end okl_rct_pvt_w;

Line 932: , p5_a46 JTF_VARCHAR2_TABLE_100

928: , p5_a42 JTF_NUMBER_TABLE
929: , p5_a43 JTF_VARCHAR2_TABLE_100
930: , p5_a44 JTF_NUMBER_TABLE
931: , p5_a45 JTF_VARCHAR2_TABLE_100
932: , p5_a46 JTF_VARCHAR2_TABLE_100
933: );
934: end okl_rct_pvt_w;