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_ELR_UPD dependencies on BEN_ELR_SHD

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

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

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

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

128: where elig_loa_rsn_prte_id = p_rec.elig_loa_rsn_prte_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_elr_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_elr_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_elr_shd.g_api_dml := false; -- Unset the api dml status
145: ben_elr_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_elr_shd.constraint_error

141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_elr_shd.g_api_dml := false; -- Unset the api dml status
145: ben_elr_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_elr_shd.g_api_dml := false; -- Unset the api dml status

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

145: ben_elr_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_elr_shd.g_api_dml := false; -- Unset the api dml status
150: ben_elr_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_elr_shd.g_api_dml := false; -- Unset the api dml status

Line 150: ben_elr_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_elr_shd.g_api_dml := false; -- Unset the api dml status
150: ben_elr_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_elr_shd.g_api_dml := false; -- Unset the api dml status
154: Raise;

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

149: ben_elr_shd.g_api_dml := false; -- Unset the api dml status
150: ben_elr_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_elr_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_elr_shd.g_rec_type,

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure update_dml
189: (p_rec in out nocopy ben_elr_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_elr_shd.g_rec_type,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy ben_elr_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_elr_shd.upd_effective_end_date

265: hr_utility.set_location(l_proc, 10);
266: --
267: -- Update the current effective end date
268: --
269: ben_elr_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date,
271: p_base_key_value => p_rec.elig_loa_rsn_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_elr_shd.g_rec_type,

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure pre_update
338: (p_rec in out nocopy ben_elr_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_elr_shd.g_rec_type,

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_elr_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_elr_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_elr_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num

Line 460: ,p_effective_end_date_o =>ben_elr_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_elr_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag

Line 461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id

457: ,p_criteria_score =>p_rec.criteria_score
458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_elr_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category

Line 462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id

458: ,p_criteria_weight =>p_rec.criteria_weight
459: ,p_effective_start_date_o =>ben_elr_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1

Line 463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num

459: ,p_effective_start_date_o =>ben_elr_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2

Line 464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag

460: ,p_effective_end_date_o =>ben_elr_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3

Line 465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category

461: ,p_business_group_id_o =>ben_elr_shd.g_old_rec.business_group_id
462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4

Line 466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1

462: ,p_eligy_prfl_id_o =>ben_elr_shd.g_old_rec.eligy_prfl_id
463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5

Line 467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2

463: ,p_ordr_num_o =>ben_elr_shd.g_old_rec.ordr_num
464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6

Line 468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3

464: ,p_excld_flag_o =>ben_elr_shd.g_old_rec.excld_flag
465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7

Line 469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4

465: ,p_elr_attribute_category_o =>ben_elr_shd.g_old_rec.elr_attribute_category
466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8

Line 470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5

466: ,p_elr_attribute1_o =>ben_elr_shd.g_old_rec.elr_attribute1
467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9

Line 471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6

467: ,p_elr_attribute2_o =>ben_elr_shd.g_old_rec.elr_attribute2
468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10

Line 472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7

468: ,p_elr_attribute3_o =>ben_elr_shd.g_old_rec.elr_attribute3
469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11

Line 473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8

469: ,p_elr_attribute4_o =>ben_elr_shd.g_old_rec.elr_attribute4
470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12

Line 474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9

470: ,p_elr_attribute5_o =>ben_elr_shd.g_old_rec.elr_attribute5
471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13

Line 475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10

471: ,p_elr_attribute6_o =>ben_elr_shd.g_old_rec.elr_attribute6
472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14

Line 476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11

472: ,p_elr_attribute7_o =>ben_elr_shd.g_old_rec.elr_attribute7
473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15

Line 477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12

473: ,p_elr_attribute8_o =>ben_elr_shd.g_old_rec.elr_attribute8
474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16

Line 478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13

474: ,p_elr_attribute9_o =>ben_elr_shd.g_old_rec.elr_attribute9
475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17

Line 479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14

475: ,p_elr_attribute10_o =>ben_elr_shd.g_old_rec.elr_attribute10
476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18

Line 480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15

476: ,p_elr_attribute11_o =>ben_elr_shd.g_old_rec.elr_attribute11
477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19

Line 481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16

477: ,p_elr_attribute12_o =>ben_elr_shd.g_old_rec.elr_attribute12
478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20

Line 482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17

478: ,p_elr_attribute13_o =>ben_elr_shd.g_old_rec.elr_attribute13
479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21

Line 483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18

479: ,p_elr_attribute14_o =>ben_elr_shd.g_old_rec.elr_attribute14
480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22

Line 484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19

480: ,p_elr_attribute15_o =>ben_elr_shd.g_old_rec.elr_attribute15
481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23

Line 485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20

481: ,p_elr_attribute16_o =>ben_elr_shd.g_old_rec.elr_attribute16
482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24

Line 486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21

482: ,p_elr_attribute17_o =>ben_elr_shd.g_old_rec.elr_attribute17
483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25

Line 487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22

483: ,p_elr_attribute18_o =>ben_elr_shd.g_old_rec.elr_attribute18
484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26

Line 488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23

484: ,p_elr_attribute19_o =>ben_elr_shd.g_old_rec.elr_attribute19
485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27

Line 489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24

485: ,p_elr_attribute20_o =>ben_elr_shd.g_old_rec.elr_attribute20
486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28

Line 490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25

486: ,p_elr_attribute21_o =>ben_elr_shd.g_old_rec.elr_attribute21
487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29

Line 491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26

487: ,p_elr_attribute22_o =>ben_elr_shd.g_old_rec.elr_attribute22
488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30

Line 492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27

488: ,p_elr_attribute23_o =>ben_elr_shd.g_old_rec.elr_attribute23
489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number

Line 493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28

489: ,p_elr_attribute24_o =>ben_elr_shd.g_old_rec.elr_attribute24
490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id

Line 494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29

490: ,p_elr_attribute25_o =>ben_elr_shd.g_old_rec.elr_attribute25
491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id

Line 495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30

491: ,p_elr_attribute26_o =>ben_elr_shd.g_old_rec.elr_attribute26
492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score

Line 496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number

492: ,p_elr_attribute27_o =>ben_elr_shd.g_old_rec.elr_attribute27
493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_elr_shd.g_old_rec.criteria_weight

Line 497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id

493: ,p_elr_attribute28_o =>ben_elr_shd.g_old_rec.elr_attribute28
494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_elr_shd.g_old_rec.criteria_weight
501: );

Line 498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id

494: ,p_elr_attribute29_o =>ben_elr_shd.g_old_rec.elr_attribute29
495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_elr_shd.g_old_rec.criteria_weight
501: );
502: --

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

