eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VEP_UPD dependencies on BEN_VEP_SHD

Line 58: (p_rec in out nocopy ben_vep_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_vep_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 83: ben_vep_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID'
80: ,p_base_key_value => p_rec.vrbl_rt_elig_prfl_id
81: );
82: --
83: ben_vep_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the BEN_VRBL_RT_ELIG_PRFL_f Row
86: --
87: update BEN_VRBL_RT_ELIG_PRFL_f

Line 130: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

126: where vrbl_rt_elig_prfl_id = p_rec.vrbl_rt_elig_prfl_id
127: and effective_start_date = p_validation_start_date
128: and effective_end_date = p_validation_end_date;
129: --
130: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: -- Set the effective start and end dates
133: --
134: p_rec.effective_start_date := p_validation_start_date;

Line 142: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

138: hr_utility.set_location(' Leaving:'||l_proc, 15);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
143: ben_vep_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated

Line 143: ben_vep_shd.constraint_error

139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
143: ben_vep_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

Line 147: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

143: ben_vep_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
148: ben_vep_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

Line 148: ben_vep_shd.constraint_error

144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
148: ben_vep_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;

Line 151: ben_vep_shd.g_api_dml := false; -- Unset the api dml status

147: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
148: ben_vep_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;
153: End dt_update_dml;
154: --
155: -- ----------------------------------------------------------------------------

