DBA Data[Home] [Help]

APPS.JTF_REGION_PUB_W dependencies on JTF_NUMBER_TABLE

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 227: , a7 JTF_NUMBER_TABLE

223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_VARCHAR2_TABLE_100
225: , a5 JTF_VARCHAR2_TABLE_100
226: , a6 JTF_VARCHAR2_TABLE_2000
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_VARCHAR2_TABLE_100
229: , a9 JTF_VARCHAR2_TABLE_100
230: , a10 JTF_VARCHAR2_TABLE_100
231: );

Line 239: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

235: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
236: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
237: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
238: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
239: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
240: , a8 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: );

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 256: , p_get_responsibility_ids 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
257: , p_skip_column_name number
258: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 260: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

256: , p_get_responsibility_ids JTF_NUMBER_TABLE
257: , p_skip_column_name number
258: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
261: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
262: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p_ret_region_description OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
264: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 271: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

267: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
271: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
272: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
273: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
274: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: );

Line 289: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

285: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
286: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
287: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
288: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
289: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
290: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
291: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
292: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
293: );

Line 305: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

301: , p_range_high NUMBER
302: , p_max_rows IN OUT NOCOPY /* file.sql.39 change */ NUMBER
303: , p9_a0 JTF_VARCHAR2_TABLE_100
304: , p9_a1 JTF_VARCHAR2_TABLE_300
305: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
306: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
307: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
308: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
309: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300