APPS.GHR_PDH_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
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

Line 91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 92: When hr_api.parent_integrity_violated Then

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
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then

Line 95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: When hr_api.unique_integrity_violated Then

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
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 231: when hr_api.cannot_find_prog_unit then

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'
234: ,p_hook_type => 'AU'
235: );

Line 232: hr_api.cannot_find_prog_unit_error

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'
234: ,p_hook_type => 'AU'
235: );
236: end;

Line 299: If (p_rec.position_description_id = hr_api.g_number) then

295: -- p_rec plsql record structure
296: -- to see if a system default is being used. If a system default
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

Line 303: -- If (p_rec.attachment_modified_flag = hr_api.g_varchar2) then

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;
306: -- End If;
307: If (p_rec.initiator_flag = hr_api.g_varchar2) then

Line 307: If (p_rec.initiator_flag = hr_api.g_varchar2) then

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;
310: End If;
311: If (p_rec.requester_flag = hr_api.g_varchar2) then

Line 311: If (p_rec.requester_flag = hr_api.g_varchar2) then

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;
314: End If;
315: If (p_rec.approver_flag = hr_api.g_varchar2) then

Line 315: If (p_rec.approver_flag = hr_api.g_varchar2) then

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;
318: End If;
319: If (p_rec.reviewer_flag = hr_api.g_varchar2) then

Line 319: If (p_rec.reviewer_flag = hr_api.g_varchar2) then

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;
322: End If;
323: -- If (p_rec.requester_flag = hr_api.g_varchar2) then

Line 323: -- If (p_rec.requester_flag = hr_api.g_varchar2) then

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;
326: -- End If;
327: If (p_rec.authorizer_flag = hr_api.g_varchar2) then

Line 327: If (p_rec.authorizer_flag = hr_api.g_varchar2) then

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;
330: End If;
331: If (p_rec.personnelist_flag = hr_api.g_varchar2) then

Line 331: If (p_rec.personnelist_flag = hr_api.g_varchar2) then

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;
334: End If;
335: If (p_rec.approved_flag = hr_api.g_varchar2) then

Line 335: If (p_rec.approved_flag = hr_api.g_varchar2) then

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;
338: End If;
339: If (p_rec.user_name_employee_id = hr_api.g_number) then

Line 339: If (p_rec.user_name_employee_id = hr_api.g_number) then

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;
342: End If;
343: -- If (p_rec.notepad = hr_api.g_varchar2) then

Line 343: -- If (p_rec.notepad = hr_api.g_varchar2) then

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;
346: -- End If;
347: If (p_rec.action_taken = hr_api.g_varchar2) then

Line 347: If (p_rec.action_taken = hr_api.g_varchar2) then

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;
350: End If;
351: If (p_rec.user_name = hr_api.g_varchar2) then

Line 351: If (p_rec.user_name = hr_api.g_varchar2) then

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;
354: End If;
355: If (p_rec.groupbox_id = hr_api.g_number) then

Line 355: If (p_rec.groupbox_id = hr_api.g_number) then

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;
358: End If;
359: If (p_rec.routing_list_id = hr_api.g_number) then

Line 359: If (p_rec.routing_list_id = hr_api.g_number) then

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;
362: End If;
363: If (p_rec.routing_seq_number = hr_api.g_number) then

Line 363: If (p_rec.routing_seq_number = hr_api.g_number) then

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;
366: End If;
367: -- If (p_rec.nature_of_action_id = hr_api.g_number) then

Line 367: -- If (p_rec.nature_of_action_id = hr_api.g_number) then

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;
370: -- End If;
371: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then

Line 371: If (p_rec.user_name_emp_first_name = hr_api.g_varchar2) then

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;
374: End If;
375: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then

Line 375: If (p_rec.user_name_emp_last_name = hr_api.g_varchar2) then

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;
378: End If;
379: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then

Line 379: If (p_rec.user_name_emp_middle_names = hr_api.g_varchar2) then

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;
382: End If;
383: If (p_rec.date_notification_sent = hr_api.g_date) then

Line 383: If (p_rec.date_notification_sent = hr_api.g_date) then

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;
386: End If;
387: If (p_rec.item_key = hr_api.g_varchar2) then