Line 187: (p_rec in out nocopy ben_vep_shd.g_rec_type

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure update_dml
187: (p_rec in out nocopy ben_vep_shd.g_rec_type
188: ,p_effective_date in date
189: ,p_datetrack_mode in varchar2
190: ,p_validation_start_date in date
191: ,p_validation_end_date in date

Line 254: (p_rec in out nocopy ben_vep_shd.g_rec_type

250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure dt_pre_update
254: (p_rec in out nocopy ben_vep_shd.g_rec_type
255: ,p_effective_date in date
256: ,p_datetrack_mode in varchar2
257: ,p_validation_start_date in date
258: ,p_validation_end_date in date

Line 270: ben_vep_shd.upd_effective_end_date

266: If (p_datetrack_mode <> hr_api.g_correction) then
267: --
268: -- Update the current effective end date
269: --
270: ben_vep_shd.upd_effective_end_date
271: (p_effective_date => p_effective_date
272: ,p_base_key_value => p_rec.vrbl_rt_elig_prfl_id
273: ,p_new_effective_end_date => (p_validation_start_date - 1)
274: ,p_validation_start_date => p_validation_start_date

Line 340: (p_rec in out nocopy ben_vep_shd.g_rec_type

336: --
337: -- {End Of Comments}
338: -- ----------------------------------------------------------------------------
339: Procedure pre_update
340: (p_rec in out nocopy ben_vep_shd.g_rec_type
341: ,p_effective_date in date
342: ,p_datetrack_mode in varchar2
343: ,p_validation_start_date in date
344: ,p_validation_end_date in date

Line 398: (p_rec in ben_vep_shd.g_rec_type

394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure post_update
398: (p_rec in ben_vep_shd.g_rec_type
399: ,p_effective_date in date
400: ,p_datetrack_mode in varchar2
401: ,p_validation_start_date in date
402: ,p_validation_end_date in date

Line 499: => ben_vep_shd.g_old_rec.effective_start_date

495: => p_rec.vep_attribute30
496: ,p_object_version_number
497: => p_rec.object_version_number
498: ,p_effective_start_date_o
499: => ben_vep_shd.g_old_rec.effective_start_date
500: ,p_effective_end_date_o
501: => ben_vep_shd.g_old_rec.effective_end_date
502: ,p_business_group_id_o
503: => ben_vep_shd.g_old_rec.business_group_id

Line 501: => ben_vep_shd.g_old_rec.effective_end_date

497: => p_rec.object_version_number
498: ,p_effective_start_date_o
499: => ben_vep_shd.g_old_rec.effective_start_date
500: ,p_effective_end_date_o
501: => ben_vep_shd.g_old_rec.effective_end_date
502: ,p_business_group_id_o
503: => ben_vep_shd.g_old_rec.business_group_id
504: ,p_vrbl_rt_prfl_id_o
505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id

Line 503: => ben_vep_shd.g_old_rec.business_group_id

499: => ben_vep_shd.g_old_rec.effective_start_date
500: ,p_effective_end_date_o
501: => ben_vep_shd.g_old_rec.effective_end_date
502: ,p_business_group_id_o
503: => ben_vep_shd.g_old_rec.business_group_id
504: ,p_vrbl_rt_prfl_id_o
505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
506: ,p_eligy_prfl_id_o
507: => ben_vep_shd.g_old_rec.eligy_prfl_id

Line 505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id

501: => ben_vep_shd.g_old_rec.effective_end_date
502: ,p_business_group_id_o
503: => ben_vep_shd.g_old_rec.business_group_id
504: ,p_vrbl_rt_prfl_id_o
505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
506: ,p_eligy_prfl_id_o
507: => ben_vep_shd.g_old_rec.eligy_prfl_id
508: ,p_mndtry_flag_o
509: => ben_vep_shd.g_old_rec.mndtry_flag

Line 507: => ben_vep_shd.g_old_rec.eligy_prfl_id

503: => ben_vep_shd.g_old_rec.business_group_id
504: ,p_vrbl_rt_prfl_id_o
505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
506: ,p_eligy_prfl_id_o
507: => ben_vep_shd.g_old_rec.eligy_prfl_id
508: ,p_mndtry_flag_o
509: => ben_vep_shd.g_old_rec.mndtry_flag
510: ,p_vep_attribute_category_o
511: => ben_vep_shd.g_old_rec.vep_attribute_category

Line 509: => ben_vep_shd.g_old_rec.mndtry_flag

505: => ben_vep_shd.g_old_rec.vrbl_rt_prfl_id
506: ,p_eligy_prfl_id_o
507: => ben_vep_shd.g_old_rec.eligy_prfl_id
508: ,p_mndtry_flag_o
509: => ben_vep_shd.g_old_rec.mndtry_flag
510: ,p_vep_attribute_category_o
511: => ben_vep_shd.g_old_rec.vep_attribute_category
512: ,p_vep_attribute1_o
513: => ben_vep_shd.g_old_rec.vep_attribute1

Line 511: => ben_vep_shd.g_old_rec.vep_attribute_category

507: => ben_vep_shd.g_old_rec.eligy_prfl_id
508: ,p_mndtry_flag_o
509: => ben_vep_shd.g_old_rec.mndtry_flag
510: ,p_vep_attribute_category_o
511: => ben_vep_shd.g_old_rec.vep_attribute_category
512: ,p_vep_attribute1_o
513: => ben_vep_shd.g_old_rec.vep_attribute1
514: ,p_vep_attribute2_o
515: => ben_vep_shd.g_old_rec.vep_attribute2

Line 513: => ben_vep_shd.g_old_rec.vep_attribute1

509: => ben_vep_shd.g_old_rec.mndtry_flag
510: ,p_vep_attribute_category_o
511: => ben_vep_shd.g_old_rec.vep_attribute_category
512: ,p_vep_attribute1_o
513: => ben_vep_shd.g_old_rec.vep_attribute1
514: ,p_vep_attribute2_o
515: => ben_vep_shd.g_old_rec.vep_attribute2
516: ,p_vep_attribute3_o
517: => ben_vep_shd.g_old_rec.vep_attribute3

Line 515: => ben_vep_shd.g_old_rec.vep_attribute2

511: => ben_vep_shd.g_old_rec.vep_attribute_category
512: ,p_vep_attribute1_o
513: => ben_vep_shd.g_old_rec.vep_attribute1
514: ,p_vep_attribute2_o
515: => ben_vep_shd.g_old_rec.vep_attribute2
516: ,p_vep_attribute3_o
517: => ben_vep_shd.g_old_rec.vep_attribute3
518: ,p_vep_attribute4_o
519: => ben_vep_shd.g_old_rec.vep_attribute4

Line 517: => ben_vep_shd.g_old_rec.vep_attribute3

513: => ben_vep_shd.g_old_rec.vep_attribute1
514: ,p_vep_attribute2_o
515: => ben_vep_shd.g_old_rec.vep_attribute2
516: ,p_vep_attribute3_o
517: => ben_vep_shd.g_old_rec.vep_attribute3
518: ,p_vep_attribute4_o
519: => ben_vep_shd.g_old_rec.vep_attribute4
520: ,p_vep_attribute5_o
521: => ben_vep_shd.g_old_rec.vep_attribute5

Line 519: => ben_vep_shd.g_old_rec.vep_attribute4

515: => ben_vep_shd.g_old_rec.vep_attribute2
516: ,p_vep_attribute3_o
517: => ben_vep_shd.g_old_rec.vep_attribute3
518: ,p_vep_attribute4_o
519: => ben_vep_shd.g_old_rec.vep_attribute4
520: ,p_vep_attribute5_o
521: => ben_vep_shd.g_old_rec.vep_attribute5
522: ,p_vep_attribute6_o
523: => ben_vep_shd.g_old_rec.vep_attribute6

Line 521: => ben_vep_shd.g_old_rec.vep_attribute5

517: => ben_vep_shd.g_old_rec.vep_attribute3
518: ,p_vep_attribute4_o
519: => ben_vep_shd.g_old_rec.vep_attribute4
520: ,p_vep_attribute5_o
521: => ben_vep_shd.g_old_rec.vep_attribute5
522: ,p_vep_attribute6_o
523: => ben_vep_shd.g_old_rec.vep_attribute6
524: ,p_vep_attribute7_o
525: => ben_vep_shd.g_old_rec.vep_attribute7

Line 523: => ben_vep_shd.g_old_rec.vep_attribute6

519: => ben_vep_shd.g_old_rec.vep_attribute4
520: ,p_vep_attribute5_o
521: => ben_vep_shd.g_old_rec.vep_attribute5
522: ,p_vep_attribute6_o
523: => ben_vep_shd.g_old_rec.vep_attribute6
524: ,p_vep_attribute7_o
525: => ben_vep_shd.g_old_rec.vep_attribute7
526: ,p_vep_attribute8_o
527: => ben_vep_shd.g_old_rec.vep_attribute8

Line 525: => ben_vep_shd.g_old_rec.vep_attribute7

521: => ben_vep_shd.g_old_rec.vep_attribute5
522: ,p_vep_attribute6_o
523: => ben_vep_shd.g_old_rec.vep_attribute6
524: ,p_vep_attribute7_o
525: => ben_vep_shd.g_old_rec.vep_attribute7
526: ,p_vep_attribute8_o
527: => ben_vep_shd.g_old_rec.vep_attribute8
528: ,p_vep_attribute9_o
529: => ben_vep_shd.g_old_rec.vep_attribute9

Line 527: => ben_vep_shd.g_old_rec.vep_attribute8

523: => ben_vep_shd.g_old_rec.vep_attribute6
524: ,p_vep_attribute7_o
525: => ben_vep_shd.g_old_rec.vep_attribute7
526: ,p_vep_attribute8_o
527: => ben_vep_shd.g_old_rec.vep_attribute8
528: ,p_vep_attribute9_o
529: => ben_vep_shd.g_old_rec.vep_attribute9
530: ,p_vep_attribute10_o
531: => ben_vep_shd.g_old_rec.vep_attribute10

Line 529: => ben_vep_shd.g_old_rec.vep_attribute9

525: => ben_vep_shd.g_old_rec.vep_attribute7
526: ,p_vep_attribute8_o
527: => ben_vep_shd.g_old_rec.vep_attribute8
528: ,p_vep_attribute9_o
529: => ben_vep_shd.g_old_rec.vep_attribute9
530: ,p_vep_attribute10_o
531: => ben_vep_shd.g_old_rec.vep_attribute10
532: ,p_vep_attribute11_o
533: => ben_vep_shd.g_old_rec.vep_attribute11

Line 531: => ben_vep_shd.g_old_rec.vep_attribute10

527: => ben_vep_shd.g_old_rec.vep_attribute8
528: ,p_vep_attribute9_o
529: => ben_vep_shd.g_old_rec.vep_attribute9
530: ,p_vep_attribute10_o
531: => ben_vep_shd.g_old_rec.vep_attribute10
532: ,p_vep_attribute11_o
533: => ben_vep_shd.g_old_rec.vep_attribute11
534: ,p_vep_attribute12_o
535: => ben_vep_shd.g_old_rec.vep_attribute12

Line 533: => ben_vep_shd.g_old_rec.vep_attribute11

529: => ben_vep_shd.g_old_rec.vep_attribute9
530: ,p_vep_attribute10_o
531: => ben_vep_shd.g_old_rec.vep_attribute10
532: ,p_vep_attribute11_o
533: => ben_vep_shd.g_old_rec.vep_attribute11
534: ,p_vep_attribute12_o
535: => ben_vep_shd.g_old_rec.vep_attribute12
536: ,p_vep_attribute13_o
537: => ben_vep_shd.g_old_rec.vep_attribute13

Line 535: => ben_vep_shd.g_old_rec.vep_attribute12

531: => ben_vep_shd.g_old_rec.vep_attribute10
532: ,p_vep_attribute11_o
533: => ben_vep_shd.g_old_rec.vep_attribute11
534: ,p_vep_attribute12_o
535: => ben_vep_shd.g_old_rec.vep_attribute12
536: ,p_vep_attribute13_o
537: => ben_vep_shd.g_old_rec.vep_attribute13
538: ,p_vep_attribute14_o
539: => ben_vep_shd.g_old_rec.vep_attribute14

Line 537: => ben_vep_shd.g_old_rec.vep_attribute13

533: => ben_vep_shd.g_old_rec.vep_attribute11
534: ,p_vep_attribute12_o
535: => ben_vep_shd.g_old_rec.vep_attribute12
536: ,p_vep_attribute13_o
537: => ben_vep_shd.g_old_rec.vep_attribute13
538: ,p_vep_attribute14_o
539: => ben_vep_shd.g_old_rec.vep_attribute14
540: ,p_vep_attribute15_o
541: => ben_vep_shd.g_old_rec.vep_attribute15

Line 539: => ben_vep_shd.g_old_rec.vep_attribute14

535: => ben_vep_shd.g_old_rec.vep_attribute12
536: ,p_vep_attribute13_o
537: => ben_vep_shd.g_old_rec.vep_attribute13
538: ,p_vep_attribute14_o
539: => ben_vep_shd.g_old_rec.vep_attribute14
540: ,p_vep_attribute15_o
541: => ben_vep_shd.g_old_rec.vep_attribute15
542: ,p_vep_attribute16_o
543: => ben_vep_shd.g_old_rec.vep_attribute16

Line 541: => ben_vep_shd.g_old_rec.vep_attribute15

537: => ben_vep_shd.g_old_rec.vep_attribute13
538: ,p_vep_attribute14_o
539: => ben_vep_shd.g_old_rec.vep_attribute14
540: ,p_vep_attribute15_o
541: => ben_vep_shd.g_old_rec.vep_attribute15
542: ,p_vep_attribute16_o
543: => ben_vep_shd.g_old_rec.vep_attribute16
544: ,p_vep_attribute17_o
545: => ben_vep_shd.g_old_rec.vep_attribute17

Line 543: => ben_vep_shd.g_old_rec.vep_attribute16

539: => ben_vep_shd.g_old_rec.vep_attribute14
540: ,p_vep_attribute15_o
541: => ben_vep_shd.g_old_rec.vep_attribute15
542: ,p_vep_attribute16_o
543: => ben_vep_shd.g_old_rec.vep_attribute16
544: ,p_vep_attribute17_o
545: => ben_vep_shd.g_old_rec.vep_attribute17
546: ,p_vep_attribute18_o
547: => ben_vep_shd.g_old_rec.vep_attribute18

Line 545: => ben_vep_shd.g_old_rec.vep_attribute17

541: => ben_vep_shd.g_old_rec.vep_attribute15
542: ,p_vep_attribute16_o
543: => ben_vep_shd.g_old_rec.vep_attribute16
544: ,p_vep_attribute17_o
545: => ben_vep_shd.g_old_rec.vep_attribute17
546: ,p_vep_attribute18_o
547: => ben_vep_shd.g_old_rec.vep_attribute18
548: ,p_vep_attribute19_o
549: => ben_vep_shd.g_old_rec.vep_attribute19

Line 547: => ben_vep_shd.g_old_rec.vep_attribute18

543: => ben_vep_shd.g_old_rec.vep_attribute16
544: ,p_vep_attribute17_o
545: => ben_vep_shd.g_old_rec.vep_attribute17
546: ,p_vep_attribute18_o
547: => ben_vep_shd.g_old_rec.vep_attribute18
548: ,p_vep_attribute19_o
549: => ben_vep_shd.g_old_rec.vep_attribute19
550: ,p_vep_attribute20_o
551: => ben_vep_shd.g_old_rec.vep_attribute20

Line 549: => ben_vep_shd.g_old_rec.vep_attribute19

545: => ben_vep_shd.g_old_rec.vep_attribute17
546: ,p_vep_attribute18_o
547: => ben_vep_shd.g_old_rec.vep_attribute18
548: ,p_vep_attribute19_o
549: => ben_vep_shd.g_old_rec.vep_attribute19
550: ,p_vep_attribute20_o
551: => ben_vep_shd.g_old_rec.vep_attribute20
552: ,p_vep_attribute21_o
553: => ben_vep_shd.g_old_rec.vep_attribute21

Line 551: => ben_vep_shd.g_old_rec.vep_attribute20

547: => ben_vep_shd.g_old_rec.vep_attribute18
548: ,p_vep_attribute19_o
549: => ben_vep_shd.g_old_rec.vep_attribute19
550: ,p_vep_attribute20_o
551: => ben_vep_shd.g_old_rec.vep_attribute20
552: ,p_vep_attribute21_o
553: => ben_vep_shd.g_old_rec.vep_attribute21
554: ,p_vep_attribute22_o
555: => ben_vep_shd.g_old_rec.vep_attribute22

Line 553: => ben_vep_shd.g_old_rec.vep_attribute21

549: => ben_vep_shd.g_old_rec.vep_attribute19
550: ,p_vep_attribute20_o
551: => ben_vep_shd.g_old_rec.vep_attribute20
552: ,p_vep_attribute21_o
553: => ben_vep_shd.g_old_rec.vep_attribute21
554: ,p_vep_attribute22_o
555: => ben_vep_shd.g_old_rec.vep_attribute22
556: ,p_vep_attribute23_o
557: => ben_vep_shd.g_old_rec.vep_attribute23

Line 555: => ben_vep_shd.g_old_rec.vep_attribute22

551: => ben_vep_shd.g_old_rec.vep_attribute20
552: ,p_vep_attribute21_o
553: => ben_vep_shd.g_old_rec.vep_attribute21
554: ,p_vep_attribute22_o
555: => ben_vep_shd.g_old_rec.vep_attribute22
556: ,p_vep_attribute23_o
557: => ben_vep_shd.g_old_rec.vep_attribute23
558: ,p_vep_attribute24_o
559: => ben_vep_shd.g_old_rec.vep_attribute24

Line 557: => ben_vep_shd.g_old_rec.vep_attribute23

553: => ben_vep_shd.g_old_rec.vep_attribute21
554: ,p_vep_attribute22_o
555: => ben_vep_shd.g_old_rec.vep_attribute22
556: ,p_vep_attribute23_o
557: => ben_vep_shd.g_old_rec.vep_attribute23
558: ,p_vep_attribute24_o
559: => ben_vep_shd.g_old_rec.vep_attribute24
560: ,p_vep_attribute25_o
561: => ben_vep_shd.g_old_rec.vep_attribute25

Line 559: => ben_vep_shd.g_old_rec.vep_attribute24

555: => ben_vep_shd.g_old_rec.vep_attribute22
556: ,p_vep_attribute23_o
557: => ben_vep_shd.g_old_rec.vep_attribute23
558: ,p_vep_attribute24_o
559: => ben_vep_shd.g_old_rec.vep_attribute24
560: ,p_vep_attribute25_o
561: => ben_vep_shd.g_old_rec.vep_attribute25
562: ,p_vep_attribute26_o
563: => ben_vep_shd.g_old_rec.vep_attribute26

Line 561: => ben_vep_shd.g_old_rec.vep_attribute25

557: => ben_vep_shd.g_old_rec.vep_attribute23
558: ,p_vep_attribute24_o
559: => ben_vep_shd.g_old_rec.vep_attribute24
560: ,p_vep_attribute25_o
561: => ben_vep_shd.g_old_rec.vep_attribute25
562: ,p_vep_attribute26_o
563: => ben_vep_shd.g_old_rec.vep_attribute26
564: ,p_vep_attribute27_o
565: => ben_vep_shd.g_old_rec.vep_attribute27

Line 563: => ben_vep_shd.g_old_rec.vep_attribute26

559: => ben_vep_shd.g_old_rec.vep_attribute24
560: ,p_vep_attribute25_o
561: => ben_vep_shd.g_old_rec.vep_attribute25
562: ,p_vep_attribute26_o
563: => ben_vep_shd.g_old_rec.vep_attribute26
564: ,p_vep_attribute27_o
565: => ben_vep_shd.g_old_rec.vep_attribute27
566: ,p_vep_attribute28_o
567: => ben_vep_shd.g_old_rec.vep_attribute28

Line 565: => ben_vep_shd.g_old_rec.vep_attribute27

561: => ben_vep_shd.g_old_rec.vep_attribute25
562: ,p_vep_attribute26_o
563: => ben_vep_shd.g_old_rec.vep_attribute26
564: ,p_vep_attribute27_o
565: => ben_vep_shd.g_old_rec.vep_attribute27
566: ,p_vep_attribute28_o
567: => ben_vep_shd.g_old_rec.vep_attribute28
568: ,p_vep_attribute29_o
569: => ben_vep_shd.g_old_rec.vep_attribute29

Line 567: => ben_vep_shd.g_old_rec.vep_attribute28

563: => ben_vep_shd.g_old_rec.vep_attribute26
564: ,p_vep_attribute27_o
565: => ben_vep_shd.g_old_rec.vep_attribute27
566: ,p_vep_attribute28_o
567: => ben_vep_shd.g_old_rec.vep_attribute28
568: ,p_vep_attribute29_o
569: => ben_vep_shd.g_old_rec.vep_attribute29
570: ,p_vep_attribute30_o
571: => ben_vep_shd.g_old_rec.vep_attribute30

Line 569: => ben_vep_shd.g_old_rec.vep_attribute29

565: => ben_vep_shd.g_old_rec.vep_attribute27
566: ,p_vep_attribute28_o
567: => ben_vep_shd.g_old_rec.vep_attribute28
568: ,p_vep_attribute29_o
569: => ben_vep_shd.g_old_rec.vep_attribute29
570: ,p_vep_attribute30_o
571: => ben_vep_shd.g_old_rec.vep_attribute30
572: ,p_object_version_number_o
573: => ben_vep_shd.g_old_rec.object_version_number

Line 571: => ben_vep_shd.g_old_rec.vep_attribute30

567: => ben_vep_shd.g_old_rec.vep_attribute28
568: ,p_vep_attribute29_o
569: => ben_vep_shd.g_old_rec.vep_attribute29
570: ,p_vep_attribute30_o
571: => ben_vep_shd.g_old_rec.vep_attribute30
572: ,p_object_version_number_o
573: => ben_vep_shd.g_old_rec.object_version_number
574: );
575: --

Line 573: => ben_vep_shd.g_old_rec.object_version_number

569: => ben_vep_shd.g_old_rec.vep_attribute29
570: ,p_vep_attribute30_o
571: => ben_vep_shd.g_old_rec.vep_attribute30
572: ,p_object_version_number_o
573: => ben_vep_shd.g_old_rec.object_version_number
574: );
575: --
576: exception
577: --

Line 633: (p_rec in out nocopy ben_vep_shd.g_rec_type

629: --
630: -- {End Of Comments}
631: -- ----------------------------------------------------------------------------
632: Procedure convert_defs
633: (p_rec in out nocopy ben_vep_shd.g_rec_type
634: ) is
635: --
636: Begin
637: --

Line 645: ben_vep_shd.g_old_rec.business_group_id;

641: -- is being used then we must set to the 'current' argument value.
642: --
643: If (p_rec.business_group_id = hr_api.g_number) then
644: p_rec.business_group_id :=
645: ben_vep_shd.g_old_rec.business_group_id;
646: End If;
647: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
648: p_rec.vrbl_rt_prfl_id :=
649: ben_vep_shd.g_old_rec.vrbl_rt_prfl_id;

Line 649: ben_vep_shd.g_old_rec.vrbl_rt_prfl_id;

645: ben_vep_shd.g_old_rec.business_group_id;
646: End If;
647: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
648: p_rec.vrbl_rt_prfl_id :=
649: ben_vep_shd.g_old_rec.vrbl_rt_prfl_id;
650: End If;
651: If (p_rec.eligy_prfl_id = hr_api.g_number) then
652: p_rec.eligy_prfl_id :=
653: ben_vep_shd.g_old_rec.eligy_prfl_id;

Line 653: ben_vep_shd.g_old_rec.eligy_prfl_id;

649: ben_vep_shd.g_old_rec.vrbl_rt_prfl_id;
650: End If;
651: If (p_rec.eligy_prfl_id = hr_api.g_number) then
652: p_rec.eligy_prfl_id :=
653: ben_vep_shd.g_old_rec.eligy_prfl_id;
654: End If;
655: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
656: p_rec.mndtry_flag :=
657: ben_vep_shd.g_old_rec.mndtry_flag;

Line 657: ben_vep_shd.g_old_rec.mndtry_flag;

653: ben_vep_shd.g_old_rec.eligy_prfl_id;
654: End If;
655: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
656: p_rec.mndtry_flag :=
657: ben_vep_shd.g_old_rec.mndtry_flag;
658: End If;
659: If (p_rec.vep_attribute_category = hr_api.g_varchar2) then
660: p_rec.vep_attribute_category :=
661: ben_vep_shd.g_old_rec.vep_attribute_category;

Line 661: ben_vep_shd.g_old_rec.vep_attribute_category;

657: ben_vep_shd.g_old_rec.mndtry_flag;
658: End If;
659: If (p_rec.vep_attribute_category = hr_api.g_varchar2) then
660: p_rec.vep_attribute_category :=
661: ben_vep_shd.g_old_rec.vep_attribute_category;
662: End If;
663: If (p_rec.vep_attribute1 = hr_api.g_varchar2) then
664: p_rec.vep_attribute1 :=
665: ben_vep_shd.g_old_rec.vep_attribute1;

Line 665: ben_vep_shd.g_old_rec.vep_attribute1;

661: ben_vep_shd.g_old_rec.vep_attribute_category;
662: End If;
663: If (p_rec.vep_attribute1 = hr_api.g_varchar2) then
664: p_rec.vep_attribute1 :=
665: ben_vep_shd.g_old_rec.vep_attribute1;
666: End If;
667: If (p_rec.vep_attribute2 = hr_api.g_varchar2) then
668: p_rec.vep_attribute2 :=
669: ben_vep_shd.g_old_rec.vep_attribute2;

Line 669: ben_vep_shd.g_old_rec.vep_attribute2;

665: ben_vep_shd.g_old_rec.vep_attribute1;
666: End If;
667: If (p_rec.vep_attribute2 = hr_api.g_varchar2) then
668: p_rec.vep_attribute2 :=
669: ben_vep_shd.g_old_rec.vep_attribute2;
670: End If;
671: If (p_rec.vep_attribute3 = hr_api.g_varchar2) then
672: p_rec.vep_attribute3 :=
673: ben_vep_shd.g_old_rec.vep_attribute3;

Line 673: ben_vep_shd.g_old_rec.vep_attribute3;

669: ben_vep_shd.g_old_rec.vep_attribute2;
670: End If;
671: If (p_rec.vep_attribute3 = hr_api.g_varchar2) then
672: p_rec.vep_attribute3 :=
673: ben_vep_shd.g_old_rec.vep_attribute3;
674: End If;
675: If (p_rec.vep_attribute4 = hr_api.g_varchar2) then
676: p_rec.vep_attribute4 :=
677: ben_vep_shd.g_old_rec.vep_attribute4;

Line 677: ben_vep_shd.g_old_rec.vep_attribute4;

673: ben_vep_shd.g_old_rec.vep_attribute3;
674: End If;
675: If (p_rec.vep_attribute4 = hr_api.g_varchar2) then
676: p_rec.vep_attribute4 :=
677: ben_vep_shd.g_old_rec.vep_attribute4;
678: End If;
679: If (p_rec.vep_attribute5 = hr_api.g_varchar2) then
680: p_rec.vep_attribute5 :=
681: ben_vep_shd.g_old_rec.vep_attribute5;

Line 681: ben_vep_shd.g_old_rec.vep_attribute5;

677: ben_vep_shd.g_old_rec.vep_attribute4;
678: End If;
679: If (p_rec.vep_attribute5 = hr_api.g_varchar2) then
680: p_rec.vep_attribute5 :=
681: ben_vep_shd.g_old_rec.vep_attribute5;
682: End If;
683: If (p_rec.vep_attribute6 = hr_api.g_varchar2) then
684: p_rec.vep_attribute6 :=
685: ben_vep_shd.g_old_rec.vep_attribute6;

Line 685: ben_vep_shd.g_old_rec.vep_attribute6;

681: ben_vep_shd.g_old_rec.vep_attribute5;
682: End If;
683: If (p_rec.vep_attribute6 = hr_api.g_varchar2) then
684: p_rec.vep_attribute6 :=
685: ben_vep_shd.g_old_rec.vep_attribute6;
686: End If;
687: If (p_rec.vep_attribute7 = hr_api.g_varchar2) then
688: p_rec.vep_attribute7 :=
689: ben_vep_shd.g_old_rec.vep_attribute7;

Line 689: ben_vep_shd.g_old_rec.vep_attribute7;

685: ben_vep_shd.g_old_rec.vep_attribute6;
686: End If;
687: If (p_rec.vep_attribute7 = hr_api.g_varchar2) then
688: p_rec.vep_attribute7 :=
689: ben_vep_shd.g_old_rec.vep_attribute7;
690: End If;
691: If (p_rec.vep_attribute8 = hr_api.g_varchar2) then
692: p_rec.vep_attribute8 :=
693: ben_vep_shd.g_old_rec.vep_attribute8;

Line 693: ben_vep_shd.g_old_rec.vep_attribute8;

689: ben_vep_shd.g_old_rec.vep_attribute7;
690: End If;
691: If (p_rec.vep_attribute8 = hr_api.g_varchar2) then
692: p_rec.vep_attribute8 :=
693: ben_vep_shd.g_old_rec.vep_attribute8;
694: End If;
695: If (p_rec.vep_attribute9 = hr_api.g_varchar2) then
696: p_rec.vep_attribute9 :=
697: ben_vep_shd.g_old_rec.vep_attribute9;

Line 697: ben_vep_shd.g_old_rec.vep_attribute9;

693: ben_vep_shd.g_old_rec.vep_attribute8;
694: End If;
695: If (p_rec.vep_attribute9 = hr_api.g_varchar2) then
696: p_rec.vep_attribute9 :=
697: ben_vep_shd.g_old_rec.vep_attribute9;
698: End If;
699: If (p_rec.vep_attribute10 = hr_api.g_varchar2) then
700: p_rec.vep_attribute10 :=
701: ben_vep_shd.g_old_rec.vep_attribute10;

Line 701: ben_vep_shd.g_old_rec.vep_attribute10;

697: ben_vep_shd.g_old_rec.vep_attribute9;
698: End If;
699: If (p_rec.vep_attribute10 = hr_api.g_varchar2) then
700: p_rec.vep_attribute10 :=
701: ben_vep_shd.g_old_rec.vep_attribute10;
702: End If;
703: If (p_rec.vep_attribute11 = hr_api.g_varchar2) then
704: p_rec.vep_attribute11 :=
705: ben_vep_shd.g_old_rec.vep_attribute11;

Line 705: ben_vep_shd.g_old_rec.vep_attribute11;

701: ben_vep_shd.g_old_rec.vep_attribute10;
702: End If;
703: If (p_rec.vep_attribute11 = hr_api.g_varchar2) then
704: p_rec.vep_attribute11 :=
705: ben_vep_shd.g_old_rec.vep_attribute11;
706: End If;
707: If (p_rec.vep_attribute12 = hr_api.g_varchar2) then
708: p_rec.vep_attribute12 :=
709: ben_vep_shd.g_old_rec.vep_attribute12;

Line 709: ben_vep_shd.g_old_rec.vep_attribute12;

705: ben_vep_shd.g_old_rec.vep_attribute11;
706: End If;
707: If (p_rec.vep_attribute12 = hr_api.g_varchar2) then
708: p_rec.vep_attribute12 :=
709: ben_vep_shd.g_old_rec.vep_attribute12;
710: End If;
711: If (p_rec.vep_attribute13 = hr_api.g_varchar2) then
712: p_rec.vep_attribute13 :=
713: ben_vep_shd.g_old_rec.vep_attribute13;

Line 713: ben_vep_shd.g_old_rec.vep_attribute13;

709: ben_vep_shd.g_old_rec.vep_attribute12;
710: End If;
711: If (p_rec.vep_attribute13 = hr_api.g_varchar2) then
712: p_rec.vep_attribute13 :=
713: ben_vep_shd.g_old_rec.vep_attribute13;
714: End If;
715: If (p_rec.vep_attribute14 = hr_api.g_varchar2) then
716: p_rec.vep_attribute14 :=
717: ben_vep_shd.g_old_rec.vep_attribute14;

Line 717: ben_vep_shd.g_old_rec.vep_attribute14;

713: ben_vep_shd.g_old_rec.vep_attribute13;
714: End If;
715: If (p_rec.vep_attribute14 = hr_api.g_varchar2) then
716: p_rec.vep_attribute14 :=
717: ben_vep_shd.g_old_rec.vep_attribute14;
718: End If;
719: If (p_rec.vep_attribute15 = hr_api.g_varchar2) then
720: p_rec.vep_attribute15 :=
721: ben_vep_shd.g_old_rec.vep_attribute15;

Line 721: ben_vep_shd.g_old_rec.vep_attribute15;

717: ben_vep_shd.g_old_rec.vep_attribute14;
718: End If;
719: If (p_rec.vep_attribute15 = hr_api.g_varchar2) then
720: p_rec.vep_attribute15 :=
721: ben_vep_shd.g_old_rec.vep_attribute15;
722: End If;
723: If (p_rec.vep_attribute16 = hr_api.g_varchar2) then
724: p_rec.vep_attribute16 :=
725: ben_vep_shd.g_old_rec.vep_attribute16;

Line 725: ben_vep_shd.g_old_rec.vep_attribute16;

721: ben_vep_shd.g_old_rec.vep_attribute15;
722: End If;
723: If (p_rec.vep_attribute16 = hr_api.g_varchar2) then
724: p_rec.vep_attribute16 :=
725: ben_vep_shd.g_old_rec.vep_attribute16;
726: End If;
727: If (p_rec.vep_attribute17 = hr_api.g_varchar2) then
728: p_rec.vep_attribute17 :=
729: ben_vep_shd.g_old_rec.vep_attribute17;

Line 729: ben_vep_shd.g_old_rec.vep_attribute17;

725: ben_vep_shd.g_old_rec.vep_attribute16;
726: End If;
727: If (p_rec.vep_attribute17 = hr_api.g_varchar2) then
728: p_rec.vep_attribute17 :=
729: ben_vep_shd.g_old_rec.vep_attribute17;
730: End If;
731: If (p_rec.vep_attribute18 = hr_api.g_varchar2) then
732: p_rec.vep_attribute18 :=
733: ben_vep_shd.g_old_rec.vep_attribute18;

Line 733: ben_vep_shd.g_old_rec.vep_attribute18;

729: ben_vep_shd.g_old_rec.vep_attribute17;
730: End If;
731: If (p_rec.vep_attribute18 = hr_api.g_varchar2) then
732: p_rec.vep_attribute18 :=
733: ben_vep_shd.g_old_rec.vep_attribute18;
734: End If;
735: If (p_rec.vep_attribute19 = hr_api.g_varchar2) then
736: p_rec.vep_attribute19 :=
737: ben_vep_shd.g_old_rec.vep_attribute19;

Line 737: ben_vep_shd.g_old_rec.vep_attribute19;

733: ben_vep_shd.g_old_rec.vep_attribute18;
734: End If;
735: If (p_rec.vep_attribute19 = hr_api.g_varchar2) then
736: p_rec.vep_attribute19 :=
737: ben_vep_shd.g_old_rec.vep_attribute19;
738: End If;
739: If (p_rec.vep_attribute20 = hr_api.g_varchar2) then
740: p_rec.vep_attribute20 :=
741: ben_vep_shd.g_old_rec.vep_attribute20;

Line 741: ben_vep_shd.g_old_rec.vep_attribute20;

737: ben_vep_shd.g_old_rec.vep_attribute19;
738: End If;
739: If (p_rec.vep_attribute20 = hr_api.g_varchar2) then
740: p_rec.vep_attribute20 :=
741: ben_vep_shd.g_old_rec.vep_attribute20;
742: End If;
743: If (p_rec.vep_attribute21 = hr_api.g_varchar2) then
744: p_rec.vep_attribute21 :=
745: ben_vep_shd.g_old_rec.vep_attribute21;

Line 745: ben_vep_shd.g_old_rec.vep_attribute21;

741: ben_vep_shd.g_old_rec.vep_attribute20;
742: End If;
743: If (p_rec.vep_attribute21 = hr_api.g_varchar2) then
744: p_rec.vep_attribute21 :=
745: ben_vep_shd.g_old_rec.vep_attribute21;
746: End If;
747: If (p_rec.vep_attribute22 = hr_api.g_varchar2) then
748: p_rec.vep_attribute22 :=
749: ben_vep_shd.g_old_rec.vep_attribute22;

Line 749: ben_vep_shd.g_old_rec.vep_attribute22;

745: ben_vep_shd.g_old_rec.vep_attribute21;
746: End If;
747: If (p_rec.vep_attribute22 = hr_api.g_varchar2) then
748: p_rec.vep_attribute22 :=
749: ben_vep_shd.g_old_rec.vep_attribute22;
750: End If;
751: If (p_rec.vep_attribute23 = hr_api.g_varchar2) then
752: p_rec.vep_attribute23 :=
753: ben_vep_shd.g_old_rec.vep_attribute23;

Line 753: ben_vep_shd.g_old_rec.vep_attribute23;

749: ben_vep_shd.g_old_rec.vep_attribute22;
750: End If;
751: If (p_rec.vep_attribute23 = hr_api.g_varchar2) then
752: p_rec.vep_attribute23 :=
753: ben_vep_shd.g_old_rec.vep_attribute23;
754: End If;
755: If (p_rec.vep_attribute24 = hr_api.g_varchar2) then
756: p_rec.vep_attribute24 :=
757: ben_vep_shd.g_old_rec.vep_attribute24;

Line 757: ben_vep_shd.g_old_rec.vep_attribute24;

753: ben_vep_shd.g_old_rec.vep_attribute23;
754: End If;
755: If (p_rec.vep_attribute24 = hr_api.g_varchar2) then
756: p_rec.vep_attribute24 :=
757: ben_vep_shd.g_old_rec.vep_attribute24;
758: End If;
759: If (p_rec.vep_attribute25 = hr_api.g_varchar2) then
760: p_rec.vep_attribute25 :=
761: ben_vep_shd.g_old_rec.vep_attribute25;

Line 761: ben_vep_shd.g_old_rec.vep_attribute25;

757: ben_vep_shd.g_old_rec.vep_attribute24;
758: End If;
759: If (p_rec.vep_attribute25 = hr_api.g_varchar2) then
760: p_rec.vep_attribute25 :=
761: ben_vep_shd.g_old_rec.vep_attribute25;
762: End If;
763: If (p_rec.vep_attribute26 = hr_api.g_varchar2) then
764: p_rec.vep_attribute26 :=
765: ben_vep_shd.g_old_rec.vep_attribute26;

Line 765: ben_vep_shd.g_old_rec.vep_attribute26;

761: ben_vep_shd.g_old_rec.vep_attribute25;
762: End If;
763: If (p_rec.vep_attribute26 = hr_api.g_varchar2) then
764: p_rec.vep_attribute26 :=
765: ben_vep_shd.g_old_rec.vep_attribute26;
766: End If;
767: If (p_rec.vep_attribute27 = hr_api.g_varchar2) then
768: p_rec.vep_attribute27 :=
769: ben_vep_shd.g_old_rec.vep_attribute27;

Line 769: ben_vep_shd.g_old_rec.vep_attribute27;

765: ben_vep_shd.g_old_rec.vep_attribute26;
766: End If;
767: If (p_rec.vep_attribute27 = hr_api.g_varchar2) then
768: p_rec.vep_attribute27 :=
769: ben_vep_shd.g_old_rec.vep_attribute27;
770: End If;
771: If (p_rec.vep_attribute28 = hr_api.g_varchar2) then
772: p_rec.vep_attribute28 :=
773: ben_vep_shd.g_old_rec.vep_attribute28;

Line 773: ben_vep_shd.g_old_rec.vep_attribute28;

769: ben_vep_shd.g_old_rec.vep_attribute27;
770: End If;
771: If (p_rec.vep_attribute28 = hr_api.g_varchar2) then
772: p_rec.vep_attribute28 :=
773: ben_vep_shd.g_old_rec.vep_attribute28;
774: End If;
775: If (p_rec.vep_attribute29 = hr_api.g_varchar2) then
776: p_rec.vep_attribute29 :=
777: ben_vep_shd.g_old_rec.vep_attribute29;

Line 777: ben_vep_shd.g_old_rec.vep_attribute29;

773: ben_vep_shd.g_old_rec.vep_attribute28;
774: End If;
775: If (p_rec.vep_attribute29 = hr_api.g_varchar2) then
776: p_rec.vep_attribute29 :=
777: ben_vep_shd.g_old_rec.vep_attribute29;
778: End If;
779: If (p_rec.vep_attribute30 = hr_api.g_varchar2) then
780: p_rec.vep_attribute30 :=
781: ben_vep_shd.g_old_rec.vep_attribute30;

Line 781: ben_vep_shd.g_old_rec.vep_attribute30;

777: ben_vep_shd.g_old_rec.vep_attribute29;
778: End If;
779: If (p_rec.vep_attribute30 = hr_api.g_varchar2) then
780: p_rec.vep_attribute30 :=
781: ben_vep_shd.g_old_rec.vep_attribute30;
782: End If;
783: --
784: End convert_defs;
785: --

Line 792: ,p_rec in out nocopy ben_vep_shd.g_rec_type

788: -- ----------------------------------------------------------------------------
789: Procedure upd
790: (p_effective_date in date
791: ,p_datetrack_mode in varchar2
792: ,p_rec in out nocopy ben_vep_shd.g_rec_type
793: ) is
794: --
795: l_proc varchar2(72) := g_package||'upd';
796: l_validation_start_date date;

Line 808: ben_vep_shd.lck

804: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
805: --
806: -- We must lock the row which we need to update.
807: --
808: ben_vep_shd.lck
809: (p_effective_date => p_effective_date
810: ,p_datetrack_mode => p_datetrack_mode
811: ,p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
812: ,p_object_version_number => p_rec.object_version_number

Line 911: l_rec ben_vep_shd.g_rec_type;

907: ,p_effective_start_date out nocopy date
908: ,p_effective_end_date out nocopy date
909: ) is
910: --
911: l_rec ben_vep_shd.g_rec_type;
912: l_proc varchar2(72) := g_package||'upd';
913: --
914: Begin
915: hr_utility.set_location('Entering:'||l_proc, 5);

Line 921: ben_vep_shd.convert_args

917: -- Call conversion function to turn arguments into the
918: -- l_rec structure.
919: --
920: l_rec :=
921: ben_vep_shd.convert_args
922: (p_vrbl_rt_elig_prfl_id
923: ,null
924: ,null
925: ,p_business_group_id