Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
force_update_tbl_staff FUNCTION PLPGSQL false trigger INVOKER
delete_staff_position FUNCTION PLPYTHONU false trigger INVOKER
insert_staff_position FUNCTION PLPYTHONU false trigger INVOKER
insert_staff FUNCTION PLPYTHONU false trigger INVOKER
maintain_sequence FUNCTION PLPGSQL false trigger INVOKER
insert_staff_payroll_centre FUNCTION PLPYTHONU false trigger INVOKER
delete_staff_payroll_centre FUNCTION PLPYTHONU false trigger INVOKER
update_staff_to_tenders FUNCTION PLPYTHONU false trigger INVOKER
amqp_push_staff_data_to_messaging FUNCTION PLPGSQL false trigger INVOKER
delete_staff_cost_centre FUNCTION PLPYTHONU false trigger INVOKER
drop_mirror_triggers FUNCTION PLPGSQL false boolean INVOKER
amqp_mirror_trigger FUNCTION PLPGSQL false trigger INVOKER
update_staff FUNCTION PLPYTHONU false trigger INVOKER
amqp_mirror_trigger_new FUNCTION PLPGSQL false trigger INVOKER
delete_staff_location FUNCTION PLPYTHONU false trigger INVOKER
insert_staff_location FUNCTION PLPYTHONU false trigger INVOKER
insert_staff_cost_centre FUNCTION PLPYTHONU false trigger INVOKER
pg_grant FUNCTION PLPGSQL false integer DEFINER
create_mirror_triggers FUNCTION PLPGSQL false boolean INVOKER
insert_staff_into_tenders FUNCTION PLPYTHONU false trigger INVOKER
update_timestamp FUNCTION PLPGSQL false trigger INVOKER