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_UPD dependencies on GHR_PRH_SHD

Line 49: Procedure update_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is

45: -- Internal Table Handler Use Only.
46: --
47: -- {End Of Comments}
48: -- ----------------------------------------------------------------------------
49: Procedure update_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) ;
52: l_rec ghr_prh_shd.g_rec_type;
53: --

Line 52: l_rec ghr_prh_shd.g_rec_type;

48: -- ----------------------------------------------------------------------------
49: Procedure update_dml(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) ;
52: l_rec ghr_prh_shd.g_rec_type;
53: --
54: Begin
55: l_proc := g_package||'update_dml';
56: hr_utility.set_location('Entering:'||l_proc, 5);

Line 101: ghr_prh_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: p_rec := l_rec;
101: ghr_prh_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: p_rec := l_rec;

Line 106: ghr_prh_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: p_rec := l_rec;
106: ghr_prh_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: p_rec := l_rec;

Line 111: ghr_prh_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: p_rec := l_rec;
111: ghr_prh_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: p_rec := l_rec;
115: Raise;

Line 150: Procedure pre_update(p_rec in ghr_prh_shd.g_rec_type) is

146: -- Internal Table Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_update(p_rec in ghr_prh_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) ;
153: --
154: Begin

Line 193: Procedure post_update(p_rec in ghr_prh_shd.g_rec_type) is

189: -- Internal Table Handler Use Only.
190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure post_update(p_rec in ghr_prh_shd.g_rec_type) is
194: --
195: l_proc varchar2(72);
196: --
197: Begin

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

227: p_user_name_emp_first_name => p_rec.user_name_emp_first_name,
228: p_user_name_emp_last_name => p_rec.user_name_emp_last_name,
229: p_user_name_emp_middle_names => p_rec.user_name_emp_middle_names,
230: p_object_version_number => p_rec.object_version_number,
231: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,

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

228: p_user_name_emp_last_name => p_rec.user_name_emp_last_name,
229: p_user_name_emp_middle_names => p_rec.user_name_emp_middle_names,
230: p_object_version_number => p_rec.object_version_number,
231: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,

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

229: p_user_name_emp_middle_names => p_rec.user_name_emp_middle_names,
230: p_object_version_number => p_rec.object_version_number,
231: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,

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

230: p_object_version_number => p_rec.object_version_number,
231: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,

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

231: p_pa_request_id_o => ghr_prh_shd.g_old_rec.pa_request_id,
232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,

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

232: p_action_taken_o => ghr_prh_shd.g_old_rec.action_taken,
233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,

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

233: p_approved_flag_o => ghr_prh_shd.g_old_rec.approved_flag,
234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,

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

234: p_approver_flag_o => ghr_prh_shd.g_old_rec.approver_flag,
235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,

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

235: p_approval_status_o => ghr_prh_shd.g_old_rec.approval_status,
236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,

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

236: p_attachment_modified_flag_o => ghr_prh_shd.g_old_rec.attachment_modified_flag,
237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,

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

237: p_authorizer_flag_o => ghr_prh_shd.g_old_rec.authorizer_flag,
238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,

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

238: p_date_notification_sent_o => ghr_prh_shd.g_old_rec.date_notification_sent,
239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,

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

239: p_groupbox_id_o => ghr_prh_shd.g_old_rec.groupbox_id,
240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,

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

240: p_initiator_flag_o => ghr_prh_shd.g_old_rec.initiator_flag,
241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,

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

241: p_nature_of_action_id_o => ghr_prh_shd.g_old_rec.nature_of_action_id,
242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>

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

242: p_noa_family_code_o => ghr_prh_shd.g_old_rec.noa_family_code,
243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,

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

243: p_notepad_o => ghr_prh_shd.g_old_rec.notepad,
244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,

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

244: p_personnelist_flag_o => ghr_prh_shd.g_old_rec.personnelist_flag,
245: p_requester_flag_o => ghr_prh_shd.g_old_rec.requester_flag,
246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,

Line 250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,

246: p_reviewer_flag_o => ghr_prh_shd.g_old_rec.reviewer_flag,
247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,

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

