APPS.CN_COLUMN_IND_MAPS_PKG SQL Statements

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

Line: 9

  PROCEDURE insert_row (
	X_rowid		OUT	ROWID,
	X_column_ind_map_id	cn_column_ind_maps.column_ind_map_id%TYPE,
	X_index_id		cn_column_ind_maps.index_id%TYPE,
	X_column_id		cn_column_ind_maps.column_id%TYPE,
	X_column_position	cn_column_ind_maps.column_position%TYPE,
	X_order_flag		cn_column_ind_maps.order_flag%TYPE) IS

    X_primary_key               cn_column_trg_maps.column_trg_map_id%TYPE;

Line: 22

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 27

    INSERT INTO cn_column_ind_maps (
	column_ind_map_id,
	index_id,
	column_id,
	column_position,
	order_flag)
      VALUES (
	X_column_ind_map_id,
	X_index_id,
	X_column_id,
	X_column_position,
	X_order_flag);

Line: 40

    SELECT ROWID
      INTO X_rowid
      FROM cn_column_ind_maps
     WHERE column_ind_map_id = X_primary_key;

Line: 49

  END insert_row;

Line: 52

  PROCEDURE select_row (
	recinfo IN OUT cn_column_ind_maps%ROWTYPE) IS
  BEGIN
    -- select row based on index_id (primary key)
    IF (recinfo.index_id IS NOT NULL) THEN

      SELECT * INTO recinfo
        FROM cn_column_ind_maps ccim
        WHERE ccim.index_id = recinfo.index_id;

Line: 63

  END select_row;