[Home] [Help]
PACKAGE: APPS.CN_ROLE_PLANS_PUB_W
Source
1 package cn_role_plans_pub_w AUTHID CURRENT_USER as
2 /* $Header: cnwrlpls.pls 120.2 2005/09/14 03:41 vensrini ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_200
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 );
28 procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
29 , a1 out nocopy JTF_NUMBER_TABLE
30 , a2 out nocopy JTF_VARCHAR2_TABLE_100
31 , a3 out nocopy JTF_NUMBER_TABLE
32 , a4 out nocopy JTF_DATE_TABLE
33 , a5 out nocopy JTF_DATE_TABLE
34 , a6 out nocopy JTF_VARCHAR2_TABLE_100
35 , a7 out nocopy JTF_VARCHAR2_TABLE_200
36 , a8 out nocopy JTF_VARCHAR2_TABLE_200
37 , a9 out nocopy JTF_VARCHAR2_TABLE_200
38 , a10 out nocopy JTF_VARCHAR2_TABLE_200
39 , a11 out nocopy JTF_VARCHAR2_TABLE_200
40 , a12 out nocopy JTF_VARCHAR2_TABLE_200
41 , a13 out nocopy JTF_VARCHAR2_TABLE_200
42 , a14 out nocopy JTF_VARCHAR2_TABLE_200
43 , a15 out nocopy JTF_VARCHAR2_TABLE_200
44 , a16 out nocopy JTF_VARCHAR2_TABLE_200
45 , a17 out nocopy JTF_VARCHAR2_TABLE_200
46 , a18 out nocopy JTF_VARCHAR2_TABLE_200
47 , a19 out nocopy JTF_VARCHAR2_TABLE_200
48 , a20 out nocopy JTF_VARCHAR2_TABLE_200
49 , a21 out nocopy JTF_VARCHAR2_TABLE_200
50 , a22 out nocopy JTF_NUMBER_TABLE
51 , a23 out nocopy JTF_NUMBER_TABLE
52 );
53
54 procedure create_role_plan(p_api_version NUMBER
55 , p_init_msg_list VARCHAR2
56 , p_commit VARCHAR2
57 , p_validation_level NUMBER
58 , x_return_status out nocopy VARCHAR2
59 , x_loading_status out nocopy VARCHAR2
60 , x_msg_count out nocopy NUMBER
61 , x_msg_data out nocopy VARCHAR2
62 , p8_a0 VARCHAR2
63 , p8_a1 NUMBER
64 , p8_a2 VARCHAR2
65 , p8_a3 NUMBER
66 , p8_a4 DATE
67 , p8_a5 DATE
68 , p8_a6 VARCHAR2
69 , p8_a7 VARCHAR2
70 , p8_a8 VARCHAR2
71 , p8_a9 VARCHAR2
72 , p8_a10 VARCHAR2
73 , p8_a11 VARCHAR2
74 , p8_a12 VARCHAR2
75 , p8_a13 VARCHAR2
76 , p8_a14 VARCHAR2
77 , p8_a15 VARCHAR2
78 , p8_a16 VARCHAR2
79 , p8_a17 VARCHAR2
80 , p8_a18 VARCHAR2
81 , p8_a19 VARCHAR2
82 , p8_a20 VARCHAR2
83 , p8_a21 VARCHAR2
84 , p8_a22 NUMBER
85 , p8_a23 NUMBER
86 , x_role_plan_id out nocopy NUMBER
87 , x_obj_ver_num out nocopy NUMBER
88 );
89 procedure update_role_plan(p_api_version NUMBER
90 , p_init_msg_list VARCHAR2
91 , p_commit VARCHAR2
92 , p_validation_level NUMBER
93 , x_return_status out nocopy VARCHAR2
94 , x_loading_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , p8_a0 VARCHAR2
98 , p8_a1 NUMBER
99 , p8_a2 VARCHAR2
100 , p8_a3 NUMBER
101 , p8_a4 DATE
102 , p8_a5 DATE
103 , p8_a6 VARCHAR2
104 , p8_a7 VARCHAR2
105 , p8_a8 VARCHAR2
106 , p8_a9 VARCHAR2
107 , p8_a10 VARCHAR2
108 , p8_a11 VARCHAR2
109 , p8_a12 VARCHAR2
110 , p8_a13 VARCHAR2
111 , p8_a14 VARCHAR2
112 , p8_a15 VARCHAR2
113 , p8_a16 VARCHAR2
114 , p8_a17 VARCHAR2
115 , p8_a18 VARCHAR2
116 , p8_a19 VARCHAR2
117 , p8_a20 VARCHAR2
118 , p8_a21 VARCHAR2
119 , p8_a22 NUMBER
120 , p8_a23 NUMBER
121 , p_ovn in out nocopy NUMBER
122 , p10_a0 VARCHAR2
123 , p10_a1 NUMBER
124 , p10_a2 VARCHAR2
125 , p10_a3 NUMBER
126 , p10_a4 DATE
127 , p10_a5 DATE
128 , p10_a6 VARCHAR2
129 , p10_a7 VARCHAR2
130 , p10_a8 VARCHAR2
131 , p10_a9 VARCHAR2
132 , p10_a10 VARCHAR2
133 , p10_a11 VARCHAR2
134 , p10_a12 VARCHAR2
135 , p10_a13 VARCHAR2
136 , p10_a14 VARCHAR2
137 , p10_a15 VARCHAR2
138 , p10_a16 VARCHAR2
139 , p10_a17 VARCHAR2
140 , p10_a18 VARCHAR2
141 , p10_a19 VARCHAR2
142 , p10_a20 VARCHAR2
143 , p10_a21 VARCHAR2
144 , p10_a22 NUMBER
145 , p10_a23 NUMBER
146 , p_role_plan_id NUMBER
147 );
148 procedure delete_role_plan(p_api_version NUMBER
149 , p_init_msg_list VARCHAR2
150 , p_commit VARCHAR2
151 , p_validation_level NUMBER
152 , x_return_status out nocopy VARCHAR2
153 , x_loading_status out nocopy VARCHAR2
154 , x_msg_count out nocopy NUMBER
155 , x_msg_data out nocopy VARCHAR2
156 , p8_a0 VARCHAR2
157 , p8_a1 NUMBER
158 , p8_a2 VARCHAR2
159 , p8_a3 NUMBER
160 , p8_a4 DATE
161 , p8_a5 DATE
162 , p8_a6 VARCHAR2
163 , p8_a7 VARCHAR2
164 , p8_a8 VARCHAR2
165 , p8_a9 VARCHAR2
166 , p8_a10 VARCHAR2
167 , p8_a11 VARCHAR2
168 , p8_a12 VARCHAR2
169 , p8_a13 VARCHAR2
170 , p8_a14 VARCHAR2
171 , p8_a15 VARCHAR2
172 , p8_a16 VARCHAR2
173 , p8_a17 VARCHAR2
174 , p8_a18 VARCHAR2
175 , p8_a19 VARCHAR2
176 , p8_a20 VARCHAR2
177 , p8_a21 VARCHAR2
178 , p8_a22 NUMBER
179 , p8_a23 NUMBER
180 );
181 end cn_role_plans_pub_w;