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_EBU_UPD dependencies on BEN_EBU_SHD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_ebu_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 456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date

452: ,p_effective_date =>p_effective_date
453: ,p_datetrack_mode =>p_datetrack_mode
454: ,p_validation_start_date =>p_validation_start_date
455: ,p_validation_end_date =>p_validation_end_date
456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id

Line 457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date

453: ,p_datetrack_mode =>p_datetrack_mode
454: ,p_validation_start_date =>p_validation_start_date
455: ,p_validation_end_date =>p_validation_end_date
456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num

Line 458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id

454: ,p_validation_start_date =>p_validation_start_date
455: ,p_validation_end_date =>p_validation_end_date
456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag

Line 459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd

455: ,p_validation_end_date =>p_validation_end_date
456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category

Line 460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id

456: ,p_effective_start_date_o =>ben_ebu_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1

Line 461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num

457: ,p_effective_end_date_o =>ben_ebu_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2

Line 462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag

458: ,p_business_group_id_o =>ben_ebu_shd.g_old_rec.business_group_id
459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3

Line 463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category

459: ,p_brgng_unit_cd_o =>ben_ebu_shd.g_old_rec.brgng_unit_cd
460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4

Line 464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1

460: ,p_eligy_prfl_id_o =>ben_ebu_shd.g_old_rec.eligy_prfl_id
461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5

Line 465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2

461: ,p_ordr_num_o =>ben_ebu_shd.g_old_rec.ordr_num
462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6

Line 466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3

462: ,p_excld_flag_o =>ben_ebu_shd.g_old_rec.excld_flag
463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7

Line 467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4

463: ,p_ebu_attribute_category_o =>ben_ebu_shd.g_old_rec.ebu_attribute_category
464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8

Line 468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5

464: ,p_ebu_attribute1_o =>ben_ebu_shd.g_old_rec.ebu_attribute1
465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9

Line 469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6

465: ,p_ebu_attribute2_o =>ben_ebu_shd.g_old_rec.ebu_attribute2
466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10

Line 470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7

466: ,p_ebu_attribute3_o =>ben_ebu_shd.g_old_rec.ebu_attribute3
467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11

Line 471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8

467: ,p_ebu_attribute4_o =>ben_ebu_shd.g_old_rec.ebu_attribute4
468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12

Line 472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9

468: ,p_ebu_attribute5_o =>ben_ebu_shd.g_old_rec.ebu_attribute5
469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13

Line 473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10

469: ,p_ebu_attribute6_o =>ben_ebu_shd.g_old_rec.ebu_attribute6
470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14

Line 474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11

470: ,p_ebu_attribute7_o =>ben_ebu_shd.g_old_rec.ebu_attribute7
471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15

Line 475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12

471: ,p_ebu_attribute8_o =>ben_ebu_shd.g_old_rec.ebu_attribute8
472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16

Line 476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13

472: ,p_ebu_attribute9_o =>ben_ebu_shd.g_old_rec.ebu_attribute9
473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17

Line 477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14

473: ,p_ebu_attribute10_o =>ben_ebu_shd.g_old_rec.ebu_attribute10
474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18

Line 478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15

474: ,p_ebu_attribute11_o =>ben_ebu_shd.g_old_rec.ebu_attribute11
475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19

Line 479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16

475: ,p_ebu_attribute12_o =>ben_ebu_shd.g_old_rec.ebu_attribute12
476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20

Line 480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17

476: ,p_ebu_attribute13_o =>ben_ebu_shd.g_old_rec.ebu_attribute13
477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21

Line 481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18

477: ,p_ebu_attribute14_o =>ben_ebu_shd.g_old_rec.ebu_attribute14
478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22

Line 482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19

478: ,p_ebu_attribute15_o =>ben_ebu_shd.g_old_rec.ebu_attribute15
479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23

Line 483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20

479: ,p_ebu_attribute16_o =>ben_ebu_shd.g_old_rec.ebu_attribute16
480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24

