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_EPT_UPD dependencies on BEN_EPT_SHD

Line 58: (p_rec in out nocopy ben_ept_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ept_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) is

Line 81: ben_ept_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_elig_per_typ_prte_f',
78: p_base_key_column => 'elig_per_typ_prte_id',
79: p_base_key_value => p_rec.elig_per_typ_prte_id);
80: --
81: ben_ept_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_per_typ_prte_f Row
84: --
85: update ben_elig_per_typ_prte_f

Line 133: ben_ept_shd.g_api_dml := false; -- Unset the api dml status

129: where elig_per_typ_prte_id = p_rec.elig_per_typ_prte_id
130: and effective_start_date = p_validation_start_date
131: and effective_end_date = p_validation_end_date;
132: --
133: ben_ept_shd.g_api_dml := false; -- Unset the api dml status
134: --
135: -- Set the effective start and end dates
136: --
137: p_rec.effective_start_date := p_validation_start_date;

Line 145: ben_ept_shd.g_api_dml := false; -- Unset the api dml status

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

Line 146: ben_ept_shd.constraint_error

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

Line 150: ben_ept_shd.g_api_dml := false; -- Unset the api dml status

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

Line 151: ben_ept_shd.constraint_error

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

Line 154: ben_ept_shd.g_api_dml := false; -- Unset the api dml status

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

