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_EPN_UPD dependencies on BEN_EPN_SHD

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

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

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

Line 132: ben_epn_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: ben_epn_shd.g_api_dml := false; -- Unset the api dml status

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

Line 145: ben_epn_shd.constraint_error

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

Line 149: ben_epn_shd.g_api_dml := false; -- Unset the api dml status

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

Line 150: ben_epn_shd.constraint_error

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

Line 153: ben_epn_shd.g_api_dml := false; -- Unset the api dml status

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

Line 189: (p_rec in out nocopy ben_epn_shd.g_rec_type,

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

Line 253: (p_rec in out nocopy ben_epn_shd.g_rec_type,

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

Line 269: ben_epn_shd.upd_effective_end_date

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

Line 338: (p_rec in out nocopy ben_epn_shd.g_rec_type,

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

Line 394: (p_rec in ben_epn_shd.g_rec_type,

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

Line 459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date

455: ,p_validation_start_date =>p_validation_start_date
456: ,p_validation_end_date =>p_validation_end_date
457: ,p_criteria_score =>p_rec.criteria_score
458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD

Line 460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date

456: ,p_validation_end_date =>p_validation_end_date
457: ,p_criteria_score =>p_rec.criteria_score
458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit

Line 461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag

457: ,p_criteria_score =>p_rec.criteria_score
458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id

Line 462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num

458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id

Line 463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD

459: ,p_effective_start_date_o =>ben_epn_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category

Line 464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit

460: ,p_effective_end_date_o =>ben_epn_shd.g_old_rec.effective_end_date
461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1

Line 465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id

461: ,p_excld_flag_o =>ben_epn_shd.g_old_rec.excld_flag
462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2

Line 466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id

462: ,p_ordr_num_o =>ben_epn_shd.g_old_rec.ordr_num
463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3

Line 467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category

463: ,p_PROBATION_PERIOD_o =>ben_epn_shd.g_old_rec.PROBATION_PERIOD
464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4

Line 468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1

464: ,p_probation_unit_o =>ben_epn_shd.g_old_rec.probation_unit
465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5

Line 469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2

465: ,p_eligy_prfl_id_o =>ben_epn_shd.g_old_rec.eligy_prfl_id
466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6

Line 470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3

466: ,p_business_group_id_o =>ben_epn_shd.g_old_rec.business_group_id
467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7

Line 471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4

467: ,p_epn_attribute_category_o =>ben_epn_shd.g_old_rec.epn_attribute_category
468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8

Line 472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5

468: ,p_epn_attribute1_o =>ben_epn_shd.g_old_rec.epn_attribute1
469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9

Line 473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6

469: ,p_epn_attribute2_o =>ben_epn_shd.g_old_rec.epn_attribute2
470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10

Line 474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7

470: ,p_epn_attribute3_o =>ben_epn_shd.g_old_rec.epn_attribute3
471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11

Line 475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8

471: ,p_epn_attribute4_o =>ben_epn_shd.g_old_rec.epn_attribute4
472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12

Line 476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9

472: ,p_epn_attribute5_o =>ben_epn_shd.g_old_rec.epn_attribute5
473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13

Line 477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10

473: ,p_epn_attribute6_o =>ben_epn_shd.g_old_rec.epn_attribute6
474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14

Line 478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11

474: ,p_epn_attribute7_o =>ben_epn_shd.g_old_rec.epn_attribute7
475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15

Line 479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12

475: ,p_epn_attribute8_o =>ben_epn_shd.g_old_rec.epn_attribute8
476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16

Line 480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13

476: ,p_epn_attribute9_o =>ben_epn_shd.g_old_rec.epn_attribute9
477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17

Line 481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14

477: ,p_epn_attribute10_o =>ben_epn_shd.g_old_rec.epn_attribute10
478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18

Line 482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15

478: ,p_epn_attribute11_o =>ben_epn_shd.g_old_rec.epn_attribute11
479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19

Line 483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16

479: ,p_epn_attribute12_o =>ben_epn_shd.g_old_rec.epn_attribute12
480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20

Line 484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17

480: ,p_epn_attribute13_o =>ben_epn_shd.g_old_rec.epn_attribute13
481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21

Line 485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18

481: ,p_epn_attribute14_o =>ben_epn_shd.g_old_rec.epn_attribute14
482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22

Line 486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19

482: ,p_epn_attribute15_o =>ben_epn_shd.g_old_rec.epn_attribute15
483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23

Line 487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20

483: ,p_epn_attribute16_o =>ben_epn_shd.g_old_rec.epn_attribute16
484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24

Line 488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21

484: ,p_epn_attribute17_o =>ben_epn_shd.g_old_rec.epn_attribute17
485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25

Line 489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22

485: ,p_epn_attribute18_o =>ben_epn_shd.g_old_rec.epn_attribute18
486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26

Line 490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23

486: ,p_epn_attribute19_o =>ben_epn_shd.g_old_rec.epn_attribute19
487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27

Line 491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24

487: ,p_epn_attribute20_o =>ben_epn_shd.g_old_rec.epn_attribute20
488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28

Line 492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25

488: ,p_epn_attribute21_o =>ben_epn_shd.g_old_rec.epn_attribute21
489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29

Line 493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26

489: ,p_epn_attribute22_o =>ben_epn_shd.g_old_rec.epn_attribute22
490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30

Line 494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27

490: ,p_epn_attribute23_o =>ben_epn_shd.g_old_rec.epn_attribute23
491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number

Line 495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28

491: ,p_epn_attribute24_o =>ben_epn_shd.g_old_rec.epn_attribute24
492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score

Line 496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29

492: ,p_epn_attribute25_o =>ben_epn_shd.g_old_rec.epn_attribute25
493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight

Line 497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30

493: ,p_epn_attribute26_o =>ben_epn_shd.g_old_rec.epn_attribute26
494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight
501: );

Line 498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number

494: ,p_epn_attribute27_o =>ben_epn_shd.g_old_rec.epn_attribute27
495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight
501: );
502: --

Line 499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score

495: ,p_epn_attribute28_o =>ben_epn_shd.g_old_rec.epn_attribute28
496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight
501: );
502: --
503: exception

Line 500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight

496: ,p_epn_attribute29_o =>ben_epn_shd.g_old_rec.epn_attribute29
497: ,p_epn_attribute30_o =>ben_epn_shd.g_old_rec.epn_attribute30
498: ,p_object_version_number_o =>ben_epn_shd.g_old_rec.object_version_number
499: ,p_criteria_score_o =>ben_epn_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_epn_shd.g_old_rec.criteria_weight
501: );
502: --
503: exception
504: --

