eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CN_USER_ACCESS_PVT_W

Source


1 package cn_user_access_pvt_w AUTHID CURRENT_USER as
2   /* $Header: cnwurass.pls 115.5 2002/11/25 22:32:57 nkodkani ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_200
10     , a7 JTF_VARCHAR2_TABLE_200
11     , a8 JTF_VARCHAR2_TABLE_200
12     , a9 JTF_VARCHAR2_TABLE_200
13     , a10 JTF_VARCHAR2_TABLE_200
14     , a11 JTF_VARCHAR2_TABLE_200
15     , a12 JTF_VARCHAR2_TABLE_200
16     , a13 JTF_VARCHAR2_TABLE_200
17     , a14 JTF_VARCHAR2_TABLE_200
18     , a15 JTF_VARCHAR2_TABLE_200
19     , a16 JTF_VARCHAR2_TABLE_200
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
24     , a21 JTF_NUMBER_TABLE
25     );
26   procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27     , a1 out nocopy JTF_NUMBER_TABLE
28     , a2 out nocopy JTF_NUMBER_TABLE
29     , a3 out nocopy JTF_VARCHAR2_TABLE_100
30     , a4 out nocopy JTF_VARCHAR2_TABLE_100
31     , a5 out nocopy JTF_VARCHAR2_TABLE_100
32     , a6 out nocopy JTF_VARCHAR2_TABLE_200
33     , a7 out nocopy JTF_VARCHAR2_TABLE_200
34     , a8 out nocopy JTF_VARCHAR2_TABLE_200
35     , a9 out nocopy JTF_VARCHAR2_TABLE_200
36     , a10 out nocopy JTF_VARCHAR2_TABLE_200
37     , a11 out nocopy JTF_VARCHAR2_TABLE_200
38     , a12 out nocopy JTF_VARCHAR2_TABLE_200
39     , a13 out nocopy JTF_VARCHAR2_TABLE_200
40     , a14 out nocopy JTF_VARCHAR2_TABLE_200
41     , a15 out nocopy JTF_VARCHAR2_TABLE_200
42     , a16 out nocopy JTF_VARCHAR2_TABLE_200
43     , a17 out nocopy JTF_VARCHAR2_TABLE_200
44     , a18 out nocopy JTF_VARCHAR2_TABLE_200
45     , a19 out nocopy JTF_VARCHAR2_TABLE_200
46     , a20 out nocopy JTF_VARCHAR2_TABLE_200
47     , a21 out nocopy JTF_NUMBER_TABLE
48     );
49 
50   procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE
51     , a1 JTF_VARCHAR2_TABLE_300
52     , a2 JTF_VARCHAR2_TABLE_100
53     );
54   procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55     , a1 out nocopy JTF_VARCHAR2_TABLE_300
56     , a2 out nocopy JTF_VARCHAR2_TABLE_100
57     );
58 
59   procedure create_user_access(p_api_version  NUMBER
60     , p_init_msg_list  VARCHAR2
61     , p_commit  VARCHAR2
62     , p_validation_level  NUMBER
63     , p4_a0  NUMBER
64     , p4_a1  NUMBER
65     , p4_a2  NUMBER
66     , p4_a3  VARCHAR
67     , p4_a4  VARCHAR
68     , p4_a5  VARCHAR2
69     , p4_a6  VARCHAR2
70     , p4_a7  VARCHAR2
71     , p4_a8  VARCHAR2
72     , p4_a9  VARCHAR2
73     , p4_a10  VARCHAR2
74     , p4_a11  VARCHAR2
75     , p4_a12  VARCHAR2
76     , p4_a13  VARCHAR2
77     , p4_a14  VARCHAR2
78     , p4_a15  VARCHAR2
79     , p4_a16  VARCHAR2
80     , p4_a17  VARCHAR2
81     , p4_a18  VARCHAR2
82     , p4_a19  VARCHAR2
83     , p4_a20  VARCHAR2
84     , p4_a21  NUMBER
85     , x_return_status out nocopy  VARCHAR2
86     , x_msg_count out nocopy  NUMBER
87     , x_msg_data out nocopy  VARCHAR2
88     , x_user_access_id out nocopy  NUMBER
89   );
90   procedure update_user_access(p_api_version  NUMBER
91     , p_init_msg_list  VARCHAR2
92     , p_commit  VARCHAR2
93     , p_validation_level  NUMBER
94     , p4_a0  NUMBER
95     , p4_a1  NUMBER
96     , p4_a2  NUMBER
97     , p4_a3  VARCHAR
98     , p4_a4  VARCHAR
99     , p4_a5  VARCHAR2
100     , p4_a6  VARCHAR2
101     , p4_a7  VARCHAR2
102     , p4_a8  VARCHAR2
103     , p4_a9  VARCHAR2
104     , p4_a10  VARCHAR2
105     , p4_a11  VARCHAR2
106     , p4_a12  VARCHAR2
107     , p4_a13  VARCHAR2
108     , p4_a14  VARCHAR2
109     , p4_a15  VARCHAR2
110     , p4_a16  VARCHAR2
111     , p4_a17  VARCHAR2
112     , p4_a18  VARCHAR2
113     , p4_a19  VARCHAR2
114     , p4_a20  VARCHAR2
115     , p4_a21  NUMBER
116     , x_return_status out nocopy  VARCHAR2
117     , x_msg_count out nocopy  NUMBER
118     , x_msg_data out nocopy  VARCHAR2
119   );
120   procedure get_accesses(p_range_low  NUMBER
121     , p_range_high  NUMBER
122     , x_total_rows out nocopy  NUMBER
123     , p3_a0 out nocopy JTF_NUMBER_TABLE
124     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_300
125     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
126   );
127   procedure get_access_details(p_user_id  NUMBER
128     , p1_a0 out nocopy JTF_NUMBER_TABLE
129     , p1_a1 out nocopy JTF_NUMBER_TABLE
130     , p1_a2 out nocopy JTF_NUMBER_TABLE
131     , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
132     , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
133     , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
134     , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
135     , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
136     , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
137     , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200
138     , p1_a10 out nocopy JTF_VARCHAR2_TABLE_200
139     , p1_a11 out nocopy JTF_VARCHAR2_TABLE_200
140     , p1_a12 out nocopy JTF_VARCHAR2_TABLE_200
141     , p1_a13 out nocopy JTF_VARCHAR2_TABLE_200
142     , p1_a14 out nocopy JTF_VARCHAR2_TABLE_200
143     , p1_a15 out nocopy JTF_VARCHAR2_TABLE_200
144     , p1_a16 out nocopy JTF_VARCHAR2_TABLE_200
145     , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
146     , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
147     , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
148     , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
149     , p1_a21 out nocopy JTF_NUMBER_TABLE
150   );
151 end cn_user_access_pvt_w;