247: p_routing_list_id_o => ghr_prh_shd.g_old_rec.routing_list_id,
248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>

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

248: p_routing_seq_number_o => ghr_prh_shd.g_old_rec.routing_seq_number,
249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>
256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,

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

249: p_second_nature_of_action_id_o =>
250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>
256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
257: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number

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

250: ghr_prh_shd.g_old_rec.second_nature_of_action_id,
251: p_user_name_o => ghr_prh_shd.g_old_rec.user_name,
252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>
256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
257: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
258: );

Line 256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,

252: p_user_name_employee_id_o => ghr_prh_shd.g_old_rec.user_name_employee_id,
253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>
256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
257: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
258: );
259:
260: exception

Line 257: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number

253: p_user_name_emp_first_name_o => ghr_prh_shd.g_old_rec.user_name_emp_first_name,
254: p_user_name_emp_last_name_o => ghr_prh_shd.g_old_rec.user_name_emp_last_name,
255: p_user_name_emp_middle_names_o =>
256: ghr_prh_shd.g_old_rec.user_name_emp_middle_names,
257: p_object_version_number_o => ghr_prh_shd.g_old_rec.object_version_number
258: );
259:
260: exception
261: when hr_api.cannot_find_prog_unit then

Line 316: Procedure convert_defs(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is

312: -- Internal Table Handler Use Only.
313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure convert_defs(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
317: --
318: l_proc varchar2(72);
319: l_rec ghr_prh_shd.g_rec_type;
320: --

Line 319: l_rec ghr_prh_shd.g_rec_type;

315: -- ----------------------------------------------------------------------------
316: Procedure convert_defs(p_rec in out NOCOPY ghr_prh_shd.g_rec_type) is
317: --
318: l_proc varchar2(72);
319: l_rec ghr_prh_shd.g_rec_type;
320: --
321: Begin
322: --
323: l_proc := g_package||'convert_defs';

Line 334: ghr_prh_shd.g_old_rec.pa_request_id;

330: -- is being used then we must set to the 'current' argument value.
331: --
332: If (p_rec.pa_request_id = hr_api.g_number) then
333: p_rec.pa_request_id :=
334: ghr_prh_shd.g_old_rec.pa_request_id;
335: End If;
336: If (p_rec.attachment_modified_flag = hr_api.g_varchar2) then
337: p_rec.attachment_modified_flag :=
338: ghr_prh_shd.g_old_rec.attachment_modified_flag;

Line 338: ghr_prh_shd.g_old_rec.attachment_modified_flag;

334: ghr_prh_shd.g_old_rec.pa_request_id;
335: End If;
336: If (p_rec.attachment_modified_flag = hr_api.g_varchar2) then
337: p_rec.attachment_modified_flag :=
338: ghr_prh_shd.g_old_rec.attachment_modified_flag;
339: End If;
340: If (p_rec.initiator_flag = hr_api.g_varchar2) then
341: p_rec.initiator_flag :=
342: ghr_prh_shd.g_old_rec.initiator_flag;

Line 342: ghr_prh_shd.g_old_rec.initiator_flag;

338: ghr_prh_shd.g_old_rec.attachment_modified_flag;
339: End If;
340: If (p_rec.initiator_flag = hr_api.g_varchar2) then
341: p_rec.initiator_flag :=
342: ghr_prh_shd.g_old_rec.initiator_flag;
343: End If;
344: If (p_rec.approver_flag = hr_api.g_varchar2) then
345: p_rec.approver_flag :=
346: ghr_prh_shd.g_old_rec.approver_flag;

Line 346: ghr_prh_shd.g_old_rec.approver_flag;

342: ghr_prh_shd.g_old_rec.initiator_flag;
343: End If;
344: If (p_rec.approver_flag = hr_api.g_varchar2) then
345: p_rec.approver_flag :=
346: ghr_prh_shd.g_old_rec.approver_flag;
347: End If;
348: If (p_rec.reviewer_flag = hr_api.g_varchar2) then
349: p_rec.reviewer_flag :=
350: ghr_prh_shd.g_old_rec.reviewer_flag;

Line 350: ghr_prh_shd.g_old_rec.reviewer_flag;

346: ghr_prh_shd.g_old_rec.approver_flag;
347: End If;
348: If (p_rec.reviewer_flag = hr_api.g_varchar2) then
349: p_rec.reviewer_flag :=
350: ghr_prh_shd.g_old_rec.reviewer_flag;
351: End If;
352: If (p_rec.requester_flag = hr_api.g_varchar2) then
353: p_rec.requester_flag :=
354: ghr_prh_shd.g_old_rec.requester_flag;

Line 354: ghr_prh_shd.g_old_rec.requester_flag;

350: ghr_prh_shd.g_old_rec.reviewer_flag;
351: End If;
352: If (p_rec.requester_flag = hr_api.g_varchar2) then
353: p_rec.requester_flag :=
354: ghr_prh_shd.g_old_rec.requester_flag;
355: End If;
356: If (p_rec.authorizer_flag = hr_api.g_varchar2) then
357: p_rec.authorizer_flag :=
358: ghr_prh_shd.g_old_rec.authorizer_flag;

Line 358: ghr_prh_shd.g_old_rec.authorizer_flag;

354: ghr_prh_shd.g_old_rec.requester_flag;
355: End If;
356: If (p_rec.authorizer_flag = hr_api.g_varchar2) then
357: p_rec.authorizer_flag :=
358: ghr_prh_shd.g_old_rec.authorizer_flag;
359: End If;
360: If (p_rec.personnelist_flag = hr_api.g_varchar2) then
361: p_rec.personnelist_flag :=
362: ghr_prh_shd.g_old_rec.authorizer_flag;

Line 362: ghr_prh_shd.g_old_rec.authorizer_flag;

358: ghr_prh_shd.g_old_rec.authorizer_flag;
359: End If;
360: If (p_rec.personnelist_flag = hr_api.g_varchar2) then
361: p_rec.personnelist_flag :=
362: ghr_prh_shd.g_old_rec.authorizer_flag;
363: End If;
364: If (p_rec.approved_flag = hr_api.g_varchar2) then
365: p_rec.approved_flag :=
366: ghr_prh_shd.g_old_rec.approved_flag;

Line 366: ghr_prh_shd.g_old_rec.approved_flag;

362: ghr_prh_shd.g_old_rec.authorizer_flag;
363: End If;
364: If (p_rec.approved_flag = hr_api.g_varchar2) then
365: p_rec.approved_flag :=
366: ghr_prh_shd.g_old_rec.approved_flag;
367: End If;
368: If (p_rec.user_name_employee_id = hr_api.g_number) then
369: p_rec.user_name_employee_id :=
370: ghr_prh_shd.g_old_rec.user_name_employee_id;

Line 370: ghr_prh_shd.g_old_rec.user_name_employee_id;

366: ghr_prh_shd.g_old_rec.approved_flag;
367: End If;
368: If (p_rec.user_name_employee_id = hr_api.g_number) then
369: p_rec.user_name_employee_id :=
370: ghr_prh_shd.g_old_rec.user_name_employee_id;
371: End If;
372: If (p_rec.notepad = hr_api.g_varchar2) then
373: p_rec.notepad :=
374: ghr_prh_shd.g_old_rec.notepad;

Line 374: ghr_prh_shd.g_old_rec.notepad;

370: ghr_prh_shd.g_old_rec.user_name_employee_id;
371: End If;
372: If (p_rec.notepad = hr_api.g_varchar2) then
373: p_rec.notepad :=
374: ghr_prh_shd.g_old_rec.notepad;
375: End If;
376: If (p_rec.action_taken = hr_api.g_varchar2) then
377: p_rec.action_taken :=
378: ghr_prh_shd.g_old_rec.action_taken;

Line 378: ghr_prh_shd.g_old_rec.action_taken;

374: ghr_prh_shd.g_old_rec.notepad;
375: End If;
376: If (p_rec.action_taken = hr_api.g_varchar2) then
377: p_rec.action_taken :=
378: ghr_prh_shd.g_old_rec.action_taken;
379: End If;
380: If (p_rec.user_name = hr_api.g_varchar2) then
381: p_rec.user_name :=
382: ghr_prh_shd.g_old_rec.user_name;

Line 382: ghr_prh_shd.g_old_rec.user_name;

378: ghr_prh_shd.g_old_rec.action_taken;
379: End If;
380: If (p_rec.user_name = hr_api.g_varchar2) then
381: p_rec.user_name :=
382: ghr_prh_shd.g_old_rec.user_name;
383: End If;
384: If (p_rec.groupbox_id = hr_api.g_number) then
385: p_rec.groupbox_id :=
386: ghr_prh_shd.g_old_rec.groupbox_id;

Line 386: ghr_prh_shd.g_old_rec.groupbox_id;

382: ghr_prh_shd.g_old_rec.user_name;
383: End If;
384: If (p_rec.groupbox_id = hr_api.g_number) then
385: p_rec.groupbox_id :=
386: ghr_prh_shd.g_old_rec.groupbox_id;
387: End If;
388: If (p_rec.routing_list_id = hr_api.g_number) then
389: p_rec.routing_list_id :=
390: ghr_prh_shd.g_old_rec.routing_list_id;

Line 390: ghr_prh_shd.g_old_rec.routing_list_id;

386: ghr_prh_shd.g_old_rec.groupbox_id;
387: End If;
388: If (p_rec.routing_list_id = hr_api.g_number) then
389: p_rec.routing_list_id :=
390: ghr_prh_shd.g_old_rec.routing_list_id;
391: End If;
392: If (p_rec.routing_seq_number = hr_api.g_number) then
393: p_rec.routing_seq_number :=
394: ghr_prh_shd.g_old_rec.routing_seq_number;

Line 394: ghr_prh_shd.g_old_rec.routing_seq_number;

390: ghr_prh_shd.g_old_rec.routing_list_id;
391: End If;
392: If (p_rec.routing_seq_number = hr_api.g_number) then
393: p_rec.routing_seq_number :=
394: ghr_prh_shd.g_old_rec.routing_seq_number;
395: End If;
396: If (p_rec.noa_family_code = hr_api.g_varchar2) then
397: p_rec.noa_family_code :=
398: ghr_prh_shd.g_old_rec.noa_family_code;

Line 398: ghr_prh_shd.g_old_rec.noa_family_code;

394: ghr_prh_shd.g_old_rec.routing_seq_number;
395: End If;
396: If (p_rec.noa_family_code = hr_api.g_varchar2) then
397: p_rec.noa_family_code :=
398: ghr_prh_shd.g_old_rec.noa_family_code;
399: End If;
400: If (p_rec.nature_of_action_id = hr_api.g_number) then
401: p_rec.nature_of_action_id :=
402: ghr_prh_shd.g_old_rec.nature_of_action_id;

Line 402: ghr_prh_shd.g_old_rec.nature_of_action_id;

398: ghr_prh_shd.g_old_rec.noa_family_code;
399: End If;
400: If (p_rec.nature_of_action_id = hr_api.g_number) then
401: p_rec.nature_of_action_id :=
402: ghr_prh_shd.g_old_rec.nature_of_action_id;
403: End If;
404: If (p_rec.second_nature_of_action_id = hr_api.g_number) then
405: p_rec.second_nature_of_action_id :=
406: ghr_prh_shd.g_old_rec.second_nature_of_action_id;

Line 406: ghr_prh_shd.g_old_rec.second_nature_of_action_id;

402: ghr_prh_shd.g_old_rec.nature_of_action_id;
403: End If;
404: If (p_rec.second_nature_of_action_id = hr_api.g_number) then
405: p_rec.second_nature_of_action_id :=
406: ghr_prh_shd.g_old_rec.second_nature_of_action_id;
407: End If;
408: If (p_rec.approval_status = hr_api.g_varchar2) then
409: p_rec.approval_Status :=
410: ghr_prh_shd.g_old_rec.approval_status;

Line 410: ghr_prh_shd.g_old_rec.approval_status;

406: ghr_prh_shd.g_old_rec.second_nature_of_action_id;
407: End If;
408: If (p_rec.approval_status = hr_api.g_varchar2) then
409: p_rec.approval_Status :=
410: ghr_prh_shd.g_old_rec.approval_status;
411: End If;
412: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then
413: p_rec.user_name_emp_first_name :=
414: ghr_prh_shd.g_old_rec.user_name_emp_first_name;

Line 414: ghr_prh_shd.g_old_rec.user_name_emp_first_name;

410: ghr_prh_shd.g_old_rec.approval_status;
411: End If;
412: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then
413: p_rec.user_name_emp_first_name :=
414: ghr_prh_shd.g_old_rec.user_name_emp_first_name;
415: End If;
416: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then
417: p_rec.user_name_emp_last_name :=
418: ghr_prh_shd.g_old_rec.user_name_emp_last_name;

Line 418: ghr_prh_shd.g_old_rec.user_name_emp_last_name;

414: ghr_prh_shd.g_old_rec.user_name_emp_first_name;
415: End If;
416: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then
417: p_rec.user_name_emp_last_name :=
418: ghr_prh_shd.g_old_rec.user_name_emp_last_name;
419: End If;
420: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then
421: p_rec.user_name_emp_middle_names :=
422: ghr_prh_shd.g_old_rec.user_name_emp_middle_names;

Line 422: ghr_prh_shd.g_old_rec.user_name_emp_middle_names;

418: ghr_prh_shd.g_old_rec.user_name_emp_last_name;
419: End If;
420: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then
421: p_rec.user_name_emp_middle_names :=
422: ghr_prh_shd.g_old_rec.user_name_emp_middle_names;
423: End If;
424: If (p_rec.date_notification_sent = hr_api.g_date) then
425: p_rec.date_notification_sent :=
426: ghr_prh_shd.g_old_rec.date_notification_sent;

Line 426: ghr_prh_shd.g_old_rec.date_notification_sent;

422: ghr_prh_shd.g_old_rec.user_name_emp_middle_names;
423: End If;
424: If (p_rec.date_notification_sent = hr_api.g_date) then
425: p_rec.date_notification_sent :=
426: ghr_prh_shd.g_old_rec.date_notification_sent;
427: End If;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: --

Line 442: p_rec in out NOCOPY ghr_prh_shd.g_rec_type,

438: -- |---------------------------------< upd >----------------------------------|
439: -- ----------------------------------------------------------------------------
440: Procedure upd
441: (
442: p_rec in out NOCOPY ghr_prh_shd.g_rec_type,
443: p_validate in boolean default false
444: ) is
445: --
446: l_proc varchar2(72) ;

Line 447: l_rec ghr_prh_shd.g_rec_type;

443: p_validate in boolean default false
444: ) is
445: --
446: l_proc varchar2(72) ;
447: l_rec ghr_prh_shd.g_rec_type;
448: --
449: Begin
450: l_proc := g_package||'upd';
451: hr_utility.set_location('Entering:'||l_proc, 5);

Line 465: ghr_prh_shd.lck

461: End If;
462: --
463: -- We must lock the row which we need to update.
464: --
465: ghr_prh_shd.lck
466: (
467: p_rec.pa_routing_history_id,
468: p_rec.object_version_number
469: );

Line 543: l_rec ghr_prh_shd.g_rec_type;

539: p_object_version_number in out NOCOPY number,
540: p_validate in boolean default false
541: ) is
542: --
543: l_rec ghr_prh_shd.g_rec_type;
544: l_proc varchar2(72) ;
545: l_object_version_number NUMBER;
546: --
547: Begin

Line 556: ghr_prh_shd.convert_args

552: -- Call conversion function to turn arguments into the
553: -- l_rec structure.
554: --
555: l_rec :=
556: ghr_prh_shd.convert_args
557: (
558: p_pa_routing_history_id,
559: hr_api.g_number,
560: p_attachment_modified_flag,