Line 562: Procedure convert_defs(p_rec in out nocopy ben_epn_shd.g_rec_type) is

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

Line 577: ben_epn_shd.g_old_rec.excld_flag;

573: -- is being used then we must set to the 'current' argument value.
574: --
575: If (p_rec.excld_flag = hr_api.g_varchar2) then
576: p_rec.excld_flag :=
577: ben_epn_shd.g_old_rec.excld_flag;
578: End If;
579: If (p_rec.ordr_num = hr_api.g_number) then
580: p_rec.ordr_num :=
581: ben_epn_shd.g_old_rec.ordr_num;

Line 581: ben_epn_shd.g_old_rec.ordr_num;

577: ben_epn_shd.g_old_rec.excld_flag;
578: End If;
579: If (p_rec.ordr_num = hr_api.g_number) then
580: p_rec.ordr_num :=
581: ben_epn_shd.g_old_rec.ordr_num;
582: End If;
583: If (p_rec.PROBATION_PERIOD = hr_api.g_number) then
584: p_rec.PROBATION_PERIOD :=
585: ben_epn_shd.g_old_rec.PROBATION_PERIOD;

Line 585: ben_epn_shd.g_old_rec.PROBATION_PERIOD;

581: ben_epn_shd.g_old_rec.ordr_num;
582: End If;
583: If (p_rec.PROBATION_PERIOD = hr_api.g_number) then
584: p_rec.PROBATION_PERIOD :=
585: ben_epn_shd.g_old_rec.PROBATION_PERIOD;
586: End If;
587: If (p_rec.probation_unit = hr_api.g_varchar2) then
588: p_rec.probation_unit :=
589: ben_epn_shd.g_old_rec.probation_unit;

Line 589: ben_epn_shd.g_old_rec.probation_unit;

