82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pqh_crd_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: --
109: pqh_crd_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;
144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pqh_crd_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin
186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in pqh_crd_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin
203: pqh_crd_rkd.after_delete
204: (p_criteria_rate_defn_id
205: => p_rec.criteria_rate_defn_id
206: ,p_short_name_o
207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
205: => p_rec.criteria_rate_defn_id
206: ,p_short_name_o
207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number
302: );
303: --
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number
302: );
303: --
304: exception
305: --
317: -- ----------------------------------------------------------------------------
318: -- |---------------------------------< del >----------------------------------|
319: -- ----------------------------------------------------------------------------
320: Procedure del
321: (p_rec in pqh_crd_shd.g_rec_type
322: ) is
323: --
324: l_proc varchar2(72) := g_package||'del';
325: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- We must lock the row which we need to delete.
330: --
331: pqh_crd_shd.lck
332: (p_rec.criteria_rate_defn_id
333: ,p_rec.object_version_number
334: );
335: --
364: (p_criteria_rate_defn_id in number
365: ,p_object_version_number in number
366: ) is
367: --
368: l_rec pqh_crd_shd.g_rec_type;
369: l_proc varchar2(72) := g_package||'del';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);