48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ben_pty_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ben_pty_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ben_pl_pcp_typ row.
63: --
64: delete from ben_pl_pcp_typ
63: --
64: delete from ben_pl_pcp_typ
65: where pl_pcp_typ_id = p_rec.pl_pcp_typ_id;
66: --
67: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pty_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pty_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
74: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pty_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pty_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------
110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ben_pty_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin
152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in ben_pty_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin
164: ben_pty_rkd.after_delete
165: (p_pl_pcp_typ_id
166: => p_rec.pl_pcp_typ_id
167: ,p_pl_pcp_id_o
168: => ben_pty_shd.g_old_rec.pl_pcp_id
169: ,p_business_group_id_o
170: => ben_pty_shd.g_old_rec.business_group_id
171: ,p_pcp_typ_cd_o
172: => ben_pty_shd.g_old_rec.pcp_typ_cd
166: => p_rec.pl_pcp_typ_id
167: ,p_pl_pcp_id_o
168: => ben_pty_shd.g_old_rec.pl_pcp_id
169: ,p_business_group_id_o
170: => ben_pty_shd.g_old_rec.business_group_id
171: ,p_pcp_typ_cd_o
172: => ben_pty_shd.g_old_rec.pcp_typ_cd
173: ,p_min_age_o
174: => ben_pty_shd.g_old_rec.min_age
168: => ben_pty_shd.g_old_rec.pl_pcp_id
169: ,p_business_group_id_o
170: => ben_pty_shd.g_old_rec.business_group_id
171: ,p_pcp_typ_cd_o
172: => ben_pty_shd.g_old_rec.pcp_typ_cd
173: ,p_min_age_o
174: => ben_pty_shd.g_old_rec.min_age
175: ,p_max_age_o
176: => ben_pty_shd.g_old_rec.max_age
170: => ben_pty_shd.g_old_rec.business_group_id
171: ,p_pcp_typ_cd_o
172: => ben_pty_shd.g_old_rec.pcp_typ_cd
173: ,p_min_age_o
174: => ben_pty_shd.g_old_rec.min_age
175: ,p_max_age_o
176: => ben_pty_shd.g_old_rec.max_age
177: ,p_gndr_alwd_cd_o
178: => ben_pty_shd.g_old_rec.gndr_alwd_cd
172: => ben_pty_shd.g_old_rec.pcp_typ_cd
173: ,p_min_age_o
174: => ben_pty_shd.g_old_rec.min_age
175: ,p_max_age_o
176: => ben_pty_shd.g_old_rec.max_age
177: ,p_gndr_alwd_cd_o
178: => ben_pty_shd.g_old_rec.gndr_alwd_cd
179: ,p_pty_attribute_category_o
180: => ben_pty_shd.g_old_rec.pty_attribute_category
174: => ben_pty_shd.g_old_rec.min_age
175: ,p_max_age_o
176: => ben_pty_shd.g_old_rec.max_age
177: ,p_gndr_alwd_cd_o
178: => ben_pty_shd.g_old_rec.gndr_alwd_cd
179: ,p_pty_attribute_category_o
180: => ben_pty_shd.g_old_rec.pty_attribute_category
181: ,p_pty_attribute1_o
182: => ben_pty_shd.g_old_rec.pty_attribute1
176: => ben_pty_shd.g_old_rec.max_age
177: ,p_gndr_alwd_cd_o
178: => ben_pty_shd.g_old_rec.gndr_alwd_cd
179: ,p_pty_attribute_category_o
180: => ben_pty_shd.g_old_rec.pty_attribute_category
181: ,p_pty_attribute1_o
182: => ben_pty_shd.g_old_rec.pty_attribute1
183: ,p_pty_attribute2_o
184: => ben_pty_shd.g_old_rec.pty_attribute2
178: => ben_pty_shd.g_old_rec.gndr_alwd_cd
179: ,p_pty_attribute_category_o
180: => ben_pty_shd.g_old_rec.pty_attribute_category
181: ,p_pty_attribute1_o
182: => ben_pty_shd.g_old_rec.pty_attribute1
183: ,p_pty_attribute2_o
184: => ben_pty_shd.g_old_rec.pty_attribute2
185: ,p_pty_attribute3_o
186: => ben_pty_shd.g_old_rec.pty_attribute3
180: => ben_pty_shd.g_old_rec.pty_attribute_category
181: ,p_pty_attribute1_o
182: => ben_pty_shd.g_old_rec.pty_attribute1
183: ,p_pty_attribute2_o
184: => ben_pty_shd.g_old_rec.pty_attribute2
185: ,p_pty_attribute3_o
186: => ben_pty_shd.g_old_rec.pty_attribute3
187: ,p_pty_attribute4_o
188: => ben_pty_shd.g_old_rec.pty_attribute4
182: => ben_pty_shd.g_old_rec.pty_attribute1
183: ,p_pty_attribute2_o
184: => ben_pty_shd.g_old_rec.pty_attribute2
185: ,p_pty_attribute3_o
186: => ben_pty_shd.g_old_rec.pty_attribute3
187: ,p_pty_attribute4_o
188: => ben_pty_shd.g_old_rec.pty_attribute4
189: ,p_pty_attribute5_o
190: => ben_pty_shd.g_old_rec.pty_attribute5
184: => ben_pty_shd.g_old_rec.pty_attribute2
185: ,p_pty_attribute3_o
186: => ben_pty_shd.g_old_rec.pty_attribute3
187: ,p_pty_attribute4_o
188: => ben_pty_shd.g_old_rec.pty_attribute4
189: ,p_pty_attribute5_o
190: => ben_pty_shd.g_old_rec.pty_attribute5
191: ,p_pty_attribute6_o
192: => ben_pty_shd.g_old_rec.pty_attribute6
186: => ben_pty_shd.g_old_rec.pty_attribute3
187: ,p_pty_attribute4_o
188: => ben_pty_shd.g_old_rec.pty_attribute4
189: ,p_pty_attribute5_o
190: => ben_pty_shd.g_old_rec.pty_attribute5
191: ,p_pty_attribute6_o
192: => ben_pty_shd.g_old_rec.pty_attribute6
193: ,p_pty_attribute7_o
194: => ben_pty_shd.g_old_rec.pty_attribute7
188: => ben_pty_shd.g_old_rec.pty_attribute4
189: ,p_pty_attribute5_o
190: => ben_pty_shd.g_old_rec.pty_attribute5
191: ,p_pty_attribute6_o
192: => ben_pty_shd.g_old_rec.pty_attribute6
193: ,p_pty_attribute7_o
194: => ben_pty_shd.g_old_rec.pty_attribute7
195: ,p_pty_attribute8_o
196: => ben_pty_shd.g_old_rec.pty_attribute8
190: => ben_pty_shd.g_old_rec.pty_attribute5
191: ,p_pty_attribute6_o
192: => ben_pty_shd.g_old_rec.pty_attribute6
193: ,p_pty_attribute7_o
194: => ben_pty_shd.g_old_rec.pty_attribute7
195: ,p_pty_attribute8_o
196: => ben_pty_shd.g_old_rec.pty_attribute8
197: ,p_pty_attribute9_o
198: => ben_pty_shd.g_old_rec.pty_attribute9
192: => ben_pty_shd.g_old_rec.pty_attribute6
193: ,p_pty_attribute7_o
194: => ben_pty_shd.g_old_rec.pty_attribute7
195: ,p_pty_attribute8_o
196: => ben_pty_shd.g_old_rec.pty_attribute8
197: ,p_pty_attribute9_o
198: => ben_pty_shd.g_old_rec.pty_attribute9
199: ,p_pty_attribute10_o
200: => ben_pty_shd.g_old_rec.pty_attribute10
194: => ben_pty_shd.g_old_rec.pty_attribute7
195: ,p_pty_attribute8_o
196: => ben_pty_shd.g_old_rec.pty_attribute8
197: ,p_pty_attribute9_o
198: => ben_pty_shd.g_old_rec.pty_attribute9
199: ,p_pty_attribute10_o
200: => ben_pty_shd.g_old_rec.pty_attribute10
201: ,p_pty_attribute11_o
202: => ben_pty_shd.g_old_rec.pty_attribute11
196: => ben_pty_shd.g_old_rec.pty_attribute8
197: ,p_pty_attribute9_o
198: => ben_pty_shd.g_old_rec.pty_attribute9
199: ,p_pty_attribute10_o
200: => ben_pty_shd.g_old_rec.pty_attribute10
201: ,p_pty_attribute11_o
202: => ben_pty_shd.g_old_rec.pty_attribute11
203: ,p_pty_attribute12_o
204: => ben_pty_shd.g_old_rec.pty_attribute12
198: => ben_pty_shd.g_old_rec.pty_attribute9
199: ,p_pty_attribute10_o
200: => ben_pty_shd.g_old_rec.pty_attribute10
201: ,p_pty_attribute11_o
202: => ben_pty_shd.g_old_rec.pty_attribute11
203: ,p_pty_attribute12_o
204: => ben_pty_shd.g_old_rec.pty_attribute12
205: ,p_pty_attribute13_o
206: => ben_pty_shd.g_old_rec.pty_attribute13
200: => ben_pty_shd.g_old_rec.pty_attribute10
201: ,p_pty_attribute11_o
202: => ben_pty_shd.g_old_rec.pty_attribute11
203: ,p_pty_attribute12_o
204: => ben_pty_shd.g_old_rec.pty_attribute12
205: ,p_pty_attribute13_o
206: => ben_pty_shd.g_old_rec.pty_attribute13
207: ,p_pty_attribute14_o
208: => ben_pty_shd.g_old_rec.pty_attribute14
202: => ben_pty_shd.g_old_rec.pty_attribute11
203: ,p_pty_attribute12_o
204: => ben_pty_shd.g_old_rec.pty_attribute12
205: ,p_pty_attribute13_o
206: => ben_pty_shd.g_old_rec.pty_attribute13
207: ,p_pty_attribute14_o
208: => ben_pty_shd.g_old_rec.pty_attribute14
209: ,p_pty_attribute15_o
210: => ben_pty_shd.g_old_rec.pty_attribute15
204: => ben_pty_shd.g_old_rec.pty_attribute12
205: ,p_pty_attribute13_o
206: => ben_pty_shd.g_old_rec.pty_attribute13
207: ,p_pty_attribute14_o
208: => ben_pty_shd.g_old_rec.pty_attribute14
209: ,p_pty_attribute15_o
210: => ben_pty_shd.g_old_rec.pty_attribute15
211: ,p_pty_attribute16_o
212: => ben_pty_shd.g_old_rec.pty_attribute16
206: => ben_pty_shd.g_old_rec.pty_attribute13
207: ,p_pty_attribute14_o
208: => ben_pty_shd.g_old_rec.pty_attribute14
209: ,p_pty_attribute15_o
210: => ben_pty_shd.g_old_rec.pty_attribute15
211: ,p_pty_attribute16_o
212: => ben_pty_shd.g_old_rec.pty_attribute16
213: ,p_pty_attribute17_o
214: => ben_pty_shd.g_old_rec.pty_attribute17
208: => ben_pty_shd.g_old_rec.pty_attribute14
209: ,p_pty_attribute15_o
210: => ben_pty_shd.g_old_rec.pty_attribute15
211: ,p_pty_attribute16_o
212: => ben_pty_shd.g_old_rec.pty_attribute16
213: ,p_pty_attribute17_o
214: => ben_pty_shd.g_old_rec.pty_attribute17
215: ,p_pty_attribute18_o
216: => ben_pty_shd.g_old_rec.pty_attribute18
210: => ben_pty_shd.g_old_rec.pty_attribute15
211: ,p_pty_attribute16_o
212: => ben_pty_shd.g_old_rec.pty_attribute16
213: ,p_pty_attribute17_o
214: => ben_pty_shd.g_old_rec.pty_attribute17
215: ,p_pty_attribute18_o
216: => ben_pty_shd.g_old_rec.pty_attribute18
217: ,p_pty_attribute19_o
218: => ben_pty_shd.g_old_rec.pty_attribute19
212: => ben_pty_shd.g_old_rec.pty_attribute16
213: ,p_pty_attribute17_o
214: => ben_pty_shd.g_old_rec.pty_attribute17
215: ,p_pty_attribute18_o
216: => ben_pty_shd.g_old_rec.pty_attribute18
217: ,p_pty_attribute19_o
218: => ben_pty_shd.g_old_rec.pty_attribute19
219: ,p_pty_attribute20_o
220: => ben_pty_shd.g_old_rec.pty_attribute20
214: => ben_pty_shd.g_old_rec.pty_attribute17
215: ,p_pty_attribute18_o
216: => ben_pty_shd.g_old_rec.pty_attribute18
217: ,p_pty_attribute19_o
218: => ben_pty_shd.g_old_rec.pty_attribute19
219: ,p_pty_attribute20_o
220: => ben_pty_shd.g_old_rec.pty_attribute20
221: ,p_pty_attribute21_o
222: => ben_pty_shd.g_old_rec.pty_attribute21
216: => ben_pty_shd.g_old_rec.pty_attribute18
217: ,p_pty_attribute19_o
218: => ben_pty_shd.g_old_rec.pty_attribute19
219: ,p_pty_attribute20_o
220: => ben_pty_shd.g_old_rec.pty_attribute20
221: ,p_pty_attribute21_o
222: => ben_pty_shd.g_old_rec.pty_attribute21
223: ,p_pty_attribute22_o
224: => ben_pty_shd.g_old_rec.pty_attribute22
218: => ben_pty_shd.g_old_rec.pty_attribute19
219: ,p_pty_attribute20_o
220: => ben_pty_shd.g_old_rec.pty_attribute20
221: ,p_pty_attribute21_o
222: => ben_pty_shd.g_old_rec.pty_attribute21
223: ,p_pty_attribute22_o
224: => ben_pty_shd.g_old_rec.pty_attribute22
225: ,p_pty_attribute23_o
226: => ben_pty_shd.g_old_rec.pty_attribute23
220: => ben_pty_shd.g_old_rec.pty_attribute20
221: ,p_pty_attribute21_o
222: => ben_pty_shd.g_old_rec.pty_attribute21
223: ,p_pty_attribute22_o
224: => ben_pty_shd.g_old_rec.pty_attribute22
225: ,p_pty_attribute23_o
226: => ben_pty_shd.g_old_rec.pty_attribute23
227: ,p_pty_attribute24_o
228: => ben_pty_shd.g_old_rec.pty_attribute24
222: => ben_pty_shd.g_old_rec.pty_attribute21
223: ,p_pty_attribute22_o
224: => ben_pty_shd.g_old_rec.pty_attribute22
225: ,p_pty_attribute23_o
226: => ben_pty_shd.g_old_rec.pty_attribute23
227: ,p_pty_attribute24_o
228: => ben_pty_shd.g_old_rec.pty_attribute24
229: ,p_pty_attribute25_o
230: => ben_pty_shd.g_old_rec.pty_attribute25
224: => ben_pty_shd.g_old_rec.pty_attribute22
225: ,p_pty_attribute23_o
226: => ben_pty_shd.g_old_rec.pty_attribute23
227: ,p_pty_attribute24_o
228: => ben_pty_shd.g_old_rec.pty_attribute24
229: ,p_pty_attribute25_o
230: => ben_pty_shd.g_old_rec.pty_attribute25
231: ,p_pty_attribute26_o
232: => ben_pty_shd.g_old_rec.pty_attribute26
226: => ben_pty_shd.g_old_rec.pty_attribute23
227: ,p_pty_attribute24_o
228: => ben_pty_shd.g_old_rec.pty_attribute24
229: ,p_pty_attribute25_o
230: => ben_pty_shd.g_old_rec.pty_attribute25
231: ,p_pty_attribute26_o
232: => ben_pty_shd.g_old_rec.pty_attribute26
233: ,p_pty_attribute27_o
234: => ben_pty_shd.g_old_rec.pty_attribute27
228: => ben_pty_shd.g_old_rec.pty_attribute24
229: ,p_pty_attribute25_o
230: => ben_pty_shd.g_old_rec.pty_attribute25
231: ,p_pty_attribute26_o
232: => ben_pty_shd.g_old_rec.pty_attribute26
233: ,p_pty_attribute27_o
234: => ben_pty_shd.g_old_rec.pty_attribute27
235: ,p_pty_attribute28_o
236: => ben_pty_shd.g_old_rec.pty_attribute28
230: => ben_pty_shd.g_old_rec.pty_attribute25
231: ,p_pty_attribute26_o
232: => ben_pty_shd.g_old_rec.pty_attribute26
233: ,p_pty_attribute27_o
234: => ben_pty_shd.g_old_rec.pty_attribute27
235: ,p_pty_attribute28_o
236: => ben_pty_shd.g_old_rec.pty_attribute28
237: ,p_pty_attribute29_o
238: => ben_pty_shd.g_old_rec.pty_attribute29
232: => ben_pty_shd.g_old_rec.pty_attribute26
233: ,p_pty_attribute27_o
234: => ben_pty_shd.g_old_rec.pty_attribute27
235: ,p_pty_attribute28_o
236: => ben_pty_shd.g_old_rec.pty_attribute28
237: ,p_pty_attribute29_o
238: => ben_pty_shd.g_old_rec.pty_attribute29
239: ,p_pty_attribute30_o
240: => ben_pty_shd.g_old_rec.pty_attribute30
234: => ben_pty_shd.g_old_rec.pty_attribute27
235: ,p_pty_attribute28_o
236: => ben_pty_shd.g_old_rec.pty_attribute28
237: ,p_pty_attribute29_o
238: => ben_pty_shd.g_old_rec.pty_attribute29
239: ,p_pty_attribute30_o
240: => ben_pty_shd.g_old_rec.pty_attribute30
241: ,p_object_version_number_o
242: => ben_pty_shd.g_old_rec.object_version_number
236: => ben_pty_shd.g_old_rec.pty_attribute28
237: ,p_pty_attribute29_o
238: => ben_pty_shd.g_old_rec.pty_attribute29
239: ,p_pty_attribute30_o
240: => ben_pty_shd.g_old_rec.pty_attribute30
241: ,p_object_version_number_o
242: => ben_pty_shd.g_old_rec.object_version_number
243: );
244: --
238: => ben_pty_shd.g_old_rec.pty_attribute29
239: ,p_pty_attribute30_o
240: => ben_pty_shd.g_old_rec.pty_attribute30
241: ,p_object_version_number_o
242: => ben_pty_shd.g_old_rec.object_version_number
243: );
244: --
245: exception
246: --
258: -- ----------------------------------------------------------------------------
259: -- |---------------------------------< del >----------------------------------|
260: -- ----------------------------------------------------------------------------
261: Procedure del
262: (p_rec in ben_pty_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72) := g_package||'del';
266: --
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: -- We must lock the row which we need to delete.
271: --
272: ben_pty_shd.lck
273: (p_rec.pl_pcp_typ_id
274: ,p_rec.object_version_number
275: );
276: --
299: (p_pl_pcp_typ_id in number
300: ,p_object_version_number in number
301: ) is
302: --
303: l_rec ben_pty_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'del';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);