495: ,p_elr_attribute30_o =>ben_elr_shd.g_old_rec.elr_attribute30
496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_elr_shd.g_old_rec.criteria_weight
501: );
502: --
503: exception

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

496: ,p_object_version_number_o =>ben_elr_shd.g_old_rec.object_version_number
497: ,p_absence_attendance_type_id_o =>ben_elr_shd.g_old_rec.absence_attendance_type_id
498: ,p_abs_attendance_reason_id_o =>ben_elr_shd.g_old_rec.abs_attendance_reason_id
499: ,p_criteria_score_o =>ben_elr_shd.g_old_rec.criteria_score
500: ,p_criteria_weight_o =>ben_elr_shd.g_old_rec.criteria_weight
501: );
502: --
503: exception
504: --

Line 562: Procedure convert_defs(p_rec in out nocopy ben_elr_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_elr_shd.g_rec_type) is
563: --
564: l_proc varchar2(72) := g_package||'convert_defs';
565: --
566: Begin

Line 577: ben_elr_shd.g_old_rec.business_group_id;

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

Line 581: ben_elr_shd.g_old_rec.eligy_prfl_id;

577: ben_elr_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.eligy_prfl_id = hr_api.g_number) then
580: p_rec.eligy_prfl_id :=
581: ben_elr_shd.g_old_rec.eligy_prfl_id;
582: End If;
583: If (p_rec.ordr_num = hr_api.g_number) then
584: p_rec.ordr_num :=
585: ben_elr_shd.g_old_rec.ordr_num;

