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_EMP_UPD dependencies on BEN_EMP_SHD

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

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

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

Line 130: ben_emp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 142: ben_emp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 143: ben_emp_shd.constraint_error

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

Line 147: ben_emp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 148: ben_emp_shd.constraint_error

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

Line 151: ben_emp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 187: (p_rec in out nocopy ben_emp_shd.g_rec_type,

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

Line 251: (p_rec in out nocopy ben_emp_shd.g_rec_type,

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

Line 267: ben_emp_shd.upd_effective_end_date

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

Line 336: (p_rec in out nocopy ben_emp_shd.g_rec_type,

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

Line 392: (p_rec in ben_emp_shd.g_rec_type,

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

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

451: ,p_validation_start_date =>p_validation_start_date
452: ,p_validation_end_date =>p_validation_end_date
453: ,p_criteria_score =>p_rec.criteria_score
454: ,p_criteria_weight =>p_rec.criteria_weight
455: ,p_effective_start_date_o =>ben_emp_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id

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

452: ,p_validation_end_date =>p_validation_end_date
453: ,p_criteria_score =>p_rec.criteria_score
454: ,p_criteria_weight =>p_rec.criteria_weight
455: ,p_effective_start_date_o =>ben_emp_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id

Line 457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag

453: ,p_criteria_score =>p_rec.criteria_score
454: ,p_criteria_weight =>p_rec.criteria_weight
455: ,p_effective_start_date_o =>ben_emp_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category

Line 458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status

454: ,p_criteria_weight =>p_rec.criteria_weight
455: ,p_effective_start_date_o =>ben_emp_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1

Line 459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id

455: ,p_effective_start_date_o =>ben_emp_shd.g_old_rec.effective_start_date
456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2

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

456: ,p_effective_end_date_o =>ben_emp_shd.g_old_rec.effective_end_date
457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3

Line 461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category

457: ,p_excld_flag_o =>ben_emp_shd.g_old_rec.excld_flag
458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4

Line 462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1

458: ,p_marital_status_o =>ben_emp_shd.g_old_rec.marital_status
459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5

Line 463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2

459: ,p_eligy_prfl_id_o =>ben_emp_shd.g_old_rec.eligy_prfl_id
460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6

Line 464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3

460: ,p_business_group_id_o =>ben_emp_shd.g_old_rec.business_group_id
461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7

Line 465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4

461: ,p_emp_attribute_category_o =>ben_emp_shd.g_old_rec.emp_attribute_category
462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8

Line 466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5

462: ,p_emp_attribute1_o =>ben_emp_shd.g_old_rec.emp_attribute1
463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9

Line 467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6

463: ,p_emp_attribute2_o =>ben_emp_shd.g_old_rec.emp_attribute2
464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10

Line 468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7

464: ,p_emp_attribute3_o =>ben_emp_shd.g_old_rec.emp_attribute3
465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11

Line 469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8

465: ,p_emp_attribute4_o =>ben_emp_shd.g_old_rec.emp_attribute4
466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12

Line 470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9

466: ,p_emp_attribute5_o =>ben_emp_shd.g_old_rec.emp_attribute5
467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13

Line 471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10

467: ,p_emp_attribute6_o =>ben_emp_shd.g_old_rec.emp_attribute6
468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14

Line 472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11

468: ,p_emp_attribute7_o =>ben_emp_shd.g_old_rec.emp_attribute7
469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15

Line 473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12

469: ,p_emp_attribute8_o =>ben_emp_shd.g_old_rec.emp_attribute8
470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16

Line 474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13

470: ,p_emp_attribute9_o =>ben_emp_shd.g_old_rec.emp_attribute9
471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17

Line 475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14

471: ,p_emp_attribute10_o =>ben_emp_shd.g_old_rec.emp_attribute10
472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18

Line 476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15

472: ,p_emp_attribute11_o =>ben_emp_shd.g_old_rec.emp_attribute11
473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19

Line 477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16

473: ,p_emp_attribute12_o =>ben_emp_shd.g_old_rec.emp_attribute12
474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20

Line 478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17

474: ,p_emp_attribute13_o =>ben_emp_shd.g_old_rec.emp_attribute13
475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21

Line 479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18

475: ,p_emp_attribute14_o =>ben_emp_shd.g_old_rec.emp_attribute14
476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22

Line 480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19

476: ,p_emp_attribute15_o =>ben_emp_shd.g_old_rec.emp_attribute15
477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23

Line 481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20

477: ,p_emp_attribute16_o =>ben_emp_shd.g_old_rec.emp_attribute16
478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24

Line 482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21

478: ,p_emp_attribute17_o =>ben_emp_shd.g_old_rec.emp_attribute17
479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25

Line 483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22

479: ,p_emp_attribute18_o =>ben_emp_shd.g_old_rec.emp_attribute18
480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26

Line 484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23

480: ,p_emp_attribute19_o =>ben_emp_shd.g_old_rec.emp_attribute19
481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27

Line 485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24

481: ,p_emp_attribute20_o =>ben_emp_shd.g_old_rec.emp_attribute20
482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28

Line 486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25

482: ,p_emp_attribute21_o =>ben_emp_shd.g_old_rec.emp_attribute21
483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29

Line 487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26

483: ,p_emp_attribute22_o =>ben_emp_shd.g_old_rec.emp_attribute22
484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30

Line 488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27

484: ,p_emp_attribute23_o =>ben_emp_shd.g_old_rec.emp_attribute23
485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number

Line 489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28

485: ,p_emp_attribute24_o =>ben_emp_shd.g_old_rec.emp_attribute24
486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score

Line 490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29

486: ,p_emp_attribute25_o =>ben_emp_shd.g_old_rec.emp_attribute25
487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score
494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight

Line 491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30

487: ,p_emp_attribute26_o =>ben_emp_shd.g_old_rec.emp_attribute26
488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score
494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight
495: );

Line 492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number

488: ,p_emp_attribute27_o =>ben_emp_shd.g_old_rec.emp_attribute27
489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score
494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight
495: );
496: --

Line 493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score

489: ,p_emp_attribute28_o =>ben_emp_shd.g_old_rec.emp_attribute28
490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score
494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight
495: );
496: --
497: exception

Line 494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight

490: ,p_emp_attribute29_o =>ben_emp_shd.g_old_rec.emp_attribute29
491: ,p_emp_attribute30_o =>ben_emp_shd.g_old_rec.emp_attribute30
492: ,p_object_version_number_o =>ben_emp_shd.g_old_rec.object_version_number
493: ,p_criteria_score_o =>ben_emp_shd.g_old_rec.criteria_score
494: ,p_criteria_weight_o =>ben_emp_shd.g_old_rec.criteria_weight
495: );
496: --
497: exception
498: --