Line 484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21

480: ,p_ebu_attribute17_o =>ben_ebu_shd.g_old_rec.ebu_attribute17
481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25

Line 485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22

481: ,p_ebu_attribute18_o =>ben_ebu_shd.g_old_rec.ebu_attribute18
482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26

Line 486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23

482: ,p_ebu_attribute19_o =>ben_ebu_shd.g_old_rec.ebu_attribute19
483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27

Line 487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24

483: ,p_ebu_attribute20_o =>ben_ebu_shd.g_old_rec.ebu_attribute20
484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28

Line 488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25

484: ,p_ebu_attribute21_o =>ben_ebu_shd.g_old_rec.ebu_attribute21
485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29

Line 489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26

485: ,p_ebu_attribute22_o =>ben_ebu_shd.g_old_rec.ebu_attribute22
486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30

Line 490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27

486: ,p_ebu_attribute23_o =>ben_ebu_shd.g_old_rec.ebu_attribute23
487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number

Line 491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28

487: ,p_ebu_attribute24_o =>ben_ebu_shd.g_old_rec.ebu_attribute24
488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score

Line 492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29

488: ,p_ebu_attribute25_o =>ben_ebu_shd.g_old_rec.ebu_attribute25
489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight

Line 493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30

489: ,p_ebu_attribute26_o =>ben_ebu_shd.g_old_rec.ebu_attribute26
490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score

Line 494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number

490: ,p_ebu_attribute27_o =>ben_ebu_shd.g_old_rec.ebu_attribute27
491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight

Line 495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score

491: ,p_ebu_attribute28_o =>ben_ebu_shd.g_old_rec.ebu_attribute28
492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight
499:

Line 496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight

492: ,p_ebu_attribute29_o =>ben_ebu_shd.g_old_rec.ebu_attribute29
493: ,p_ebu_attribute30_o =>ben_ebu_shd.g_old_rec.ebu_attribute30
494: ,p_object_version_number_o =>ben_ebu_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_ebu_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_ebu_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight
499:
500: );

Line 561: Procedure convert_defs(p_rec in out nocopy ben_ebu_shd.g_rec_type) is

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

Line 576: ben_ebu_shd.g_old_rec.business_group_id;

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

Line 580: ben_ebu_shd.g_old_rec.brgng_unit_cd;

576: ben_ebu_shd.g_old_rec.business_group_id;
577: End If;
578: If (p_rec.brgng_unit_cd = hr_api.g_varchar2) then
579: p_rec.brgng_unit_cd :=
580: ben_ebu_shd.g_old_rec.brgng_unit_cd;
581: End If;
582: If (p_rec.eligy_prfl_id = hr_api.g_number) then
583: p_rec.eligy_prfl_id :=
584: ben_ebu_shd.g_old_rec.eligy_prfl_id;

Line 584: ben_ebu_shd.g_old_rec.eligy_prfl_id;

580: ben_ebu_shd.g_old_rec.brgng_unit_cd;
581: End If;
582: If (p_rec.eligy_prfl_id = hr_api.g_number) then
583: p_rec.eligy_prfl_id :=
584: ben_ebu_shd.g_old_rec.eligy_prfl_id;
585: End If;
586: If (p_rec.ordr_num = hr_api.g_number) then
587: p_rec.ordr_num :=
588: ben_ebu_shd.g_old_rec.ordr_num;

Line 588: ben_ebu_shd.g_old_rec.ordr_num;

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

Line 592: ben_ebu_shd.g_old_rec.excld_flag;

588: ben_ebu_shd.g_old_rec.ordr_num;
589: End If;
590: If (p_rec.excld_flag = hr_api.g_varchar2) then
591: p_rec.excld_flag :=
592: ben_ebu_shd.g_old_rec.excld_flag;
593: End If;
594: If (p_rec.ebu_attribute_category = hr_api.g_varchar2) then
595: p_rec.ebu_attribute_category :=
596: ben_ebu_shd.g_old_rec.ebu_attribute_category;

