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_EFP_UPD dependencies on BEN_EFP_SHD

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

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

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

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

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

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

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

Line 145: ben_efp_shd.constraint_error

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

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

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

Line 150: ben_efp_shd.constraint_error

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

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

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

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

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

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

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

Line 269: ben_efp_shd.upd_effective_end_date

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

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

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

Line 394: (p_rec in ben_efp_shd.g_rec_type,

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

Line 456: ,p_effective_start_date_o =>ben_efp_shd.g_old_rec.effective_start_date

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

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

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

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

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

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

455: ,p_validation_end_date =>p_validation_end_date
456: ,p_effective_start_date_o =>ben_efp_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_efp_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_efp_shd.g_old_rec.business_group_id
459: ,p_eligy_prfl_id_o =>ben_efp_shd.g_old_rec.eligy_prfl_id
460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category

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

456: ,p_effective_start_date_o =>ben_efp_shd.g_old_rec.effective_start_date
457: ,p_effective_end_date_o =>ben_efp_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_efp_shd.g_old_rec.business_group_id
459: ,p_eligy_prfl_id_o =>ben_efp_shd.g_old_rec.eligy_prfl_id
460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1

Line 461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd

457: ,p_effective_end_date_o =>ben_efp_shd.g_old_rec.effective_end_date
458: ,p_business_group_id_o =>ben_efp_shd.g_old_rec.business_group_id
459: ,p_eligy_prfl_id_o =>ben_efp_shd.g_old_rec.eligy_prfl_id
460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2

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

458: ,p_business_group_id_o =>ben_efp_shd.g_old_rec.business_group_id
459: ,p_eligy_prfl_id_o =>ben_efp_shd.g_old_rec.eligy_prfl_id
460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3

Line 463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category

459: ,p_eligy_prfl_id_o =>ben_efp_shd.g_old_rec.eligy_prfl_id
460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4

Line 464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1

460: ,p_ordr_num_o =>ben_efp_shd.g_old_rec.ordr_num
461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5

Line 465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2

461: ,p_fl_tm_pt_tm_cd_o =>ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd
462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6

Line 466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3

462: ,p_excld_flag_o =>ben_efp_shd.g_old_rec.excld_flag
463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7

Line 467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4

463: ,p_efp_attribute_category_o =>ben_efp_shd.g_old_rec.efp_attribute_category
464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8

Line 468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5

464: ,p_efp_attribute1_o =>ben_efp_shd.g_old_rec.efp_attribute1
465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9

Line 469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6

465: ,p_efp_attribute2_o =>ben_efp_shd.g_old_rec.efp_attribute2
466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10

Line 470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7

466: ,p_efp_attribute3_o =>ben_efp_shd.g_old_rec.efp_attribute3
467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11

Line 471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8

467: ,p_efp_attribute4_o =>ben_efp_shd.g_old_rec.efp_attribute4
468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12

Line 472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9

468: ,p_efp_attribute5_o =>ben_efp_shd.g_old_rec.efp_attribute5
469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13

Line 473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10

469: ,p_efp_attribute6_o =>ben_efp_shd.g_old_rec.efp_attribute6
470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14

Line 474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11

470: ,p_efp_attribute7_o =>ben_efp_shd.g_old_rec.efp_attribute7
471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15

Line 475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12

471: ,p_efp_attribute8_o =>ben_efp_shd.g_old_rec.efp_attribute8
472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16

Line 476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13

472: ,p_efp_attribute9_o =>ben_efp_shd.g_old_rec.efp_attribute9
473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17

Line 477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14

473: ,p_efp_attribute10_o =>ben_efp_shd.g_old_rec.efp_attribute10
474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18

Line 478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15

474: ,p_efp_attribute11_o =>ben_efp_shd.g_old_rec.efp_attribute11
475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19

Line 479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16

475: ,p_efp_attribute12_o =>ben_efp_shd.g_old_rec.efp_attribute12
476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20

Line 480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17

476: ,p_efp_attribute13_o =>ben_efp_shd.g_old_rec.efp_attribute13
477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21

Line 481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18

477: ,p_efp_attribute14_o =>ben_efp_shd.g_old_rec.efp_attribute14
478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22

Line 482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19

478: ,p_efp_attribute15_o =>ben_efp_shd.g_old_rec.efp_attribute15
479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23

Line 483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20

479: ,p_efp_attribute16_o =>ben_efp_shd.g_old_rec.efp_attribute16
480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24

Line 484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21

480: ,p_efp_attribute17_o =>ben_efp_shd.g_old_rec.efp_attribute17
481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25

Line 485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22

481: ,p_efp_attribute18_o =>ben_efp_shd.g_old_rec.efp_attribute18
482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26

Line 486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23

482: ,p_efp_attribute19_o =>ben_efp_shd.g_old_rec.efp_attribute19
483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27

Line 487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24

483: ,p_efp_attribute20_o =>ben_efp_shd.g_old_rec.efp_attribute20
484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28

Line 488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25

484: ,p_efp_attribute21_o =>ben_efp_shd.g_old_rec.efp_attribute21
485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29

Line 489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26

485: ,p_efp_attribute22_o =>ben_efp_shd.g_old_rec.efp_attribute22
486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30

Line 490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27

486: ,p_efp_attribute23_o =>ben_efp_shd.g_old_rec.efp_attribute23
487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number

Line 491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28

487: ,p_efp_attribute24_o =>ben_efp_shd.g_old_rec.efp_attribute24
488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score

Line 492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29

488: ,p_efp_attribute25_o =>ben_efp_shd.g_old_rec.efp_attribute25
489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_efp_shd.g_old_rec.criteria_weight

Line 493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30

489: ,p_efp_attribute26_o =>ben_efp_shd.g_old_rec.efp_attribute26
490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_efp_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score

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

490: ,p_efp_attribute27_o =>ben_efp_shd.g_old_rec.efp_attribute27
491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_efp_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight

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

491: ,p_efp_attribute28_o =>ben_efp_shd.g_old_rec.efp_attribute28
492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_efp_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight
499:

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

492: ,p_efp_attribute29_o =>ben_efp_shd.g_old_rec.efp_attribute29
493: ,p_efp_attribute30_o =>ben_efp_shd.g_old_rec.efp_attribute30
494: ,p_object_version_number_o =>ben_efp_shd.g_old_rec.object_version_number
495: ,p_criteria_score_o =>ben_efp_shd.g_old_rec.criteria_score
496: ,p_criteria_weight_o =>ben_efp_shd.g_old_rec.criteria_weight
497: ,p_criteria_score =>p_rec.criteria_score
498: ,p_criteria_weight =>p_rec.criteria_weight
499:
500:

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

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

Line 577: ben_efp_shd.g_old_rec.business_group_id;

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

Line 581: ben_efp_shd.g_old_rec.eligy_prfl_id;

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

Line 585: ben_efp_shd.g_old_rec.ordr_num;

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

Line 589: ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd;

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

Line 593: ben_efp_shd.g_old_rec.excld_flag;

589: ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd;
590: End If;
591: If (p_rec.excld_flag = hr_api.g_varchar2) then
592: p_rec.excld_flag :=
593: ben_efp_shd.g_old_rec.excld_flag;
594: End If;
595: If (p_rec.efp_attribute_category = hr_api.g_varchar2) then
596: p_rec.efp_attribute_category :=
597: ben_efp_shd.g_old_rec.efp_attribute_category;

Line 597: ben_efp_shd.g_old_rec.efp_attribute_category;

593: ben_efp_shd.g_old_rec.excld_flag;
594: End If;
595: If (p_rec.efp_attribute_category = hr_api.g_varchar2) then
596: p_rec.efp_attribute_category :=
597: ben_efp_shd.g_old_rec.efp_attribute_category;
598: End If;
599: If (p_rec.efp_attribute1 = hr_api.g_varchar2) then
600: p_rec.efp_attribute1 :=
601: ben_efp_shd.g_old_rec.efp_attribute1;

Line 601: ben_efp_shd.g_old_rec.efp_attribute1;

597: ben_efp_shd.g_old_rec.efp_attribute_category;
598: End If;
599: If (p_rec.efp_attribute1 = hr_api.g_varchar2) then
600: p_rec.efp_attribute1 :=
601: ben_efp_shd.g_old_rec.efp_attribute1;
602: End If;
603: If (p_rec.efp_attribute2 = hr_api.g_varchar2) then
604: p_rec.efp_attribute2 :=
605: ben_efp_shd.g_old_rec.efp_attribute2;

Line 605: ben_efp_shd.g_old_rec.efp_attribute2;

601: ben_efp_shd.g_old_rec.efp_attribute1;
602: End If;
603: If (p_rec.efp_attribute2 = hr_api.g_varchar2) then
604: p_rec.efp_attribute2 :=
605: ben_efp_shd.g_old_rec.efp_attribute2;
606: End If;
607: If (p_rec.efp_attribute3 = hr_api.g_varchar2) then
608: p_rec.efp_attribute3 :=
609: ben_efp_shd.g_old_rec.efp_attribute3;

Line 609: ben_efp_shd.g_old_rec.efp_attribute3;

605: ben_efp_shd.g_old_rec.efp_attribute2;
606: End If;
607: If (p_rec.efp_attribute3 = hr_api.g_varchar2) then
608: p_rec.efp_attribute3 :=
609: ben_efp_shd.g_old_rec.efp_attribute3;
610: End If;
611: If (p_rec.efp_attribute4 = hr_api.g_varchar2) then
612: p_rec.efp_attribute4 :=
613: ben_efp_shd.g_old_rec.efp_attribute4;

Line 613: ben_efp_shd.g_old_rec.efp_attribute4;

609: ben_efp_shd.g_old_rec.efp_attribute3;
610: End If;
611: If (p_rec.efp_attribute4 = hr_api.g_varchar2) then
612: p_rec.efp_attribute4 :=
613: ben_efp_shd.g_old_rec.efp_attribute4;
614: End If;
615: If (p_rec.efp_attribute5 = hr_api.g_varchar2) then
616: p_rec.efp_attribute5 :=
617: ben_efp_shd.g_old_rec.efp_attribute5;

Line 617: ben_efp_shd.g_old_rec.efp_attribute5;

613: ben_efp_shd.g_old_rec.efp_attribute4;
614: End If;
615: If (p_rec.efp_attribute5 = hr_api.g_varchar2) then
616: p_rec.efp_attribute5 :=
617: ben_efp_shd.g_old_rec.efp_attribute5;
618: End If;
619: If (p_rec.efp_attribute6 = hr_api.g_varchar2) then
620: p_rec.efp_attribute6 :=
621: ben_efp_shd.g_old_rec.efp_attribute6;

Line 621: ben_efp_shd.g_old_rec.efp_attribute6;

617: ben_efp_shd.g_old_rec.efp_attribute5;
618: End If;
619: If (p_rec.efp_attribute6 = hr_api.g_varchar2) then
620: p_rec.efp_attribute6 :=
621: ben_efp_shd.g_old_rec.efp_attribute6;
622: End If;
623: If (p_rec.efp_attribute7 = hr_api.g_varchar2) then
624: p_rec.efp_attribute7 :=
625: ben_efp_shd.g_old_rec.efp_attribute7;

Line 625: ben_efp_shd.g_old_rec.efp_attribute7;

621: ben_efp_shd.g_old_rec.efp_attribute6;
622: End If;
623: If (p_rec.efp_attribute7 = hr_api.g_varchar2) then
624: p_rec.efp_attribute7 :=
625: ben_efp_shd.g_old_rec.efp_attribute7;
626: End If;
627: If (p_rec.efp_attribute8 = hr_api.g_varchar2) then
628: p_rec.efp_attribute8 :=
629: ben_efp_shd.g_old_rec.efp_attribute8;

Line 629: ben_efp_shd.g_old_rec.efp_attribute8;

625: ben_efp_shd.g_old_rec.efp_attribute7;
626: End If;
627: If (p_rec.efp_attribute8 = hr_api.g_varchar2) then
628: p_rec.efp_attribute8 :=
629: ben_efp_shd.g_old_rec.efp_attribute8;
630: End If;
631: If (p_rec.efp_attribute9 = hr_api.g_varchar2) then
632: p_rec.efp_attribute9 :=
633: ben_efp_shd.g_old_rec.efp_attribute9;

Line 633: ben_efp_shd.g_old_rec.efp_attribute9;

629: ben_efp_shd.g_old_rec.efp_attribute8;
630: End If;
631: If (p_rec.efp_attribute9 = hr_api.g_varchar2) then
632: p_rec.efp_attribute9 :=
633: ben_efp_shd.g_old_rec.efp_attribute9;
634: End If;
635: If (p_rec.efp_attribute10 = hr_api.g_varchar2) then
636: p_rec.efp_attribute10 :=
637: ben_efp_shd.g_old_rec.efp_attribute10;

Line 637: ben_efp_shd.g_old_rec.efp_attribute10;

633: ben_efp_shd.g_old_rec.efp_attribute9;
634: End If;
635: If (p_rec.efp_attribute10 = hr_api.g_varchar2) then
636: p_rec.efp_attribute10 :=
637: ben_efp_shd.g_old_rec.efp_attribute10;
638: End If;
639: If (p_rec.efp_attribute11 = hr_api.g_varchar2) then
640: p_rec.efp_attribute11 :=
641: ben_efp_shd.g_old_rec.efp_attribute11;

Line 641: ben_efp_shd.g_old_rec.efp_attribute11;

637: ben_efp_shd.g_old_rec.efp_attribute10;
638: End If;
639: If (p_rec.efp_attribute11 = hr_api.g_varchar2) then
640: p_rec.efp_attribute11 :=
641: ben_efp_shd.g_old_rec.efp_attribute11;
642: End If;
643: If (p_rec.efp_attribute12 = hr_api.g_varchar2) then
644: p_rec.efp_attribute12 :=
645: ben_efp_shd.g_old_rec.efp_attribute12;

Line 645: ben_efp_shd.g_old_rec.efp_attribute12;

641: ben_efp_shd.g_old_rec.efp_attribute11;
642: End If;
643: If (p_rec.efp_attribute12 = hr_api.g_varchar2) then
644: p_rec.efp_attribute12 :=
645: ben_efp_shd.g_old_rec.efp_attribute12;
646: End If;
647: If (p_rec.efp_attribute13 = hr_api.g_varchar2) then
648: p_rec.efp_attribute13 :=
649: ben_efp_shd.g_old_rec.efp_attribute13;

Line 649: ben_efp_shd.g_old_rec.efp_attribute13;

645: ben_efp_shd.g_old_rec.efp_attribute12;
646: End If;
647: If (p_rec.efp_attribute13 = hr_api.g_varchar2) then
648: p_rec.efp_attribute13 :=
649: ben_efp_shd.g_old_rec.efp_attribute13;
650: End If;
651: If (p_rec.efp_attribute14 = hr_api.g_varchar2) then
652: p_rec.efp_attribute14 :=
653: ben_efp_shd.g_old_rec.efp_attribute14;

Line 653: ben_efp_shd.g_old_rec.efp_attribute14;

649: ben_efp_shd.g_old_rec.efp_attribute13;
650: End If;
651: If (p_rec.efp_attribute14 = hr_api.g_varchar2) then
652: p_rec.efp_attribute14 :=
653: ben_efp_shd.g_old_rec.efp_attribute14;
654: End If;
655: If (p_rec.efp_attribute15 = hr_api.g_varchar2) then
656: p_rec.efp_attribute15 :=
657: ben_efp_shd.g_old_rec.efp_attribute15;

Line 657: ben_efp_shd.g_old_rec.efp_attribute15;

653: ben_efp_shd.g_old_rec.efp_attribute14;
654: End If;
655: If (p_rec.efp_attribute15 = hr_api.g_varchar2) then
656: p_rec.efp_attribute15 :=
657: ben_efp_shd.g_old_rec.efp_attribute15;
658: End If;
659: If (p_rec.efp_attribute16 = hr_api.g_varchar2) then
660: p_rec.efp_attribute16 :=
661: ben_efp_shd.g_old_rec.efp_attribute16;

Line 661: ben_efp_shd.g_old_rec.efp_attribute16;

657: ben_efp_shd.g_old_rec.efp_attribute15;
658: End If;
659: If (p_rec.efp_attribute16 = hr_api.g_varchar2) then
660: p_rec.efp_attribute16 :=
661: ben_efp_shd.g_old_rec.efp_attribute16;
662: End If;
663: If (p_rec.efp_attribute17 = hr_api.g_varchar2) then
664: p_rec.efp_attribute17 :=
665: ben_efp_shd.g_old_rec.efp_attribute17;

Line 665: ben_efp_shd.g_old_rec.efp_attribute17;

661: ben_efp_shd.g_old_rec.efp_attribute16;
662: End If;
663: If (p_rec.efp_attribute17 = hr_api.g_varchar2) then
664: p_rec.efp_attribute17 :=
665: ben_efp_shd.g_old_rec.efp_attribute17;
666: End If;
667: If (p_rec.efp_attribute18 = hr_api.g_varchar2) then
668: p_rec.efp_attribute18 :=
669: ben_efp_shd.g_old_rec.efp_attribute18;

Line 669: ben_efp_shd.g_old_rec.efp_attribute18;

665: ben_efp_shd.g_old_rec.efp_attribute17;
666: End If;
667: If (p_rec.efp_attribute18 = hr_api.g_varchar2) then
668: p_rec.efp_attribute18 :=
669: ben_efp_shd.g_old_rec.efp_attribute18;
670: End If;
671: If (p_rec.efp_attribute19 = hr_api.g_varchar2) then
672: p_rec.efp_attribute19 :=
673: ben_efp_shd.g_old_rec.efp_attribute19;

Line 673: ben_efp_shd.g_old_rec.efp_attribute19;

669: ben_efp_shd.g_old_rec.efp_attribute18;
670: End If;
671: If (p_rec.efp_attribute19 = hr_api.g_varchar2) then
672: p_rec.efp_attribute19 :=
673: ben_efp_shd.g_old_rec.efp_attribute19;
674: End If;
675: If (p_rec.efp_attribute20 = hr_api.g_varchar2) then
676: p_rec.efp_attribute20 :=
677: ben_efp_shd.g_old_rec.efp_attribute20;

Line 677: ben_efp_shd.g_old_rec.efp_attribute20;

673: ben_efp_shd.g_old_rec.efp_attribute19;
674: End If;
675: If (p_rec.efp_attribute20 = hr_api.g_varchar2) then
676: p_rec.efp_attribute20 :=
677: ben_efp_shd.g_old_rec.efp_attribute20;
678: End If;
679: If (p_rec.efp_attribute21 = hr_api.g_varchar2) then
680: p_rec.efp_attribute21 :=
681: ben_efp_shd.g_old_rec.efp_attribute21;

Line 681: ben_efp_shd.g_old_rec.efp_attribute21;

677: ben_efp_shd.g_old_rec.efp_attribute20;
678: End If;
679: If (p_rec.efp_attribute21 = hr_api.g_varchar2) then
680: p_rec.efp_attribute21 :=
681: ben_efp_shd.g_old_rec.efp_attribute21;
682: End If;
683: If (p_rec.efp_attribute22 = hr_api.g_varchar2) then
684: p_rec.efp_attribute22 :=
685: ben_efp_shd.g_old_rec.efp_attribute22;

Line 685: ben_efp_shd.g_old_rec.efp_attribute22;

681: ben_efp_shd.g_old_rec.efp_attribute21;
682: End If;
683: If (p_rec.efp_attribute22 = hr_api.g_varchar2) then
684: p_rec.efp_attribute22 :=
685: ben_efp_shd.g_old_rec.efp_attribute22;
686: End If;
687: If (p_rec.efp_attribute23 = hr_api.g_varchar2) then
688: p_rec.efp_attribute23 :=
689: ben_efp_shd.g_old_rec.efp_attribute23;

Line 689: ben_efp_shd.g_old_rec.efp_attribute23;

685: ben_efp_shd.g_old_rec.efp_attribute22;
686: End If;
687: If (p_rec.efp_attribute23 = hr_api.g_varchar2) then
688: p_rec.efp_attribute23 :=
689: ben_efp_shd.g_old_rec.efp_attribute23;
690: End If;
691: If (p_rec.efp_attribute24 = hr_api.g_varchar2) then
692: p_rec.efp_attribute24 :=
693: ben_efp_shd.g_old_rec.efp_attribute24;

Line 693: ben_efp_shd.g_old_rec.efp_attribute24;

689: ben_efp_shd.g_old_rec.efp_attribute23;
690: End If;
691: If (p_rec.efp_attribute24 = hr_api.g_varchar2) then
692: p_rec.efp_attribute24 :=
693: ben_efp_shd.g_old_rec.efp_attribute24;
694: End If;
695: If (p_rec.efp_attribute25 = hr_api.g_varchar2) then
696: p_rec.efp_attribute25 :=
697: ben_efp_shd.g_old_rec.efp_attribute25;

Line 697: ben_efp_shd.g_old_rec.efp_attribute25;

693: ben_efp_shd.g_old_rec.efp_attribute24;
694: End If;
695: If (p_rec.efp_attribute25 = hr_api.g_varchar2) then
696: p_rec.efp_attribute25 :=
697: ben_efp_shd.g_old_rec.efp_attribute25;
698: End If;
699: If (p_rec.efp_attribute26 = hr_api.g_varchar2) then
700: p_rec.efp_attribute26 :=
701: ben_efp_shd.g_old_rec.efp_attribute26;

Line 701: ben_efp_shd.g_old_rec.efp_attribute26;

697: ben_efp_shd.g_old_rec.efp_attribute25;
698: End If;
699: If (p_rec.efp_attribute26 = hr_api.g_varchar2) then
700: p_rec.efp_attribute26 :=
701: ben_efp_shd.g_old_rec.efp_attribute26;
702: End If;
703: If (p_rec.efp_attribute27 = hr_api.g_varchar2) then
704: p_rec.efp_attribute27 :=
705: ben_efp_shd.g_old_rec.efp_attribute27;

Line 705: ben_efp_shd.g_old_rec.efp_attribute27;

701: ben_efp_shd.g_old_rec.efp_attribute26;
702: End If;
703: If (p_rec.efp_attribute27 = hr_api.g_varchar2) then
704: p_rec.efp_attribute27 :=
705: ben_efp_shd.g_old_rec.efp_attribute27;
706: End If;
707: If (p_rec.efp_attribute28 = hr_api.g_varchar2) then
708: p_rec.efp_attribute28 :=
709: ben_efp_shd.g_old_rec.efp_attribute28;

Line 709: ben_efp_shd.g_old_rec.efp_attribute28;

705: ben_efp_shd.g_old_rec.efp_attribute27;
706: End If;
707: If (p_rec.efp_attribute28 = hr_api.g_varchar2) then
708: p_rec.efp_attribute28 :=
709: ben_efp_shd.g_old_rec.efp_attribute28;
710: End If;
711: If (p_rec.efp_attribute29 = hr_api.g_varchar2) then
712: p_rec.efp_attribute29 :=
713: ben_efp_shd.g_old_rec.efp_attribute29;

Line 713: ben_efp_shd.g_old_rec.efp_attribute29;

709: ben_efp_shd.g_old_rec.efp_attribute28;
710: End If;
711: If (p_rec.efp_attribute29 = hr_api.g_varchar2) then
712: p_rec.efp_attribute29 :=
713: ben_efp_shd.g_old_rec.efp_attribute29;
714: End If;
715: If (p_rec.efp_attribute30 = hr_api.g_varchar2) then
716: p_rec.efp_attribute30 :=
717: ben_efp_shd.g_old_rec.efp_attribute30;

Line 717: ben_efp_shd.g_old_rec.efp_attribute30;

713: ben_efp_shd.g_old_rec.efp_attribute29;
714: End If;
715: If (p_rec.efp_attribute30 = hr_api.g_varchar2) then
716: p_rec.efp_attribute30 :=
717: ben_efp_shd.g_old_rec.efp_attribute30;
718: End If;
719:
720: If (p_rec.criteria_score = hr_api.g_number) then
721: p_rec.criteria_score :=

Line 722: ben_efp_shd.g_old_rec.criteria_score;

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

Line 727: ben_efp_shd.g_old_rec.criteria_weight;

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

Line 740: p_rec in out nocopy ben_efp_shd.g_rec_type,

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

Line 758: ben_efp_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_efp_shd.lck
759: (p_effective_date => p_effective_date,
760: p_datetrack_mode => p_datetrack_mode,
761: p_elig_fl_tm_pt_tm_prte_id => p_rec.elig_fl_tm_pt_tm_prte_id,
762: p_object_version_number => p_rec.object_version_number,

Line 859: l_rec ben_efp_shd.g_rec_type;

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

Line 869: ben_efp_shd.convert_args

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