1 Package hr_elc_constituencys_api as
2 /* $Header: peecoapi.pkh 120.1 2005/10/02 02:15:15 aroussel $ */
3 /*#
4 * This API creates constituencies for election.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Election constituency
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_election_constituency >-------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates constituencies for election.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Human Resources.
21 *
22 * <p><b>Prerequisites</b><br>
23 * Organization with the classification of constituency must already exist.
24 * Also election must already exist.
25 *
26 * <p><b>Post Success</b><br>
27 * Election_constituency is created.
28 *
29 * <p><b>Post Failure</b><br>
30 * Election constituency does not get created and error is returned.
31 * @param p_validate If true, then validation alone will be performed and the
32 * database will remain unchanged. If false and all validation checks pass,
33 * then the database will be modified.
34 * @param p_effective_date Reference date for validating lookup values are
35 * applicable during the start to end active date range. This date does not
36 * determine when the changes take effect.
37 * @param p_election_id Uniquely identifies the election for which the process
38 * is creating a constituency.
39 * @param p_business_group_id Uniquely identifies the business group associated
40 * with the constituency.
41 * @param p_constituency_id Uniquely identifies the constituency associated
42 * with the election.
43 * @param p_attribute_category This context value determines which flexfield
44 * structure to use with the descriptive flexfield segments.
45 * @param p_attribute1 Descriptive flexfield segment.
46 * @param p_attribute2 Descriptive flexfield segment.
47 * @param p_attribute3 Descriptive flexfield segment.
48 * @param p_attribute4 Descriptive flexfield segment.
49 * @param p_attribute5 Descriptive flexfield segment.
50 * @param p_attribute6 Descriptive flexfield segment.
51 * @param p_attribute7 Descriptive flexfield segment.
52 * @param p_attribute8 Descriptive flexfield segment.
53 * @param p_attribute9 Descriptive flexfield segment.
54 * @param p_attribute10 Descriptive flexfield segment.
55 * @param p_attribute11 Descriptive flexfield segment.
56 * @param p_attribute12 Descriptive flexfield segment.
57 * @param p_attribute13 Descriptive flexfield segment.
58 * @param p_attribute14 Descriptive flexfield segment.
59 * @param p_attribute15 Descriptive flexfield segment.
60 * @param p_attribute16 Descriptive flexfield segment.
61 * @param p_attribute17 Descriptive flexfield segment.
62 * @param p_attribute18 Descriptive flexfield segment.
63 * @param p_attribute19 Descriptive flexfield segment.
64 * @param p_attribute20 Descriptive flexfield segment.
65 * @param p_attribute21 Descriptive flexfield segment.
66 * @param p_attribute22 Descriptive flexfield segment.
67 * @param p_attribute23 Descriptive flexfield segment.
68 * @param p_attribute24 Descriptive flexfield segment.
69 * @param p_attribute25 Descriptive flexfield segment.
70 * @param p_attribute26 Descriptive flexfield segment.
71 * @param p_attribute27 Descriptive flexfield segment.
72 * @param p_attribute28 Descriptive flexfield segment.
73 * @param p_attribute29 Descriptive flexfield segment.
74 * @param p_attribute30 Descriptive flexfield segment.
75 * @param p_election_constituency_id If p_validate is false, uniquely
76 * identifies the election constituency created. If p_validate is true, set to
77 * null.
78 * @param p_object_version_number If p_validate is false, then set to the
79 * version number of the created Election Constituency. If p_validate is true,
80 * then the value will be null.
81 * @rep:displayname Create Election Constituency
82 * @rep:category BUSINESS_ENTITY PER_WORK_COUNCIL_ELECTION
83 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
84 * @rep:scope public
85 * @rep:lifecycle active
86 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
87 */
88 --
89 -- {End Of Comments}
90 --
91 procedure create_election_constituency
92 (p_validate in boolean default false
93 ,p_effective_date in date
94 ,p_election_id in number
95 ,p_business_group_id in number
96 ,p_constituency_id in number
97 ,p_attribute_category in varchar2 default null
98 ,p_attribute1 in varchar2 default null
99 ,p_attribute2 in varchar2 default null
100 ,p_attribute3 in varchar2 default null
101 ,p_attribute4 in varchar2 default null
102 ,p_attribute5 in varchar2 default null
103 ,p_attribute6 in varchar2 default null
104 ,p_attribute7 in varchar2 default null
105 ,p_attribute8 in varchar2 default null
106 ,p_attribute9 in varchar2 default null
107 ,p_attribute10 in varchar2 default null
108 ,p_attribute11 in varchar2 default null
109 ,p_attribute12 in varchar2 default null
110 ,p_attribute13 in varchar2 default null
111 ,p_attribute14 in varchar2 default null
112 ,p_attribute15 in varchar2 default null
113 ,p_attribute16 in varchar2 default null
114 ,p_attribute17 in varchar2 default null
115 ,p_attribute18 in varchar2 default null
116 ,p_attribute19 in varchar2 default null
117 ,p_attribute20 in varchar2 default null
118 ,p_attribute21 in varchar2 default null
119 ,p_attribute22 in varchar2 default null
120 ,p_attribute23 in varchar2 default null
121 ,p_attribute24 in varchar2 default null
122 ,p_attribute25 in varchar2 default null
123 ,p_attribute26 in varchar2 default null
124 ,p_attribute27 in varchar2 default null
125 ,p_attribute28 in varchar2 default null
126 ,p_attribute29 in varchar2 default null
127 ,p_attribute30 in varchar2 default null
128 ,p_election_constituency_id out nocopy number
129 ,p_object_version_number out nocopy number
130 );
131 --
132 -- ----------------------------------------------------------------------------
133 -- |-----------------------< update_election_constituency >-------------------|
134 -- ----------------------------------------------------------------------------
135 --
136 -- {Start Of Comments}
137 /*#
138 * This API updates election constituencies.
139 *
140 *
141 * <p><b>Licensing</b><br>
142 * This API is licensed for use with Human Resources.
143 *
144 * <p><b>Prerequisites</b><br>
145 * Organization with the classification of constituency must already exist.
146 * Also election must already exist.
147 *
148 * <p><b>Post Success</b><br>
149 * Election constituency will be updated.
150 *
151 * <p><b>Post Failure</b><br>
152 * Election constituency is not updated and error is returned.
153 * @param p_validate If true, then validation alone will be performed and the
154 * database will remain unchanged. If false and all validation checks pass,
155 * then the database will be modified.
156 * @param p_effective_date Reference date for validating lookup values are
157 * applicable during the start to end active date range. This date does not
158 * determine when the changes take effect.
159 * @param p_election_constituency_id Uniquely identifies the election
160 * constituency record to modify.
161 * @param p_election_id Uniquely identifies the election for which the process
162 * is updating a constituency.
163 * @param p_business_group_id Uniquely identifies the business group associated
164 * with the constituency.
165 * @param p_constituency_id Uniquely identifies the constituency associated
166 * with the election.
167 * @param p_attribute_category This context value determines which flexfield
168 * structure to use with the descriptive flexfield segments.
169 * @param p_attribute1 Descriptive flexfield segment.
170 * @param p_attribute2 Descriptive flexfield segment.
171 * @param p_attribute3 Descriptive flexfield segment.
172 * @param p_attribute4 Descriptive flexfield segment.
173 * @param p_attribute5 Descriptive flexfield segment.
174 * @param p_attribute6 Descriptive flexfield segment.
175 * @param p_attribute7 Descriptive flexfield segment.
176 * @param p_attribute8 Descriptive flexfield segment.
177 * @param p_attribute9 Descriptive flexfield segment.
178 * @param p_attribute10 Descriptive flexfield segment.
179 * @param p_attribute11 Descriptive flexfield segment.
180 * @param p_attribute12 Descriptive flexfield segment.
181 * @param p_attribute13 Descriptive flexfield segment.
182 * @param p_attribute14 Descriptive flexfield segment.
183 * @param p_attribute15 Descriptive flexfield segment.
184 * @param p_attribute16 Descriptive flexfield segment.
185 * @param p_attribute17 Descriptive flexfield segment.
186 * @param p_attribute18 Descriptive flexfield segment.
187 * @param p_attribute19 Descriptive flexfield segment.
188 * @param p_attribute20 Descriptive flexfield segment.
189 * @param p_attribute21 Descriptive flexfield segment.
190 * @param p_attribute22 Descriptive flexfield segment.
191 * @param p_attribute23 Descriptive flexfield segment.
192 * @param p_attribute24 Descriptive flexfield segment.
193 * @param p_attribute25 Descriptive flexfield segment.
194 * @param p_attribute26 Descriptive flexfield segment.
195 * @param p_attribute27 Descriptive flexfield segment.
196 * @param p_attribute28 Descriptive flexfield segment.
197 * @param p_attribute29 Descriptive flexfield segment.
198 * @param p_attribute30 Descriptive flexfield segment.
199 * @param p_object_version_number Pass in the current version number of the
200 * election constituency to be updated. When the API completes if p_validate is
201 * false, will be set to the new version number of the updated election
202 * constituency. If p_validate is true will be set to the same value which was
203 * passed in.
204 * @rep:displayname Update Election Constituency
205 * @rep:category BUSINESS_ENTITY PER_WORK_COUNCIL_ELECTION
206 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
207 * @rep:scope public
208 * @rep:lifecycle active
209 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
210 */
211 --
212 -- {End Of Comments}
213 --
214 procedure update_election_constituency
215 (p_validate in boolean default false
216 ,p_effective_date in date
217 ,p_election_constituency_id in out nocopy number
218 ,p_election_id in number default hr_api.g_number
219 ,p_business_group_id in number default hr_api.g_number
220 ,p_constituency_id in number default hr_api.g_number
221 ,p_attribute_category in varchar2 default hr_api.g_varchar2
222 ,p_attribute1 in varchar2 default hr_api.g_varchar2
223 ,p_attribute2 in varchar2 default hr_api.g_varchar2
224 ,p_attribute3 in varchar2 default hr_api.g_varchar2
225 ,p_attribute4 in varchar2 default hr_api.g_varchar2
226 ,p_attribute5 in varchar2 default hr_api.g_varchar2
227 ,p_attribute6 in varchar2 default hr_api.g_varchar2
228 ,p_attribute7 in varchar2 default hr_api.g_varchar2
229 ,p_attribute8 in varchar2 default hr_api.g_varchar2
230 ,p_attribute9 in varchar2 default hr_api.g_varchar2
231 ,p_attribute10 in varchar2 default hr_api.g_varchar2
232 ,p_attribute11 in varchar2 default hr_api.g_varchar2
233 ,p_attribute12 in varchar2 default hr_api.g_varchar2
234 ,p_attribute13 in varchar2 default hr_api.g_varchar2
235 ,p_attribute14 in varchar2 default hr_api.g_varchar2
236 ,p_attribute15 in varchar2 default hr_api.g_varchar2
237 ,p_attribute16 in varchar2 default hr_api.g_varchar2
238 ,p_attribute17 in varchar2 default hr_api.g_varchar2
239 ,p_attribute18 in varchar2 default hr_api.g_varchar2
240 ,p_attribute19 in varchar2 default hr_api.g_varchar2
241 ,p_attribute20 in varchar2 default hr_api.g_varchar2
242 ,p_attribute21 in varchar2 default hr_api.g_varchar2
243 ,p_attribute22 in varchar2 default hr_api.g_varchar2
244 ,p_attribute23 in varchar2 default hr_api.g_varchar2
245 ,p_attribute24 in varchar2 default hr_api.g_varchar2
246 ,p_attribute25 in varchar2 default hr_api.g_varchar2
247 ,p_attribute26 in varchar2 default hr_api.g_varchar2
248 ,p_attribute27 in varchar2 default hr_api.g_varchar2
249 ,p_attribute28 in varchar2 default hr_api.g_varchar2
250 ,p_attribute29 in varchar2 default hr_api.g_varchar2
251 ,p_attribute30 in varchar2 default hr_api.g_varchar2
252 ,p_object_version_number in out nocopy number
253 );
254 --
255 -- ----------------------------------------------------------------------------
256 -- |-----------------------< delete_election_constituency >-------------------|
257 -- ----------------------------------------------------------------------------
258 --
259 -- {Start Of Comments}
260 /*#
261 * This API deletes an election constituency.
262 *
263 *
264 * <p><b>Licensing</b><br>
265 * This API is licensed for use with Human Resources.
266 *
267 * <p><b>Prerequisites</b><br>
268 * Election constituency record must already exist.
269 *
270 * <p><b>Post Success</b><br>
271 * Election constituency will be deleted.
272 *
273 * <p><b>Post Failure</b><br>
274 * Election constituency is not deleted and error is returned.
275 * @param p_validate If true, then validation alone will be performed and the
276 * database will remain unchanged. If false and all validation checks pass,
277 * then the database will be modified.
278 * @param p_election_constituency_id Uniquely identifies the election
279 * constituency record to delete.
280 * @param p_object_version_number Current version number of the Election
281 * Constituency to be deleted.
282 * @rep:displayname Delete Election Constituency
283 * @rep:category BUSINESS_ENTITY PER_WORK_COUNCIL_ELECTION
284 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
285 * @rep:scope public
286 * @rep:lifecycle active
287 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
288 */
289 --
290 -- {End Of Comments}
291 --
292 procedure delete_election_constituency
293 (p_validate in boolean default false
294 ,p_election_constituency_id in number
295 ,p_object_version_number in number
296 );
297 --
298 end hr_elc_constituencys_api;