585: ben_epn_shd.g_old_rec.PROBATION_PERIOD;
586: End If;
587: If (p_rec.probation_unit = hr_api.g_varchar2) then
588: p_rec.probation_unit :=
589: ben_epn_shd.g_old_rec.probation_unit;
590: End If;
591: If (p_rec.eligy_prfl_id = hr_api.g_number) then
592: p_rec.eligy_prfl_id :=
593: ben_epn_shd.g_old_rec.eligy_prfl_id;

Line 593: ben_epn_shd.g_old_rec.eligy_prfl_id;

589: ben_epn_shd.g_old_rec.probation_unit;
590: End If;
591: If (p_rec.eligy_prfl_id = hr_api.g_number) then
592: p_rec.eligy_prfl_id :=
593: ben_epn_shd.g_old_rec.eligy_prfl_id;
594: End If;
595: If (p_rec.business_group_id = hr_api.g_number) then
596: p_rec.business_group_id :=
597: ben_epn_shd.g_old_rec.business_group_id;

Line 597: ben_epn_shd.g_old_rec.business_group_id;

593: ben_epn_shd.g_old_rec.eligy_prfl_id;
594: End If;
595: If (p_rec.business_group_id = hr_api.g_number) then
596: p_rec.business_group_id :=
597: ben_epn_shd.g_old_rec.business_group_id;
598: End If;
599: If (p_rec.epn_attribute_category = hr_api.g_varchar2) then
600: p_rec.epn_attribute_category :=
601: ben_epn_shd.g_old_rec.epn_attribute_category;

Line 601: ben_epn_shd.g_old_rec.epn_attribute_category;

597: ben_epn_shd.g_old_rec.business_group_id;
598: End If;
599: If (p_rec.epn_attribute_category = hr_api.g_varchar2) then
600: p_rec.epn_attribute_category :=
601: ben_epn_shd.g_old_rec.epn_attribute_category;
602: End If;
603: If (p_rec.epn_attribute1 = hr_api.g_varchar2) then
604: p_rec.epn_attribute1 :=
605: ben_epn_shd.g_old_rec.epn_attribute1;

Line 605: ben_epn_shd.g_old_rec.epn_attribute1;

601: ben_epn_shd.g_old_rec.epn_attribute_category;
602: End If;
603: If (p_rec.epn_attribute1 = hr_api.g_varchar2) then
604: p_rec.epn_attribute1 :=
605: ben_epn_shd.g_old_rec.epn_attribute1;
606: End If;
607: If (p_rec.epn_attribute2 = hr_api.g_varchar2) then
608: p_rec.epn_attribute2 :=
609: ben_epn_shd.g_old_rec.epn_attribute2;

Line 609: ben_epn_shd.g_old_rec.epn_attribute2;

605: ben_epn_shd.g_old_rec.epn_attribute1;
606: End If;
607: If (p_rec.epn_attribute2 = hr_api.g_varchar2) then
608: p_rec.epn_attribute2 :=
609: ben_epn_shd.g_old_rec.epn_attribute2;
610: End If;
611: If (p_rec.epn_attribute3 = hr_api.g_varchar2) then
612: p_rec.epn_attribute3 :=
613: ben_epn_shd.g_old_rec.epn_attribute3;

Line 613: ben_epn_shd.g_old_rec.epn_attribute3;

609: ben_epn_shd.g_old_rec.epn_attribute2;
610: End If;
611: If (p_rec.epn_attribute3 = hr_api.g_varchar2) then
612: p_rec.epn_attribute3 :=
613: ben_epn_shd.g_old_rec.epn_attribute3;
614: End If;
615: If (p_rec.epn_attribute4 = hr_api.g_varchar2) then
616: p_rec.epn_attribute4 :=
617: ben_epn_shd.g_old_rec.epn_attribute4;

Line 617: ben_epn_shd.g_old_rec.epn_attribute4;

613: ben_epn_shd.g_old_rec.epn_attribute3;
614: End If;
615: If (p_rec.epn_attribute4 = hr_api.g_varchar2) then
616: p_rec.epn_attribute4 :=
617: ben_epn_shd.g_old_rec.epn_attribute4;
618: End If;
619: If (p_rec.epn_attribute5 = hr_api.g_varchar2) then
620: p_rec.epn_attribute5 :=
621: ben_epn_shd.g_old_rec.epn_attribute5;