Line 556: Procedure convert_defs(p_rec in out nocopy ben_emp_shd.g_rec_type) is

552: -- Internal Row Handler Use Only.
553: --
554: -- {End Of Comments}
555: -- ----------------------------------------------------------------------------
556: Procedure convert_defs(p_rec in out nocopy ben_emp_shd.g_rec_type) is
557: --
558: l_proc varchar2(72) := g_package||'convert_defs';
559: --
560: Begin

Line 571: ben_emp_shd.g_old_rec.excld_flag;

567: -- is being used then we must set to the 'current' argument value.
568: --
569: If (p_rec.excld_flag = hr_api.g_varchar2) then
570: p_rec.excld_flag :=
571: ben_emp_shd.g_old_rec.excld_flag;
572: End If;
573: If (p_rec.marital_status = hr_api.g_varchar2) then
574: p_rec.marital_status :=
575: ben_emp_shd.g_old_rec.marital_status;

Line 575: ben_emp_shd.g_old_rec.marital_status;

571: ben_emp_shd.g_old_rec.excld_flag;
572: End If;
573: If (p_rec.marital_status = hr_api.g_varchar2) then
574: p_rec.marital_status :=
575: ben_emp_shd.g_old_rec.marital_status;
576: End If;
577: If (p_rec.eligy_prfl_id = hr_api.g_number) then
578: p_rec.eligy_prfl_id :=
579: ben_emp_shd.g_old_rec.eligy_prfl_id;

