DBA Data[Home] [Help]

APPS.JTF_REGION_PUB_W dependencies on JTF_REGION_PUB

Line 1: package jtf_region_pub_w AUTHID CURRENT_USER as

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

Line 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

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

Line 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

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

Line 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

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

Line 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

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

Line 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

Line 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

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

Line 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

Line 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

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

Line 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);

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);

Line 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);

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:

Line 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);

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);

Line 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);

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:

Line 251: procedure rosetta_table_copy_in_p10(t OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.number_table, a0 JTF_NUMBER_TABLE);

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

Line 252: procedure rosetta_table_copy_out_p10(t jtf_region_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);

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

Line 408: end jtf_region_pub_w;

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;