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_PRT_DEL dependencies on BEN_PRT_SHD

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

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

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

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

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

83: delete from ben_poe_rt_f
84: where poe_rt_id = p_rec.poe_rt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_prt_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_prt_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_prt_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_prt_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_prt_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_prt_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_prt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag

Line 310: ,p_effective_end_date_o =>ben_prt_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_prt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag

Line 311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num

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_prt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd

Line 312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl

Line 313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag

309: ,p_effective_start_date_o =>ben_prt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom

Line 314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag

310: ,p_effective_end_date_o =>ben_prt_shd.g_old_rec.effective_end_date
311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id

Line 315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd

311: ,p_mn_poe_num_o =>ben_prt_shd.g_old_rec.mn_poe_num
312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id

Line 316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl

312: ,p_mx_poe_num_o =>ben_prt_shd.g_old_rec.mx_poe_num
313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category

Line 317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom

313: ,p_no_mn_poe_flag_o =>ben_prt_shd.g_old_rec.no_mn_poe_flag
314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1

Line 318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id

314: ,p_no_mx_poe_flag_o =>ben_prt_shd.g_old_rec.no_mx_poe_flag
315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2

Line 319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id

315: ,p_rndg_cd_o =>ben_prt_shd.g_old_rec.rndg_cd
316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3

Line 320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category

316: ,p_rndg_rl_o =>ben_prt_shd.g_old_rec.rndg_rl
317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4

Line 321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1

317: ,p_poe_nnmntry_uom_o =>ben_prt_shd.g_old_rec.poe_nnmntry_uom
318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5

Line 322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2

318: ,p_vrbl_rt_prfl_id_o =>ben_prt_shd.g_old_rec.vrbl_rt_prfl_id
319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6

Line 323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3

319: ,p_business_group_id_o =>ben_prt_shd.g_old_rec.business_group_id
320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7

Line 324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4

320: ,p_prt_attribute_category_o =>ben_prt_shd.g_old_rec.prt_attribute_category
321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8

Line 325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5

321: ,p_prt_attribute1_o =>ben_prt_shd.g_old_rec.prt_attribute1
322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9

Line 326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6

322: ,p_prt_attribute2_o =>ben_prt_shd.g_old_rec.prt_attribute2
323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10

Line 327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7

323: ,p_prt_attribute3_o =>ben_prt_shd.g_old_rec.prt_attribute3
324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11

Line 328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8

324: ,p_prt_attribute4_o =>ben_prt_shd.g_old_rec.prt_attribute4
325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12

Line 329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9

325: ,p_prt_attribute5_o =>ben_prt_shd.g_old_rec.prt_attribute5
326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13

Line 330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10

326: ,p_prt_attribute6_o =>ben_prt_shd.g_old_rec.prt_attribute6
327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14

Line 331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11

327: ,p_prt_attribute7_o =>ben_prt_shd.g_old_rec.prt_attribute7
328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15

Line 332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12

328: ,p_prt_attribute8_o =>ben_prt_shd.g_old_rec.prt_attribute8
329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16

Line 333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13

329: ,p_prt_attribute9_o =>ben_prt_shd.g_old_rec.prt_attribute9
330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17

Line 334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14

330: ,p_prt_attribute10_o =>ben_prt_shd.g_old_rec.prt_attribute10
331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18

Line 335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15

331: ,p_prt_attribute11_o =>ben_prt_shd.g_old_rec.prt_attribute11
332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19

Line 336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16

332: ,p_prt_attribute12_o =>ben_prt_shd.g_old_rec.prt_attribute12
333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20

Line 337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17

333: ,p_prt_attribute13_o =>ben_prt_shd.g_old_rec.prt_attribute13
334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21

Line 338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18

334: ,p_prt_attribute14_o =>ben_prt_shd.g_old_rec.prt_attribute14
335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22

Line 339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19

335: ,p_prt_attribute15_o =>ben_prt_shd.g_old_rec.prt_attribute15
336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23

Line 340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20

336: ,p_prt_attribute16_o =>ben_prt_shd.g_old_rec.prt_attribute16
337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24

Line 341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21

337: ,p_prt_attribute17_o =>ben_prt_shd.g_old_rec.prt_attribute17
338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25

Line 342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22

338: ,p_prt_attribute18_o =>ben_prt_shd.g_old_rec.prt_attribute18
339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26

Line 343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23

339: ,p_prt_attribute19_o =>ben_prt_shd.g_old_rec.prt_attribute19
340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27

Line 344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24

340: ,p_prt_attribute20_o =>ben_prt_shd.g_old_rec.prt_attribute20
341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28

Line 345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25

341: ,p_prt_attribute21_o =>ben_prt_shd.g_old_rec.prt_attribute21
342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29

Line 346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26

342: ,p_prt_attribute22_o =>ben_prt_shd.g_old_rec.prt_attribute22
343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30

Line 347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27

343: ,p_prt_attribute23_o =>ben_prt_shd.g_old_rec.prt_attribute23
344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number

Line 348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28

344: ,p_prt_attribute24_o =>ben_prt_shd.g_old_rec.prt_attribute24
345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag

Line 349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29

345: ,p_prt_attribute25_o =>ben_prt_shd.g_old_rec.prt_attribute25
346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
353: );

Line 350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30

346: ,p_prt_attribute26_o =>ben_prt_shd.g_old_rec.prt_attribute26
347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
353: );
354: --

Line 351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number

347: ,p_prt_attribute27_o =>ben_prt_shd.g_old_rec.prt_attribute27
348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
353: );
354: --
355: exception

Line 352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag

348: ,p_prt_attribute28_o =>ben_prt_shd.g_old_rec.prt_attribute28
349: ,p_prt_attribute29_o =>ben_prt_shd.g_old_rec.prt_attribute29
350: ,p_prt_attribute30_o =>ben_prt_shd.g_old_rec.prt_attribute30
351: ,p_object_version_number_o =>ben_prt_shd.g_old_rec.object_version_number
352: ,p_cbr_dsblty_apls_flag_o =>ben_prt_shd.g_old_rec.cbr_dsblty_apls_flag
353: );
354: --
355: exception
356: --

Line 376: p_rec in out nocopy ben_prt_shd.g_rec_type,

372: -- |---------------------------------< del >----------------------------------|
373: -- ----------------------------------------------------------------------------
374: Procedure del
375: (
376: p_rec in out nocopy ben_prt_shd.g_rec_type,
377: p_effective_date in date,
378: p_datetrack_mode in varchar2
379: ) is
380: --

Line 394: ben_prt_shd.lck

390: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
391: --
392: -- We must lock the row which we need to delete.
393: --
394: ben_prt_shd.lck
395: (p_effective_date => p_effective_date,
396: p_datetrack_mode => p_datetrack_mode,
397: p_poe_rt_id => p_rec.poe_rt_id,
398: p_object_version_number => p_rec.object_version_number,

Line 452: l_rec ben_prt_shd.g_rec_type;

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