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_WCT_DEL dependencies on BEN_WCT_SHD

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

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

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

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

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

83: delete from ben_wv_prtn_rsn_ctfn_ptip_f
84: where wv_prtn_rsn_ctfn_ptip_id = p_rec.wv_prtn_rsn_ctfn_ptip_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_wct_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_wct_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_wct_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_wct_shd.g_rec_type,

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

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

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

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

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_wct_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_wct_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_wct_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag

Line 310: ,p_effective_end_date_o =>ben_wct_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_wct_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag

Line 311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd

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_wct_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl

Line 312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_wct_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag

Line 313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag

309: ,p_effective_start_date_o =>ben_wct_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd

Line 314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag

310: ,p_effective_end_date_o =>ben_wct_shd.g_old_rec.effective_end_date
311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id

Line 315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl

311: ,p_wv_prtn_ctfn_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd
312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category

Line 316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag

312: ,p_wv_prtn_rsn_ptip_id_o =>ben_wct_shd.g_old_rec.wv_prtn_rsn_ptip_id
313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1

Line 317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd

313: ,p_lack_ctfn_sspnd_wvr_flag_o =>ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag
314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2

Line 318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id

314: ,p_rqd_flag_o =>ben_wct_shd.g_old_rec.rqd_flag
315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3

Line 319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category

315: ,p_ctfn_rqd_when_rl_o =>ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4

Line 320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1

316: ,p_pfd_flag_o =>ben_wct_shd.g_old_rec.pfd_flag
317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5

Line 321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2

317: ,p_wv_prtn_ctfn_typ_cd_o =>ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd
318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6

Line 322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3

318: ,p_business_group_id_o =>ben_wct_shd.g_old_rec.business_group_id
319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7

Line 323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4

319: ,p_wct_attribute_category_o =>ben_wct_shd.g_old_rec.wct_attribute_category
320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8

Line 324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5

320: ,p_wct_attribute1_o =>ben_wct_shd.g_old_rec.wct_attribute1
321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9

Line 325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6

321: ,p_wct_attribute2_o =>ben_wct_shd.g_old_rec.wct_attribute2
322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10

Line 326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7

322: ,p_wct_attribute3_o =>ben_wct_shd.g_old_rec.wct_attribute3
323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11

Line 327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8

323: ,p_wct_attribute4_o =>ben_wct_shd.g_old_rec.wct_attribute4
324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12

Line 328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9

324: ,p_wct_attribute5_o =>ben_wct_shd.g_old_rec.wct_attribute5
325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13

Line 329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10

325: ,p_wct_attribute6_o =>ben_wct_shd.g_old_rec.wct_attribute6
326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14

Line 330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11

326: ,p_wct_attribute7_o =>ben_wct_shd.g_old_rec.wct_attribute7
327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15

Line 331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12

327: ,p_wct_attribute8_o =>ben_wct_shd.g_old_rec.wct_attribute8
328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16

Line 332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13

328: ,p_wct_attribute9_o =>ben_wct_shd.g_old_rec.wct_attribute9
329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17

Line 333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14

329: ,p_wct_attribute10_o =>ben_wct_shd.g_old_rec.wct_attribute10
330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18

Line 334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15

330: ,p_wct_attribute11_o =>ben_wct_shd.g_old_rec.wct_attribute11
331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19

Line 335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16

331: ,p_wct_attribute12_o =>ben_wct_shd.g_old_rec.wct_attribute12
332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20

Line 336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17

332: ,p_wct_attribute13_o =>ben_wct_shd.g_old_rec.wct_attribute13
333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21

Line 337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18

333: ,p_wct_attribute14_o =>ben_wct_shd.g_old_rec.wct_attribute14
334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22

Line 338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19

334: ,p_wct_attribute15_o =>ben_wct_shd.g_old_rec.wct_attribute15
335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23

Line 339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20

335: ,p_wct_attribute16_o =>ben_wct_shd.g_old_rec.wct_attribute16
336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24

Line 340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21

336: ,p_wct_attribute17_o =>ben_wct_shd.g_old_rec.wct_attribute17
337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25

Line 341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22

337: ,p_wct_attribute18_o =>ben_wct_shd.g_old_rec.wct_attribute18
338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26

Line 342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23

338: ,p_wct_attribute19_o =>ben_wct_shd.g_old_rec.wct_attribute19
339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27

Line 343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24

339: ,p_wct_attribute20_o =>ben_wct_shd.g_old_rec.wct_attribute20
340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28

Line 344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25

340: ,p_wct_attribute21_o =>ben_wct_shd.g_old_rec.wct_attribute21
341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29

Line 345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26

341: ,p_wct_attribute22_o =>ben_wct_shd.g_old_rec.wct_attribute22
342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30

Line 346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27

342: ,p_wct_attribute23_o =>ben_wct_shd.g_old_rec.wct_attribute23
343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30
350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number

Line 347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28

343: ,p_wct_attribute24_o =>ben_wct_shd.g_old_rec.wct_attribute24
344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30
350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number
351: );

Line 348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29

344: ,p_wct_attribute25_o =>ben_wct_shd.g_old_rec.wct_attribute25
345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30
350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number
351: );
352: --

Line 349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30

345: ,p_wct_attribute26_o =>ben_wct_shd.g_old_rec.wct_attribute26
346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30
350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number
351: );
352: --
353: exception

Line 350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number

346: ,p_wct_attribute27_o =>ben_wct_shd.g_old_rec.wct_attribute27
347: ,p_wct_attribute28_o =>ben_wct_shd.g_old_rec.wct_attribute28
348: ,p_wct_attribute29_o =>ben_wct_shd.g_old_rec.wct_attribute29
349: ,p_wct_attribute30_o =>ben_wct_shd.g_old_rec.wct_attribute30
350: ,p_object_version_number_o =>ben_wct_shd.g_old_rec.object_version_number
351: );
352: --
353: exception
354: --

Line 374: p_rec in out nocopy ben_wct_shd.g_rec_type,

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

Line 392: ben_wct_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_wct_shd.lck
393: (p_effective_date => p_effective_date,
394: p_datetrack_mode => p_datetrack_mode,
395: p_wv_prtn_rsn_ctfn_ptip_id => p_rec.wv_prtn_rsn_ctfn_ptip_id,
396: p_object_version_number => p_rec.object_version_number,

Line 450: l_rec ben_wct_shd.g_rec_type;

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