APPS.GHR_PRH_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

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));

Line 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

Line 103: When hr_api.parent_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
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 108: When hr_api.unique_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
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 261: when hr_api.cannot_find_prog_unit then

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: );

Line 262: hr_api.cannot_find_prog_unit_error

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;

Line 332: If (p_rec.pa_request_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 495: Raise HR_Api.Validate_Enabled;

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

Line 500: When HR_Api.Validate_Enabled Then

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: --

Line 518: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

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,

Line 519: p_initiator_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,

Line 520: p_approver_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,

Line 521: p_reviewer_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,

Line 522: p_requester_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,

Line 523: p_authorizer_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,
527: p_user_name_employee_id in number default hr_api.g_number,

Line 524: p_personnelist_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,
528: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,

Line 525: p_approved_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,
529: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,

Line 526: p_user_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,

Line 527: p_user_name_employee_id in number default hr_api.g_number,

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,

Line 528: p_user_name_emp_first_name 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,

Line 529: p_user_name_emp_last_name 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,

Line 530: p_user_name_emp_middle_names 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,
534: p_noa_family_code in varchar2 default hr_api.g_varchar2,

Line 531: p_notepad 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,

Line 532: p_action_taken in varchar2 default hr_api.g_varchar2,

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,

Line 533: p_groupbox_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,

Line 534: p_noa_family_code 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,

Line 535: p_nature_of_action_id in number default hr_api.g_number,

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,

Line 536: p_second_nature_of_action_id in number default hr_api.g_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

Line 537: p_approval_status 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
541: ) is

Line 538: p_date_notification_sent in date default hr_api.g_date,

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: --

Line 559: hr_api.g_number,

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,

Line 576: hr_api.g_number,

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,

Line 577: hr_api.g_number,

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,