Line 585: ben_elr_shd.g_old_rec.ordr_num;

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

Line 589: ben_elr_shd.g_old_rec.excld_flag;

585: ben_elr_shd.g_old_rec.ordr_num;
586: End If;
587: If (p_rec.excld_flag = hr_api.g_varchar2) then
588: p_rec.excld_flag :=
589: ben_elr_shd.g_old_rec.excld_flag;
590: End If;
591: If (p_rec.elr_attribute_category = hr_api.g_varchar2) then
592: p_rec.elr_attribute_category :=
593: ben_elr_shd.g_old_rec.elr_attribute_category;

Line 593: ben_elr_shd.g_old_rec.elr_attribute_category;

589: ben_elr_shd.g_old_rec.excld_flag;
590: End If;
591: If (p_rec.elr_attribute_category = hr_api.g_varchar2) then
592: p_rec.elr_attribute_category :=
593: ben_elr_shd.g_old_rec.elr_attribute_category;
594: End If;
595: If (p_rec.elr_attribute1 = hr_api.g_varchar2) then
596: p_rec.elr_attribute1 :=
597: ben_elr_shd.g_old_rec.elr_attribute1;

Line 597: ben_elr_shd.g_old_rec.elr_attribute1;

593: ben_elr_shd.g_old_rec.elr_attribute_category;
594: End If;
595: If (p_rec.elr_attribute1 = hr_api.g_varchar2) then
596: p_rec.elr_attribute1 :=
597: ben_elr_shd.g_old_rec.elr_attribute1;
598: End If;
599: If (p_rec.elr_attribute2 = hr_api.g_varchar2) then
600: p_rec.elr_attribute2 :=
601: ben_elr_shd.g_old_rec.elr_attribute2;

Line 601: ben_elr_shd.g_old_rec.elr_attribute2;

597: ben_elr_shd.g_old_rec.elr_attribute1;
598: End If;
599: If (p_rec.elr_attribute2 = hr_api.g_varchar2) then
600: p_rec.elr_attribute2 :=
601: ben_elr_shd.g_old_rec.elr_attribute2;
602: End If;
603: If (p_rec.elr_attribute3 = hr_api.g_varchar2) then
604: p_rec.elr_attribute3 :=
605: ben_elr_shd.g_old_rec.elr_attribute3;

Line 605: ben_elr_shd.g_old_rec.elr_attribute3;

601: ben_elr_shd.g_old_rec.elr_attribute2;
602: End If;
603: If (p_rec.elr_attribute3 = hr_api.g_varchar2) then
604: p_rec.elr_attribute3 :=
605: ben_elr_shd.g_old_rec.elr_attribute3;
606: End If;
607: If (p_rec.elr_attribute4 = hr_api.g_varchar2) then
608: p_rec.elr_attribute4 :=
609: ben_elr_shd.g_old_rec.elr_attribute4;

Line 609: ben_elr_shd.g_old_rec.elr_attribute4;

605: ben_elr_shd.g_old_rec.elr_attribute3;
606: End If;
607: If (p_rec.elr_attribute4 = hr_api.g_varchar2) then
608: p_rec.elr_attribute4 :=
609: ben_elr_shd.g_old_rec.elr_attribute4;
610: End If;
611: If (p_rec.elr_attribute5 = hr_api.g_varchar2) then
612: p_rec.elr_attribute5 :=
613: ben_elr_shd.g_old_rec.elr_attribute5;

Line 613: ben_elr_shd.g_old_rec.elr_attribute5;

