APPS.CNREDF_EVENT_TRIG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

  PROCEDURE select_columns (X_trigger_id	IN OUT		number,
			    X_trigger_name 	IN OUT		varchar2,
			    X_table_name	IN OUT		varchar2) IS

  BEGIN

    SELECT trg.name, tab.name
      INTO X_trigger_name, X_table_name
      FROM cn_obj_triggers_v trg,
	   cn_obj_tables_v tab
     WHERE trg.trigger_id = X_trigger_id
       AND tab.table_id = trg.table_id;

Line: 24

  END select_columns;

Line: 34

  PROCEDURE delete_row (X_trigger_ID 				number) IS

  BEGIN

    UPDATE cn_obj_triggers_v
       SET event_id = NULL
     WHERE trigger_id = X_trigger_id;

Line: 42

  END delete_row;

Line: 44

  PROCEDURE Insert_Row (X_trigger_id				number,
			X_event_id				number) IS

  BEGIN

    UPDATE cn_obj_triggers_v
       SET event_id = X_event_id
     WHERE trigger_id = X_trigger_id;

Line: 53

  END Insert_Row;

Line: 69

    SELECT trigger_id
      INTO Dumy
      FROM cn_obj_triggers_v
     WHERE trigger_id = X_trigger_ID
       FOR UPDATE OF cn_obj_triggers_v.event_id;

Line: 90

    SELECT trg.table_id, tab.name
      INTO X_table_id, X_table_name
      FROM cn_obj_triggers_v trg,
	   cn_obj_tables_v tab
     WHERE trg.trigger_id = X_trigger_id
       AND tab.table_id = trg.table_id;