Line 579: ben_emp_shd.g_old_rec.eligy_prfl_id;

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

Line 583: ben_emp_shd.g_old_rec.business_group_id;

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

Line 587: ben_emp_shd.g_old_rec.emp_attribute_category;

583: ben_emp_shd.g_old_rec.business_group_id;
584: End If;
585: If (p_rec.emp_attribute_category = hr_api.g_varchar2) then
586: p_rec.emp_attribute_category :=
587: ben_emp_shd.g_old_rec.emp_attribute_category;
588: End If;
589: If (p_rec.emp_attribute1 = hr_api.g_varchar2) then
590: p_rec.emp_attribute1 :=
591: ben_emp_shd.g_old_rec.emp_attribute1;

Line 591: ben_emp_shd.g_old_rec.emp_attribute1;

587: ben_emp_shd.g_old_rec.emp_attribute_category;
588: End If;
589: If (p_rec.emp_attribute1 = hr_api.g_varchar2) then
590: p_rec.emp_attribute1 :=
591: ben_emp_shd.g_old_rec.emp_attribute1;
592: End If;
593: If (p_rec.emp_attribute2 = hr_api.g_varchar2) then
594: p_rec.emp_attribute2 :=
595: ben_emp_shd.g_old_rec.emp_attribute2;

Line 595: ben_emp_shd.g_old_rec.emp_attribute2;

591: ben_emp_shd.g_old_rec.emp_attribute1;
592: End If;
593: If (p_rec.emp_attribute2 = hr_api.g_varchar2) then
594: p_rec.emp_attribute2 :=
595: ben_emp_shd.g_old_rec.emp_attribute2;
596: End If;
597: If (p_rec.emp_attribute3 = hr_api.g_varchar2) then
598: p_rec.emp_attribute3 :=
599: ben_emp_shd.g_old_rec.emp_attribute3;

Line 599: ben_emp_shd.g_old_rec.emp_attribute3;

595: ben_emp_shd.g_old_rec.emp_attribute2;
596: End If;
597: If (p_rec.emp_attribute3 = hr_api.g_varchar2) then
598: p_rec.emp_attribute3 :=
599: ben_emp_shd.g_old_rec.emp_attribute3;
600: End If;
601: If (p_rec.emp_attribute4 = hr_api.g_varchar2) then
602: p_rec.emp_attribute4 :=
603: ben_emp_shd.g_old_rec.emp_attribute4;

Line 603: ben_emp_shd.g_old_rec.emp_attribute4;

599: ben_emp_shd.g_old_rec.emp_attribute3;
600: End If;
601: If (p_rec.emp_attribute4 = hr_api.g_varchar2) then
602: p_rec.emp_attribute4 :=
603: ben_emp_shd.g_old_rec.emp_attribute4;
604: End If;
605: If (p_rec.emp_attribute5 = hr_api.g_varchar2) then
606: p_rec.emp_attribute5 :=
607: ben_emp_shd.g_old_rec.emp_attribute5;

Line 607: ben_emp_shd.g_old_rec.emp_attribute5;

603: ben_emp_shd.g_old_rec.emp_attribute4;
604: End If;
605: If (p_rec.emp_attribute5 = hr_api.g_varchar2) then
606: p_rec.emp_attribute5 :=
607: ben_emp_shd.g_old_rec.emp_attribute5;
608: End If;
609: If (p_rec.emp_attribute6 = hr_api.g_varchar2) then
610: p_rec.emp_attribute6 :=
611: ben_emp_shd.g_old_rec.emp_attribute6;

Line 611: ben_emp_shd.g_old_rec.emp_attribute6;

