egdb3_11_7
.acq
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
extract_provider_holding_data(lineitem_i integer)
Parameters
Name
Type
Mode
lineitem_i
integer
IN
Definition
DECLARE prov_i INT; tag_t TEXT; lida acq.flat_lineitem_detail%ROWTYPE; BEGIN SELECT provider INTO prov_i FROM acq.lineitem WHERE id = lineitem_i; IF NOT FOUND THEN RETURN; END IF; SELECT holding_tag INTO tag_t FROM acq.provider WHERE id = prov_i; IF NOT FOUND OR tag_t IS NULL THEN RETURN; END IF; FOR lida IN SELECT lineitem_i, h.holding, a.name, h.data FROM acq.extract_holding_attr_table( lineitem_i, tag_t ) h JOIN acq.provider_holding_subfield_map a USING (subfield) WHERE a.provider = prov_i LOOP RETURN NEXT lida; END LOOP; RETURN; END;