Line 596: ben_ebu_shd.g_old_rec.ebu_attribute_category;

592: ben_ebu_shd.g_old_rec.excld_flag;
593: End If;
594: If (p_rec.ebu_attribute_category = hr_api.g_varchar2) then
595: p_rec.ebu_attribute_category :=
596: ben_ebu_shd.g_old_rec.ebu_attribute_category;
597: End If;
598: If (p_rec.ebu_attribute1 = hr_api.g_varchar2) then
599: p_rec.ebu_attribute1 :=
600: ben_ebu_shd.g_old_rec.ebu_attribute1;

Line 600: ben_ebu_shd.g_old_rec.ebu_attribute1;

596: ben_ebu_shd.g_old_rec.ebu_attribute_category;
597: End If;
598: If (p_rec.ebu_attribute1 = hr_api.g_varchar2) then
599: p_rec.ebu_attribute1 :=
600: ben_ebu_shd.g_old_rec.ebu_attribute1;
601: End If;
602: If (p_rec.ebu_attribute2 = hr_api.g_varchar2) then
603: p_rec.ebu_attribute2 :=
604: ben_ebu_shd.g_old_rec.ebu_attribute2;

Line 604: ben_ebu_shd.g_old_rec.ebu_attribute2;

600: ben_ebu_shd.g_old_rec.ebu_attribute1;
601: End If;
602: If (p_rec.ebu_attribute2 = hr_api.g_varchar2) then
603: p_rec.ebu_attribute2 :=
604: ben_ebu_shd.g_old_rec.ebu_attribute2;
605: End If;
606: If (p_rec.ebu_attribute3 = hr_api.g_varchar2) then
607: p_rec.ebu_attribute3 :=
608: ben_ebu_shd.g_old_rec.ebu_attribute3;

Line 608: ben_ebu_shd.g_old_rec.ebu_attribute3;

604: ben_ebu_shd.g_old_rec.ebu_attribute2;
605: End If;
606: If (p_rec.ebu_attribute3 = hr_api.g_varchar2) then
607: p_rec.ebu_attribute3 :=
608: ben_ebu_shd.g_old_rec.ebu_attribute3;
609: End If;
610: If (p_rec.ebu_attribute4 = hr_api.g_varchar2) then
611: p_rec.ebu_attribute4 :=
612: ben_ebu_shd.g_old_rec.ebu_attribute4;

Line 612: ben_ebu_shd.g_old_rec.ebu_attribute4;

608: ben_ebu_shd.g_old_rec.ebu_attribute3;
609: End If;
610: If (p_rec.ebu_attribute4 = hr_api.g_varchar2) then
611: p_rec.ebu_attribute4 :=
612: ben_ebu_shd.g_old_rec.ebu_attribute4;
613: End If;
614: If (p_rec.ebu_attribute5 = hr_api.g_varchar2) then
615: p_rec.ebu_attribute5 :=
616: ben_ebu_shd.g_old_rec.ebu_attribute5;

Line 616: ben_ebu_shd.g_old_rec.ebu_attribute5;

612: ben_ebu_shd.g_old_rec.ebu_attribute4;
613: End If;
614: If (p_rec.ebu_attribute5 = hr_api.g_varchar2) then
615: p_rec.ebu_attribute5 :=
616: ben_ebu_shd.g_old_rec.ebu_attribute5;
617: End If;
618: If (p_rec.ebu_attribute6 = hr_api.g_varchar2) then
619: p_rec.ebu_attribute6 :=
620: ben_ebu_shd.g_old_rec.ebu_attribute6;

Line 620: ben_ebu_shd.g_old_rec.ebu_attribute6;