609: ben_elr_shd.g_old_rec.elr_attribute4;
610: End If;
611: If (p_rec.elr_attribute5 = hr_api.g_varchar2) then
612: p_rec.elr_attribute5 :=
613: ben_elr_shd.g_old_rec.elr_attribute5;
614: End If;
615: If (p_rec.elr_attribute6 = hr_api.g_varchar2) then
616: p_rec.elr_attribute6 :=
617: ben_elr_shd.g_old_rec.elr_attribute6;

Line 617: ben_elr_shd.g_old_rec.elr_attribute6;

613: ben_elr_shd.g_old_rec.elr_attribute5;
614: End If;
615: If (p_rec.elr_attribute6 = hr_api.g_varchar2) then
616: p_rec.elr_attribute6 :=
617: ben_elr_shd.g_old_rec.elr_attribute6;
618: End If;
619: If (p_rec.elr_attribute7 = hr_api.g_varchar2) then
620: p_rec.elr_attribute7 :=
621: ben_elr_shd.g_old_rec.elr_attribute7;

Line 621: ben_elr_shd.g_old_rec.elr_attribute7;

617: ben_elr_shd.g_old_rec.elr_attribute6;
618: End If;
619: If (p_rec.elr_attribute7 = hr_api.g_varchar2) then
620: p_rec.elr_attribute7 :=
621: ben_elr_shd.g_old_rec.elr_attribute7;
622: End If;
623: If (p_rec.elr_attribute8 = hr_api.g_varchar2) then
624: p_rec.elr_attribute8 :=
625: ben_elr_shd.g_old_rec.elr_attribute8;

Line 625: ben_elr_shd.g_old_rec.elr_attribute8;

621: ben_elr_shd.g_old_rec.elr_attribute7;
622: End If;
623: If (p_rec.elr_attribute8 = hr_api.g_varchar2) then
624: p_rec.elr_attribute8 :=
625: ben_elr_shd.g_old_rec.elr_attribute8;
626: End If;
627: If (p_rec.elr_attribute9 = hr_api.g_varchar2) then
628: p_rec.elr_attribute9 :=
629: ben_elr_shd.g_old_rec.elr_attribute9;

Line 629: ben_elr_shd.g_old_rec.elr_attribute9;

625: ben_elr_shd.g_old_rec.elr_attribute8;
626: End If;
627: If (p_rec.elr_attribute9 = hr_api.g_varchar2) then
628: p_rec.elr_attribute9 :=
629: ben_elr_shd.g_old_rec.elr_attribute9;
630: End If;
631: If (p_rec.elr_attribute10 = hr_api.g_varchar2) then
632: p_rec.elr_attribute10 :=
633: ben_elr_shd.g_old_rec.elr_attribute10;

Line 633: ben_elr_shd.g_old_rec.elr_attribute10;

629: ben_elr_shd.g_old_rec.elr_attribute9;
630: End If;
631: If (p_rec.elr_attribute10 = hr_api.g_varchar2) then
632: p_rec.elr_attribute10 :=
633: ben_elr_shd.g_old_rec.elr_attribute10;
634: End If;
635: If (p_rec.elr_attribute11 = hr_api.g_varchar2) then
636: p_rec.elr_attribute11 :=
637: ben_elr_shd.g_old_rec.elr_attribute11;

Line 637: ben_elr_shd.g_old_rec.elr_attribute11;

633: ben_elr_shd.g_old_rec.elr_attribute10;
634: End If;
635: If (p_rec.elr_attribute11 = hr_api.g_varchar2) then
636: p_rec.elr_attribute11 :=
637: ben_elr_shd.g_old_rec.elr_attribute11;
638: End If;
639: If (p_rec.elr_attribute12 = hr_api.g_varchar2) then
640: p_rec.elr_attribute12 :=
641: ben_elr_shd.g_old_rec.elr_attribute12;

Line 641: ben_elr_shd.g_old_rec.elr_attribute12;

637: ben_elr_shd.g_old_rec.elr_attribute11;
638: End If;
639: If (p_rec.elr_attribute12 = hr_api.g_varchar2) then
640: p_rec.elr_attribute12 :=
641: ben_elr_shd.g_old_rec.elr_attribute12;
642: End If;
643: If (p_rec.elr_attribute13 = hr_api.g_varchar2) then
644: p_rec.elr_attribute13 :=
645: ben_elr_shd.g_old_rec.elr_attribute13;

