4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure insert_row(p_api_version NUMBER
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure lock_row(p_api_version NUMBER
104: , p_init_msg_list VARCHAR2
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE
153: , p5_a8 JTF_NUMBER_TABLE
154: );
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE
153: , p5_a8 JTF_NUMBER_TABLE
154: );
155: procedure update_row(p_api_version NUMBER
156: , p_init_msg_list VARCHAR2
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );
234: procedure delete_row(p_api_version NUMBER
235: , p_init_msg_list VARCHAR2
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE
284: , p5_a8 JTF_NUMBER_TABLE
285: );
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE
284: , p5_a8 JTF_NUMBER_TABLE
285: );
286: procedure validate_row(p_api_version NUMBER
287: , p_init_msg_list VARCHAR2
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE
336: , p5_a8 JTF_NUMBER_TABLE
337: );
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE
336: , p5_a8 JTF_NUMBER_TABLE
337: );
338: end okl_rsp_pvt_w;