DBA Data[Home] [Help]

APPS.CNREDF_TRIG_COLUMNS_PKG SQL Statements

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

Line: 17

      SELECT cn_column_trg_maps_s.nextval
	INTO X_column_trigger_id
	FROM dual;
Line: 33

  PROCEDURE select_columns (X_column_id		IN OUT		number,
			    X_column_name 	IN OUT		varchar2) IS
  BEGIN

    SELECT name
      INTO X_column_name
      FROM cn_obj_columns_v
     WHERE column_id = X_column_id;
Line: 42

  END select_columns;