1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
DECLARE
TYPE t_rec_unit IS TABLE OF NUMBER
INDEX BY PLS_INTEGER;
vt_rec_unit t_rec_unit;
BEGIN
INSERT INTO G_REC_GROUP_MEMBERS (rec_group_id, rec_unit_id)
SELECT rec_unit_id
FROM G_REC_GROUP_MEMBERS SM
WHERE rec_group_id = pn_source_group_id
AND closed IS NULL
AND NOT EXISTS
(SELECT NULL
FROM G_REC_GROUP_MEMBERS MM
WHERE rec_group_id IN
(SELECT rec_group_id
FROM G_REC_UNIT_GROUP
WHERE activity_id = pv_activity_id
AND entity_id = pn_entity_id
AND TYPE = 'M')
AND MM.rec_unit_id = SM.rec_unit_id)
RETURNING rec_unit_id
BULK COLLECT INTO vt_rec_unit;
END; |
Partager