Line 621: ben_epn_shd.g_old_rec.epn_attribute5;

617: ben_epn_shd.g_old_rec.epn_attribute4;
618: End If;
619: If (p_rec.epn_attribute5 = hr_api.g_varchar2) then
620: p_rec.epn_attribute5 :=
621: ben_epn_shd.g_old_rec.epn_attribute5;
622: End If;
623: If (p_rec.epn_attribute6 = hr_api.g_varchar2) then
624: p_rec.epn_attribute6 :=
625: ben_epn_shd.g_old_rec.epn_attribute6;

Line 625: ben_epn_shd.g_old_rec.epn_attribute6;

621: ben_epn_shd.g_old_rec.epn_attribute5;
622: End If;
623: If (p_rec.epn_attribute6 = hr_api.g_varchar2) then
624: p_rec.epn_attribute6 :=
625: ben_epn_shd.g_old_rec.epn_attribute6;
626: End If;
627: If (p_rec.epn_attribute7 = hr_api.g_varchar2) then
628: p_rec.epn_attribute7 :=
629: ben_epn_shd.g_old_rec.epn_attribute7;

Line 629: ben_epn_shd.g_old_rec.epn_attribute7;

625: ben_epn_shd.g_old_rec.epn_attribute6;
626: End If;
627: If (p_rec.epn_attribute7 = hr_api.g_varchar2) then
628: p_rec.epn_attribute7 :=
629: ben_epn_shd.g_old_rec.epn_attribute7;
630: End If;
631: If (p_rec.epn_attribute8 = hr_api.g_varchar2) then
632: p_rec.epn_attribute8 :=
633: ben_epn_shd.g_old_rec.epn_attribute8;

Line 633: ben_epn_shd.g_old_rec.epn_attribute8;

629: ben_epn_shd.g_old_rec.epn_attribute7;
630: End If;
631: If (p_rec.epn_attribute8 = hr_api.g_varchar2) then
632: p_rec.epn_attribute8 :=
633: ben_epn_shd.g_old_rec.epn_attribute8;
634: End If;
635: If (p_rec.epn_attribute9 = hr_api.g_varchar2) then
636: p_rec.epn_attribute9 :=
637: ben_epn_shd.g_old_rec.epn_attribute9;

Line 637: ben_epn_shd.g_old_rec.epn_attribute9;

633: ben_epn_shd.g_old_rec.epn_attribute8;
634: End If;
635: If (p_rec.epn_attribute9 = hr_api.g_varchar2) then
636: p_rec.epn_attribute9 :=
637: ben_epn_shd.g_old_rec.epn_attribute9;
638: End If;
639: If (p_rec.epn_attribute10 = hr_api.g_varchar2) then
640: p_rec.epn_attribute10 :=
641: ben_epn_shd.g_old_rec.epn_attribute10;

Line 641: ben_epn_shd.g_old_rec.epn_attribute10;

637: ben_epn_shd.g_old_rec.epn_attribute9;
638: End If;
639: If (p_rec.epn_attribute10 = hr_api.g_varchar2) then
640: p_rec.epn_attribute10 :=
641: ben_epn_shd.g_old_rec.epn_attribute10;
642: End If;
643: If (p_rec.epn_attribute11 = hr_api.g_varchar2) then
644: p_rec.epn_attribute11 :=
645: ben_epn_shd.g_old_rec.epn_attribute11;

Line 645: ben_epn_shd.g_old_rec.epn_attribute11;

641: ben_epn_shd.g_old_rec.epn_attribute10;
642: End If;
643: If (p_rec.epn_attribute11 = hr_api.g_varchar2) then
644: p_rec.epn_attribute11 :=
645: ben_epn_shd.g_old_rec.epn_attribute11;
646: End If;
647: If (p_rec.epn_attribute12 = hr_api.g_varchar2) then
648: p_rec.epn_attribute12 :=
649: ben_epn_shd.g_old_rec.epn_attribute12;

Line 649: ben_epn_shd.g_old_rec.epn_attribute12;

