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_AVA_DEL dependencies on BEN_AVA_SHD

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

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

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

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

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

83: delete from ben_actl_prem_vrbl_rt_rl_f
84: where actl_prem_vrbl_rt_rl_id = p_rec.actl_prem_vrbl_rt_rl_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_ava_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_ava_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_ava_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_ava_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_ava_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_ava_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_ava_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num

Line 310: ,p_effective_end_date_o =>ben_ava_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_ava_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd

Line 311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_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_ava_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id

Line 312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category

Line 313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num

309: ,p_effective_start_date_o =>ben_ava_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1

Line 314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd

310: ,p_effective_end_date_o =>ben_ava_shd.g_old_rec.effective_end_date
311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2

Line 315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id

311: ,p_actl_prem_id_o =>ben_ava_shd.g_old_rec.actl_prem_id
312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3

Line 316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category

312: ,p_formula_id_o =>ben_ava_shd.g_old_rec.formula_id
313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4

Line 317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1

313: ,p_ordr_to_aply_num_o =>ben_ava_shd.g_old_rec.ordr_to_aply_num
314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5

Line 318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2

314: ,p_rt_trtmt_cd_o =>ben_ava_shd.g_old_rec.rt_trtmt_cd
315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6

Line 319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3

315: ,p_business_group_id_o =>ben_ava_shd.g_old_rec.business_group_id
316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7

Line 320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4

316: ,p_ava_attribute_category_o =>ben_ava_shd.g_old_rec.ava_attribute_category
317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8

Line 321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5

317: ,p_ava_attribute1_o =>ben_ava_shd.g_old_rec.ava_attribute1
318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9

Line 322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6

318: ,p_ava_attribute2_o =>ben_ava_shd.g_old_rec.ava_attribute2
319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10

Line 323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7

319: ,p_ava_attribute3_o =>ben_ava_shd.g_old_rec.ava_attribute3
320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11

Line 324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8

320: ,p_ava_attribute4_o =>ben_ava_shd.g_old_rec.ava_attribute4
321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12

Line 325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9

321: ,p_ava_attribute5_o =>ben_ava_shd.g_old_rec.ava_attribute5
322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13

Line 326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10

322: ,p_ava_attribute6_o =>ben_ava_shd.g_old_rec.ava_attribute6
323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14

Line 327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11

323: ,p_ava_attribute7_o =>ben_ava_shd.g_old_rec.ava_attribute7
324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15

Line 328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12

324: ,p_ava_attribute8_o =>ben_ava_shd.g_old_rec.ava_attribute8
325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16

Line 329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13

325: ,p_ava_attribute9_o =>ben_ava_shd.g_old_rec.ava_attribute9
326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17

Line 330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14

326: ,p_ava_attribute10_o =>ben_ava_shd.g_old_rec.ava_attribute10
327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18

Line 331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15

327: ,p_ava_attribute11_o =>ben_ava_shd.g_old_rec.ava_attribute11
328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19

Line 332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16

328: ,p_ava_attribute12_o =>ben_ava_shd.g_old_rec.ava_attribute12
329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20

Line 333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17

329: ,p_ava_attribute13_o =>ben_ava_shd.g_old_rec.ava_attribute13
330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21

Line 334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18

330: ,p_ava_attribute14_o =>ben_ava_shd.g_old_rec.ava_attribute14
331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22

Line 335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19

331: ,p_ava_attribute15_o =>ben_ava_shd.g_old_rec.ava_attribute15
332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23

Line 336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20

332: ,p_ava_attribute16_o =>ben_ava_shd.g_old_rec.ava_attribute16
333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24

Line 337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21

333: ,p_ava_attribute17_o =>ben_ava_shd.g_old_rec.ava_attribute17
334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25

Line 338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22

334: ,p_ava_attribute18_o =>ben_ava_shd.g_old_rec.ava_attribute18
335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26

Line 339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23

335: ,p_ava_attribute19_o =>ben_ava_shd.g_old_rec.ava_attribute19
336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27

Line 340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24

336: ,p_ava_attribute20_o =>ben_ava_shd.g_old_rec.ava_attribute20
337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28

Line 341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25

337: ,p_ava_attribute21_o =>ben_ava_shd.g_old_rec.ava_attribute21
338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29

Line 342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26

338: ,p_ava_attribute22_o =>ben_ava_shd.g_old_rec.ava_attribute22
339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30

Line 343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27

339: ,p_ava_attribute23_o =>ben_ava_shd.g_old_rec.ava_attribute23
340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number

Line 344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28

340: ,p_ava_attribute24_o =>ben_ava_shd.g_old_rec.ava_attribute24
341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
348: );

Line 345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29

341: ,p_ava_attribute25_o =>ben_ava_shd.g_old_rec.ava_attribute25
342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
348: );
349: --

Line 346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30

342: ,p_ava_attribute26_o =>ben_ava_shd.g_old_rec.ava_attribute26
343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
348: );
349: --
350: exception

Line 347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number

343: ,p_ava_attribute27_o =>ben_ava_shd.g_old_rec.ava_attribute27
344: ,p_ava_attribute28_o =>ben_ava_shd.g_old_rec.ava_attribute28
345: ,p_ava_attribute29_o =>ben_ava_shd.g_old_rec.ava_attribute29
346: ,p_ava_attribute30_o =>ben_ava_shd.g_old_rec.ava_attribute30
347: ,p_object_version_number_o =>ben_ava_shd.g_old_rec.object_version_number
348: );
349: --
350: exception
351: --

Line 371: p_rec in out nocopy ben_ava_shd.g_rec_type,

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

Line 389: ben_ava_shd.lck

385: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
386: --
387: -- We must lock the row which we need to delete.
388: --
389: ben_ava_shd.lck
390: (p_effective_date => p_effective_date,
391: p_datetrack_mode => p_datetrack_mode,
392: p_actl_prem_vrbl_rt_rl_id => p_rec.actl_prem_vrbl_rt_rl_id,
393: p_object_version_number => p_rec.object_version_number,

Line 447: l_rec ben_ava_shd.g_rec_type;

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