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_PYD_DEL dependencies on BEN_PYD_SHD

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

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

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

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

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

83: delete from ben_ptip_dpnt_cvg_ctfn_f
84: where ptip_dpnt_cvg_ctfn_id = p_rec.ptip_dpnt_cvg_ctfn_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_pyd_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_pyd_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_pyd_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_pyd_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pyd_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_pyd_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_pyd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag

Line 310: ,p_effective_end_date_o =>ben_pyd_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_pyd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>

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

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

Line 312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl

Line 313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag

309: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd

Line 315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag

311: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag

Line 316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl

312: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category

Line 317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd

313: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1

Line 318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd

314: ,p_lack_ctfn_sspnd_enrt_flag_o =>
315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2

Line 319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag

315: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3

Line 320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category

316: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4

Line 321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1

317: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5

Line 322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2

318: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6

Line 323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3

319: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7

Line 324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4

320: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8

Line 325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5

321: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9

Line 326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6

322: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10

Line 327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7

323: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11

Line 328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8

324: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12

Line 329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9

325: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13

Line 330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10

326: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14

Line 331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11

327: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15

Line 332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12

328: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16

Line 333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13

329: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17

Line 334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14

330: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18

Line 335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15

331: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19

Line 336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16

332: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20

Line 337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17

333: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21

Line 338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18

334: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22

Line 339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19

335: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23

Line 340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20

336: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24

Line 341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21

337: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25

Line 342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22

338: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26

Line 343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23

339: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27

Line 344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24

340: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28

Line 345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25

341: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29

Line 346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26

342: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30

Line 347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27

343: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
351: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number

Line 348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28

344: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
351: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
352: );

Line 349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29

345: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
351: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
352: );
353: --

Line 350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30

346: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
351: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
352: );
353: --
354: exception

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

347: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
348: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
349: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
350: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
351: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
352: );
353: --
354: exception
355: --

Line 375: p_rec in out nocopy ben_pyd_shd.g_rec_type,

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

Line 393: ben_pyd_shd.lck

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

Line 451: l_rec ben_pyd_shd.g_rec_type;

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