APPS.CN_MOD_OBJ_DEPENDS_PKG SQL Statements

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

Line: 9

  PROCEDURE insert_row (
	X_rowid		OUT	ROWID,
	X_mod_obj_depends_id	cn_mod_obj_depends.mod_obj_depends_id%TYPE,
	X_object_id		cn_mod_obj_depends.object_id%TYPE,
	X_parent_object_id	cn_mod_obj_depends.parent_object_id%TYPE,
	X_action		cn_mod_obj_depends.action%TYPE,
	X_module_id		cn_mod_obj_depends.module_id%TYPE) IS

    X_primary_key		cn_mod_obj_depends.mod_obj_depends_id%TYPE;

Line: 22

      SELECT cn_objects_s.NEXTVAL
        INTO X_primary_key
        FROM dual;

Line: 27

    INSERT INTO cn_mod_obj_depends (
	mod_obj_depends_id,
	object_id,
	parent_object_id,
	action,
	module_id)
      VALUES (
	X_primary_key,
	X_object_id,
	X_parent_object_id,
	X_action,
	X_module_id);

Line: 40

    SELECT ROWID
      INTO X_rowid
      FROM cn_mod_obj_depends
     WHERE mod_obj_depends_id = X_primary_key;

Line: 49

  END insert_row;

Line: 52

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

      SELECT * INTO recinfo
        FROM cn_mod_obj_depends cmom
        WHERE cmom.mod_obj_depends_id = recinfo.mod_obj_depends_id;

Line: 63

  END select_row;