607: ben_emp_shd.g_old_rec.emp_attribute5;
608: End If;
609: If (p_rec.emp_attribute6 = hr_api.g_varchar2) then
610: p_rec.emp_attribute6 :=
611: ben_emp_shd.g_old_rec.emp_attribute6;
612: End If;
613: If (p_rec.emp_attribute7 = hr_api.g_varchar2) then
614: p_rec.emp_attribute7 :=
615: ben_emp_shd.g_old_rec.emp_attribute7;

Line 615: ben_emp_shd.g_old_rec.emp_attribute7;

611: ben_emp_shd.g_old_rec.emp_attribute6;
612: End If;
613: If (p_rec.emp_attribute7 = hr_api.g_varchar2) then
614: p_rec.emp_attribute7 :=
615: ben_emp_shd.g_old_rec.emp_attribute7;
616: End If;
617: If (p_rec.emp_attribute8 = hr_api.g_varchar2) then
618: p_rec.emp_attribute8 :=
619: ben_emp_shd.g_old_rec.emp_attribute8;

Line 619: ben_emp_shd.g_old_rec.emp_attribute8;

615: ben_emp_shd.g_old_rec.emp_attribute7;
616: End If;
617: If (p_rec.emp_attribute8 = hr_api.g_varchar2) then
618: p_rec.emp_attribute8 :=
619: ben_emp_shd.g_old_rec.emp_attribute8;
620: End If;
621: If (p_rec.emp_attribute9 = hr_api.g_varchar2) then
622: p_rec.emp_attribute9 :=
623: ben_emp_shd.g_old_rec.emp_attribute9;

Line 623: ben_emp_shd.g_old_rec.emp_attribute9;

619: ben_emp_shd.g_old_rec.emp_attribute8;
620: End If;
621: If (p_rec.emp_attribute9 = hr_api.g_varchar2) then
622: p_rec.emp_attribute9 :=
623: ben_emp_shd.g_old_rec.emp_attribute9;
624: End If;
625: If (p_rec.emp_attribute10 = hr_api.g_varchar2) then
626: p_rec.emp_attribute10 :=
627: ben_emp_shd.g_old_rec.emp_attribute10;

Line 627: ben_emp_shd.g_old_rec.emp_attribute10;

623: ben_emp_shd.g_old_rec.emp_attribute9;
624: End If;
625: If (p_rec.emp_attribute10 = hr_api.g_varchar2) then
626: p_rec.emp_attribute10 :=
627: ben_emp_shd.g_old_rec.emp_attribute10;
628: End If;
629: If (p_rec.emp_attribute11 = hr_api.g_varchar2) then
630: p_rec.emp_attribute11 :=
631: ben_emp_shd.g_old_rec.emp_attribute11;

Line 631: ben_emp_shd.g_old_rec.emp_attribute11;

627: ben_emp_shd.g_old_rec.emp_attribute10;
628: End If;
629: If (p_rec.emp_attribute11 = hr_api.g_varchar2) then
630: p_rec.emp_attribute11 :=
631: ben_emp_shd.g_old_rec.emp_attribute11;
632: End If;
633: If (p_rec.emp_attribute12 = hr_api.g_varchar2) then
634: p_rec.emp_attribute12 :=
635: ben_emp_shd.g_old_rec.emp_attribute12;

Line 635: ben_emp_shd.g_old_rec.emp_attribute12;

631: ben_emp_shd.g_old_rec.emp_attribute11;
632: End If;
633: If (p_rec.emp_attribute12 = hr_api.g_varchar2) then
634: p_rec.emp_attribute12 :=
635: ben_emp_shd.g_old_rec.emp_attribute12;
636: End If;
637: If (p_rec.emp_attribute13 = hr_api.g_varchar2) then
638: p_rec.emp_attribute13 :=
639: ben_emp_shd.g_old_rec.emp_attribute13;

Line 639: ben_emp_shd.g_old_rec.emp_attribute13;

635: ben_emp_shd.g_old_rec.emp_attribute12;
636: End If;
637: If (p_rec.emp_attribute13 = hr_api.g_varchar2) then
638: p_rec.emp_attribute13 :=
639: ben_emp_shd.g_old_rec.emp_attribute13;
640: End If;
641: If (p_rec.emp_attribute14 = hr_api.g_varchar2) then
642: p_rec.emp_attribute14 :=
643: ben_emp_shd.g_old_rec.emp_attribute14;

