6: , a2 JTF_VARCHAR2_TABLE_400
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100
12: , a8 JTF_NUMBER_TABLE
13: );
14:
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100
12: , a8 JTF_NUMBER_TABLE
13: );
14:
15: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_400
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_NUMBER_TABLE
24: );
25:
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure pending_approval_sysadmin(p_sort_order VARCHAR2
27: , p_number_of_records NUMBER
30: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , p2_a8 out nocopy JTF_NUMBER_TABLE
37: );
38: procedure pending_approval_primary(p_sort_order VARCHAR2
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , p2_a8 out nocopy JTF_NUMBER_TABLE
37: );
38: procedure pending_approval_primary(p_sort_order VARCHAR2
39: , p_number_of_records NUMBER
40: , p_approver_user_id NUMBER
43: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , p3_a8 out nocopy JTF_NUMBER_TABLE
50: );
51: procedure pending_approval_owner(p_sort_order VARCHAR2
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , p3_a8 out nocopy JTF_NUMBER_TABLE
50: );
51: procedure pending_approval_owner(p_sort_order VARCHAR2
52: , p_number_of_records NUMBER
53: , p_approver_user_id NUMBER
56: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , p3_a8 out nocopy JTF_NUMBER_TABLE
63: );
64: end jtf_um_approval_requests_pvt_w;
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , p3_a8 out nocopy JTF_NUMBER_TABLE
63: );
64: end jtf_um_approval_requests_pvt_w;