eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAY_ELEMENT_INPUTS_PKG SQL Statements

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

Line: 38


    SELECT cn_pay_element_inputs_s.nextval
      INTO   X_pay_element_input_id
      FROM   dual;

Line: 50


PROCEDURE insert_row
   (x_pay_element_input_id  IN OUT NUMBER
    ,p_quota_pay_element_id     IN NUMBER
    ,p_element_input_id         IN NUMBER
    ,p_element_type_id          IN NUMBER
    ,p_tab_object_id            IN NUMBER
    ,p_col_object_id            IN NUMBER
    ,p_line_number		IN NUMBER
    ,p_start_date		IN DATE
    ,p_end_Date			IN DATE
    ,p_attribute_category       VARCHAR2	:= NULL
    ,p_attribute1               VARCHAR2	:= NULL
    ,p_attribute2               VARCHAR2	:= NULL
    ,p_attribute3               VARCHAR2	:= NULL
    ,p_attribute4               VARCHAR2	:= NULL
    ,p_attribute5               VARCHAR2	:= NULL
    ,p_attribute6               VARCHAR2	:= NULL
    ,p_attribute7               VARCHAR2	:= NULL
    ,p_attribute8               VARCHAR2	:= NULL
    ,p_attribute9               VARCHAR2	:= NULL
    ,p_attribute10              VARCHAR2	:= NULL
    ,p_attribute11              VARCHAR2	:= NULL
    ,p_attribute12              VARCHAR2	:= NULL
    ,p_attribute13              VARCHAR2	:= NULL
    ,p_attribute14              VARCHAR2	:= NULL
    ,p_attribute15              VARCHAR2	:= NULL
    ,p_Created_By               NUMBER
    ,p_Creation_Date            DATE
    ,p_Last_Updated_By          NUMBER
    ,p_Last_Update_Date         DATE
    ,p_Last_Update_Login        NUMBER )
   IS
      l_dummy NUMBER;

Line: 88


     INSERT INTO cn_pay_element_inputs
       (pay_element_input_id
        ,quota_pay_element_id
	,element_input_id
	,element_type_id
	,tab_object_id
	,col_object_id
        ,line_number
        ,start_date
        ,end_date
	,attribute_category
	,attribute1
	,attribute2
	,attribute3
	,attribute4
	,attribute5
	,attribute6
	,attribute7
	,attribute8
	,attribute9
	,attribute10
	,attribute11
	,attribute12
	,attribute13
	,attribute14
	,attribute15
	,Created_By
	,Creation_Date
	,Last_Updated_By
	,Last_Update_Date
	,Last_Update_Login)
       VALUES
       (x_pay_element_input_id
        ,p_quota_pay_element_id
	,p_element_input_id
	,p_element_type_id
	,p_tab_object_id
	,p_col_object_id
        ,p_line_number
        ,p_start_Date
        ,p_end_Date
	,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
	,p_Created_By
	,p_Creation_Date
	,p_Last_Updated_By
	,p_Last_Update_Date
	,p_Last_Update_Login
	);

Line: 152


     select 1 INTO l_dummy  from CN_PAY_ELEMENT_INPUTS
       where PAY_ELEMENT_INPUT_ID = x_pay_element_input_id;

Line: 155


   END Insert_row;

Line: 193


        SELECT *
          FROM cn_pay_element_inputs
         WHERE pay_element_input_id = p_pay_element_input_id
           FOR UPDATE of pay_element_input_id NOWAIT;

Line: 206


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

Line: 271


PROCEDURE update_row
   (p_pay_element_input_id      NUMBER
    ,p_quota_pay_element_id      IN NUMBER
    ,p_element_input_id         IN NUMBER
    ,p_element_type_id          IN NUMBER
    ,p_tab_object_id            IN NUMBER
    ,p_col_object_id            IN NUMBER
    ,p_line_number		IN NUMBER
    ,p_start_date		IN DATE
    ,p_end_date			IN DATE
    ,p_attribute_category       VARCHAR2
    ,p_attribute1               VARCHAR2
    ,p_attribute2               VARCHAR2
    ,p_attribute3               VARCHAR2
    ,p_attribute4               VARCHAR2
    ,p_attribute5               VARCHAR2
    ,p_attribute6               VARCHAR2
    ,p_attribute7               VARCHAR2
    ,p_attribute8               VARCHAR2
    ,p_attribute9               VARCHAR2
    ,p_attribute10              VARCHAR2
    ,p_attribute11              VARCHAR2
    ,p_attribute12              VARCHAR2
    ,p_attribute13              VARCHAR2
    ,p_attribute14              VARCHAR2
    ,p_attribute15              VARCHAR2
    ,p_Last_Updated_By          NUMBER
    ,p_Last_Update_Date         DATE
    ,p_Last_Update_Login        NUMBER ) IS

   l_pay_element_input_id	cn_pay_element_inputs.pay_element_input_id%TYPE;

Line: 329


	  SELECT *
	    FROM cn_pay_element_inputs
	    WHERE pay_element_input_id = p_pay_element_input_id
	    FOR UPDATE of pay_element_input_id NOWAIT;