Line 643: ben_emp_shd.g_old_rec.emp_attribute14;

639: ben_emp_shd.g_old_rec.emp_attribute13;
640: End If;
641: If (p_rec.emp_attribute14 = hr_api.g_varchar2) then
642: p_rec.emp_attribute14 :=
643: ben_emp_shd.g_old_rec.emp_attribute14;
644: End If;
645: If (p_rec.emp_attribute15 = hr_api.g_varchar2) then
646: p_rec.emp_attribute15 :=
647: ben_emp_shd.g_old_rec.emp_attribute15;

Line 647: ben_emp_shd.g_old_rec.emp_attribute15;

643: ben_emp_shd.g_old_rec.emp_attribute14;
644: End If;
645: If (p_rec.emp_attribute15 = hr_api.g_varchar2) then
646: p_rec.emp_attribute15 :=
647: ben_emp_shd.g_old_rec.emp_attribute15;
648: End If;
649: If (p_rec.emp_attribute16 = hr_api.g_varchar2) then
650: p_rec.emp_attribute16 :=
651: ben_emp_shd.g_old_rec.emp_attribute16;

Line 651: ben_emp_shd.g_old_rec.emp_attribute16;

647: ben_emp_shd.g_old_rec.emp_attribute15;
648: End If;
649: If (p_rec.emp_attribute16 = hr_api.g_varchar2) then
650: p_rec.emp_attribute16 :=
651: ben_emp_shd.g_old_rec.emp_attribute16;
652: End If;
653: If (p_rec.emp_attribute17 = hr_api.g_varchar2) then
654: p_rec.emp_attribute17 :=
655: ben_emp_shd.g_old_rec.emp_attribute17;

Line 655: ben_emp_shd.g_old_rec.emp_attribute17;

651: ben_emp_shd.g_old_rec.emp_attribute16;
652: End If;
653: If (p_rec.emp_attribute17 = hr_api.g_varchar2) then
654: p_rec.emp_attribute17 :=
655: ben_emp_shd.g_old_rec.emp_attribute17;
656: End If;
657: If (p_rec.emp_attribute18 = hr_api.g_varchar2) then
658: p_rec.emp_attribute18 :=
659: ben_emp_shd.g_old_rec.emp_attribute18;

Line 659: ben_emp_shd.g_old_rec.emp_attribute18;

655: ben_emp_shd.g_old_rec.emp_attribute17;
656: End If;
657: If (p_rec.emp_attribute18 = hr_api.g_varchar2) then
658: p_rec.emp_attribute18 :=
659: ben_emp_shd.g_old_rec.emp_attribute18;
660: End If;
661: If (p_rec.emp_attribute19 = hr_api.g_varchar2) then
662: p_rec.emp_attribute19 :=
663: ben_emp_shd.g_old_rec.emp_attribute19;

Line 663: ben_emp_shd.g_old_rec.emp_attribute19;

659: ben_emp_shd.g_old_rec.emp_attribute18;
660: End If;
661: If (p_rec.emp_attribute19 = hr_api.g_varchar2) then
662: p_rec.emp_attribute19 :=
663: ben_emp_shd.g_old_rec.emp_attribute19;
664: End If;
665: If (p_rec.emp_attribute20 = hr_api.g_varchar2) then
666: p_rec.emp_attribute20 :=
667: ben_emp_shd.g_old_rec.emp_attribute20;

Line 667: ben_emp_shd.g_old_rec.emp_attribute20;

663: ben_emp_shd.g_old_rec.emp_attribute19;
664: End If;
665: If (p_rec.emp_attribute20 = hr_api.g_varchar2) then
666: p_rec.emp_attribute20 :=
667: ben_emp_shd.g_old_rec.emp_attribute20;
668: End If;
669: If (p_rec.emp_attribute21 = hr_api.g_varchar2) then
670: p_rec.emp_attribute21 :=
671: ben_emp_shd.g_old_rec.emp_attribute21;