Line 387: If (p_rec.item_key = hr_api.g_varchar2) then

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;
390: End If;
391: --

Line 451: Raise HR_Api.Validate_Enabled;

447: --
448: -- If we are validating then raise the Validate_Enabled exception
449: --
450: If p_validate then
451: Raise HR_Api.Validate_Enabled;
452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception

Line 456: When HR_Api.Validate_Enabled Then

452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception
456: When HR_Api.Validate_Enabled Then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --

Line 470: p_initiator_flag in varchar2 default hr_api.g_varchar2,

466: -- ----------------------------------------------------------------------------
467: Procedure upd
468: (
469: p_pd_routing_history_id in number,
470: p_initiator_flag in varchar2 default hr_api.g_varchar2,
471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,

Line 471: p_requester_flag in varchar2 default hr_api.g_varchar2,

467: Procedure upd
468: (
469: p_pd_routing_history_id in number,
470: p_initiator_flag in varchar2 default hr_api.g_varchar2,
471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,

Line 472: p_approver_flag in varchar2 default hr_api.g_varchar2,

468: (
469: p_pd_routing_history_id in number,
470: p_initiator_flag in varchar2 default hr_api.g_varchar2,
471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,

Line 473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,

469: p_pd_routing_history_id in number,
470: p_initiator_flag in varchar2 default hr_api.g_varchar2,
471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,

Line 474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,

470: p_initiator_flag in varchar2 default hr_api.g_varchar2,
471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,

Line 475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,

471: p_requester_flag in varchar2 default hr_api.g_varchar2,
472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,

Line 476: p_approved_flag in varchar2 default hr_api.g_varchar2,

472: p_approver_flag in varchar2 default hr_api.g_varchar2,
473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,

Line 477: p_user_name in varchar2 default hr_api.g_varchar2,

473: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,

Line 478: p_user_name_employee_id in number default hr_api.g_number,

474: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,

Line 479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,

475: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,

Line 480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,

476: p_approved_flag in varchar2 default hr_api.g_varchar2,
477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,
484: p_object_version_number in out NOCOPY number,

Line 481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,

477: p_user_name in varchar2 default hr_api.g_varchar2,
478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,
484: p_object_version_number in out NOCOPY number,
485: p_item_key in varchar2 default hr_api.g_varchar2,

Line 482: p_action_taken in varchar2 default hr_api.g_varchar2,

478: p_user_name_employee_id in number default hr_api.g_number,
479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,
484: p_object_version_number in out NOCOPY number,
485: p_item_key in varchar2 default hr_api.g_varchar2,
486: p_validate in boolean default false

Line 483: p_date_notification_sent in date default hr_api.g_date,

479: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
480: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,
484: p_object_version_number in out NOCOPY number,
485: p_item_key in varchar2 default hr_api.g_varchar2,
486: p_validate in boolean default false
487: ) is

Line 485: p_item_key in varchar2 default hr_api.g_varchar2,

481: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
482: p_action_taken in varchar2 default hr_api.g_varchar2,
483: p_date_notification_sent in date default hr_api.g_date,
484: p_object_version_number in out NOCOPY number,
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;

Line 502: hr_api.g_number,

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,
504: p_requester_flag,
505: p_approver_flag,
506: p_reviewer_flag,

Line 516: hr_api.g_number,

512: p_user_name_emp_first_name,
513: p_user_name_emp_last_name,
514: p_user_name_emp_middle_names,
515: p_action_taken,
516: hr_api.g_number,
517: hr_api.g_number,
518: hr_api.g_number,
519: p_date_notification_sent,
520: p_object_version_number ,

Line 517: hr_api.g_number,

513: p_user_name_emp_last_name,
514: p_user_name_emp_middle_names,
515: p_action_taken,
516: hr_api.g_number,
517: hr_api.g_number,
518: hr_api.g_number,
519: p_date_notification_sent,
520: p_object_version_number ,
521: p_item_key

Line 518: hr_api.g_number,

514: p_user_name_emp_middle_names,
515: p_action_taken,
516: hr_api.g_number,
517: hr_api.g_number,
518: hr_api.g_number,
519: p_date_notification_sent,
520: p_object_version_number ,
521: p_item_key
522: );