616: ben_ebu_shd.g_old_rec.ebu_attribute5;
617: End If;
618: If (p_rec.ebu_attribute6 = hr_api.g_varchar2) then
619: p_rec.ebu_attribute6 :=
620: ben_ebu_shd.g_old_rec.ebu_attribute6;
621: End If;
622: If (p_rec.ebu_attribute7 = hr_api.g_varchar2) then
623: p_rec.ebu_attribute7 :=
624: ben_ebu_shd.g_old_rec.ebu_attribute7;

Line 624: ben_ebu_shd.g_old_rec.ebu_attribute7;

620: ben_ebu_shd.g_old_rec.ebu_attribute6;
621: End If;
622: If (p_rec.ebu_attribute7 = hr_api.g_varchar2) then
623: p_rec.ebu_attribute7 :=
624: ben_ebu_shd.g_old_rec.ebu_attribute7;
625: End If;
626: If (p_rec.ebu_attribute8 = hr_api.g_varchar2) then
627: p_rec.ebu_attribute8 :=
628: ben_ebu_shd.g_old_rec.ebu_attribute8;

Line 628: ben_ebu_shd.g_old_rec.ebu_attribute8;

624: ben_ebu_shd.g_old_rec.ebu_attribute7;
625: End If;
626: If (p_rec.ebu_attribute8 = hr_api.g_varchar2) then
627: p_rec.ebu_attribute8 :=
628: ben_ebu_shd.g_old_rec.ebu_attribute8;
629: End If;
630: If (p_rec.ebu_attribute9 = hr_api.g_varchar2) then
631: p_rec.ebu_attribute9 :=
632: ben_ebu_shd.g_old_rec.ebu_attribute9;

Line 632: ben_ebu_shd.g_old_rec.ebu_attribute9;

628: ben_ebu_shd.g_old_rec.ebu_attribute8;
629: End If;
630: If (p_rec.ebu_attribute9 = hr_api.g_varchar2) then
631: p_rec.ebu_attribute9 :=
632: ben_ebu_shd.g_old_rec.ebu_attribute9;
633: End If;
634: If (p_rec.ebu_attribute10 = hr_api.g_varchar2) then
635: p_rec.ebu_attribute10 :=
636: ben_ebu_shd.g_old_rec.ebu_attribute10;

Line 636: ben_ebu_shd.g_old_rec.ebu_attribute10;

632: ben_ebu_shd.g_old_rec.ebu_attribute9;
633: End If;
634: If (p_rec.ebu_attribute10 = hr_api.g_varchar2) then
635: p_rec.ebu_attribute10 :=
636: ben_ebu_shd.g_old_rec.ebu_attribute10;
637: End If;
638: If (p_rec.ebu_attribute11 = hr_api.g_varchar2) then
639: p_rec.ebu_attribute11 :=
640: ben_ebu_shd.g_old_rec.ebu_attribute11;

Line 640: ben_ebu_shd.g_old_rec.ebu_attribute11;

636: ben_ebu_shd.g_old_rec.ebu_attribute10;
637: End If;
638: If (p_rec.ebu_attribute11 = hr_api.g_varchar2) then
639: p_rec.ebu_attribute11 :=
640: ben_ebu_shd.g_old_rec.ebu_attribute11;
641: End If;
642: If (p_rec.ebu_attribute12 = hr_api.g_varchar2) then
643: p_rec.ebu_attribute12 :=
644: ben_ebu_shd.g_old_rec.ebu_attribute12;

Line 644: ben_ebu_shd.g_old_rec.ebu_attribute12;

640: ben_ebu_shd.g_old_rec.ebu_attribute11;
641: End If;
642: If (p_rec.ebu_attribute12 = hr_api.g_varchar2) then
643: p_rec.ebu_attribute12 :=
644: ben_ebu_shd.g_old_rec.ebu_attribute12;
645: End If;
646: If (p_rec.ebu_attribute13 = hr_api.g_varchar2) then
647: p_rec.ebu_attribute13 :=
648: ben_ebu_shd.g_old_rec.ebu_attribute13;