Line 671: ben_emp_shd.g_old_rec.emp_attribute21;

667: ben_emp_shd.g_old_rec.emp_attribute20;
668: End If;
669: If (p_rec.emp_attribute21 = hr_api.g_varchar2) then
670: p_rec.emp_attribute21 :=
671: ben_emp_shd.g_old_rec.emp_attribute21;
672: End If;
673: If (p_rec.emp_attribute22 = hr_api.g_varchar2) then
674: p_rec.emp_attribute22 :=
675: ben_emp_shd.g_old_rec.emp_attribute22;

Line 675: ben_emp_shd.g_old_rec.emp_attribute22;

671: ben_emp_shd.g_old_rec.emp_attribute21;
672: End If;
673: If (p_rec.emp_attribute22 = hr_api.g_varchar2) then
674: p_rec.emp_attribute22 :=
675: ben_emp_shd.g_old_rec.emp_attribute22;
676: End If;
677: If (p_rec.emp_attribute23 = hr_api.g_varchar2) then
678: p_rec.emp_attribute23 :=
679: ben_emp_shd.g_old_rec.emp_attribute23;

Line 679: ben_emp_shd.g_old_rec.emp_attribute23;

675: ben_emp_shd.g_old_rec.emp_attribute22;
676: End If;
677: If (p_rec.emp_attribute23 = hr_api.g_varchar2) then
678: p_rec.emp_attribute23 :=
679: ben_emp_shd.g_old_rec.emp_attribute23;
680: End If;
681: If (p_rec.emp_attribute24 = hr_api.g_varchar2) then
682: p_rec.emp_attribute24 :=
683: ben_emp_shd.g_old_rec.emp_attribute24;

Line 683: ben_emp_shd.g_old_rec.emp_attribute24;

679: ben_emp_shd.g_old_rec.emp_attribute23;
680: End If;
681: If (p_rec.emp_attribute24 = hr_api.g_varchar2) then
682: p_rec.emp_attribute24 :=
683: ben_emp_shd.g_old_rec.emp_attribute24;
684: End If;
685: If (p_rec.emp_attribute25 = hr_api.g_varchar2) then
686: p_rec.emp_attribute25 :=
687: ben_emp_shd.g_old_rec.emp_attribute25;

Line 687: ben_emp_shd.g_old_rec.emp_attribute25;

683: ben_emp_shd.g_old_rec.emp_attribute24;
684: End If;
685: If (p_rec.emp_attribute25 = hr_api.g_varchar2) then
686: p_rec.emp_attribute25 :=
687: ben_emp_shd.g_old_rec.emp_attribute25;
688: End If;
689: If (p_rec.emp_attribute26 = hr_api.g_varchar2) then
690: p_rec.emp_attribute26 :=
691: ben_emp_shd.g_old_rec.emp_attribute26;

Line 691: ben_emp_shd.g_old_rec.emp_attribute26;

687: ben_emp_shd.g_old_rec.emp_attribute25;
688: End If;
689: If (p_rec.emp_attribute26 = hr_api.g_varchar2) then
690: p_rec.emp_attribute26 :=
691: ben_emp_shd.g_old_rec.emp_attribute26;
692: End If;
693: If (p_rec.emp_attribute27 = hr_api.g_varchar2) then
694: p_rec.emp_attribute27 :=
695: ben_emp_shd.g_old_rec.emp_attribute27;

Line 695: ben_emp_shd.g_old_rec.emp_attribute27;

691: ben_emp_shd.g_old_rec.emp_attribute26;
692: End If;
693: If (p_rec.emp_attribute27 = hr_api.g_varchar2) then
694: p_rec.emp_attribute27 :=
695: ben_emp_shd.g_old_rec.emp_attribute27;
696: End If;
697: If (p_rec.emp_attribute28 = hr_api.g_varchar2) then
698: p_rec.emp_attribute28 :=
699: ben_emp_shd.g_old_rec.emp_attribute28;

