DBA Data[Home] [Help]

APPS.OKL_LAP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_lap_pvt_w as
2: /* $Header: OKLILAPS.pls 120.4 2006/11/08 14:55:45 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lap_pvt.lapv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 22: , a19 JTF_VARCHAR2_TABLE_100

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

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 48: , a45 JTF_VARCHAR2_TABLE_100

44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_VARCHAR2_TABLE_2000
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p23(t okl_lap_pvt.lapv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE

Line 49: , a46 JTF_VARCHAR2_TABLE_100

45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_VARCHAR2_TABLE_2000
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p23(t okl_lap_pvt.lapv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a2 out nocopy JTF_VARCHAR2_TABLE_100

49: , a46 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p23(t okl_lap_pvt.lapv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_500
55: , a4 out nocopy JTF_VARCHAR2_TABLE_500
56: , a5 out nocopy JTF_VARCHAR2_TABLE_500
57: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 70: , a19 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 78: , a27 out nocopy JTF_VARCHAR2_TABLE_100

74: , a23 out nocopy JTF_NUMBER_TABLE
75: , a24 out nocopy JTF_NUMBER_TABLE
76: , a25 out nocopy JTF_NUMBER_TABLE
77: , a26 out nocopy JTF_NUMBER_TABLE
78: , a27 out nocopy JTF_VARCHAR2_TABLE_100
79: , a28 out nocopy JTF_VARCHAR2_TABLE_100
80: , a29 out nocopy JTF_VARCHAR2_TABLE_100
81: , a30 out nocopy JTF_VARCHAR2_TABLE_100
82: , a31 out nocopy JTF_NUMBER_TABLE

Line 79: , a28 out nocopy JTF_VARCHAR2_TABLE_100

75: , a24 out nocopy JTF_NUMBER_TABLE
76: , a25 out nocopy JTF_NUMBER_TABLE
77: , a26 out nocopy JTF_NUMBER_TABLE
78: , a27 out nocopy JTF_VARCHAR2_TABLE_100
79: , a28 out nocopy JTF_VARCHAR2_TABLE_100
80: , a29 out nocopy JTF_VARCHAR2_TABLE_100
81: , a30 out nocopy JTF_VARCHAR2_TABLE_100
82: , a31 out nocopy JTF_NUMBER_TABLE
83: , a32 out nocopy JTF_DATE_TABLE

Line 80: , a29 out nocopy JTF_VARCHAR2_TABLE_100

76: , a25 out nocopy JTF_NUMBER_TABLE
77: , a26 out nocopy JTF_NUMBER_TABLE
78: , a27 out nocopy JTF_VARCHAR2_TABLE_100
79: , a28 out nocopy JTF_VARCHAR2_TABLE_100
80: , a29 out nocopy JTF_VARCHAR2_TABLE_100
81: , a30 out nocopy JTF_VARCHAR2_TABLE_100
82: , a31 out nocopy JTF_NUMBER_TABLE
83: , a32 out nocopy JTF_DATE_TABLE
84: , a33 out nocopy JTF_NUMBER_TABLE

Line 81: , a30 out nocopy JTF_VARCHAR2_TABLE_100

77: , a26 out nocopy JTF_NUMBER_TABLE
78: , a27 out nocopy JTF_VARCHAR2_TABLE_100
79: , a28 out nocopy JTF_VARCHAR2_TABLE_100
80: , a29 out nocopy JTF_VARCHAR2_TABLE_100
81: , a30 out nocopy JTF_VARCHAR2_TABLE_100
82: , a31 out nocopy JTF_NUMBER_TABLE
83: , a32 out nocopy JTF_DATE_TABLE
84: , a33 out nocopy JTF_NUMBER_TABLE
85: , a34 out nocopy JTF_NUMBER_TABLE

Line 96: , a45 out nocopy JTF_VARCHAR2_TABLE_100

92: , a41 out nocopy JTF_NUMBER_TABLE
93: , a42 out nocopy JTF_VARCHAR2_TABLE_300
94: , a43 out nocopy JTF_VARCHAR2_TABLE_2000
95: , a44 out nocopy JTF_NUMBER_TABLE
96: , a45 out nocopy JTF_VARCHAR2_TABLE_100
97: , a46 out nocopy JTF_VARCHAR2_TABLE_100
98: );
99:
100: procedure insert_row(p_api_version NUMBER

Line 97: , a46 out nocopy JTF_VARCHAR2_TABLE_100

93: , a42 out nocopy JTF_VARCHAR2_TABLE_300
94: , a43 out nocopy JTF_VARCHAR2_TABLE_2000
95: , a44 out nocopy JTF_NUMBER_TABLE
96: , a45 out nocopy JTF_VARCHAR2_TABLE_100
97: , a46 out nocopy JTF_VARCHAR2_TABLE_100
98: );
99:
100: procedure insert_row(p_api_version NUMBER
101: , p_init_msg_list VARCHAR2

Line 107: , p5_a2 JTF_VARCHAR2_TABLE_100

103: , x_msg_count out nocopy NUMBER
104: , x_msg_data out nocopy VARCHAR2
105: , p5_a0 JTF_NUMBER_TABLE
106: , p5_a1 JTF_NUMBER_TABLE
107: , p5_a2 JTF_VARCHAR2_TABLE_100
108: , p5_a3 JTF_VARCHAR2_TABLE_500
109: , p5_a4 JTF_VARCHAR2_TABLE_500
110: , p5_a5 JTF_VARCHAR2_TABLE_500
111: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 124: , p5_a19 JTF_VARCHAR2_TABLE_100

120: , p5_a15 JTF_VARCHAR2_TABLE_500
121: , p5_a16 JTF_VARCHAR2_TABLE_500
122: , p5_a17 JTF_VARCHAR2_TABLE_500
123: , p5_a18 JTF_VARCHAR2_TABLE_200
124: , p5_a19 JTF_VARCHAR2_TABLE_100
125: , p5_a20 JTF_DATE_TABLE
126: , p5_a21 JTF_DATE_TABLE
127: , p5_a22 JTF_NUMBER_TABLE
128: , p5_a23 JTF_NUMBER_TABLE

Line 132: , p5_a27 JTF_VARCHAR2_TABLE_100

128: , p5_a23 JTF_NUMBER_TABLE
129: , p5_a24 JTF_NUMBER_TABLE
130: , p5_a25 JTF_NUMBER_TABLE
131: , p5_a26 JTF_NUMBER_TABLE
132: , p5_a27 JTF_VARCHAR2_TABLE_100
133: , p5_a28 JTF_VARCHAR2_TABLE_100
134: , p5_a29 JTF_VARCHAR2_TABLE_100
135: , p5_a30 JTF_VARCHAR2_TABLE_100
136: , p5_a31 JTF_NUMBER_TABLE

Line 133: , p5_a28 JTF_VARCHAR2_TABLE_100

129: , p5_a24 JTF_NUMBER_TABLE
130: , p5_a25 JTF_NUMBER_TABLE
131: , p5_a26 JTF_NUMBER_TABLE
132: , p5_a27 JTF_VARCHAR2_TABLE_100
133: , p5_a28 JTF_VARCHAR2_TABLE_100
134: , p5_a29 JTF_VARCHAR2_TABLE_100
135: , p5_a30 JTF_VARCHAR2_TABLE_100
136: , p5_a31 JTF_NUMBER_TABLE
137: , p5_a32 JTF_DATE_TABLE

Line 134: , p5_a29 JTF_VARCHAR2_TABLE_100

130: , p5_a25 JTF_NUMBER_TABLE
131: , p5_a26 JTF_NUMBER_TABLE
132: , p5_a27 JTF_VARCHAR2_TABLE_100
133: , p5_a28 JTF_VARCHAR2_TABLE_100
134: , p5_a29 JTF_VARCHAR2_TABLE_100
135: , p5_a30 JTF_VARCHAR2_TABLE_100
136: , p5_a31 JTF_NUMBER_TABLE
137: , p5_a32 JTF_DATE_TABLE
138: , p5_a33 JTF_NUMBER_TABLE

Line 135: , p5_a30 JTF_VARCHAR2_TABLE_100

131: , p5_a26 JTF_NUMBER_TABLE
132: , p5_a27 JTF_VARCHAR2_TABLE_100
133: , p5_a28 JTF_VARCHAR2_TABLE_100
134: , p5_a29 JTF_VARCHAR2_TABLE_100
135: , p5_a30 JTF_VARCHAR2_TABLE_100
136: , p5_a31 JTF_NUMBER_TABLE
137: , p5_a32 JTF_DATE_TABLE
138: , p5_a33 JTF_NUMBER_TABLE
139: , p5_a34 JTF_NUMBER_TABLE

Line 150: , p5_a45 JTF_VARCHAR2_TABLE_100

146: , p5_a41 JTF_NUMBER_TABLE
147: , p5_a42 JTF_VARCHAR2_TABLE_300
148: , p5_a43 JTF_VARCHAR2_TABLE_2000
149: , p5_a44 JTF_NUMBER_TABLE
150: , p5_a45 JTF_VARCHAR2_TABLE_100
151: , p5_a46 JTF_VARCHAR2_TABLE_100
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , p5_a46 JTF_VARCHAR2_TABLE_100

147: , p5_a42 JTF_VARCHAR2_TABLE_300
148: , p5_a43 JTF_VARCHAR2_TABLE_2000
149: , p5_a44 JTF_NUMBER_TABLE
150: , p5_a45 JTF_VARCHAR2_TABLE_100
151: , p5_a46 JTF_VARCHAR2_TABLE_100
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

150: , p5_a45 JTF_VARCHAR2_TABLE_100
151: , p5_a46 JTF_VARCHAR2_TABLE_100
152: , p6_a0 out nocopy JTF_NUMBER_TABLE
153: , p6_a1 out nocopy JTF_NUMBER_TABLE
154: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
156: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
157: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
158: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 171: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

167: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
169: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
170: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
171: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a20 out nocopy JTF_DATE_TABLE
173: , p6_a21 out nocopy JTF_DATE_TABLE
174: , p6_a22 out nocopy JTF_NUMBER_TABLE
175: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 179: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

175: , p6_a23 out nocopy JTF_NUMBER_TABLE
176: , p6_a24 out nocopy JTF_NUMBER_TABLE
177: , p6_a25 out nocopy JTF_NUMBER_TABLE
178: , p6_a26 out nocopy JTF_NUMBER_TABLE
179: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 180: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

176: , p6_a24 out nocopy JTF_NUMBER_TABLE
177: , p6_a25 out nocopy JTF_NUMBER_TABLE
178: , p6_a26 out nocopy JTF_NUMBER_TABLE
179: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a31 out nocopy JTF_NUMBER_TABLE
184: , p6_a32 out nocopy JTF_DATE_TABLE

Line 181: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

177: , p6_a25 out nocopy JTF_NUMBER_TABLE
178: , p6_a26 out nocopy JTF_NUMBER_TABLE
179: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a31 out nocopy JTF_NUMBER_TABLE
184: , p6_a32 out nocopy JTF_DATE_TABLE
185: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 182: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

178: , p6_a26 out nocopy JTF_NUMBER_TABLE
179: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a31 out nocopy JTF_NUMBER_TABLE
184: , p6_a32 out nocopy JTF_DATE_TABLE
185: , p6_a33 out nocopy JTF_NUMBER_TABLE
186: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 197: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

193: , p6_a41 out nocopy JTF_NUMBER_TABLE
194: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
195: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a44 out nocopy JTF_NUMBER_TABLE
197: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
199: );
200: procedure update_row(p_api_version NUMBER
201: , p_init_msg_list VARCHAR2

Line 198: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

194: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
195: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a44 out nocopy JTF_NUMBER_TABLE
197: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
199: );
200: procedure update_row(p_api_version NUMBER
201: , p_init_msg_list VARCHAR2
202: , x_return_status out nocopy VARCHAR2

Line 207: , p5_a2 JTF_VARCHAR2_TABLE_100

203: , x_msg_count out nocopy NUMBER
204: , x_msg_data out nocopy VARCHAR2
205: , p5_a0 JTF_NUMBER_TABLE
206: , p5_a1 JTF_NUMBER_TABLE
207: , p5_a2 JTF_VARCHAR2_TABLE_100
208: , p5_a3 JTF_VARCHAR2_TABLE_500
209: , p5_a4 JTF_VARCHAR2_TABLE_500
210: , p5_a5 JTF_VARCHAR2_TABLE_500
211: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 224: , p5_a19 JTF_VARCHAR2_TABLE_100

220: , p5_a15 JTF_VARCHAR2_TABLE_500
221: , p5_a16 JTF_VARCHAR2_TABLE_500
222: , p5_a17 JTF_VARCHAR2_TABLE_500
223: , p5_a18 JTF_VARCHAR2_TABLE_200
224: , p5_a19 JTF_VARCHAR2_TABLE_100
225: , p5_a20 JTF_DATE_TABLE
226: , p5_a21 JTF_DATE_TABLE
227: , p5_a22 JTF_NUMBER_TABLE
228: , p5_a23 JTF_NUMBER_TABLE

Line 232: , p5_a27 JTF_VARCHAR2_TABLE_100

228: , p5_a23 JTF_NUMBER_TABLE
229: , p5_a24 JTF_NUMBER_TABLE
230: , p5_a25 JTF_NUMBER_TABLE
231: , p5_a26 JTF_NUMBER_TABLE
232: , p5_a27 JTF_VARCHAR2_TABLE_100
233: , p5_a28 JTF_VARCHAR2_TABLE_100
234: , p5_a29 JTF_VARCHAR2_TABLE_100
235: , p5_a30 JTF_VARCHAR2_TABLE_100
236: , p5_a31 JTF_NUMBER_TABLE

Line 233: , p5_a28 JTF_VARCHAR2_TABLE_100

229: , p5_a24 JTF_NUMBER_TABLE
230: , p5_a25 JTF_NUMBER_TABLE
231: , p5_a26 JTF_NUMBER_TABLE
232: , p5_a27 JTF_VARCHAR2_TABLE_100
233: , p5_a28 JTF_VARCHAR2_TABLE_100
234: , p5_a29 JTF_VARCHAR2_TABLE_100
235: , p5_a30 JTF_VARCHAR2_TABLE_100
236: , p5_a31 JTF_NUMBER_TABLE
237: , p5_a32 JTF_DATE_TABLE

Line 234: , p5_a29 JTF_VARCHAR2_TABLE_100

230: , p5_a25 JTF_NUMBER_TABLE
231: , p5_a26 JTF_NUMBER_TABLE
232: , p5_a27 JTF_VARCHAR2_TABLE_100
233: , p5_a28 JTF_VARCHAR2_TABLE_100
234: , p5_a29 JTF_VARCHAR2_TABLE_100
235: , p5_a30 JTF_VARCHAR2_TABLE_100
236: , p5_a31 JTF_NUMBER_TABLE
237: , p5_a32 JTF_DATE_TABLE
238: , p5_a33 JTF_NUMBER_TABLE

Line 235: , p5_a30 JTF_VARCHAR2_TABLE_100

231: , p5_a26 JTF_NUMBER_TABLE
232: , p5_a27 JTF_VARCHAR2_TABLE_100
233: , p5_a28 JTF_VARCHAR2_TABLE_100
234: , p5_a29 JTF_VARCHAR2_TABLE_100
235: , p5_a30 JTF_VARCHAR2_TABLE_100
236: , p5_a31 JTF_NUMBER_TABLE
237: , p5_a32 JTF_DATE_TABLE
238: , p5_a33 JTF_NUMBER_TABLE
239: , p5_a34 JTF_NUMBER_TABLE

Line 250: , p5_a45 JTF_VARCHAR2_TABLE_100

246: , p5_a41 JTF_NUMBER_TABLE
247: , p5_a42 JTF_VARCHAR2_TABLE_300
248: , p5_a43 JTF_VARCHAR2_TABLE_2000
249: , p5_a44 JTF_NUMBER_TABLE
250: , p5_a45 JTF_VARCHAR2_TABLE_100
251: , p5_a46 JTF_VARCHAR2_TABLE_100
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , p5_a46 JTF_VARCHAR2_TABLE_100

247: , p5_a42 JTF_VARCHAR2_TABLE_300
248: , p5_a43 JTF_VARCHAR2_TABLE_2000
249: , p5_a44 JTF_NUMBER_TABLE
250: , p5_a45 JTF_VARCHAR2_TABLE_100
251: , p5_a46 JTF_VARCHAR2_TABLE_100
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

250: , p5_a45 JTF_VARCHAR2_TABLE_100
251: , p5_a46 JTF_VARCHAR2_TABLE_100
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 271: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

267: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a20 out nocopy JTF_DATE_TABLE
273: , p6_a21 out nocopy JTF_DATE_TABLE
274: , p6_a22 out nocopy JTF_NUMBER_TABLE
275: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 279: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100

275: , p6_a23 out nocopy JTF_NUMBER_TABLE
276: , p6_a24 out nocopy JTF_NUMBER_TABLE
277: , p6_a25 out nocopy JTF_NUMBER_TABLE
278: , p6_a26 out nocopy JTF_NUMBER_TABLE
279: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 280: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100

276: , p6_a24 out nocopy JTF_NUMBER_TABLE
277: , p6_a25 out nocopy JTF_NUMBER_TABLE
278: , p6_a26 out nocopy JTF_NUMBER_TABLE
279: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a31 out nocopy JTF_NUMBER_TABLE
284: , p6_a32 out nocopy JTF_DATE_TABLE

Line 281: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100

277: , p6_a25 out nocopy JTF_NUMBER_TABLE
278: , p6_a26 out nocopy JTF_NUMBER_TABLE
279: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a31 out nocopy JTF_NUMBER_TABLE
284: , p6_a32 out nocopy JTF_DATE_TABLE
285: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 282: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

278: , p6_a26 out nocopy JTF_NUMBER_TABLE
279: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
281: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a31 out nocopy JTF_NUMBER_TABLE
284: , p6_a32 out nocopy JTF_DATE_TABLE
285: , p6_a33 out nocopy JTF_NUMBER_TABLE
286: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 297: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100

293: , p6_a41 out nocopy JTF_NUMBER_TABLE
294: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
295: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
296: , p6_a44 out nocopy JTF_NUMBER_TABLE
297: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
298: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
299: );
300: procedure delete_row(p_api_version NUMBER
301: , p_init_msg_list VARCHAR2

Line 298: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100

294: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_300
295: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_2000
296: , p6_a44 out nocopy JTF_NUMBER_TABLE
297: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
298: , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
299: );
300: procedure delete_row(p_api_version NUMBER
301: , p_init_msg_list VARCHAR2
302: , x_return_status out nocopy VARCHAR2

Line 307: , p5_a2 JTF_VARCHAR2_TABLE_100

303: , x_msg_count out nocopy NUMBER
304: , x_msg_data out nocopy VARCHAR2
305: , p5_a0 JTF_NUMBER_TABLE
306: , p5_a1 JTF_NUMBER_TABLE
307: , p5_a2 JTF_VARCHAR2_TABLE_100
308: , p5_a3 JTF_VARCHAR2_TABLE_500
309: , p5_a4 JTF_VARCHAR2_TABLE_500
310: , p5_a5 JTF_VARCHAR2_TABLE_500
311: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 324: , p5_a19 JTF_VARCHAR2_TABLE_100

320: , p5_a15 JTF_VARCHAR2_TABLE_500
321: , p5_a16 JTF_VARCHAR2_TABLE_500
322: , p5_a17 JTF_VARCHAR2_TABLE_500
323: , p5_a18 JTF_VARCHAR2_TABLE_200
324: , p5_a19 JTF_VARCHAR2_TABLE_100
325: , p5_a20 JTF_DATE_TABLE
326: , p5_a21 JTF_DATE_TABLE
327: , p5_a22 JTF_NUMBER_TABLE
328: , p5_a23 JTF_NUMBER_TABLE

Line 332: , p5_a27 JTF_VARCHAR2_TABLE_100

328: , p5_a23 JTF_NUMBER_TABLE
329: , p5_a24 JTF_NUMBER_TABLE
330: , p5_a25 JTF_NUMBER_TABLE
331: , p5_a26 JTF_NUMBER_TABLE
332: , p5_a27 JTF_VARCHAR2_TABLE_100
333: , p5_a28 JTF_VARCHAR2_TABLE_100
334: , p5_a29 JTF_VARCHAR2_TABLE_100
335: , p5_a30 JTF_VARCHAR2_TABLE_100
336: , p5_a31 JTF_NUMBER_TABLE

Line 333: , p5_a28 JTF_VARCHAR2_TABLE_100

329: , p5_a24 JTF_NUMBER_TABLE
330: , p5_a25 JTF_NUMBER_TABLE
331: , p5_a26 JTF_NUMBER_TABLE
332: , p5_a27 JTF_VARCHAR2_TABLE_100
333: , p5_a28 JTF_VARCHAR2_TABLE_100
334: , p5_a29 JTF_VARCHAR2_TABLE_100
335: , p5_a30 JTF_VARCHAR2_TABLE_100
336: , p5_a31 JTF_NUMBER_TABLE
337: , p5_a32 JTF_DATE_TABLE

Line 334: , p5_a29 JTF_VARCHAR2_TABLE_100

330: , p5_a25 JTF_NUMBER_TABLE
331: , p5_a26 JTF_NUMBER_TABLE
332: , p5_a27 JTF_VARCHAR2_TABLE_100
333: , p5_a28 JTF_VARCHAR2_TABLE_100
334: , p5_a29 JTF_VARCHAR2_TABLE_100
335: , p5_a30 JTF_VARCHAR2_TABLE_100
336: , p5_a31 JTF_NUMBER_TABLE
337: , p5_a32 JTF_DATE_TABLE
338: , p5_a33 JTF_NUMBER_TABLE

Line 335: , p5_a30 JTF_VARCHAR2_TABLE_100

331: , p5_a26 JTF_NUMBER_TABLE
332: , p5_a27 JTF_VARCHAR2_TABLE_100
333: , p5_a28 JTF_VARCHAR2_TABLE_100
334: , p5_a29 JTF_VARCHAR2_TABLE_100
335: , p5_a30 JTF_VARCHAR2_TABLE_100
336: , p5_a31 JTF_NUMBER_TABLE
337: , p5_a32 JTF_DATE_TABLE
338: , p5_a33 JTF_NUMBER_TABLE
339: , p5_a34 JTF_NUMBER_TABLE

Line 350: , p5_a45 JTF_VARCHAR2_TABLE_100

346: , p5_a41 JTF_NUMBER_TABLE
347: , p5_a42 JTF_VARCHAR2_TABLE_300
348: , p5_a43 JTF_VARCHAR2_TABLE_2000
349: , p5_a44 JTF_NUMBER_TABLE
350: , p5_a45 JTF_VARCHAR2_TABLE_100
351: , p5_a46 JTF_VARCHAR2_TABLE_100
352: );
353: procedure insert_row(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2

Line 351: , p5_a46 JTF_VARCHAR2_TABLE_100

347: , p5_a42 JTF_VARCHAR2_TABLE_300
348: , p5_a43 JTF_VARCHAR2_TABLE_2000
349: , p5_a44 JTF_NUMBER_TABLE
350: , p5_a45 JTF_VARCHAR2_TABLE_100
351: , p5_a46 JTF_VARCHAR2_TABLE_100
352: );
353: procedure insert_row(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2
355: , x_return_status out nocopy VARCHAR2