Line 648: ben_ebu_shd.g_old_rec.ebu_attribute13;

644: ben_ebu_shd.g_old_rec.ebu_attribute12;
645: End If;
646: If (p_rec.ebu_attribute13 = hr_api.g_varchar2) then
647: p_rec.ebu_attribute13 :=
648: ben_ebu_shd.g_old_rec.ebu_attribute13;
649: End If;
650: If (p_rec.ebu_attribute14 = hr_api.g_varchar2) then
651: p_rec.ebu_attribute14 :=
652: ben_ebu_shd.g_old_rec.ebu_attribute14;

Line 652: ben_ebu_shd.g_old_rec.ebu_attribute14;

648: ben_ebu_shd.g_old_rec.ebu_attribute13;
649: End If;
650: If (p_rec.ebu_attribute14 = hr_api.g_varchar2) then
651: p_rec.ebu_attribute14 :=
652: ben_ebu_shd.g_old_rec.ebu_attribute14;
653: End If;
654: If (p_rec.ebu_attribute15 = hr_api.g_varchar2) then
655: p_rec.ebu_attribute15 :=
656: ben_ebu_shd.g_old_rec.ebu_attribute15;

Line 656: ben_ebu_shd.g_old_rec.ebu_attribute15;

652: ben_ebu_shd.g_old_rec.ebu_attribute14;
653: End If;
654: If (p_rec.ebu_attribute15 = hr_api.g_varchar2) then
655: p_rec.ebu_attribute15 :=
656: ben_ebu_shd.g_old_rec.ebu_attribute15;
657: End If;
658: If (p_rec.ebu_attribute16 = hr_api.g_varchar2) then
659: p_rec.ebu_attribute16 :=
660: ben_ebu_shd.g_old_rec.ebu_attribute16;

Line 660: ben_ebu_shd.g_old_rec.ebu_attribute16;

656: ben_ebu_shd.g_old_rec.ebu_attribute15;
657: End If;
658: If (p_rec.ebu_attribute16 = hr_api.g_varchar2) then
659: p_rec.ebu_attribute16 :=
660: ben_ebu_shd.g_old_rec.ebu_attribute16;
661: End If;
662: If (p_rec.ebu_attribute17 = hr_api.g_varchar2) then
663: p_rec.ebu_attribute17 :=
664: ben_ebu_shd.g_old_rec.ebu_attribute17;

Line 664: ben_ebu_shd.g_old_rec.ebu_attribute17;

660: ben_ebu_shd.g_old_rec.ebu_attribute16;
661: End If;
662: If (p_rec.ebu_attribute17 = hr_api.g_varchar2) then
663: p_rec.ebu_attribute17 :=
664: ben_ebu_shd.g_old_rec.ebu_attribute17;
665: End If;
666: If (p_rec.ebu_attribute18 = hr_api.g_varchar2) then
667: p_rec.ebu_attribute18 :=
668: ben_ebu_shd.g_old_rec.ebu_attribute18;

Line 668: ben_ebu_shd.g_old_rec.ebu_attribute18;

664: ben_ebu_shd.g_old_rec.ebu_attribute17;
665: End If;
666: If (p_rec.ebu_attribute18 = hr_api.g_varchar2) then
667: p_rec.ebu_attribute18 :=
668: ben_ebu_shd.g_old_rec.ebu_attribute18;
669: End If;
670: If (p_rec.ebu_attribute19 = hr_api.g_varchar2) then
671: p_rec.ebu_attribute19 :=
672: ben_ebu_shd.g_old_rec.ebu_attribute19;

Line 672: ben_ebu_shd.g_old_rec.ebu_attribute19;

668: ben_ebu_shd.g_old_rec.ebu_attribute18;
669: End If;
670: If (p_rec.ebu_attribute19 = hr_api.g_varchar2) then
671: p_rec.ebu_attribute19 :=
672: ben_ebu_shd.g_old_rec.ebu_attribute19;
673: End If;
674: If (p_rec.ebu_attribute20 = hr_api.g_varchar2) then
675: p_rec.ebu_attribute20 :=
676: ben_ebu_shd.g_old_rec.ebu_attribute20;

