1 Package BEN_CWB_STOCK_OPTN_DTLS_API as
2 /* $Header: becsoapi.pkh 120.4 2006/10/17 10:30:58 steotia noship $ */
3 /*#
4 * This package contains APIs to upload third party stock option data.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Compensation Workbench Stock Option
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_cwb_stock_optn_dtls >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API inserts a Compensation Workbench Stock Option Detail record.
17 *
18 * This new record is shown in the extended stock option region of the
19 * Compensation Workbench history pages. The load process uses this API to load
20 * the stock detail data obtained from an external source.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Self-Service Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The employee record must exist.
27 *
28 * <p><b>Post Success</b><br>
29 * The Compensation Workbench Stock Option Detail record is successfully
30 * inserted in the database.
31 *
32 * <p><b>Post Failure</b><br>
33 * The API does not create the Compensation Workbench Stock Option Detail
34 * record, and raises an error.
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Reference date for validating lookup values are
39 * applicable during the start to end active date range. This date does not
40 * determine when the changes take effect.
41 * @param p_grant_id {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_ID}
42 * @param p_grant_number {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_NUMBER}
43 * @param p_grant_name {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_NAME}
44 * @param p_grant_type {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_TYPE}
45 * @param p_grant_date {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_DATE}
46 * @param p_grant_shares {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_SHARES}
47 * @param p_grant_price {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_PRICE}
48 * @param p_value_at_grant {@rep:casecolumn
49 * BEN_CWB_STOCK_OPTN_DTLS.VALUE_AT_GRANT}
50 * @param p_current_share_price {@rep:casecolumn
51 * BEN_CWB_STOCK_OPTN_DTLS.CURRENT_SHARE_PRICE}
52 * @param p_current_shares_outstanding Number of current outstanding shares.
53 * @param p_vested_shares {@rep:casecolumn
54 * BEN_CWB_STOCK_OPTN_DTLS.VESTED_SHARES}
55 * @param p_unvested_shares {@rep:casecolumn
56 * BEN_CWB_STOCK_OPTN_DTLS.UNVESTED_SHARES}
57 * @param p_exercisable_shares {@rep:casecolumn
58 * BEN_CWB_STOCK_OPTN_DTLS.EXERCISABLE_SHARES}
59 * @param p_exercised_shares {@rep:casecolumn
60 * BEN_CWB_STOCK_OPTN_DTLS.EXERCISED_SHARES}
61 * @param p_cancelled_shares {@rep:casecolumn
62 * BEN_CWB_STOCK_OPTN_DTLS.CANCELLED_SHARES}
63 * @param p_trading_symbol {@rep:casecolumn
64 * BEN_CWB_STOCK_OPTN_DTLS.TRADING_SYMBOL}
65 * @param p_expiration_date {@rep:casecolumn
66 * BEN_CWB_STOCK_OPTN_DTLS.EXPIRATION_DATE}
67 * @param p_reason_code {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.REASON_CODE}
68 * @param p_class {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.CLASS}
69 * @param p_misc {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.MISC}
70 * @param p_employee_number Specifies the Employee Number of the person to whom
71 * the stock option was granted. If the Person ID is not passed, then the
72 * process requires this Employee Number.
73 * @param p_person_id Specifies the Person ID of the person to whom the stock
74 * option was granted. If passed, the person record must exist. If the Person
75 * ID is not passed in, then the process requires the Business Group and
76 * Employee Number.
77 * @param p_business_group_id Specifies the Business Group ID of the person to
78 * whom the stock option was granted. If passed, then the Business Group record
79 * must exist. If the Person ID is not passed in, the process requires the
80 * Business Group ID.
81 * @param p_prtt_rt_val_id {@rep:casecolumn
82 * BEN_CWB_STOCK_OPTN_DTLS.PRTT_RT_VAL_ID}
83 * @param p_cso_attribute_category {@rep:casecolumn
84 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE_CATEGORY}
85 * @param p_cso_attribute1 {@rep:casecolumn
86 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE1}
87 * @param p_cso_attribute2 {@rep:casecolumn
88 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE2}
89 * @param p_cso_attribute3 {@rep:casecolumn
90 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE3}
91 * @param p_cso_attribute4 {@rep:casecolumn
92 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE4}
93 * @param p_cso_attribute5 {@rep:casecolumn
94 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE5}
95 * @param p_cso_attribute6 {@rep:casecolumn
96 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE6}
97 * @param p_cso_attribute7 {@rep:casecolumn
98 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE7}
99 * @param p_cso_attribute8 {@rep:casecolumn
100 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE8}
101 * @param p_cso_attribute9 {@rep:casecolumn
102 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE9}
103 * @param p_cso_attribute10 {@rep:casecolumn
104 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE10}
105 * @param p_cso_attribute11 {@rep:casecolumn
106 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE11}
107 * @param p_cso_attribute12 {@rep:casecolumn
108 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE12}
109 * @param p_cso_attribute13 {@rep:casecolumn
110 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE13}
111 * @param p_cso_attribute14 {@rep:casecolumn
112 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE14}
113 * @param p_cso_attribute15 {@rep:casecolumn
114 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE15}
115 * @param p_cso_attribute16 {@rep:casecolumn
116 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE16}
117 * @param p_cso_attribute17 {@rep:casecolumn
118 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE17}
119 * @param p_cso_attribute18 {@rep:casecolumn
120 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE18}
121 * @param p_cso_attribute19 {@rep:casecolumn
122 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE19}
123 * @param p_cso_attribute20 {@rep:casecolumn
124 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE20}
125 * @param p_cso_attribute21 {@rep:casecolumn
126 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE21}
127 * @param p_cso_attribute22 {@rep:casecolumn
128 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE22}
129 * @param p_cso_attribute23 {@rep:casecolumn
130 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE23}
131 * @param p_cso_attribute24 {@rep:casecolumn
132 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE24}
133 * @param p_cso_attribute25 {@rep:casecolumn
134 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE25}
135 * @param p_cso_attribute26 {@rep:casecolumn
136 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE26}
137 * @param p_cso_attribute27 {@rep:casecolumn
138 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE27}
139 * @param p_cso_attribute28 {@rep:casecolumn
140 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE28}
141 * @param p_cso_attribute29 {@rep:casecolumn
142 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE29}
143 * @param p_cso_attribute30 {@rep:casecolumn
144 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE30}
145 * @param p_cwb_stock_optn_dtls_id Identifier of the Compensation Workbench
146 * Stock Option Detail record.
147 * @param p_object_version_number Pass in the current version number of the
148 * stock detail record to be updated. When the API completes if p_validate is
149 * false, will be set to the new version number of the updated stock detail
150 * record. If p_validate is true will be set to the same value which was passed
151 * in.
152 * @rep:displayname Create Compensation Workbench Stock Option
153 * @rep:category BUSINESS_ENTITY BEN_CWB_3RD_PARTY_STOCK_OPTS
154 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
155 * @rep:scope public
156 * @rep:lifecycle active
157 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
158 */
159 --
160 -- {End Of Comments}
161 --
162 procedure create_cwb_stock_optn_dtls
163 (p_validate in boolean default false
164 ,p_effective_date in date
165 ,p_grant_id in number default null
166 ,p_grant_number in varchar2 default null
167 ,p_grant_name in varchar2 default null
168 ,p_grant_type in varchar2 default null
169 ,p_grant_date in date default null
170 ,p_grant_shares in number default null
171 ,p_grant_price in number default null
172 ,p_value_at_grant in number default null
173 ,p_current_share_price in number default null
174 ,p_current_shares_outstanding in number default null
175 ,p_vested_shares in number default null
176 ,p_unvested_shares in number default null
177 ,p_exercisable_shares in number default null
178 ,p_exercised_shares in number default null
179 ,p_cancelled_shares in number default null
180 ,p_trading_symbol in varchar2 default null
181 ,p_expiration_date in date default null
182 ,p_reason_code in varchar2 default null
183 ,p_class in varchar2 default null
184 ,p_misc in varchar2 default null
185 ,p_employee_number in varchar2 default null
186 ,p_person_id in number default null
187 ,p_business_group_id in number default null
188 ,p_prtt_rt_val_id in number default null
189 ,p_cso_attribute_category in varchar2 default null
190 ,p_cso_attribute1 in varchar2 default null
191 ,p_cso_attribute2 in varchar2 default null
192 ,p_cso_attribute3 in varchar2 default null
193 ,p_cso_attribute4 in varchar2 default null
194 ,p_cso_attribute5 in varchar2 default null
195 ,p_cso_attribute6 in varchar2 default null
196 ,p_cso_attribute7 in varchar2 default null
197 ,p_cso_attribute8 in varchar2 default null
198 ,p_cso_attribute9 in varchar2 default null
199 ,p_cso_attribute10 in varchar2 default null
200 ,p_cso_attribute11 in varchar2 default null
201 ,p_cso_attribute12 in varchar2 default null
202 ,p_cso_attribute13 in varchar2 default null
203 ,p_cso_attribute14 in varchar2 default null
204 ,p_cso_attribute15 in varchar2 default null
205 ,p_cso_attribute16 in varchar2 default null
206 ,p_cso_attribute17 in varchar2 default null
207 ,p_cso_attribute18 in varchar2 default null
208 ,p_cso_attribute19 in varchar2 default null
209 ,p_cso_attribute20 in varchar2 default null
210 ,p_cso_attribute21 in varchar2 default null
211 ,p_cso_attribute22 in varchar2 default null
212 ,p_cso_attribute23 in varchar2 default null
213 ,p_cso_attribute24 in varchar2 default null
214 ,p_cso_attribute25 in varchar2 default null
215 ,p_cso_attribute26 in varchar2 default null
216 ,p_cso_attribute27 in varchar2 default null
217 ,p_cso_attribute28 in varchar2 default null
218 ,p_cso_attribute29 in varchar2 default null
219 ,p_cso_attribute30 in varchar2 default null
220 ,p_cwb_stock_optn_dtls_id out nocopy number
221 ,p_object_version_number out nocopy number
222 );
223 --
224 -- ----------------------------------------------------------------------------
225 -- |------------------------< update_cwb_stock_optn_dtls >--------------------|
226 -- ----------------------------------------------------------------------------
227 --
228 -- {Start Of Comments}
229 /*#
230 * This API updates a Compensation Workbench Stock Option Detail record.
231 *
232 * This updated record is shown in the extended stock option region of the
233 * Compensation Workbench history pages.
234 *
235 * <p><b>Licensing</b><br>
236 * This API is licensed for use with Self-Service Human Resources.
237 *
238 * <p><b>Prerequisites</b><br>
239 * The stock option detail record must exist.
240 *
241 * <p><b>Post Success</b><br>
242 * The Compensation Workbench Stock Option Detail record is successfully
243 * updated in the database.
244 *
245 * <p><b>Post Failure</b><br>
246 * The API does not update the Compensation Workbench Stock Option Detail
247 * record and raises an error.
248 * @param p_validate If true, then validation alone will be performed and the
249 * database will remain unchanged. If false and all validation checks pass,
250 * then the database will be modified.
251 * @param p_effective_date Reference date for validating lookup values are
252 * applicable during the start to end active date range. This date does not
253 * determine when the changes take effect.
254 * @param p_cwb_stock_optn_dtls_id The identifier of the Compensation Workbench
255 * Stock Option Detail record to update.
256 * @param p_grant_id {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_ID}
257 * @param p_grant_number {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_NUMBER}
258 * @param p_grant_name {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_NAME}
259 * @param p_grant_type {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_TYPE}
260 * @param p_grant_date {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_DATE}
261 * @param p_grant_shares {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_SHARES}
262 * @param p_grant_price {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.GRANT_PRICE}
263 * @param p_value_at_grant {@rep:casecolumn
264 * BEN_CWB_STOCK_OPTN_DTLS.VALUE_AT_GRANT}
265 * @param p_current_share_price {@rep:casecolumn
266 * BEN_CWB_STOCK_OPTN_DTLS.CURRENT_SHARE_PRICE}
267 * @param p_current_shares_outstanding Number of current outstanding shares.
268 * @param p_vested_shares {@rep:casecolumn
269 * BEN_CWB_STOCK_OPTN_DTLS.VESTED_SHARES}
270 * @param p_unvested_shares {@rep:casecolumn
271 * BEN_CWB_STOCK_OPTN_DTLS.UNVESTED_SHARES}
272 * @param p_exercisable_shares {@rep:casecolumn
273 * BEN_CWB_STOCK_OPTN_DTLS.EXERCISABLE_SHARES}
274 * @param p_exercised_shares {@rep:casecolumn
275 * BEN_CWB_STOCK_OPTN_DTLS.EXERCISED_SHARES}
276 * @param p_cancelled_shares {@rep:casecolumn
277 * BEN_CWB_STOCK_OPTN_DTLS.CANCELLED_SHARES}
278 * @param p_trading_symbol {@rep:casecolumn
279 * BEN_CWB_STOCK_OPTN_DTLS.TRADING_SYMBOL}
280 * @param p_expiration_date {@rep:casecolumn
281 * BEN_CWB_STOCK_OPTN_DTLS.EXPIRATION_DATE}
282 * @param p_reason_code {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.REASON_CODE}
283 * @param p_class {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.CLASS}
284 * @param p_misc {@rep:casecolumn BEN_CWB_STOCK_OPTN_DTLS.MISC}
285 * @param p_employee_number {@rep:casecolumn
286 * BEN_CWB_STOCK_OPTN_DTLS.EMPLOYEE_NUMBER}
287 * @param p_person_id Specifies the person to whom the stock has been granted.
288 * @param p_business_group_id Specifies the Business Group of the person.
289 * @param p_prtt_rt_val_id {@rep:casecolumn
290 * BEN_CWB_STOCK_OPTN_DTLS.PRTT_RT_VAL_ID}
291 * @param p_cso_attribute_category {@rep:casecolumn
292 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE_CATEGORY}
293 * @param p_cso_attribute1 {@rep:casecolumn
294 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE1}
295 * @param p_cso_attribute2 {@rep:casecolumn
296 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE2}
297 * @param p_cso_attribute3 {@rep:casecolumn
298 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE3}
299 * @param p_cso_attribute4 {@rep:casecolumn
300 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE4}
301 * @param p_cso_attribute5 {@rep:casecolumn
302 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE5}
303 * @param p_cso_attribute6 {@rep:casecolumn
304 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE6}
305 * @param p_cso_attribute7 {@rep:casecolumn
306 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE7}
307 * @param p_cso_attribute8 {@rep:casecolumn
308 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE8}
309 * @param p_cso_attribute9 {@rep:casecolumn
310 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE9}
311 * @param p_cso_attribute10 {@rep:casecolumn
312 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE10}
313 * @param p_cso_attribute11 {@rep:casecolumn
314 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE11}
315 * @param p_cso_attribute12 {@rep:casecolumn
316 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE12}
317 * @param p_cso_attribute13 {@rep:casecolumn
318 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE13}
319 * @param p_cso_attribute14 {@rep:casecolumn
320 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE14}
321 * @param p_cso_attribute15 {@rep:casecolumn
322 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE15}
323 * @param p_cso_attribute16 {@rep:casecolumn
324 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE16}
325 * @param p_cso_attribute17 {@rep:casecolumn
326 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE17}
327 * @param p_cso_attribute18 {@rep:casecolumn
328 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE18}
329 * @param p_cso_attribute19 {@rep:casecolumn
330 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE19}
331 * @param p_cso_attribute20 {@rep:casecolumn
332 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE20}
333 * @param p_cso_attribute21 {@rep:casecolumn
334 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE21}
335 * @param p_cso_attribute22 {@rep:casecolumn
336 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE22}
337 * @param p_cso_attribute23 {@rep:casecolumn
338 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE23}
339 * @param p_cso_attribute24 {@rep:casecolumn
340 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE24}
341 * @param p_cso_attribute25 {@rep:casecolumn
342 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE25}
343 * @param p_cso_attribute26 {@rep:casecolumn
344 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE26}
345 * @param p_cso_attribute27 {@rep:casecolumn
346 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE27}
347 * @param p_cso_attribute28 {@rep:casecolumn
348 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE28}
349 * @param p_cso_attribute29 {@rep:casecolumn
350 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE29}
351 * @param p_cso_attribute30 {@rep:casecolumn
352 * BEN_CWB_STOCK_OPTN_DTLS.CSO_ATTRIBUTE30}
353 * @param p_object_version_number Pass in the current version number of the
354 * stock detail record to be updated. When the API completes if p_validate is
355 * false, will be set to the new version number of the updated stock detail
356 * record. If p_validate is true will be set to the same value which was passed
357 * in.
358 * @rep:displayname Update Compensation Workbench Stock Option
359 * @rep:category BUSINESS_ENTITY BEN_CWB_3RD_PARTY_STOCK_OPTS
360 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
361 * @rep:scope public
362 * @rep:lifecycle active
363 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
364 */
365 --
366 -- {End Of Comments}
367 --
368 procedure update_cwb_stock_optn_dtls
369 (p_validate in boolean default false
370 ,p_effective_date in date
371 ,p_cwb_stock_optn_dtls_id in number
372 ,p_grant_id in number default hr_api.g_number
373 ,p_grant_number in varchar2 default hr_api.g_varchar2
374 ,p_grant_name in varchar2 default hr_api.g_varchar2
375 ,p_grant_type in varchar2 default hr_api.g_varchar2
376 ,p_grant_date in date default hr_api.g_date
377 ,p_grant_shares in number default hr_api.g_number
378 ,p_grant_price in number default hr_api.g_number
379 ,p_value_at_grant in number default hr_api.g_number
380 ,p_current_share_price in number default hr_api.g_number
381 ,p_current_shares_outstanding in number default hr_api.g_number
385 ,p_exercised_shares in number default hr_api.g_number
382 ,p_vested_shares in number default hr_api.g_number
383 ,p_unvested_shares in number default hr_api.g_number
384 ,p_exercisable_shares in number default hr_api.g_number
386 ,p_cancelled_shares in number default hr_api.g_number
387 ,p_trading_symbol in varchar2 default hr_api.g_varchar2
388 ,p_expiration_date in date default hr_api.g_date
389 ,p_reason_code in varchar2 default hr_api.g_varchar2
390 ,p_class in varchar2 default hr_api.g_varchar2
391 ,p_misc in varchar2 default hr_api.g_varchar2
392 ,p_employee_number in varchar2 default hr_api.g_varchar2
393 ,p_person_id in number default hr_api.g_number
394 ,p_business_group_id in number default hr_api.g_number
395 ,p_prtt_rt_val_id in number default hr_api.g_number
396 ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
397 ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
398 ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
399 ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
400 ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
401 ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
402 ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
403 ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
404 ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
405 ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
406 ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
407 ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
408 ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
409 ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
410 ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
411 ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
412 ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
413 ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
414 ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
415 ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
416 ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
417 ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
418 ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
419 ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
420 ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
421 ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
422 ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
423 ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
424 ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
425 ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
426 ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
427 ,p_object_version_number in out nocopy number
428 );
429 --
430 -- ----------------------------------------------------------------------------
431 -- |------------------------< delete_cwb_stock_optn_dtls >--------------------|
432 -- ----------------------------------------------------------------------------
433 --
434 -- {Start Of Comments}
435 /*#
436 * This API deletes a Compensation Workbench Stock Option Detail record.
437 *
438 * This deleted record will not display in the extended stock option region of
439 * Compensation Workbench History pages.
440 *
441 * <p><b>Licensing</b><br>
442 * This API is licensed for use with Self-Service Human Resources.
443 *
444 * <p><b>Prerequisites</b><br>
445 * The stock option detail record must exist.
446 *
447 * <p><b>Post Success</b><br>
448 * The Compensation Workbench Stock Option Detail record is successfully
449 * deleted from the database.
450 *
451 * <p><b>Post Failure</b><br>
452 * The API does not delete the Compensation Workbench Stock Option Detail
453 * record and raises an error.
454 * @param p_validate If true, then validation alone will be performed and the
455 * database will remain unchanged. If false and all validation checks pass,
456 * then the database will be modified.
457 * @param p_effective_date Reference date for validating lookup values are
458 * applicable during the start to end active date range. This date does not
459 * determine when the changes take effect.
460 * @param p_cwb_stock_optn_dtls_id Identifier of the Stock Option Detail record
461 * to delete.
462 * @param p_object_version_number Current version number of the stock detail
463 * record to be deleted.
464 * @rep:displayname Delete Compensation Workbench Stock Option
465 * @rep:category BUSINESS_ENTITY BEN_CWB_3RD_PARTY_STOCK_OPTS
466 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
467 * @rep:scope public
468 * @rep:lifecycle active
469 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
470 */
471 --
472 -- {End Of Comments}
473 --
474 procedure delete_cwb_stock_optn_dtls
475 (p_validate in boolean default false
476 ,p_effective_date in date
477 ,p_cwb_stock_optn_dtls_id in number
478 ,p_object_version_number in out nocopy number
479 );
480 --
481 -- ----------------------------------------------------------------------------
482 -- |----------------------------------< lck >---------------------------------|
483 -- ----------------------------------------------------------------------------
484 -- {Start Of Comments}
485 --
486 -- Description:
487 --
488 -- Prerequisites:
489 --
490 --
491 -- In Parameters:
492 -- Name Reqd Type Description
493 -- p_cwb_stock_optn_dtls_id Yes number PK of record
494 -- p_object_version_number Yes number OVN of record
495 --
496 -- Post Success:
497 --
498 -- Name Type Description
499 --
500 -- Post Failure:
501 --
502 -- Access Status:
503 -- Public.
504 --
505 -- {End Of Comments}
506 --
507 procedure lck
508 (
509 p_cwb_stock_optn_dtls_id in number
510 ,p_object_version_number in number
511 );
512 --
513 end BEN_CWB_STOCK_OPTN_DTLS_API;