The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
X_rowid OUT ROWID,
X_trigger_id cn_obj_triggers_v.trigger_id%TYPE,
X_name cn_obj_triggers_v.name%TYPE,
X_description cn_obj_triggers_v.description%TYPE,
X_dependency_map_complete cn_obj_triggers_v.dependency_map_complete%TYPE,
X_status cn_obj_triggers_v.status%TYPE,
X_repository_id cn_obj_triggers_v.repository_id%TYPE,
X_when_clause cn_obj_triggers_v.when_clause%TYPE,
X_triggering_event cn_obj_triggers_v.triggering_event%TYPE,
X_table_id cn_obj_triggers_v.table_id%TYPE,
X_event_id cn_obj_triggers_v.event_id%TYPE,
X_for_each_row cn_obj_triggers_v.for_each_row%TYPE,
X_trigger_type cn_obj_triggers_v.trigger_type%TYPE,
X_seed_trigger_id cn_obj_triggers_v.seed_trigger_id%TYPE) IS
X_primary_key cn_obj_triggers_v.trigger_id%TYPE;
SELECT cn_objects_s.NEXTVAL
INTO X_primary_key
FROM dual;
INSERT INTO cn_obj_triggers_v (
trigger_id,
name,
description,
dependency_map_complete,
status,
repository_id,
object_type,
when_clause,
triggering_event,
table_id,
event_id,
for_each_row,
trigger_type,
seed_trigger_id)
VALUES (
X_primary_key, -- AE 03-28-95
X_name,
X_description,
X_dependency_map_complete,
X_status,
X_repository_id,
'TRG',
X_when_clause,
X_triggering_event,
X_table_id,
X_event_id,
X_for_each_row,
X_trigger_type,
X_seed_trigger_id);
SELECT ROWID
INTO X_rowid
FROM cn_obj_triggers_v
WHERE trigger_id = X_primary_key;
END insert_row;
PROCEDURE select_row (
row IN OUT cn_obj_triggers_v%ROWTYPE) IS
BEGIN
IF (row.trigger_id IS NOT NULL) THEN
SELECT * INTO row
FROM cn_obj_triggers_v
WHERE cn_obj_triggers_v.trigger_id = row.trigger_id;
END select_row;