egdb3_12_9
.action
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
find_circ_matrix_matchpoint(context_ou integer, match_item bigint, match_user integer, renewal boolean)
Parameters
Name
Type
Mode
context_ou
integer
IN
match_item
bigint
IN
match_user
integer
IN
renewal
boolean
IN
Definition
DECLARE item_object asset.copy%ROWTYPE; user_object actor.usr%ROWTYPE; BEGIN SELECT INTO item_object * FROM asset.copy WHERE id = match_item; SELECT INTO user_object * FROM actor.usr WHERE id = match_user; RETURN QUERY SELECT * FROM action.find_circ_matrix_matchpoint( context_ou, item_object, user_object, renewal ); END;