PACKAGE: APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W

Source

1 package jtf_um_approval_requests_pvt_w as
2   /* $Header: JTFWAPRS.pls 120.2 2005/09/02 18:35:47 applrt ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_400
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_1000
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     );
12   procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
13     , a1 out nocopy JTF_VARCHAR2_TABLE_100
14     , a2 out nocopy JTF_VARCHAR2_TABLE_400
15     , a3 out nocopy JTF_VARCHAR2_TABLE_100
16     , a4 out nocopy JTF_VARCHAR2_TABLE_1000
17     , a5 out nocopy JTF_VARCHAR2_TABLE_100
18     , a6 out nocopy JTF_NUMBER_TABLE
19     , a7 out nocopy JTF_VARCHAR2_TABLE_100
20     );
21 
22   procedure pending_approval_sysadmin(p_sort_order  VARCHAR2
23     , p_number_of_records  NUMBER
24     , p2_a0 out nocopy JTF_DATE_TABLE
25     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
26     , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
27     , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
28     , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
29     , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
30     , p2_a6 out nocopy JTF_NUMBER_TABLE
31     , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
32   );
33   procedure pending_approval_primary(p_sort_order  VARCHAR2
34     , p_number_of_records  NUMBER
35     , p_approver_user_id  NUMBER
36     , p3_a0 out nocopy JTF_DATE_TABLE
37     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
38     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
39     , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
40     , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
41     , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
42     , p3_a6 out nocopy JTF_NUMBER_TABLE
43     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
44   );
45   procedure pending_approval_owner(p_sort_order  VARCHAR2
46     , p_number_of_records  NUMBER
47     , p_approver_user_id  NUMBER
48     , p3_a0 out nocopy JTF_DATE_TABLE
49     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
50     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
51     , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
52     , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
53     , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
54     , p3_a6 out nocopy JTF_NUMBER_TABLE
55     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
56   );
57 end jtf_um_approval_requests_pvt_w;