48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pqh_rap_shd.g_rec_type
53: ) is
54: --
55: l_proc constant varchar2(72):= g_package||'delete_dml';
56: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: pqh_rap_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in pqh_rap_shd.g_rec_type) is
116: --
117: l_proc constant varchar2(72):= g_package||'pre_delete';
118: --
119: Begin
154: -- Internal Row Handler Use Only.
155: --
156: -- {End Of Comments}
157: -- -----------------------------------------------------------------------------
158: Procedure post_delete(p_rec in pqh_rap_shd.g_rec_type) is
159: --
160: l_proc constant varchar2(72):= g_package||'post_delete';
161: --
162: Begin
167: pqh_rap_rkd.after_delete
168: (p_rank_process_approval_id
169: => p_rec.rank_process_approval_id
170: ,p_rank_process_id_o
171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
169: => p_rec.rank_process_approval_id
170: ,p_rank_process_id_o
171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number
184: );
185: --
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number
184: );
185: --
186: exception
187: --
199: -- ----------------------------------------------------------------------------
200: -- |---------------------------------< del >----------------------------------|
201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (p_rec in pqh_rap_shd.g_rec_type
204: ) is
205: --
206: l_proc constant varchar2(72):= g_package||'del';
207: --
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqh_rap_shd.lck
215: (p_rec.rank_process_approval_id
216: ,p_rec.object_version_number
217: );
218: --
247: (p_rank_process_approval_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec pqh_rap_shd.g_rec_type;
252: l_proc constant varchar2(72):= g_package||'del';
253: --
254: Begin
255: