APPS.AHL_VWP_TASKS_PVT_W dependencies on JTF_DATE_TABLE

Line 4: , a1 JTF_DATE_TABLE

1: package ahl_vwp_tasks_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWTSKS.pls 120.6.12020000.2 2012/12/14 06:57:54 shnatu 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
8: , a1 out nocopy JTF_DATE_TABLE

Line 5: , a2 JTF_DATE_TABLE

1: package ahl_vwp_tasks_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWTSKS.pls 120.6.12020000.2 2012/12/14 06:57:54 shnatu 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
8: , a1 out nocopy JTF_DATE_TABLE
9: , a2 out nocopy JTF_DATE_TABLE

Line 8: , a1 out nocopy JTF_DATE_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:
12: procedure get_task_details(p_api_version NUMBER

Line 9: , a2 out nocopy 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:
12: procedure get_task_details(p_api_version NUMBER
13: , p_init_msg_list VARCHAR2

Line 332: , p6_a1 in out nocopy JTF_DATE_TABLE

328: , p_validation_level NUMBER
329: , p_module_type VARCHAR2
330: , p_visit_id NUMBER
331: , p6_a0 in out nocopy JTF_NUMBER_TABLE
332: , p6_a1 in out nocopy JTF_DATE_TABLE
333: , p6_a2 in out nocopy JTF_DATE_TABLE
334: , x_return_status out nocopy VARCHAR2
335: , x_msg_count out nocopy NUMBER
336: , x_msg_data out nocopy VARCHAR2

Line 333: , p6_a2 in out nocopy JTF_DATE_TABLE

329: , p_module_type VARCHAR2
330: , p_visit_id NUMBER
331: , p6_a0 in out nocopy JTF_NUMBER_TABLE
332: , p6_a1 in out nocopy JTF_DATE_TABLE
333: , p6_a2 in out nocopy JTF_DATE_TABLE
334: , x_return_status out nocopy VARCHAR2
335: , x_msg_count out nocopy NUMBER
336: , x_msg_data out nocopy VARCHAR2
337: );

Line 377: , p5_a34 in out nocopy JTF_DATE_TABLE

373: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
374: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p5_a33 in out nocopy JTF_NUMBER_TABLE
377: , p5_a34 in out nocopy JTF_DATE_TABLE
378: , p5_a35 in out nocopy JTF_NUMBER_TABLE
379: , p5_a36 in out nocopy JTF_DATE_TABLE
380: , p5_a37 in out nocopy JTF_NUMBER_TABLE
381: , p5_a38 in out nocopy JTF_NUMBER_TABLE

Line 379: , p5_a36 in out nocopy JTF_DATE_TABLE

375: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p5_a33 in out nocopy JTF_NUMBER_TABLE
377: , p5_a34 in out nocopy JTF_DATE_TABLE
378: , p5_a35 in out nocopy JTF_NUMBER_TABLE
379: , p5_a36 in out nocopy JTF_DATE_TABLE
380: , p5_a37 in out nocopy JTF_NUMBER_TABLE
381: , p5_a38 in out nocopy JTF_NUMBER_TABLE
382: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200

Line 398: , p5_a55 in out nocopy JTF_DATE_TABLE

394: , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
395: , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
396: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
397: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
398: , p5_a55 in out nocopy JTF_DATE_TABLE
399: , p5_a56 in out nocopy JTF_DATE_TABLE
400: , p5_a57 in out nocopy JTF_DATE_TABLE
401: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100

Line 399: , p5_a56 in out nocopy JTF_DATE_TABLE

395: , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
396: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
397: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
398: , p5_a55 in out nocopy JTF_DATE_TABLE
399: , p5_a56 in out nocopy JTF_DATE_TABLE
400: , p5_a57 in out nocopy JTF_DATE_TABLE
401: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p5_a60 in out nocopy JTF_NUMBER_TABLE

Line 400: , p5_a57 in out nocopy JTF_DATE_TABLE

396: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
397: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
398: , p5_a55 in out nocopy JTF_DATE_TABLE
399: , p5_a56 in out nocopy JTF_DATE_TABLE
400: , p5_a57 in out nocopy JTF_DATE_TABLE
401: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
402: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
403: , p5_a60 in out nocopy JTF_NUMBER_TABLE
404: , p5_a61 in out nocopy JTF_NUMBER_TABLE

Line 409: , p5_a66 in out nocopy JTF_DATE_TABLE

405: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p5_a63 in out nocopy JTF_NUMBER_TABLE
407: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
408: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
409: , p5_a66 in out nocopy JTF_DATE_TABLE
410: , p5_a67 in out nocopy JTF_DATE_TABLE
411: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100

Line 410: , p5_a67 in out nocopy JTF_DATE_TABLE

406: , p5_a63 in out nocopy JTF_NUMBER_TABLE
407: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
408: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
409: , p5_a66 in out nocopy JTF_DATE_TABLE
410: , p5_a67 in out nocopy JTF_DATE_TABLE
411: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a71 in out nocopy JTF_NUMBER_TABLE

Line 421: , p5_a78 in out nocopy JTF_DATE_TABLE

417: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
418: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a78 in out nocopy JTF_DATE_TABLE
422: , p5_a79 in out nocopy JTF_DATE_TABLE
423: , p5_a80 in out nocopy JTF_NUMBER_TABLE
424: , p5_a81 in out nocopy JTF_NUMBER_TABLE
425: , p5_a82 in out nocopy JTF_NUMBER_TABLE

Line 422: , p5_a79 in out nocopy JTF_DATE_TABLE

418: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a78 in out nocopy JTF_DATE_TABLE
422: , p5_a79 in out nocopy JTF_DATE_TABLE
423: , p5_a80 in out nocopy JTF_NUMBER_TABLE
424: , p5_a81 in out nocopy JTF_NUMBER_TABLE
425: , p5_a82 in out nocopy JTF_NUMBER_TABLE
426: , p5_a83 in out nocopy JTF_VARCHAR2_TABLE_100