41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in ghr_pdh_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: ghr_pdh_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;
98: -- Internal Table Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in ghr_pdh_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin
140: -- Internal table Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(p_rec in ghr_pdh_shd.g_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'post_delete';
147: --
148: Begin
152: --
153: begin
154: ghr_pdh_rkd.after_delete (
155: p_pd_routing_history_id => p_rec.pd_routing_history_id,
156: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
153: begin
154: ghr_pdh_rkd.after_delete (
155: p_pd_routing_history_id => p_rec.pd_routing_history_id,
156: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
154: ghr_pdh_rkd.after_delete (
155: p_pd_routing_history_id => p_rec.pd_routing_history_id,
156: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
155: p_pd_routing_history_id => p_rec.pd_routing_history_id,
156: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
156: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
157: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
158: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
159: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
160: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
161: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
162: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
163: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
164: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
165: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
166: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
167: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
175: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
168: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
175: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
176:
169: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
175: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
176:
177: exception
170: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
175: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
176:
177: exception
178: when hr_api.cannot_find_prog_unit then
171: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
172: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
173: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
174: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
175: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
176:
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
189: -- |---------------------------------< del >----------------------------------|
190: -- ----------------------------------------------------------------------------
191: Procedure del
192: (
193: p_rec in ghr_pdh_shd.g_rec_type,
194: p_validate in boolean default false
195: ) is
196: --
197: l_proc varchar2(72) := g_package||'del';
209: End If;
210: --
211: -- We must lock the row which we need to delete.
212: --
213: ghr_pdh_shd.lck
214: (
215: p_rec.pd_routing_history_id,
216: p_rec.object_version_number
217: );
257: p_object_version_number in number,
258: p_validate in boolean default false
259: ) is
260: --
261: l_rec ghr_pdh_shd.g_rec_type;
262: l_proc varchar2(72) := g_package||'del';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);