Line 645: ben_elr_shd.g_old_rec.elr_attribute13;

641: ben_elr_shd.g_old_rec.elr_attribute12;
642: End If;
643: If (p_rec.elr_attribute13 = hr_api.g_varchar2) then
644: p_rec.elr_attribute13 :=
645: ben_elr_shd.g_old_rec.elr_attribute13;
646: End If;
647: If (p_rec.elr_attribute14 = hr_api.g_varchar2) then
648: p_rec.elr_attribute14 :=
649: ben_elr_shd.g_old_rec.elr_attribute14;

Line 649: ben_elr_shd.g_old_rec.elr_attribute14;

645: ben_elr_shd.g_old_rec.elr_attribute13;
646: End If;
647: If (p_rec.elr_attribute14 = hr_api.g_varchar2) then
648: p_rec.elr_attribute14 :=
649: ben_elr_shd.g_old_rec.elr_attribute14;
650: End If;
651: If (p_rec.elr_attribute15 = hr_api.g_varchar2) then
652: p_rec.elr_attribute15 :=
653: ben_elr_shd.g_old_rec.elr_attribute15;

Line 653: ben_elr_shd.g_old_rec.elr_attribute15;

649: ben_elr_shd.g_old_rec.elr_attribute14;
650: End If;
651: If (p_rec.elr_attribute15 = hr_api.g_varchar2) then
652: p_rec.elr_attribute15 :=
653: ben_elr_shd.g_old_rec.elr_attribute15;
654: End If;
655: If (p_rec.elr_attribute16 = hr_api.g_varchar2) then
656: p_rec.elr_attribute16 :=
657: ben_elr_shd.g_old_rec.elr_attribute16;

Line 657: ben_elr_shd.g_old_rec.elr_attribute16;

653: ben_elr_shd.g_old_rec.elr_attribute15;
654: End If;
655: If (p_rec.elr_attribute16 = hr_api.g_varchar2) then
656: p_rec.elr_attribute16 :=
657: ben_elr_shd.g_old_rec.elr_attribute16;
658: End If;
659: If (p_rec.elr_attribute17 = hr_api.g_varchar2) then
660: p_rec.elr_attribute17 :=
661: ben_elr_shd.g_old_rec.elr_attribute17;

Line 661: ben_elr_shd.g_old_rec.elr_attribute17;

657: ben_elr_shd.g_old_rec.elr_attribute16;
658: End If;
659: If (p_rec.elr_attribute17 = hr_api.g_varchar2) then
660: p_rec.elr_attribute17 :=
661: ben_elr_shd.g_old_rec.elr_attribute17;
662: End If;
663: If (p_rec.elr_attribute18 = hr_api.g_varchar2) then
664: p_rec.elr_attribute18 :=
665: ben_elr_shd.g_old_rec.elr_attribute18;

Line 665: ben_elr_shd.g_old_rec.elr_attribute18;

661: ben_elr_shd.g_old_rec.elr_attribute17;
662: End If;
663: If (p_rec.elr_attribute18 = hr_api.g_varchar2) then
664: p_rec.elr_attribute18 :=
665: ben_elr_shd.g_old_rec.elr_attribute18;
666: End If;
667: If (p_rec.elr_attribute19 = hr_api.g_varchar2) then
668: p_rec.elr_attribute19 :=
669: ben_elr_shd.g_old_rec.elr_attribute19;

Line 669: ben_elr_shd.g_old_rec.elr_attribute19;

665: ben_elr_shd.g_old_rec.elr_attribute18;
666: End If;
667: If (p_rec.elr_attribute19 = hr_api.g_varchar2) then
668: p_rec.elr_attribute19 :=
669: ben_elr_shd.g_old_rec.elr_attribute19;
670: End If;
671: If (p_rec.elr_attribute20 = hr_api.g_varchar2) then
672: p_rec.elr_attribute20 :=
673: ben_elr_shd.g_old_rec.elr_attribute20;

Line 673: ben_elr_shd.g_old_rec.elr_attribute20;

669: ben_elr_shd.g_old_rec.elr_attribute19;
670: End If;
671: If (p_rec.elr_attribute20 = hr_api.g_varchar2) then
672: p_rec.elr_attribute20 :=
673: ben_elr_shd.g_old_rec.elr_attribute20;
674: End If;
675: If (p_rec.elr_attribute21 = hr_api.g_varchar2) then
676: p_rec.elr_attribute21 :=
677: ben_elr_shd.g_old_rec.elr_attribute21;

Line 677: ben_elr_shd.g_old_rec.elr_attribute21;

673: ben_elr_shd.g_old_rec.elr_attribute20;
674: End If;
675: If (p_rec.elr_attribute21 = hr_api.g_varchar2) then
676: p_rec.elr_attribute21 :=
677: ben_elr_shd.g_old_rec.elr_attribute21;
678: End If;
679: If (p_rec.elr_attribute22 = hr_api.g_varchar2) then
680: p_rec.elr_attribute22 :=
681: ben_elr_shd.g_old_rec.elr_attribute22;

Line 681: ben_elr_shd.g_old_rec.elr_attribute22;

677: ben_elr_shd.g_old_rec.elr_attribute21;
678: End If;
679: If (p_rec.elr_attribute22 = hr_api.g_varchar2) then
680: p_rec.elr_attribute22 :=
681: ben_elr_shd.g_old_rec.elr_attribute22;
682: End If;
683: If (p_rec.elr_attribute23 = hr_api.g_varchar2) then
684: p_rec.elr_attribute23 :=
685: ben_elr_shd.g_old_rec.elr_attribute23;

Line 685: ben_elr_shd.g_old_rec.elr_attribute23;

681: ben_elr_shd.g_old_rec.elr_attribute22;
682: End If;
683: If (p_rec.elr_attribute23 = hr_api.g_varchar2) then
684: p_rec.elr_attribute23 :=
685: ben_elr_shd.g_old_rec.elr_attribute23;
686: End If;
687: If (p_rec.elr_attribute24 = hr_api.g_varchar2) then
688: p_rec.elr_attribute24 :=
689: ben_elr_shd.g_old_rec.elr_attribute24;

Line 689: ben_elr_shd.g_old_rec.elr_attribute24;

685: ben_elr_shd.g_old_rec.elr_attribute23;
686: End If;
687: If (p_rec.elr_attribute24 = hr_api.g_varchar2) then
688: p_rec.elr_attribute24 :=
689: ben_elr_shd.g_old_rec.elr_attribute24;
690: End If;
691: If (p_rec.elr_attribute25 = hr_api.g_varchar2) then
692: p_rec.elr_attribute25 :=
693: ben_elr_shd.g_old_rec.elr_attribute25;

Line 693: ben_elr_shd.g_old_rec.elr_attribute25;

689: ben_elr_shd.g_old_rec.elr_attribute24;
690: End If;
691: If (p_rec.elr_attribute25 = hr_api.g_varchar2) then
692: p_rec.elr_attribute25 :=
693: ben_elr_shd.g_old_rec.elr_attribute25;
694: End If;
695: If (p_rec.elr_attribute26 = hr_api.g_varchar2) then
696: p_rec.elr_attribute26 :=
697: ben_elr_shd.g_old_rec.elr_attribute26;

Line 697: ben_elr_shd.g_old_rec.elr_attribute26;

693: ben_elr_shd.g_old_rec.elr_attribute25;
694: End If;
695: If (p_rec.elr_attribute26 = hr_api.g_varchar2) then
696: p_rec.elr_attribute26 :=
697: ben_elr_shd.g_old_rec.elr_attribute26;
698: End If;
699: If (p_rec.elr_attribute27 = hr_api.g_varchar2) then
700: p_rec.elr_attribute27 :=
701: ben_elr_shd.g_old_rec.elr_attribute27;