645: ben_epn_shd.g_old_rec.epn_attribute11;
646: End If;
647: If (p_rec.epn_attribute12 = hr_api.g_varchar2) then
648: p_rec.epn_attribute12 :=
649: ben_epn_shd.g_old_rec.epn_attribute12;
650: End If;
651: If (p_rec.epn_attribute13 = hr_api.g_varchar2) then
652: p_rec.epn_attribute13 :=
653: ben_epn_shd.g_old_rec.epn_attribute13;

Line 653: ben_epn_shd.g_old_rec.epn_attribute13;

649: ben_epn_shd.g_old_rec.epn_attribute12;
650: End If;
651: If (p_rec.epn_attribute13 = hr_api.g_varchar2) then
652: p_rec.epn_attribute13 :=
653: ben_epn_shd.g_old_rec.epn_attribute13;
654: End If;
655: If (p_rec.epn_attribute14 = hr_api.g_varchar2) then
656: p_rec.epn_attribute14 :=
657: ben_epn_shd.g_old_rec.epn_attribute14;

Line 657: ben_epn_shd.g_old_rec.epn_attribute14;

653: ben_epn_shd.g_old_rec.epn_attribute13;
654: End If;
655: If (p_rec.epn_attribute14 = hr_api.g_varchar2) then
656: p_rec.epn_attribute14 :=
657: ben_epn_shd.g_old_rec.epn_attribute14;
658: End If;
659: If (p_rec.epn_attribute15 = hr_api.g_varchar2) then
660: p_rec.epn_attribute15 :=
661: ben_epn_shd.g_old_rec.epn_attribute15;

Line 661: ben_epn_shd.g_old_rec.epn_attribute15;

657: ben_epn_shd.g_old_rec.epn_attribute14;
658: End If;
659: If (p_rec.epn_attribute15 = hr_api.g_varchar2) then
660: p_rec.epn_attribute15 :=
661: ben_epn_shd.g_old_rec.epn_attribute15;
662: End If;
663: If (p_rec.epn_attribute16 = hr_api.g_varchar2) then
664: p_rec.epn_attribute16 :=
665: ben_epn_shd.g_old_rec.epn_attribute16;

Line 665: ben_epn_shd.g_old_rec.epn_attribute16;

661: ben_epn_shd.g_old_rec.epn_attribute15;
662: End If;
663: If (p_rec.epn_attribute16 = hr_api.g_varchar2) then
664: p_rec.epn_attribute16 :=
665: ben_epn_shd.g_old_rec.epn_attribute16;
666: End If;
667: If (p_rec.epn_attribute17 = hr_api.g_varchar2) then
668: p_rec.epn_attribute17 :=
669: ben_epn_shd.g_old_rec.epn_attribute17;

Line 669: ben_epn_shd.g_old_rec.epn_attribute17;

665: ben_epn_shd.g_old_rec.epn_attribute16;
666: End If;
667: If (p_rec.epn_attribute17 = hr_api.g_varchar2) then
668: p_rec.epn_attribute17 :=
669: ben_epn_shd.g_old_rec.epn_attribute17;
670: End If;
671: If (p_rec.epn_attribute18 = hr_api.g_varchar2) then
672: p_rec.epn_attribute18 :=
673: ben_epn_shd.g_old_rec.epn_attribute18;

Line 673: ben_epn_shd.g_old_rec.epn_attribute18;

669: ben_epn_shd.g_old_rec.epn_attribute17;
670: End If;
671: If (p_rec.epn_attribute18 = hr_api.g_varchar2) then
672: p_rec.epn_attribute18 :=
673: ben_epn_shd.g_old_rec.epn_attribute18;
674: End If;
675: If (p_rec.epn_attribute19 = hr_api.g_varchar2) then
676: p_rec.epn_attribute19 :=
677: ben_epn_shd.g_old_rec.epn_attribute19;

Line 677: ben_epn_shd.g_old_rec.epn_attribute19;

673: ben_epn_shd.g_old_rec.epn_attribute18;
674: End If;
675: If (p_rec.epn_attribute19 = hr_api.g_varchar2) then
676: p_rec.epn_attribute19 :=
677: ben_epn_shd.g_old_rec.epn_attribute19;
678: End If;
679: If (p_rec.epn_attribute20 = hr_api.g_varchar2) then
680: p_rec.epn_attribute20 :=
681: ben_epn_shd.g_old_rec.epn_attribute20;

