APPS.CN_OBJ_TABLES_V_PKG SQL Statements

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

Line: 19

  PROCEDURE insert_row (
	X_rowid			OUT	rowid,
        X_row_id                        rowid		default NULL,
	X_table_id 		IN OUT	number,
	X_name 				varchar2,
	X_description 			varchar2	default NULL,
	X_status 			varchar2,
	X_dependency_map_complete 	varchar2,
	X_repository_id			number,
	X_alias				varchar2	default NULL,
	X_table_level			varchar2	default NULL,
	X_table_type			varchar2	default NULL,
	X_seed_table_id			varchar2	default NULL) IS


    CURSOR C IS SELECT rowid
                  FROM cn_obj_tables_v
	         WHERE table_id = X_table_id;

Line: 38

    CURSOR C2 IS SELECT cn_objects_s.nextval
                   FROM sys.dual;

Line: 49

    INSERT INTO cn_obj_tables_v(
	row_id,
	table_id,
	name,
	description,
	repository_id,
	object_type,
	status,
	dependency_map_complete,
	alias,
	table_level,
	table_type,
	seed_table_id)
    VALUES (
	X_row_id,
	X_table_id,
	X_name,
	X_description,
	X_repository_id,
	'TBL',
	X_status,
	X_dependency_map_complete,
	X_alias,
	X_table_level,
	X_table_type,
	X_seed_table_id);

Line: 86

  END insert_row;

Line: 96

  PROCEDURE update_row (
	X_rowid				varchar2,
	X_table_id 			number,
	X_name 				varchar2,
	X_description			varchar2	default NULL,
	X_repository_id			number,
	X_alias				varchar2	default NULL,
	X_table_level			varchar2	default NULL,
	X_table_type			varchar2	default NULL) IS

  BEGIN
    UPDATE cn_obj_tables_v
       SET
	 name			= X_name,
	 description		= X_description,
	 repository_id		= X_repository_id,
	 object_type		= 'TBL',
    	 alias			= X_alias,
	 table_level		= X_table_level,
	 table_type		= X_table_type
     WHERE table_id = X_table_id;

Line: 122

  END update_row;

Line: 139

	select rep_tables.table_id into Tony
	from rep_tables, rep_objects
	where rep_tables.table_id = tab_id AND rep_objects.object_id = tab_id
	for update of rep_tables.table_type, rep_objects.name,
			rep_objects.description, rep_tables.alias;

Line: 157

  PROCEDURE select_row
	(row IN OUT cn_obj_tables_v%ROWTYPE) IS

  BEGIN
    IF (row.table_id IS NOT NULL) THEN

      SELECT * INTO row
        FROM cn_obj_tables_v
       WHERE cn_obj_tables_v.table_id = row.table_id;

Line: 169

  END select_row;