Line 190: (p_rec in out nocopy ben_ept_shd.g_rec_type,

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure update_dml
190: (p_rec in out nocopy ben_ept_shd.g_rec_type,
191: p_effective_date in date,
192: p_datetrack_mode in varchar2,
193: p_validation_start_date in date,
194: p_validation_end_date in date) is

Line 254: (p_rec in out nocopy ben_ept_shd.g_rec_type,

250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure dt_pre_update
254: (p_rec in out nocopy ben_ept_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) is

Line 270: ben_ept_shd.upd_effective_end_date

266: hr_utility.set_location(l_proc, 10);
267: --
268: -- Update the current effective end date
269: --
270: ben_ept_shd.upd_effective_end_date
271: (p_effective_date => p_effective_date,
272: p_base_key_value => p_rec.elig_per_typ_prte_id,
273: p_new_effective_end_date => (p_validation_start_date - 1),
274: p_validation_start_date => p_validation_start_date,

Line 339: (p_rec in out nocopy ben_ept_shd.g_rec_type,

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

Line 395: (p_rec in ben_ept_shd.g_rec_type,

391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure post_update
395: (p_rec in ben_ept_shd.g_rec_type,
396: p_effective_date in date,
397: p_datetrack_mode in varchar2,
398: p_validation_start_date in date,
399: p_validation_end_date in date) is

Line 458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date

454: ,p_effective_date =>p_effective_date
455: ,p_datetrack_mode =>p_datetrack_mode
456: ,p_validation_start_date =>p_validation_start_date
457: ,p_validation_end_date =>p_validation_end_date
458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd

Line 459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date

455: ,p_datetrack_mode =>p_datetrack_mode
456: ,p_validation_start_date =>p_validation_start_date
457: ,p_validation_end_date =>p_validation_end_date
458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id

Line 460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id

456: ,p_validation_start_date =>p_validation_start_date
457: ,p_validation_end_date =>p_validation_end_date
458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num

Line 461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id

457: ,p_validation_end_date =>p_validation_end_date
458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag

Line 462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd

458: ,p_effective_start_date_o =>ben_ept_shd.g_old_rec.effective_start_date
459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category

Line 463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id

459: ,p_effective_end_date_o =>ben_ept_shd.g_old_rec.effective_end_date
460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1

Line 464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num

460: ,p_business_group_id_o =>ben_ept_shd.g_old_rec.business_group_id
461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2

Line 465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag

461: ,p_eligy_prfl_id_o =>ben_ept_shd.g_old_rec.eligy_prfl_id
462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3

Line 466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category

462: ,p_per_typ_cd_o =>ben_ept_shd.g_old_rec.per_typ_cd
463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4

Line 467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1

463: ,p_person_type_id_o =>ben_ept_shd.g_old_rec.person_type_id
464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5

Line 468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2

464: ,p_ordr_num_o =>ben_ept_shd.g_old_rec.ordr_num
465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6

Line 469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3

465: ,p_excld_flag_o =>ben_ept_shd.g_old_rec.excld_flag
466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7

Line 470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4

466: ,p_ept_attribute_category_o =>ben_ept_shd.g_old_rec.ept_attribute_category
467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8

Line 471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5

467: ,p_ept_attribute1_o =>ben_ept_shd.g_old_rec.ept_attribute1
468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9

Line 472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6

468: ,p_ept_attribute2_o =>ben_ept_shd.g_old_rec.ept_attribute2
469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10

Line 473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7

469: ,p_ept_attribute3_o =>ben_ept_shd.g_old_rec.ept_attribute3
470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11

Line 474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8

470: ,p_ept_attribute4_o =>ben_ept_shd.g_old_rec.ept_attribute4
471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12

Line 475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9

471: ,p_ept_attribute5_o =>ben_ept_shd.g_old_rec.ept_attribute5
472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13

Line 476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10

472: ,p_ept_attribute6_o =>ben_ept_shd.g_old_rec.ept_attribute6
473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14

Line 477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11

473: ,p_ept_attribute7_o =>ben_ept_shd.g_old_rec.ept_attribute7
474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15

Line 478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12

474: ,p_ept_attribute8_o =>ben_ept_shd.g_old_rec.ept_attribute8
475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16

Line 479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13

475: ,p_ept_attribute9_o =>ben_ept_shd.g_old_rec.ept_attribute9
476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17

Line 480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14

476: ,p_ept_attribute10_o =>ben_ept_shd.g_old_rec.ept_attribute10
477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18

Line 481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15

477: ,p_ept_attribute11_o =>ben_ept_shd.g_old_rec.ept_attribute11
478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19

Line 482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16

478: ,p_ept_attribute12_o =>ben_ept_shd.g_old_rec.ept_attribute12
479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20

Line 483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17

479: ,p_ept_attribute13_o =>ben_ept_shd.g_old_rec.ept_attribute13
480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21

Line 484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18

480: ,p_ept_attribute14_o =>ben_ept_shd.g_old_rec.ept_attribute14
481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22

Line 485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19

481: ,p_ept_attribute15_o =>ben_ept_shd.g_old_rec.ept_attribute15
482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23

Line 486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20

482: ,p_ept_attribute16_o =>ben_ept_shd.g_old_rec.ept_attribute16
483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24

Line 487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21

483: ,p_ept_attribute17_o =>ben_ept_shd.g_old_rec.ept_attribute17
484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25

Line 488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22

484: ,p_ept_attribute18_o =>ben_ept_shd.g_old_rec.ept_attribute18
485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26

Line 489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23

485: ,p_ept_attribute19_o =>ben_ept_shd.g_old_rec.ept_attribute19
486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27

Line 490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24

486: ,p_ept_attribute20_o =>ben_ept_shd.g_old_rec.ept_attribute20
487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28

Line 491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25

487: ,p_ept_attribute21_o =>ben_ept_shd.g_old_rec.ept_attribute21
488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29

Line 492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26

488: ,p_ept_attribute22_o =>ben_ept_shd.g_old_rec.ept_attribute22
489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30

Line 493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27

489: ,p_ept_attribute23_o =>ben_ept_shd.g_old_rec.ept_attribute23
490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number

Line 494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28

490: ,p_ept_attribute24_o =>ben_ept_shd.g_old_rec.ept_attribute24
491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score

Line 495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29

491: ,p_ept_attribute25_o =>ben_ept_shd.g_old_rec.ept_attribute25
492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score
499: ,p_criteria_weight =>p_rec.criteria_weight

Line 496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30

492: ,p_ept_attribute26_o =>ben_ept_shd.g_old_rec.ept_attribute26
493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score
499: ,p_criteria_weight =>p_rec.criteria_weight
500: ,p_criteria_score_o =>ben_ept_shd.g_old_rec.criteria_score

Line 497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number

493: ,p_ept_attribute27_o =>ben_ept_shd.g_old_rec.ept_attribute27
494: ,p_ept_attribute28_o =>ben_ept_shd.g_old_rec.ept_attribute28
495: ,p_ept_attribute29_o =>ben_ept_shd.g_old_rec.ept_attribute29
496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score
499: ,p_criteria_weight =>p_rec.criteria_weight
500: ,p_criteria_score_o =>ben_ept_shd.g_old_rec.criteria_score
501: ,p_criteria_weight_o =>ben_ept_shd.g_old_rec.criteria_weight

Line 500: ,p_criteria_score_o =>ben_ept_shd.g_old_rec.criteria_score

496: ,p_ept_attribute30_o =>ben_ept_shd.g_old_rec.ept_attribute30
497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score
499: ,p_criteria_weight =>p_rec.criteria_weight
500: ,p_criteria_score_o =>ben_ept_shd.g_old_rec.criteria_score
501: ,p_criteria_weight_o =>ben_ept_shd.g_old_rec.criteria_weight
502:
503:
504: );

Line 501: ,p_criteria_weight_o =>ben_ept_shd.g_old_rec.criteria_weight

497: ,p_object_version_number_o =>ben_ept_shd.g_old_rec.object_version_number
498: ,p_criteria_score =>p_rec.criteria_score
499: ,p_criteria_weight =>p_rec.criteria_weight
500: ,p_criteria_score_o =>ben_ept_shd.g_old_rec.criteria_score
501: ,p_criteria_weight_o =>ben_ept_shd.g_old_rec.criteria_weight
502:
503:
504: );
505: --

Line 565: Procedure convert_defs(p_rec in out nocopy ben_ept_shd.g_rec_type) is

561: -- Internal Row Handler Use Only.
562: --
563: -- {End Of Comments}
564: -- ----------------------------------------------------------------------------
565: Procedure convert_defs(p_rec in out nocopy ben_ept_shd.g_rec_type) is
566: --
567: l_proc varchar2(72) := g_package||'convert_defs';
568: --
569: Begin

Line 580: ben_ept_shd.g_old_rec.business_group_id;

576: -- is being used then we must set to the 'current' argument value.
577: --
578: If (p_rec.business_group_id = hr_api.g_number) then
579: p_rec.business_group_id :=
580: ben_ept_shd.g_old_rec.business_group_id;
581: End If;
582: If (p_rec.eligy_prfl_id = hr_api.g_number) then
583: p_rec.eligy_prfl_id :=
584: ben_ept_shd.g_old_rec.eligy_prfl_id;

Line 584: ben_ept_shd.g_old_rec.eligy_prfl_id;

580: ben_ept_shd.g_old_rec.business_group_id;
581: End If;
582: If (p_rec.eligy_prfl_id = hr_api.g_number) then
583: p_rec.eligy_prfl_id :=
584: ben_ept_shd.g_old_rec.eligy_prfl_id;
585: End If;
586: If (p_rec.per_typ_cd = hr_api.g_varchar2) then
587: p_rec.per_typ_cd :=
588: ben_ept_shd.g_old_rec.per_typ_cd;

Line 588: ben_ept_shd.g_old_rec.per_typ_cd;

584: ben_ept_shd.g_old_rec.eligy_prfl_id;
585: End If;
586: If (p_rec.per_typ_cd = hr_api.g_varchar2) then
587: p_rec.per_typ_cd :=
588: ben_ept_shd.g_old_rec.per_typ_cd;
589: End If;
590: If (p_rec.person_type_id = hr_api.g_number) then
591: p_rec.person_type_id :=
592: ben_ept_shd.g_old_rec.person_type_id;

Line 592: ben_ept_shd.g_old_rec.person_type_id;

588: ben_ept_shd.g_old_rec.per_typ_cd;
589: End If;
590: If (p_rec.person_type_id = hr_api.g_number) then
591: p_rec.person_type_id :=
592: ben_ept_shd.g_old_rec.person_type_id;
593: End If;
594: If (p_rec.ordr_num = hr_api.g_number) then
595: p_rec.ordr_num :=
596: ben_ept_shd.g_old_rec.ordr_num;

Line 596: ben_ept_shd.g_old_rec.ordr_num;

592: ben_ept_shd.g_old_rec.person_type_id;
593: End If;
594: If (p_rec.ordr_num = hr_api.g_number) then
595: p_rec.ordr_num :=
596: ben_ept_shd.g_old_rec.ordr_num;
597: End If;
598: If (p_rec.excld_flag = hr_api.g_varchar2) then
599: p_rec.excld_flag :=
600: ben_ept_shd.g_old_rec.excld_flag;

Line 600: ben_ept_shd.g_old_rec.excld_flag;

596: ben_ept_shd.g_old_rec.ordr_num;
597: End If;
598: If (p_rec.excld_flag = hr_api.g_varchar2) then
599: p_rec.excld_flag :=
600: ben_ept_shd.g_old_rec.excld_flag;
601: End If;
602: If (p_rec.ept_attribute_category = hr_api.g_varchar2) then
603: p_rec.ept_attribute_category :=
604: ben_ept_shd.g_old_rec.ept_attribute_category;

Line 604: ben_ept_shd.g_old_rec.ept_attribute_category;

600: ben_ept_shd.g_old_rec.excld_flag;
601: End If;
602: If (p_rec.ept_attribute_category = hr_api.g_varchar2) then
603: p_rec.ept_attribute_category :=
604: ben_ept_shd.g_old_rec.ept_attribute_category;
605: End If;
606: If (p_rec.ept_attribute1 = hr_api.g_varchar2) then
607: p_rec.ept_attribute1 :=
608: ben_ept_shd.g_old_rec.ept_attribute1;

Line 608: ben_ept_shd.g_old_rec.ept_attribute1;

604: ben_ept_shd.g_old_rec.ept_attribute_category;
605: End If;
606: If (p_rec.ept_attribute1 = hr_api.g_varchar2) then
607: p_rec.ept_attribute1 :=
608: ben_ept_shd.g_old_rec.ept_attribute1;
609: End If;
610: If (p_rec.ept_attribute2 = hr_api.g_varchar2) then
611: p_rec.ept_attribute2 :=
612: ben_ept_shd.g_old_rec.ept_attribute2;

Line 612: ben_ept_shd.g_old_rec.ept_attribute2;

608: ben_ept_shd.g_old_rec.ept_attribute1;
609: End If;
610: If (p_rec.ept_attribute2 = hr_api.g_varchar2) then
611: p_rec.ept_attribute2 :=
612: ben_ept_shd.g_old_rec.ept_attribute2;
613: End If;
614: If (p_rec.ept_attribute3 = hr_api.g_varchar2) then
615: p_rec.ept_attribute3 :=
616: ben_ept_shd.g_old_rec.ept_attribute3;

Line 616: ben_ept_shd.g_old_rec.ept_attribute3;

612: ben_ept_shd.g_old_rec.ept_attribute2;
613: End If;
614: If (p_rec.ept_attribute3 = hr_api.g_varchar2) then
615: p_rec.ept_attribute3 :=
616: ben_ept_shd.g_old_rec.ept_attribute3;
617: End If;
618: If (p_rec.ept_attribute4 = hr_api.g_varchar2) then
619: p_rec.ept_attribute4 :=
620: ben_ept_shd.g_old_rec.ept_attribute4;

Line 620: ben_ept_shd.g_old_rec.ept_attribute4;

616: ben_ept_shd.g_old_rec.ept_attribute3;
617: End If;
618: If (p_rec.ept_attribute4 = hr_api.g_varchar2) then
619: p_rec.ept_attribute4 :=
620: ben_ept_shd.g_old_rec.ept_attribute4;
621: End If;
622: If (p_rec.ept_attribute5 = hr_api.g_varchar2) then
623: p_rec.ept_attribute5 :=
624: ben_ept_shd.g_old_rec.ept_attribute5;

Line 624: ben_ept_shd.g_old_rec.ept_attribute5;

620: ben_ept_shd.g_old_rec.ept_attribute4;
621: End If;
622: If (p_rec.ept_attribute5 = hr_api.g_varchar2) then
623: p_rec.ept_attribute5 :=
624: ben_ept_shd.g_old_rec.ept_attribute5;
625: End If;
626: If (p_rec.ept_attribute6 = hr_api.g_varchar2) then
627: p_rec.ept_attribute6 :=
628: ben_ept_shd.g_old_rec.ept_attribute6;

Line 628: ben_ept_shd.g_old_rec.ept_attribute6;

624: ben_ept_shd.g_old_rec.ept_attribute5;
625: End If;
626: If (p_rec.ept_attribute6 = hr_api.g_varchar2) then
627: p_rec.ept_attribute6 :=
628: ben_ept_shd.g_old_rec.ept_attribute6;
629: End If;
630: If (p_rec.ept_attribute7 = hr_api.g_varchar2) then
631: p_rec.ept_attribute7 :=
632: ben_ept_shd.g_old_rec.ept_attribute7;

Line 632: ben_ept_shd.g_old_rec.ept_attribute7;

628: ben_ept_shd.g_old_rec.ept_attribute6;
629: End If;
630: If (p_rec.ept_attribute7 = hr_api.g_varchar2) then
631: p_rec.ept_attribute7 :=
632: ben_ept_shd.g_old_rec.ept_attribute7;
633: End If;
634: If (p_rec.ept_attribute8 = hr_api.g_varchar2) then
635: p_rec.ept_attribute8 :=
636: ben_ept_shd.g_old_rec.ept_attribute8;

Line 636: ben_ept_shd.g_old_rec.ept_attribute8;

632: ben_ept_shd.g_old_rec.ept_attribute7;
633: End If;
634: If (p_rec.ept_attribute8 = hr_api.g_varchar2) then
635: p_rec.ept_attribute8 :=
636: ben_ept_shd.g_old_rec.ept_attribute8;
637: End If;
638: If (p_rec.ept_attribute9 = hr_api.g_varchar2) then
639: p_rec.ept_attribute9 :=
640: ben_ept_shd.g_old_rec.ept_attribute9;

Line 640: ben_ept_shd.g_old_rec.ept_attribute9;

636: ben_ept_shd.g_old_rec.ept_attribute8;
637: End If;
638: If (p_rec.ept_attribute9 = hr_api.g_varchar2) then
639: p_rec.ept_attribute9 :=
640: ben_ept_shd.g_old_rec.ept_attribute9;
641: End If;
642: If (p_rec.ept_attribute10 = hr_api.g_varchar2) then
643: p_rec.ept_attribute10 :=
644: ben_ept_shd.g_old_rec.ept_attribute10;

Line 644: ben_ept_shd.g_old_rec.ept_attribute10;

640: ben_ept_shd.g_old_rec.ept_attribute9;
641: End If;
642: If (p_rec.ept_attribute10 = hr_api.g_varchar2) then
643: p_rec.ept_attribute10 :=
644: ben_ept_shd.g_old_rec.ept_attribute10;
645: End If;
646: If (p_rec.ept_attribute11 = hr_api.g_varchar2) then
647: p_rec.ept_attribute11 :=
648: ben_ept_shd.g_old_rec.ept_attribute11;

Line 648: ben_ept_shd.g_old_rec.ept_attribute11;

644: ben_ept_shd.g_old_rec.ept_attribute10;
645: End If;
646: If (p_rec.ept_attribute11 = hr_api.g_varchar2) then
647: p_rec.ept_attribute11 :=
648: ben_ept_shd.g_old_rec.ept_attribute11;
649: End If;
650: If (p_rec.ept_attribute12 = hr_api.g_varchar2) then
651: p_rec.ept_attribute12 :=
652: ben_ept_shd.g_old_rec.ept_attribute12;

Line 652: ben_ept_shd.g_old_rec.ept_attribute12;

648: ben_ept_shd.g_old_rec.ept_attribute11;
649: End If;
650: If (p_rec.ept_attribute12 = hr_api.g_varchar2) then
651: p_rec.ept_attribute12 :=
652: ben_ept_shd.g_old_rec.ept_attribute12;
653: End If;
654: If (p_rec.ept_attribute13 = hr_api.g_varchar2) then
655: p_rec.ept_attribute13 :=
656: ben_ept_shd.g_old_rec.ept_attribute13;

Line 656: ben_ept_shd.g_old_rec.ept_attribute13;

652: ben_ept_shd.g_old_rec.ept_attribute12;
653: End If;
654: If (p_rec.ept_attribute13 = hr_api.g_varchar2) then
655: p_rec.ept_attribute13 :=
656: ben_ept_shd.g_old_rec.ept_attribute13;
657: End If;
658: If (p_rec.ept_attribute14 = hr_api.g_varchar2) then
659: p_rec.ept_attribute14 :=
660: ben_ept_shd.g_old_rec.ept_attribute14;

Line 660: ben_ept_shd.g_old_rec.ept_attribute14;

656: ben_ept_shd.g_old_rec.ept_attribute13;
657: End If;
658: If (p_rec.ept_attribute14 = hr_api.g_varchar2) then
659: p_rec.ept_attribute14 :=
660: ben_ept_shd.g_old_rec.ept_attribute14;
661: End If;
662: If (p_rec.ept_attribute15 = hr_api.g_varchar2) then
663: p_rec.ept_attribute15 :=
664: ben_ept_shd.g_old_rec.ept_attribute15;

Line 664: ben_ept_shd.g_old_rec.ept_attribute15;

660: ben_ept_shd.g_old_rec.ept_attribute14;
661: End If;
662: If (p_rec.ept_attribute15 = hr_api.g_varchar2) then
663: p_rec.ept_attribute15 :=
664: ben_ept_shd.g_old_rec.ept_attribute15;
665: End If;
666: If (p_rec.ept_attribute16 = hr_api.g_varchar2) then
667: p_rec.ept_attribute16 :=
668: ben_ept_shd.g_old_rec.ept_attribute16;

Line 668: ben_ept_shd.g_old_rec.ept_attribute16;

664: ben_ept_shd.g_old_rec.ept_attribute15;
665: End If;
666: If (p_rec.ept_attribute16 = hr_api.g_varchar2) then
667: p_rec.ept_attribute16 :=
668: ben_ept_shd.g_old_rec.ept_attribute16;
669: End If;
670: If (p_rec.ept_attribute17 = hr_api.g_varchar2) then
671: p_rec.ept_attribute17 :=
672: ben_ept_shd.g_old_rec.ept_attribute17;

Line 672: ben_ept_shd.g_old_rec.ept_attribute17;

668: ben_ept_shd.g_old_rec.ept_attribute16;
669: End If;
670: If (p_rec.ept_attribute17 = hr_api.g_varchar2) then
671: p_rec.ept_attribute17 :=
672: ben_ept_shd.g_old_rec.ept_attribute17;
673: End If;
674: If (p_rec.ept_attribute18 = hr_api.g_varchar2) then
675: p_rec.ept_attribute18 :=
676: ben_ept_shd.g_old_rec.ept_attribute18;

Line 676: ben_ept_shd.g_old_rec.ept_attribute18;

672: ben_ept_shd.g_old_rec.ept_attribute17;
673: End If;
674: If (p_rec.ept_attribute18 = hr_api.g_varchar2) then
675: p_rec.ept_attribute18 :=
676: ben_ept_shd.g_old_rec.ept_attribute18;
677: End If;
678: If (p_rec.ept_attribute19 = hr_api.g_varchar2) then
679: p_rec.ept_attribute19 :=
680: ben_ept_shd.g_old_rec.ept_attribute19;

Line 680: ben_ept_shd.g_old_rec.ept_attribute19;

676: ben_ept_shd.g_old_rec.ept_attribute18;
677: End If;
678: If (p_rec.ept_attribute19 = hr_api.g_varchar2) then
679: p_rec.ept_attribute19 :=
680: ben_ept_shd.g_old_rec.ept_attribute19;
681: End If;
682: If (p_rec.ept_attribute20 = hr_api.g_varchar2) then
683: p_rec.ept_attribute20 :=
684: ben_ept_shd.g_old_rec.ept_attribute20;

Line 684: ben_ept_shd.g_old_rec.ept_attribute20;

680: ben_ept_shd.g_old_rec.ept_attribute19;
681: End If;
682: If (p_rec.ept_attribute20 = hr_api.g_varchar2) then
683: p_rec.ept_attribute20 :=
684: ben_ept_shd.g_old_rec.ept_attribute20;
685: End If;
686: If (p_rec.ept_attribute21 = hr_api.g_varchar2) then
687: p_rec.ept_attribute21 :=
688: ben_ept_shd.g_old_rec.ept_attribute21;

Line 688: ben_ept_shd.g_old_rec.ept_attribute21;

684: ben_ept_shd.g_old_rec.ept_attribute20;
685: End If;
686: If (p_rec.ept_attribute21 = hr_api.g_varchar2) then
687: p_rec.ept_attribute21 :=
688: ben_ept_shd.g_old_rec.ept_attribute21;
689: End If;
690: If (p_rec.ept_attribute22 = hr_api.g_varchar2) then
691: p_rec.ept_attribute22 :=
692: ben_ept_shd.g_old_rec.ept_attribute22;

Line 692: ben_ept_shd.g_old_rec.ept_attribute22;

688: ben_ept_shd.g_old_rec.ept_attribute21;
689: End If;
690: If (p_rec.ept_attribute22 = hr_api.g_varchar2) then
691: p_rec.ept_attribute22 :=
692: ben_ept_shd.g_old_rec.ept_attribute22;
693: End If;
694: If (p_rec.ept_attribute23 = hr_api.g_varchar2) then
695: p_rec.ept_attribute23 :=
696: ben_ept_shd.g_old_rec.ept_attribute23;

Line 696: ben_ept_shd.g_old_rec.ept_attribute23;

692: ben_ept_shd.g_old_rec.ept_attribute22;
693: End If;
694: If (p_rec.ept_attribute23 = hr_api.g_varchar2) then
695: p_rec.ept_attribute23 :=
696: ben_ept_shd.g_old_rec.ept_attribute23;
697: End If;
698: If (p_rec.ept_attribute24 = hr_api.g_varchar2) then
699: p_rec.ept_attribute24 :=
700: ben_ept_shd.g_old_rec.ept_attribute24;

Line 700: ben_ept_shd.g_old_rec.ept_attribute24;

696: ben_ept_shd.g_old_rec.ept_attribute23;
697: End If;
698: If (p_rec.ept_attribute24 = hr_api.g_varchar2) then
699: p_rec.ept_attribute24 :=
700: ben_ept_shd.g_old_rec.ept_attribute24;
701: End If;
702: If (p_rec.ept_attribute25 = hr_api.g_varchar2) then
703: p_rec.ept_attribute25 :=
704: ben_ept_shd.g_old_rec.ept_attribute25;

Line 704: ben_ept_shd.g_old_rec.ept_attribute25;

700: ben_ept_shd.g_old_rec.ept_attribute24;
701: End If;
702: If (p_rec.ept_attribute25 = hr_api.g_varchar2) then
703: p_rec.ept_attribute25 :=
704: ben_ept_shd.g_old_rec.ept_attribute25;
705: End If;
706: If (p_rec.ept_attribute26 = hr_api.g_varchar2) then
707: p_rec.ept_attribute26 :=
708: ben_ept_shd.g_old_rec.ept_attribute26;

Line 708: ben_ept_shd.g_old_rec.ept_attribute26;

704: ben_ept_shd.g_old_rec.ept_attribute25;
705: End If;
706: If (p_rec.ept_attribute26 = hr_api.g_varchar2) then
707: p_rec.ept_attribute26 :=
708: ben_ept_shd.g_old_rec.ept_attribute26;
709: End If;
710: If (p_rec.ept_attribute27 = hr_api.g_varchar2) then
711: p_rec.ept_attribute27 :=
712: ben_ept_shd.g_old_rec.ept_attribute27;

Line 712: ben_ept_shd.g_old_rec.ept_attribute27;

708: ben_ept_shd.g_old_rec.ept_attribute26;
709: End If;
710: If (p_rec.ept_attribute27 = hr_api.g_varchar2) then
711: p_rec.ept_attribute27 :=
712: ben_ept_shd.g_old_rec.ept_attribute27;
713: End If;
714: If (p_rec.ept_attribute28 = hr_api.g_varchar2) then
715: p_rec.ept_attribute28 :=
716: ben_ept_shd.g_old_rec.ept_attribute28;

Line 716: ben_ept_shd.g_old_rec.ept_attribute28;

712: ben_ept_shd.g_old_rec.ept_attribute27;
713: End If;
714: If (p_rec.ept_attribute28 = hr_api.g_varchar2) then
715: p_rec.ept_attribute28 :=
716: ben_ept_shd.g_old_rec.ept_attribute28;
717: End If;
718: If (p_rec.ept_attribute29 = hr_api.g_varchar2) then
719: p_rec.ept_attribute29 :=
720: ben_ept_shd.g_old_rec.ept_attribute29;

Line 720: ben_ept_shd.g_old_rec.ept_attribute29;

716: ben_ept_shd.g_old_rec.ept_attribute28;
717: End If;
718: If (p_rec.ept_attribute29 = hr_api.g_varchar2) then
719: p_rec.ept_attribute29 :=
720: ben_ept_shd.g_old_rec.ept_attribute29;
721: End If;
722:
723: If (p_rec.ept_attribute30 = hr_api.g_varchar2) then
724: p_rec.ept_attribute30 :=

Line 725: ben_ept_shd.g_old_rec.ept_attribute30;

721: End If;
722:
723: If (p_rec.ept_attribute30 = hr_api.g_varchar2) then
724: p_rec.ept_attribute30 :=
725: ben_ept_shd.g_old_rec.ept_attribute30;
726: End If;
727:
728: If (p_rec.criteria_score = hr_api.g_number) then
729: p_rec.criteria_score :=

Line 730: ben_ept_shd.g_old_rec.criteria_score;

726: End If;
727:
728: If (p_rec.criteria_score = hr_api.g_number) then
729: p_rec.criteria_score :=
730: ben_ept_shd.g_old_rec.criteria_score;
731: End If;
732:
733: If (p_rec.criteria_weight = hr_api.g_number) then
734: p_rec.criteria_weight :=

Line 735: ben_ept_shd.g_old_rec.criteria_weight;

731: End If;
732:
733: If (p_rec.criteria_weight = hr_api.g_number) then
734: p_rec.criteria_weight :=
735: ben_ept_shd.g_old_rec.criteria_weight;
736: End If;
737:
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 748: p_rec in out nocopy ben_ept_shd.g_rec_type,

744: -- |---------------------------------< upd >----------------------------------|
745: -- ----------------------------------------------------------------------------
746: Procedure upd
747: (
748: p_rec in out nocopy ben_ept_shd.g_rec_type,
749: p_effective_date in date,
750: p_datetrack_mode in varchar2
751: ) is
752: --

Line 766: ben_ept_shd.lck

762: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
763: --
764: -- We must lock the row which we need to update.
765: --
766: ben_ept_shd.lck
767: (p_effective_date => p_effective_date,
768: p_datetrack_mode => p_datetrack_mode,
769: p_elig_per_typ_prte_id => p_rec.elig_per_typ_prte_id,
770: p_object_version_number => p_rec.object_version_number,

Line 868: l_rec ben_ept_shd.g_rec_type;

864: p_criteria_score in number default hr_api.g_number,
865: p_criteria_weight in number default hr_api.g_number
866: ) is
867: --
868: l_rec ben_ept_shd.g_rec_type;
869: l_proc varchar2(72) := g_package||'upd';
870: --
871: Begin
872: hr_utility.set_location('Entering:'||l_proc, 5);

Line 878: ben_ept_shd.convert_args

874: -- Call conversion function to turn arguments into the
875: -- l_rec structure.
876: --
877: l_rec :=
878: ben_ept_shd.convert_args
879: (
880: p_elig_per_typ_prte_id,
881: null,
882: null,