APPS.DEFCONDNRULE_PKG SQL Statements

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

Line: 4

   PROCEDURE Insert_Row(
      p_rowid    				in out NOCOPY /* file.sql.39 change */  varchar2
      ,p_attr_def_condition_id 			in out NOCOPY /* file.sql.39 change */  number
      ,p_condition_id 			in   number
      ,p_precedence 			in   number
      ,p_database_object_name		in      varchar2
      ,p_attribute_code	        	in      varchar2
      ,p_created_by       	 	in      number
      ,p_creation_date       		in      date
      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_system_flag       	in      varchar2
      ,p_enabled_flag       	in      varchar2
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
   )  IS

CURSOR C IS SELECT rowid from OE_DEF_attr_condns
	    WHERE attr_def_condition_id = p_attr_def_condition_id;

Line: 41

      INSERT INTO OE_DEF_ATTR_CONDNS(
		condition_id,
		attr_def_condition_id,
		precedence,
		database_object_name,
		attribute_code
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
	    ,system_flag
	    ,enabled_flag
         ,attribute_category
         ,attribute1
         ,attribute2
         ,attribute3
         ,attribute4
         ,attribute5
         ,attribute6
         ,attribute7
         ,attribute8
         ,attribute9
         ,attribute10
         ,attribute11
         ,attribute12
         ,attribute13
         ,attribute14
         ,attribute15)

	VALUES(
		p_condition_id,
		p_attr_def_condition_id,
		p_precedence,
		p_database_object_name,
		p_attribute_code
         ,p_created_by
         ,p_creation_date
         ,p_last_updated_by
         ,p_last_update_date
         ,p_last_update_login
	    ,p_system_flag
	    ,p_enabled_flag
         ,p_attribute_category
         ,p_attribute1
         ,p_attribute2
         ,p_attribute3
         ,p_attribute4
         ,p_attribute5
         ,p_attribute6
         ,p_attribute7
         ,p_attribute8
         ,p_attribute9
         ,p_attribute10
         ,p_attribute11
         ,p_attribute12
         ,p_attribute13
         ,p_attribute14
         ,p_attribute15);

Line: 110

END Insert_Row;

Line: 113

   PROCEDURE Update_Row(
      p_rowid    				in   varchar2
      ,p_attr_def_condition_id 			in   number
      ,p_condition_id 			in   number
      ,p_precedence 			in   number
      ,p_database_object_name		in      varchar2
      ,p_attribute_code	        	in      varchar2
      ,p_enabled_flag	        	in      varchar2
      ,p_created_by       	 	in      number
      ,p_creation_date       		in      date
      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
   ) IS

BEGIN

     UPDATE OE_DEF_ATTR_CONDNS
	SET precedence            = p_precedence
	    ,condition_id         = p_condition_id
	    ,enabled_flag         = p_enabled_flag
         ,created_by   		 = p_created_by
         ,creation_date		 = p_creation_date
         ,last_updated_by    	 = p_last_updated_by
         ,last_update_date     = p_last_update_date
         ,last_update_login     = p_last_update_login
         ,attribute_category   = p_attribute_category
         ,attribute1           = p_attribute1
         ,attribute2           = p_attribute2
         ,attribute3           = p_attribute3
         ,attribute4           = p_attribute4
         ,attribute5           = p_attribute5
         ,attribute6           = p_attribute6
         ,attribute7           = p_attribute7
         ,attribute8           = p_attribute8
         ,attribute9           = p_attribute9
         ,attribute10           = p_attribute10
         ,attribute11           = p_attribute11
         ,attribute12           = p_attribute12
         ,attribute13           = p_attribute13
         ,attribute14           = p_attribute14
         ,attribute15           = p_attribute15
WHERE rowid = p_rowid;

Line: 177

END Update_Row;

Line: 180

PROCEDURE Delete_Row(p_Rowid	  VARCHAR2,
		     p_attr_def_condition_id NUMBER) IS
BEGIN

  DELETE FROM OE_DEF_ATTR_CONDNS
  WHERE rowid = p_rowid;

Line: 192

END Delete_Row;

Line: 205

      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
   )  IS

CURSOR C IS
SELECT * FROM OE_DEF_ATTR_CONDNS
WHERE rowid = p_Rowid
FOR UPDATE OF attr_def_condition_id ;

Line: 239

FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 314

	 select 1 into dummy from dual where  exists
	 (select 1 from oe_def_attr_def_RULES
	  where attr_def_condition_id = p_attr_def_condition_id);

Line: 339

 SELECT COUNT(1)
	INTO dummy
	FROM OE_DEF_ATTR_CONDNS
	WHERE condition_id = p_condition_id
	AND database_object_name=p_database_object_name
	AND attribute_code = p_attribute_code
	AND ((p_rowid IS NULL) OR (ROWID <> p_rowid));