Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- procedure itself in p_person_history
- procedure create_person_status_change_history(p_person_id in number,
- p_gui_user_id in number,
- p_person_status_id in number,
- p_system_comment in varchar2)
- is
- v_event_date date;
- begin
- v_event_date := toUTCDate(sysdate, 'Europe/Brussels');
- insert into PERSON_HISTORY (PERSON_HISTORY_ID, PERSON_ID, EVENT_DATE, GUI_USER_ID, PERSON_HISTORY_EVENT_TYPE_ID, SYSTEM_COMMENT)
- 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);
- commit;
- P_PERSON_DATA.create_person_history_person_data(seq_person_history_id.currval);
- end create_person_status_change_history;
- -- addition to update_person
- ...
- vg_proc_name := 'UPDATE_PERSON';
- vg_step := 40;
- begin
- p_person_history.create_person_status_change_history(v_person_id,
- p_gui_user_id,
- p_person_status_id,
- 'P_PERSON.update_person status change' || p_lm_name);
- end;
- begin
- v_ph_id := p_person_history.create_person_histories(v_person_id,sysdate, ...
Advertisement
Add Comment
Please, Sign In to add comment