Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
copy_fund_tags(old_fund_id integer, new_fund_id integer) FUNCTION plpgsql false void INVOKER
fap_limit_100() FUNCTION plpgsql false trigger INVOKER
propagate_funds_by_org_unit(old_year integer, user_id integer, org_unit_id integer) FUNCTION sql false void INVOKER
audit_acq_lineitem_detail_func() FUNCTION plpgsql false trigger INVOKER
propagate_funds_by_org_tree(old_year integer, user_id integer, org_unit_id integer, include_desc boolean DEFAULT true) FUNCTION plpgsql false void INVOKER
create_acq_func(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
create_acq_update_trigger(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
create_acq_lifecycle(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
find_bad_fy() FUNCTION plpgsql false SETOF record INVOKER
create_acq_seq(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
po_org_name_date_unique() FUNCTION plpgsql false trigger INVOKER
extract_provider_holding_data(lineitem_i integer) FUNCTION plpgsql false SETOF acq.flat_lineitem_detail INVOKER
exchange_ratio(text, text, numeric) FUNCTION sql false numeric INVOKER
extract_holding_attr_table(lineitem integer, tag text) FUNCTION plpgsql false SETOF acq.flat_lineitem_holding_subfield INVOKER
rollover_funds_by_org_tree(old_year integer, user_id integer, org_unit_id integer, encumb_only boolean DEFAULT false, include_desc boolean DEFAULT true) FUNCTION plpgsql false void INVOKER
rollover_funds_by_org_unit(old_year integer, user_id integer, org_unit_id integer, encumb_only boolean DEFAULT false) FUNCTION sql false void INVOKER
purchase_order_name_default() FUNCTION plpgsql false trigger INVOKER
audit_acq_lineitem_func() FUNCTION plpgsql false trigger INVOKER
transfer_fund(old_fund integer, old_amount numeric, new_fund integer, new_amount numeric, user_id integer, xfer_note text) FUNCTION plpgsql false void INVOKER
audit_acq_purchase_order_func() FUNCTION plpgsql false trigger INVOKER
fund_alloc_percent_val() FUNCTION plpgsql false trigger INVOKER
exchange_ratio(from_ex text, to_ex text) FUNCTION plpgsql false numeric INVOKER
create_acq_history(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
create_acq_auditor(sch text, tbl text) FUNCTION plpgsql false boolean INVOKER
attribute_debits() FUNCTION plpgsql false void INVOKER