[Home] [Help]
22: , a2 JTF_VARCHAR2_TABLE_200
23: , a3 JTF_VARCHAR2_TABLE_200
24: , a4 JTF_VARCHAR2_TABLE_600
25: , a5 JTF_NUMBER_TABLE
26: , a6 JTF_VARCHAR2_TABLE_100
27: , a7 JTF_VARCHAR2_TABLE_100
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_VARCHAR2_TABLE_100
30: , a10 JTF_VARCHAR2_TABLE_200
23: , a3 JTF_VARCHAR2_TABLE_200
24: , a4 JTF_VARCHAR2_TABLE_600
25: , a5 JTF_NUMBER_TABLE
26: , a6 JTF_VARCHAR2_TABLE_100
27: , a7 JTF_VARCHAR2_TABLE_100
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_VARCHAR2_TABLE_100
30: , a10 JTF_VARCHAR2_TABLE_200
31: , a11 JTF_NUMBER_TABLE
25: , a5 JTF_NUMBER_TABLE
26: , a6 JTF_VARCHAR2_TABLE_100
27: , a7 JTF_VARCHAR2_TABLE_100
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_VARCHAR2_TABLE_100
30: , a10 JTF_VARCHAR2_TABLE_200
31: , a11 JTF_NUMBER_TABLE
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_DATE_TABLE
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_VARCHAR2_TABLE_100
30: , a10 JTF_VARCHAR2_TABLE_200
31: , a11 JTF_NUMBER_TABLE
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_DATE_TABLE
34: , a14 JTF_DATE_TABLE
35: , a15 JTF_NUMBER_TABLE
36: , a16 JTF_NUMBER_TABLE
36: , a16 JTF_NUMBER_TABLE
37: , a17 JTF_NUMBER_TABLE
38: , a18 JTF_NUMBER_TABLE
39: , a19 JTF_NUMBER_TABLE
40: , a20 JTF_VARCHAR2_TABLE_100
41: , a21 JTF_NUMBER_TABLE
42: , a22 JTF_NUMBER_TABLE
43: , a23 JTF_NUMBER_TABLE
44: , a24 JTF_VARCHAR2_TABLE_200
42: , a22 JTF_NUMBER_TABLE
43: , a23 JTF_NUMBER_TABLE
44: , a24 JTF_VARCHAR2_TABLE_200
45: , a25 JTF_NUMBER_TABLE
46: , a26 JTF_VARCHAR2_TABLE_100
47: , a27 JTF_VARCHAR2_TABLE_100
48: , a28 JTF_NUMBER_TABLE
49: , a29 JTF_DATE_TABLE
50: , a30 JTF_DATE_TABLE
43: , a23 JTF_NUMBER_TABLE
44: , a24 JTF_VARCHAR2_TABLE_200
45: , a25 JTF_NUMBER_TABLE
46: , a26 JTF_VARCHAR2_TABLE_100
47: , a27 JTF_VARCHAR2_TABLE_100
48: , a28 JTF_NUMBER_TABLE
49: , a29 JTF_DATE_TABLE
50: , a30 JTF_DATE_TABLE
51: , a31 JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_VARCHAR2_TABLE_200
63: , a4 out nocopy JTF_VARCHAR2_TABLE_600
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_200
62: , a3 out nocopy JTF_VARCHAR2_TABLE_200
63: , a4 out nocopy JTF_VARCHAR2_TABLE_600
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_200
70: , a11 out nocopy JTF_NUMBER_TABLE
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_200
70: , a11 out nocopy JTF_NUMBER_TABLE
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: , a13 out nocopy JTF_DATE_TABLE
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_200
70: , a11 out nocopy JTF_NUMBER_TABLE
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: , a13 out nocopy JTF_DATE_TABLE
73: , a14 out nocopy JTF_DATE_TABLE
74: , a15 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
75: , a16 out nocopy JTF_NUMBER_TABLE
76: , a17 out nocopy JTF_NUMBER_TABLE
77: , a18 out nocopy JTF_NUMBER_TABLE
78: , a19 out nocopy JTF_NUMBER_TABLE
79: , a20 out nocopy JTF_VARCHAR2_TABLE_100
80: , a21 out nocopy JTF_NUMBER_TABLE
81: , a22 out nocopy JTF_NUMBER_TABLE
82: , a23 out nocopy JTF_NUMBER_TABLE
83: , a24 out nocopy JTF_VARCHAR2_TABLE_200
81: , a22 out nocopy JTF_NUMBER_TABLE
82: , a23 out nocopy JTF_NUMBER_TABLE
83: , a24 out nocopy JTF_VARCHAR2_TABLE_200
84: , a25 out nocopy JTF_NUMBER_TABLE
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_NUMBER_TABLE
88: , a29 out nocopy JTF_DATE_TABLE
89: , a30 out nocopy JTF_DATE_TABLE
82: , a23 out nocopy JTF_NUMBER_TABLE
83: , a24 out nocopy JTF_VARCHAR2_TABLE_200
84: , a25 out nocopy JTF_NUMBER_TABLE
85: , a26 out nocopy JTF_VARCHAR2_TABLE_100
86: , a27 out nocopy JTF_VARCHAR2_TABLE_100
87: , a28 out nocopy JTF_NUMBER_TABLE
88: , a29 out nocopy JTF_DATE_TABLE
89: , a30 out nocopy JTF_DATE_TABLE
90: , a31 out nocopy JTF_NUMBER_TABLE
98:
99: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_VARCHAR2_TABLE_100
103: , a4 JTF_NUMBER_TABLE
104: , a5 JTF_VARCHAR2_TABLE_100
105: , a6 JTF_DATE_TABLE
106: , a7 JTF_DATE_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_VARCHAR2_TABLE_100
103: , a4 JTF_NUMBER_TABLE
104: , a5 JTF_VARCHAR2_TABLE_100
105: , a6 JTF_DATE_TABLE
106: , a7 JTF_DATE_TABLE
107: , a8 JTF_VARCHAR2_TABLE_200
108: , a9 JTF_NUMBER_TABLE
111: , a12 JTF_NUMBER_TABLE
112: , a13 JTF_NUMBER_TABLE
113: , a14 JTF_NUMBER_TABLE
114: , a15 JTF_NUMBER_TABLE
115: , a16 JTF_VARCHAR2_TABLE_100
116: , a17 JTF_VARCHAR2_TABLE_100
117: , a18 JTF_NUMBER_TABLE
118: , a19 JTF_DATE_TABLE
119: , a20 JTF_DATE_TABLE
112: , a13 JTF_NUMBER_TABLE
113: , a14 JTF_NUMBER_TABLE
114: , a15 JTF_NUMBER_TABLE
115: , a16 JTF_VARCHAR2_TABLE_100
116: , a17 JTF_VARCHAR2_TABLE_100
117: , a18 JTF_NUMBER_TABLE
118: , a19 JTF_DATE_TABLE
119: , a20 JTF_DATE_TABLE
120: , a21 JTF_DATE_TABLE
121: );
122: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_VARCHAR2_TABLE_100
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE
129: , a7 out nocopy JTF_DATE_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_VARCHAR2_TABLE_100
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE
129: , a7 out nocopy JTF_DATE_TABLE
130: , a8 out nocopy JTF_VARCHAR2_TABLE_200
131: , a9 out nocopy JTF_NUMBER_TABLE
134: , a12 out nocopy JTF_NUMBER_TABLE
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_NUMBER_TABLE
137: , a15 out nocopy JTF_NUMBER_TABLE
138: , a16 out nocopy JTF_VARCHAR2_TABLE_100
139: , a17 out nocopy JTF_VARCHAR2_TABLE_100
140: , a18 out nocopy JTF_NUMBER_TABLE
141: , a19 out nocopy JTF_DATE_TABLE
142: , a20 out nocopy JTF_DATE_TABLE
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_NUMBER_TABLE
137: , a15 out nocopy JTF_NUMBER_TABLE
138: , a16 out nocopy JTF_VARCHAR2_TABLE_100
139: , a17 out nocopy JTF_VARCHAR2_TABLE_100
140: , a18 out nocopy JTF_NUMBER_TABLE
141: , a19 out nocopy JTF_DATE_TABLE
142: , a20 out nocopy JTF_DATE_TABLE
143: , a21 out nocopy JTF_DATE_TABLE
142: , a20 out nocopy JTF_DATE_TABLE
143: , a21 out nocopy JTF_DATE_TABLE
144: );
145:
146: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
147: , a1 JTF_NUMBER_TABLE
148: , a2 JTF_NUMBER_TABLE
149: , a3 JTF_NUMBER_TABLE
150: , a4 JTF_VARCHAR2_TABLE_200
163: , a17 JTF_NUMBER_TABLE
164: , a18 JTF_NUMBER_TABLE
165: , a19 JTF_NUMBER_TABLE
166: , a20 JTF_VARCHAR2_TABLE_200
167: , a21 JTF_VARCHAR2_TABLE_100
168: , a22 JTF_NUMBER_TABLE
169: , a23 JTF_VARCHAR2_TABLE_100
170: , a24 JTF_NUMBER_TABLE
171: , a25 JTF_VARCHAR2_TABLE_100
165: , a19 JTF_NUMBER_TABLE
166: , a20 JTF_VARCHAR2_TABLE_200
167: , a21 JTF_VARCHAR2_TABLE_100
168: , a22 JTF_NUMBER_TABLE
169: , a23 JTF_VARCHAR2_TABLE_100
170: , a24 JTF_NUMBER_TABLE
171: , a25 JTF_VARCHAR2_TABLE_100
172: , a26 JTF_NUMBER_TABLE
173: , a27 JTF_VARCHAR2_TABLE_100
167: , a21 JTF_VARCHAR2_TABLE_100
168: , a22 JTF_NUMBER_TABLE
169: , a23 JTF_VARCHAR2_TABLE_100
170: , a24 JTF_NUMBER_TABLE
171: , a25 JTF_VARCHAR2_TABLE_100
172: , a26 JTF_NUMBER_TABLE
173: , a27 JTF_VARCHAR2_TABLE_100
174: , a28 JTF_NUMBER_TABLE
175: , a29 JTF_VARCHAR2_TABLE_100
169: , a23 JTF_VARCHAR2_TABLE_100
170: , a24 JTF_NUMBER_TABLE
171: , a25 JTF_VARCHAR2_TABLE_100
172: , a26 JTF_NUMBER_TABLE
173: , a27 JTF_VARCHAR2_TABLE_100
174: , a28 JTF_NUMBER_TABLE
175: , a29 JTF_VARCHAR2_TABLE_100
176: , a30 JTF_NUMBER_TABLE
177: , a31 JTF_VARCHAR2_TABLE_100
171: , a25 JTF_VARCHAR2_TABLE_100
172: , a26 JTF_NUMBER_TABLE
173: , a27 JTF_VARCHAR2_TABLE_100
174: , a28 JTF_NUMBER_TABLE
175: , a29 JTF_VARCHAR2_TABLE_100
176: , a30 JTF_NUMBER_TABLE
177: , a31 JTF_VARCHAR2_TABLE_100
178: , a32 JTF_NUMBER_TABLE
179: , a33 JTF_VARCHAR2_TABLE_100
173: , a27 JTF_VARCHAR2_TABLE_100
174: , a28 JTF_NUMBER_TABLE
175: , a29 JTF_VARCHAR2_TABLE_100
176: , a30 JTF_NUMBER_TABLE
177: , a31 JTF_VARCHAR2_TABLE_100
178: , a32 JTF_NUMBER_TABLE
179: , a33 JTF_VARCHAR2_TABLE_100
180: , a34 JTF_VARCHAR2_TABLE_100
181: );
175: , a29 JTF_VARCHAR2_TABLE_100
176: , a30 JTF_NUMBER_TABLE
177: , a31 JTF_VARCHAR2_TABLE_100
178: , a32 JTF_NUMBER_TABLE
179: , a33 JTF_VARCHAR2_TABLE_100
180: , a34 JTF_VARCHAR2_TABLE_100
181: );
182: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
183: , a1 out nocopy JTF_NUMBER_TABLE
176: , a30 JTF_NUMBER_TABLE
177: , a31 JTF_VARCHAR2_TABLE_100
178: , a32 JTF_NUMBER_TABLE
179: , a33 JTF_VARCHAR2_TABLE_100
180: , a34 JTF_VARCHAR2_TABLE_100
181: );
182: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_NUMBER_TABLE
178: , a32 JTF_NUMBER_TABLE
179: , a33 JTF_VARCHAR2_TABLE_100
180: , a34 JTF_VARCHAR2_TABLE_100
181: );
182: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_NUMBER_TABLE
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_VARCHAR2_TABLE_200
199: , a17 out nocopy JTF_NUMBER_TABLE
200: , a18 out nocopy JTF_NUMBER_TABLE
201: , a19 out nocopy JTF_NUMBER_TABLE
202: , a20 out nocopy JTF_VARCHAR2_TABLE_200
203: , a21 out nocopy JTF_VARCHAR2_TABLE_100
204: , a22 out nocopy JTF_NUMBER_TABLE
205: , a23 out nocopy JTF_VARCHAR2_TABLE_100
206: , a24 out nocopy JTF_NUMBER_TABLE
207: , a25 out nocopy JTF_VARCHAR2_TABLE_100
201: , a19 out nocopy JTF_NUMBER_TABLE
202: , a20 out nocopy JTF_VARCHAR2_TABLE_200
203: , a21 out nocopy JTF_VARCHAR2_TABLE_100
204: , a22 out nocopy JTF_NUMBER_TABLE
205: , a23 out nocopy JTF_VARCHAR2_TABLE_100
206: , a24 out nocopy JTF_NUMBER_TABLE
207: , a25 out nocopy JTF_VARCHAR2_TABLE_100
208: , a26 out nocopy JTF_NUMBER_TABLE
209: , a27 out nocopy JTF_VARCHAR2_TABLE_100
203: , a21 out nocopy JTF_VARCHAR2_TABLE_100
204: , a22 out nocopy JTF_NUMBER_TABLE
205: , a23 out nocopy JTF_VARCHAR2_TABLE_100
206: , a24 out nocopy JTF_NUMBER_TABLE
207: , a25 out nocopy JTF_VARCHAR2_TABLE_100
208: , a26 out nocopy JTF_NUMBER_TABLE
209: , a27 out nocopy JTF_VARCHAR2_TABLE_100
210: , a28 out nocopy JTF_NUMBER_TABLE
211: , a29 out nocopy JTF_VARCHAR2_TABLE_100
205: , a23 out nocopy JTF_VARCHAR2_TABLE_100
206: , a24 out nocopy JTF_NUMBER_TABLE
207: , a25 out nocopy JTF_VARCHAR2_TABLE_100
208: , a26 out nocopy JTF_NUMBER_TABLE
209: , a27 out nocopy JTF_VARCHAR2_TABLE_100
210: , a28 out nocopy JTF_NUMBER_TABLE
211: , a29 out nocopy JTF_VARCHAR2_TABLE_100
212: , a30 out nocopy JTF_NUMBER_TABLE
213: , a31 out nocopy JTF_VARCHAR2_TABLE_100
207: , a25 out nocopy JTF_VARCHAR2_TABLE_100
208: , a26 out nocopy JTF_NUMBER_TABLE
209: , a27 out nocopy JTF_VARCHAR2_TABLE_100
210: , a28 out nocopy JTF_NUMBER_TABLE
211: , a29 out nocopy JTF_VARCHAR2_TABLE_100
212: , a30 out nocopy JTF_NUMBER_TABLE
213: , a31 out nocopy JTF_VARCHAR2_TABLE_100
214: , a32 out nocopy JTF_NUMBER_TABLE
215: , a33 out nocopy JTF_VARCHAR2_TABLE_100
209: , a27 out nocopy JTF_VARCHAR2_TABLE_100
210: , a28 out nocopy JTF_NUMBER_TABLE
211: , a29 out nocopy JTF_VARCHAR2_TABLE_100
212: , a30 out nocopy JTF_NUMBER_TABLE
213: , a31 out nocopy JTF_VARCHAR2_TABLE_100
214: , a32 out nocopy JTF_NUMBER_TABLE
215: , a33 out nocopy JTF_VARCHAR2_TABLE_100
216: , a34 out nocopy JTF_VARCHAR2_TABLE_100
217: );
211: , a29 out nocopy JTF_VARCHAR2_TABLE_100
212: , a30 out nocopy JTF_NUMBER_TABLE
213: , a31 out nocopy JTF_VARCHAR2_TABLE_100
214: , a32 out nocopy JTF_NUMBER_TABLE
215: , a33 out nocopy JTF_VARCHAR2_TABLE_100
216: , a34 out nocopy JTF_VARCHAR2_TABLE_100
217: );
218:
219: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
212: , a30 out nocopy JTF_NUMBER_TABLE
213: , a31 out nocopy JTF_VARCHAR2_TABLE_100
214: , a32 out nocopy JTF_NUMBER_TABLE
215: , a33 out nocopy JTF_VARCHAR2_TABLE_100
216: , a34 out nocopy JTF_VARCHAR2_TABLE_100
217: );
218:
219: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
220: , a1 JTF_VARCHAR2_TABLE_200
224: , a5 JTF_VARCHAR2_TABLE_300
225: , a6 JTF_NUMBER_TABLE
226: , a7 JTF_VARCHAR2_TABLE_200
227: , a8 JTF_VARCHAR2_TABLE_2000
228: , a9 JTF_VARCHAR2_TABLE_100
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_NUMBER_TABLE
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_200
225: , a6 JTF_NUMBER_TABLE
226: , a7 JTF_VARCHAR2_TABLE_200
227: , a8 JTF_VARCHAR2_TABLE_2000
228: , a9 JTF_VARCHAR2_TABLE_100
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_NUMBER_TABLE
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_200
233: , a14 JTF_VARCHAR2_TABLE_100
229: , a10 JTF_VARCHAR2_TABLE_100
230: , a11 JTF_NUMBER_TABLE
231: , a12 JTF_NUMBER_TABLE
232: , a13 JTF_VARCHAR2_TABLE_200
233: , a14 JTF_VARCHAR2_TABLE_100
234: , a15 JTF_DATE_TABLE
235: , a16 JTF_DATE_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
233: , a14 JTF_VARCHAR2_TABLE_100
234: , a15 JTF_DATE_TABLE
235: , a16 JTF_DATE_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_VARCHAR2_TABLE_100
239: );
240: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_VARCHAR2_TABLE_200
234: , a15 JTF_DATE_TABLE
235: , a16 JTF_DATE_TABLE
236: , a17 JTF_NUMBER_TABLE
237: , a18 JTF_VARCHAR2_TABLE_100
238: , a19 JTF_VARCHAR2_TABLE_100
239: );
240: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_VARCHAR2_TABLE_200
242: , a2 out nocopy JTF_VARCHAR2_TABLE_200
245: , a5 out nocopy JTF_VARCHAR2_TABLE_300
246: , a6 out nocopy JTF_NUMBER_TABLE
247: , a7 out nocopy JTF_VARCHAR2_TABLE_200
248: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a9 out nocopy JTF_VARCHAR2_TABLE_100
250: , a10 out nocopy JTF_VARCHAR2_TABLE_100
251: , a11 out nocopy JTF_NUMBER_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_VARCHAR2_TABLE_200
246: , a6 out nocopy JTF_NUMBER_TABLE
247: , a7 out nocopy JTF_VARCHAR2_TABLE_200
248: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a9 out nocopy JTF_VARCHAR2_TABLE_100
250: , a10 out nocopy JTF_VARCHAR2_TABLE_100
251: , a11 out nocopy JTF_NUMBER_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_VARCHAR2_TABLE_200
254: , a14 out nocopy JTF_VARCHAR2_TABLE_100
250: , a10 out nocopy JTF_VARCHAR2_TABLE_100
251: , a11 out nocopy JTF_NUMBER_TABLE
252: , a12 out nocopy JTF_NUMBER_TABLE
253: , a13 out nocopy JTF_VARCHAR2_TABLE_200
254: , a14 out nocopy JTF_VARCHAR2_TABLE_100
255: , a15 out nocopy JTF_DATE_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
258: , a18 out nocopy JTF_VARCHAR2_TABLE_100
254: , a14 out nocopy JTF_VARCHAR2_TABLE_100
255: , a15 out nocopy JTF_DATE_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
258: , a18 out nocopy JTF_VARCHAR2_TABLE_100
259: , a19 out nocopy JTF_VARCHAR2_TABLE_100
260: );
261:
262: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
255: , a15 out nocopy JTF_DATE_TABLE
256: , a16 out nocopy JTF_DATE_TABLE
257: , a17 out nocopy JTF_NUMBER_TABLE
258: , a18 out nocopy JTF_VARCHAR2_TABLE_100
259: , a19 out nocopy JTF_VARCHAR2_TABLE_100
260: );
261:
262: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
263: , a1 JTF_VARCHAR2_TABLE_200
261:
262: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
263: , a1 JTF_VARCHAR2_TABLE_200
264: , a2 JTF_VARCHAR2_TABLE_200
265: , a3 JTF_VARCHAR2_TABLE_100
266: , a4 JTF_NUMBER_TABLE
267: , a5 JTF_VARCHAR2_TABLE_300
268: , a6 JTF_VARCHAR2_TABLE_300
269: , a7 JTF_NUMBER_TABLE
268: , a6 JTF_VARCHAR2_TABLE_300
269: , a7 JTF_NUMBER_TABLE
270: , a8 JTF_VARCHAR2_TABLE_200
271: , a9 JTF_VARCHAR2_TABLE_2000
272: , a10 JTF_VARCHAR2_TABLE_100
273: , a11 JTF_VARCHAR2_TABLE_100
274: , a12 JTF_NUMBER_TABLE
275: , a13 JTF_DATE_TABLE
276: , a14 JTF_DATE_TABLE
269: , a7 JTF_NUMBER_TABLE
270: , a8 JTF_VARCHAR2_TABLE_200
271: , a9 JTF_VARCHAR2_TABLE_2000
272: , a10 JTF_VARCHAR2_TABLE_100
273: , a11 JTF_VARCHAR2_TABLE_100
274: , a12 JTF_NUMBER_TABLE
275: , a13 JTF_DATE_TABLE
276: , a14 JTF_DATE_TABLE
277: , a15 JTF_VARCHAR2_TABLE_100
273: , a11 JTF_VARCHAR2_TABLE_100
274: , a12 JTF_NUMBER_TABLE
275: , a13 JTF_DATE_TABLE
276: , a14 JTF_DATE_TABLE
277: , a15 JTF_VARCHAR2_TABLE_100
278: , a16 JTF_VARCHAR2_TABLE_100
279: , a17 JTF_DATE_TABLE
280: , a18 JTF_DATE_TABLE
281: , a19 JTF_VARCHAR2_TABLE_100
274: , a12 JTF_NUMBER_TABLE
275: , a13 JTF_DATE_TABLE
276: , a14 JTF_DATE_TABLE
277: , a15 JTF_VARCHAR2_TABLE_100
278: , a16 JTF_VARCHAR2_TABLE_100
279: , a17 JTF_DATE_TABLE
280: , a18 JTF_DATE_TABLE
281: , a19 JTF_VARCHAR2_TABLE_100
282: , a20 JTF_VARCHAR2_TABLE_2000
277: , a15 JTF_VARCHAR2_TABLE_100
278: , a16 JTF_VARCHAR2_TABLE_100
279: , a17 JTF_DATE_TABLE
280: , a18 JTF_DATE_TABLE
281: , a19 JTF_VARCHAR2_TABLE_100
282: , a20 JTF_VARCHAR2_TABLE_2000
283: , a21 JTF_DATE_TABLE
284: , a22 JTF_VARCHAR2_TABLE_100
285: , a23 JTF_VARCHAR2_TABLE_500
280: , a18 JTF_DATE_TABLE
281: , a19 JTF_VARCHAR2_TABLE_100
282: , a20 JTF_VARCHAR2_TABLE_2000
283: , a21 JTF_DATE_TABLE
284: , a22 JTF_VARCHAR2_TABLE_100
285: , a23 JTF_VARCHAR2_TABLE_500
286: , a24 JTF_VARCHAR2_TABLE_100
287: , a25 JTF_VARCHAR2_TABLE_500
288: , a26 JTF_VARCHAR2_TABLE_100
282: , a20 JTF_VARCHAR2_TABLE_2000
283: , a21 JTF_DATE_TABLE
284: , a22 JTF_VARCHAR2_TABLE_100
285: , a23 JTF_VARCHAR2_TABLE_500
286: , a24 JTF_VARCHAR2_TABLE_100
287: , a25 JTF_VARCHAR2_TABLE_500
288: , a26 JTF_VARCHAR2_TABLE_100
289: , a27 JTF_NUMBER_TABLE
290: );
284: , a22 JTF_VARCHAR2_TABLE_100
285: , a23 JTF_VARCHAR2_TABLE_500
286: , a24 JTF_VARCHAR2_TABLE_100
287: , a25 JTF_VARCHAR2_TABLE_500
288: , a26 JTF_VARCHAR2_TABLE_100
289: , a27 JTF_NUMBER_TABLE
290: );
291: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_200
290: );
291: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_200
293: , a2 out nocopy JTF_VARCHAR2_TABLE_200
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_NUMBER_TABLE
296: , a5 out nocopy JTF_VARCHAR2_TABLE_300
297: , a6 out nocopy JTF_VARCHAR2_TABLE_300
298: , a7 out nocopy JTF_NUMBER_TABLE
297: , a6 out nocopy JTF_VARCHAR2_TABLE_300
298: , a7 out nocopy JTF_NUMBER_TABLE
299: , a8 out nocopy JTF_VARCHAR2_TABLE_200
300: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_DATE_TABLE
305: , a14 out nocopy JTF_DATE_TABLE
298: , a7 out nocopy JTF_NUMBER_TABLE
299: , a8 out nocopy JTF_VARCHAR2_TABLE_200
300: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_DATE_TABLE
305: , a14 out nocopy JTF_DATE_TABLE
306: , a15 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_DATE_TABLE
305: , a14 out nocopy JTF_DATE_TABLE
306: , a15 out nocopy JTF_VARCHAR2_TABLE_100
307: , a16 out nocopy JTF_VARCHAR2_TABLE_100
308: , a17 out nocopy JTF_DATE_TABLE
309: , a18 out nocopy JTF_DATE_TABLE
310: , a19 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_DATE_TABLE
305: , a14 out nocopy JTF_DATE_TABLE
306: , a15 out nocopy JTF_VARCHAR2_TABLE_100
307: , a16 out nocopy JTF_VARCHAR2_TABLE_100
308: , a17 out nocopy JTF_DATE_TABLE
309: , a18 out nocopy JTF_DATE_TABLE
310: , a19 out nocopy JTF_VARCHAR2_TABLE_100
311: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
306: , a15 out nocopy JTF_VARCHAR2_TABLE_100
307: , a16 out nocopy JTF_VARCHAR2_TABLE_100
308: , a17 out nocopy JTF_DATE_TABLE
309: , a18 out nocopy JTF_DATE_TABLE
310: , a19 out nocopy JTF_VARCHAR2_TABLE_100
311: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
312: , a21 out nocopy JTF_DATE_TABLE
313: , a22 out nocopy JTF_VARCHAR2_TABLE_100
314: , a23 out nocopy JTF_VARCHAR2_TABLE_500
309: , a18 out nocopy JTF_DATE_TABLE
310: , a19 out nocopy JTF_VARCHAR2_TABLE_100
311: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
312: , a21 out nocopy JTF_DATE_TABLE
313: , a22 out nocopy JTF_VARCHAR2_TABLE_100
314: , a23 out nocopy JTF_VARCHAR2_TABLE_500
315: , a24 out nocopy JTF_VARCHAR2_TABLE_100
316: , a25 out nocopy JTF_VARCHAR2_TABLE_500
317: , a26 out nocopy JTF_VARCHAR2_TABLE_100
311: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
312: , a21 out nocopy JTF_DATE_TABLE
313: , a22 out nocopy JTF_VARCHAR2_TABLE_100
314: , a23 out nocopy JTF_VARCHAR2_TABLE_500
315: , a24 out nocopy JTF_VARCHAR2_TABLE_100
316: , a25 out nocopy JTF_VARCHAR2_TABLE_500
317: , a26 out nocopy JTF_VARCHAR2_TABLE_100
318: , a27 out nocopy JTF_NUMBER_TABLE
319: );
313: , a22 out nocopy JTF_VARCHAR2_TABLE_100
314: , a23 out nocopy JTF_VARCHAR2_TABLE_500
315: , a24 out nocopy JTF_VARCHAR2_TABLE_100
316: , a25 out nocopy JTF_VARCHAR2_TABLE_500
317: , a26 out nocopy JTF_VARCHAR2_TABLE_100
318: , a27 out nocopy JTF_NUMBER_TABLE
319: );
320:
321: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
320:
321: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
322: , a1 JTF_VARCHAR2_TABLE_200
323: , a2 JTF_VARCHAR2_TABLE_200
324: , a3 JTF_VARCHAR2_TABLE_100
325: , a4 JTF_NUMBER_TABLE
326: , a5 JTF_VARCHAR2_TABLE_300
327: , a6 JTF_VARCHAR2_TABLE_300
328: , a7 JTF_NUMBER_TABLE
327: , a6 JTF_VARCHAR2_TABLE_300
328: , a7 JTF_NUMBER_TABLE
329: , a8 JTF_VARCHAR2_TABLE_200
330: , a9 JTF_VARCHAR2_TABLE_2000
331: , a10 JTF_VARCHAR2_TABLE_100
332: , a11 JTF_NUMBER_TABLE
333: , a12 JTF_DATE_TABLE
334: , a13 JTF_DATE_TABLE
335: , a14 JTF_VARCHAR2_TABLE_100
331: , a10 JTF_VARCHAR2_TABLE_100
332: , a11 JTF_NUMBER_TABLE
333: , a12 JTF_DATE_TABLE
334: , a13 JTF_DATE_TABLE
335: , a14 JTF_VARCHAR2_TABLE_100
336: , a15 JTF_VARCHAR2_TABLE_100
337: , a16 JTF_DATE_TABLE
338: , a17 JTF_DATE_TABLE
339: , a18 JTF_VARCHAR2_TABLE_100
332: , a11 JTF_NUMBER_TABLE
333: , a12 JTF_DATE_TABLE
334: , a13 JTF_DATE_TABLE
335: , a14 JTF_VARCHAR2_TABLE_100
336: , a15 JTF_VARCHAR2_TABLE_100
337: , a16 JTF_DATE_TABLE
338: , a17 JTF_DATE_TABLE
339: , a18 JTF_VARCHAR2_TABLE_100
340: , a19 JTF_VARCHAR2_TABLE_2000
335: , a14 JTF_VARCHAR2_TABLE_100
336: , a15 JTF_VARCHAR2_TABLE_100
337: , a16 JTF_DATE_TABLE
338: , a17 JTF_DATE_TABLE
339: , a18 JTF_VARCHAR2_TABLE_100
340: , a19 JTF_VARCHAR2_TABLE_2000
341: , a20 JTF_DATE_TABLE
342: , a21 JTF_NUMBER_TABLE
343: );
343: );
344: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
345: , a1 out nocopy JTF_VARCHAR2_TABLE_200
346: , a2 out nocopy JTF_VARCHAR2_TABLE_200
347: , a3 out nocopy JTF_VARCHAR2_TABLE_100
348: , a4 out nocopy JTF_NUMBER_TABLE
349: , a5 out nocopy JTF_VARCHAR2_TABLE_300
350: , a6 out nocopy JTF_VARCHAR2_TABLE_300
351: , a7 out nocopy JTF_NUMBER_TABLE
350: , a6 out nocopy JTF_VARCHAR2_TABLE_300
351: , a7 out nocopy JTF_NUMBER_TABLE
352: , a8 out nocopy JTF_VARCHAR2_TABLE_200
353: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
354: , a10 out nocopy JTF_VARCHAR2_TABLE_100
355: , a11 out nocopy JTF_NUMBER_TABLE
356: , a12 out nocopy JTF_DATE_TABLE
357: , a13 out nocopy JTF_DATE_TABLE
358: , a14 out nocopy JTF_VARCHAR2_TABLE_100
354: , a10 out nocopy JTF_VARCHAR2_TABLE_100
355: , a11 out nocopy JTF_NUMBER_TABLE
356: , a12 out nocopy JTF_DATE_TABLE
357: , a13 out nocopy JTF_DATE_TABLE
358: , a14 out nocopy JTF_VARCHAR2_TABLE_100
359: , a15 out nocopy JTF_VARCHAR2_TABLE_100
360: , a16 out nocopy JTF_DATE_TABLE
361: , a17 out nocopy JTF_DATE_TABLE
362: , a18 out nocopy JTF_VARCHAR2_TABLE_100
355: , a11 out nocopy JTF_NUMBER_TABLE
356: , a12 out nocopy JTF_DATE_TABLE
357: , a13 out nocopy JTF_DATE_TABLE
358: , a14 out nocopy JTF_VARCHAR2_TABLE_100
359: , a15 out nocopy JTF_VARCHAR2_TABLE_100
360: , a16 out nocopy JTF_DATE_TABLE
361: , a17 out nocopy JTF_DATE_TABLE
362: , a18 out nocopy JTF_VARCHAR2_TABLE_100
363: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
358: , a14 out nocopy JTF_VARCHAR2_TABLE_100
359: , a15 out nocopy JTF_VARCHAR2_TABLE_100
360: , a16 out nocopy JTF_DATE_TABLE
361: , a17 out nocopy JTF_DATE_TABLE
362: , a18 out nocopy JTF_VARCHAR2_TABLE_100
363: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
364: , a20 out nocopy JTF_DATE_TABLE
365: , a21 out nocopy JTF_NUMBER_TABLE
366: );
369: , a1 JTF_VARCHAR2_TABLE_200
370: , a2 JTF_VARCHAR2_TABLE_200
371: , a3 JTF_VARCHAR2_TABLE_300
372: , a4 JTF_VARCHAR2_TABLE_600
373: , a5 JTF_VARCHAR2_TABLE_100
374: , a6 JTF_DATE_TABLE
375: , a7 JTF_DATE_TABLE
376: , a8 JTF_DATE_TABLE
377: );
379: , a1 out nocopy JTF_VARCHAR2_TABLE_200
380: , a2 out nocopy JTF_VARCHAR2_TABLE_200
381: , a3 out nocopy JTF_VARCHAR2_TABLE_300
382: , a4 out nocopy JTF_VARCHAR2_TABLE_600
383: , a5 out nocopy JTF_VARCHAR2_TABLE_100
384: , a6 out nocopy JTF_DATE_TABLE
385: , a7 out nocopy JTF_DATE_TABLE
386: , a8 out nocopy JTF_DATE_TABLE
387: );
385: , a7 out nocopy JTF_DATE_TABLE
386: , a8 out nocopy JTF_DATE_TABLE
387: );
388:
389: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
390: , a1 JTF_NUMBER_TABLE
391: , a2 JTF_NUMBER_TABLE
392: , a3 JTF_VARCHAR2_TABLE_100
393: );
388:
389: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
390: , a1 JTF_NUMBER_TABLE
391: , a2 JTF_NUMBER_TABLE
392: , a3 JTF_VARCHAR2_TABLE_100
393: );
394: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
395: , a1 out nocopy JTF_NUMBER_TABLE
396: , a2 out nocopy JTF_NUMBER_TABLE
390: , a1 JTF_NUMBER_TABLE
391: , a2 JTF_NUMBER_TABLE
392: , a3 JTF_VARCHAR2_TABLE_100
393: );
394: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
395: , a1 out nocopy JTF_NUMBER_TABLE
396: , a2 out nocopy JTF_NUMBER_TABLE
397: , a3 out nocopy JTF_VARCHAR2_TABLE_100
398: );
393: );
394: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
395: , a1 out nocopy JTF_NUMBER_TABLE
396: , a2 out nocopy JTF_NUMBER_TABLE
397: , a3 out nocopy JTF_VARCHAR2_TABLE_100
398: );
399:
400: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
401: , a1 JTF_VARCHAR2_TABLE_100
397: , a3 out nocopy JTF_VARCHAR2_TABLE_100
398: );
399:
400: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
401: , a1 JTF_VARCHAR2_TABLE_100
402: );
403: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_VARCHAR2_TABLE_100
405: );
400: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
401: , a1 JTF_VARCHAR2_TABLE_100
402: );
403: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_VARCHAR2_TABLE_100
405: );
406:
407: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
408: , a1 JTF_VARCHAR2_TABLE_200
405: );
406:
407: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
408: , a1 JTF_VARCHAR2_TABLE_200
409: , a2 JTF_VARCHAR2_TABLE_100
410: , a3 JTF_VARCHAR2_TABLE_100
411: , a4 JTF_VARCHAR2_TABLE_300
412: , a5 JTF_VARCHAR2_TABLE_2000
413: , a6 JTF_DATE_TABLE
406:
407: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
408: , a1 JTF_VARCHAR2_TABLE_200
409: , a2 JTF_VARCHAR2_TABLE_100
410: , a3 JTF_VARCHAR2_TABLE_100
411: , a4 JTF_VARCHAR2_TABLE_300
412: , a5 JTF_VARCHAR2_TABLE_2000
413: , a6 JTF_DATE_TABLE
414: , a7 JTF_DATE_TABLE
413: , a6 JTF_DATE_TABLE
414: , a7 JTF_DATE_TABLE
415: , a8 JTF_DATE_TABLE
416: , a9 JTF_NUMBER_TABLE
417: , a10 JTF_VARCHAR2_TABLE_100
418: , a11 JTF_VARCHAR2_TABLE_100
419: , a12 JTF_VARCHAR2_TABLE_100
420: );
421: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
414: , a7 JTF_DATE_TABLE
415: , a8 JTF_DATE_TABLE
416: , a9 JTF_NUMBER_TABLE
417: , a10 JTF_VARCHAR2_TABLE_100
418: , a11 JTF_VARCHAR2_TABLE_100
419: , a12 JTF_VARCHAR2_TABLE_100
420: );
421: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
422: , a1 out nocopy JTF_VARCHAR2_TABLE_200
415: , a8 JTF_DATE_TABLE
416: , a9 JTF_NUMBER_TABLE
417: , a10 JTF_VARCHAR2_TABLE_100
418: , a11 JTF_VARCHAR2_TABLE_100
419: , a12 JTF_VARCHAR2_TABLE_100
420: );
421: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
422: , a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , a2 out nocopy JTF_VARCHAR2_TABLE_100
419: , a12 JTF_VARCHAR2_TABLE_100
420: );
421: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
422: , a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , a4 out nocopy JTF_VARCHAR2_TABLE_300
426: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
427: , a6 out nocopy JTF_DATE_TABLE
420: );
421: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
422: , a1 out nocopy JTF_VARCHAR2_TABLE_200
423: , a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , a3 out nocopy JTF_VARCHAR2_TABLE_100
425: , a4 out nocopy JTF_VARCHAR2_TABLE_300
426: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
427: , a6 out nocopy JTF_DATE_TABLE
428: , a7 out nocopy JTF_DATE_TABLE
427: , a6 out nocopy JTF_DATE_TABLE
428: , a7 out nocopy JTF_DATE_TABLE
429: , a8 out nocopy JTF_DATE_TABLE
430: , a9 out nocopy JTF_NUMBER_TABLE
431: , a10 out nocopy JTF_VARCHAR2_TABLE_100
432: , a11 out nocopy JTF_VARCHAR2_TABLE_100
433: , a12 out nocopy JTF_VARCHAR2_TABLE_100
434: );
435:
428: , a7 out nocopy JTF_DATE_TABLE
429: , a8 out nocopy JTF_DATE_TABLE
430: , a9 out nocopy JTF_NUMBER_TABLE
431: , a10 out nocopy JTF_VARCHAR2_TABLE_100
432: , a11 out nocopy JTF_VARCHAR2_TABLE_100
433: , a12 out nocopy JTF_VARCHAR2_TABLE_100
434: );
435:
436: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
429: , a8 out nocopy JTF_DATE_TABLE
430: , a9 out nocopy JTF_NUMBER_TABLE
431: , a10 out nocopy JTF_VARCHAR2_TABLE_100
432: , a11 out nocopy JTF_VARCHAR2_TABLE_100
433: , a12 out nocopy JTF_VARCHAR2_TABLE_100
434: );
435:
436: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
437: , a1 JTF_NUMBER_TABLE
435:
436: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
437: , a1 JTF_NUMBER_TABLE
438: , a2 JTF_NUMBER_TABLE
439: , a3 JTF_VARCHAR2_TABLE_100
440: , a4 JTF_NUMBER_TABLE
441: , a5 JTF_VARCHAR2_TABLE_100
442: , a6 JTF_VARCHAR2_TABLE_100
443: );
437: , a1 JTF_NUMBER_TABLE
438: , a2 JTF_NUMBER_TABLE
439: , a3 JTF_VARCHAR2_TABLE_100
440: , a4 JTF_NUMBER_TABLE
441: , a5 JTF_VARCHAR2_TABLE_100
442: , a6 JTF_VARCHAR2_TABLE_100
443: );
444: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
445: , a1 out nocopy JTF_NUMBER_TABLE
438: , a2 JTF_NUMBER_TABLE
439: , a3 JTF_VARCHAR2_TABLE_100
440: , a4 JTF_NUMBER_TABLE
441: , a5 JTF_VARCHAR2_TABLE_100
442: , a6 JTF_VARCHAR2_TABLE_100
443: );
444: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
445: , a1 out nocopy JTF_NUMBER_TABLE
446: , a2 out nocopy JTF_NUMBER_TABLE
443: );
444: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
445: , a1 out nocopy JTF_NUMBER_TABLE
446: , a2 out nocopy JTF_NUMBER_TABLE
447: , a3 out nocopy JTF_VARCHAR2_TABLE_100
448: , a4 out nocopy JTF_NUMBER_TABLE
449: , a5 out nocopy JTF_VARCHAR2_TABLE_100
450: , a6 out nocopy JTF_VARCHAR2_TABLE_100
451: );
445: , a1 out nocopy JTF_NUMBER_TABLE
446: , a2 out nocopy JTF_NUMBER_TABLE
447: , a3 out nocopy JTF_VARCHAR2_TABLE_100
448: , a4 out nocopy JTF_NUMBER_TABLE
449: , a5 out nocopy JTF_VARCHAR2_TABLE_100
450: , a6 out nocopy JTF_VARCHAR2_TABLE_100
451: );
452:
453: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
446: , a2 out nocopy JTF_NUMBER_TABLE
447: , a3 out nocopy JTF_VARCHAR2_TABLE_100
448: , a4 out nocopy JTF_NUMBER_TABLE
449: , a5 out nocopy JTF_VARCHAR2_TABLE_100
450: , a6 out nocopy JTF_VARCHAR2_TABLE_100
451: );
452:
453: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
454: , a1 JTF_NUMBER_TABLE
451: );
452:
453: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
454: , a1 JTF_NUMBER_TABLE
455: , a2 JTF_VARCHAR2_TABLE_100
456: , a3 JTF_VARCHAR2_TABLE_100
457: , a4 JTF_VARCHAR2_TABLE_100
458: );
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
452:
453: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
454: , a1 JTF_NUMBER_TABLE
455: , a2 JTF_VARCHAR2_TABLE_100
456: , a3 JTF_VARCHAR2_TABLE_100
457: , a4 JTF_VARCHAR2_TABLE_100
458: );
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460: , a1 out nocopy JTF_NUMBER_TABLE
453: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
454: , a1 JTF_NUMBER_TABLE
455: , a2 JTF_VARCHAR2_TABLE_100
456: , a3 JTF_VARCHAR2_TABLE_100
457: , a4 JTF_VARCHAR2_TABLE_100
458: );
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460: , a1 out nocopy JTF_NUMBER_TABLE
461: , a2 out nocopy JTF_VARCHAR2_TABLE_100
457: , a4 JTF_VARCHAR2_TABLE_100
458: );
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460: , a1 out nocopy JTF_NUMBER_TABLE
461: , a2 out nocopy JTF_VARCHAR2_TABLE_100
462: , a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , a4 out nocopy JTF_VARCHAR2_TABLE_100
464: );
465:
458: );
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460: , a1 out nocopy JTF_NUMBER_TABLE
461: , a2 out nocopy JTF_VARCHAR2_TABLE_100
462: , a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , a4 out nocopy JTF_VARCHAR2_TABLE_100
464: );
465:
466: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
459: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460: , a1 out nocopy JTF_NUMBER_TABLE
461: , a2 out nocopy JTF_VARCHAR2_TABLE_100
462: , a3 out nocopy JTF_VARCHAR2_TABLE_100
463: , a4 out nocopy JTF_VARCHAR2_TABLE_100
464: );
465:
466: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
467: , a1 JTF_NUMBER_TABLE
487:
488: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_VARCHAR2_TABLE_100
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_VARCHAR2_TABLE_100
494: , a6 JTF_NUMBER_TABLE
495: , a7 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_VARCHAR2_TABLE_100
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_VARCHAR2_TABLE_100
494: , a6 JTF_NUMBER_TABLE
495: , a7 JTF_NUMBER_TABLE
496: , a8 JTF_NUMBER_TABLE
497: , a9 JTF_NUMBER_TABLE
495: , a7 JTF_NUMBER_TABLE
496: , a8 JTF_NUMBER_TABLE
497: , a9 JTF_NUMBER_TABLE
498: , a10 JTF_NUMBER_TABLE
499: , a11 JTF_VARCHAR2_TABLE_100
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
496: , a8 JTF_NUMBER_TABLE
497: , a9 JTF_NUMBER_TABLE
498: , a10 JTF_NUMBER_TABLE
499: , a11 JTF_VARCHAR2_TABLE_100
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
497: , a9 JTF_NUMBER_TABLE
498: , a10 JTF_NUMBER_TABLE
499: , a11 JTF_VARCHAR2_TABLE_100
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
498: , a10 JTF_NUMBER_TABLE
499: , a11 JTF_VARCHAR2_TABLE_100
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
506: , a18 JTF_NUMBER_TABLE
499: , a11 JTF_VARCHAR2_TABLE_100
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
506: , a18 JTF_NUMBER_TABLE
507: , a19 JTF_NUMBER_TABLE
500: , a12 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
506: , a18 JTF_NUMBER_TABLE
507: , a19 JTF_NUMBER_TABLE
508: , a20 JTF_VARCHAR2_TABLE_100
501: , a13 JTF_VARCHAR2_TABLE_100
502: , a14 JTF_VARCHAR2_TABLE_100
503: , a15 JTF_VARCHAR2_TABLE_100
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
506: , a18 JTF_NUMBER_TABLE
507: , a19 JTF_NUMBER_TABLE
508: , a20 JTF_VARCHAR2_TABLE_100
509: );
504: , a16 JTF_VARCHAR2_TABLE_100
505: , a17 JTF_VARCHAR2_TABLE_100
506: , a18 JTF_NUMBER_TABLE
507: , a19 JTF_NUMBER_TABLE
508: , a20 JTF_VARCHAR2_TABLE_100
509: );
510: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_NUMBER_TABLE
512: , a2 out nocopy JTF_NUMBER_TABLE
509: );
510: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_NUMBER_TABLE
512: , a2 out nocopy JTF_NUMBER_TABLE
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: , a4 out nocopy JTF_NUMBER_TABLE
515: , a5 out nocopy JTF_VARCHAR2_TABLE_100
516: , a6 out nocopy JTF_NUMBER_TABLE
517: , a7 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_NUMBER_TABLE
512: , a2 out nocopy JTF_NUMBER_TABLE
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: , a4 out nocopy JTF_NUMBER_TABLE
515: , a5 out nocopy JTF_VARCHAR2_TABLE_100
516: , a6 out nocopy JTF_NUMBER_TABLE
517: , a7 out nocopy JTF_NUMBER_TABLE
518: , a8 out nocopy JTF_NUMBER_TABLE
519: , a9 out nocopy JTF_NUMBER_TABLE
517: , a7 out nocopy JTF_NUMBER_TABLE
518: , a8 out nocopy JTF_NUMBER_TABLE
519: , a9 out nocopy JTF_NUMBER_TABLE
520: , a10 out nocopy JTF_NUMBER_TABLE
521: , a11 out nocopy JTF_VARCHAR2_TABLE_100
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , a8 out nocopy JTF_NUMBER_TABLE
519: , a9 out nocopy JTF_NUMBER_TABLE
520: , a10 out nocopy JTF_NUMBER_TABLE
521: , a11 out nocopy JTF_VARCHAR2_TABLE_100
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , a9 out nocopy JTF_NUMBER_TABLE
520: , a10 out nocopy JTF_NUMBER_TABLE
521: , a11 out nocopy JTF_VARCHAR2_TABLE_100
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , a10 out nocopy JTF_NUMBER_TABLE
521: , a11 out nocopy JTF_VARCHAR2_TABLE_100
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
528: , a18 out nocopy JTF_NUMBER_TABLE
521: , a11 out nocopy JTF_VARCHAR2_TABLE_100
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
528: , a18 out nocopy JTF_NUMBER_TABLE
529: , a19 out nocopy JTF_NUMBER_TABLE
522: , a12 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
528: , a18 out nocopy JTF_NUMBER_TABLE
529: , a19 out nocopy JTF_NUMBER_TABLE
530: , a20 out nocopy JTF_VARCHAR2_TABLE_100
523: , a13 out nocopy JTF_VARCHAR2_TABLE_100
524: , a14 out nocopy JTF_VARCHAR2_TABLE_100
525: , a15 out nocopy JTF_VARCHAR2_TABLE_100
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
528: , a18 out nocopy JTF_NUMBER_TABLE
529: , a19 out nocopy JTF_NUMBER_TABLE
530: , a20 out nocopy JTF_VARCHAR2_TABLE_100
531: );
526: , a16 out nocopy JTF_VARCHAR2_TABLE_100
527: , a17 out nocopy JTF_VARCHAR2_TABLE_100
528: , a18 out nocopy JTF_NUMBER_TABLE
529: , a19 out nocopy JTF_NUMBER_TABLE
530: , a20 out nocopy JTF_VARCHAR2_TABLE_100
531: );
532:
533: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
534: , a1 JTF_VARCHAR2_TABLE_100
530: , a20 out nocopy JTF_VARCHAR2_TABLE_100
531: );
532:
533: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
534: , a1 JTF_VARCHAR2_TABLE_100
535: , a2 JTF_VARCHAR2_TABLE_100
536: , a3 JTF_DATE_TABLE
537: , a4 JTF_DATE_TABLE
538: , a5 JTF_DATE_TABLE
531: );
532:
533: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
534: , a1 JTF_VARCHAR2_TABLE_100
535: , a2 JTF_VARCHAR2_TABLE_100
536: , a3 JTF_DATE_TABLE
537: , a4 JTF_DATE_TABLE
538: , a5 JTF_DATE_TABLE
539: , a6 JTF_DATE_TABLE
538: , a5 JTF_DATE_TABLE
539: , a6 JTF_DATE_TABLE
540: , a7 JTF_NUMBER_TABLE
541: , a8 JTF_NUMBER_TABLE
542: , a9 JTF_VARCHAR2_TABLE_100
543: );
544: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
545: , a1 out nocopy JTF_VARCHAR2_TABLE_100
546: , a2 out nocopy JTF_VARCHAR2_TABLE_100
541: , a8 JTF_NUMBER_TABLE
542: , a9 JTF_VARCHAR2_TABLE_100
543: );
544: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
545: , a1 out nocopy JTF_VARCHAR2_TABLE_100
546: , a2 out nocopy JTF_VARCHAR2_TABLE_100
547: , a3 out nocopy JTF_DATE_TABLE
548: , a4 out nocopy JTF_DATE_TABLE
549: , a5 out nocopy JTF_DATE_TABLE
542: , a9 JTF_VARCHAR2_TABLE_100
543: );
544: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
545: , a1 out nocopy JTF_VARCHAR2_TABLE_100
546: , a2 out nocopy JTF_VARCHAR2_TABLE_100
547: , a3 out nocopy JTF_DATE_TABLE
548: , a4 out nocopy JTF_DATE_TABLE
549: , a5 out nocopy JTF_DATE_TABLE
550: , a6 out nocopy JTF_DATE_TABLE
549: , a5 out nocopy JTF_DATE_TABLE
550: , a6 out nocopy JTF_DATE_TABLE
551: , a7 out nocopy JTF_NUMBER_TABLE
552: , a8 out nocopy JTF_NUMBER_TABLE
553: , a9 out nocopy JTF_VARCHAR2_TABLE_100
554: );
555:
556: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
557: , a1 JTF_NUMBER_TABLE
554: );
555:
556: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
557: , a1 JTF_NUMBER_TABLE
558: , a2 JTF_VARCHAR2_TABLE_100
559: );
560: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
561: , a1 out nocopy JTF_NUMBER_TABLE
562: , a2 out nocopy JTF_VARCHAR2_TABLE_100
558: , a2 JTF_VARCHAR2_TABLE_100
559: );
560: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
561: , a1 out nocopy JTF_NUMBER_TABLE
562: , a2 out nocopy JTF_VARCHAR2_TABLE_100
563: );
564:
565: procedure rosetta_table_copy_in_p83(t out nocopy oks_entitlements_pub.output_tbl_contractline, a0 JTF_VARCHAR2_TABLE_200
566: , a1 JTF_VARCHAR2_TABLE_200
569: , a4 JTF_VARCHAR2_TABLE_2000
570: , a5 JTF_VARCHAR2_TABLE_2000
571: , a6 JTF_DATE_TABLE
572: , a7 JTF_DATE_TABLE
573: , a8 JTF_VARCHAR2_TABLE_100
574: , a9 JTF_VARCHAR2_TABLE_200
575: , a10 JTF_NUMBER_TABLE
576: , a11 JTF_NUMBER_TABLE
577: , a12 JTF_NUMBER_TABLE
576: , a11 JTF_NUMBER_TABLE
577: , a12 JTF_NUMBER_TABLE
578: , a13 JTF_NUMBER_TABLE
579: , a14 JTF_NUMBER_TABLE
580: , a15 JTF_VARCHAR2_TABLE_100
581: , a16 JTF_NUMBER_TABLE
582: , a17 JTF_VARCHAR2_TABLE_300
583: );
584: procedure rosetta_table_copy_out_p83(t oks_entitlements_pub.output_tbl_contractline, a0 out nocopy JTF_VARCHAR2_TABLE_200
588: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
589: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
590: , a6 out nocopy JTF_DATE_TABLE
591: , a7 out nocopy JTF_DATE_TABLE
592: , a8 out nocopy JTF_VARCHAR2_TABLE_100
593: , a9 out nocopy JTF_VARCHAR2_TABLE_200
594: , a10 out nocopy JTF_NUMBER_TABLE
595: , a11 out nocopy JTF_NUMBER_TABLE
596: , a12 out nocopy JTF_NUMBER_TABLE
595: , a11 out nocopy JTF_NUMBER_TABLE
596: , a12 out nocopy JTF_NUMBER_TABLE
597: , a13 out nocopy JTF_NUMBER_TABLE
598: , a14 out nocopy JTF_NUMBER_TABLE
599: , a15 out nocopy JTF_VARCHAR2_TABLE_100
600: , a16 out nocopy JTF_NUMBER_TABLE
601: , a17 out nocopy JTF_VARCHAR2_TABLE_300
602: );
603:
616: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
617: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
618: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
619: , p6_a5 out nocopy JTF_NUMBER_TABLE
620: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a8 out nocopy JTF_NUMBER_TABLE
623: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
617: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
618: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
619: , p6_a5 out nocopy JTF_NUMBER_TABLE
620: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a8 out nocopy JTF_NUMBER_TABLE
623: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
625: , p6_a11 out nocopy JTF_NUMBER_TABLE
619: , p6_a5 out nocopy JTF_NUMBER_TABLE
620: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
621: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a8 out nocopy JTF_NUMBER_TABLE
623: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
625: , p6_a11 out nocopy JTF_NUMBER_TABLE
626: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a13 out nocopy JTF_DATE_TABLE
622: , p6_a8 out nocopy JTF_NUMBER_TABLE
623: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
625: , p6_a11 out nocopy JTF_NUMBER_TABLE
626: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a13 out nocopy JTF_DATE_TABLE
628: , p6_a14 out nocopy JTF_DATE_TABLE
629: , p6_a15 out nocopy JTF_NUMBER_TABLE
630: , p6_a16 out nocopy JTF_NUMBER_TABLE
630: , p6_a16 out nocopy JTF_NUMBER_TABLE
631: , p6_a17 out nocopy JTF_NUMBER_TABLE
632: , p6_a18 out nocopy JTF_NUMBER_TABLE
633: , p6_a19 out nocopy JTF_NUMBER_TABLE
634: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a21 out nocopy JTF_NUMBER_TABLE
636: , p6_a22 out nocopy JTF_NUMBER_TABLE
637: , p6_a23 out nocopy JTF_NUMBER_TABLE
638: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
636: , p6_a22 out nocopy JTF_NUMBER_TABLE
637: , p6_a23 out nocopy JTF_NUMBER_TABLE
638: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
639: , p6_a25 out nocopy JTF_NUMBER_TABLE
640: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
641: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
642: , p6_a28 out nocopy JTF_NUMBER_TABLE
643: , p6_a29 out nocopy JTF_DATE_TABLE
644: , p6_a30 out nocopy JTF_DATE_TABLE
637: , p6_a23 out nocopy JTF_NUMBER_TABLE
638: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
639: , p6_a25 out nocopy JTF_NUMBER_TABLE
640: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
641: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
642: , p6_a28 out nocopy JTF_NUMBER_TABLE
643: , p6_a29 out nocopy JTF_DATE_TABLE
644: , p6_a30 out nocopy JTF_DATE_TABLE
645: , p6_a31 out nocopy JTF_NUMBER_TABLE
658: , x_msg_data out nocopy VARCHAR2
659: , p6_a0 out nocopy JTF_NUMBER_TABLE
660: , p6_a1 out nocopy JTF_NUMBER_TABLE
661: , p6_a2 out nocopy JTF_NUMBER_TABLE
662: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
663: , p6_a4 out nocopy JTF_NUMBER_TABLE
664: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a6 out nocopy JTF_DATE_TABLE
666: , p6_a7 out nocopy JTF_DATE_TABLE
660: , p6_a1 out nocopy JTF_NUMBER_TABLE
661: , p6_a2 out nocopy JTF_NUMBER_TABLE
662: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
663: , p6_a4 out nocopy JTF_NUMBER_TABLE
664: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a6 out nocopy JTF_DATE_TABLE
666: , p6_a7 out nocopy JTF_DATE_TABLE
667: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
668: , p6_a9 out nocopy JTF_NUMBER_TABLE
671: , p6_a12 out nocopy JTF_NUMBER_TABLE
672: , p6_a13 out nocopy JTF_NUMBER_TABLE
673: , p6_a14 out nocopy JTF_NUMBER_TABLE
674: , p6_a15 out nocopy JTF_NUMBER_TABLE
675: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
676: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a18 out nocopy JTF_NUMBER_TABLE
678: , p6_a19 out nocopy JTF_DATE_TABLE
679: , p6_a20 out nocopy JTF_DATE_TABLE
672: , p6_a13 out nocopy JTF_NUMBER_TABLE
673: , p6_a14 out nocopy JTF_NUMBER_TABLE
674: , p6_a15 out nocopy JTF_NUMBER_TABLE
675: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
676: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a18 out nocopy JTF_NUMBER_TABLE
678: , p6_a19 out nocopy JTF_DATE_TABLE
679: , p6_a20 out nocopy JTF_DATE_TABLE
680: , p6_a21 out nocopy JTF_DATE_TABLE
684: , p_contract_line_id NUMBER
685: , x_return_status out nocopy VARCHAR2
686: , x_msg_count out nocopy NUMBER
687: , x_msg_data out nocopy VARCHAR2
688: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
689: , p6_a1 out nocopy JTF_NUMBER_TABLE
690: , p6_a2 out nocopy JTF_NUMBER_TABLE
691: , p6_a3 out nocopy JTF_NUMBER_TABLE
692: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
705: , p6_a17 out nocopy JTF_NUMBER_TABLE
706: , p6_a18 out nocopy JTF_NUMBER_TABLE
707: , p6_a19 out nocopy JTF_NUMBER_TABLE
708: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
709: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
710: , p6_a22 out nocopy JTF_NUMBER_TABLE
711: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a24 out nocopy JTF_NUMBER_TABLE
713: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
707: , p6_a19 out nocopy JTF_NUMBER_TABLE
708: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
709: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
710: , p6_a22 out nocopy JTF_NUMBER_TABLE
711: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a24 out nocopy JTF_NUMBER_TABLE
713: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a26 out nocopy JTF_NUMBER_TABLE
715: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
710: , p6_a22 out nocopy JTF_NUMBER_TABLE
711: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a24 out nocopy JTF_NUMBER_TABLE
713: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a26 out nocopy JTF_NUMBER_TABLE
715: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a28 out nocopy JTF_NUMBER_TABLE
717: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
711: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a24 out nocopy JTF_NUMBER_TABLE
713: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a26 out nocopy JTF_NUMBER_TABLE
715: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a28 out nocopy JTF_NUMBER_TABLE
717: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a30 out nocopy JTF_NUMBER_TABLE
719: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
713: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a26 out nocopy JTF_NUMBER_TABLE
715: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a28 out nocopy JTF_NUMBER_TABLE
717: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a30 out nocopy JTF_NUMBER_TABLE
719: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a32 out nocopy JTF_NUMBER_TABLE
721: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a28 out nocopy JTF_NUMBER_TABLE
717: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a30 out nocopy JTF_NUMBER_TABLE
719: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a32 out nocopy JTF_NUMBER_TABLE
721: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
722: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
723: );
717: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
718: , p6_a30 out nocopy JTF_NUMBER_TABLE
719: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a32 out nocopy JTF_NUMBER_TABLE
721: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
722: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
723: );
724: procedure get_contracts(p_api_version NUMBER
725: , p_init_msg_list VARCHAR2
718: , p6_a30 out nocopy JTF_NUMBER_TABLE
719: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
720: , p6_a32 out nocopy JTF_NUMBER_TABLE
721: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
722: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
723: );
724: procedure get_contracts(p_api_version NUMBER
725: , p_init_msg_list VARCHAR2
726: , p2_a0 VARCHAR2
745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
746: , p6_a6 out nocopy JTF_NUMBER_TABLE
747: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
748: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
749: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a11 out nocopy JTF_NUMBER_TABLE
752: , p6_a12 out nocopy JTF_NUMBER_TABLE
753: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
746: , p6_a6 out nocopy JTF_NUMBER_TABLE
747: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
748: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
749: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a11 out nocopy JTF_NUMBER_TABLE
752: , p6_a12 out nocopy JTF_NUMBER_TABLE
753: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
754: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a11 out nocopy JTF_NUMBER_TABLE
752: , p6_a12 out nocopy JTF_NUMBER_TABLE
753: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
754: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a15 out nocopy JTF_DATE_TABLE
756: , p6_a16 out nocopy JTF_DATE_TABLE
757: , p6_a17 out nocopy JTF_NUMBER_TABLE
758: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a15 out nocopy JTF_DATE_TABLE
756: , p6_a16 out nocopy JTF_DATE_TABLE
757: , p6_a17 out nocopy JTF_NUMBER_TABLE
758: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
759: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
760: );
761: procedure get_contracts(p_api_version NUMBER
762: , p_init_msg_list VARCHAR2
755: , p6_a15 out nocopy JTF_DATE_TABLE
756: , p6_a16 out nocopy JTF_DATE_TABLE
757: , p6_a17 out nocopy JTF_NUMBER_TABLE
758: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
759: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
760: );
761: procedure get_contracts(p_api_version NUMBER
762: , p_init_msg_list VARCHAR2
763: , p2_a0 VARCHAR2
783: , x_msg_data out nocopy VARCHAR2
784: , p6_a0 out nocopy JTF_NUMBER_TABLE
785: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
786: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
787: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
788: , p6_a4 out nocopy JTF_NUMBER_TABLE
789: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
791: , p6_a7 out nocopy JTF_NUMBER_TABLE
790: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
791: , p6_a7 out nocopy JTF_NUMBER_TABLE
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
793: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
794: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_NUMBER_TABLE
797: , p6_a13 out nocopy JTF_DATE_TABLE
798: , p6_a14 out nocopy JTF_DATE_TABLE
791: , p6_a7 out nocopy JTF_NUMBER_TABLE
792: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
793: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
794: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_NUMBER_TABLE
797: , p6_a13 out nocopy JTF_DATE_TABLE
798: , p6_a14 out nocopy JTF_DATE_TABLE
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
795: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_NUMBER_TABLE
797: , p6_a13 out nocopy JTF_DATE_TABLE
798: , p6_a14 out nocopy JTF_DATE_TABLE
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a17 out nocopy JTF_DATE_TABLE
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
796: , p6_a12 out nocopy JTF_NUMBER_TABLE
797: , p6_a13 out nocopy JTF_DATE_TABLE
798: , p6_a14 out nocopy JTF_DATE_TABLE
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a17 out nocopy JTF_DATE_TABLE
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
799: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a17 out nocopy JTF_DATE_TABLE
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
805: , p6_a21 out nocopy JTF_DATE_TABLE
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
802: , p6_a18 out nocopy JTF_DATE_TABLE
803: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
805: , p6_a21 out nocopy JTF_DATE_TABLE
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
804: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
805: , p6_a21 out nocopy JTF_DATE_TABLE
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: );
806: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
807: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
811: , p6_a27 out nocopy JTF_NUMBER_TABLE
812: );
813: procedure get_contracts(p_api_version NUMBER
814: , p_init_msg_list VARCHAR2
832: , x_msg_data out nocopy VARCHAR2
833: , p6_a0 out nocopy JTF_NUMBER_TABLE
834: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
835: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
836: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
837: , p6_a4 out nocopy JTF_NUMBER_TABLE
838: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
839: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
840: , p6_a7 out nocopy JTF_NUMBER_TABLE
839: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
840: , p6_a7 out nocopy JTF_NUMBER_TABLE
841: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
842: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
843: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a11 out nocopy JTF_NUMBER_TABLE
845: , p6_a12 out nocopy JTF_DATE_TABLE
846: , p6_a13 out nocopy JTF_DATE_TABLE
847: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
843: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a11 out nocopy JTF_NUMBER_TABLE
845: , p6_a12 out nocopy JTF_DATE_TABLE
846: , p6_a13 out nocopy JTF_DATE_TABLE
847: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
848: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a16 out nocopy JTF_DATE_TABLE
850: , p6_a17 out nocopy JTF_DATE_TABLE
851: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a11 out nocopy JTF_NUMBER_TABLE
845: , p6_a12 out nocopy JTF_DATE_TABLE
846: , p6_a13 out nocopy JTF_DATE_TABLE
847: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
848: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a16 out nocopy JTF_DATE_TABLE
850: , p6_a17 out nocopy JTF_DATE_TABLE
851: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
847: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
848: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a16 out nocopy JTF_DATE_TABLE
850: , p6_a17 out nocopy JTF_DATE_TABLE
851: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
852: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
853: , p6_a20 out nocopy JTF_DATE_TABLE
854: , p6_a21 out nocopy JTF_NUMBER_TABLE
855: );
874: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
875: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
876: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
877: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
878: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
879: , p6_a6 out nocopy JTF_DATE_TABLE
880: , p6_a7 out nocopy JTF_DATE_TABLE
881: , p6_a8 out nocopy JTF_DATE_TABLE
882: );
884: , p_init_msg_list VARCHAR2
885: , p_contract_line_id NUMBER
886: , p_busiproc_id NUMBER
887: , p_request_date date
888: , p5_a0 JTF_VARCHAR2_TABLE_100
889: , p5_a1 JTF_NUMBER_TABLE
890: , p5_a2 JTF_NUMBER_TABLE
891: , p5_a3 JTF_VARCHAR2_TABLE_100
892: , p_verify_combination VARCHAR2
887: , p_request_date date
888: , p5_a0 JTF_VARCHAR2_TABLE_100
889: , p5_a1 JTF_NUMBER_TABLE
890: , p5_a2 JTF_NUMBER_TABLE
891: , p5_a3 JTF_VARCHAR2_TABLE_100
892: , p_verify_combination VARCHAR2
893: , x_return_status out nocopy VARCHAR2
894: , x_msg_count out nocopy NUMBER
895: , x_msg_data out nocopy VARCHAR2
892: , p_verify_combination VARCHAR2
893: , x_return_status out nocopy VARCHAR2
894: , x_msg_count out nocopy NUMBER
895: , x_msg_data out nocopy VARCHAR2
896: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p10_a1 out nocopy JTF_NUMBER_TABLE
898: , p10_a2 out nocopy JTF_NUMBER_TABLE
899: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
900: , x_combination_valid out nocopy VARCHAR2
895: , x_msg_data out nocopy VARCHAR2
896: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
897: , p10_a1 out nocopy JTF_NUMBER_TABLE
898: , p10_a2 out nocopy JTF_NUMBER_TABLE
899: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
900: , x_combination_valid out nocopy VARCHAR2
901: );
902: procedure search_contracts(p_api_version NUMBER
903: , p_init_msg_list VARCHAR2
913: , p2_a9 NUMBER
914: , p2_a10 DATE
915: , p2_a11 VARCHAR2
916: , p3_a0 JTF_NUMBER_TABLE
917: , p3_a1 JTF_VARCHAR2_TABLE_100
918: , x_return_status out nocopy VARCHAR2
919: , x_msg_count out nocopy NUMBER
920: , x_msg_data out nocopy VARCHAR2
921: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
919: , x_msg_count out nocopy NUMBER
920: , x_msg_data out nocopy VARCHAR2
921: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
922: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
923: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
924: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
925: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
926: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
927: , p7_a6 out nocopy JTF_DATE_TABLE
920: , x_msg_data out nocopy VARCHAR2
921: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
922: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
923: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
924: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
925: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
926: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
927: , p7_a6 out nocopy JTF_DATE_TABLE
928: , p7_a7 out nocopy JTF_DATE_TABLE
927: , p7_a6 out nocopy JTF_DATE_TABLE
928: , p7_a7 out nocopy JTF_DATE_TABLE
929: , p7_a8 out nocopy JTF_DATE_TABLE
930: , p7_a9 out nocopy JTF_NUMBER_TABLE
931: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
932: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
933: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
934: );
935: procedure get_react_resolve_by_time(p_api_version NUMBER
928: , p7_a7 out nocopy JTF_DATE_TABLE
929: , p7_a8 out nocopy JTF_DATE_TABLE
930: , p7_a9 out nocopy JTF_NUMBER_TABLE
931: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
932: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
933: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
934: );
935: procedure get_react_resolve_by_time(p_api_version NUMBER
936: , p_init_msg_list VARCHAR2
929: , p7_a8 out nocopy JTF_DATE_TABLE
930: , p7_a9 out nocopy JTF_NUMBER_TABLE
931: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
932: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
933: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
934: );
935: procedure get_react_resolve_by_time(p_api_version NUMBER
936: , p_init_msg_list VARCHAR2
937: , p2_a0 NUMBER
1016: , x_msg_data out nocopy VARCHAR2
1017: , p7_a0 out nocopy JTF_NUMBER_TABLE
1018: , p7_a1 out nocopy JTF_NUMBER_TABLE
1019: , p7_a2 out nocopy JTF_NUMBER_TABLE
1020: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p7_a4 out nocopy JTF_NUMBER_TABLE
1022: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1024: );
1018: , p7_a1 out nocopy JTF_NUMBER_TABLE
1019: , p7_a2 out nocopy JTF_NUMBER_TABLE
1020: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p7_a4 out nocopy JTF_NUMBER_TABLE
1022: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1024: );
1025: procedure get_preferred_engineers(p_api_version NUMBER
1026: , p_init_msg_list VARCHAR2
1019: , p7_a2 out nocopy JTF_NUMBER_TABLE
1020: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1021: , p7_a4 out nocopy JTF_NUMBER_TABLE
1022: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1023: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1024: );
1025: procedure get_preferred_engineers(p_api_version NUMBER
1026: , p_init_msg_list VARCHAR2
1027: , p_contract_line_id NUMBER
1031: , x_msg_count out nocopy NUMBER
1032: , x_msg_data out nocopy VARCHAR2
1033: , p8_a0 out nocopy JTF_NUMBER_TABLE
1034: , p8_a1 out nocopy JTF_NUMBER_TABLE
1035: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1038: );
1039: procedure oks_validate_system(p_api_version NUMBER
1032: , x_msg_data out nocopy VARCHAR2
1033: , p8_a0 out nocopy JTF_NUMBER_TABLE
1034: , p8_a1 out nocopy JTF_NUMBER_TABLE
1035: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1038: );
1039: procedure oks_validate_system(p_api_version NUMBER
1040: , p_init_msg_list VARCHAR2
1033: , p8_a0 out nocopy JTF_NUMBER_TABLE
1034: , p8_a1 out nocopy JTF_NUMBER_TABLE
1035: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1038: );
1039: procedure oks_validate_system(p_api_version NUMBER
1040: , p_init_msg_list VARCHAR2
1041: , p_system_id NUMBER
1110: , p7_a3 out nocopy JTF_NUMBER_TABLE
1111: , p8_a0 out nocopy JTF_NUMBER_TABLE
1112: , p8_a1 out nocopy JTF_NUMBER_TABLE
1113: , p8_a2 out nocopy JTF_NUMBER_TABLE
1114: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1115: , p8_a4 out nocopy JTF_NUMBER_TABLE
1116: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1117: , p8_a6 out nocopy JTF_NUMBER_TABLE
1118: , p8_a7 out nocopy JTF_NUMBER_TABLE
1112: , p8_a1 out nocopy JTF_NUMBER_TABLE
1113: , p8_a2 out nocopy JTF_NUMBER_TABLE
1114: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1115: , p8_a4 out nocopy JTF_NUMBER_TABLE
1116: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1117: , p8_a6 out nocopy JTF_NUMBER_TABLE
1118: , p8_a7 out nocopy JTF_NUMBER_TABLE
1119: , p8_a8 out nocopy JTF_NUMBER_TABLE
1120: , p8_a9 out nocopy JTF_NUMBER_TABLE
1118: , p8_a7 out nocopy JTF_NUMBER_TABLE
1119: , p8_a8 out nocopy JTF_NUMBER_TABLE
1120: , p8_a9 out nocopy JTF_NUMBER_TABLE
1121: , p8_a10 out nocopy JTF_NUMBER_TABLE
1122: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1119: , p8_a8 out nocopy JTF_NUMBER_TABLE
1120: , p8_a9 out nocopy JTF_NUMBER_TABLE
1121: , p8_a10 out nocopy JTF_NUMBER_TABLE
1122: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p8_a9 out nocopy JTF_NUMBER_TABLE
1121: , p8_a10 out nocopy JTF_NUMBER_TABLE
1122: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1121: , p8_a10 out nocopy JTF_NUMBER_TABLE
1122: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129: , p8_a18 out nocopy JTF_NUMBER_TABLE
1122: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129: , p8_a18 out nocopy JTF_NUMBER_TABLE
1130: , p8_a19 out nocopy JTF_NUMBER_TABLE
1123: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129: , p8_a18 out nocopy JTF_NUMBER_TABLE
1130: , p8_a19 out nocopy JTF_NUMBER_TABLE
1131: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
1124: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129: , p8_a18 out nocopy JTF_NUMBER_TABLE
1130: , p8_a19 out nocopy JTF_NUMBER_TABLE
1131: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
1132: );
1127: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129: , p8_a18 out nocopy JTF_NUMBER_TABLE
1130: , p8_a19 out nocopy JTF_NUMBER_TABLE
1131: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
1132: );
1133: procedure search_contract_lines(p_api_version NUMBER
1134: , p_init_msg_list VARCHAR2
1135: , p2_a0 NUMBER
1159: , p3_a8 NUMBER
1160: , p3_a9 VARCHAR2
1161: , p4_a0 JTF_NUMBER_TABLE
1162: , p4_a1 JTF_NUMBER_TABLE
1163: , p4_a2 JTF_VARCHAR2_TABLE_100
1164: , x_return_status out nocopy VARCHAR2
1165: , x_msg_count out nocopy NUMBER
1166: , x_msg_data out nocopy VARCHAR2
1167: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_200
1171: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1172: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1173: , p8_a6 out nocopy JTF_DATE_TABLE
1174: , p8_a7 out nocopy JTF_DATE_TABLE
1175: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
1176: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
1177: , p8_a10 out nocopy JTF_NUMBER_TABLE
1178: , p8_a11 out nocopy JTF_NUMBER_TABLE
1179: , p8_a12 out nocopy JTF_NUMBER_TABLE
1178: , p8_a11 out nocopy JTF_NUMBER_TABLE
1179: , p8_a12 out nocopy JTF_NUMBER_TABLE
1180: , p8_a13 out nocopy JTF_NUMBER_TABLE
1181: , p8_a14 out nocopy JTF_NUMBER_TABLE
1182: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1183: , p8_a16 out nocopy JTF_NUMBER_TABLE
1184: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
1185: );
1186: end oks_entitlements_pub_w;