APPS.CNREDF_COLUMNS_PKG SQL Statements

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

Line: 11

  PROCEDURE select_columns(	X_data_type		IN OUT	varchar2,
				X_column_type		IN OUT	varchar2,
				X_dimension_id		IN OUT	number,
				X_data_type_name	IN OUT	varchar2,
				X_type_name		IN OUT	varchar2,
				X_dimension_name	IN OUT	varchar2) IS


  BEGIN

    IF X_column_type is NULL THEN
      X_column_type := 'CN';

Line: 29

    SELECT lookup1.meaning, lookup2.meaning
      INTO X_type_name,
           X_data_type_name
      FROM cn_lookups lookup1,
           cn_lookups lookup2
     WHERE lookup1.lookup_type = 'COLUMN_TYPE'
       AND lookup1.lookup_code = X_column_type
       AND lookup2.lookup_type = 'DATA_TYPE'
       AND lookup2.lookup_code = X_data_type;

Line: 40

      SELECT name
	INTO X_dimension_name
	FROM cn_dimensions
       WHERE dimension_id = X_dimension_id;

Line: 49

  END select_columns;

Line: 64

      SELECT cn_objects_s.nextval
        INTO X_column_id FROM dual;