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_ETU_UPD dependencies on BEN_ETU_SHD

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

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

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

Line 131: ben_etu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 143: ben_etu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: ben_etu_shd.constraint_error

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

Line 148: ben_etu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 149: ben_etu_shd.constraint_error

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

Line 152: ben_etu_shd.g_api_dml := false; -- Unset the api dml status

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

Line 188: (p_rec in out nocopy ben_etu_shd.g_rec_type,

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

Line 252: (p_rec in out nocopy ben_etu_shd.g_rec_type,

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

Line 268: ben_etu_shd.upd_effective_end_date

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

Line 337: (p_rec in out nocopy ben_etu_shd.g_rec_type,

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

Line 393: (p_rec in ben_etu_shd.g_rec_type,

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

Line 455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date

451: ,p_effective_date =>p_effective_date
452: ,p_datetrack_mode =>p_datetrack_mode
453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag

Line 456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date

452: ,p_datetrack_mode =>p_datetrack_mode
453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num

Line 457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id

453: ,p_validation_start_date =>p_validation_start_date
454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag

Line 458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id

454: ,p_validation_end_date =>p_validation_end_date
455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category

Line 459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag

455: ,p_effective_start_date_o =>ben_etu_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1

Line 460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num

456: ,p_effective_end_date_o =>ben_etu_shd.g_old_rec.effective_end_date
457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2

Line 461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag

457: ,p_business_group_id_o =>ben_etu_shd.g_old_rec.business_group_id
458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3

Line 462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category

458: ,p_eligy_prfl_id_o =>ben_etu_shd.g_old_rec.eligy_prfl_id
459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4

Line 463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1

459: ,p_excld_flag_o =>ben_etu_shd.g_old_rec.excld_flag
460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5

Line 464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2

460: ,p_ordr_num_o =>ben_etu_shd.g_old_rec.ordr_num
461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6

Line 465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3

461: ,p_uses_tbco_flag_o =>ben_etu_shd.g_old_rec.uses_tbco_flag
462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7

Line 466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4

462: ,p_etu_attribute_category_o =>ben_etu_shd.g_old_rec.etu_attribute_category
463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8

Line 467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5

463: ,p_etu_attribute1_o =>ben_etu_shd.g_old_rec.etu_attribute1
464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9

Line 468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6

464: ,p_etu_attribute2_o =>ben_etu_shd.g_old_rec.etu_attribute2
465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10

Line 469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7

465: ,p_etu_attribute3_o =>ben_etu_shd.g_old_rec.etu_attribute3
466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11

Line 470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8

466: ,p_etu_attribute4_o =>ben_etu_shd.g_old_rec.etu_attribute4
467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12

Line 471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9

467: ,p_etu_attribute5_o =>ben_etu_shd.g_old_rec.etu_attribute5
468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13

Line 472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10

468: ,p_etu_attribute6_o =>ben_etu_shd.g_old_rec.etu_attribute6
469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14

Line 473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11

469: ,p_etu_attribute7_o =>ben_etu_shd.g_old_rec.etu_attribute7
470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15

Line 474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12

470: ,p_etu_attribute8_o =>ben_etu_shd.g_old_rec.etu_attribute8
471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16

Line 475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13

471: ,p_etu_attribute9_o =>ben_etu_shd.g_old_rec.etu_attribute9
472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17

Line 476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14

472: ,p_etu_attribute10_o =>ben_etu_shd.g_old_rec.etu_attribute10
473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18

Line 477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15

473: ,p_etu_attribute11_o =>ben_etu_shd.g_old_rec.etu_attribute11
474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19

Line 478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16

474: ,p_etu_attribute12_o =>ben_etu_shd.g_old_rec.etu_attribute12
475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20

Line 479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17

475: ,p_etu_attribute13_o =>ben_etu_shd.g_old_rec.etu_attribute13
476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21

Line 480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18

476: ,p_etu_attribute14_o =>ben_etu_shd.g_old_rec.etu_attribute14
477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22

Line 481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19

477: ,p_etu_attribute15_o =>ben_etu_shd.g_old_rec.etu_attribute15
478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23

Line 482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20

478: ,p_etu_attribute16_o =>ben_etu_shd.g_old_rec.etu_attribute16
479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24

Line 483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21

479: ,p_etu_attribute17_o =>ben_etu_shd.g_old_rec.etu_attribute17
480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25

Line 484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22

480: ,p_etu_attribute18_o =>ben_etu_shd.g_old_rec.etu_attribute18
481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26

Line 485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23

481: ,p_etu_attribute19_o =>ben_etu_shd.g_old_rec.etu_attribute19
482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27

Line 486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24

482: ,p_etu_attribute20_o =>ben_etu_shd.g_old_rec.etu_attribute20
483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28

Line 487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25

483: ,p_etu_attribute21_o =>ben_etu_shd.g_old_rec.etu_attribute21
484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29

Line 488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26

484: ,p_etu_attribute22_o =>ben_etu_shd.g_old_rec.etu_attribute22
485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30

Line 489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27

485: ,p_etu_attribute23_o =>ben_etu_shd.g_old_rec.etu_attribute23
486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number

Line 490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28

486: ,p_etu_attribute24_o =>ben_etu_shd.g_old_rec.etu_attribute24
487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score

Line 491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29

487: ,p_etu_attribute25_o =>ben_etu_shd.g_old_rec.etu_attribute25
488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score
495: ,p_criteria_weight =>p_rec.criteria_weight

Line 492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30

488: ,p_etu_attribute26_o =>ben_etu_shd.g_old_rec.etu_attribute26
489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score
495: ,p_criteria_weight =>p_rec.criteria_weight
496: ,p_criteria_score_o =>ben_etu_shd.g_old_rec.criteria_score

Line 493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number

489: ,p_etu_attribute27_o =>ben_etu_shd.g_old_rec.etu_attribute27
490: ,p_etu_attribute28_o =>ben_etu_shd.g_old_rec.etu_attribute28
491: ,p_etu_attribute29_o =>ben_etu_shd.g_old_rec.etu_attribute29
492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score
495: ,p_criteria_weight =>p_rec.criteria_weight
496: ,p_criteria_score_o =>ben_etu_shd.g_old_rec.criteria_score
497: ,p_criteria_weight_o =>ben_etu_shd.g_old_rec.criteria_weight

Line 496: ,p_criteria_score_o =>ben_etu_shd.g_old_rec.criteria_score

492: ,p_etu_attribute30_o =>ben_etu_shd.g_old_rec.etu_attribute30
493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score
495: ,p_criteria_weight =>p_rec.criteria_weight
496: ,p_criteria_score_o =>ben_etu_shd.g_old_rec.criteria_score
497: ,p_criteria_weight_o =>ben_etu_shd.g_old_rec.criteria_weight
498:
499: );
500: --

Line 497: ,p_criteria_weight_o =>ben_etu_shd.g_old_rec.criteria_weight

493: ,p_object_version_number_o =>ben_etu_shd.g_old_rec.object_version_number
494: ,p_criteria_score =>p_rec.criteria_score
495: ,p_criteria_weight =>p_rec.criteria_weight
496: ,p_criteria_score_o =>ben_etu_shd.g_old_rec.criteria_score
497: ,p_criteria_weight_o =>ben_etu_shd.g_old_rec.criteria_weight
498:
499: );
500: --
501: exception

Line 560: Procedure convert_defs(p_rec in out nocopy ben_etu_shd.g_rec_type) is

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

Line 575: ben_etu_shd.g_old_rec.business_group_id;

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

Line 579: ben_etu_shd.g_old_rec.eligy_prfl_id;

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

Line 583: ben_etu_shd.g_old_rec.excld_flag;

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

Line 587: ben_etu_shd.g_old_rec.ordr_num;

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

Line 591: ben_etu_shd.g_old_rec.uses_tbco_flag;

587: ben_etu_shd.g_old_rec.ordr_num;
588: End If;
589: If (p_rec.uses_tbco_flag = hr_api.g_varchar2) then
590: p_rec.uses_tbco_flag :=
591: ben_etu_shd.g_old_rec.uses_tbco_flag;
592: End If;
593: If (p_rec.etu_attribute_category = hr_api.g_varchar2) then
594: p_rec.etu_attribute_category :=
595: ben_etu_shd.g_old_rec.etu_attribute_category;

Line 595: ben_etu_shd.g_old_rec.etu_attribute_category;

591: ben_etu_shd.g_old_rec.uses_tbco_flag;
592: End If;
593: If (p_rec.etu_attribute_category = hr_api.g_varchar2) then
594: p_rec.etu_attribute_category :=
595: ben_etu_shd.g_old_rec.etu_attribute_category;
596: End If;
597: If (p_rec.etu_attribute1 = hr_api.g_varchar2) then
598: p_rec.etu_attribute1 :=
599: ben_etu_shd.g_old_rec.etu_attribute1;

Line 599: ben_etu_shd.g_old_rec.etu_attribute1;

595: ben_etu_shd.g_old_rec.etu_attribute_category;
596: End If;
597: If (p_rec.etu_attribute1 = hr_api.g_varchar2) then
598: p_rec.etu_attribute1 :=
599: ben_etu_shd.g_old_rec.etu_attribute1;
600: End If;
601: If (p_rec.etu_attribute2 = hr_api.g_varchar2) then
602: p_rec.etu_attribute2 :=
603: ben_etu_shd.g_old_rec.etu_attribute2;

Line 603: ben_etu_shd.g_old_rec.etu_attribute2;

599: ben_etu_shd.g_old_rec.etu_attribute1;
600: End If;
601: If (p_rec.etu_attribute2 = hr_api.g_varchar2) then
602: p_rec.etu_attribute2 :=
603: ben_etu_shd.g_old_rec.etu_attribute2;
604: End If;
605: If (p_rec.etu_attribute3 = hr_api.g_varchar2) then
606: p_rec.etu_attribute3 :=
607: ben_etu_shd.g_old_rec.etu_attribute3;

Line 607: ben_etu_shd.g_old_rec.etu_attribute3;

603: ben_etu_shd.g_old_rec.etu_attribute2;
604: End If;
605: If (p_rec.etu_attribute3 = hr_api.g_varchar2) then
606: p_rec.etu_attribute3 :=
607: ben_etu_shd.g_old_rec.etu_attribute3;
608: End If;
609: If (p_rec.etu_attribute4 = hr_api.g_varchar2) then
610: p_rec.etu_attribute4 :=
611: ben_etu_shd.g_old_rec.etu_attribute4;

Line 611: ben_etu_shd.g_old_rec.etu_attribute4;

607: ben_etu_shd.g_old_rec.etu_attribute3;
608: End If;
609: If (p_rec.etu_attribute4 = hr_api.g_varchar2) then
610: p_rec.etu_attribute4 :=
611: ben_etu_shd.g_old_rec.etu_attribute4;
612: End If;
613: If (p_rec.etu_attribute5 = hr_api.g_varchar2) then
614: p_rec.etu_attribute5 :=
615: ben_etu_shd.g_old_rec.etu_attribute5;

Line 615: ben_etu_shd.g_old_rec.etu_attribute5;

611: ben_etu_shd.g_old_rec.etu_attribute4;
612: End If;
613: If (p_rec.etu_attribute5 = hr_api.g_varchar2) then
614: p_rec.etu_attribute5 :=
615: ben_etu_shd.g_old_rec.etu_attribute5;
616: End If;
617: If (p_rec.etu_attribute6 = hr_api.g_varchar2) then
618: p_rec.etu_attribute6 :=
619: ben_etu_shd.g_old_rec.etu_attribute6;

Line 619: ben_etu_shd.g_old_rec.etu_attribute6;

615: ben_etu_shd.g_old_rec.etu_attribute5;
616: End If;
617: If (p_rec.etu_attribute6 = hr_api.g_varchar2) then
618: p_rec.etu_attribute6 :=
619: ben_etu_shd.g_old_rec.etu_attribute6;
620: End If;
621: If (p_rec.etu_attribute7 = hr_api.g_varchar2) then
622: p_rec.etu_attribute7 :=
623: ben_etu_shd.g_old_rec.etu_attribute7;

Line 623: ben_etu_shd.g_old_rec.etu_attribute7;

619: ben_etu_shd.g_old_rec.etu_attribute6;
620: End If;
621: If (p_rec.etu_attribute7 = hr_api.g_varchar2) then
622: p_rec.etu_attribute7 :=
623: ben_etu_shd.g_old_rec.etu_attribute7;
624: End If;
625: If (p_rec.etu_attribute8 = hr_api.g_varchar2) then
626: p_rec.etu_attribute8 :=
627: ben_etu_shd.g_old_rec.etu_attribute8;

Line 627: ben_etu_shd.g_old_rec.etu_attribute8;

623: ben_etu_shd.g_old_rec.etu_attribute7;
624: End If;
625: If (p_rec.etu_attribute8 = hr_api.g_varchar2) then
626: p_rec.etu_attribute8 :=
627: ben_etu_shd.g_old_rec.etu_attribute8;
628: End If;
629: If (p_rec.etu_attribute9 = hr_api.g_varchar2) then
630: p_rec.etu_attribute9 :=
631: ben_etu_shd.g_old_rec.etu_attribute9;

Line 631: ben_etu_shd.g_old_rec.etu_attribute9;

627: ben_etu_shd.g_old_rec.etu_attribute8;
628: End If;
629: If (p_rec.etu_attribute9 = hr_api.g_varchar2) then
630: p_rec.etu_attribute9 :=
631: ben_etu_shd.g_old_rec.etu_attribute9;
632: End If;
633: If (p_rec.etu_attribute10 = hr_api.g_varchar2) then
634: p_rec.etu_attribute10 :=
635: ben_etu_shd.g_old_rec.etu_attribute10;

Line 635: ben_etu_shd.g_old_rec.etu_attribute10;

631: ben_etu_shd.g_old_rec.etu_attribute9;
632: End If;
633: If (p_rec.etu_attribute10 = hr_api.g_varchar2) then
634: p_rec.etu_attribute10 :=
635: ben_etu_shd.g_old_rec.etu_attribute10;
636: End If;
637: If (p_rec.etu_attribute11 = hr_api.g_varchar2) then
638: p_rec.etu_attribute11 :=
639: ben_etu_shd.g_old_rec.etu_attribute11;

Line 639: ben_etu_shd.g_old_rec.etu_attribute11;

635: ben_etu_shd.g_old_rec.etu_attribute10;
636: End If;
637: If (p_rec.etu_attribute11 = hr_api.g_varchar2) then
638: p_rec.etu_attribute11 :=
639: ben_etu_shd.g_old_rec.etu_attribute11;
640: End If;
641: If (p_rec.etu_attribute12 = hr_api.g_varchar2) then
642: p_rec.etu_attribute12 :=
643: ben_etu_shd.g_old_rec.etu_attribute12;

Line 643: ben_etu_shd.g_old_rec.etu_attribute12;

639: ben_etu_shd.g_old_rec.etu_attribute11;
640: End If;
641: If (p_rec.etu_attribute12 = hr_api.g_varchar2) then
642: p_rec.etu_attribute12 :=
643: ben_etu_shd.g_old_rec.etu_attribute12;
644: End If;
645: If (p_rec.etu_attribute13 = hr_api.g_varchar2) then
646: p_rec.etu_attribute13 :=
647: ben_etu_shd.g_old_rec.etu_attribute13;

Line 647: ben_etu_shd.g_old_rec.etu_attribute13;

643: ben_etu_shd.g_old_rec.etu_attribute12;
644: End If;
645: If (p_rec.etu_attribute13 = hr_api.g_varchar2) then
646: p_rec.etu_attribute13 :=
647: ben_etu_shd.g_old_rec.etu_attribute13;
648: End If;
649: If (p_rec.etu_attribute14 = hr_api.g_varchar2) then
650: p_rec.etu_attribute14 :=
651: ben_etu_shd.g_old_rec.etu_attribute14;

Line 651: ben_etu_shd.g_old_rec.etu_attribute14;

647: ben_etu_shd.g_old_rec.etu_attribute13;
648: End If;
649: If (p_rec.etu_attribute14 = hr_api.g_varchar2) then
650: p_rec.etu_attribute14 :=
651: ben_etu_shd.g_old_rec.etu_attribute14;
652: End If;
653: If (p_rec.etu_attribute15 = hr_api.g_varchar2) then
654: p_rec.etu_attribute15 :=
655: ben_etu_shd.g_old_rec.etu_attribute15;

Line 655: ben_etu_shd.g_old_rec.etu_attribute15;

651: ben_etu_shd.g_old_rec.etu_attribute14;
652: End If;
653: If (p_rec.etu_attribute15 = hr_api.g_varchar2) then
654: p_rec.etu_attribute15 :=
655: ben_etu_shd.g_old_rec.etu_attribute15;
656: End If;
657: If (p_rec.etu_attribute16 = hr_api.g_varchar2) then
658: p_rec.etu_attribute16 :=
659: ben_etu_shd.g_old_rec.etu_attribute16;

Line 659: ben_etu_shd.g_old_rec.etu_attribute16;

655: ben_etu_shd.g_old_rec.etu_attribute15;
656: End If;
657: If (p_rec.etu_attribute16 = hr_api.g_varchar2) then
658: p_rec.etu_attribute16 :=
659: ben_etu_shd.g_old_rec.etu_attribute16;
660: End If;
661: If (p_rec.etu_attribute17 = hr_api.g_varchar2) then
662: p_rec.etu_attribute17 :=
663: ben_etu_shd.g_old_rec.etu_attribute17;

Line 663: ben_etu_shd.g_old_rec.etu_attribute17;

659: ben_etu_shd.g_old_rec.etu_attribute16;
660: End If;
661: If (p_rec.etu_attribute17 = hr_api.g_varchar2) then
662: p_rec.etu_attribute17 :=
663: ben_etu_shd.g_old_rec.etu_attribute17;
664: End If;
665: If (p_rec.etu_attribute18 = hr_api.g_varchar2) then
666: p_rec.etu_attribute18 :=
667: ben_etu_shd.g_old_rec.etu_attribute18;

Line 667: ben_etu_shd.g_old_rec.etu_attribute18;

663: ben_etu_shd.g_old_rec.etu_attribute17;
664: End If;
665: If (p_rec.etu_attribute18 = hr_api.g_varchar2) then
666: p_rec.etu_attribute18 :=
667: ben_etu_shd.g_old_rec.etu_attribute18;
668: End If;
669: If (p_rec.etu_attribute19 = hr_api.g_varchar2) then
670: p_rec.etu_attribute19 :=
671: ben_etu_shd.g_old_rec.etu_attribute19;

Line 671: ben_etu_shd.g_old_rec.etu_attribute19;

667: ben_etu_shd.g_old_rec.etu_attribute18;
668: End If;
669: If (p_rec.etu_attribute19 = hr_api.g_varchar2) then
670: p_rec.etu_attribute19 :=
671: ben_etu_shd.g_old_rec.etu_attribute19;
672: End If;
673: If (p_rec.etu_attribute20 = hr_api.g_varchar2) then
674: p_rec.etu_attribute20 :=
675: ben_etu_shd.g_old_rec.etu_attribute20;

Line 675: ben_etu_shd.g_old_rec.etu_attribute20;

671: ben_etu_shd.g_old_rec.etu_attribute19;
672: End If;
673: If (p_rec.etu_attribute20 = hr_api.g_varchar2) then
674: p_rec.etu_attribute20 :=
675: ben_etu_shd.g_old_rec.etu_attribute20;
676: End If;
677: If (p_rec.etu_attribute21 = hr_api.g_varchar2) then
678: p_rec.etu_attribute21 :=
679: ben_etu_shd.g_old_rec.etu_attribute21;

Line 679: ben_etu_shd.g_old_rec.etu_attribute21;

675: ben_etu_shd.g_old_rec.etu_attribute20;
676: End If;
677: If (p_rec.etu_attribute21 = hr_api.g_varchar2) then
678: p_rec.etu_attribute21 :=
679: ben_etu_shd.g_old_rec.etu_attribute21;
680: End If;
681: If (p_rec.etu_attribute22 = hr_api.g_varchar2) then
682: p_rec.etu_attribute22 :=
683: ben_etu_shd.g_old_rec.etu_attribute22;

Line 683: ben_etu_shd.g_old_rec.etu_attribute22;

679: ben_etu_shd.g_old_rec.etu_attribute21;
680: End If;
681: If (p_rec.etu_attribute22 = hr_api.g_varchar2) then
682: p_rec.etu_attribute22 :=
683: ben_etu_shd.g_old_rec.etu_attribute22;
684: End If;
685: If (p_rec.etu_attribute23 = hr_api.g_varchar2) then
686: p_rec.etu_attribute23 :=
687: ben_etu_shd.g_old_rec.etu_attribute23;

Line 687: ben_etu_shd.g_old_rec.etu_attribute23;

683: ben_etu_shd.g_old_rec.etu_attribute22;
684: End If;
685: If (p_rec.etu_attribute23 = hr_api.g_varchar2) then
686: p_rec.etu_attribute23 :=
687: ben_etu_shd.g_old_rec.etu_attribute23;
688: End If;
689: If (p_rec.etu_attribute24 = hr_api.g_varchar2) then
690: p_rec.etu_attribute24 :=
691: ben_etu_shd.g_old_rec.etu_attribute24;

Line 691: ben_etu_shd.g_old_rec.etu_attribute24;

687: ben_etu_shd.g_old_rec.etu_attribute23;
688: End If;
689: If (p_rec.etu_attribute24 = hr_api.g_varchar2) then
690: p_rec.etu_attribute24 :=
691: ben_etu_shd.g_old_rec.etu_attribute24;
692: End If;
693: If (p_rec.etu_attribute25 = hr_api.g_varchar2) then
694: p_rec.etu_attribute25 :=
695: ben_etu_shd.g_old_rec.etu_attribute25;

Line 695: ben_etu_shd.g_old_rec.etu_attribute25;

691: ben_etu_shd.g_old_rec.etu_attribute24;
692: End If;
693: If (p_rec.etu_attribute25 = hr_api.g_varchar2) then
694: p_rec.etu_attribute25 :=
695: ben_etu_shd.g_old_rec.etu_attribute25;
696: End If;
697: If (p_rec.etu_attribute26 = hr_api.g_varchar2) then
698: p_rec.etu_attribute26 :=
699: ben_etu_shd.g_old_rec.etu_attribute26;

Line 699: ben_etu_shd.g_old_rec.etu_attribute26;

695: ben_etu_shd.g_old_rec.etu_attribute25;
696: End If;
697: If (p_rec.etu_attribute26 = hr_api.g_varchar2) then
698: p_rec.etu_attribute26 :=
699: ben_etu_shd.g_old_rec.etu_attribute26;
700: End If;
701: If (p_rec.etu_attribute27 = hr_api.g_varchar2) then
702: p_rec.etu_attribute27 :=
703: ben_etu_shd.g_old_rec.etu_attribute27;

Line 703: ben_etu_shd.g_old_rec.etu_attribute27;

699: ben_etu_shd.g_old_rec.etu_attribute26;
700: End If;
701: If (p_rec.etu_attribute27 = hr_api.g_varchar2) then
702: p_rec.etu_attribute27 :=
703: ben_etu_shd.g_old_rec.etu_attribute27;
704: End If;
705: If (p_rec.etu_attribute28 = hr_api.g_varchar2) then
706: p_rec.etu_attribute28 :=
707: ben_etu_shd.g_old_rec.etu_attribute28;

Line 707: ben_etu_shd.g_old_rec.etu_attribute28;

703: ben_etu_shd.g_old_rec.etu_attribute27;
704: End If;
705: If (p_rec.etu_attribute28 = hr_api.g_varchar2) then
706: p_rec.etu_attribute28 :=
707: ben_etu_shd.g_old_rec.etu_attribute28;
708: End If;
709: If (p_rec.etu_attribute29 = hr_api.g_varchar2) then
710: p_rec.etu_attribute29 :=
711: ben_etu_shd.g_old_rec.etu_attribute29;

Line 711: ben_etu_shd.g_old_rec.etu_attribute29;

707: ben_etu_shd.g_old_rec.etu_attribute28;
708: End If;
709: If (p_rec.etu_attribute29 = hr_api.g_varchar2) then
710: p_rec.etu_attribute29 :=
711: ben_etu_shd.g_old_rec.etu_attribute29;
712: End If;
713: If (p_rec.etu_attribute30 = hr_api.g_varchar2) then
714: p_rec.etu_attribute30 :=
715: ben_etu_shd.g_old_rec.etu_attribute30;

Line 715: ben_etu_shd.g_old_rec.etu_attribute30;

711: ben_etu_shd.g_old_rec.etu_attribute29;
712: End If;
713: If (p_rec.etu_attribute30 = hr_api.g_varchar2) then
714: p_rec.etu_attribute30 :=
715: ben_etu_shd.g_old_rec.etu_attribute30;
716: End If;
717:
718: If (p_rec.criteria_score = hr_api.g_number) then
719: p_rec.criteria_score :=

Line 720: ben_etu_shd.g_old_rec.criteria_score;

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

Line 725: ben_etu_shd.g_old_rec.criteria_weight;

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

Line 740: p_rec in out nocopy ben_etu_shd.g_rec_type,

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

Line 758: ben_etu_shd.lck

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

Line 860: l_rec ben_etu_shd.g_rec_type;

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

Line 870: ben_etu_shd.convert_args

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