DBA Data[Home] [Help]

APPS.BEN_CWB_STOCK_OPTN_DTLS_API dependencies on HR_API

Line 152: when hr_api.cannot_find_prog_unit then

148: ,p_cso_attribute29 => p_cso_attribute9
149: ,p_cso_attribute30 => p_cso_attribute30
150: );
151: exception
152: when hr_api.cannot_find_prog_unit then
153: hr_api.cannot_find_prog_unit_error
154: (p_module_name => 'create_cwb_stock_optn_dtls'
155: ,p_hook_type => 'BP'
156: );

Line 153: hr_api.cannot_find_prog_unit_error

149: ,p_cso_attribute30 => p_cso_attribute30
150: );
151: exception
152: when hr_api.cannot_find_prog_unit then
153: hr_api.cannot_find_prog_unit_error
154: (p_module_name => 'create_cwb_stock_optn_dtls'
155: ,p_hook_type => 'BP'
156: );
157: end;

Line 294: when hr_api.cannot_find_prog_unit then

290: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
291: ,p_object_version_number => p_object_version_number
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'create_cwb_stock_optn_dtls'
297: ,p_hook_type => 'AP'
298: );

Line 295: hr_api.cannot_find_prog_unit_error

291: ,p_object_version_number => p_object_version_number
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'create_cwb_stock_optn_dtls'
297: ,p_hook_type => 'AP'
298: );
299: end;

Line 304: raise hr_api.validate_enabled;

300: --
301: -- When in validation only mode raise the Validate_Enabled exception
302: --
303: if p_validate then
304: raise hr_api.validate_enabled;
305: end if;
306: --
307: -- Set all IN OUT and OUT parameters with out values
308: --

Line 314: when hr_api.validate_enabled then

310: p_object_version_number := l_object_version_number;
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised
317: -- we must rollback to the savepoint
318: --

Line 352: ,p_grant_id in number default hr_api.g_number

348: procedure update_cwb_stock_optn_dtls
349: (p_validate in boolean default false
350: ,p_effective_date in date
351: ,p_cwb_stock_optn_dtls_id in number
352: ,p_grant_id in number default hr_api.g_number
353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date

Line 353: ,p_grant_number in varchar2 default hr_api.g_varchar2

349: (p_validate in boolean default false
350: ,p_effective_date in date
351: ,p_cwb_stock_optn_dtls_id in number
352: ,p_grant_id in number default hr_api.g_number
353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number

Line 354: ,p_grant_name in varchar2 default hr_api.g_varchar2

350: ,p_effective_date in date
351: ,p_cwb_stock_optn_dtls_id in number
352: ,p_grant_id in number default hr_api.g_number
353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number

Line 355: ,p_grant_type in varchar2 default hr_api.g_varchar2

351: ,p_cwb_stock_optn_dtls_id in number
352: ,p_grant_id in number default hr_api.g_number
353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number

Line 356: ,p_grant_date in date default hr_api.g_date

352: ,p_grant_id in number default hr_api.g_number
353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number

Line 357: ,p_grant_shares in number default hr_api.g_number

353: ,p_grant_number in varchar2 default hr_api.g_varchar2
354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number

Line 358: ,p_grant_price in number default hr_api.g_number

354: ,p_grant_name in varchar2 default hr_api.g_varchar2
355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number

Line 359: ,p_value_at_grant in number default hr_api.g_number

355: ,p_grant_type in varchar2 default hr_api.g_varchar2
356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number

Line 360: ,p_current_share_price in number default hr_api.g_number

356: ,p_grant_date in date default hr_api.g_date
357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number

Line 361: ,p_current_shares_outstanding in number default hr_api.g_number

357: ,p_grant_shares in number default hr_api.g_number
358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number

Line 362: ,p_vested_shares in number default hr_api.g_number

358: ,p_grant_price in number default hr_api.g_number
359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number

Line 363: ,p_unvested_shares in number default hr_api.g_number

359: ,p_value_at_grant in number default hr_api.g_number
360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2

Line 364: ,p_exercisable_shares in number default hr_api.g_number

360: ,p_current_share_price in number default hr_api.g_number
361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date

Line 365: ,p_exercised_shares in number default hr_api.g_number

361: ,p_current_shares_outstanding in number default hr_api.g_number
362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2

Line 366: ,p_cancelled_shares in number default hr_api.g_number

362: ,p_vested_shares in number default hr_api.g_number
363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2

Line 367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2

363: ,p_unvested_shares in number default hr_api.g_number
364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2

Line 368: ,p_expiration_date in date default hr_api.g_date

364: ,p_exercisable_shares in number default hr_api.g_number
365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2

Line 369: ,p_reason_code in varchar2 default hr_api.g_varchar2

365: ,p_exercised_shares in number default hr_api.g_number
366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number

Line 370: ,p_class in varchar2 default hr_api.g_varchar2

366: ,p_cancelled_shares in number default hr_api.g_number
367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number

Line 371: ,p_misc in varchar2 default hr_api.g_varchar2

367: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number

Line 372: ,p_employee_number in varchar2 default hr_api.g_varchar2

368: ,p_expiration_date in date default hr_api.g_date
369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2

Line 373: ,p_person_id in number default hr_api.g_number

369: ,p_reason_code in varchar2 default hr_api.g_varchar2
370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2

Line 374: ,p_business_group_id in number default hr_api.g_number

370: ,p_class in varchar2 default hr_api.g_varchar2
371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2

Line 375: ,p_prtt_rt_val_id in number default hr_api.g_number

371: ,p_misc in varchar2 default hr_api.g_varchar2
372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2

Line 376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2

372: ,p_employee_number in varchar2 default hr_api.g_varchar2
373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2

Line 377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2

373: ,p_person_id in number default hr_api.g_number
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2

Line 378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2

374: ,p_business_group_id in number default hr_api.g_number
375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2

Line 379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2

375: ,p_prtt_rt_val_id in number default hr_api.g_number
376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2

Line 380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2

376: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2

Line 381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2

377: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2

Line 382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2

378: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2

Line 383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2

379: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2

Line 384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2

380: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2

Line 385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2

381: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2

Line 386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2

382: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2

Line 387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2

383: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2

Line 388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2

384: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2

Line 389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2

385: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2

Line 390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2

386: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2

Line 391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2

387: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2

Line 392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2

388: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2

Line 393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2

389: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2

Line 394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2

390: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2

Line 395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2

391: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2

Line 396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2

392: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2

Line 397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2

393: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2

Line 398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2

394: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2

Line 399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2

395: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2

Line 400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2

396: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2

Line 401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2

397: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2

Line 402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2

398: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2

Line 403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2

399: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
407: ,p_object_version_number in out nocopy number

Line 404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2

400: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
407: ,p_object_version_number in out nocopy number
408: ) is

Line 405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2

401: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
407: ,p_object_version_number in out nocopy number
408: ) is
409: --

