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_PRG_DEL dependencies on BEN_PRG_SHD

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

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

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

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

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

83: delete from ben_pl_regn_f
84: where pl_regn_id = p_rec.pl_regn_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_prg_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_prg_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_prg_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_prg_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_prg_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 308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date

304: ,p_validation_start_date => p_validation_start_date
305: ,p_validation_end_date => p_validation_end_date
306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date
309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id

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

305: ,p_validation_end_date => p_validation_end_date
306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date
309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id

Line 310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id

306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date
309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl

Line 311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id

307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date
309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl

Line 312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id

308: ,p_effective_end_date_o => ben_prg_shd.g_old_rec.effective_end_date
309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl

Line 313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id

309: ,p_effective_start_date_o => ben_prg_shd.g_old_rec.effective_start_date
310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl

Line 314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl

310: ,p_business_group_id_o => ben_prg_shd.g_old_rec.business_group_id
311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl

Line 315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl

311: ,p_regn_id_o => ben_prg_shd.g_old_rec.regn_id
312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd

Line 316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl

312: ,p_pl_id_o => ben_prg_shd.g_old_rec.pl_id
313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category

Line 317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl

313: ,p_rptg_grp_id_o => ben_prg_shd.g_old_rec.rptg_grp_id
314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1

Line 318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl

314: ,p_hghly_compd_det_rl_o => ben_prg_shd.g_old_rec.hghly_compd_det_rl
315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2

Line 319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd

315: ,p_key_ee_det_rl_o => ben_prg_shd.g_old_rec.key_ee_det_rl
316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3

Line 320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category

316: ,p_cntr_nndscrn_rl_o => ben_prg_shd.g_old_rec.cntr_nndscrn_rl
317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4

Line 321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1

317: ,p_cvg_nndscrn_rl_o => ben_prg_shd.g_old_rec.cvg_nndscrn_rl
318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5

Line 322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2

318: ,p_five_pct_ownr_rl_o => ben_prg_shd.g_old_rec.five_pct_ownr_rl
319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6

Line 323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3

319: ,p_regy_pl_typ_cd_o => ben_prg_shd.g_old_rec.regy_pl_typ_cd
320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7

Line 324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4

320: ,p_prg_attribute_category_o => ben_prg_shd.g_old_rec.prg_attribute_category
321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8

Line 325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5

321: ,p_prg_attribute1_o => ben_prg_shd.g_old_rec.prg_attribute1
322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9

Line 326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6

322: ,p_prg_attribute2_o => ben_prg_shd.g_old_rec.prg_attribute2
323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10

Line 327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7

323: ,p_prg_attribute3_o => ben_prg_shd.g_old_rec.prg_attribute3
324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11

Line 328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8

324: ,p_prg_attribute4_o => ben_prg_shd.g_old_rec.prg_attribute4
325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12

Line 329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9

325: ,p_prg_attribute5_o => ben_prg_shd.g_old_rec.prg_attribute5
326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13

Line 330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10

326: ,p_prg_attribute6_o => ben_prg_shd.g_old_rec.prg_attribute6
327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14

Line 331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11

327: ,p_prg_attribute7_o => ben_prg_shd.g_old_rec.prg_attribute7
328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15

Line 332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12

328: ,p_prg_attribute8_o => ben_prg_shd.g_old_rec.prg_attribute8
329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16

Line 333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13

329: ,p_prg_attribute9_o => ben_prg_shd.g_old_rec.prg_attribute9
330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17

Line 334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14

330: ,p_prg_attribute10_o => ben_prg_shd.g_old_rec.prg_attribute10
331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18

Line 335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15

331: ,p_prg_attribute11_o => ben_prg_shd.g_old_rec.prg_attribute11
332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19

Line 336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16

332: ,p_prg_attribute12_o => ben_prg_shd.g_old_rec.prg_attribute12
333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20

Line 337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17

333: ,p_prg_attribute13_o => ben_prg_shd.g_old_rec.prg_attribute13
334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21

Line 338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18

334: ,p_prg_attribute14_o => ben_prg_shd.g_old_rec.prg_attribute14
335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22

Line 339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19

335: ,p_prg_attribute15_o => ben_prg_shd.g_old_rec.prg_attribute15
336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23

Line 340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20

336: ,p_prg_attribute16_o => ben_prg_shd.g_old_rec.prg_attribute16
337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24

Line 341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21

337: ,p_prg_attribute17_o => ben_prg_shd.g_old_rec.prg_attribute17
338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25

Line 342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22

338: ,p_prg_attribute18_o => ben_prg_shd.g_old_rec.prg_attribute18
339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26

Line 343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23

339: ,p_prg_attribute19_o => ben_prg_shd.g_old_rec.prg_attribute19
340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27

Line 344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24

340: ,p_prg_attribute20_o => ben_prg_shd.g_old_rec.prg_attribute20
341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28

Line 345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25

341: ,p_prg_attribute21_o => ben_prg_shd.g_old_rec.prg_attribute21
342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29

Line 346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26

342: ,p_prg_attribute22_o => ben_prg_shd.g_old_rec.prg_attribute22
343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30

Line 347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27

343: ,p_prg_attribute23_o => ben_prg_shd.g_old_rec.prg_attribute23
344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30
351: ,p_object_version_number_o => ben_prg_shd.g_old_rec.object_version_number

Line 348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28

344: ,p_prg_attribute24_o => ben_prg_shd.g_old_rec.prg_attribute24
345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30
351: ,p_object_version_number_o => ben_prg_shd.g_old_rec.object_version_number
352: );

Line 349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29

345: ,p_prg_attribute25_o => ben_prg_shd.g_old_rec.prg_attribute25
346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30
351: ,p_object_version_number_o => ben_prg_shd.g_old_rec.object_version_number
352: );
353: --

Line 350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30

346: ,p_prg_attribute26_o => ben_prg_shd.g_old_rec.prg_attribute26
347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30
351: ,p_object_version_number_o => ben_prg_shd.g_old_rec.object_version_number
352: );
353: --
354: exception

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

347: ,p_prg_attribute27_o => ben_prg_shd.g_old_rec.prg_attribute27
348: ,p_prg_attribute28_o => ben_prg_shd.g_old_rec.prg_attribute28
349: ,p_prg_attribute29_o => ben_prg_shd.g_old_rec.prg_attribute29
350: ,p_prg_attribute30_o => ben_prg_shd.g_old_rec.prg_attribute30
351: ,p_object_version_number_o => ben_prg_shd.g_old_rec.object_version_number
352: );
353: --
354: exception
355: --

Line 374: p_rec in out nocopy ben_prg_shd.g_rec_type,

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

Line 392: ben_prg_shd.lck

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

Line 450: l_rec ben_prg_shd.g_rec_type;

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