APPS.CN_OBJ_INDEXES_V_PKG SQL Statements

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

Line: 9

  PROCEDURE insert_row (
	X_rowid		OUT	ROWID,
	X_index_id		cn_obj_indexes_v.index_id%TYPE,
	X_name			cn_obj_indexes_v.name%TYPE,
	X_description		cn_obj_indexes_v.description%TYPE,
	X_dependency_map_complete	cn_obj_indexes_v.dependency_map_complete%TYPE,
	X_status		cn_obj_indexes_v.status%TYPE,
	X_repository_id		cn_obj_indexes_v.repository_id%TYPE,
	X_table_id		cn_obj_indexes_v.table_id%TYPE,
	X_unique_flag		cn_obj_indexes_v.unique_flag%TYPE,
	X_seed_index_id		cn_obj_indexes_v.seed_index_id%TYPE) IS

    X_primary_key		cn_obj_indexes_v.index_id%TYPE;

Line: 26

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 31

    INSERT INTO cn_obj_indexes_v (
	index_id,
	name,
	description,
	dependency_map_complete,
	status,
	repository_id,
	table_id,
	unique_flag,
	object_type,
	seed_index_id)
      VALUES (
	X_primary_key,
	X_name,
	X_description,
	X_dependency_map_complete,
	X_status,
	X_repository_id,
	X_table_id,
	X_unique_flag,
	'IND',
	X_seed_index_id);

Line: 54

    SELECT ROWID
      INTO X_rowid
      FROM cn_obj_indexes_v
     WHERE index_id = X_primary_key;

Line: 63

  END insert_row;

Line: 66

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

      SELECT * INTO recinfo
        FROM cn_obj_indexes_v coiv
        WHERE coiv.index_id = recinfo.index_id;

Line: 77

  END select_row;