50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_cct_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
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_cct_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: --
77: delete from ben_cm_typ_f_tl
78: where cm_typ_id = p_rec.cm_typ_id
79: and effective_start_date = p_validation_start_date;
80: --
81: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
82: Else
83: hr_utility.set_location(l_proc, 15);
84: ben_cct_shd.g_api_dml := true; -- Set the api dml status
85: --
80: --
81: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
82: Else
83: hr_utility.set_location(l_proc, 15);
84: ben_cct_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Delete the row(s) where the effective start date is greater than
87: -- or equal to the validation start date.
88: --
93: delete from ben_cm_typ_f_tl
94: where cm_typ_id = p_rec.cm_typ_id
95: and effective_start_date >= p_validation_start_date;
96: --
97: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
98: End If;
99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 20);
101: --
100: hr_utility.set_location(' Leaving:'||l_proc, 20);
101: --
102: Exception
103: When Others Then
104: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End dt_delete_dml;
107: --
108: -- ----------------------------------------------------------------------------
108: -- ----------------------------------------------------------------------------
109: -- |------------------------------< delete_dml >------------------------------|
110: -- ----------------------------------------------------------------------------
111: Procedure delete_dml
112: (p_rec in out nocopy ben_cct_shd.g_rec_type,
113: p_effective_date in date,
114: p_datetrack_mode in varchar2,
115: p_validation_start_date in date,
116: p_validation_end_date in date) is
162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure dt_pre_delete
166: (p_rec in out nocopy ben_cct_shd.g_rec_type,
167: p_effective_date in date,
168: p_datetrack_mode in varchar2,
169: p_validation_start_date in date,
170: p_validation_end_date in date) is
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: If (p_datetrack_mode <> 'ZAP') then
178: --
179: p_rec.effective_start_date := ben_cct_shd.g_old_rec.effective_start_date;
180: --
181: If (p_datetrack_mode = 'DELETE') then
182: p_rec.effective_end_date := p_validation_start_date - 1;
183: Else
185: End If;
186: --
187: -- Update the current effective end date record
188: --
189: ben_cct_shd.upd_effective_end_date
190: (p_effective_date => p_effective_date,
191: p_base_key_value => p_rec.cm_typ_id,
192: p_new_effective_end_date => p_rec.effective_end_date,
193: p_validation_start_date => p_validation_start_date,
233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure pre_delete
237: (p_rec in out nocopy ben_cct_shd.g_rec_type,
238: p_effective_date in date,
239: p_datetrack_mode in varchar2,
240: p_validation_start_date in date,
241: p_validation_end_date in date) is
291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure post_delete
295: (p_rec in ben_cct_shd.g_rec_type,
296: p_effective_date in date,
297: p_datetrack_mode in varchar2,
298: p_validation_start_date in date,
299: p_validation_end_date in date) is
314: ,p_validation_start_date =>p_validation_start_date
315: ,p_validation_end_date =>p_validation_end_date
316: ,p_effective_start_date =>p_rec.effective_start_date
317: ,p_effective_end_date =>p_rec.effective_end_date
318: ,p_effective_start_date_o =>ben_cct_shd.g_old_rec.effective_start_date
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
315: ,p_validation_end_date =>p_validation_end_date
316: ,p_effective_start_date =>p_rec.effective_start_date
317: ,p_effective_end_date =>p_rec.effective_end_date
318: ,p_effective_start_date_o =>ben_cct_shd.g_old_rec.effective_start_date
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
316: ,p_effective_start_date =>p_rec.effective_start_date
317: ,p_effective_end_date =>p_rec.effective_end_date
318: ,p_effective_start_date_o =>ben_cct_shd.g_old_rec.effective_start_date
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
317: ,p_effective_end_date =>p_rec.effective_end_date
318: ,p_effective_start_date_o =>ben_cct_shd.g_old_rec.effective_start_date
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
318: ,p_effective_start_date_o =>ben_cct_shd.g_old_rec.effective_start_date
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
319: ,p_effective_end_date_o =>ben_cct_shd.g_old_rec.effective_end_date
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
320: ,p_name_o =>ben_cct_shd.g_old_rec.name
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
321: ,p_desc_txt_o =>ben_cct_shd.g_old_rec.desc_txt
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
322: ,p_cm_typ_rl_o =>ben_cct_shd.g_old_rec.cm_typ_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
323: ,p_cm_usg_cd_o =>ben_cct_shd.g_old_rec.cm_usg_cd
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
324: ,p_whnvr_trgrd_flag_o =>ben_cct_shd.g_old_rec.whnvr_trgrd_flag
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
325: ,p_shrt_name_o =>ben_cct_shd.g_old_rec.shrt_name
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
326: ,p_pc_kit_cd_o =>ben_cct_shd.g_old_rec.pc_kit_cd
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
327: ,p_trk_mlg_flag_o =>ben_cct_shd.g_old_rec.trk_mlg_flag
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
328: ,p_mx_num_avlbl_val_o =>ben_cct_shd.g_old_rec.mx_num_avlbl_val
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
329: ,p_to_be_sent_dt_cd_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_cd
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
330: ,p_to_be_sent_dt_rl_o =>ben_cct_shd.g_old_rec.to_be_sent_dt_rl
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
331: ,p_inspn_rqd_flag_o =>ben_cct_shd.g_old_rec.inspn_rqd_flag
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
332: ,p_inspn_rqd_rl_o =>ben_cct_shd.g_old_rec.inspn_rqd_rl
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
333: ,p_rcpent_cd_o =>ben_cct_shd.g_old_rec.rcpent_cd
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
334: ,p_parnt_cm_typ_id_o =>ben_cct_shd.g_old_rec.parnt_cm_typ_id
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
335: ,p_business_group_id_o =>ben_cct_shd.g_old_rec.business_group_id
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
336: ,p_cct_attribute_category_o =>ben_cct_shd.g_old_rec.cct_attribute_category
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
337: ,p_cct_attribute1_o =>ben_cct_shd.g_old_rec.cct_attribute1
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
338: ,p_cct_attribute10_o =>ben_cct_shd.g_old_rec.cct_attribute10
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
339: ,p_cct_attribute11_o =>ben_cct_shd.g_old_rec.cct_attribute11
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
340: ,p_cct_attribute12_o =>ben_cct_shd.g_old_rec.cct_attribute12
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
341: ,p_cct_attribute13_o =>ben_cct_shd.g_old_rec.cct_attribute13
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
342: ,p_cct_attribute14_o =>ben_cct_shd.g_old_rec.cct_attribute14
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
343: ,p_cct_attribute15_o =>ben_cct_shd.g_old_rec.cct_attribute15
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
344: ,p_cct_attribute16_o =>ben_cct_shd.g_old_rec.cct_attribute16
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
345: ,p_cct_attribute17_o =>ben_cct_shd.g_old_rec.cct_attribute17
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
346: ,p_cct_attribute18_o =>ben_cct_shd.g_old_rec.cct_attribute18
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
347: ,p_cct_attribute19_o =>ben_cct_shd.g_old_rec.cct_attribute19
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
348: ,p_cct_attribute2_o =>ben_cct_shd.g_old_rec.cct_attribute2
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
349: ,p_cct_attribute20_o =>ben_cct_shd.g_old_rec.cct_attribute20
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
350: ,p_cct_attribute21_o =>ben_cct_shd.g_old_rec.cct_attribute21
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
351: ,p_cct_attribute22_o =>ben_cct_shd.g_old_rec.cct_attribute22
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
352: ,p_cct_attribute23_o =>ben_cct_shd.g_old_rec.cct_attribute23
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
353: ,p_cct_attribute24_o =>ben_cct_shd.g_old_rec.cct_attribute24
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
354: ,p_cct_attribute25_o =>ben_cct_shd.g_old_rec.cct_attribute25
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
355: ,p_cct_attribute26_o =>ben_cct_shd.g_old_rec.cct_attribute26
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
356: ,p_cct_attribute27_o =>ben_cct_shd.g_old_rec.cct_attribute27
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
357: ,p_cct_attribute28_o =>ben_cct_shd.g_old_rec.cct_attribute28
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
358: ,p_cct_attribute29_o =>ben_cct_shd.g_old_rec.cct_attribute29
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
359: ,p_cct_attribute3_o =>ben_cct_shd.g_old_rec.cct_attribute3
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
367: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
360: ,p_cct_attribute30_o =>ben_cct_shd.g_old_rec.cct_attribute30
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
367: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
368: --
361: ,p_cct_attribute4_o =>ben_cct_shd.g_old_rec.cct_attribute4
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
367: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
368: --
369: exception
362: ,p_cct_attribute5_o =>ben_cct_shd.g_old_rec.cct_attribute5
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
367: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
368: --
369: exception
370: --
363: ,p_cct_attribute6_o =>ben_cct_shd.g_old_rec.cct_attribute6
364: ,p_cct_attribute7_o =>ben_cct_shd.g_old_rec.cct_attribute7
365: ,p_cct_attribute8_o =>ben_cct_shd.g_old_rec.cct_attribute8
366: ,p_cct_attribute9_o =>ben_cct_shd.g_old_rec.cct_attribute9
367: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
368: --
369: exception
370: --
371: when hr_api.cannot_find_prog_unit then
386: -- |---------------------------------< del >----------------------------------|
387: -- ----------------------------------------------------------------------------
388: Procedure del
389: (
390: p_rec in out nocopy ben_cct_shd.g_rec_type,
391: p_effective_date in date,
392: p_datetrack_mode in varchar2
393: ) is
394: --
404: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
405: --
406: -- We must lock the row which we need to delete.
407: --
408: ben_cct_shd.lck
409: (p_effective_date => p_effective_date,
410: p_datetrack_mode => p_datetrack_mode,
411: p_cm_typ_id => p_rec.cm_typ_id,
412: p_object_version_number => p_rec.object_version_number,
462: p_effective_date in date,
463: p_datetrack_mode in varchar2
464: ) is
465: --
466: l_rec ben_cct_shd.g_rec_type;
467: l_proc varchar2(72) := g_package||'del';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);