PACKAGE: APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W

Source

1 package jtf_um_approval_requests_pvt_w AUTHID CURRENT_USER as
2   /* $Header: JTFWAPRS.pls 120.4 2009/06/15 11:38:32 kkasibha ship $ */
3 
4   procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
5     , a1 JTF_VARCHAR2_TABLE_100
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 
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 
26   procedure pending_approval_sysadmin(p_sort_order  VARCHAR2
27     , p_number_of_records  NUMBER
28     , p2_a0 out nocopy JTF_DATE_TABLE
29     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
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
39     , p_number_of_records  NUMBER
40     , p_approver_user_id  NUMBER
41     , p3_a0 out nocopy JTF_DATE_TABLE
42     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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
52     , p_number_of_records  NUMBER
53     , p_approver_user_id  NUMBER
54     , p3_a0 out nocopy JTF_DATE_TABLE
55     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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;