Line 681: ben_epn_shd.g_old_rec.epn_attribute20;

677: ben_epn_shd.g_old_rec.epn_attribute19;
678: End If;
679: If (p_rec.epn_attribute20 = hr_api.g_varchar2) then
680: p_rec.epn_attribute20 :=
681: ben_epn_shd.g_old_rec.epn_attribute20;
682: End If;
683: If (p_rec.epn_attribute21 = hr_api.g_varchar2) then
684: p_rec.epn_attribute21 :=
685: ben_epn_shd.g_old_rec.epn_attribute21;

Line 685: ben_epn_shd.g_old_rec.epn_attribute21;

681: ben_epn_shd.g_old_rec.epn_attribute20;
682: End If;
683: If (p_rec.epn_attribute21 = hr_api.g_varchar2) then
684: p_rec.epn_attribute21 :=
685: ben_epn_shd.g_old_rec.epn_attribute21;
686: End If;
687: If (p_rec.epn_attribute22 = hr_api.g_varchar2) then
688: p_rec.epn_attribute22 :=
689: ben_epn_shd.g_old_rec.epn_attribute22;

Line 689: ben_epn_shd.g_old_rec.epn_attribute22;

685: ben_epn_shd.g_old_rec.epn_attribute21;
686: End If;
687: If (p_rec.epn_attribute22 = hr_api.g_varchar2) then
688: p_rec.epn_attribute22 :=
689: ben_epn_shd.g_old_rec.epn_attribute22;
690: End If;
691: If (p_rec.epn_attribute23 = hr_api.g_varchar2) then
692: p_rec.epn_attribute23 :=
693: ben_epn_shd.g_old_rec.epn_attribute23;

Line 693: ben_epn_shd.g_old_rec.epn_attribute23;

689: ben_epn_shd.g_old_rec.epn_attribute22;
690: End If;
691: If (p_rec.epn_attribute23 = hr_api.g_varchar2) then
692: p_rec.epn_attribute23 :=
693: ben_epn_shd.g_old_rec.epn_attribute23;
694: End If;
695: If (p_rec.epn_attribute24 = hr_api.g_varchar2) then
696: p_rec.epn_attribute24 :=
697: ben_epn_shd.g_old_rec.epn_attribute24;

Line 697: ben_epn_shd.g_old_rec.epn_attribute24;

693: ben_epn_shd.g_old_rec.epn_attribute23;
694: End If;
695: If (p_rec.epn_attribute24 = hr_api.g_varchar2) then
696: p_rec.epn_attribute24 :=
697: ben_epn_shd.g_old_rec.epn_attribute24;
698: End If;
699: If (p_rec.epn_attribute25 = hr_api.g_varchar2) then
700: p_rec.epn_attribute25 :=
701: ben_epn_shd.g_old_rec.epn_attribute25;

Line 701: ben_epn_shd.g_old_rec.epn_attribute25;

697: ben_epn_shd.g_old_rec.epn_attribute24;
698: End If;
699: If (p_rec.epn_attribute25 = hr_api.g_varchar2) then
700: p_rec.epn_attribute25 :=
701: ben_epn_shd.g_old_rec.epn_attribute25;
702: End If;
703: If (p_rec.epn_attribute26 = hr_api.g_varchar2) then
704: p_rec.epn_attribute26 :=
705: ben_epn_shd.g_old_rec.epn_attribute26;

Line 705: ben_epn_shd.g_old_rec.epn_attribute26;

701: ben_epn_shd.g_old_rec.epn_attribute25;
702: End If;
703: If (p_rec.epn_attribute26 = hr_api.g_varchar2) then
704: p_rec.epn_attribute26 :=
705: ben_epn_shd.g_old_rec.epn_attribute26;
706: End If;
707: If (p_rec.epn_attribute27 = hr_api.g_varchar2) then
708: p_rec.epn_attribute27 :=
709: ben_epn_shd.g_old_rec.epn_attribute27;

Line 709: ben_epn_shd.g_old_rec.epn_attribute27;

705: ben_epn_shd.g_old_rec.epn_attribute26;
706: End If;
707: If (p_rec.epn_attribute27 = hr_api.g_varchar2) then
708: p_rec.epn_attribute27 :=
709: ben_epn_shd.g_old_rec.epn_attribute27;
710: End If;
711: If (p_rec.epn_attribute28 = hr_api.g_varchar2) then
712: p_rec.epn_attribute28 :=
713: ben_epn_shd.g_old_rec.epn_attribute28;

