47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_crt_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_crt_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_crt_ordr row.
61: --
62: delete from ben_crt_ordr
61: --
62: delete from ben_crt_ordr
63: where crt_ordr_id = p_rec.crt_ordr_id;
64: --
65: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crt_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_crt_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_crt_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_crt_rkd.after_delete
168: (
169: p_crt_ordr_id =>p_rec.crt_ordr_id
170: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
167: ben_crt_rkd.after_delete
168: (
169: p_crt_ordr_id =>p_rec.crt_ordr_id
170: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
168: (
169: p_crt_ordr_id =>p_rec.crt_ordr_id
170: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
169: p_crt_ordr_id =>p_rec.crt_ordr_id
170: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
170: ,p_crt_ordr_typ_cd_o =>ben_crt_shd.g_old_rec.crt_ordr_typ_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
171: ,p_apls_perd_endg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_endg_dt
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
172: ,p_apls_perd_strtg_dt_o =>ben_crt_shd.g_old_rec.apls_perd_strtg_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
173: ,p_crt_ident_o =>ben_crt_shd.g_old_rec.crt_ident
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
174: ,p_description_o =>ben_crt_shd.g_old_rec.description
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
175: ,p_detd_qlfd_ordr_dt_o =>ben_crt_shd.g_old_rec.detd_qlfd_ordr_dt
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
176: ,p_issue_dt_o =>ben_crt_shd.g_old_rec.issue_dt
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
177: ,p_qdro_amt_o =>ben_crt_shd.g_old_rec.qdro_amt
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
178: ,p_qdro_dstr_mthd_cd_o =>ben_crt_shd.g_old_rec.qdro_dstr_mthd_cd
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
179: ,p_qdro_pct_o =>ben_crt_shd.g_old_rec.qdro_pct
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
180: ,p_rcvd_dt_o =>ben_crt_shd.g_old_rec.rcvd_dt
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
181: ,p_uom_o =>ben_crt_shd.g_old_rec.uom
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
182: ,p_crt_issng_o =>ben_crt_shd.g_old_rec.crt_issng
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
183: ,p_pl_id_o =>ben_crt_shd.g_old_rec.pl_id
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
184: ,p_person_id_o =>ben_crt_shd.g_old_rec.person_id
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
185: ,p_business_group_id_o =>ben_crt_shd.g_old_rec.business_group_id
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
186: ,p_crt_attribute_category_o =>ben_crt_shd.g_old_rec.crt_attribute_category
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
187: ,p_crt_attribute1_o =>ben_crt_shd.g_old_rec.crt_attribute1
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
188: ,p_crt_attribute2_o =>ben_crt_shd.g_old_rec.crt_attribute2
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
189: ,p_crt_attribute3_o =>ben_crt_shd.g_old_rec.crt_attribute3
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
190: ,p_crt_attribute4_o =>ben_crt_shd.g_old_rec.crt_attribute4
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
191: ,p_crt_attribute5_o =>ben_crt_shd.g_old_rec.crt_attribute5
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
192: ,p_crt_attribute6_o =>ben_crt_shd.g_old_rec.crt_attribute6
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
193: ,p_crt_attribute7_o =>ben_crt_shd.g_old_rec.crt_attribute7
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
194: ,p_crt_attribute8_o =>ben_crt_shd.g_old_rec.crt_attribute8
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
195: ,p_crt_attribute9_o =>ben_crt_shd.g_old_rec.crt_attribute9
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
196: ,p_crt_attribute10_o =>ben_crt_shd.g_old_rec.crt_attribute10
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
197: ,p_crt_attribute11_o =>ben_crt_shd.g_old_rec.crt_attribute11
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
198: ,p_crt_attribute12_o =>ben_crt_shd.g_old_rec.crt_attribute12
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
199: ,p_crt_attribute13_o =>ben_crt_shd.g_old_rec.crt_attribute13
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
200: ,p_crt_attribute14_o =>ben_crt_shd.g_old_rec.crt_attribute14
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
201: ,p_crt_attribute15_o =>ben_crt_shd.g_old_rec.crt_attribute15
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
202: ,p_crt_attribute16_o =>ben_crt_shd.g_old_rec.crt_attribute16
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
203: ,p_crt_attribute17_o =>ben_crt_shd.g_old_rec.crt_attribute17
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
204: ,p_crt_attribute18_o =>ben_crt_shd.g_old_rec.crt_attribute18
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
205: ,p_crt_attribute19_o =>ben_crt_shd.g_old_rec.crt_attribute19
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
206: ,p_crt_attribute20_o =>ben_crt_shd.g_old_rec.crt_attribute20
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
207: ,p_crt_attribute21_o =>ben_crt_shd.g_old_rec.crt_attribute21
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
208: ,p_crt_attribute22_o =>ben_crt_shd.g_old_rec.crt_attribute22
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
209: ,p_crt_attribute23_o =>ben_crt_shd.g_old_rec.crt_attribute23
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
210: ,p_crt_attribute24_o =>ben_crt_shd.g_old_rec.crt_attribute24
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
211: ,p_crt_attribute25_o =>ben_crt_shd.g_old_rec.crt_attribute25
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
212: ,p_crt_attribute26_o =>ben_crt_shd.g_old_rec.crt_attribute26
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
220: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
213: ,p_crt_attribute27_o =>ben_crt_shd.g_old_rec.crt_attribute27
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
220: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
221: );
214: ,p_crt_attribute28_o =>ben_crt_shd.g_old_rec.crt_attribute28
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
220: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
221: );
222: --
215: ,p_crt_attribute29_o =>ben_crt_shd.g_old_rec.crt_attribute29
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
220: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
221: );
222: --
223: exception
216: ,p_crt_attribute30_o =>ben_crt_shd.g_old_rec.crt_attribute30
217: ,p_object_version_number_o =>ben_crt_shd.g_old_rec.object_version_number
218: ,p_qdro_num_pymt_val_o =>ben_crt_shd.g_old_rec.qdro_num_pymt_val
219: ,p_qdro_per_perd_cd_o =>ben_crt_shd.g_old_rec.qdro_per_perd_cd
220: ,p_pl_typ_id_o =>ben_crt_shd.g_old_rec.pl_typ_id
221: );
222: --
223: exception
224: --
241: -- ----------------------------------------------------------------------------
242: Procedure del
243: (
244: p_effective_date in date,
245: p_rec in ben_crt_shd.g_rec_type
246: ) is
247: --
248: l_proc varchar2(72) := g_package||'del';
249: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- We must lock the row which we need to delete.
254: --
255: ben_crt_shd.lck
256: (
257: p_rec.crt_ordr_id,
258: p_rec.object_version_number
259: );
286: p_crt_ordr_id in number,
287: p_object_version_number in number
288: ) is
289: --
290: l_rec ben_crt_shd.g_rec_type;
291: l_proc varchar2(72) := g_package||'del';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);