Line 699: ben_emp_shd.g_old_rec.emp_attribute28;

695: ben_emp_shd.g_old_rec.emp_attribute27;
696: End If;
697: If (p_rec.emp_attribute28 = hr_api.g_varchar2) then
698: p_rec.emp_attribute28 :=
699: ben_emp_shd.g_old_rec.emp_attribute28;
700: End If;
701: If (p_rec.emp_attribute29 = hr_api.g_varchar2) then
702: p_rec.emp_attribute29 :=
703: ben_emp_shd.g_old_rec.emp_attribute29;

Line 703: ben_emp_shd.g_old_rec.emp_attribute29;

699: ben_emp_shd.g_old_rec.emp_attribute28;
700: End If;
701: If (p_rec.emp_attribute29 = hr_api.g_varchar2) then
702: p_rec.emp_attribute29 :=
703: ben_emp_shd.g_old_rec.emp_attribute29;
704: End If;
705: If (p_rec.emp_attribute30 = hr_api.g_varchar2) then
706: p_rec.emp_attribute30 :=
707: ben_emp_shd.g_old_rec.emp_attribute30;

Line 707: ben_emp_shd.g_old_rec.emp_attribute30;

703: ben_emp_shd.g_old_rec.emp_attribute29;
704: End If;
705: If (p_rec.emp_attribute30 = hr_api.g_varchar2) then
706: p_rec.emp_attribute30 :=
707: ben_emp_shd.g_old_rec.emp_attribute30;
708: End If;
709: If (p_rec.criteria_score = hr_api.g_number) then
710: p_rec.criteria_score :=
711: ben_emp_shd.g_old_rec.criteria_score;

Line 711: ben_emp_shd.g_old_rec.criteria_score;

707: ben_emp_shd.g_old_rec.emp_attribute30;
708: End If;
709: If (p_rec.criteria_score = hr_api.g_number) then
710: p_rec.criteria_score :=
711: ben_emp_shd.g_old_rec.criteria_score;
712: End If;
713: If (p_rec.criteria_weight = hr_api.g_number) then
714: p_rec.criteria_weight :=
715: ben_emp_shd.g_old_rec.criteria_weight;

Line 715: ben_emp_shd.g_old_rec.criteria_weight;

711: ben_emp_shd.g_old_rec.criteria_score;
712: End If;
713: If (p_rec.criteria_weight = hr_api.g_number) then
714: p_rec.criteria_weight :=
715: ben_emp_shd.g_old_rec.criteria_weight;
716: End If;
717:
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 728: p_rec in out nocopy ben_emp_shd.g_rec_type,

724: -- |---------------------------------< upd >----------------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure upd
727: (
728: p_rec in out nocopy ben_emp_shd.g_rec_type,
729: p_effective_date in date,
730: p_datetrack_mode in varchar2
731: ) is
732: --

Line 746: ben_emp_shd.lck

742: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
743: --
744: -- We must lock the row which we need to update.
745: --
746: ben_emp_shd.lck
747: (p_effective_date => p_effective_date,
748: p_datetrack_mode => p_datetrack_mode,
749: p_ELIG_MRTL_STS_PRTE_id => p_rec.ELIG_MRTL_STS_PRTE_id,
750: p_object_version_number => p_rec.object_version_number,

Line 846: l_rec ben_emp_shd.g_rec_type;

842: p_criteria_score in number default hr_api.g_number,
843: p_criteria_weight in number default hr_api.g_number
844: ) is
845: --
846: l_rec ben_emp_shd.g_rec_type;
847: l_proc varchar2(72) := g_package||'upd';
848: --
849: Begin
850: hr_utility.set_location('Entering:'||l_proc, 5);

Line 856: ben_emp_shd.convert_args

852: -- Call conversion function to turn arguments into the
853: -- l_rec structure.
854: --
855: l_rec :=
856: ben_emp_shd.convert_args
857: (
858: p_ELIG_MRTL_STS_PRTE_id,
859: null,
860: null,