Line 676: ben_ebu_shd.g_old_rec.ebu_attribute20;

672: ben_ebu_shd.g_old_rec.ebu_attribute19;
673: End If;
674: If (p_rec.ebu_attribute20 = hr_api.g_varchar2) then
675: p_rec.ebu_attribute20 :=
676: ben_ebu_shd.g_old_rec.ebu_attribute20;
677: End If;
678: If (p_rec.ebu_attribute21 = hr_api.g_varchar2) then
679: p_rec.ebu_attribute21 :=
680: ben_ebu_shd.g_old_rec.ebu_attribute21;

Line 680: ben_ebu_shd.g_old_rec.ebu_attribute21;

676: ben_ebu_shd.g_old_rec.ebu_attribute20;
677: End If;
678: If (p_rec.ebu_attribute21 = hr_api.g_varchar2) then
679: p_rec.ebu_attribute21 :=
680: ben_ebu_shd.g_old_rec.ebu_attribute21;
681: End If;
682: If (p_rec.ebu_attribute22 = hr_api.g_varchar2) then
683: p_rec.ebu_attribute22 :=
684: ben_ebu_shd.g_old_rec.ebu_attribute22;

Line 684: ben_ebu_shd.g_old_rec.ebu_attribute22;

680: ben_ebu_shd.g_old_rec.ebu_attribute21;
681: End If;
682: If (p_rec.ebu_attribute22 = hr_api.g_varchar2) then
683: p_rec.ebu_attribute22 :=
684: ben_ebu_shd.g_old_rec.ebu_attribute22;
685: End If;
686: If (p_rec.ebu_attribute23 = hr_api.g_varchar2) then
687: p_rec.ebu_attribute23 :=
688: ben_ebu_shd.g_old_rec.ebu_attribute23;

Line 688: ben_ebu_shd.g_old_rec.ebu_attribute23;

684: ben_ebu_shd.g_old_rec.ebu_attribute22;
685: End If;
686: If (p_rec.ebu_attribute23 = hr_api.g_varchar2) then
687: p_rec.ebu_attribute23 :=
688: ben_ebu_shd.g_old_rec.ebu_attribute23;
689: End If;
690: If (p_rec.ebu_attribute24 = hr_api.g_varchar2) then
691: p_rec.ebu_attribute24 :=
692: ben_ebu_shd.g_old_rec.ebu_attribute24;

Line 692: ben_ebu_shd.g_old_rec.ebu_attribute24;

688: ben_ebu_shd.g_old_rec.ebu_attribute23;
689: End If;
690: If (p_rec.ebu_attribute24 = hr_api.g_varchar2) then
691: p_rec.ebu_attribute24 :=
692: ben_ebu_shd.g_old_rec.ebu_attribute24;
693: End If;
694: If (p_rec.ebu_attribute25 = hr_api.g_varchar2) then
695: p_rec.ebu_attribute25 :=
696: ben_ebu_shd.g_old_rec.ebu_attribute25;

Line 696: ben_ebu_shd.g_old_rec.ebu_attribute25;

692: ben_ebu_shd.g_old_rec.ebu_attribute24;
693: End If;
694: If (p_rec.ebu_attribute25 = hr_api.g_varchar2) then
695: p_rec.ebu_attribute25 :=
696: ben_ebu_shd.g_old_rec.ebu_attribute25;
697: End If;
698: If (p_rec.ebu_attribute26 = hr_api.g_varchar2) then
699: p_rec.ebu_attribute26 :=
700: ben_ebu_shd.g_old_rec.ebu_attribute26;

Line 700: ben_ebu_shd.g_old_rec.ebu_attribute26;

