eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PRH_DEL dependencies on GHR_PRH_SHD

Line 45: Procedure delete_dml(p_rec in ghr_prh_shd.g_rec_type) is

41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in ghr_prh_shd.g_rec_type) is
46: --
47: l_proc varchar2(72);
48: --
49: Begin

Line 65: ghr_prh_shd.constraint_error

61: --
62: Exception
63: When hr_api.child_integrity_violated then
64: -- Child integrity has been violated
65: ghr_prh_shd.constraint_error
66: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
67: When Others Then
68: Raise;
69: End delete_dml;

Line 103: Procedure pre_delete(p_rec in ghr_prh_shd.g_rec_type) is

99: -- Internal Table Handler Use Only.
100: --
101: -- {End Of Comments}
102: -- ----------------------------------------------------------------------------
103: Procedure pre_delete(p_rec in ghr_prh_shd.g_rec_type) is
104: --
105: l_proc varchar2(72) ;
106: --
107: Begin

Line 146: Procedure post_delete(p_rec in ghr_prh_shd.g_rec_type) is

142: -- Internal table Handler Use Only.
143: --
144: -- {End Of Comments}
145: -- ----------------------------------------------------------------------------
146: Procedure post_delete(p_rec in ghr_prh_shd.g_rec_type) is
147: --
148: l_proc varchar2(72) ;
149: --
150: Begin

Line 159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,

155: --
156: begin
157: ghr_prh_rkd.after_delete (
158: p_pa_routing_history_id => p_rec.pa_routing_history_id,
159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,

Line 160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,

156: begin
157: ghr_prh_rkd.after_delete (
158: p_pa_routing_history_id => p_rec.pa_routing_history_id,
159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,

Line 161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,

157: ghr_prh_rkd.after_delete (
158: p_pa_routing_history_id => p_rec.pa_routing_history_id,
159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,

Line 162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,

158: p_pa_routing_history_id => p_rec.pa_routing_history_id,
159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,

Line 163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,

159: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,

Line 164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,

160: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,

Line 165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,

161: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,

Line 166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,

162: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,

Line 167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,

163: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,

Line 168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,

164: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,

Line 169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,

165: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,

Line 170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,

166: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,

Line 171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,

167: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,

Line 172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,

168: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,

Line 173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,

169: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>

Line 174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,

170: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,

Line 175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,

171: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,

Line 176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,

172: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
173: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,

Line 178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,

174: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,

Line 179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,

175: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>

Line 180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,

176: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>
184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,

Line 181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,

177: p_second_nature_of_action_id_o =>
178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>
184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
185: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number

Line 182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,

178: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
179: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>
184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
185: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
186: );

Line 184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,

180: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>
184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
185: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
186: );
187:
188: exception

Line 185: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number

181: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
182: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
183: p_user_name_emp_middle_names_o =>
184: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
185: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
186: );
187:
188: exception
189: when hr_api.cannot_find_prog_unit then

Line 205: p_rec in ghr_prh_shd.g_rec_type,

201: -- |---------------------------------< del >----------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure del
204: (
205: p_rec in ghr_prh_shd.g_rec_type,
206: p_validate in boolean default false
207: ) is
208: --
209: l_proc varchar2(72);

Line 226: ghr_prh_shd.lck

222: End If;
223: --
224: -- We must lock the row which we need to delete.
225: --
226: ghr_prh_shd.lck
227: (
228: p_rec.pa_routing_history_id,
229: p_rec.object_version_number
230: );

Line 274: l_rec ghr_prh_shd.g_rec_type;

270: p_object_version_number in number,
271: p_validate in boolean default false
272: ) is
273: --
274: l_rec ghr_prh_shd.g_rec_type;
275: l_proc varchar2(72) ;
276: --
277: Begin
278: l_proc := g_package||'del';