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_QUOTA_PAY_ELEMENTS_PKG SQL Statements

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

Line: 37


    SELECT cn_quota_pay_elements_s.nextval
      INTO   X_quota_pay_element_id
      FROM   dual;

Line: 49


PROCEDURE insert_row
   (x_quota_pay_element_id  IN OUT NUMBER
    ,p_quota_id                 IN NUMBER
    ,p_pay_element_type_id      IN NUMBER
    ,p_status                   VARCHAR2        := NULL
    ,p_start_date	        DATE
    ,p_end_date	                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: 84


     INSERT INTO cn_quota_pay_elements
       (quota_pay_element_id
	,quota_id
	,pay_element_type_id
	,status
	,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_quota_pay_element_id
	,p_quota_id
	,p_pay_element_type_id
	,p_status
	,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: 142


     select 1 INTO l_dummy  from CN_QUOTA_PAY_ELEMENTS
       where QUOTA_PAY_ELEMENT_ID = x_quota_pay_element_id;

Line: 145


   END Insert_row;

Line: 180


        SELECT *
          FROM cn_quota_pay_elements
         WHERE quota_pay_element_id = p_quota_pay_element_id
           FOR UPDATE of quota_pay_element_id NOWAIT;

Line: 193


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

Line: 255


PROCEDURE update_row
   (p_quota_pay_element_id      NUMBER
    ,p_quota_id                 NUMBER
    ,p_pay_element_type_id      NUMBER
    ,p_status                   VARCHAR2
    ,p_start_date		DATE
    ,p_end_date		        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_quota_pay_element_id	cn_quota_pay_elements.quota_pay_element_id%TYPE;

Line: 306


	  SELECT *
	    FROM cn_quota_pay_elements
	    WHERE quota_pay_element_id = p_quota_pay_element_id
	    FOR UPDATE of quota_pay_element_id NOWAIT;

Line: 318


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

Line: 323


   SELECT
      decode(p_quota_id,
	     fnd_api.g_miss_num, oldrow.quota_id,
	     p_quota_id),
      decode(p_pay_element_type_id,
	     fnd_api.g_miss_num, oldrow.pay_element_type_id,
	     p_pay_element_type_id),
      decode(p_status,
	     fnd_api.g_miss_char, oldrow.status,
	     p_status),
      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_quota_id,
      l_pay_element_type_id,
      l_status,
      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: 411


    UPDATE cn_quota_pay_elements
      SET
      quota_id                  =       l_quota_id,
      pay_element_type_id       =       l_pay_element_type_id,
      status                    =       l_status,
      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 quota_pay_element_id=       p_quota_pay_element_id;

Line: 443


  END Update_row;

Line: 452


  PROCEDURE Delete_row( p_quota_pay_element_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_quota_pay_elements
       WHERE  quota_pay_element_id = p_quota_pay_element_id ;

Line: 461


  END Delete_row;