APPS.CNSYIN_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: 28

    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: 37

      SELECT name
        INTO X_dimension_name
        FROM cn_dimensions
       WHERE dimension_id = X_dimension_id;

Line: 46

  END select_columns;

Line: 63

      SELECT cn_objects_s.nextval
        INTO X_column_id FROM dual;

Line: 70

      SELECT max(position)+1
	INTO X_position
	FROM cn_obj_columns_v
       WHERE table_id = X_table_id;