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_EMS_DEL dependencies on BEN_EMS_SHD

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_ems_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_ems_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_ems_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_ems_shd.g_api_dml := false; -- Unset the api dml status

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

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

74: --
75: ben_ems_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_ems_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_ems_shd.g_api_dml := false; -- Unset the api dml status

83: delete from ben_elig_mrtl_stat_cvg_f
84: where elig_mrtl_stat_cvg_id = p_rec.elig_mrtl_stat_cvg_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_ems_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_ems_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_ems_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_ems_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_ems_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_ems_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_ems_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_ems_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_ems_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_ems_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_ems_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.elig_mrtl_stat_cvg_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_ems_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_ems_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_ems_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_ems_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_ems_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_ems_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd

Line 310: ,p_effective_end_date_o =>ben_ems_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_ems_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd

Line 311: ,p_business_group_id_o =>ben_ems_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_ems_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl

Line 312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_ems_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd

Line 313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd

309: ,p_effective_start_date_o =>ben_ems_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl

Line 314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd

310: ,p_effective_end_date_o =>ben_ems_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category

Line 315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl

311: ,p_business_group_id_o =>ben_ems_shd.g_old_rec.business_group_id
312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1

Line 316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd

312: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_ems_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2

Line 317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl

313: ,p_mrtl_stat_cd_o =>ben_ems_shd.g_old_rec.mrtl_stat_cd
314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3

Line 318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category

314: ,p_cvg_strt_cd_o =>ben_ems_shd.g_old_rec.cvg_strt_cd
315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4

Line 319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1

315: ,p_cvg_strt_rl_o =>ben_ems_shd.g_old_rec.cvg_strt_rl
316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5

Line 320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2

316: ,p_cvg_thru_cd_o =>ben_ems_shd.g_old_rec.cvg_thru_cd
317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6

Line 321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3

317: ,p_cvg_thru_rl_o =>ben_ems_shd.g_old_rec.cvg_thru_rl
318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7

Line 322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4

318: ,p_ems_attribute_category_o =>ben_ems_shd.g_old_rec.ems_attribute_category
319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8

Line 323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5

319: ,p_ems_attribute1_o =>ben_ems_shd.g_old_rec.ems_attribute1
320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9

Line 324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6

320: ,p_ems_attribute2_o =>ben_ems_shd.g_old_rec.ems_attribute2
321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10

Line 325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7

321: ,p_ems_attribute3_o =>ben_ems_shd.g_old_rec.ems_attribute3
322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11

Line 326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8

322: ,p_ems_attribute4_o =>ben_ems_shd.g_old_rec.ems_attribute4
323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12

Line 327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9

323: ,p_ems_attribute5_o =>ben_ems_shd.g_old_rec.ems_attribute5
324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13

Line 328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10

324: ,p_ems_attribute6_o =>ben_ems_shd.g_old_rec.ems_attribute6
325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14

Line 329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11

325: ,p_ems_attribute7_o =>ben_ems_shd.g_old_rec.ems_attribute7
326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15

Line 330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12

326: ,p_ems_attribute8_o =>ben_ems_shd.g_old_rec.ems_attribute8
327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16

Line 331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13

327: ,p_ems_attribute9_o =>ben_ems_shd.g_old_rec.ems_attribute9
328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17

Line 332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14

328: ,p_ems_attribute10_o =>ben_ems_shd.g_old_rec.ems_attribute10
329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18

Line 333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15

329: ,p_ems_attribute11_o =>ben_ems_shd.g_old_rec.ems_attribute11
330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19

Line 334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16

330: ,p_ems_attribute12_o =>ben_ems_shd.g_old_rec.ems_attribute12
331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20

Line 335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17

331: ,p_ems_attribute13_o =>ben_ems_shd.g_old_rec.ems_attribute13
332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21

Line 336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18

332: ,p_ems_attribute14_o =>ben_ems_shd.g_old_rec.ems_attribute14
333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22

Line 337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19

333: ,p_ems_attribute15_o =>ben_ems_shd.g_old_rec.ems_attribute15
334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23

Line 338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20

334: ,p_ems_attribute16_o =>ben_ems_shd.g_old_rec.ems_attribute16
335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24

Line 339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21

335: ,p_ems_attribute17_o =>ben_ems_shd.g_old_rec.ems_attribute17
336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25

Line 340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22

336: ,p_ems_attribute18_o =>ben_ems_shd.g_old_rec.ems_attribute18
337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26

Line 341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23

337: ,p_ems_attribute19_o =>ben_ems_shd.g_old_rec.ems_attribute19
338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27

Line 342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24

338: ,p_ems_attribute20_o =>ben_ems_shd.g_old_rec.ems_attribute20
339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28

Line 343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25

339: ,p_ems_attribute21_o =>ben_ems_shd.g_old_rec.ems_attribute21
340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29

Line 344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26

340: ,p_ems_attribute22_o =>ben_ems_shd.g_old_rec.ems_attribute22
341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30

Line 345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27

341: ,p_ems_attribute23_o =>ben_ems_shd.g_old_rec.ems_attribute23
342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30
349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number

Line 346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28

342: ,p_ems_attribute24_o =>ben_ems_shd.g_old_rec.ems_attribute24
343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30
349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number
350: );

Line 347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29

343: ,p_ems_attribute25_o =>ben_ems_shd.g_old_rec.ems_attribute25
344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30
349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number
350: );
351: --

Line 348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30

344: ,p_ems_attribute26_o =>ben_ems_shd.g_old_rec.ems_attribute26
345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30
349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number
350: );
351: --
352: exception

Line 349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number

345: ,p_ems_attribute27_o =>ben_ems_shd.g_old_rec.ems_attribute27
346: ,p_ems_attribute28_o =>ben_ems_shd.g_old_rec.ems_attribute28
347: ,p_ems_attribute29_o =>ben_ems_shd.g_old_rec.ems_attribute29
348: ,p_ems_attribute30_o =>ben_ems_shd.g_old_rec.ems_attribute30
349: ,p_object_version_number_o =>ben_ems_shd.g_old_rec.object_version_number
350: );
351: --
352: exception
353: --

Line 373: p_rec in out nocopy ben_ems_shd.g_rec_type,

369: -- |---------------------------------< del >----------------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure del
372: (
373: p_rec in out nocopy ben_ems_shd.g_rec_type,
374: p_effective_date in date,
375: p_datetrack_mode in varchar2
376: ) is
377: --

Line 391: ben_ems_shd.lck

387: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
388: --
389: -- We must lock the row which we need to delete.
390: --
391: ben_ems_shd.lck
392: (p_effective_date => p_effective_date,
393: p_datetrack_mode => p_datetrack_mode,
394: p_elig_mrtl_stat_cvg_id => p_rec.elig_mrtl_stat_cvg_id,
395: p_object_version_number => p_rec.object_version_number,

Line 449: l_rec ben_ems_shd.g_rec_type;

445: p_effective_date in date,
446: p_datetrack_mode in varchar2
447: ) is
448: --
449: l_rec ben_ems_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'del';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);