Line 701: ben_elr_shd.g_old_rec.elr_attribute27;

697: ben_elr_shd.g_old_rec.elr_attribute26;
698: End If;
699: If (p_rec.elr_attribute27 = hr_api.g_varchar2) then
700: p_rec.elr_attribute27 :=
701: ben_elr_shd.g_old_rec.elr_attribute27;
702: End If;
703: If (p_rec.elr_attribute28 = hr_api.g_varchar2) then
704: p_rec.elr_attribute28 :=
705: ben_elr_shd.g_old_rec.elr_attribute28;

Line 705: ben_elr_shd.g_old_rec.elr_attribute28;

701: ben_elr_shd.g_old_rec.elr_attribute27;
702: End If;
703: If (p_rec.elr_attribute28 = hr_api.g_varchar2) then
704: p_rec.elr_attribute28 :=
705: ben_elr_shd.g_old_rec.elr_attribute28;
706: End If;
707: If (p_rec.elr_attribute29 = hr_api.g_varchar2) then
708: p_rec.elr_attribute29 :=
709: ben_elr_shd.g_old_rec.elr_attribute29;

Line 709: ben_elr_shd.g_old_rec.elr_attribute29;

705: ben_elr_shd.g_old_rec.elr_attribute28;
706: End If;
707: If (p_rec.elr_attribute29 = hr_api.g_varchar2) then
708: p_rec.elr_attribute29 :=
709: ben_elr_shd.g_old_rec.elr_attribute29;
710: End If;
711: If (p_rec.elr_attribute30 = hr_api.g_varchar2) then
712: p_rec.elr_attribute30 :=
713: ben_elr_shd.g_old_rec.elr_attribute30;

Line 713: ben_elr_shd.g_old_rec.elr_attribute30;

709: ben_elr_shd.g_old_rec.elr_attribute29;
710: End If;
711: If (p_rec.elr_attribute30 = hr_api.g_varchar2) then
712: p_rec.elr_attribute30 :=
713: ben_elr_shd.g_old_rec.elr_attribute30;
714: End If;
715: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
716: p_rec.absence_attendance_type_id :=
717: ben_elr_shd.g_old_rec.absence_attendance_type_id;

Line 717: ben_elr_shd.g_old_rec.absence_attendance_type_id;

713: ben_elr_shd.g_old_rec.elr_attribute30;
714: End If;
715: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
716: p_rec.absence_attendance_type_id :=
717: ben_elr_shd.g_old_rec.absence_attendance_type_id;
718: End If;
719: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
720: p_rec.abs_attendance_reason_id :=
721: ben_elr_shd.g_old_rec.abs_attendance_reason_id;

Line 721: ben_elr_shd.g_old_rec.abs_attendance_reason_id;

717: ben_elr_shd.g_old_rec.absence_attendance_type_id;
718: End If;
719: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
720: p_rec.abs_attendance_reason_id :=
721: ben_elr_shd.g_old_rec.abs_attendance_reason_id;
722: End If;
723: If (p_rec.criteria_score = hr_api.g_number) then
724: p_rec.criteria_score :=
725: ben_elr_shd.g_old_rec.criteria_score;

Line 725: ben_elr_shd.g_old_rec.criteria_score;

721: ben_elr_shd.g_old_rec.abs_attendance_reason_id;
722: End If;
723: If (p_rec.criteria_score = hr_api.g_number) then
724: p_rec.criteria_score :=
725: ben_elr_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_elr_shd.g_old_rec.criteria_weight;

Line 729: ben_elr_shd.g_old_rec.criteria_weight;

725: ben_elr_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_elr_shd.g_old_rec.criteria_weight;
730: End If;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: --

Line 741: p_rec in out nocopy ben_elr_shd.g_rec_type,

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

Line 759: ben_elr_shd.lck

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

Line 861: l_rec ben_elr_shd.g_rec_type;

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

Line 871: ben_elr_shd.convert_args

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