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_PDH_UPD dependencies on GHR_PDH_SHD

Line 49: Procedure update_dml(p_rec in out NOCOPY ghr_pdh_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_pdh_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'update_dml';
52: --
53: Begin

Line 90: ghr_pdh_shd.constraint_error

86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ghr_pdh_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: ghr_pdh_shd.constraint_error

Line 94: ghr_pdh_shd.constraint_error

90: ghr_pdh_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: ghr_pdh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: ghr_pdh_shd.constraint_error

Line 98: ghr_pdh_shd.constraint_error

94: ghr_pdh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: ghr_pdh_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: Raise;
102: End update_dml;

Line 136: Procedure pre_update(p_rec in ghr_pdh_shd.g_rec_type) is

132: -- Internal Table Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in ghr_pdh_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in ghr_pdh_shd.g_rec_type) is

174: -- Internal Table Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in ghr_pdh_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

Line 210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,

206: p_routing_seq_number => p_rec.routing_seq_number,
207: p_date_notification_sent => p_rec.date_notification_sent,
208: p_item_key => p_rec.item_key,
209: p_object_version_number => p_rec.object_version_number,
210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,

Line 211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,

207: p_date_notification_sent => p_rec.date_notification_sent,
208: p_item_key => p_rec.item_key,
209: p_object_version_number => p_rec.object_version_number,
210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,

Line 212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,

208: p_item_key => p_rec.item_key,
209: p_object_version_number => p_rec.object_version_number,
210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,

Line 213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,

209: p_object_version_number => p_rec.object_version_number,
210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,

Line 214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,

210: p_position_description_id_o => ghr_pdh_shd.g_old_rec.position_description_id,
211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,

Line 215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,

211: p_initiator_flag_o => ghr_pdh_shd.g_old_rec.initiator_flag,
212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,

Line 216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,

212: p_requester_flag_o => ghr_pdh_shd.g_old_rec.requester_flag,
213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,

Line 217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,

213: p_approver_flag_o => ghr_pdh_shd.g_old_rec.approver_flag,
214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,

Line 218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,

214: p_personnelist_flag_o => ghr_pdh_shd.g_old_rec.personnelist_flag,
215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,

Line 219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,

215: p_reviewer_flag_o => ghr_pdh_shd.g_old_rec.reviewer_flag,
216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,

Line 220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,

216: p_authorizer_flag_o => ghr_pdh_shd.g_old_rec.authorizer_flag,
217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,

Line 221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,

217: p_approved_flag_o => ghr_pdh_shd.g_old_rec.approved_flag,
218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,

Line 222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,

218: p_user_name_o => ghr_pdh_shd.g_old_rec.user_name,
219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,

Line 223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,

219: p_user_name_employee_id_o => ghr_pdh_shd.g_old_rec.user_name_employee_id,
220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,

Line 224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,

220: p_user_name_emp_first_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_first_name,
221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,

Line 225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,

221: p_user_name_emp_last_name_o => ghr_pdh_shd.g_old_rec.user_name_emp_last_name,
222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );

Line 226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,

222: p_user_name_emp_middle_names_o=> ghr_pdh_shd.g_old_rec.user_name_emp_middle_names,
223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
230: exception

Line 227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,

223: p_action_taken_o => ghr_pdh_shd.g_old_rec.action_taken,
224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
230: exception
231: when hr_api.cannot_find_prog_unit then

Line 228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,

224: p_groupbox_id_o => ghr_pdh_shd.g_old_rec.groupbox_id,
225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
230: exception
231: when hr_api.cannot_find_prog_unit then
232: hr_api.cannot_find_prog_unit_error

Line 229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );

