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_EPZ_UPD dependencies on BEN_EPZ_SHD

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

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

77: (p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
78: p_base_key_column => 'elig_pstl_cd_r_rng_prte_id',
79: p_base_key_value => p_rec.elig_pstl_cd_r_rng_prte_id);
80: --
81: ben_epz_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_pstl_cd_r_rng_prte_f Row
84: --
85: hr_utility.set_location('********right before the actual update',10);

Line 140: ben_epz_shd.g_api_dml := false; -- Unset the api dml status

136: and effective_start_date = p_validation_start_date
137: and effective_end_date = p_validation_end_date;
138: hr_utility.set_location('********right after the actual update',10);
139: --
140: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: -- Set the effective start and end dates
143: --
144: p_rec.effective_start_date := p_validation_start_date;

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

148: hr_utility.set_location(' Leaving:'||l_proc, 15);
149: Exception
150: When hr_api.check_integrity_violated Then
151: -- A check constraint has been violated
152: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
153: ben_epz_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated

Line 153: ben_epz_shd.constraint_error

149: Exception
150: When hr_api.check_integrity_violated Then
151: -- A check constraint has been violated
152: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
153: ben_epz_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ben_epz_shd.g_api_dml := false; -- Unset the api dml status

Line 157: ben_epz_shd.g_api_dml := false; -- Unset the api dml status

153: ben_epz_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
158: ben_epz_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ben_epz_shd.g_api_dml := false; -- Unset the api dml status

Line 158: ben_epz_shd.constraint_error

154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
158: ben_epz_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;

Line 161: ben_epz_shd.g_api_dml := false; -- Unset the api dml status

157: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
158: ben_epz_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;
163: End dt_update_dml;
164: --
165: -- ----------------------------------------------------------------------------

