psi_mmobile

Untitled

Jun 25th, 2026
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. -- procedure itself in p_person_history
  2. procedure create_person_status_change_history(p_person_id in number,
  3. p_gui_user_id in number,
  4. p_person_status_id in number,
  5. p_system_comment in varchar2)
  6. is
  7. v_event_date date;
  8. begin
  9. v_event_date := toUTCDate(sysdate, 'Europe/Brussels');
  10.  
  11. insert into PERSON_HISTORY (PERSON_HISTORY_ID, PERSON_ID, EVENT_DATE, GUI_USER_ID, PERSON_HISTORY_EVENT_TYPE_ID, SYSTEM_COMMENT)
  12. values(seq_person_history_id.nextval, p_person_id, v_event_date, p_gui_user_id, decode(p_person_status_id, 0, 1013, 1014), p_system_comment);
  13. commit;
  14. P_PERSON_DATA.create_person_history_person_data(seq_person_history_id.currval);
  15. end create_person_status_change_history;
  16.  
  17. -- addition to update_person
  18. ...
  19. vg_proc_name := 'UPDATE_PERSON';
  20. vg_step := 40;
  21.  
  22. begin
  23. p_person_history.create_person_status_change_history(v_person_id,
  24. p_gui_user_id,
  25. p_person_status_id,
  26. 'P_PERSON.update_person status change' || p_lm_name);
  27. end;
  28. begin
  29. v_ph_id := p_person_history.create_person_histories(v_person_id,sysdate, ...
Advertisement
Add Comment
Please, Sign In to add comment