696: ben_ebu_shd.g_old_rec.ebu_attribute25;
697: End If;
698: If (p_rec.ebu_attribute26 = hr_api.g_varchar2) then
699: p_rec.ebu_attribute26 :=
700: ben_ebu_shd.g_old_rec.ebu_attribute26;
701: End If;
702: If (p_rec.ebu_attribute27 = hr_api.g_varchar2) then
703: p_rec.ebu_attribute27 :=
704: ben_ebu_shd.g_old_rec.ebu_attribute27;

Line 704: ben_ebu_shd.g_old_rec.ebu_attribute27;

700: ben_ebu_shd.g_old_rec.ebu_attribute26;
701: End If;
702: If (p_rec.ebu_attribute27 = hr_api.g_varchar2) then
703: p_rec.ebu_attribute27 :=
704: ben_ebu_shd.g_old_rec.ebu_attribute27;
705: End If;
706: If (p_rec.ebu_attribute28 = hr_api.g_varchar2) then
707: p_rec.ebu_attribute28 :=
708: ben_ebu_shd.g_old_rec.ebu_attribute28;

Line 708: ben_ebu_shd.g_old_rec.ebu_attribute28;

704: ben_ebu_shd.g_old_rec.ebu_attribute27;
705: End If;
706: If (p_rec.ebu_attribute28 = hr_api.g_varchar2) then
707: p_rec.ebu_attribute28 :=
708: ben_ebu_shd.g_old_rec.ebu_attribute28;
709: End If;
710: If (p_rec.ebu_attribute29 = hr_api.g_varchar2) then
711: p_rec.ebu_attribute29 :=
712: ben_ebu_shd.g_old_rec.ebu_attribute29;

Line 712: ben_ebu_shd.g_old_rec.ebu_attribute29;

708: ben_ebu_shd.g_old_rec.ebu_attribute28;
709: End If;
710: If (p_rec.ebu_attribute29 = hr_api.g_varchar2) then
711: p_rec.ebu_attribute29 :=
712: ben_ebu_shd.g_old_rec.ebu_attribute29;
713: End If;
714: If (p_rec.ebu_attribute30 = hr_api.g_varchar2) then
715: p_rec.ebu_attribute30 :=
716: ben_ebu_shd.g_old_rec.ebu_attribute30;

Line 716: ben_ebu_shd.g_old_rec.ebu_attribute30;

712: ben_ebu_shd.g_old_rec.ebu_attribute29;
713: End If;
714: If (p_rec.ebu_attribute30 = hr_api.g_varchar2) then
715: p_rec.ebu_attribute30 :=
716: ben_ebu_shd.g_old_rec.ebu_attribute30;
717: End If;
718:
719: If (p_rec.criteria_score = hr_api.g_number) then
720: p_rec.criteria_score :=

Line 721: ben_ebu_shd.g_old_rec.criteria_score;

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

Line 726: ben_ebu_shd.g_old_rec.criteria_weight;

722: End If;
723:
724: If (p_rec.criteria_weight = hr_api.g_number) then
725: p_rec.criteria_weight :=
726: ben_ebu_shd.g_old_rec.criteria_weight;
727: End If;
728:
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 739: p_rec in out nocopy ben_ebu_shd.g_rec_type,

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

Line 757: ben_ebu_shd.lck

753: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
754: --
755: -- We must lock the row which we need to update.
756: --
757: ben_ebu_shd.lck
758: (p_effective_date => p_effective_date,
759: p_datetrack_mode => p_datetrack_mode,
760: p_elig_brgng_unit_prte_id => p_rec.elig_brgng_unit_prte_id,
761: p_object_version_number => p_rec.object_version_number,

Line 858: l_rec ben_ebu_shd.g_rec_type;

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

Line 868: ben_ebu_shd.convert_args

864: -- Call conversion function to turn arguments into the
865: -- l_rec structure.
866: --
867: l_rec :=
868: ben_ebu_shd.convert_args
869: (
870: p_elig_brgng_unit_prte_id,
871: null,
872: null,