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_ESH_DEL dependencies on BEN_ESH_SHD

Line 54: (p_rec in out nocopy ben_esh_shd.g_rec_type,

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_esh_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

Line 66: ben_esh_shd.g_api_dml := true; -- Set the api dml status

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_esh_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ben_esh_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_elig_schedd_hrs_prte_f
72: where elig_schedd_hrs_prte_id = p_rec.elig_schedd_hrs_prte_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_esh_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_esh_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: ben_esh_shd.g_api_dml := true; -- Set the api dml status

74: --
75: ben_esh_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_esh_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

Line 87: ben_esh_shd.g_api_dml := false; -- Unset the api dml status

83: delete from ben_elig_schedd_hrs_prte_f
84: where elig_schedd_hrs_prte_id = p_rec.elig_schedd_hrs_prte_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_esh_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

Line 94: ben_esh_shd.g_api_dml := false; -- Unset the api dml status

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_esh_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

Line 102: (p_rec in out nocopy ben_esh_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_esh_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

Line 156: (p_rec in out nocopy ben_esh_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_esh_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := ben_esh_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_esh_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_esh_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_esh_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.elig_schedd_hrs_prte_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

Line 227: (p_rec in out nocopy ben_esh_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_esh_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in ben_esh_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_esh_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd

Line 310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl

Line 311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd

Line 312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl

Line 313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd

309: ,p_effective_start_date_o =>ben_esh_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num

Line 314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl

310: ,p_effective_end_date_o =>ben_esh_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl

Line 315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd

311: ,p_business_group_id_o =>ben_esh_shd.g_old_rec.business_group_id
312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd

Line 316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl

312: ,p_hrs_num_o =>ben_esh_shd.g_old_rec.hrs_num
313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num

Line 317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num

313: ,p_determination_cd_o =>ben_esh_shd.g_old_rec.determination_cd
314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag

Line 318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl

314: ,p_determination_rl_o =>ben_esh_shd.g_old_rec.determination_rl
315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id

Line 319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd

315: ,p_rounding_cd_o =>ben_esh_shd.g_old_rec.rounding_cd
316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category

Line 320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num

316: ,p_rounding_rl_o =>ben_esh_shd.g_old_rec.rounding_rl
317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1

Line 321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag

317: ,p_max_hrs_num_o =>ben_esh_shd.g_old_rec.max_hrs_num
318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2

Line 322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id

318: ,p_schedd_hrs_rl_o =>ben_esh_shd.g_old_rec.schedd_hrs_rl
319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3

Line 323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category

319: ,p_freq_cd_o =>ben_esh_shd.g_old_rec.freq_cd
320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4

Line 324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1

320: ,p_ordr_num_o =>ben_esh_shd.g_old_rec.ordr_num
321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5

Line 325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2

321: ,p_excld_flag_o =>ben_esh_shd.g_old_rec.excld_flag
322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6

Line 326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3

322: ,p_eligy_prfl_id_o =>ben_esh_shd.g_old_rec.eligy_prfl_id
323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7

Line 327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4

323: ,p_esh_attribute_category_o =>ben_esh_shd.g_old_rec.esh_attribute_category
324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8

Line 328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5

324: ,p_esh_attribute1_o =>ben_esh_shd.g_old_rec.esh_attribute1
325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9

Line 329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6

325: ,p_esh_attribute2_o =>ben_esh_shd.g_old_rec.esh_attribute2
326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10

Line 330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7

326: ,p_esh_attribute3_o =>ben_esh_shd.g_old_rec.esh_attribute3
327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11

Line 331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8

327: ,p_esh_attribute4_o =>ben_esh_shd.g_old_rec.esh_attribute4
328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12

Line 332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9

328: ,p_esh_attribute5_o =>ben_esh_shd.g_old_rec.esh_attribute5
329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13

Line 333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10

329: ,p_esh_attribute6_o =>ben_esh_shd.g_old_rec.esh_attribute6
330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14

Line 334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11

330: ,p_esh_attribute7_o =>ben_esh_shd.g_old_rec.esh_attribute7
331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15

Line 335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12

331: ,p_esh_attribute8_o =>ben_esh_shd.g_old_rec.esh_attribute8
332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16

Line 336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13

332: ,p_esh_attribute9_o =>ben_esh_shd.g_old_rec.esh_attribute9
333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17

Line 337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14

333: ,p_esh_attribute10_o =>ben_esh_shd.g_old_rec.esh_attribute10
334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18

Line 338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15

334: ,p_esh_attribute11_o =>ben_esh_shd.g_old_rec.esh_attribute11
335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19

Line 339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16

335: ,p_esh_attribute12_o =>ben_esh_shd.g_old_rec.esh_attribute12
336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20

Line 340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17

336: ,p_esh_attribute13_o =>ben_esh_shd.g_old_rec.esh_attribute13
337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21

Line 341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18

337: ,p_esh_attribute14_o =>ben_esh_shd.g_old_rec.esh_attribute14
338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22

Line 342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19

338: ,p_esh_attribute15_o =>ben_esh_shd.g_old_rec.esh_attribute15
339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23

Line 343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20

339: ,p_esh_attribute16_o =>ben_esh_shd.g_old_rec.esh_attribute16
340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24

Line 344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21

340: ,p_esh_attribute17_o =>ben_esh_shd.g_old_rec.esh_attribute17
341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25

Line 345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22

341: ,p_esh_attribute18_o =>ben_esh_shd.g_old_rec.esh_attribute18
342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26

Line 346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23

342: ,p_esh_attribute19_o =>ben_esh_shd.g_old_rec.esh_attribute19
343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27

Line 347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24

343: ,p_esh_attribute20_o =>ben_esh_shd.g_old_rec.esh_attribute20
344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28

Line 348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25

344: ,p_esh_attribute21_o =>ben_esh_shd.g_old_rec.esh_attribute21
345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29

Line 349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26

345: ,p_esh_attribute22_o =>ben_esh_shd.g_old_rec.esh_attribute22
346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30

Line 350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27

346: ,p_esh_attribute23_o =>ben_esh_shd.g_old_rec.esh_attribute23
347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number

Line 351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28

347: ,p_esh_attribute24_o =>ben_esh_shd.g_old_rec.esh_attribute24
348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score

Line 352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29

348: ,p_esh_attribute25_o =>ben_esh_shd.g_old_rec.esh_attribute25
349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score
356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight

Line 353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30

349: ,p_esh_attribute26_o =>ben_esh_shd.g_old_rec.esh_attribute26
350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score
356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight
357: );

Line 354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number

350: ,p_esh_attribute27_o =>ben_esh_shd.g_old_rec.esh_attribute27
351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score
356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight
357: );
358: --

Line 355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score

351: ,p_esh_attribute28_o =>ben_esh_shd.g_old_rec.esh_attribute28
352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score
356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight
357: );
358: --
359: exception

Line 356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight

352: ,p_esh_attribute29_o =>ben_esh_shd.g_old_rec.esh_attribute29
353: ,p_esh_attribute30_o =>ben_esh_shd.g_old_rec.esh_attribute30
354: ,p_object_version_number_o =>ben_esh_shd.g_old_rec.object_version_number
355: ,p_criteria_score_o =>ben_esh_shd.g_old_rec.criteria_score
356: ,p_criteria_weight_o =>ben_esh_shd.g_old_rec.criteria_weight
357: );
358: --
359: exception
360: --

Line 380: p_rec in out nocopy ben_esh_shd.g_rec_type,

376: -- |---------------------------------< del >----------------------------------|
377: -- ----------------------------------------------------------------------------
378: Procedure del
379: (
380: p_rec in out nocopy ben_esh_shd.g_rec_type,
381: p_effective_date in date,
382: p_datetrack_mode in varchar2
383: ) is
384: --

Line 398: ben_esh_shd.lck

394: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
395: --
396: -- We must lock the row which we need to delete.
397: --
398: ben_esh_shd.lck
399: (p_effective_date => p_effective_date,
400: p_datetrack_mode => p_datetrack_mode,
401: p_elig_schedd_hrs_prte_id => p_rec.elig_schedd_hrs_prte_id,
402: p_object_version_number => p_rec.object_version_number,

Line 456: l_rec ben_esh_shd.g_rec_type;

452: p_effective_date in date,
453: p_datetrack_mode in varchar2
454: ) is
455: --
456: l_rec ben_esh_shd.g_rec_type;
457: l_proc varchar2(72) := g_package||'del';
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);