1: package jtf_region_pub_w AUTHID CURRENT_USER as
2: /* $Header: jtfregws.pls 120.2 2005/10/25 05:25:23 psanyal ship $ */
3: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_result_table, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_300
1: package jtf_region_pub_w AUTHID CURRENT_USER as
2: /* $Header: jtfregws.pls 120.2 2005/10/25 05:25:23 psanyal ship $ */
3: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_result_table, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_300
100: , a97 JTF_VARCHAR2_TABLE_300
101: , a98 JTF_VARCHAR2_TABLE_300
102: , a99 JTF_VARCHAR2_TABLE_300
103: );
104: procedure rosetta_table_copy_out_p4(t jtf_region_pub.ak_result_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
105: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
106: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
107: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
108: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
202: , a98 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , a99 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
204: );
205:
206: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_item_rec_table, a0 JTF_NUMBER_TABLE
207: , a1 JTF_VARCHAR2_TABLE_100
208: );
209: procedure rosetta_table_copy_out_p5(t jtf_region_pub.ak_item_rec_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
210: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205:
206: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_item_rec_table, a0 JTF_NUMBER_TABLE
207: , a1 JTF_VARCHAR2_TABLE_100
208: );
209: procedure rosetta_table_copy_out_p5(t jtf_region_pub.ak_item_rec_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
210: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: );
212:
213: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_bind_table, a0 JTF_VARCHAR2_TABLE_100
209: procedure rosetta_table_copy_out_p5(t jtf_region_pub.ak_item_rec_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
210: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: );
212:
213: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_bind_table, a0 JTF_VARCHAR2_TABLE_100
214: , a1 JTF_VARCHAR2_TABLE_300
215: );
216: procedure rosetta_table_copy_out_p6(t jtf_region_pub.ak_bind_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
217: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
212:
213: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_bind_table, a0 JTF_VARCHAR2_TABLE_100
214: , a1 JTF_VARCHAR2_TABLE_300
215: );
216: procedure rosetta_table_copy_out_p6(t jtf_region_pub.ak_bind_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
217: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
218: );
219:
220: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
216: procedure rosetta_table_copy_out_p6(t jtf_region_pub.ak_bind_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
217: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
218: );
219:
220: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table, a0 JTF_VARCHAR2_TABLE_100
221: , a1 JTF_VARCHAR2_TABLE_100
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_VARCHAR2_TABLE_100
228: , a8 JTF_VARCHAR2_TABLE_100
229: , a9 JTF_VARCHAR2_TABLE_100
230: , a10 JTF_VARCHAR2_TABLE_100
231: );
232: procedure rosetta_table_copy_out_p7(t jtf_region_pub.ak_region_items_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
233: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
234: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
235: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
236: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
241: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
243: );
244:
245: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100);
246: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100);
247:
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
242: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
243: );
244:
245: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100);
246: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100);
247:
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
250:
244:
245: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100);
246: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100);
247:
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
250:
251: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE);
252: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);
245: procedure rosetta_table_copy_in_p8(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.short_varchar2_table, a0 JTF_VARCHAR2_TABLE_100);
246: procedure rosetta_table_copy_out_p8(t jtf_region_pub.short_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100);
247:
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
250:
251: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE);
252: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);
253:
247:
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
250:
251: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE);
252: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);
253:
254: procedure get_regions(p_get_region_codes JTF_VARCHAR2_TABLE_100
255: , p_get_application_id NUMBER
248: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.long_varchar2_table, a0 JTF_VARCHAR2_TABLE_2000);
249: procedure rosetta_table_copy_out_p9(t jtf_region_pub.long_varchar2_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000);
250:
251: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE);
252: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);
253:
254: procedure get_regions(p_get_region_codes JTF_VARCHAR2_TABLE_100
255: , p_get_application_id NUMBER
256: , p_get_responsibility_ids JTF_NUMBER_TABLE
404: , p11_a97 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
405: , p11_a98 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
406: , p11_a99 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
407: );
408: end jtf_region_pub_w;