Line 713: ben_epn_shd.g_old_rec.epn_attribute28;

709: ben_epn_shd.g_old_rec.epn_attribute27;
710: End If;
711: If (p_rec.epn_attribute28 = hr_api.g_varchar2) then
712: p_rec.epn_attribute28 :=
713: ben_epn_shd.g_old_rec.epn_attribute28;
714: End If;
715: If (p_rec.epn_attribute29 = hr_api.g_varchar2) then
716: p_rec.epn_attribute29 :=
717: ben_epn_shd.g_old_rec.epn_attribute29;

Line 717: ben_epn_shd.g_old_rec.epn_attribute29;

713: ben_epn_shd.g_old_rec.epn_attribute28;
714: End If;
715: If (p_rec.epn_attribute29 = hr_api.g_varchar2) then
716: p_rec.epn_attribute29 :=
717: ben_epn_shd.g_old_rec.epn_attribute29;
718: End If;
719: If (p_rec.epn_attribute30 = hr_api.g_varchar2) then
720: p_rec.epn_attribute30 :=
721: ben_epn_shd.g_old_rec.epn_attribute30;

Line 721: ben_epn_shd.g_old_rec.epn_attribute30;

717: ben_epn_shd.g_old_rec.epn_attribute29;
718: End If;
719: If (p_rec.epn_attribute30 = hr_api.g_varchar2) then
720: p_rec.epn_attribute30 :=
721: ben_epn_shd.g_old_rec.epn_attribute30;
722: End If;
723: If (p_rec.criteria_score = hr_api.g_number) then
724: p_rec.criteria_score :=
725: ben_epn_shd.g_old_rec.criteria_score;

Line 725: ben_epn_shd.g_old_rec.criteria_score;

721: ben_epn_shd.g_old_rec.epn_attribute30;
722: End If;
723: If (p_rec.criteria_score = hr_api.g_number) then
724: p_rec.criteria_score :=
725: ben_epn_shd.g_old_rec.criteria_score;
726: End If;
727: If (p_rec.criteria_weight = hr_api.g_number) then
728: p_rec.criteria_weight :=
729: ben_epn_shd.g_old_rec.criteria_weight;

Line 729: ben_epn_shd.g_old_rec.criteria_weight;

725: ben_epn_shd.g_old_rec.criteria_score;
726: End If;
727: If (p_rec.criteria_weight = hr_api.g_number) then
728: p_rec.criteria_weight :=
729: ben_epn_shd.g_old_rec.criteria_weight;
730: End If;
731:
732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 742: p_rec in out nocopy ben_epn_shd.g_rec_type,

738: -- |---------------------------------< upd >----------------------------------|
739: -- ----------------------------------------------------------------------------
740: Procedure upd
741: (
742: p_rec in out nocopy ben_epn_shd.g_rec_type,
743: p_effective_date in date,
744: p_datetrack_mode in varchar2
745: ) is
746: --

Line 760: ben_epn_shd.lck

756: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
757: --
758: -- We must lock the row which we need to update.
759: --
760: ben_epn_shd.lck
761: (p_effective_date => p_effective_date,
762: p_datetrack_mode => p_datetrack_mode,
763: p_ELIG_PRBTN_PERD_PRTE_id => p_rec.ELIG_PRBTN_PERD_PRTE_id,
764: p_object_version_number => p_rec.object_version_number,

Line 862: l_rec ben_epn_shd.g_rec_type;

858: p_criteria_score in number default hr_api.g_number,
859: p_criteria_weight in number default hr_api.g_number
860: ) is
861: --
862: l_rec ben_epn_shd.g_rec_type;
863: l_proc varchar2(72) := g_package||'upd';
864: --
865: Begin
866: hr_utility.set_location('Entering:'||l_proc, 5);

Line 872: ben_epn_shd.convert_args

868: -- Call conversion function to turn arguments into the
869: -- l_rec structure.
870: --
871: l_rec :=
872: ben_epn_shd.convert_args
873: (
874: p_ELIG_PRBTN_PERD_PRTE_id,
875: null,
876: null,