DBA Data[Home] [Help]

APPS.BEN_BEP_UPD dependencies on BEN_BEP_SHD

Line 58: (p_rec in out nocopy ben_bep_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_bep_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 133: ben_bep_shd.constraint_error

129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ben_bep_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --

Line 138: ben_bep_shd.constraint_error

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --
138: ben_bep_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --
142: Raise;

Line 177: (p_rec in out nocopy ben_bep_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure update_dml
177: (p_rec in out nocopy ben_bep_shd.g_rec_type
178: ,p_effective_date in date
179: ,p_datetrack_mode in varchar2
180: ,p_validation_start_date in date
181: ,p_validation_end_date in date

Line 244: (p_rec in out nocopy ben_bep_shd.g_rec_type

240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure dt_pre_update
244: (p_rec in out nocopy ben_bep_shd.g_rec_type
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_validation_start_date in date
248: ,p_validation_end_date in date

Line 260: ben_bep_shd.upd_effective_end_date

256: If (p_datetrack_mode <> hr_api.g_correction) then
257: --
258: -- Update the current effective end date
259: --
260: ben_bep_shd.upd_effective_end_date
261: (p_effective_date => p_effective_date
262: ,p_base_key_value => p_rec.elig_obj_elig_prfl_id
263: ,p_new_effective_end_date => (p_validation_start_date - 1)
264: ,p_validation_start_date => p_validation_start_date

Line 329: (p_rec in out nocopy ben_bep_shd.g_rec_type

325: --
326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure pre_update
329: (p_rec in out nocopy ben_bep_shd.g_rec_type
330: ,p_effective_date in date
331: ,p_datetrack_mode in varchar2
332: ,p_validation_start_date in date
333: ,p_validation_end_date in date

Line 387: (p_rec in ben_bep_shd.g_rec_type

383: --
384: -- {End Of Comments}
385: -- ----------------------------------------------------------------------------
386: Procedure post_update
387: (p_rec in ben_bep_shd.g_rec_type
388: ,p_effective_date in date
389: ,p_datetrack_mode in varchar2
390: ,p_validation_start_date in date
391: ,p_validation_end_date in date

Line 468: => ben_bep_shd.g_old_rec.effective_start_date

464: => p_rec.bep_attribute20
465: ,p_object_version_number
466: => p_rec.object_version_number
467: ,p_effective_start_date_o
468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id

Line 470: => ben_bep_shd.g_old_rec.effective_end_date

466: => p_rec.object_version_number
467: ,p_effective_start_date_o
468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id

Line 472: => ben_bep_shd.g_old_rec.elig_obj_id

468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag

Line 474: => ben_bep_shd.g_old_rec.elig_prfl_id

470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id

Line 476: => ben_bep_shd.g_old_rec.mndtry_flag

472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category

Line 478: => ben_bep_shd.g_old_rec.business_group_id

474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1

Line 480: => ben_bep_shd.g_old_rec.bep_attribute_category

476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2

Line 482: => ben_bep_shd.g_old_rec.bep_attribute1

478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3

Line 484: => ben_bep_shd.g_old_rec.bep_attribute2

480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4

Line 486: => ben_bep_shd.g_old_rec.bep_attribute3

482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5

Line 488: => ben_bep_shd.g_old_rec.bep_attribute4

484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6

Line 490: => ben_bep_shd.g_old_rec.bep_attribute5

486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7

Line 492: => ben_bep_shd.g_old_rec.bep_attribute6

488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8

Line 494: => ben_bep_shd.g_old_rec.bep_attribute7

490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9

Line 496: => ben_bep_shd.g_old_rec.bep_attribute8

492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10

Line 498: => ben_bep_shd.g_old_rec.bep_attribute9

494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11

Line 500: => ben_bep_shd.g_old_rec.bep_attribute10

496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12

Line 502: => ben_bep_shd.g_old_rec.bep_attribute11

498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13

Line 504: => ben_bep_shd.g_old_rec.bep_attribute12

500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14

Line 506: => ben_bep_shd.g_old_rec.bep_attribute13

502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15

Line 508: => ben_bep_shd.g_old_rec.bep_attribute14

504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16

Line 510: => ben_bep_shd.g_old_rec.bep_attribute15

506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17

Line 512: => ben_bep_shd.g_old_rec.bep_attribute16

508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18

Line 514: => ben_bep_shd.g_old_rec.bep_attribute17

510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19

Line 516: => ben_bep_shd.g_old_rec.bep_attribute18

512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20

Line 518: => ben_bep_shd.g_old_rec.bep_attribute19

514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number

Line 520: => ben_bep_shd.g_old_rec.bep_attribute20

516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number
523: );
524: --

Line 522: => ben_bep_shd.g_old_rec.object_version_number

518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number
523: );
524: --
525: exception
526: --

Line 582: (p_rec in out nocopy ben_bep_shd.g_rec_type

578: --
579: -- {End Of Comments}
580: -- ----------------------------------------------------------------------------
581: Procedure convert_defs
582: (p_rec in out nocopy ben_bep_shd.g_rec_type
583: ) is
584: --
585: Begin
586: --

Line 594: ben_bep_shd.g_old_rec.elig_obj_id;

590: -- is being used then we must set to the 'current' argument value.
591: --
592: If (p_rec.elig_obj_id = hr_api.g_number) then
593: p_rec.elig_obj_id :=
594: ben_bep_shd.g_old_rec.elig_obj_id;
595: End If;
596: If (p_rec.elig_prfl_id = hr_api.g_number) then
597: p_rec.elig_prfl_id :=
598: ben_bep_shd.g_old_rec.elig_prfl_id;

Line 598: ben_bep_shd.g_old_rec.elig_prfl_id;

594: ben_bep_shd.g_old_rec.elig_obj_id;
595: End If;
596: If (p_rec.elig_prfl_id = hr_api.g_number) then
597: p_rec.elig_prfl_id :=
598: ben_bep_shd.g_old_rec.elig_prfl_id;
599: End If;
600: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
601: p_rec.mndtry_flag :=
602: ben_bep_shd.g_old_rec.mndtry_flag;

Line 602: ben_bep_shd.g_old_rec.mndtry_flag;

598: ben_bep_shd.g_old_rec.elig_prfl_id;
599: End If;
600: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
601: p_rec.mndtry_flag :=
602: ben_bep_shd.g_old_rec.mndtry_flag;
603: End If;
604: If (p_rec.business_group_id = hr_api.g_number) then
605: p_rec.business_group_id :=
606: ben_bep_shd.g_old_rec.business_group_id;

Line 606: ben_bep_shd.g_old_rec.business_group_id;

602: ben_bep_shd.g_old_rec.mndtry_flag;
603: End If;
604: If (p_rec.business_group_id = hr_api.g_number) then
605: p_rec.business_group_id :=
606: ben_bep_shd.g_old_rec.business_group_id;
607: End If;
608: If (p_rec.bep_attribute_category = hr_api.g_varchar2) then
609: p_rec.bep_attribute_category :=
610: ben_bep_shd.g_old_rec.bep_attribute_category;

Line 610: ben_bep_shd.g_old_rec.bep_attribute_category;

606: ben_bep_shd.g_old_rec.business_group_id;
607: End If;
608: If (p_rec.bep_attribute_category = hr_api.g_varchar2) then
609: p_rec.bep_attribute_category :=
610: ben_bep_shd.g_old_rec.bep_attribute_category;
611: End If;
612: If (p_rec.bep_attribute1 = hr_api.g_varchar2) then
613: p_rec.bep_attribute1 :=
614: ben_bep_shd.g_old_rec.bep_attribute1;

Line 614: ben_bep_shd.g_old_rec.bep_attribute1;

610: ben_bep_shd.g_old_rec.bep_attribute_category;
611: End If;
612: If (p_rec.bep_attribute1 = hr_api.g_varchar2) then
613: p_rec.bep_attribute1 :=
614: ben_bep_shd.g_old_rec.bep_attribute1;
615: End If;
616: If (p_rec.bep_attribute2 = hr_api.g_varchar2) then
617: p_rec.bep_attribute2 :=
618: ben_bep_shd.g_old_rec.bep_attribute2;

Line 618: ben_bep_shd.g_old_rec.bep_attribute2;

614: ben_bep_shd.g_old_rec.bep_attribute1;
615: End If;
616: If (p_rec.bep_attribute2 = hr_api.g_varchar2) then
617: p_rec.bep_attribute2 :=
618: ben_bep_shd.g_old_rec.bep_attribute2;
619: End If;
620: If (p_rec.bep_attribute3 = hr_api.g_varchar2) then
621: p_rec.bep_attribute3 :=
622: ben_bep_shd.g_old_rec.bep_attribute3;

Line 622: ben_bep_shd.g_old_rec.bep_attribute3;

618: ben_bep_shd.g_old_rec.bep_attribute2;
619: End If;
620: If (p_rec.bep_attribute3 = hr_api.g_varchar2) then
621: p_rec.bep_attribute3 :=
622: ben_bep_shd.g_old_rec.bep_attribute3;
623: End If;
624: If (p_rec.bep_attribute4 = hr_api.g_varchar2) then
625: p_rec.bep_attribute4 :=
626: ben_bep_shd.g_old_rec.bep_attribute4;

Line 626: ben_bep_shd.g_old_rec.bep_attribute4;

622: ben_bep_shd.g_old_rec.bep_attribute3;
623: End If;
624: If (p_rec.bep_attribute4 = hr_api.g_varchar2) then
625: p_rec.bep_attribute4 :=
626: ben_bep_shd.g_old_rec.bep_attribute4;
627: End If;
628: If (p_rec.bep_attribute5 = hr_api.g_varchar2) then
629: p_rec.bep_attribute5 :=
630: ben_bep_shd.g_old_rec.bep_attribute5;

Line 630: ben_bep_shd.g_old_rec.bep_attribute5;

626: ben_bep_shd.g_old_rec.bep_attribute4;
627: End If;
628: If (p_rec.bep_attribute5 = hr_api.g_varchar2) then
629: p_rec.bep_attribute5 :=
630: ben_bep_shd.g_old_rec.bep_attribute5;
631: End If;
632: If (p_rec.bep_attribute6 = hr_api.g_varchar2) then
633: p_rec.bep_attribute6 :=
634: ben_bep_shd.g_old_rec.bep_attribute6;

Line 634: ben_bep_shd.g_old_rec.bep_attribute6;

630: ben_bep_shd.g_old_rec.bep_attribute5;
631: End If;
632: If (p_rec.bep_attribute6 = hr_api.g_varchar2) then
633: p_rec.bep_attribute6 :=
634: ben_bep_shd.g_old_rec.bep_attribute6;
635: End If;
636: If (p_rec.bep_attribute7 = hr_api.g_varchar2) then
637: p_rec.bep_attribute7 :=
638: ben_bep_shd.g_old_rec.bep_attribute7;

Line 638: ben_bep_shd.g_old_rec.bep_attribute7;

634: ben_bep_shd.g_old_rec.bep_attribute6;
635: End If;
636: If (p_rec.bep_attribute7 = hr_api.g_varchar2) then
637: p_rec.bep_attribute7 :=
638: ben_bep_shd.g_old_rec.bep_attribute7;
639: End If;
640: If (p_rec.bep_attribute8 = hr_api.g_varchar2) then
641: p_rec.bep_attribute8 :=
642: ben_bep_shd.g_old_rec.bep_attribute8;

Line 642: ben_bep_shd.g_old_rec.bep_attribute8;

638: ben_bep_shd.g_old_rec.bep_attribute7;
639: End If;
640: If (p_rec.bep_attribute8 = hr_api.g_varchar2) then
641: p_rec.bep_attribute8 :=
642: ben_bep_shd.g_old_rec.bep_attribute8;
643: End If;
644: If (p_rec.bep_attribute9 = hr_api.g_varchar2) then
645: p_rec.bep_attribute9 :=
646: ben_bep_shd.g_old_rec.bep_attribute9;

Line 646: ben_bep_shd.g_old_rec.bep_attribute9;

642: ben_bep_shd.g_old_rec.bep_attribute8;
643: End If;
644: If (p_rec.bep_attribute9 = hr_api.g_varchar2) then
645: p_rec.bep_attribute9 :=
646: ben_bep_shd.g_old_rec.bep_attribute9;
647: End If;
648: If (p_rec.bep_attribute10 = hr_api.g_varchar2) then
649: p_rec.bep_attribute10 :=
650: ben_bep_shd.g_old_rec.bep_attribute10;

Line 650: ben_bep_shd.g_old_rec.bep_attribute10;

646: ben_bep_shd.g_old_rec.bep_attribute9;
647: End If;
648: If (p_rec.bep_attribute10 = hr_api.g_varchar2) then
649: p_rec.bep_attribute10 :=
650: ben_bep_shd.g_old_rec.bep_attribute10;
651: End If;
652: If (p_rec.bep_attribute11 = hr_api.g_varchar2) then
653: p_rec.bep_attribute11 :=
654: ben_bep_shd.g_old_rec.bep_attribute11;

Line 654: ben_bep_shd.g_old_rec.bep_attribute11;

650: ben_bep_shd.g_old_rec.bep_attribute10;
651: End If;
652: If (p_rec.bep_attribute11 = hr_api.g_varchar2) then
653: p_rec.bep_attribute11 :=
654: ben_bep_shd.g_old_rec.bep_attribute11;
655: End If;
656: If (p_rec.bep_attribute12 = hr_api.g_varchar2) then
657: p_rec.bep_attribute12 :=
658: ben_bep_shd.g_old_rec.bep_attribute12;

Line 658: ben_bep_shd.g_old_rec.bep_attribute12;

654: ben_bep_shd.g_old_rec.bep_attribute11;
655: End If;
656: If (p_rec.bep_attribute12 = hr_api.g_varchar2) then
657: p_rec.bep_attribute12 :=
658: ben_bep_shd.g_old_rec.bep_attribute12;
659: End If;
660: If (p_rec.bep_attribute13 = hr_api.g_varchar2) then
661: p_rec.bep_attribute13 :=
662: ben_bep_shd.g_old_rec.bep_attribute13;

Line 662: ben_bep_shd.g_old_rec.bep_attribute13;

658: ben_bep_shd.g_old_rec.bep_attribute12;
659: End If;
660: If (p_rec.bep_attribute13 = hr_api.g_varchar2) then
661: p_rec.bep_attribute13 :=
662: ben_bep_shd.g_old_rec.bep_attribute13;
663: End If;
664: If (p_rec.bep_attribute14 = hr_api.g_varchar2) then
665: p_rec.bep_attribute14 :=
666: ben_bep_shd.g_old_rec.bep_attribute14;

Line 666: ben_bep_shd.g_old_rec.bep_attribute14;

662: ben_bep_shd.g_old_rec.bep_attribute13;
663: End If;
664: If (p_rec.bep_attribute14 = hr_api.g_varchar2) then
665: p_rec.bep_attribute14 :=
666: ben_bep_shd.g_old_rec.bep_attribute14;
667: End If;
668: If (p_rec.bep_attribute15 = hr_api.g_varchar2) then
669: p_rec.bep_attribute15 :=
670: ben_bep_shd.g_old_rec.bep_attribute15;

Line 670: ben_bep_shd.g_old_rec.bep_attribute15;

666: ben_bep_shd.g_old_rec.bep_attribute14;
667: End If;
668: If (p_rec.bep_attribute15 = hr_api.g_varchar2) then
669: p_rec.bep_attribute15 :=
670: ben_bep_shd.g_old_rec.bep_attribute15;
671: End If;
672: If (p_rec.bep_attribute16 = hr_api.g_varchar2) then
673: p_rec.bep_attribute16 :=
674: ben_bep_shd.g_old_rec.bep_attribute16;

Line 674: ben_bep_shd.g_old_rec.bep_attribute16;

670: ben_bep_shd.g_old_rec.bep_attribute15;
671: End If;
672: If (p_rec.bep_attribute16 = hr_api.g_varchar2) then
673: p_rec.bep_attribute16 :=
674: ben_bep_shd.g_old_rec.bep_attribute16;
675: End If;
676: If (p_rec.bep_attribute17 = hr_api.g_varchar2) then
677: p_rec.bep_attribute17 :=
678: ben_bep_shd.g_old_rec.bep_attribute17;

Line 678: ben_bep_shd.g_old_rec.bep_attribute17;

674: ben_bep_shd.g_old_rec.bep_attribute16;
675: End If;
676: If (p_rec.bep_attribute17 = hr_api.g_varchar2) then
677: p_rec.bep_attribute17 :=
678: ben_bep_shd.g_old_rec.bep_attribute17;
679: End If;
680: If (p_rec.bep_attribute18 = hr_api.g_varchar2) then
681: p_rec.bep_attribute18 :=
682: ben_bep_shd.g_old_rec.bep_attribute18;

Line 682: ben_bep_shd.g_old_rec.bep_attribute18;

678: ben_bep_shd.g_old_rec.bep_attribute17;
679: End If;
680: If (p_rec.bep_attribute18 = hr_api.g_varchar2) then
681: p_rec.bep_attribute18 :=
682: ben_bep_shd.g_old_rec.bep_attribute18;
683: End If;
684: If (p_rec.bep_attribute19 = hr_api.g_varchar2) then
685: p_rec.bep_attribute19 :=
686: ben_bep_shd.g_old_rec.bep_attribute19;

Line 686: ben_bep_shd.g_old_rec.bep_attribute19;

682: ben_bep_shd.g_old_rec.bep_attribute18;
683: End If;
684: If (p_rec.bep_attribute19 = hr_api.g_varchar2) then
685: p_rec.bep_attribute19 :=
686: ben_bep_shd.g_old_rec.bep_attribute19;
687: End If;
688: If (p_rec.bep_attribute20 = hr_api.g_varchar2) then
689: p_rec.bep_attribute20 :=
690: ben_bep_shd.g_old_rec.bep_attribute20;

Line 690: ben_bep_shd.g_old_rec.bep_attribute20;

686: ben_bep_shd.g_old_rec.bep_attribute19;
687: End If;
688: If (p_rec.bep_attribute20 = hr_api.g_varchar2) then
689: p_rec.bep_attribute20 :=
690: ben_bep_shd.g_old_rec.bep_attribute20;
691: End If;
692: --
693: End convert_defs;
694: --

Line 701: ,p_rec in out nocopy ben_bep_shd.g_rec_type

697: -- ----------------------------------------------------------------------------
698: Procedure upd
699: (p_effective_date in date
700: ,p_datetrack_mode in varchar2
701: ,p_rec in out nocopy ben_bep_shd.g_rec_type
702: ) is
703: --
704: l_proc varchar2(72) := g_package||'upd';
705: l_validation_start_date date;

Line 717: ben_bep_shd.lck

713: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
714: --
715: -- We must lock the row which we need to update.
716: --
717: ben_bep_shd.lck
718: (p_effective_date => p_effective_date
719: ,p_datetrack_mode => p_datetrack_mode
720: ,p_elig_obj_elig_prfl_id => p_rec.elig_obj_elig_prfl_id
721: ,p_object_version_number => p_rec.object_version_number

Line 816: l_rec ben_bep_shd.g_rec_type;

812: ,p_effective_start_date out nocopy date
813: ,p_effective_end_date out nocopy date
814: ) is
815: --
816: l_rec ben_bep_shd.g_rec_type;
817: l_proc varchar2(72) := g_package||'upd';
818: --
819: Begin
820: hr_utility.set_location('Entering:'||l_proc, 5);

Line 826: ben_bep_shd.convert_args

822: -- Call conversion function to turn arguments into the
823: -- l_rec structure.
824: --
825: l_rec :=
826: ben_bep_shd.convert_args
827: (p_elig_obj_elig_prfl_id
828: ,null
829: ,null
830: ,p_elig_obj_id