APPS.CN_OBJ_PACKAGES_V_PKG SQL Statements

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

Line: 17

  PROCEDURE insert_row (
	X_rowid		OUT		ROWID,
	X_package_id			cn_obj_packages_v.package_id%TYPE,
	X_name				cn_obj_packages_v.name%TYPE,
	X_description			cn_obj_packages_v.description%TYPE,
	X_dependency_map_complete	cn_obj_packages_v.dependency_map_complete%TYPE,
	X_status			cn_obj_packages_v.status%TYPE,
	X_repository_id			cn_obj_packages_v.repository_id%TYPE,
	X_package_type			cn_obj_packages_v.package_type%TYPE,
	X_package_specification_id	cn_obj_packages_v.package_specification_id%TYPE,
	X_seed_package_id		cn_obj_packages_v.seed_package_id%TYPE) IS

    X_object_type		cn_obj_packages_v.object_type%TYPE;

Line: 36

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 49

    INSERT INTO cn_obj_packages_v(
	package_id,
	name,
	description,
	dependency_map_complete,
	status,
	repository_id,
	package_type,
	package_specification_id,
	object_type,
	seed_package_id)
    VALUES(
	X_primary_key,
	X_name,
	X_description,
	X_dependency_map_complete,
	X_status,
	X_repository_id,
        X_package_type,
	X_package_specification_id,
	X_object_type,
	X_seed_package_id);

Line: 72

    SELECT ROWID
      INTO X_rowid
      FROM cn_obj_packages_v
     WHERE package_id = X_primary_key;

Line: 81

  END insert_row;

Line: 92

  PROCEDURE select_row(
	row IN OUT cn_obj_packages_v%ROWTYPE) IS

  BEGIN

    IF (row.package_id IS NOT NULL) THEN
      SELECT *
	INTO row
        FROM cn_obj_packages_v
       WHERE cn_obj_packages_v.package_id = row.package_id;

Line: 104

  END select_row;