eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_TASKS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_vwp_tasks_pvt_w as
2: /* $Header: AHLWTSKS.pls 120.2 2008/01/09 08:33:43 rnahata ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: );
7: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 7: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: );
7: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_DATE_TABLE
9: , a2 out nocopy JTF_DATE_TABLE
10: );
11:

Line 274: , p6_a0 in out nocopy JTF_NUMBER_TABLE

270: , p_commit VARCHAR2
271: , p_validation_level NUMBER
272: , p_module_type VARCHAR2
273: , p_visit_id NUMBER
274: , p6_a0 in out nocopy JTF_NUMBER_TABLE
275: , p6_a1 in out nocopy JTF_DATE_TABLE
276: , p6_a2 in out nocopy JTF_DATE_TABLE
277: , x_return_status out nocopy VARCHAR2
278: , x_msg_count out nocopy NUMBER

Line 286: , p5_a0 in out nocopy JTF_NUMBER_TABLE

282: , p_init_msg_list VARCHAR2
283: , p_commit VARCHAR2
284: , p_validation_level NUMBER
285: , p_module_type VARCHAR2
286: , p5_a0 in out nocopy JTF_NUMBER_TABLE
287: , p5_a1 in out nocopy JTF_NUMBER_TABLE
288: , p5_a2 in out nocopy JTF_NUMBER_TABLE
289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 287: , p5_a1 in out nocopy JTF_NUMBER_TABLE

283: , p_commit VARCHAR2
284: , p_validation_level NUMBER
285: , p_module_type VARCHAR2
286: , p5_a0 in out nocopy JTF_NUMBER_TABLE
287: , p5_a1 in out nocopy JTF_NUMBER_TABLE
288: , p5_a2 in out nocopy JTF_NUMBER_TABLE
289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 288: , p5_a2 in out nocopy JTF_NUMBER_TABLE

284: , p_validation_level NUMBER
285: , p_module_type VARCHAR2
286: , p5_a0 in out nocopy JTF_NUMBER_TABLE
287: , p5_a1 in out nocopy JTF_NUMBER_TABLE
288: , p5_a2 in out nocopy JTF_NUMBER_TABLE
289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 290: , p5_a4 in out nocopy JTF_NUMBER_TABLE

286: , p5_a0 in out nocopy JTF_NUMBER_TABLE
287: , p5_a1 in out nocopy JTF_NUMBER_TABLE
288: , p5_a2 in out nocopy JTF_NUMBER_TABLE
289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE

Line 291: , p5_a5 in out nocopy JTF_NUMBER_TABLE

287: , p5_a1 in out nocopy JTF_NUMBER_TABLE
288: , p5_a2 in out nocopy JTF_NUMBER_TABLE
289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE
295: , p5_a9 in out nocopy JTF_NUMBER_TABLE

Line 293: , p5_a7 in out nocopy JTF_NUMBER_TABLE

289: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE
295: , p5_a9 in out nocopy JTF_NUMBER_TABLE
296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE

Line 294: , p5_a8 in out nocopy JTF_NUMBER_TABLE

290: , p5_a4 in out nocopy JTF_NUMBER_TABLE
291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE
295: , p5_a9 in out nocopy JTF_NUMBER_TABLE
296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE
298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 295: , p5_a9 in out nocopy JTF_NUMBER_TABLE

291: , p5_a5 in out nocopy JTF_NUMBER_TABLE
292: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE
295: , p5_a9 in out nocopy JTF_NUMBER_TABLE
296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE
298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a13 in out nocopy JTF_NUMBER_TABLE

Line 297: , p5_a11 in out nocopy JTF_NUMBER_TABLE

293: , p5_a7 in out nocopy JTF_NUMBER_TABLE
294: , p5_a8 in out nocopy JTF_NUMBER_TABLE
295: , p5_a9 in out nocopy JTF_NUMBER_TABLE
296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE
298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a13 in out nocopy JTF_NUMBER_TABLE
300: , p5_a14 in out nocopy JTF_NUMBER_TABLE
301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300

Line 299: , p5_a13 in out nocopy JTF_NUMBER_TABLE

295: , p5_a9 in out nocopy JTF_NUMBER_TABLE
296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE
298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a13 in out nocopy JTF_NUMBER_TABLE
300: , p5_a14 in out nocopy JTF_NUMBER_TABLE
301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 300: , p5_a14 in out nocopy JTF_NUMBER_TABLE

296: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a11 in out nocopy JTF_NUMBER_TABLE
298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a13 in out nocopy JTF_NUMBER_TABLE
300: , p5_a14 in out nocopy JTF_NUMBER_TABLE
301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a18 in out nocopy JTF_NUMBER_TABLE

Line 302: , p5_a16 in out nocopy JTF_NUMBER_TABLE

298: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a13 in out nocopy JTF_NUMBER_TABLE
300: , p5_a14 in out nocopy JTF_NUMBER_TABLE
301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a18 in out nocopy JTF_NUMBER_TABLE
305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE

Line 304: , p5_a18 in out nocopy JTF_NUMBER_TABLE

300: , p5_a14 in out nocopy JTF_NUMBER_TABLE
301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a18 in out nocopy JTF_NUMBER_TABLE
305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 305: , p5_a19 in out nocopy JTF_NUMBER_TABLE

301: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a18 in out nocopy JTF_NUMBER_TABLE
305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 306: , p5_a20 in out nocopy JTF_NUMBER_TABLE

302: , p5_a16 in out nocopy JTF_NUMBER_TABLE
303: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a18 in out nocopy JTF_NUMBER_TABLE
305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE

Line 308: , p5_a22 in out nocopy JTF_NUMBER_TABLE

304: , p5_a18 in out nocopy JTF_NUMBER_TABLE
305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE
311: , p5_a25 in out nocopy JTF_NUMBER_TABLE
312: , p5_a26 in out nocopy JTF_NUMBER_TABLE

Line 309: , p5_a23 in out nocopy JTF_NUMBER_TABLE

305: , p5_a19 in out nocopy JTF_NUMBER_TABLE
306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE
311: , p5_a25 in out nocopy JTF_NUMBER_TABLE
312: , p5_a26 in out nocopy JTF_NUMBER_TABLE
313: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

Line 310: , p5_a24 in out nocopy JTF_NUMBER_TABLE

306: , p5_a20 in out nocopy JTF_NUMBER_TABLE
307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE
311: , p5_a25 in out nocopy JTF_NUMBER_TABLE
312: , p5_a26 in out nocopy JTF_NUMBER_TABLE
313: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 311: , p5_a25 in out nocopy JTF_NUMBER_TABLE

307: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE
311: , p5_a25 in out nocopy JTF_NUMBER_TABLE
312: , p5_a26 in out nocopy JTF_NUMBER_TABLE
313: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100

Line 312: , p5_a26 in out nocopy JTF_NUMBER_TABLE

308: , p5_a22 in out nocopy JTF_NUMBER_TABLE
309: , p5_a23 in out nocopy JTF_NUMBER_TABLE
310: , p5_a24 in out nocopy JTF_NUMBER_TABLE
311: , p5_a25 in out nocopy JTF_NUMBER_TABLE
312: , p5_a26 in out nocopy JTF_NUMBER_TABLE
313: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 319: , p5_a33 in out nocopy JTF_NUMBER_TABLE

315: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
317: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a33 in out nocopy JTF_NUMBER_TABLE
320: , p5_a34 in out nocopy JTF_DATE_TABLE
321: , p5_a35 in out nocopy JTF_NUMBER_TABLE
322: , p5_a36 in out nocopy JTF_DATE_TABLE
323: , p5_a37 in out nocopy JTF_NUMBER_TABLE

Line 321: , p5_a35 in out nocopy JTF_NUMBER_TABLE

317: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a33 in out nocopy JTF_NUMBER_TABLE
320: , p5_a34 in out nocopy JTF_DATE_TABLE
321: , p5_a35 in out nocopy JTF_NUMBER_TABLE
322: , p5_a36 in out nocopy JTF_DATE_TABLE
323: , p5_a37 in out nocopy JTF_NUMBER_TABLE
324: , p5_a38 in out nocopy JTF_NUMBER_TABLE
325: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 323: , p5_a37 in out nocopy JTF_NUMBER_TABLE

319: , p5_a33 in out nocopy JTF_NUMBER_TABLE
320: , p5_a34 in out nocopy JTF_DATE_TABLE
321: , p5_a35 in out nocopy JTF_NUMBER_TABLE
322: , p5_a36 in out nocopy JTF_DATE_TABLE
323: , p5_a37 in out nocopy JTF_NUMBER_TABLE
324: , p5_a38 in out nocopy JTF_NUMBER_TABLE
325: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
327: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200

Line 324: , p5_a38 in out nocopy JTF_NUMBER_TABLE

320: , p5_a34 in out nocopy JTF_DATE_TABLE
321: , p5_a35 in out nocopy JTF_NUMBER_TABLE
322: , p5_a36 in out nocopy JTF_DATE_TABLE
323: , p5_a37 in out nocopy JTF_NUMBER_TABLE
324: , p5_a38 in out nocopy JTF_NUMBER_TABLE
325: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
327: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200
328: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_200

Line 346: , p5_a60 in out nocopy JTF_NUMBER_TABLE

342: , p5_a56 in out nocopy JTF_DATE_TABLE
343: , p5_a57 in out nocopy JTF_DATE_TABLE
344: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
346: , p5_a60 in out nocopy JTF_NUMBER_TABLE
347: , p5_a61 in out nocopy JTF_NUMBER_TABLE
348: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a63 in out nocopy JTF_NUMBER_TABLE
350: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300

Line 347: , p5_a61 in out nocopy JTF_NUMBER_TABLE

343: , p5_a57 in out nocopy JTF_DATE_TABLE
344: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
345: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
346: , p5_a60 in out nocopy JTF_NUMBER_TABLE
347: , p5_a61 in out nocopy JTF_NUMBER_TABLE
348: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a63 in out nocopy JTF_NUMBER_TABLE
350: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
351: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100

Line 349: , p5_a63 in out nocopy JTF_NUMBER_TABLE

345: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
346: , p5_a60 in out nocopy JTF_NUMBER_TABLE
347: , p5_a61 in out nocopy JTF_NUMBER_TABLE
348: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
349: , p5_a63 in out nocopy JTF_NUMBER_TABLE
350: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
351: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
352: , p5_a66 in out nocopy JTF_DATE_TABLE
353: , p5_a67 in out nocopy JTF_DATE_TABLE

Line 357: , p5_a71 in out nocopy JTF_NUMBER_TABLE

353: , p5_a67 in out nocopy JTF_DATE_TABLE
354: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
355: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
356: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
357: , p5_a71 in out nocopy JTF_NUMBER_TABLE
358: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
359: , p5_a73 in out nocopy JTF_NUMBER_TABLE
360: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
361: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100

Line 359: , p5_a73 in out nocopy JTF_NUMBER_TABLE

355: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
356: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
357: , p5_a71 in out nocopy JTF_NUMBER_TABLE
358: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
359: , p5_a73 in out nocopy JTF_NUMBER_TABLE
360: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
361: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
362: , x_return_status out nocopy VARCHAR2
363: , x_msg_count out nocopy NUMBER