DBA Data[Home] [Help]

APPS.BEN_CSO_UPD dependencies on BEN_CSO_SHD

Line 55: (p_rec in out nocopy ben_cso_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_cso_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 139: ben_cso_shd.constraint_error

135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: --
139: ben_cso_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: --

Line 144: ben_cso_shd.constraint_error

140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: --
144: ben_cso_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --

Line 149: ben_cso_shd.constraint_error

145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_cso_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: --
153: Raise;

Line 189: (p_rec in ben_cso_shd.g_rec_type

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure pre_update
189: (p_rec in ben_cso_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'pre_update';
193: --

Line 234: ,p_rec in ben_cso_shd.g_rec_type

230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure post_update
233: (p_effective_date in date
234: ,p_rec in ben_cso_shd.g_rec_type
235: ) is
236: --
237: l_proc varchar2(72) := g_package||'post_update';
238: --

Line 360: => ben_cso_shd.g_old_rec.grant_id

356: => p_rec.cso_attribute29
357: ,p_cso_attribute30
358: => p_rec.cso_attribute30
359: ,p_grant_id_o
360: => ben_cso_shd.g_old_rec.grant_id
361: ,p_grant_number_o
362: => ben_cso_shd.g_old_rec.grant_number
363: ,p_grant_name_o
364: => ben_cso_shd.g_old_rec.grant_name

Line 362: => ben_cso_shd.g_old_rec.grant_number

358: => p_rec.cso_attribute30
359: ,p_grant_id_o
360: => ben_cso_shd.g_old_rec.grant_id
361: ,p_grant_number_o
362: => ben_cso_shd.g_old_rec.grant_number
363: ,p_grant_name_o
364: => ben_cso_shd.g_old_rec.grant_name
365: ,p_grant_type_o
366: => ben_cso_shd.g_old_rec.grant_type

Line 364: => ben_cso_shd.g_old_rec.grant_name

360: => ben_cso_shd.g_old_rec.grant_id
361: ,p_grant_number_o
362: => ben_cso_shd.g_old_rec.grant_number
363: ,p_grant_name_o
364: => ben_cso_shd.g_old_rec.grant_name
365: ,p_grant_type_o
366: => ben_cso_shd.g_old_rec.grant_type
367: ,p_grant_date_o
368: => ben_cso_shd.g_old_rec.grant_date

Line 366: => ben_cso_shd.g_old_rec.grant_type

362: => ben_cso_shd.g_old_rec.grant_number
363: ,p_grant_name_o
364: => ben_cso_shd.g_old_rec.grant_name
365: ,p_grant_type_o
366: => ben_cso_shd.g_old_rec.grant_type
367: ,p_grant_date_o
368: => ben_cso_shd.g_old_rec.grant_date
369: ,p_grant_shares_o
370: => ben_cso_shd.g_old_rec.grant_shares

Line 368: => ben_cso_shd.g_old_rec.grant_date

364: => ben_cso_shd.g_old_rec.grant_name
365: ,p_grant_type_o
366: => ben_cso_shd.g_old_rec.grant_type
367: ,p_grant_date_o
368: => ben_cso_shd.g_old_rec.grant_date
369: ,p_grant_shares_o
370: => ben_cso_shd.g_old_rec.grant_shares
371: ,p_grant_price_o
372: => ben_cso_shd.g_old_rec.grant_price

Line 370: => ben_cso_shd.g_old_rec.grant_shares

366: => ben_cso_shd.g_old_rec.grant_type
367: ,p_grant_date_o
368: => ben_cso_shd.g_old_rec.grant_date
369: ,p_grant_shares_o
370: => ben_cso_shd.g_old_rec.grant_shares
371: ,p_grant_price_o
372: => ben_cso_shd.g_old_rec.grant_price
373: ,p_value_at_grant_o
374: => ben_cso_shd.g_old_rec.value_at_grant

Line 372: => ben_cso_shd.g_old_rec.grant_price

368: => ben_cso_shd.g_old_rec.grant_date
369: ,p_grant_shares_o
370: => ben_cso_shd.g_old_rec.grant_shares
371: ,p_grant_price_o
372: => ben_cso_shd.g_old_rec.grant_price
373: ,p_value_at_grant_o
374: => ben_cso_shd.g_old_rec.value_at_grant
375: ,p_current_share_price_o
376: => ben_cso_shd.g_old_rec.current_share_price

Line 374: => ben_cso_shd.g_old_rec.value_at_grant

370: => ben_cso_shd.g_old_rec.grant_shares
371: ,p_grant_price_o
372: => ben_cso_shd.g_old_rec.grant_price
373: ,p_value_at_grant_o
374: => ben_cso_shd.g_old_rec.value_at_grant
375: ,p_current_share_price_o
376: => ben_cso_shd.g_old_rec.current_share_price
377: ,p_current_shares_outstanding_o
378: => ben_cso_shd.g_old_rec.current_shares_outstanding

Line 376: => ben_cso_shd.g_old_rec.current_share_price

372: => ben_cso_shd.g_old_rec.grant_price
373: ,p_value_at_grant_o
374: => ben_cso_shd.g_old_rec.value_at_grant
375: ,p_current_share_price_o
376: => ben_cso_shd.g_old_rec.current_share_price
377: ,p_current_shares_outstanding_o
378: => ben_cso_shd.g_old_rec.current_shares_outstanding
379: ,p_vested_shares_o
380: => ben_cso_shd.g_old_rec.vested_shares

Line 378: => ben_cso_shd.g_old_rec.current_shares_outstanding

374: => ben_cso_shd.g_old_rec.value_at_grant
375: ,p_current_share_price_o
376: => ben_cso_shd.g_old_rec.current_share_price
377: ,p_current_shares_outstanding_o
378: => ben_cso_shd.g_old_rec.current_shares_outstanding
379: ,p_vested_shares_o
380: => ben_cso_shd.g_old_rec.vested_shares
381: ,p_unvested_shares_o
382: => ben_cso_shd.g_old_rec.unvested_shares

Line 380: => ben_cso_shd.g_old_rec.vested_shares

376: => ben_cso_shd.g_old_rec.current_share_price
377: ,p_current_shares_outstanding_o
378: => ben_cso_shd.g_old_rec.current_shares_outstanding
379: ,p_vested_shares_o
380: => ben_cso_shd.g_old_rec.vested_shares
381: ,p_unvested_shares_o
382: => ben_cso_shd.g_old_rec.unvested_shares
383: ,p_exercisable_shares_o
384: => ben_cso_shd.g_old_rec.exercisable_shares

Line 382: => ben_cso_shd.g_old_rec.unvested_shares

378: => ben_cso_shd.g_old_rec.current_shares_outstanding
379: ,p_vested_shares_o
380: => ben_cso_shd.g_old_rec.vested_shares
381: ,p_unvested_shares_o
382: => ben_cso_shd.g_old_rec.unvested_shares
383: ,p_exercisable_shares_o
384: => ben_cso_shd.g_old_rec.exercisable_shares
385: ,p_exercised_shares_o
386: => ben_cso_shd.g_old_rec.exercised_shares

Line 384: => ben_cso_shd.g_old_rec.exercisable_shares

380: => ben_cso_shd.g_old_rec.vested_shares
381: ,p_unvested_shares_o
382: => ben_cso_shd.g_old_rec.unvested_shares
383: ,p_exercisable_shares_o
384: => ben_cso_shd.g_old_rec.exercisable_shares
385: ,p_exercised_shares_o
386: => ben_cso_shd.g_old_rec.exercised_shares
387: ,p_cancelled_shares_o
388: => ben_cso_shd.g_old_rec.cancelled_shares

Line 386: => ben_cso_shd.g_old_rec.exercised_shares

382: => ben_cso_shd.g_old_rec.unvested_shares
383: ,p_exercisable_shares_o
384: => ben_cso_shd.g_old_rec.exercisable_shares
385: ,p_exercised_shares_o
386: => ben_cso_shd.g_old_rec.exercised_shares
387: ,p_cancelled_shares_o
388: => ben_cso_shd.g_old_rec.cancelled_shares
389: ,p_trading_symbol_o
390: => ben_cso_shd.g_old_rec.trading_symbol

Line 388: => ben_cso_shd.g_old_rec.cancelled_shares

384: => ben_cso_shd.g_old_rec.exercisable_shares
385: ,p_exercised_shares_o
386: => ben_cso_shd.g_old_rec.exercised_shares
387: ,p_cancelled_shares_o
388: => ben_cso_shd.g_old_rec.cancelled_shares
389: ,p_trading_symbol_o
390: => ben_cso_shd.g_old_rec.trading_symbol
391: ,p_expiration_date_o
392: => ben_cso_shd.g_old_rec.expiration_date

Line 390: => ben_cso_shd.g_old_rec.trading_symbol

386: => ben_cso_shd.g_old_rec.exercised_shares
387: ,p_cancelled_shares_o
388: => ben_cso_shd.g_old_rec.cancelled_shares
389: ,p_trading_symbol_o
390: => ben_cso_shd.g_old_rec.trading_symbol
391: ,p_expiration_date_o
392: => ben_cso_shd.g_old_rec.expiration_date
393: ,p_reason_code_o
394: => ben_cso_shd.g_old_rec.reason_code

Line 392: => ben_cso_shd.g_old_rec.expiration_date

388: => ben_cso_shd.g_old_rec.cancelled_shares
389: ,p_trading_symbol_o
390: => ben_cso_shd.g_old_rec.trading_symbol
391: ,p_expiration_date_o
392: => ben_cso_shd.g_old_rec.expiration_date
393: ,p_reason_code_o
394: => ben_cso_shd.g_old_rec.reason_code
395: ,p_class_o
396: => ben_cso_shd.g_old_rec.class

Line 394: => ben_cso_shd.g_old_rec.reason_code

390: => ben_cso_shd.g_old_rec.trading_symbol
391: ,p_expiration_date_o
392: => ben_cso_shd.g_old_rec.expiration_date
393: ,p_reason_code_o
394: => ben_cso_shd.g_old_rec.reason_code
395: ,p_class_o
396: => ben_cso_shd.g_old_rec.class
397: ,p_misc_o
398: => ben_cso_shd.g_old_rec.misc

Line 396: => ben_cso_shd.g_old_rec.class

392: => ben_cso_shd.g_old_rec.expiration_date
393: ,p_reason_code_o
394: => ben_cso_shd.g_old_rec.reason_code
395: ,p_class_o
396: => ben_cso_shd.g_old_rec.class
397: ,p_misc_o
398: => ben_cso_shd.g_old_rec.misc
399: ,p_employee_number_o
400: => ben_cso_shd.g_old_rec.employee_number

Line 398: => ben_cso_shd.g_old_rec.misc

394: => ben_cso_shd.g_old_rec.reason_code
395: ,p_class_o
396: => ben_cso_shd.g_old_rec.class
397: ,p_misc_o
398: => ben_cso_shd.g_old_rec.misc
399: ,p_employee_number_o
400: => ben_cso_shd.g_old_rec.employee_number
401: ,p_person_id_o
402: => ben_cso_shd.g_old_rec.person_id

Line 400: => ben_cso_shd.g_old_rec.employee_number

396: => ben_cso_shd.g_old_rec.class
397: ,p_misc_o
398: => ben_cso_shd.g_old_rec.misc
399: ,p_employee_number_o
400: => ben_cso_shd.g_old_rec.employee_number
401: ,p_person_id_o
402: => ben_cso_shd.g_old_rec.person_id
403: ,p_business_group_id_o
404: => ben_cso_shd.g_old_rec.business_group_id

Line 402: => ben_cso_shd.g_old_rec.person_id

398: => ben_cso_shd.g_old_rec.misc
399: ,p_employee_number_o
400: => ben_cso_shd.g_old_rec.employee_number
401: ,p_person_id_o
402: => ben_cso_shd.g_old_rec.person_id
403: ,p_business_group_id_o
404: => ben_cso_shd.g_old_rec.business_group_id
405: ,p_prtt_rt_val_id_o
406: => ben_cso_shd.g_old_rec.prtt_rt_val_id

Line 404: => ben_cso_shd.g_old_rec.business_group_id

400: => ben_cso_shd.g_old_rec.employee_number
401: ,p_person_id_o
402: => ben_cso_shd.g_old_rec.person_id
403: ,p_business_group_id_o
404: => ben_cso_shd.g_old_rec.business_group_id
405: ,p_prtt_rt_val_id_o
406: => ben_cso_shd.g_old_rec.prtt_rt_val_id
407: ,p_object_version_number_o
408: => ben_cso_shd.g_old_rec.object_version_number

Line 406: => ben_cso_shd.g_old_rec.prtt_rt_val_id

402: => ben_cso_shd.g_old_rec.person_id
403: ,p_business_group_id_o
404: => ben_cso_shd.g_old_rec.business_group_id
405: ,p_prtt_rt_val_id_o
406: => ben_cso_shd.g_old_rec.prtt_rt_val_id
407: ,p_object_version_number_o
408: => ben_cso_shd.g_old_rec.object_version_number
409: ,p_cso_attribute_category_o
410: => ben_cso_shd.g_old_rec.cso_attribute_category

Line 408: => ben_cso_shd.g_old_rec.object_version_number

404: => ben_cso_shd.g_old_rec.business_group_id
405: ,p_prtt_rt_val_id_o
406: => ben_cso_shd.g_old_rec.prtt_rt_val_id
407: ,p_object_version_number_o
408: => ben_cso_shd.g_old_rec.object_version_number
409: ,p_cso_attribute_category_o
410: => ben_cso_shd.g_old_rec.cso_attribute_category
411: ,p_cso_attribute1_o
412: => ben_cso_shd.g_old_rec.cso_attribute1

Line 410: => ben_cso_shd.g_old_rec.cso_attribute_category

406: => ben_cso_shd.g_old_rec.prtt_rt_val_id
407: ,p_object_version_number_o
408: => ben_cso_shd.g_old_rec.object_version_number
409: ,p_cso_attribute_category_o
410: => ben_cso_shd.g_old_rec.cso_attribute_category
411: ,p_cso_attribute1_o
412: => ben_cso_shd.g_old_rec.cso_attribute1
413: ,p_cso_attribute2_o
414: => ben_cso_shd.g_old_rec.cso_attribute2

Line 412: => ben_cso_shd.g_old_rec.cso_attribute1

408: => ben_cso_shd.g_old_rec.object_version_number
409: ,p_cso_attribute_category_o
410: => ben_cso_shd.g_old_rec.cso_attribute_category
411: ,p_cso_attribute1_o
412: => ben_cso_shd.g_old_rec.cso_attribute1
413: ,p_cso_attribute2_o
414: => ben_cso_shd.g_old_rec.cso_attribute2
415: ,p_cso_attribute3_o
416: => ben_cso_shd.g_old_rec.cso_attribute3

Line 414: => ben_cso_shd.g_old_rec.cso_attribute2

410: => ben_cso_shd.g_old_rec.cso_attribute_category
411: ,p_cso_attribute1_o
412: => ben_cso_shd.g_old_rec.cso_attribute1
413: ,p_cso_attribute2_o
414: => ben_cso_shd.g_old_rec.cso_attribute2
415: ,p_cso_attribute3_o
416: => ben_cso_shd.g_old_rec.cso_attribute3
417: ,p_cso_attribute4_o
418: => ben_cso_shd.g_old_rec.cso_attribute4

Line 416: => ben_cso_shd.g_old_rec.cso_attribute3

412: => ben_cso_shd.g_old_rec.cso_attribute1
413: ,p_cso_attribute2_o
414: => ben_cso_shd.g_old_rec.cso_attribute2
415: ,p_cso_attribute3_o
416: => ben_cso_shd.g_old_rec.cso_attribute3
417: ,p_cso_attribute4_o
418: => ben_cso_shd.g_old_rec.cso_attribute4
419: ,p_cso_attribute5_o
420: => ben_cso_shd.g_old_rec.cso_attribute5

Line 418: => ben_cso_shd.g_old_rec.cso_attribute4

414: => ben_cso_shd.g_old_rec.cso_attribute2
415: ,p_cso_attribute3_o
416: => ben_cso_shd.g_old_rec.cso_attribute3
417: ,p_cso_attribute4_o
418: => ben_cso_shd.g_old_rec.cso_attribute4
419: ,p_cso_attribute5_o
420: => ben_cso_shd.g_old_rec.cso_attribute5
421: ,p_cso_attribute6_o
422: => ben_cso_shd.g_old_rec.cso_attribute6

Line 420: => ben_cso_shd.g_old_rec.cso_attribute5

416: => ben_cso_shd.g_old_rec.cso_attribute3
417: ,p_cso_attribute4_o
418: => ben_cso_shd.g_old_rec.cso_attribute4
419: ,p_cso_attribute5_o
420: => ben_cso_shd.g_old_rec.cso_attribute5
421: ,p_cso_attribute6_o
422: => ben_cso_shd.g_old_rec.cso_attribute6
423: ,p_cso_attribute7_o
424: => ben_cso_shd.g_old_rec.cso_attribute7

Line 422: => ben_cso_shd.g_old_rec.cso_attribute6

418: => ben_cso_shd.g_old_rec.cso_attribute4
419: ,p_cso_attribute5_o
420: => ben_cso_shd.g_old_rec.cso_attribute5
421: ,p_cso_attribute6_o
422: => ben_cso_shd.g_old_rec.cso_attribute6
423: ,p_cso_attribute7_o
424: => ben_cso_shd.g_old_rec.cso_attribute7
425: ,p_cso_attribute8_o
426: => ben_cso_shd.g_old_rec.cso_attribute8

Line 424: => ben_cso_shd.g_old_rec.cso_attribute7

420: => ben_cso_shd.g_old_rec.cso_attribute5
421: ,p_cso_attribute6_o
422: => ben_cso_shd.g_old_rec.cso_attribute6
423: ,p_cso_attribute7_o
424: => ben_cso_shd.g_old_rec.cso_attribute7
425: ,p_cso_attribute8_o
426: => ben_cso_shd.g_old_rec.cso_attribute8
427: ,p_cso_attribute9_o
428: => ben_cso_shd.g_old_rec.cso_attribute9

Line 426: => ben_cso_shd.g_old_rec.cso_attribute8

422: => ben_cso_shd.g_old_rec.cso_attribute6
423: ,p_cso_attribute7_o
424: => ben_cso_shd.g_old_rec.cso_attribute7
425: ,p_cso_attribute8_o
426: => ben_cso_shd.g_old_rec.cso_attribute8
427: ,p_cso_attribute9_o
428: => ben_cso_shd.g_old_rec.cso_attribute9
429: ,p_cso_attribute10_o
430: => ben_cso_shd.g_old_rec.cso_attribute10

Line 428: => ben_cso_shd.g_old_rec.cso_attribute9

424: => ben_cso_shd.g_old_rec.cso_attribute7
425: ,p_cso_attribute8_o
426: => ben_cso_shd.g_old_rec.cso_attribute8
427: ,p_cso_attribute9_o
428: => ben_cso_shd.g_old_rec.cso_attribute9
429: ,p_cso_attribute10_o
430: => ben_cso_shd.g_old_rec.cso_attribute10
431: ,p_cso_attribute11_o
432: => ben_cso_shd.g_old_rec.cso_attribute11

Line 430: => ben_cso_shd.g_old_rec.cso_attribute10

426: => ben_cso_shd.g_old_rec.cso_attribute8
427: ,p_cso_attribute9_o
428: => ben_cso_shd.g_old_rec.cso_attribute9
429: ,p_cso_attribute10_o
430: => ben_cso_shd.g_old_rec.cso_attribute10
431: ,p_cso_attribute11_o
432: => ben_cso_shd.g_old_rec.cso_attribute11
433: ,p_cso_attribute12_o
434: => ben_cso_shd.g_old_rec.cso_attribute12

Line 432: => ben_cso_shd.g_old_rec.cso_attribute11

428: => ben_cso_shd.g_old_rec.cso_attribute9
429: ,p_cso_attribute10_o
430: => ben_cso_shd.g_old_rec.cso_attribute10
431: ,p_cso_attribute11_o
432: => ben_cso_shd.g_old_rec.cso_attribute11
433: ,p_cso_attribute12_o
434: => ben_cso_shd.g_old_rec.cso_attribute12
435: ,p_cso_attribute13_o
436: => ben_cso_shd.g_old_rec.cso_attribute13

Line 434: => ben_cso_shd.g_old_rec.cso_attribute12

430: => ben_cso_shd.g_old_rec.cso_attribute10
431: ,p_cso_attribute11_o
432: => ben_cso_shd.g_old_rec.cso_attribute11
433: ,p_cso_attribute12_o
434: => ben_cso_shd.g_old_rec.cso_attribute12
435: ,p_cso_attribute13_o
436: => ben_cso_shd.g_old_rec.cso_attribute13
437: ,p_cso_attribute14_o
438: => ben_cso_shd.g_old_rec.cso_attribute14

Line 436: => ben_cso_shd.g_old_rec.cso_attribute13

432: => ben_cso_shd.g_old_rec.cso_attribute11
433: ,p_cso_attribute12_o
434: => ben_cso_shd.g_old_rec.cso_attribute12
435: ,p_cso_attribute13_o
436: => ben_cso_shd.g_old_rec.cso_attribute13
437: ,p_cso_attribute14_o
438: => ben_cso_shd.g_old_rec.cso_attribute14
439: ,p_cso_attribute15_o
440: => ben_cso_shd.g_old_rec.cso_attribute15

Line 438: => ben_cso_shd.g_old_rec.cso_attribute14

434: => ben_cso_shd.g_old_rec.cso_attribute12
435: ,p_cso_attribute13_o
436: => ben_cso_shd.g_old_rec.cso_attribute13
437: ,p_cso_attribute14_o
438: => ben_cso_shd.g_old_rec.cso_attribute14
439: ,p_cso_attribute15_o
440: => ben_cso_shd.g_old_rec.cso_attribute15
441: ,p_cso_attribute16_o
442: => ben_cso_shd.g_old_rec.cso_attribute16

Line 440: => ben_cso_shd.g_old_rec.cso_attribute15

436: => ben_cso_shd.g_old_rec.cso_attribute13
437: ,p_cso_attribute14_o
438: => ben_cso_shd.g_old_rec.cso_attribute14
439: ,p_cso_attribute15_o
440: => ben_cso_shd.g_old_rec.cso_attribute15
441: ,p_cso_attribute16_o
442: => ben_cso_shd.g_old_rec.cso_attribute16
443: ,p_cso_attribute17_o
444: => ben_cso_shd.g_old_rec.cso_attribute17

Line 442: => ben_cso_shd.g_old_rec.cso_attribute16

438: => ben_cso_shd.g_old_rec.cso_attribute14
439: ,p_cso_attribute15_o
440: => ben_cso_shd.g_old_rec.cso_attribute15
441: ,p_cso_attribute16_o
442: => ben_cso_shd.g_old_rec.cso_attribute16
443: ,p_cso_attribute17_o
444: => ben_cso_shd.g_old_rec.cso_attribute17
445: ,p_cso_attribute18_o
446: => ben_cso_shd.g_old_rec.cso_attribute18

Line 444: => ben_cso_shd.g_old_rec.cso_attribute17

440: => ben_cso_shd.g_old_rec.cso_attribute15
441: ,p_cso_attribute16_o
442: => ben_cso_shd.g_old_rec.cso_attribute16
443: ,p_cso_attribute17_o
444: => ben_cso_shd.g_old_rec.cso_attribute17
445: ,p_cso_attribute18_o
446: => ben_cso_shd.g_old_rec.cso_attribute18
447: ,p_cso_attribute19_o
448: => ben_cso_shd.g_old_rec.cso_attribute19

Line 446: => ben_cso_shd.g_old_rec.cso_attribute18

442: => ben_cso_shd.g_old_rec.cso_attribute16
443: ,p_cso_attribute17_o
444: => ben_cso_shd.g_old_rec.cso_attribute17
445: ,p_cso_attribute18_o
446: => ben_cso_shd.g_old_rec.cso_attribute18
447: ,p_cso_attribute19_o
448: => ben_cso_shd.g_old_rec.cso_attribute19
449: ,p_cso_attribute20_o
450: => ben_cso_shd.g_old_rec.cso_attribute20

Line 448: => ben_cso_shd.g_old_rec.cso_attribute19

444: => ben_cso_shd.g_old_rec.cso_attribute17
445: ,p_cso_attribute18_o
446: => ben_cso_shd.g_old_rec.cso_attribute18
447: ,p_cso_attribute19_o
448: => ben_cso_shd.g_old_rec.cso_attribute19
449: ,p_cso_attribute20_o
450: => ben_cso_shd.g_old_rec.cso_attribute20
451: ,p_cso_attribute21_o
452: => ben_cso_shd.g_old_rec.cso_attribute21

Line 450: => ben_cso_shd.g_old_rec.cso_attribute20

446: => ben_cso_shd.g_old_rec.cso_attribute18
447: ,p_cso_attribute19_o
448: => ben_cso_shd.g_old_rec.cso_attribute19
449: ,p_cso_attribute20_o
450: => ben_cso_shd.g_old_rec.cso_attribute20
451: ,p_cso_attribute21_o
452: => ben_cso_shd.g_old_rec.cso_attribute21
453: ,p_cso_attribute22_o
454: => ben_cso_shd.g_old_rec.cso_attribute22

Line 452: => ben_cso_shd.g_old_rec.cso_attribute21

448: => ben_cso_shd.g_old_rec.cso_attribute19
449: ,p_cso_attribute20_o
450: => ben_cso_shd.g_old_rec.cso_attribute20
451: ,p_cso_attribute21_o
452: => ben_cso_shd.g_old_rec.cso_attribute21
453: ,p_cso_attribute22_o
454: => ben_cso_shd.g_old_rec.cso_attribute22
455: ,p_cso_attribute23_o
456: => ben_cso_shd.g_old_rec.cso_attribute23

Line 454: => ben_cso_shd.g_old_rec.cso_attribute22

450: => ben_cso_shd.g_old_rec.cso_attribute20
451: ,p_cso_attribute21_o
452: => ben_cso_shd.g_old_rec.cso_attribute21
453: ,p_cso_attribute22_o
454: => ben_cso_shd.g_old_rec.cso_attribute22
455: ,p_cso_attribute23_o
456: => ben_cso_shd.g_old_rec.cso_attribute23
457: ,p_cso_attribute24_o
458: => ben_cso_shd.g_old_rec.cso_attribute24

Line 456: => ben_cso_shd.g_old_rec.cso_attribute23

452: => ben_cso_shd.g_old_rec.cso_attribute21
453: ,p_cso_attribute22_o
454: => ben_cso_shd.g_old_rec.cso_attribute22
455: ,p_cso_attribute23_o
456: => ben_cso_shd.g_old_rec.cso_attribute23
457: ,p_cso_attribute24_o
458: => ben_cso_shd.g_old_rec.cso_attribute24
459: ,p_cso_attribute25_o
460: => ben_cso_shd.g_old_rec.cso_attribute25

Line 458: => ben_cso_shd.g_old_rec.cso_attribute24

454: => ben_cso_shd.g_old_rec.cso_attribute22
455: ,p_cso_attribute23_o
456: => ben_cso_shd.g_old_rec.cso_attribute23
457: ,p_cso_attribute24_o
458: => ben_cso_shd.g_old_rec.cso_attribute24
459: ,p_cso_attribute25_o
460: => ben_cso_shd.g_old_rec.cso_attribute25
461: ,p_cso_attribute26_o
462: => ben_cso_shd.g_old_rec.cso_attribute26

Line 460: => ben_cso_shd.g_old_rec.cso_attribute25

456: => ben_cso_shd.g_old_rec.cso_attribute23
457: ,p_cso_attribute24_o
458: => ben_cso_shd.g_old_rec.cso_attribute24
459: ,p_cso_attribute25_o
460: => ben_cso_shd.g_old_rec.cso_attribute25
461: ,p_cso_attribute26_o
462: => ben_cso_shd.g_old_rec.cso_attribute26
463: ,p_cso_attribute27_o
464: => ben_cso_shd.g_old_rec.cso_attribute27

Line 462: => ben_cso_shd.g_old_rec.cso_attribute26

458: => ben_cso_shd.g_old_rec.cso_attribute24
459: ,p_cso_attribute25_o
460: => ben_cso_shd.g_old_rec.cso_attribute25
461: ,p_cso_attribute26_o
462: => ben_cso_shd.g_old_rec.cso_attribute26
463: ,p_cso_attribute27_o
464: => ben_cso_shd.g_old_rec.cso_attribute27
465: ,p_cso_attribute28_o
466: => ben_cso_shd.g_old_rec.cso_attribute28

Line 464: => ben_cso_shd.g_old_rec.cso_attribute27

460: => ben_cso_shd.g_old_rec.cso_attribute25
461: ,p_cso_attribute26_o
462: => ben_cso_shd.g_old_rec.cso_attribute26
463: ,p_cso_attribute27_o
464: => ben_cso_shd.g_old_rec.cso_attribute27
465: ,p_cso_attribute28_o
466: => ben_cso_shd.g_old_rec.cso_attribute28
467: ,p_cso_attribute29_o
468: => ben_cso_shd.g_old_rec.cso_attribute29

Line 466: => ben_cso_shd.g_old_rec.cso_attribute28

462: => ben_cso_shd.g_old_rec.cso_attribute26
463: ,p_cso_attribute27_o
464: => ben_cso_shd.g_old_rec.cso_attribute27
465: ,p_cso_attribute28_o
466: => ben_cso_shd.g_old_rec.cso_attribute28
467: ,p_cso_attribute29_o
468: => ben_cso_shd.g_old_rec.cso_attribute29
469: ,p_cso_attribute30_o
470: => ben_cso_shd.g_old_rec.cso_attribute30

Line 468: => ben_cso_shd.g_old_rec.cso_attribute29

464: => ben_cso_shd.g_old_rec.cso_attribute27
465: ,p_cso_attribute28_o
466: => ben_cso_shd.g_old_rec.cso_attribute28
467: ,p_cso_attribute29_o
468: => ben_cso_shd.g_old_rec.cso_attribute29
469: ,p_cso_attribute30_o
470: => ben_cso_shd.g_old_rec.cso_attribute30
471: );
472: --

Line 470: => ben_cso_shd.g_old_rec.cso_attribute30

466: => ben_cso_shd.g_old_rec.cso_attribute28
467: ,p_cso_attribute29_o
468: => ben_cso_shd.g_old_rec.cso_attribute29
469: ,p_cso_attribute30_o
470: => ben_cso_shd.g_old_rec.cso_attribute30
471: );
472: --
473: exception
474: --

Line 530: (p_rec in out nocopy ben_cso_shd.g_rec_type

526: --
527: -- {End Of Comments}
528: -- ----------------------------------------------------------------------------
529: Procedure convert_defs
530: (p_rec in out nocopy ben_cso_shd.g_rec_type
531: ) is
532: --
533: Begin
534: --

Line 542: ben_cso_shd.g_old_rec.grant_id;

538: -- is being used then we must set to the 'current' argument value.
539: --
540: If (p_rec.grant_id = hr_api.g_number) then
541: p_rec.grant_id :=
542: ben_cso_shd.g_old_rec.grant_id;
543: End If;
544: If (p_rec.grant_number = hr_api.g_varchar2) then
545: p_rec.grant_number :=
546: ben_cso_shd.g_old_rec.grant_number;

Line 546: ben_cso_shd.g_old_rec.grant_number;

542: ben_cso_shd.g_old_rec.grant_id;
543: End If;
544: If (p_rec.grant_number = hr_api.g_varchar2) then
545: p_rec.grant_number :=
546: ben_cso_shd.g_old_rec.grant_number;
547: End If;
548: If (p_rec.grant_name = hr_api.g_varchar2) then
549: p_rec.grant_name :=
550: ben_cso_shd.g_old_rec.grant_name;

Line 550: ben_cso_shd.g_old_rec.grant_name;

546: ben_cso_shd.g_old_rec.grant_number;
547: End If;
548: If (p_rec.grant_name = hr_api.g_varchar2) then
549: p_rec.grant_name :=
550: ben_cso_shd.g_old_rec.grant_name;
551: End If;
552: If (p_rec.grant_type = hr_api.g_varchar2) then
553: p_rec.grant_type :=
554: ben_cso_shd.g_old_rec.grant_type;

Line 554: ben_cso_shd.g_old_rec.grant_type;

550: ben_cso_shd.g_old_rec.grant_name;
551: End If;
552: If (p_rec.grant_type = hr_api.g_varchar2) then
553: p_rec.grant_type :=
554: ben_cso_shd.g_old_rec.grant_type;
555: End If;
556: If (p_rec.grant_date = hr_api.g_date) then
557: p_rec.grant_date :=
558: ben_cso_shd.g_old_rec.grant_date;

Line 558: ben_cso_shd.g_old_rec.grant_date;

554: ben_cso_shd.g_old_rec.grant_type;
555: End If;
556: If (p_rec.grant_date = hr_api.g_date) then
557: p_rec.grant_date :=
558: ben_cso_shd.g_old_rec.grant_date;
559: End If;
560: If (p_rec.grant_shares = hr_api.g_number) then
561: p_rec.grant_shares :=
562: ben_cso_shd.g_old_rec.grant_shares;

Line 562: ben_cso_shd.g_old_rec.grant_shares;

558: ben_cso_shd.g_old_rec.grant_date;
559: End If;
560: If (p_rec.grant_shares = hr_api.g_number) then
561: p_rec.grant_shares :=
562: ben_cso_shd.g_old_rec.grant_shares;
563: End If;
564: If (p_rec.grant_price = hr_api.g_number) then
565: p_rec.grant_price :=
566: ben_cso_shd.g_old_rec.grant_price;

Line 566: ben_cso_shd.g_old_rec.grant_price;

562: ben_cso_shd.g_old_rec.grant_shares;
563: End If;
564: If (p_rec.grant_price = hr_api.g_number) then
565: p_rec.grant_price :=
566: ben_cso_shd.g_old_rec.grant_price;
567: End If;
568: If (p_rec.value_at_grant = hr_api.g_number) then
569: p_rec.value_at_grant :=
570: ben_cso_shd.g_old_rec.value_at_grant;

Line 570: ben_cso_shd.g_old_rec.value_at_grant;

566: ben_cso_shd.g_old_rec.grant_price;
567: End If;
568: If (p_rec.value_at_grant = hr_api.g_number) then
569: p_rec.value_at_grant :=
570: ben_cso_shd.g_old_rec.value_at_grant;
571: End If;
572: If (p_rec.current_share_price = hr_api.g_number) then
573: p_rec.current_share_price :=
574: ben_cso_shd.g_old_rec.current_share_price;

Line 574: ben_cso_shd.g_old_rec.current_share_price;

570: ben_cso_shd.g_old_rec.value_at_grant;
571: End If;
572: If (p_rec.current_share_price = hr_api.g_number) then
573: p_rec.current_share_price :=
574: ben_cso_shd.g_old_rec.current_share_price;
575: End If;
576: If (p_rec.current_shares_outstanding = hr_api.g_number) then
577: p_rec.current_shares_outstanding :=
578: ben_cso_shd.g_old_rec.current_shares_outstanding;

Line 578: ben_cso_shd.g_old_rec.current_shares_outstanding;

574: ben_cso_shd.g_old_rec.current_share_price;
575: End If;
576: If (p_rec.current_shares_outstanding = hr_api.g_number) then
577: p_rec.current_shares_outstanding :=
578: ben_cso_shd.g_old_rec.current_shares_outstanding;
579: End If;
580: If (p_rec.vested_shares = hr_api.g_number) then
581: p_rec.vested_shares :=
582: ben_cso_shd.g_old_rec.vested_shares;

Line 582: ben_cso_shd.g_old_rec.vested_shares;

578: ben_cso_shd.g_old_rec.current_shares_outstanding;
579: End If;
580: If (p_rec.vested_shares = hr_api.g_number) then
581: p_rec.vested_shares :=
582: ben_cso_shd.g_old_rec.vested_shares;
583: End If;
584: If (p_rec.unvested_shares = hr_api.g_number) then
585: p_rec.unvested_shares :=
586: ben_cso_shd.g_old_rec.unvested_shares;

Line 586: ben_cso_shd.g_old_rec.unvested_shares;

582: ben_cso_shd.g_old_rec.vested_shares;
583: End If;
584: If (p_rec.unvested_shares = hr_api.g_number) then
585: p_rec.unvested_shares :=
586: ben_cso_shd.g_old_rec.unvested_shares;
587: End If;
588: If (p_rec.exercisable_shares = hr_api.g_number) then
589: p_rec.exercisable_shares :=
590: ben_cso_shd.g_old_rec.exercisable_shares;

Line 590: ben_cso_shd.g_old_rec.exercisable_shares;

586: ben_cso_shd.g_old_rec.unvested_shares;
587: End If;
588: If (p_rec.exercisable_shares = hr_api.g_number) then
589: p_rec.exercisable_shares :=
590: ben_cso_shd.g_old_rec.exercisable_shares;
591: End If;
592: If (p_rec.exercised_shares = hr_api.g_number) then
593: p_rec.exercised_shares :=
594: ben_cso_shd.g_old_rec.exercised_shares;

Line 594: ben_cso_shd.g_old_rec.exercised_shares;

590: ben_cso_shd.g_old_rec.exercisable_shares;
591: End If;
592: If (p_rec.exercised_shares = hr_api.g_number) then
593: p_rec.exercised_shares :=
594: ben_cso_shd.g_old_rec.exercised_shares;
595: End If;
596: If (p_rec.cancelled_shares = hr_api.g_number) then
597: p_rec.cancelled_shares :=
598: ben_cso_shd.g_old_rec.cancelled_shares;

Line 598: ben_cso_shd.g_old_rec.cancelled_shares;

594: ben_cso_shd.g_old_rec.exercised_shares;
595: End If;
596: If (p_rec.cancelled_shares = hr_api.g_number) then
597: p_rec.cancelled_shares :=
598: ben_cso_shd.g_old_rec.cancelled_shares;
599: End If;
600: If (p_rec.trading_symbol = hr_api.g_varchar2) then
601: p_rec.trading_symbol :=
602: ben_cso_shd.g_old_rec.trading_symbol;

Line 602: ben_cso_shd.g_old_rec.trading_symbol;

598: ben_cso_shd.g_old_rec.cancelled_shares;
599: End If;
600: If (p_rec.trading_symbol = hr_api.g_varchar2) then
601: p_rec.trading_symbol :=
602: ben_cso_shd.g_old_rec.trading_symbol;
603: End If;
604: If (p_rec.expiration_date = hr_api.g_date) then
605: p_rec.expiration_date :=
606: ben_cso_shd.g_old_rec.expiration_date;

Line 606: ben_cso_shd.g_old_rec.expiration_date;

602: ben_cso_shd.g_old_rec.trading_symbol;
603: End If;
604: If (p_rec.expiration_date = hr_api.g_date) then
605: p_rec.expiration_date :=
606: ben_cso_shd.g_old_rec.expiration_date;
607: End If;
608: If (p_rec.reason_code = hr_api.g_varchar2) then
609: p_rec.reason_code :=
610: ben_cso_shd.g_old_rec.reason_code;

Line 610: ben_cso_shd.g_old_rec.reason_code;

606: ben_cso_shd.g_old_rec.expiration_date;
607: End If;
608: If (p_rec.reason_code = hr_api.g_varchar2) then
609: p_rec.reason_code :=
610: ben_cso_shd.g_old_rec.reason_code;
611: End If;
612: If (p_rec.class = hr_api.g_varchar2) then
613: p_rec.class :=
614: ben_cso_shd.g_old_rec.class;

Line 614: ben_cso_shd.g_old_rec.class;

610: ben_cso_shd.g_old_rec.reason_code;
611: End If;
612: If (p_rec.class = hr_api.g_varchar2) then
613: p_rec.class :=
614: ben_cso_shd.g_old_rec.class;
615: End If;
616: If (p_rec.misc = hr_api.g_varchar2) then
617: p_rec.misc :=
618: ben_cso_shd.g_old_rec.misc;

Line 618: ben_cso_shd.g_old_rec.misc;

614: ben_cso_shd.g_old_rec.class;
615: End If;
616: If (p_rec.misc = hr_api.g_varchar2) then
617: p_rec.misc :=
618: ben_cso_shd.g_old_rec.misc;
619: End If;
620: If (p_rec.employee_number = hr_api.g_varchar2) then
621: p_rec.employee_number :=
622: ben_cso_shd.g_old_rec.employee_number;

Line 622: ben_cso_shd.g_old_rec.employee_number;

618: ben_cso_shd.g_old_rec.misc;
619: End If;
620: If (p_rec.employee_number = hr_api.g_varchar2) then
621: p_rec.employee_number :=
622: ben_cso_shd.g_old_rec.employee_number;
623: End If;
624: If (p_rec.person_id = hr_api.g_number) then
625: p_rec.person_id :=
626: ben_cso_shd.g_old_rec.person_id;

Line 626: ben_cso_shd.g_old_rec.person_id;

622: ben_cso_shd.g_old_rec.employee_number;
623: End If;
624: If (p_rec.person_id = hr_api.g_number) then
625: p_rec.person_id :=
626: ben_cso_shd.g_old_rec.person_id;
627: End If;
628: If (p_rec.business_group_id = hr_api.g_number) then
629: p_rec.business_group_id :=
630: ben_cso_shd.g_old_rec.business_group_id;

Line 630: ben_cso_shd.g_old_rec.business_group_id;

626: ben_cso_shd.g_old_rec.person_id;
627: End If;
628: If (p_rec.business_group_id = hr_api.g_number) then
629: p_rec.business_group_id :=
630: ben_cso_shd.g_old_rec.business_group_id;
631: End If;
632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
633: p_rec.prtt_rt_val_id :=
634: ben_cso_shd.g_old_rec.prtt_rt_val_id;

Line 634: ben_cso_shd.g_old_rec.prtt_rt_val_id;

630: ben_cso_shd.g_old_rec.business_group_id;
631: End If;
632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
633: p_rec.prtt_rt_val_id :=
634: ben_cso_shd.g_old_rec.prtt_rt_val_id;
635: End If;
636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then
637: p_rec.cso_attribute_category :=
638: ben_cso_shd.g_old_rec.cso_attribute_category;

Line 638: ben_cso_shd.g_old_rec.cso_attribute_category;

634: ben_cso_shd.g_old_rec.prtt_rt_val_id;
635: End If;
636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then
637: p_rec.cso_attribute_category :=
638: ben_cso_shd.g_old_rec.cso_attribute_category;
639: End If;
640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then
641: p_rec.cso_attribute1 :=
642: ben_cso_shd.g_old_rec.cso_attribute1;

Line 642: ben_cso_shd.g_old_rec.cso_attribute1;

638: ben_cso_shd.g_old_rec.cso_attribute_category;
639: End If;
640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then
641: p_rec.cso_attribute1 :=
642: ben_cso_shd.g_old_rec.cso_attribute1;
643: End If;
644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then
645: p_rec.cso_attribute2 :=
646: ben_cso_shd.g_old_rec.cso_attribute2;

Line 646: ben_cso_shd.g_old_rec.cso_attribute2;

642: ben_cso_shd.g_old_rec.cso_attribute1;
643: End If;
644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then
645: p_rec.cso_attribute2 :=
646: ben_cso_shd.g_old_rec.cso_attribute2;
647: End If;
648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then
649: p_rec.cso_attribute3 :=
650: ben_cso_shd.g_old_rec.cso_attribute3;

Line 650: ben_cso_shd.g_old_rec.cso_attribute3;

646: ben_cso_shd.g_old_rec.cso_attribute2;
647: End If;
648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then
649: p_rec.cso_attribute3 :=
650: ben_cso_shd.g_old_rec.cso_attribute3;
651: End If;
652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then
653: p_rec.cso_attribute4 :=
654: ben_cso_shd.g_old_rec.cso_attribute4;

Line 654: ben_cso_shd.g_old_rec.cso_attribute4;

650: ben_cso_shd.g_old_rec.cso_attribute3;
651: End If;
652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then
653: p_rec.cso_attribute4 :=
654: ben_cso_shd.g_old_rec.cso_attribute4;
655: End If;
656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then
657: p_rec.cso_attribute5 :=
658: ben_cso_shd.g_old_rec.cso_attribute5;

Line 658: ben_cso_shd.g_old_rec.cso_attribute5;

654: ben_cso_shd.g_old_rec.cso_attribute4;
655: End If;
656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then
657: p_rec.cso_attribute5 :=
658: ben_cso_shd.g_old_rec.cso_attribute5;
659: End If;
660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then
661: p_rec.cso_attribute6 :=
662: ben_cso_shd.g_old_rec.cso_attribute6;

Line 662: ben_cso_shd.g_old_rec.cso_attribute6;

658: ben_cso_shd.g_old_rec.cso_attribute5;
659: End If;
660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then
661: p_rec.cso_attribute6 :=
662: ben_cso_shd.g_old_rec.cso_attribute6;
663: End If;
664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then
665: p_rec.cso_attribute7 :=
666: ben_cso_shd.g_old_rec.cso_attribute7;

Line 666: ben_cso_shd.g_old_rec.cso_attribute7;

662: ben_cso_shd.g_old_rec.cso_attribute6;
663: End If;
664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then
665: p_rec.cso_attribute7 :=
666: ben_cso_shd.g_old_rec.cso_attribute7;
667: End If;
668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then
669: p_rec.cso_attribute8 :=
670: ben_cso_shd.g_old_rec.cso_attribute8;

Line 670: ben_cso_shd.g_old_rec.cso_attribute8;

666: ben_cso_shd.g_old_rec.cso_attribute7;
667: End If;
668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then
669: p_rec.cso_attribute8 :=
670: ben_cso_shd.g_old_rec.cso_attribute8;
671: End If;
672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then
673: p_rec.cso_attribute9 :=
674: ben_cso_shd.g_old_rec.cso_attribute9;

Line 674: ben_cso_shd.g_old_rec.cso_attribute9;

670: ben_cso_shd.g_old_rec.cso_attribute8;
671: End If;
672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then
673: p_rec.cso_attribute9 :=
674: ben_cso_shd.g_old_rec.cso_attribute9;
675: End If;
676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then
677: p_rec.cso_attribute10 :=
678: ben_cso_shd.g_old_rec.cso_attribute10;

Line 678: ben_cso_shd.g_old_rec.cso_attribute10;

674: ben_cso_shd.g_old_rec.cso_attribute9;
675: End If;
676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then
677: p_rec.cso_attribute10 :=
678: ben_cso_shd.g_old_rec.cso_attribute10;
679: End If;
680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then
681: p_rec.cso_attribute11 :=
682: ben_cso_shd.g_old_rec.cso_attribute11;

Line 682: ben_cso_shd.g_old_rec.cso_attribute11;

678: ben_cso_shd.g_old_rec.cso_attribute10;
679: End If;
680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then
681: p_rec.cso_attribute11 :=
682: ben_cso_shd.g_old_rec.cso_attribute11;
683: End If;
684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then
685: p_rec.cso_attribute12 :=
686: ben_cso_shd.g_old_rec.cso_attribute12;

Line 686: ben_cso_shd.g_old_rec.cso_attribute12;

682: ben_cso_shd.g_old_rec.cso_attribute11;
683: End If;
684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then
685: p_rec.cso_attribute12 :=
686: ben_cso_shd.g_old_rec.cso_attribute12;
687: End If;
688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then
689: p_rec.cso_attribute13 :=
690: ben_cso_shd.g_old_rec.cso_attribute13;

Line 690: ben_cso_shd.g_old_rec.cso_attribute13;

686: ben_cso_shd.g_old_rec.cso_attribute12;
687: End If;
688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then
689: p_rec.cso_attribute13 :=
690: ben_cso_shd.g_old_rec.cso_attribute13;
691: End If;
692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then
693: p_rec.cso_attribute14 :=
694: ben_cso_shd.g_old_rec.cso_attribute14;

Line 694: ben_cso_shd.g_old_rec.cso_attribute14;

690: ben_cso_shd.g_old_rec.cso_attribute13;
691: End If;
692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then
693: p_rec.cso_attribute14 :=
694: ben_cso_shd.g_old_rec.cso_attribute14;
695: End If;
696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then
697: p_rec.cso_attribute15 :=
698: ben_cso_shd.g_old_rec.cso_attribute15;

Line 698: ben_cso_shd.g_old_rec.cso_attribute15;

694: ben_cso_shd.g_old_rec.cso_attribute14;
695: End If;
696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then
697: p_rec.cso_attribute15 :=
698: ben_cso_shd.g_old_rec.cso_attribute15;
699: End If;
700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then
701: p_rec.cso_attribute16 :=
702: ben_cso_shd.g_old_rec.cso_attribute16;

Line 702: ben_cso_shd.g_old_rec.cso_attribute16;

698: ben_cso_shd.g_old_rec.cso_attribute15;
699: End If;
700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then
701: p_rec.cso_attribute16 :=
702: ben_cso_shd.g_old_rec.cso_attribute16;
703: End If;
704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then
705: p_rec.cso_attribute17 :=
706: ben_cso_shd.g_old_rec.cso_attribute17;

Line 706: ben_cso_shd.g_old_rec.cso_attribute17;

702: ben_cso_shd.g_old_rec.cso_attribute16;
703: End If;
704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then
705: p_rec.cso_attribute17 :=
706: ben_cso_shd.g_old_rec.cso_attribute17;
707: End If;
708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then
709: p_rec.cso_attribute18 :=
710: ben_cso_shd.g_old_rec.cso_attribute18;

Line 710: ben_cso_shd.g_old_rec.cso_attribute18;

706: ben_cso_shd.g_old_rec.cso_attribute17;
707: End If;
708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then
709: p_rec.cso_attribute18 :=
710: ben_cso_shd.g_old_rec.cso_attribute18;
711: End If;
712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then
713: p_rec.cso_attribute19 :=
714: ben_cso_shd.g_old_rec.cso_attribute19;

Line 714: ben_cso_shd.g_old_rec.cso_attribute19;

710: ben_cso_shd.g_old_rec.cso_attribute18;
711: End If;
712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then
713: p_rec.cso_attribute19 :=
714: ben_cso_shd.g_old_rec.cso_attribute19;
715: End If;
716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then
717: p_rec.cso_attribute20 :=
718: ben_cso_shd.g_old_rec.cso_attribute20;

Line 718: ben_cso_shd.g_old_rec.cso_attribute20;

714: ben_cso_shd.g_old_rec.cso_attribute19;
715: End If;
716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then
717: p_rec.cso_attribute20 :=
718: ben_cso_shd.g_old_rec.cso_attribute20;
719: End If;
720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then
721: p_rec.cso_attribute21 :=
722: ben_cso_shd.g_old_rec.cso_attribute21;

Line 722: ben_cso_shd.g_old_rec.cso_attribute21;

718: ben_cso_shd.g_old_rec.cso_attribute20;
719: End If;
720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then
721: p_rec.cso_attribute21 :=
722: ben_cso_shd.g_old_rec.cso_attribute21;
723: End If;
724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then
725: p_rec.cso_attribute22 :=
726: ben_cso_shd.g_old_rec.cso_attribute22;

Line 726: ben_cso_shd.g_old_rec.cso_attribute22;

722: ben_cso_shd.g_old_rec.cso_attribute21;
723: End If;
724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then
725: p_rec.cso_attribute22 :=
726: ben_cso_shd.g_old_rec.cso_attribute22;
727: End If;
728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then
729: p_rec.cso_attribute23 :=
730: ben_cso_shd.g_old_rec.cso_attribute23;

Line 730: ben_cso_shd.g_old_rec.cso_attribute23;

726: ben_cso_shd.g_old_rec.cso_attribute22;
727: End If;
728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then
729: p_rec.cso_attribute23 :=
730: ben_cso_shd.g_old_rec.cso_attribute23;
731: End If;
732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then
733: p_rec.cso_attribute24 :=
734: ben_cso_shd.g_old_rec.cso_attribute24;

Line 734: ben_cso_shd.g_old_rec.cso_attribute24;

730: ben_cso_shd.g_old_rec.cso_attribute23;
731: End If;
732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then
733: p_rec.cso_attribute24 :=
734: ben_cso_shd.g_old_rec.cso_attribute24;
735: End If;
736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then
737: p_rec.cso_attribute25 :=
738: ben_cso_shd.g_old_rec.cso_attribute25;

Line 738: ben_cso_shd.g_old_rec.cso_attribute25;

734: ben_cso_shd.g_old_rec.cso_attribute24;
735: End If;
736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then
737: p_rec.cso_attribute25 :=
738: ben_cso_shd.g_old_rec.cso_attribute25;
739: End If;
740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then
741: p_rec.cso_attribute26 :=
742: ben_cso_shd.g_old_rec.cso_attribute26;

Line 742: ben_cso_shd.g_old_rec.cso_attribute26;

738: ben_cso_shd.g_old_rec.cso_attribute25;
739: End If;
740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then
741: p_rec.cso_attribute26 :=
742: ben_cso_shd.g_old_rec.cso_attribute26;
743: End If;
744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then
745: p_rec.cso_attribute27 :=
746: ben_cso_shd.g_old_rec.cso_attribute27;

Line 746: ben_cso_shd.g_old_rec.cso_attribute27;

742: ben_cso_shd.g_old_rec.cso_attribute26;
743: End If;
744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then
745: p_rec.cso_attribute27 :=
746: ben_cso_shd.g_old_rec.cso_attribute27;
747: End If;
748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then
749: p_rec.cso_attribute28 :=
750: ben_cso_shd.g_old_rec.cso_attribute28;

Line 750: ben_cso_shd.g_old_rec.cso_attribute28;

746: ben_cso_shd.g_old_rec.cso_attribute27;
747: End If;
748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then
749: p_rec.cso_attribute28 :=
750: ben_cso_shd.g_old_rec.cso_attribute28;
751: End If;
752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then
753: p_rec.cso_attribute29 :=
754: ben_cso_shd.g_old_rec.cso_attribute29;

Line 754: ben_cso_shd.g_old_rec.cso_attribute29;

750: ben_cso_shd.g_old_rec.cso_attribute28;
751: End If;
752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then
753: p_rec.cso_attribute29 :=
754: ben_cso_shd.g_old_rec.cso_attribute29;
755: End If;
756: If (p_rec.cso_attribute30 = hr_api.g_varchar2) then
757: p_rec.cso_attribute30 :=
758: ben_cso_shd.g_old_rec.cso_attribute30;

Line 758: ben_cso_shd.g_old_rec.cso_attribute30;

754: ben_cso_shd.g_old_rec.cso_attribute29;
755: End If;
756: If (p_rec.cso_attribute30 = hr_api.g_varchar2) then
757: p_rec.cso_attribute30 :=
758: ben_cso_shd.g_old_rec.cso_attribute30;
759: End If;
760: --
761: End convert_defs;
762: --

Line 768: ,p_rec in out nocopy ben_cso_shd.g_rec_type

764: -- |---------------------------------< upd >----------------------------------|
765: -- ----------------------------------------------------------------------------
766: Procedure upd
767: (p_effective_date in date
768: ,p_rec in out nocopy ben_cso_shd.g_rec_type
769: ) is
770: --
771: l_proc varchar2(72) := g_package||'upd';
772: --

Line 778: ben_cso_shd.lck

774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- We must lock the row which we need to update.
777: --
778: ben_cso_shd.lck
779: (p_rec.cwb_stock_optn_dtls_id
780: ,p_rec.object_version_number
781: );
782: --

Line 881: l_rec ben_cso_shd.g_rec_type;

877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
879: ) is
880: --
881: l_rec ben_cso_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'upd';
883: --
884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);

Line 891: ben_cso_shd.convert_args

887: -- Call conversion function to turn arguments into the
888: -- l_rec structure.
889: --
890: l_rec :=
891: ben_cso_shd.convert_args
892: (p_cwb_stock_optn_dtls_id
893: ,p_grant_id
894: ,p_grant_number
895: ,p_grant_name