1: package iem_dpm_pp_queue_pvt_w AUTHID CURRENT_USER as
2: /* $Header: iemvdprs.pls 120.0 2005/09/06 11:28 liangxia noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: iemvdprs.pls 120.0 2005/09/06 11:28 liangxia noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p1(t iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_300
17: , a5 out nocopy JTF_VARCHAR2_TABLE_300
18: , a6 out nocopy JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p1(t iem_dpm_pp_queue_pvt.folder_worklist_tbl, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_300
17: , a5 out nocopy JTF_VARCHAR2_TABLE_300
18: , a6 out nocopy JTF_VARCHAR2_TABLE_100
19: , a7 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_300
17: , a5 out nocopy JTF_VARCHAR2_TABLE_300
18: , a6 out nocopy JTF_VARCHAR2_TABLE_100
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure get_folder_work_list(p_api_version_number NUMBER
23: , p_init_msg_list VARCHAR2
24: , p_commit VARCHAR2
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
28: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_300
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
31: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
24: , p_commit VARCHAR2
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
28: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_300
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
31: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
32: , p3_a7 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
28: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_300
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
31: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
32: , p3_a7 out nocopy JTF_NUMBER_TABLE
33: , x_return_status out nocopy VARCHAR2
34: , x_msg_count out nocopy NUMBER
35: , x_msg_data out nocopy VARCHAR2