94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
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));
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;
106: ghr_prh_shd.constraint_error
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;
106: ghr_prh_shd.constraint_error
107: (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;
111: ghr_prh_shd.constraint_error
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;
111: ghr_prh_shd.constraint_error
112: (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;
116: End update_dml;
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
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'
264: ,p_hook_type => 'AU'
265: );
258: );
259:
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'
264: ,p_hook_type => 'AU'
265: );
266: end;
328: -- p_rec plsql record structure
329: -- to see if a system default is being used. If a system default
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
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;
339: End If;
340: If (p_rec.initiator_flag = hr_api.g_varchar2) then
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;
343: End If;
344: If (p_rec.approver_flag = hr_api.g_varchar2) then
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;
347: End If;
348: If (p_rec.reviewer_flag = hr_api.g_varchar2) then
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;
351: End If;
352: If (p_rec.requester_flag = hr_api.g_varchar2) then
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;
355: End If;
356: If (p_rec.authorizer_flag = hr_api.g_varchar2) then
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;
359: End If;
360: If (p_rec.personnelist_flag = hr_api.g_varchar2) then
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;
363: End If;
364: If (p_rec.approved_flag = hr_api.g_varchar2) then
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;
367: End If;
368: If (p_rec.user_name_employee_id = hr_api.g_number) then
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;
371: End If;
372: If (p_rec.notepad = hr_api.g_varchar2) then
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;
375: End If;
376: If (p_rec.action_taken = hr_api.g_varchar2) then
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;
379: End If;
380: If (p_rec.user_name = hr_api.g_varchar2) then
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;
383: End If;
384: If (p_rec.groupbox_id = hr_api.g_number) then
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;
387: End If;
388: If (p_rec.routing_list_id = hr_api.g_number) then
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;
391: End If;
392: If (p_rec.routing_seq_number = hr_api.g_number) then
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;
395: End If;
396: If (p_rec.noa_family_code = hr_api.g_varchar2) then
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;
399: End If;
400: If (p_rec.nature_of_action_id = hr_api.g_number) then
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;
403: End If;
404: If (p_rec.second_nature_of_action_id = hr_api.g_number) then
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;
407: End If;
408: If (p_rec.approval_status = hr_api.g_varchar2) then
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;
411: End If;
412: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then
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;
415: End If;
416: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then
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;
419: End If;
420: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then
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;
423: End If;
424: If (p_rec.date_notification_sent = hr_api.g_date) then
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;
427: End If;
428: --
491: --
492: -- If we are validating then raise the Validate_Enabled exception
493: --
494: If p_validate then
495: Raise HR_Api.Validate_Enabled;
496: End If;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: Exception
496: End If;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: Exception
500: When HR_Api.Validate_Enabled Then
501: --
502: -- As the Validate_Enabled exception has been raised
503: -- we must rollback to the savepoint
504: --
514: -- ----------------------------------------------------------------------------
515: Procedure upd
516: (
517: p_pa_routing_history_id in number,
518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
515: Procedure upd
516: (
517: p_pa_routing_history_id in number,
518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
516: (
517: p_pa_routing_history_id in number,
518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
517: p_pa_routing_history_id in number,
518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
519: p_initiator_flag in varchar2 default hr_api.g_varchar2,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
520: p_approver_flag in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
521: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
522: p_requester_flag in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
523: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
524: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
525: p_approved_flag in varchar2 default hr_api.g_varchar2,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
526: p_user_name in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
527: p_user_name_employee_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
530: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
538: p_date_notification_sent in date default hr_api.g_date,
531: p_notepad in varchar2 default hr_api.g_varchar2,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
538: p_date_notification_sent in date default hr_api.g_date,
539: p_object_version_number in out NOCOPY number,
532: p_action_taken in varchar2 default hr_api.g_varchar2,
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
538: p_date_notification_sent in date default hr_api.g_date,
539: p_object_version_number in out NOCOPY number,
540: p_validate in boolean default false
533: p_groupbox_id in number default hr_api.g_number,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
538: p_date_notification_sent in date default hr_api.g_date,
539: p_object_version_number in out NOCOPY number,
540: p_validate in boolean default false
541: ) is
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,
535: p_nature_of_action_id in number default hr_api.g_number,
536: p_second_nature_of_action_id in number default hr_api.g_number,
537: p_approval_status in varchar2 default hr_api.g_varchar2,
538: p_date_notification_sent in date default hr_api.g_date,
539: p_object_version_number in out NOCOPY number,
540: p_validate in boolean default false
541: ) is
542: --
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,
561: p_initiator_flag,
562: p_approver_flag,
563: p_reviewer_flag,
572: p_user_name_emp_middle_names,
573: p_notepad,
574: p_action_taken,
575: p_groupbox_id,
576: hr_api.g_number,
577: hr_api.g_number,
578: p_noa_family_code,
579: p_nature_of_action_id,
580: p_second_nature_of_action_id,
573: p_notepad,
574: p_action_taken,
575: p_groupbox_id,
576: hr_api.g_number,
577: hr_api.g_number,
578: p_noa_family_code,
579: p_nature_of_action_id,
580: p_second_nature_of_action_id,
581: p_approval_status,