APPS.CN_OBJ_SEQUENCES_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_sequence_id		cn_obj_sequences_v.sequence_id%TYPE,
	X_name			cn_obj_sequences_v.name%TYPE,
	X_description		cn_obj_sequences_v.description%TYPE,
	X_dependency_map_complete	cn_obj_sequences_v.dependency_map_complete%TYPE,
	X_status		cn_obj_sequences_v.status%TYPE,
	X_repository_id		cn_obj_sequences_v.repository_id%TYPE,
	X_start_value		cn_obj_sequences_v.start_value%TYPE,
	X_increment_value	cn_obj_sequences_v.increment_value%TYPE,
	X_seed_sequence_id	cn_obj_sequences_v.seed_sequence_id%TYPE) IS

    X_primary_key		cn_obj_sequences_v.sequence_id%TYPE;

Line: 26

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 31

    INSERT INTO cn_obj_sequences_v (
	sequence_id,
	name,
	description,
	dependency_map_complete,
	status,
	repository_id,
	start_value,
	increment_value,
	object_type,
	seed_sequence_id)
      VALUES (
	X_primary_key,
	X_name,
	X_description,
	X_dependency_map_complete,
	X_status,
	X_repository_id,
	X_start_value,
	X_increment_value,
	'SEQ',
	X_seed_sequence_id);

Line: 54

    SELECT ROWID
      INTO X_rowid
      FROM cn_obj_sequences_v
     WHERE sequence_id = X_primary_key;

Line: 63

  END insert_row;

Line: 66

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

      SELECT * INTO recinfo
        FROM cn_obj_sequences_v crosv
        WHERE crosv.sequence_id = recinfo.sequence_id;

Line: 77

  END select_row;