Line 406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2

402: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
403: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
404: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
405: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
406: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
407: ,p_object_version_number in out nocopy number
408: ) is
409: --
410: -- Declare cursors and local variables

Line 491: when hr_api.cannot_find_prog_unit then

487: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
488: ,p_object_version_number => l_object_version_number
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'update_cwb_stock_optn_dtls'
494: ,p_hook_type => 'BP'
495: );

Line 492: hr_api.cannot_find_prog_unit_error

488: ,p_object_version_number => l_object_version_number
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'update_cwb_stock_optn_dtls'
494: ,p_hook_type => 'BP'
495: );
496: end;

Line 633: when hr_api.cannot_find_prog_unit then

629: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
630: ,p_object_version_number => p_object_version_number
631: );
632: exception
633: when hr_api.cannot_find_prog_unit then
634: hr_api.cannot_find_prog_unit_error
635: (p_module_name => 'update_cwb_stock_optn_dtls'
636: ,p_hook_type => 'AP'
637: );

Line 634: hr_api.cannot_find_prog_unit_error

630: ,p_object_version_number => p_object_version_number
631: );
632: exception
633: when hr_api.cannot_find_prog_unit then
634: hr_api.cannot_find_prog_unit_error
635: (p_module_name => 'update_cwb_stock_optn_dtls'
636: ,p_hook_type => 'AP'
637: );
638: end;

Line 643: raise hr_api.validate_enabled;

639: --
640: -- When in validation only mode raise the Validate_Enabled exception
641: --
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: -- Set all IN OUT and OUT parameters with out values
647: --

Line 652: when hr_api.validate_enabled then

648: p_object_version_number := l_object_version_number;
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 70);
651: exception
652: when hr_api.validate_enabled then
653: --
654: -- As the Validate_Enabled exception has been raised
655: -- we must rollback to the savepoint
656: --

Line 712: when hr_api.cannot_find_prog_unit then

708: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
709: ,p_object_version_number => p_object_version_number
710: );
711: exception
712: when hr_api.cannot_find_prog_unit then
713: hr_api.cannot_find_prog_unit_error
714: (p_module_name => 'delete_cwb_stock_optn_dtls'
715: ,p_hook_type => 'BP'
716: );

Line 713: hr_api.cannot_find_prog_unit_error

709: ,p_object_version_number => p_object_version_number
710: );
711: exception
712: when hr_api.cannot_find_prog_unit then
713: hr_api.cannot_find_prog_unit_error
714: (p_module_name => 'delete_cwb_stock_optn_dtls'
715: ,p_hook_type => 'BP'
716: );
717: end;

Line 743: when hr_api.cannot_find_prog_unit then

739: ,p_cwb_stock_optn_dtls_id => p_cwb_stock_optn_dtls_id
740: ,p_object_version_number => p_object_version_number
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'delete_cwb_stock_optn_dtls'
746: ,p_hook_type => 'AP'
747: );

Line 744: hr_api.cannot_find_prog_unit_error

740: ,p_object_version_number => p_object_version_number
741: );
742: exception
743: when hr_api.cannot_find_prog_unit then
744: hr_api.cannot_find_prog_unit_error
745: (p_module_name => 'delete_cwb_stock_optn_dtls'
746: ,p_hook_type => 'AP'
747: );
748: end;

Line 753: raise hr_api.validate_enabled;

749: --
750: -- When in validation only mode raise the Validate_Enabled exception
751: --
752: if p_validate then
753: raise hr_api.validate_enabled;
754: end if;
755: --
756: hr_utility.set_location(' Leaving:'||l_proc, 70);
757: exception

Line 758: when hr_api.validate_enabled then

754: end if;
755: --
756: hr_utility.set_location(' Leaving:'||l_proc, 70);
757: exception
758: when hr_api.validate_enabled then
759: --
760: -- As the Validate_Enabled exception has been raised
761: -- we must rollback to the savepoint
762: --