APPS.JTF_REGION_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 207: , a1 JTF_VARCHAR2_TABLE_100

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

Line 210: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
214: , a1 JTF_VARCHAR2_TABLE_300

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 221: , a1 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
225: , a5 JTF_VARCHAR2_TABLE_100

Line 222: , a2 JTF_VARCHAR2_TABLE_100

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
225: , a5 JTF_VARCHAR2_TABLE_100
226: , a6 JTF_VARCHAR2_TABLE_2000

Line 223: , a3 JTF_VARCHAR2_TABLE_100

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
225: , a5 JTF_VARCHAR2_TABLE_100
226: , a6 JTF_VARCHAR2_TABLE_2000
227: , a7 JTF_NUMBER_TABLE

Line 224: , a4 JTF_VARCHAR2_TABLE_100

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
225: , a5 JTF_VARCHAR2_TABLE_100
226: , a6 JTF_VARCHAR2_TABLE_2000
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_VARCHAR2_TABLE_100

Line 225: , a5 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
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

Line 228: , a8 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: );
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

Line 229: , a9 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: );
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

Line 230: , a10 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: );
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

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 233: , a1 OUT NOCOPY /* file.sql.39 change */ 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
237: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 234: , a2 OUT NOCOPY /* file.sql.39 change */ 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
237: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
238: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000

Line 235: , a3 OUT NOCOPY /* file.sql.39 change */ 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
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

Line 236: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

Line 237: , a5 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
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

Line 240: , a8 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: );
244:

Line 241: , a9 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: );
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);

Line 242: , a10 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: );
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);

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 254: procedure get_regions(p_get_region_codes JTF_VARCHAR2_TABLE_100

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
257: , p_skip_column_name number
258: , p_lang OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 259: , p_ret_region_codes OUT NOCOPY /* file.sql.39 change */ 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
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

Line 261: , p_ret_object_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 262: , p_ret_region_name OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 264: , p10_a0 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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 266: , p10_a2 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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 267: , p10_a3 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
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 268: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

264: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 269: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

265: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 272: , p10_a8 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: );
276: procedure get_region(p_region_code VARCHAR2

Line 273: , p10_a9 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: );
276: procedure get_region(p_region_code VARCHAR2
277: , p_application_id NUMBER

Line 274: , p10_a10 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: );
276: procedure get_region(p_region_code VARCHAR2
277: , p_application_id NUMBER
278: , p_responsibility_id NUMBER

Line 282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

278: , p_responsibility_id NUMBER
279: , p_object_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
280: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

279: , p_object_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
280: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

280: , p_region_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 285: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

281: , p_region_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 286: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

282: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 287: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

283: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
284: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
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

Line 290: , p6_a8 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: );
294: procedure ak_query(p_application_id NUMBER

Line 291: , p6_a9 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: );
294: procedure ak_query(p_application_id NUMBER
295: , p_region_code VARCHAR2

Line 292: , p6_a10 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: );
294: procedure ak_query(p_application_id NUMBER
295: , p_region_code VARCHAR2
296: , p_where_clause VARCHAR2

Line 303: , p9_a0 JTF_VARCHAR2_TABLE_100

299: , p_user_id NUMBER
300: , p_range_low NUMBER
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

Line 306: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
310: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300