APPS.DEFELEMENTS_PKG SQL Statements

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

Line: 5

   PROCEDURE Insert_Row(
-------------------------------------------------------------------
       p_condition_id 			in   number
      ,p_group_number 			in   number
      ,p_attribute_code	       	in      varchar2
      ,p_value_op	       	in      varchar2
      ,p_value_string	       	in      varchar2
      ,p_system_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
      ,p_condition_element_id      in       number
,x_rowid out nocopy varchar2

	 ) IS

CURSOR C IS SELECT rowid from OE_DEF_CONDN_ELEMS
	    WHERE condition_element_id = p_condition_element_id;

Line: 47

      INSERT INTO OE_DEF_CONDN_ELEMS(
		condition_element_id
		,condition_id
		,group_number
		,attribute_code
		,value_op
		,value_string
		,system_flag
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
         ,attribute_category
         ,attribute1
         ,attribute2
         ,attribute3
         ,attribute4
         ,attribute5
         ,attribute6
         ,attribute7
         ,attribute8
         ,attribute9
         ,attribute10
         ,attribute11
         ,attribute12
         ,attribute13
         ,attribute14
         ,attribute15)
VALUES (
	p_condition_element_id,
	p_condition_id,
	p_group_number,
	p_attribute_code,
	p_value_op,
	p_value_string,
	p_system_flag
         ,p_created_by
         ,p_creation_date
         ,p_last_updated_by
         ,p_last_update_date
         ,p_last_update_login
         ,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: 107

UPDATE OE_DEF_CONDITIONS
set number_of_elements=number_of_elements+1
where condition_id = p_condition_id;

Line: 121

END INSERT_ROW;

Line: 125

PROCEDURE Update_Row(
-------------------------------------------------------------------
       p_rowid  in out NOCOPY /* file.sql.39 change */  varchar2
      ,p_condition_id 			in   number
      ,p_condition_element_id               in       number
      ,p_group_number 			in   number
      ,p_attribute_code	       	in      varchar2
      ,p_value_op	       	in      varchar2
      ,p_value_string	       	in      varchar2
      ,p_system_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
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 163

UPDATE OE_DEF_CONDN_ELEMS
SET attribute_code = p_attribute_code,
    value_op = p_value_op,
    value_string = p_value_string,
    group_number = p_group_number
       ,system_flag          = p_system_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 condition_element_id = p_condition_element_id;

Line: 196

END Update_Row;

Line: 200

PROCEDURE Delete_Row(
-------------------------------------------------------------------
			p_rowid				IN VARCHAR2,
		     p_condition_element_id 	IN NUMBER,
		     p_condition_id 		IN NUMBER)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 211

  DELETE FROM OE_DEF_CONDN_ELEMS
  WHERE rowid = p_rowid;

Line: 214

  UPDATE OE_DEF_CONDITIONS
  set number_of_elements=number_of_elements-1
  WHERE condition_id=p_condition_id;

Line: 222

END Delete_Row;

Line: 237

      ,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_CONDN_ELEMS
WHERE condition_element_id = p_condition_element_id
FOR UPDATE of condition_element_id NOWAIT;

Line: 276

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