225: p_routing_list_id_o => ghr_pdh_shd.g_old_rec.routing_list_id,
226: p_routing_seq_number_o => ghr_pdh_shd.g_old_rec.routing_seq_number,
227: p_date_notification_sent_o => ghr_pdh_shd.g_old_rec.date_notification_sent,
228: p_item_key_o => ghr_pdh_shd.g_old_rec.item_key,
229: p_object_version_number_o => ghr_pdh_shd.g_old_rec.object_version_number );
230: exception
231: when hr_api.cannot_find_prog_unit then
232: hr_api.cannot_find_prog_unit_error
233: ( p_module_name => 'GHR_PD_ROUTING_HISTORY'

Line 286: Procedure convert_defs(p_rec in out NOCOPY ghr_pdh_shd.g_rec_type) is

282: -- Internal Table Handler Use Only.
283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure convert_defs(p_rec in out NOCOPY ghr_pdh_shd.g_rec_type) is
287: --
288: l_proc varchar2(72) := g_package||'convert_defs';
289: --
290: Begin

Line 301: ghr_pdh_shd.g_old_rec.position_description_id;

297: -- is being used then we must set to the 'current' argument value.
298: --
299: If (p_rec.position_description_id = hr_api.g_number) then
300: p_rec.position_description_id :=
301: ghr_pdh_shd.g_old_rec.position_description_id;
302: End If;
303: -- If (p_rec.attachment_modified_flag = hr_api.g_varchar2) then
304: -- p_rec.attachment_modified_flag :=
305: -- ghr_pdh_shd.g_old_rec.attachment_modified_flag;

Line 305: -- ghr_pdh_shd.g_old_rec.attachment_modified_flag;

301: ghr_pdh_shd.g_old_rec.position_description_id;
302: End If;
303: -- If (p_rec.attachment_modified_flag = hr_api.g_varchar2) then
304: -- p_rec.attachment_modified_flag :=
305: -- ghr_pdh_shd.g_old_rec.attachment_modified_flag;
306: -- End If;
307: If (p_rec.initiator_flag = hr_api.g_varchar2) then
308: p_rec.initiator_flag :=
309: ghr_pdh_shd.g_old_rec.initiator_flag;

Line 309: ghr_pdh_shd.g_old_rec.initiator_flag;

305: -- ghr_pdh_shd.g_old_rec.attachment_modified_flag;
306: -- End If;
307: If (p_rec.initiator_flag = hr_api.g_varchar2) then
308: p_rec.initiator_flag :=
309: ghr_pdh_shd.g_old_rec.initiator_flag;
310: End If;
311: If (p_rec.requester_flag = hr_api.g_varchar2) then
312: p_rec.requester_flag :=
313: ghr_pdh_shd.g_old_rec.requester_flag;

Line 313: ghr_pdh_shd.g_old_rec.requester_flag;

309: ghr_pdh_shd.g_old_rec.initiator_flag;
310: End If;
311: If (p_rec.requester_flag = hr_api.g_varchar2) then
312: p_rec.requester_flag :=
313: ghr_pdh_shd.g_old_rec.requester_flag;
314: End If;
315: If (p_rec.approver_flag = hr_api.g_varchar2) then
316: p_rec.approver_flag :=
317: ghr_pdh_shd.g_old_rec.approver_flag;

Line 317: ghr_pdh_shd.g_old_rec.approver_flag;

313: ghr_pdh_shd.g_old_rec.requester_flag;
314: End If;
315: If (p_rec.approver_flag = hr_api.g_varchar2) then
316: p_rec.approver_flag :=
317: ghr_pdh_shd.g_old_rec.approver_flag;
318: End If;
319: If (p_rec.reviewer_flag = hr_api.g_varchar2) then
320: p_rec.reviewer_flag :=
321: ghr_pdh_shd.g_old_rec.reviewer_flag;

Line 321: ghr_pdh_shd.g_old_rec.reviewer_flag;

317: ghr_pdh_shd.g_old_rec.approver_flag;
318: End If;
319: If (p_rec.reviewer_flag = hr_api.g_varchar2) then
320: p_rec.reviewer_flag :=
321: ghr_pdh_shd.g_old_rec.reviewer_flag;
322: End If;
323: -- If (p_rec.requester_flag = hr_api.g_varchar2) then
324: -- p_rec.requester_flag :=
325: -- ghr_pdh_shd.g_old_rec.requester_flag;

Line 325: -- ghr_pdh_shd.g_old_rec.requester_flag;

321: ghr_pdh_shd.g_old_rec.reviewer_flag;
322: End If;
323: -- If (p_rec.requester_flag = hr_api.g_varchar2) then
324: -- p_rec.requester_flag :=
325: -- ghr_pdh_shd.g_old_rec.requester_flag;
326: -- End If;
327: If (p_rec.authorizer_flag = hr_api.g_varchar2) then
328: p_rec.authorizer_flag :=
329: ghr_pdh_shd.g_old_rec.authorizer_flag;

Line 329: ghr_pdh_shd.g_old_rec.authorizer_flag;

325: -- ghr_pdh_shd.g_old_rec.requester_flag;
326: -- End If;
327: If (p_rec.authorizer_flag = hr_api.g_varchar2) then
328: p_rec.authorizer_flag :=
329: ghr_pdh_shd.g_old_rec.authorizer_flag;
330: End If;
331: If (p_rec.personnelist_flag = hr_api.g_varchar2) then
332: p_rec.personnelist_flag :=
333: ghr_pdh_shd.g_old_rec.authorizer_flag;

Line 333: ghr_pdh_shd.g_old_rec.authorizer_flag;

329: ghr_pdh_shd.g_old_rec.authorizer_flag;
330: End If;
331: If (p_rec.personnelist_flag = hr_api.g_varchar2) then
332: p_rec.personnelist_flag :=
333: ghr_pdh_shd.g_old_rec.authorizer_flag;
334: End If;
335: If (p_rec.approved_flag = hr_api.g_varchar2) then
336: p_rec.approved_flag :=
337: ghr_pdh_shd.g_old_rec.approved_flag;

Line 337: ghr_pdh_shd.g_old_rec.approved_flag;

333: ghr_pdh_shd.g_old_rec.authorizer_flag;
334: End If;
335: If (p_rec.approved_flag = hr_api.g_varchar2) then
336: p_rec.approved_flag :=
337: ghr_pdh_shd.g_old_rec.approved_flag;
338: End If;
339: If (p_rec.user_name_employee_id = hr_api.g_number) then
340: p_rec.user_name_employee_id :=
341: ghr_pdh_shd.g_old_rec.user_name_employee_id;

Line 341: ghr_pdh_shd.g_old_rec.user_name_employee_id;

337: ghr_pdh_shd.g_old_rec.approved_flag;
338: End If;
339: If (p_rec.user_name_employee_id = hr_api.g_number) then
340: p_rec.user_name_employee_id :=
341: ghr_pdh_shd.g_old_rec.user_name_employee_id;
342: End If;
343: -- If (p_rec.notepad = hr_api.g_varchar2) then
344: -- p_rec.notepad :=
345: -- ghr_pdh_shd.g_old_rec.notepad;

Line 345: -- ghr_pdh_shd.g_old_rec.notepad;

341: ghr_pdh_shd.g_old_rec.user_name_employee_id;
342: End If;
343: -- If (p_rec.notepad = hr_api.g_varchar2) then
344: -- p_rec.notepad :=
345: -- ghr_pdh_shd.g_old_rec.notepad;
346: -- End If;
347: If (p_rec.action_taken = hr_api.g_varchar2) then
348: p_rec.action_taken :=
349: ghr_pdh_shd.g_old_rec.action_taken;

Line 349: ghr_pdh_shd.g_old_rec.action_taken;

345: -- ghr_pdh_shd.g_old_rec.notepad;
346: -- End If;
347: If (p_rec.action_taken = hr_api.g_varchar2) then
348: p_rec.action_taken :=
349: ghr_pdh_shd.g_old_rec.action_taken;
350: End If;
351: If (p_rec.user_name = hr_api.g_varchar2) then
352: p_rec.user_name :=
353: ghr_pdh_shd.g_old_rec.user_name;

Line 353: ghr_pdh_shd.g_old_rec.user_name;

349: ghr_pdh_shd.g_old_rec.action_taken;
350: End If;
351: If (p_rec.user_name = hr_api.g_varchar2) then
352: p_rec.user_name :=
353: ghr_pdh_shd.g_old_rec.user_name;
354: End If;
355: If (p_rec.groupbox_id = hr_api.g_number) then
356: p_rec.groupbox_id :=
357: ghr_pdh_shd.g_old_rec.groupbox_id;

Line 357: ghr_pdh_shd.g_old_rec.groupbox_id;

353: ghr_pdh_shd.g_old_rec.user_name;
354: End If;
355: If (p_rec.groupbox_id = hr_api.g_number) then
356: p_rec.groupbox_id :=
357: ghr_pdh_shd.g_old_rec.groupbox_id;
358: End If;
359: If (p_rec.routing_list_id = hr_api.g_number) then
360: p_rec.routing_list_id :=
361: ghr_pdh_shd.g_old_rec.routing_list_id;

Line 361: ghr_pdh_shd.g_old_rec.routing_list_id;

357: ghr_pdh_shd.g_old_rec.groupbox_id;
358: End If;
359: If (p_rec.routing_list_id = hr_api.g_number) then
360: p_rec.routing_list_id :=
361: ghr_pdh_shd.g_old_rec.routing_list_id;
362: End If;
363: If (p_rec.routing_seq_number = hr_api.g_number) then
364: p_rec.routing_seq_number :=
365: ghr_pdh_shd.g_old_rec.routing_seq_number;

Line 365: ghr_pdh_shd.g_old_rec.routing_seq_number;

361: ghr_pdh_shd.g_old_rec.routing_list_id;
362: End If;
363: If (p_rec.routing_seq_number = hr_api.g_number) then
364: p_rec.routing_seq_number :=
365: ghr_pdh_shd.g_old_rec.routing_seq_number;
366: End If;
367: -- If (p_rec.nature_of_action_id = hr_api.g_number) then
368: -- p_rec.nature_of_action_id :=
369: -- ghr_pdh_shd.g_old_rec.nature_of_action_id;

Line 369: -- ghr_pdh_shd.g_old_rec.nature_of_action_id;

365: ghr_pdh_shd.g_old_rec.routing_seq_number;
366: End If;
367: -- If (p_rec.nature_of_action_id = hr_api.g_number) then
368: -- p_rec.nature_of_action_id :=
369: -- ghr_pdh_shd.g_old_rec.nature_of_action_id;
370: -- End If;
371: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then
372: p_rec.user_name_emp_first_name :=
373: ghr_pdh_shd.g_old_rec.user_name_emp_first_name;

Line 373: ghr_pdh_shd.g_old_rec.user_name_emp_first_name;

369: -- ghr_pdh_shd.g_old_rec.nature_of_action_id;
370: -- End If;
371: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then
372: p_rec.user_name_emp_first_name :=
373: ghr_pdh_shd.g_old_rec.user_name_emp_first_name;
374: End If;
375: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then
376: p_rec.user_name_emp_last_name :=
377: ghr_pdh_shd.g_old_rec.user_name_emp_last_name;

Line 377: ghr_pdh_shd.g_old_rec.user_name_emp_last_name;

373: ghr_pdh_shd.g_old_rec.user_name_emp_first_name;
374: End If;
375: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then
376: p_rec.user_name_emp_last_name :=
377: ghr_pdh_shd.g_old_rec.user_name_emp_last_name;
378: End If;
379: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then
380: p_rec.user_name_emp_middle_names :=
381: ghr_pdh_shd.g_old_rec.user_name_emp_middle_names;

Line 381: ghr_pdh_shd.g_old_rec.user_name_emp_middle_names;

377: ghr_pdh_shd.g_old_rec.user_name_emp_last_name;
378: End If;
379: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then
380: p_rec.user_name_emp_middle_names :=
381: ghr_pdh_shd.g_old_rec.user_name_emp_middle_names;
382: End If;
383: If (p_rec.date_notification_sent = hr_api.g_date) then
384: p_rec.date_notification_sent :=
385: ghr_pdh_shd.g_old_rec.date_notification_sent;

Line 385: ghr_pdh_shd.g_old_rec.date_notification_sent;

381: ghr_pdh_shd.g_old_rec.user_name_emp_middle_names;
382: End If;
383: If (p_rec.date_notification_sent = hr_api.g_date) then
384: p_rec.date_notification_sent :=
385: ghr_pdh_shd.g_old_rec.date_notification_sent;
386: End If;
387: If (p_rec.item_key = hr_api.g_varchar2) then
388: p_rec.item_key :=
389: ghr_pdh_shd.g_old_rec.item_key;

Line 389: ghr_pdh_shd.g_old_rec.item_key;

385: ghr_pdh_shd.g_old_rec.date_notification_sent;
386: End If;
387: If (p_rec.item_key = hr_api.g_varchar2) then
388: p_rec.item_key :=
389: ghr_pdh_shd.g_old_rec.item_key;
390: End If;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: --

Line 401: p_rec in out NOCOPY ghr_pdh_shd.g_rec_type,

397: -- |---------------------------------< upd >----------------------------------|
398: -- ----------------------------------------------------------------------------
399: Procedure upd
400: (
401: p_rec in out NOCOPY ghr_pdh_shd.g_rec_type,
402: p_validate in boolean default false
403: ) is
404: --
405: l_proc varchar2(72) := g_package||'upd';

Line 421: ghr_pdh_shd.lck

417: End If;
418: --
419: -- We must lock the row which we need to update.
420: --
421: ghr_pdh_shd.lck
422: (
423: p_rec.pd_routing_history_id,
424: p_rec.object_version_number
425: );

Line 489: l_rec ghr_pdh_shd.g_rec_type;

485: p_item_key in varchar2 default hr_api.g_varchar2,
486: p_validate in boolean default false
487: ) is
488: --
489: l_rec ghr_pdh_shd.g_rec_type;
490: l_proc varchar2(72) := g_package||'upd';
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);

Line 499: ghr_pdh_shd.convert_args

495: -- Call conversion function to turn arguments into the
496: -- l_rec structure.
497: --
498: l_rec :=
499: ghr_pdh_shd.convert_args
500: (
501: p_pd_routing_history_id,
502: hr_api.g_number,
503: p_initiator_flag,