[Home] [Help]
PACKAGE: APPS.AMS_SETUP_ATTR_PVT_W
Source
1 package ams_setup_attr_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswatts.pls 115.14 2002/12/30 05:31:16 vmodur ship $ */
3 procedure create_setup_attr(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status OUT NOCOPY VARCHAR2
8 , x_msg_count OUT NOCOPY NUMBER
9 , x_msg_data OUT NOCOPY VARCHAR2
10 , x_setup_attr_id OUT NOCOPY NUMBER
11 , p7_a0 NUMBER := 0-1962.0724
12 , p7_a1 NUMBER := 0-1962.0724
13 , p7_a2 DATE := fnd_api.g_miss_date
14 , p7_a3 NUMBER := 0-1962.0724
15 , p7_a4 DATE := fnd_api.g_miss_date
16 , p7_a5 NUMBER := 0-1962.0724
17 , p7_a6 NUMBER := 0-1962.0724
18 , p7_a7 NUMBER := 0-1962.0724
19 , p7_a8 NUMBER := 0-1962.0724
20 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26 , p7_a15 NUMBER := 0-1962.0724
27 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
29 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
30 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
31 , p7_a20 NUMBER := 0-1962.0724
32 );
33 procedure update_setup_attr(p_api_version NUMBER
34 , p_init_msg_list VARCHAR2
35 , p_commit VARCHAR2
36 , p_validation_level NUMBER
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , p7_a0 NUMBER := 0-1962.0724
41 , p7_a1 NUMBER := 0-1962.0724
42 , p7_a2 DATE := fnd_api.g_miss_date
43 , p7_a3 NUMBER := 0-1962.0724
44 , p7_a4 DATE := fnd_api.g_miss_date
45 , p7_a5 NUMBER := 0-1962.0724
46 , p7_a6 NUMBER := 0-1962.0724
47 , p7_a7 NUMBER := 0-1962.0724
48 , p7_a8 NUMBER := 0-1962.0724
49 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a15 NUMBER := 0-1962.0724
56 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a20 NUMBER := 0-1962.0724
61 );
62 procedure validate_setup_attr(p_api_version NUMBER
63 , p_init_msg_list VARCHAR2
64 , p_validation_level NUMBER
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , p6_a0 NUMBER := 0-1962.0724
69 , p6_a1 NUMBER := 0-1962.0724
70 , p6_a2 DATE := fnd_api.g_miss_date
71 , p6_a3 NUMBER := 0-1962.0724
72 , p6_a4 DATE := fnd_api.g_miss_date
73 , p6_a5 NUMBER := 0-1962.0724
74 , p6_a6 NUMBER := 0-1962.0724
75 , p6_a7 NUMBER := 0-1962.0724
76 , p6_a8 NUMBER := 0-1962.0724
77 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
78 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
79 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
80 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
81 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
82 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
83 , p6_a15 NUMBER := 0-1962.0724
84 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
85 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
86 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
87 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
88 , p6_a20 NUMBER := 0-1962.0724
89 );
90 procedure check_items(p_validation_mode VARCHAR2
91 , x_return_status OUT NOCOPY VARCHAR2
92 , p2_a0 NUMBER := 0-1962.0724
93 , p2_a1 NUMBER := 0-1962.0724
94 , p2_a2 DATE := fnd_api.g_miss_date
95 , p2_a3 NUMBER := 0-1962.0724
96 , p2_a4 DATE := fnd_api.g_miss_date
97 , p2_a5 NUMBER := 0-1962.0724
98 , p2_a6 NUMBER := 0-1962.0724
99 , p2_a7 NUMBER := 0-1962.0724
100 , p2_a8 NUMBER := 0-1962.0724
101 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
102 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
103 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
104 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
105 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
106 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
107 , p2_a15 NUMBER := 0-1962.0724
108 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
109 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
110 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
111 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
112 , p2_a20 NUMBER := 0-1962.0724
113 );
114 procedure check_setup_attr_req_items(p_validation_mode VARCHAR2
115 , x_return_status OUT NOCOPY VARCHAR2
116 , p1_a0 NUMBER := 0-1962.0724
117 , p1_a1 NUMBER := 0-1962.0724
118 , p1_a2 DATE := fnd_api.g_miss_date
119 , p1_a3 NUMBER := 0-1962.0724
120 , p1_a4 DATE := fnd_api.g_miss_date
121 , p1_a5 NUMBER := 0-1962.0724
122 , p1_a6 NUMBER := 0-1962.0724
123 , p1_a7 NUMBER := 0-1962.0724
124 , p1_a8 NUMBER := 0-1962.0724
125 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
126 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
127 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
128 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
129 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
130 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
131 , p1_a15 NUMBER := 0-1962.0724
132 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
133 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
134 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
135 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
136 , p1_a20 NUMBER := 0-1962.0724
137 );
138 procedure check_setup_attr_uk_items(p_validation_mode VARCHAR2
139 , x_return_status OUT NOCOPY VARCHAR2
140 , p1_a0 NUMBER := 0-1962.0724
141 , p1_a1 NUMBER := 0-1962.0724
142 , p1_a2 DATE := fnd_api.g_miss_date
143 , p1_a3 NUMBER := 0-1962.0724
144 , p1_a4 DATE := fnd_api.g_miss_date
145 , p1_a5 NUMBER := 0-1962.0724
146 , p1_a6 NUMBER := 0-1962.0724
147 , p1_a7 NUMBER := 0-1962.0724
148 , p1_a8 NUMBER := 0-1962.0724
149 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
150 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
151 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
152 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
153 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
154 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
155 , p1_a15 NUMBER := 0-1962.0724
156 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
157 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
158 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
159 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
160 , p1_a20 NUMBER := 0-1962.0724
161 );
162 procedure check_setup_attr_fk_items(x_return_status OUT NOCOPY VARCHAR2
163 , p0_a0 NUMBER := 0-1962.0724
164 , p0_a1 NUMBER := 0-1962.0724
165 , p0_a2 DATE := fnd_api.g_miss_date
166 , p0_a3 NUMBER := 0-1962.0724
167 , p0_a4 DATE := fnd_api.g_miss_date
168 , p0_a5 NUMBER := 0-1962.0724
169 , p0_a6 NUMBER := 0-1962.0724
170 , p0_a7 NUMBER := 0-1962.0724
171 , p0_a8 NUMBER := 0-1962.0724
172 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
173 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
174 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
175 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
176 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
177 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
178 , p0_a15 NUMBER := 0-1962.0724
179 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
180 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
181 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
182 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
183 , p0_a20 NUMBER := 0-1962.0724
184 );
185 procedure check_setup_attr_flag_items(x_return_status OUT NOCOPY VARCHAR2
186 , p0_a0 NUMBER := 0-1962.0724
187 , p0_a1 NUMBER := 0-1962.0724
188 , p0_a2 DATE := fnd_api.g_miss_date
189 , p0_a3 NUMBER := 0-1962.0724
190 , p0_a4 DATE := fnd_api.g_miss_date
191 , p0_a5 NUMBER := 0-1962.0724
192 , p0_a6 NUMBER := 0-1962.0724
193 , p0_a7 NUMBER := 0-1962.0724
194 , p0_a8 NUMBER := 0-1962.0724
195 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
196 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
197 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
198 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
199 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
200 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
201 , p0_a15 NUMBER := 0-1962.0724
202 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
203 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
204 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
205 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
206 , p0_a20 NUMBER := 0-1962.0724
207 );
208 procedure complete_setup_attr_rec(p1_a0 OUT NOCOPY NUMBER
209 , p1_a1 OUT NOCOPY NUMBER
210 , p1_a2 OUT NOCOPY DATE
211 , p1_a3 OUT NOCOPY NUMBER
212 , p1_a4 OUT NOCOPY DATE
213 , p1_a5 OUT NOCOPY NUMBER
214 , p1_a6 OUT NOCOPY NUMBER
215 , p1_a7 OUT NOCOPY NUMBER
216 , p1_a8 OUT NOCOPY NUMBER
217 , p1_a9 OUT NOCOPY VARCHAR2
218 , p1_a10 OUT NOCOPY VARCHAR2
219 , p1_a11 OUT NOCOPY VARCHAR2
220 , p1_a12 OUT NOCOPY VARCHAR2
221 , p1_a13 OUT NOCOPY VARCHAR2
222 , p1_a14 OUT NOCOPY VARCHAR2
223 , p1_a15 OUT NOCOPY NUMBER
224 , p1_a16 OUT NOCOPY VARCHAR2
225 , p1_a17 OUT NOCOPY VARCHAR2
226 , p1_a18 OUT NOCOPY VARCHAR2
227 , p1_a19 OUT NOCOPY VARCHAR2
228 , p1_a20 OUT NOCOPY NUMBER
229 , p0_a0 NUMBER := 0-1962.0724
230 , p0_a1 NUMBER := 0-1962.0724
231 , p0_a2 DATE := fnd_api.g_miss_date
232 , p0_a3 NUMBER := 0-1962.0724
233 , p0_a4 DATE := fnd_api.g_miss_date
234 , p0_a5 NUMBER := 0-1962.0724
235 , p0_a6 NUMBER := 0-1962.0724
236 , p0_a7 NUMBER := 0-1962.0724
237 , p0_a8 NUMBER := 0-1962.0724
238 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
239 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
240 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
241 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
242 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
243 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
244 , p0_a15 NUMBER := 0-1962.0724
245 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
246 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
247 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
248 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
249 , p0_a20 NUMBER := 0-1962.0724
250 );
251 procedure init_rec(p0_a0 OUT NOCOPY NUMBER
252 , p0_a1 OUT NOCOPY NUMBER
253 , p0_a2 OUT NOCOPY DATE
254 , p0_a3 OUT NOCOPY NUMBER
255 , p0_a4 OUT NOCOPY DATE
256 , p0_a5 OUT NOCOPY NUMBER
257 , p0_a6 OUT NOCOPY NUMBER
258 , p0_a7 OUT NOCOPY NUMBER
259 , p0_a8 OUT NOCOPY NUMBER
260 , p0_a9 OUT NOCOPY VARCHAR2
261 , p0_a10 OUT NOCOPY VARCHAR2
262 , p0_a11 OUT NOCOPY VARCHAR2
263 , p0_a12 OUT NOCOPY VARCHAR2
264 , p0_a13 OUT NOCOPY VARCHAR2
265 , p0_a14 OUT NOCOPY VARCHAR2
266 , p0_a15 OUT NOCOPY NUMBER
267 , p0_a16 OUT NOCOPY VARCHAR2
268 , p0_a17 OUT NOCOPY VARCHAR2
269 , p0_a18 OUT NOCOPY VARCHAR2
270 , p0_a19 OUT NOCOPY VARCHAR2
271 , p0_a20 OUT NOCOPY NUMBER
272 );
273 end ams_setup_attr_pvt_w;