Line: 340


   SELECT
      decode(p_element_input_id,
	     fnd_api.g_miss_num, oldrow.element_input_id,
	     p_element_input_id),
      decode(p_quota_pay_element_id,
	     fnd_api.g_miss_num, oldrow.quota_pay_element_id,
	     p_quota_pay_element_id),
      decode(p_element_type_id,
	     fnd_api.g_miss_num, oldrow.element_type_id,
	     p_element_type_id),
      decode(p_tab_object_id,
	     fnd_api.g_miss_num, oldrow.tab_object_id,
	     p_tab_object_id),
      decode(p_col_object_id,
	     fnd_api.g_miss_num, oldrow.col_object_id,
	     p_col_object_id),
      decode(p_line_number,
	     fnd_api.g_miss_num, oldrow.line_number,
	     p_line_number),
     decode(p_start_date,
	     fnd_api.g_miss_date, oldrow.start_date,
	     p_start_date),
      decode(p_end_date,
	     fnd_api.g_miss_date, oldrow.end_date,
	     p_end_Date),
      decode(p_attribute_category,
	     fnd_api.g_miss_char, oldrow.attribute_category,
	     p_attribute_category),
      decode(p_attribute1,
	     fnd_api.g_miss_char, oldrow.attribute1,
	     p_attribute1),
      decode(p_attribute2,
	     fnd_api.g_miss_char, oldrow.attribute2,
	     p_attribute2),
      decode(p_attribute3,
	     fnd_api.g_miss_char, oldrow.attribute3,
	     p_attribute3),
      decode(p_attribute4,
	     fnd_api.g_miss_char, oldrow.attribute4,
	     p_attribute4),
      decode(p_attribute5,
	     fnd_api.g_miss_char, oldrow.attribute5,
	     p_attribute5),
      decode(p_attribute6,
	     fnd_api.g_miss_char, oldrow.attribute6,
	     p_attribute6),
      decode(p_attribute7,
	     fnd_api.g_miss_char, oldrow.attribute7,
	     p_attribute7),
      decode(p_attribute8,
	     fnd_api.g_miss_char, oldrow.attribute8,
	     p_attribute8),
      decode(p_attribute9,
	     fnd_api.g_miss_char, oldrow.attribute9,
	     p_attribute9),
      decode(p_attribute10,
	     fnd_api.g_miss_char, oldrow.attribute10,
	     p_attribute10),
      decode(p_attribute11,
	     fnd_api.g_miss_char, oldrow.attribute11,
	     p_attribute11),
      decode(p_attribute12,
	     fnd_api.g_miss_char, oldrow.attribute12,
	     p_attribute12),
      decode(p_attribute13,
	     fnd_api.g_miss_char, oldrow.attribute13,
	     p_attribute13),
      decode(p_attribute14,
	     fnd_api.g_miss_char, oldrow.attribute14,
	     p_attribute14),
      decode(p_attribute15,
	     fnd_api.g_miss_char, oldrow.attribute15,
	     p_attribute15)
     INTO
      l_element_input_id,
      l_quota_pay_element_id,
      l_element_type_id,
      l_tab_object_id,
      l_col_object_id,
      l_line_number,
      l_start_date,
      l_end_Date,
      l_attribute_category,
      l_attribute1,
      l_attribute2,
      l_attribute3,
      l_attribute4,
      l_attribute5,
      l_attribute6,
      l_attribute7,
      l_attribute8,
      l_attribute9,
      l_attribute10,
      l_attribute11,
      l_attribute12,
      l_attribute13,
      l_attribute14,
      l_attribute15
      FROM dual;

Line: 440


    UPDATE cn_pay_element_inputs
      SET
      element_input_id          =       l_element_input_id,
      quota_pay_element_id	=	l_quota_pay_element_id,
      element_type_id           =       l_element_type_id,
      tab_object_id             =       l_tab_object_id,
      col_object_id		=	l_col_object_id,
      line_number	        = 	l_line_number,
      start_date		= 	l_start_date,
      end_date			= 	l_end_Date,
      attribute_category	=	l_attribute_category,
      attribute1		=       l_attribute1,
      attribute2		=       l_attribute2,
      attribute3		=	l_attribute3,
      attribute4		=	l_attribute4,
      attribute5		=	l_attribute5,
      attribute6		=	l_attribute6,
      attribute7		=	l_attribute7,
      attribute8		=	l_attribute8,
      attribute9		=	l_attribute9,
      attribute10		=	l_attribute10,
      attribute11		=	l_attribute11,
      attribute12		=	l_attribute12,
      attribute13		=	l_attribute13,
      attribute14		=	l_attribute14,
      attribute15		=	l_attribute15,
      last_update_date	        =	p_Last_Update_Date,
      last_updated_by      	=     	p_Last_Updated_By,
      last_update_login    	=     	p_Last_Update_Login
      WHERE pay_element_input_id=       p_pay_element_input_id;

Line: 475


  END Update_row;

Line: 484


  PROCEDURE Delete_row( p_pay_element_input_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_pay_element_inputs
       WHERE  pay_element_input_id = p_pay_element_input_id ;

Line: 493


  END Delete_row;