Line 197: (p_rec in out nocopy ben_epz_shd.g_rec_type,

193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure update_dml
197: (p_rec in out nocopy ben_epz_shd.g_rec_type,
198: p_effective_date in date,
199: p_datetrack_mode in varchar2,
200: p_validation_start_date in date,
201: p_validation_end_date in date) is

Line 261: (p_rec in out nocopy ben_epz_shd.g_rec_type,

257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure dt_pre_update
261: (p_rec in out nocopy ben_epz_shd.g_rec_type,
262: p_effective_date in date,
263: p_datetrack_mode in varchar2,
264: p_validation_start_date in date,
265: p_validation_end_date in date) is

Line 277: ben_epz_shd.upd_effective_end_date

273: hr_utility.set_location(l_proc, 10);
274: --
275: -- Update the current effective end date
276: --
277: ben_epz_shd.upd_effective_end_date
278: (p_effective_date => p_effective_date,
279: p_base_key_value => p_rec.elig_pstl_cd_r_rng_prte_id,
280: p_new_effective_end_date => (p_validation_start_date - 1),
281: p_validation_start_date => p_validation_start_date,

Line 346: (p_rec in out nocopy ben_epz_shd.g_rec_type,

342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure pre_update
346: (p_rec in out nocopy ben_epz_shd.g_rec_type,
347: p_effective_date in date,
348: p_datetrack_mode in varchar2,
349: p_validation_start_date in date,
350: p_validation_end_date in date) is

Line 402: (p_rec in ben_epz_shd.g_rec_type,

398: --
399: -- {End Of Comments}
400: -- ----------------------------------------------------------------------------
401: Procedure post_update
402: (p_rec in ben_epz_shd.g_rec_type,
403: p_effective_date in date,
404: p_datetrack_mode in varchar2,
405: p_validation_start_date in date,
406: p_validation_end_date in date) is

Line 466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date

462: ,p_validation_start_date =>p_validation_start_date
463: ,p_validation_end_date =>p_validation_end_date
464: ,p_criteria_score =>p_rec.criteria_score
465: ,p_criteria_weight =>p_rec.criteria_weight
466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date
467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id

Line 467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date

463: ,p_validation_end_date =>p_validation_end_date
464: ,p_criteria_score =>p_rec.criteria_score
465: ,p_criteria_weight =>p_rec.criteria_weight
466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date
467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id

Line 468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num

464: ,p_criteria_score =>p_rec.criteria_score
465: ,p_criteria_weight =>p_rec.criteria_weight
466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date
467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id

Line 469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag

465: ,p_criteria_weight =>p_rec.criteria_weight
466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date
467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category

Line 470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id

466: ,p_effective_start_date_o =>ben_epz_shd.g_old_rec.effective_start_date
467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1

Line 471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id

467: ,p_effective_end_date_o =>ben_epz_shd.g_old_rec.effective_end_date
468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2

Line 472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id

468: ,p_ordr_num_o =>ben_epz_shd.g_old_rec.ordr_num
469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3

Line 473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category

469: ,p_excld_flag_o =>ben_epz_shd.g_old_rec.excld_flag
470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4

Line 474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1

470: ,p_pstl_zip_rng_id_o =>ben_epz_shd.g_old_rec.pstl_zip_rng_id
471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5

Line 475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2

471: ,p_eligy_prfl_id_o =>ben_epz_shd.g_old_rec.eligy_prfl_id
472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6

Line 476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3

472: ,p_business_group_id_o =>ben_epz_shd.g_old_rec.business_group_id
473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7

Line 477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4

473: ,p_epz_attribute_category_o =>ben_epz_shd.g_old_rec.epz_attribute_category
474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8

Line 478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5

474: ,p_epz_attribute1_o =>ben_epz_shd.g_old_rec.epz_attribute1
475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9

Line 479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6

475: ,p_epz_attribute2_o =>ben_epz_shd.g_old_rec.epz_attribute2
476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10

Line 480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7

476: ,p_epz_attribute3_o =>ben_epz_shd.g_old_rec.epz_attribute3
477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11

Line 481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8

477: ,p_epz_attribute4_o =>ben_epz_shd.g_old_rec.epz_attribute4
478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12

Line 482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9

478: ,p_epz_attribute5_o =>ben_epz_shd.g_old_rec.epz_attribute5
479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13

Line 483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10

479: ,p_epz_attribute6_o =>ben_epz_shd.g_old_rec.epz_attribute6
480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14

Line 484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11

480: ,p_epz_attribute7_o =>ben_epz_shd.g_old_rec.epz_attribute7
481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15

Line 485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12

481: ,p_epz_attribute8_o =>ben_epz_shd.g_old_rec.epz_attribute8
482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16

Line 486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13

482: ,p_epz_attribute9_o =>ben_epz_shd.g_old_rec.epz_attribute9
483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17

Line 487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14

483: ,p_epz_attribute10_o =>ben_epz_shd.g_old_rec.epz_attribute10
484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18

Line 488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15

484: ,p_epz_attribute11_o =>ben_epz_shd.g_old_rec.epz_attribute11
485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19

Line 489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16

485: ,p_epz_attribute12_o =>ben_epz_shd.g_old_rec.epz_attribute12
486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20

Line 490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17

486: ,p_epz_attribute13_o =>ben_epz_shd.g_old_rec.epz_attribute13
487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21

Line 491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18

487: ,p_epz_attribute14_o =>ben_epz_shd.g_old_rec.epz_attribute14
488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22

Line 492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19

488: ,p_epz_attribute15_o =>ben_epz_shd.g_old_rec.epz_attribute15
489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23

Line 493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20

489: ,p_epz_attribute16_o =>ben_epz_shd.g_old_rec.epz_attribute16
490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24

Line 494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21

490: ,p_epz_attribute17_o =>ben_epz_shd.g_old_rec.epz_attribute17
491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25

Line 495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22

491: ,p_epz_attribute18_o =>ben_epz_shd.g_old_rec.epz_attribute18
492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26

Line 496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23

492: ,p_epz_attribute19_o =>ben_epz_shd.g_old_rec.epz_attribute19
493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27

Line 497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24

493: ,p_epz_attribute20_o =>ben_epz_shd.g_old_rec.epz_attribute20
494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28

Line 498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25

494: ,p_epz_attribute21_o =>ben_epz_shd.g_old_rec.epz_attribute21
495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29

Line 499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26

495: ,p_epz_attribute22_o =>ben_epz_shd.g_old_rec.epz_attribute22
496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30

Line 500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27

496: ,p_epz_attribute23_o =>ben_epz_shd.g_old_rec.epz_attribute23
497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number

Line 501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28

497: ,p_epz_attribute24_o =>ben_epz_shd.g_old_rec.epz_attribute24
498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score

Line 502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29

498: ,p_epz_attribute25_o =>ben_epz_shd.g_old_rec.epz_attribute25
499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score
506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight

Line 503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30

499: ,p_epz_attribute26_o =>ben_epz_shd.g_old_rec.epz_attribute26
500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score
506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight
507: );

Line 504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number

500: ,p_epz_attribute27_o =>ben_epz_shd.g_old_rec.epz_attribute27
501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score
506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight
507: );
508: --

Line 505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score

501: ,p_epz_attribute28_o =>ben_epz_shd.g_old_rec.epz_attribute28
502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score
506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight
507: );
508: --
509: exception

Line 506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight

502: ,p_epz_attribute29_o =>ben_epz_shd.g_old_rec.epz_attribute29
503: ,p_epz_attribute30_o =>ben_epz_shd.g_old_rec.epz_attribute30
504: ,p_object_version_number_o =>ben_epz_shd.g_old_rec.object_version_number
505: ,p_criteria_score_o =>ben_epz_shd.g_old_rec.criteria_score
506: ,p_criteria_weight_o =>ben_epz_shd.g_old_rec.criteria_weight
507: );
508: --
509: exception
510: --

Line 568: Procedure convert_defs(p_rec in out nocopy ben_epz_shd.g_rec_type) is

564: -- Internal Row Handler Use Only.
565: --
566: -- {End Of Comments}
567: -- ----------------------------------------------------------------------------
568: Procedure convert_defs(p_rec in out nocopy ben_epz_shd.g_rec_type) is
569: --
570: l_proc varchar2(72) := g_package||'convert_defs';
571: --
572: Begin

Line 583: ben_epz_shd.g_old_rec.ordr_num;

579: -- is being used then we must set to the 'current' argument value.
580: --
581: If (p_rec.ordr_num = hr_api.g_number) then
582: p_rec.ordr_num :=
583: ben_epz_shd.g_old_rec.ordr_num;
584: End If;
585: If (p_rec.excld_flag = hr_api.g_varchar2) then
586: p_rec.excld_flag :=
587: ben_epz_shd.g_old_rec.excld_flag;

Line 587: ben_epz_shd.g_old_rec.excld_flag;

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

Line 591: ben_epz_shd.g_old_rec.pstl_zip_rng_id;

587: ben_epz_shd.g_old_rec.excld_flag;
588: End If;
589: If (p_rec.pstl_zip_rng_id = hr_api.g_number) then
590: p_rec.pstl_zip_rng_id :=
591: ben_epz_shd.g_old_rec.pstl_zip_rng_id;
592: End If;
593: If (p_rec.eligy_prfl_id = hr_api.g_number) then
594: p_rec.eligy_prfl_id :=
595: ben_epz_shd.g_old_rec.eligy_prfl_id;

Line 595: ben_epz_shd.g_old_rec.eligy_prfl_id;

591: ben_epz_shd.g_old_rec.pstl_zip_rng_id;
592: End If;
593: If (p_rec.eligy_prfl_id = hr_api.g_number) then
594: p_rec.eligy_prfl_id :=
595: ben_epz_shd.g_old_rec.eligy_prfl_id;
596: End If;
597: If (p_rec.business_group_id = hr_api.g_number) then
598: p_rec.business_group_id :=
599: ben_epz_shd.g_old_rec.business_group_id;

Line 599: ben_epz_shd.g_old_rec.business_group_id;

595: ben_epz_shd.g_old_rec.eligy_prfl_id;
596: End If;
597: If (p_rec.business_group_id = hr_api.g_number) then
598: p_rec.business_group_id :=
599: ben_epz_shd.g_old_rec.business_group_id;
600: End If;
601: If (p_rec.epz_attribute_category = hr_api.g_varchar2) then
602: p_rec.epz_attribute_category :=
603: ben_epz_shd.g_old_rec.epz_attribute_category;

Line 603: ben_epz_shd.g_old_rec.epz_attribute_category;

599: ben_epz_shd.g_old_rec.business_group_id;
600: End If;
601: If (p_rec.epz_attribute_category = hr_api.g_varchar2) then
602: p_rec.epz_attribute_category :=
603: ben_epz_shd.g_old_rec.epz_attribute_category;
604: End If;
605: If (p_rec.epz_attribute1 = hr_api.g_varchar2) then
606: p_rec.epz_attribute1 :=
607: ben_epz_shd.g_old_rec.epz_attribute1;

Line 607: ben_epz_shd.g_old_rec.epz_attribute1;

603: ben_epz_shd.g_old_rec.epz_attribute_category;
604: End If;
605: If (p_rec.epz_attribute1 = hr_api.g_varchar2) then
606: p_rec.epz_attribute1 :=
607: ben_epz_shd.g_old_rec.epz_attribute1;
608: End If;
609: If (p_rec.epz_attribute2 = hr_api.g_varchar2) then
610: p_rec.epz_attribute2 :=
611: ben_epz_shd.g_old_rec.epz_attribute2;

Line 611: ben_epz_shd.g_old_rec.epz_attribute2;

607: ben_epz_shd.g_old_rec.epz_attribute1;
608: End If;
609: If (p_rec.epz_attribute2 = hr_api.g_varchar2) then
610: p_rec.epz_attribute2 :=
611: ben_epz_shd.g_old_rec.epz_attribute2;
612: End If;
613: If (p_rec.epz_attribute3 = hr_api.g_varchar2) then
614: p_rec.epz_attribute3 :=
615: ben_epz_shd.g_old_rec.epz_attribute3;

Line 615: ben_epz_shd.g_old_rec.epz_attribute3;

611: ben_epz_shd.g_old_rec.epz_attribute2;
612: End If;
613: If (p_rec.epz_attribute3 = hr_api.g_varchar2) then
614: p_rec.epz_attribute3 :=
615: ben_epz_shd.g_old_rec.epz_attribute3;
616: End If;
617: If (p_rec.epz_attribute4 = hr_api.g_varchar2) then
618: p_rec.epz_attribute4 :=
619: ben_epz_shd.g_old_rec.epz_attribute4;

Line 619: ben_epz_shd.g_old_rec.epz_attribute4;

615: ben_epz_shd.g_old_rec.epz_attribute3;
616: End If;
617: If (p_rec.epz_attribute4 = hr_api.g_varchar2) then
618: p_rec.epz_attribute4 :=
619: ben_epz_shd.g_old_rec.epz_attribute4;
620: End If;
621: If (p_rec.epz_attribute5 = hr_api.g_varchar2) then
622: p_rec.epz_attribute5 :=
623: ben_epz_shd.g_old_rec.epz_attribute5;

Line 623: ben_epz_shd.g_old_rec.epz_attribute5;

619: ben_epz_shd.g_old_rec.epz_attribute4;
620: End If;
621: If (p_rec.epz_attribute5 = hr_api.g_varchar2) then
622: p_rec.epz_attribute5 :=
623: ben_epz_shd.g_old_rec.epz_attribute5;
624: End If;
625: If (p_rec.epz_attribute6 = hr_api.g_varchar2) then
626: p_rec.epz_attribute6 :=
627: ben_epz_shd.g_old_rec.epz_attribute6;

Line 627: ben_epz_shd.g_old_rec.epz_attribute6;

623: ben_epz_shd.g_old_rec.epz_attribute5;
624: End If;
625: If (p_rec.epz_attribute6 = hr_api.g_varchar2) then
626: p_rec.epz_attribute6 :=
627: ben_epz_shd.g_old_rec.epz_attribute6;
628: End If;
629: If (p_rec.epz_attribute7 = hr_api.g_varchar2) then
630: p_rec.epz_attribute7 :=
631: ben_epz_shd.g_old_rec.epz_attribute7;

Line 631: ben_epz_shd.g_old_rec.epz_attribute7;

627: ben_epz_shd.g_old_rec.epz_attribute6;
628: End If;
629: If (p_rec.epz_attribute7 = hr_api.g_varchar2) then
630: p_rec.epz_attribute7 :=
631: ben_epz_shd.g_old_rec.epz_attribute7;
632: End If;
633: If (p_rec.epz_attribute8 = hr_api.g_varchar2) then
634: p_rec.epz_attribute8 :=
635: ben_epz_shd.g_old_rec.epz_attribute8;

Line 635: ben_epz_shd.g_old_rec.epz_attribute8;

631: ben_epz_shd.g_old_rec.epz_attribute7;
632: End If;
633: If (p_rec.epz_attribute8 = hr_api.g_varchar2) then
634: p_rec.epz_attribute8 :=
635: ben_epz_shd.g_old_rec.epz_attribute8;
636: End If;
637: If (p_rec.epz_attribute9 = hr_api.g_varchar2) then
638: p_rec.epz_attribute9 :=
639: ben_epz_shd.g_old_rec.epz_attribute9;

Line 639: ben_epz_shd.g_old_rec.epz_attribute9;

635: ben_epz_shd.g_old_rec.epz_attribute8;
636: End If;
637: If (p_rec.epz_attribute9 = hr_api.g_varchar2) then
638: p_rec.epz_attribute9 :=
639: ben_epz_shd.g_old_rec.epz_attribute9;
640: End If;
641: If (p_rec.epz_attribute10 = hr_api.g_varchar2) then
642: p_rec.epz_attribute10 :=
643: ben_epz_shd.g_old_rec.epz_attribute10;

Line 643: ben_epz_shd.g_old_rec.epz_attribute10;

639: ben_epz_shd.g_old_rec.epz_attribute9;
640: End If;
641: If (p_rec.epz_attribute10 = hr_api.g_varchar2) then
642: p_rec.epz_attribute10 :=
643: ben_epz_shd.g_old_rec.epz_attribute10;
644: End If;
645: If (p_rec.epz_attribute11 = hr_api.g_varchar2) then
646: p_rec.epz_attribute11 :=
647: ben_epz_shd.g_old_rec.epz_attribute11;

Line 647: ben_epz_shd.g_old_rec.epz_attribute11;

643: ben_epz_shd.g_old_rec.epz_attribute10;
644: End If;
645: If (p_rec.epz_attribute11 = hr_api.g_varchar2) then
646: p_rec.epz_attribute11 :=
647: ben_epz_shd.g_old_rec.epz_attribute11;
648: End If;
649: If (p_rec.epz_attribute12 = hr_api.g_varchar2) then
650: p_rec.epz_attribute12 :=
651: ben_epz_shd.g_old_rec.epz_attribute12;

Line 651: ben_epz_shd.g_old_rec.epz_attribute12;

647: ben_epz_shd.g_old_rec.epz_attribute11;
648: End If;
649: If (p_rec.epz_attribute12 = hr_api.g_varchar2) then
650: p_rec.epz_attribute12 :=
651: ben_epz_shd.g_old_rec.epz_attribute12;
652: End If;
653: If (p_rec.epz_attribute13 = hr_api.g_varchar2) then
654: p_rec.epz_attribute13 :=
655: ben_epz_shd.g_old_rec.epz_attribute13;

Line 655: ben_epz_shd.g_old_rec.epz_attribute13;

651: ben_epz_shd.g_old_rec.epz_attribute12;
652: End If;
653: If (p_rec.epz_attribute13 = hr_api.g_varchar2) then
654: p_rec.epz_attribute13 :=
655: ben_epz_shd.g_old_rec.epz_attribute13;
656: End If;
657: If (p_rec.epz_attribute14 = hr_api.g_varchar2) then
658: p_rec.epz_attribute14 :=
659: ben_epz_shd.g_old_rec.epz_attribute14;

Line 659: ben_epz_shd.g_old_rec.epz_attribute14;

655: ben_epz_shd.g_old_rec.epz_attribute13;
656: End If;
657: If (p_rec.epz_attribute14 = hr_api.g_varchar2) then
658: p_rec.epz_attribute14 :=
659: ben_epz_shd.g_old_rec.epz_attribute14;
660: End If;
661: If (p_rec.epz_attribute15 = hr_api.g_varchar2) then
662: p_rec.epz_attribute15 :=
663: ben_epz_shd.g_old_rec.epz_attribute15;

Line 663: ben_epz_shd.g_old_rec.epz_attribute15;

659: ben_epz_shd.g_old_rec.epz_attribute14;
660: End If;
661: If (p_rec.epz_attribute15 = hr_api.g_varchar2) then
662: p_rec.epz_attribute15 :=
663: ben_epz_shd.g_old_rec.epz_attribute15;
664: End If;
665: If (p_rec.epz_attribute16 = hr_api.g_varchar2) then
666: p_rec.epz_attribute16 :=
667: ben_epz_shd.g_old_rec.epz_attribute16;

Line 667: ben_epz_shd.g_old_rec.epz_attribute16;

663: ben_epz_shd.g_old_rec.epz_attribute15;
664: End If;
665: If (p_rec.epz_attribute16 = hr_api.g_varchar2) then
666: p_rec.epz_attribute16 :=
667: ben_epz_shd.g_old_rec.epz_attribute16;
668: End If;
669: If (p_rec.epz_attribute17 = hr_api.g_varchar2) then
670: p_rec.epz_attribute17 :=
671: ben_epz_shd.g_old_rec.epz_attribute17;

Line 671: ben_epz_shd.g_old_rec.epz_attribute17;

667: ben_epz_shd.g_old_rec.epz_attribute16;
668: End If;
669: If (p_rec.epz_attribute17 = hr_api.g_varchar2) then
670: p_rec.epz_attribute17 :=
671: ben_epz_shd.g_old_rec.epz_attribute17;
672: End If;
673: If (p_rec.epz_attribute18 = hr_api.g_varchar2) then
674: p_rec.epz_attribute18 :=
675: ben_epz_shd.g_old_rec.epz_attribute18;

Line 675: ben_epz_shd.g_old_rec.epz_attribute18;

671: ben_epz_shd.g_old_rec.epz_attribute17;
672: End If;
673: If (p_rec.epz_attribute18 = hr_api.g_varchar2) then
674: p_rec.epz_attribute18 :=
675: ben_epz_shd.g_old_rec.epz_attribute18;
676: End If;
677: If (p_rec.epz_attribute19 = hr_api.g_varchar2) then
678: p_rec.epz_attribute19 :=
679: ben_epz_shd.g_old_rec.epz_attribute19;

Line 679: ben_epz_shd.g_old_rec.epz_attribute19;

675: ben_epz_shd.g_old_rec.epz_attribute18;
676: End If;
677: If (p_rec.epz_attribute19 = hr_api.g_varchar2) then
678: p_rec.epz_attribute19 :=
679: ben_epz_shd.g_old_rec.epz_attribute19;
680: End If;
681: If (p_rec.epz_attribute20 = hr_api.g_varchar2) then
682: p_rec.epz_attribute20 :=
683: ben_epz_shd.g_old_rec.epz_attribute20;

Line 683: ben_epz_shd.g_old_rec.epz_attribute20;

679: ben_epz_shd.g_old_rec.epz_attribute19;
680: End If;
681: If (p_rec.epz_attribute20 = hr_api.g_varchar2) then
682: p_rec.epz_attribute20 :=
683: ben_epz_shd.g_old_rec.epz_attribute20;
684: End If;
685: If (p_rec.epz_attribute21 = hr_api.g_varchar2) then
686: p_rec.epz_attribute21 :=
687: ben_epz_shd.g_old_rec.epz_attribute21;

Line 687: ben_epz_shd.g_old_rec.epz_attribute21;

683: ben_epz_shd.g_old_rec.epz_attribute20;
684: End If;
685: If (p_rec.epz_attribute21 = hr_api.g_varchar2) then
686: p_rec.epz_attribute21 :=
687: ben_epz_shd.g_old_rec.epz_attribute21;
688: End If;
689: If (p_rec.epz_attribute22 = hr_api.g_varchar2) then
690: p_rec.epz_attribute22 :=
691: ben_epz_shd.g_old_rec.epz_attribute22;

Line 691: ben_epz_shd.g_old_rec.epz_attribute22;

687: ben_epz_shd.g_old_rec.epz_attribute21;
688: End If;
689: If (p_rec.epz_attribute22 = hr_api.g_varchar2) then
690: p_rec.epz_attribute22 :=
691: ben_epz_shd.g_old_rec.epz_attribute22;
692: End If;
693: If (p_rec.epz_attribute23 = hr_api.g_varchar2) then
694: p_rec.epz_attribute23 :=
695: ben_epz_shd.g_old_rec.epz_attribute23;

Line 695: ben_epz_shd.g_old_rec.epz_attribute23;

691: ben_epz_shd.g_old_rec.epz_attribute22;
692: End If;
693: If (p_rec.epz_attribute23 = hr_api.g_varchar2) then
694: p_rec.epz_attribute23 :=
695: ben_epz_shd.g_old_rec.epz_attribute23;
696: End If;
697: If (p_rec.epz_attribute24 = hr_api.g_varchar2) then
698: p_rec.epz_attribute24 :=
699: ben_epz_shd.g_old_rec.epz_attribute24;

Line 699: ben_epz_shd.g_old_rec.epz_attribute24;

695: ben_epz_shd.g_old_rec.epz_attribute23;
696: End If;
697: If (p_rec.epz_attribute24 = hr_api.g_varchar2) then
698: p_rec.epz_attribute24 :=
699: ben_epz_shd.g_old_rec.epz_attribute24;
700: End If;
701: If (p_rec.epz_attribute25 = hr_api.g_varchar2) then
702: p_rec.epz_attribute25 :=
703: ben_epz_shd.g_old_rec.epz_attribute25;

Line 703: ben_epz_shd.g_old_rec.epz_attribute25;

699: ben_epz_shd.g_old_rec.epz_attribute24;
700: End If;
701: If (p_rec.epz_attribute25 = hr_api.g_varchar2) then
702: p_rec.epz_attribute25 :=
703: ben_epz_shd.g_old_rec.epz_attribute25;
704: End If;
705: If (p_rec.epz_attribute26 = hr_api.g_varchar2) then
706: p_rec.epz_attribute26 :=
707: ben_epz_shd.g_old_rec.epz_attribute26;

Line 707: ben_epz_shd.g_old_rec.epz_attribute26;

703: ben_epz_shd.g_old_rec.epz_attribute25;
704: End If;
705: If (p_rec.epz_attribute26 = hr_api.g_varchar2) then
706: p_rec.epz_attribute26 :=
707: ben_epz_shd.g_old_rec.epz_attribute26;
708: End If;
709: If (p_rec.epz_attribute27 = hr_api.g_varchar2) then
710: p_rec.epz_attribute27 :=
711: ben_epz_shd.g_old_rec.epz_attribute27;

Line 711: ben_epz_shd.g_old_rec.epz_attribute27;

707: ben_epz_shd.g_old_rec.epz_attribute26;
708: End If;
709: If (p_rec.epz_attribute27 = hr_api.g_varchar2) then
710: p_rec.epz_attribute27 :=
711: ben_epz_shd.g_old_rec.epz_attribute27;
712: End If;
713: If (p_rec.epz_attribute28 = hr_api.g_varchar2) then
714: p_rec.epz_attribute28 :=
715: ben_epz_shd.g_old_rec.epz_attribute28;

Line 715: ben_epz_shd.g_old_rec.epz_attribute28;

711: ben_epz_shd.g_old_rec.epz_attribute27;
712: End If;
713: If (p_rec.epz_attribute28 = hr_api.g_varchar2) then
714: p_rec.epz_attribute28 :=
715: ben_epz_shd.g_old_rec.epz_attribute28;
716: End If;
717: If (p_rec.epz_attribute29 = hr_api.g_varchar2) then
718: p_rec.epz_attribute29 :=
719: ben_epz_shd.g_old_rec.epz_attribute29;

Line 719: ben_epz_shd.g_old_rec.epz_attribute29;

715: ben_epz_shd.g_old_rec.epz_attribute28;
716: End If;
717: If (p_rec.epz_attribute29 = hr_api.g_varchar2) then
718: p_rec.epz_attribute29 :=
719: ben_epz_shd.g_old_rec.epz_attribute29;
720: End If;
721: If (p_rec.epz_attribute30 = hr_api.g_varchar2) then
722: p_rec.epz_attribute30 :=
723: ben_epz_shd.g_old_rec.epz_attribute30;

Line 723: ben_epz_shd.g_old_rec.epz_attribute30;

719: ben_epz_shd.g_old_rec.epz_attribute29;
720: End If;
721: If (p_rec.epz_attribute30 = hr_api.g_varchar2) then
722: p_rec.epz_attribute30 :=
723: ben_epz_shd.g_old_rec.epz_attribute30;
724: End If;
725: If (p_rec.criteria_score = hr_api.g_number) then
726: p_rec.criteria_score :=
727: ben_epz_shd.g_old_rec.criteria_score;

Line 727: ben_epz_shd.g_old_rec.criteria_score;

723: ben_epz_shd.g_old_rec.epz_attribute30;
724: End If;
725: If (p_rec.criteria_score = hr_api.g_number) then
726: p_rec.criteria_score :=
727: ben_epz_shd.g_old_rec.criteria_score;
728: End If;
729: If (p_rec.criteria_weight = hr_api.g_number) then
730: p_rec.criteria_weight :=
731: ben_epz_shd.g_old_rec.criteria_weight;

Line 731: ben_epz_shd.g_old_rec.criteria_weight;

727: ben_epz_shd.g_old_rec.criteria_score;
728: End If;
729: If (p_rec.criteria_weight = hr_api.g_number) then
730: p_rec.criteria_weight :=
731: ben_epz_shd.g_old_rec.criteria_weight;
732: End If;
733:
734: --
735: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 744: p_rec in out nocopy ben_epz_shd.g_rec_type,

740: -- |---------------------------------< upd >----------------------------------|
741: -- ----------------------------------------------------------------------------
742: Procedure upd
743: (
744: p_rec in out nocopy ben_epz_shd.g_rec_type,
745: p_effective_date in date,
746: p_datetrack_mode in varchar2
747: ) is
748: --

Line 762: ben_epz_shd.lck

758: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
759: --
760: -- We must lock the row which we need to update.
761: --
762: ben_epz_shd.lck
763: (p_effective_date => p_effective_date,
764: p_datetrack_mode => p_datetrack_mode,
765: p_elig_pstl_cd_r_rng_prte_id => p_rec.elig_pstl_cd_r_rng_prte_id,
766: p_object_version_number => p_rec.object_version_number,

Line 863: l_rec ben_epz_shd.g_rec_type;

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

Line 873: ben_epz_shd.convert_args

869: -- Call conversion function to turn arguments into the
870: -- l_rec structure.
871: --
872: l_rec :=
873: ben_epz_shd.convert_args
874: (
875: p_elig_pstl_cd_r_rng_prte_id,
876: null,
877: null,