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

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

Line: 34


    SELECT cn_srp_pmt_plans_s.nextval
      INTO   X_srp_pmt_plan_id
      FROM   dual;

Line: 46


   PROCEDURE insert_row
   (x_srp_pmt_plan_id        	      IN OUT NOCOPY NUMBER
    ,x_pmt_plan_id                    IN NUMBER
    ,x_salesrep_id                    IN NUMBER
    ,x_org_id                         IN NUMBER
    ,x_role_id                        IN NUMBER
    ,x_credit_type_id                 IN NUMBER
    ,x_start_date		      DATE
    ,x_end_date	                      DATE
    ,x_minimum_amount                 IN NUMBER
    ,x_maximum_amount                 IN NUMBER
    ,x_max_recovery_amount            IN NUMBER
    ,x_attribute_category             VARCHAR2
    ,x_attribute1                     VARCHAR2
    ,x_attribute2                     VARCHAR2
    ,x_attribute3                     VARCHAR2
    ,x_attribute4                     VARCHAR2
    ,x_attribute5                     VARCHAR2
    ,x_attribute6                     VARCHAR2
    ,x_attribute7                     VARCHAR2
    ,x_attribute8                     VARCHAR2
    ,x_attribute9                     VARCHAR2
    ,x_attribute10                    VARCHAR2
    ,x_attribute11                    VARCHAR2
    ,x_attribute12                    VARCHAR2
    ,x_attribute13                    VARCHAR2
    ,x_attribute14                    VARCHAR2
    ,x_attribute15                    VARCHAR2
    ,x_Created_By                     NUMBER
    ,x_Creation_Date                  DATE
    ,x_Last_Updated_By                NUMBER
    ,x_Last_Update_Date               DATE
    ,x_Last_Update_Login              NUMBER
    ,x_srp_role_id                    NUMBER
    ,x_role_pmt_plan_id               NUMBER
    ,x_lock_flag                      VARCHAR2)
   IS
      l_dummy NUMBER;

Line: 89


     INSERT INTO cn_srp_pmt_plans
       (srp_pmt_plan_id
	,pmt_plan_id
	,salesrep_id
	,org_id
	,role_id
	,credit_type_id
	,start_date
	,end_date
	,minimum_amount
	,maximum_amount
	,max_recovery_amount
	,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
        ,object_version_number
        ,srp_role_id
        ,role_pmt_plan_id
        ,lock_flag)
       VALUES
       (x_srp_pmt_plan_id
	,x_pmt_plan_id
	,x_salesrep_id
	,x_org_id
	,x_role_id
	,x_credit_type_id
	,x_start_date
	,x_end_date
	,x_minimum_amount
	,x_maximum_amount
	,x_max_recovery_amount
	,x_attribute_category
	,x_attribute1
	,x_attribute2
	,x_attribute3
	,x_attribute4
	,x_attribute5
	,x_attribute6
	,x_attribute7
	,x_attribute8
	,x_attribute9
	,x_attribute10
	,x_attribute11
	,x_attribute12
	,x_attribute13
	,x_attribute14
	,x_attribute15
	,x_Created_By
	,x_Creation_Date
	,x_Last_Updated_By
	,x_Last_Update_Date
	,x_Last_Update_Login
        ,1
        ,x_srp_role_id
        ,x_role_pmt_plan_id
        ,NVL(x_lock_flag, 'N')
	);

Line: 165


     select 1 INTO l_dummy  from CN_SRP_PMT_PLANS
       where SRP_PMT_PLAN_ID = x_srp_pmt_plan_id;

Line: 168


   END Insert_row;

Line: 209


        SELECT *
          FROM cn_srp_pmt_plans
         WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
           FOR UPDATE of srp_pmt_plan_id NOWAIT;

Line: 221


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

Line: 293


PROCEDURE update_row
   (x_srp_pmt_plan_id        	NUMBER
    ,x_pmt_plan_id              NUMBER
    ,x_salesrep_id              NUMBER
    ,x_org_id                   NUMBER
    ,x_role_id                  NUMBER
    ,x_credit_type_id           NUMBER
    ,x_start_date		DATE
    ,x_end_date		        DATE
    ,x_minimum_amount           NUMBER
    ,x_maximum_amount           NUMBER
    ,x_max_recovery_amount      NUMBER
    ,x_attribute_category       VARCHAR2
    ,x_attribute1               VARCHAR2
    ,x_attribute2               VARCHAR2
    ,x_attribute3               VARCHAR2
    ,x_attribute4               VARCHAR2
    ,x_attribute5               VARCHAR2
    ,x_attribute6               VARCHAR2
    ,x_attribute7               VARCHAR2
    ,x_attribute8               VARCHAR2
    ,x_attribute9               VARCHAR2
    ,x_attribute10              VARCHAR2
    ,x_attribute11              VARCHAR2
    ,x_attribute12              VARCHAR2
    ,x_attribute13              VARCHAR2
    ,x_attribute14              VARCHAR2
    ,x_attribute15              VARCHAR2
    ,x_Last_Updated_By          NUMBER
    ,x_Last_Update_Date         DATE
    ,x_Last_Update_Login        NUMBER
    ,x_object_version_number    NUMBER
    ,x_lock_flag 		VARCHAR2  ) IS

   l_pmt_plan_id		cn_srp_pmt_plans.pmt_plan_id%TYPE;

Line: 356


	  SELECT *
	    FROM cn_srp_pmt_plans
	    WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
	    FOR UPDATE of srp_pmt_plan_id NOWAIT;

Line: 368


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

Line: 381


   SELECT
      decode(x_pmt_plan_id,
	     fnd_api.g_miss_num, oldrow.pmt_plan_id,
	     x_pmt_plan_id),
      decode(x_salesrep_id,
	     fnd_api.g_miss_num, oldrow.salesrep_id,
	     x_salesrep_id),
      decode(x_org_id,
	     fnd_api.g_miss_num, oldrow.org_id,
	     x_org_id),
      decode(x_role_id,
	     fnd_api.g_miss_num, oldrow.role_id,
	     x_role_id),
      decode(x_credit_type_id,
	     fnd_api.g_miss_num, oldrow.credit_type_id ,
	     x_credit_type_id),
      decode(x_start_date,
	     fnd_api.g_miss_date, oldrow.start_date,
	     x_start_date),
      decode(x_end_date,
	     fnd_api.g_miss_date, oldrow.end_date,
	     x_end_date),
      decode(x_minimum_amount,
	     fnd_api.g_miss_num, oldrow.minimum_amount,
	     x_minimum_amount),
      decode(x_maximum_amount,
	     fnd_api.g_miss_num, oldrow.maximum_amount,
	     x_maximum_amount),
      decode(x_max_recovery_amount,
	     fnd_api.g_miss_num, oldrow.max_recovery_amount,
	     x_max_recovery_amount),
      decode(x_attribute_category,
	     fnd_api.g_miss_char, oldrow.attribute_category,
	     x_attribute_category),
      decode(x_attribute1,
	     fnd_api.g_miss_char, oldrow.attribute1,
	     x_attribute1),
      decode(x_attribute2,
	     fnd_api.g_miss_char, oldrow.attribute2,
	     x_attribute2),
      decode(x_attribute3,
	     fnd_api.g_miss_char, oldrow.attribute3,
	     x_attribute3),
      decode(x_attribute4,
	     fnd_api.g_miss_char, oldrow.attribute4,
	     x_attribute4),
      decode(x_attribute5,
	     fnd_api.g_miss_char, oldrow.attribute5,
	     x_attribute5),
      decode(x_attribute6,
	     fnd_api.g_miss_char, oldrow.attribute6,
	     x_attribute6),
      decode(x_attribute7,
	     fnd_api.g_miss_char, oldrow.attribute7,
	     x_attribute7),
      decode(x_attribute8,
	     fnd_api.g_miss_char, oldrow.attribute8,
	     x_attribute8),
      decode(x_attribute9,
	     fnd_api.g_miss_char, oldrow.attribute9,
	     x_attribute9),
      decode(x_attribute10,
	     fnd_api.g_miss_char, oldrow.attribute10,
	     x_attribute10),
      decode(x_attribute11,
	     fnd_api.g_miss_char, oldrow.attribute11,
	     x_attribute11),
      decode(x_attribute12,
	     fnd_api.g_miss_char, oldrow.attribute12,
	     x_attribute12),
      decode(x_attribute13,
	     fnd_api.g_miss_char, oldrow.attribute13,
	     x_attribute13),
      decode(x_attribute14,
	     fnd_api.g_miss_char, oldrow.attribute14,
	     x_attribute14),
      decode(x_attribute15,
	     fnd_api.g_miss_char, oldrow.attribute15,
	     x_attribute15),
      decode(x_lock_flag,
	     fnd_api.g_miss_char, oldrow.lock_flag,
	     x_lock_flag)
     INTO
      l_pmt_plan_id,
      l_salesrep_id,
      l_org_id,
      l_role_id,
      l_credit_type_id,
      l_start_date,
      l_end_date,
      l_minimum_amount,
      l_maximum_amount,
      l_max_recovery_amount,
      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,
      l_lock_flag
      FROM dual;

Line: 493


    UPDATE cn_srp_pmt_plans
      SET
      pmt_plan_id               =       l_pmt_plan_id,
      salesrep_id               =       l_salesrep_id,
      org_id                    =       l_org_id,
      role_id                   =       l_role_id,
      credit_type_id            =       l_credit_type_id,
      start_date		=	l_start_date,
      end_date		        =	l_end_date,
      minimum_amount	        =       l_minimum_amount,
      maximum_amount	        =       l_maximum_amount,
      max_recovery_amount	=       l_max_recovery_amount,
      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	        =	x_Last_Update_Date,
      last_updated_by      	=     	x_Last_Updated_By,
      last_update_login    	=     	x_Last_Update_Login,
      object_version_number     =       nvl(X_OBJECT_VERSION_NUMBER,0) + 1,
      lock_flag 		=       l_lock_flag

      WHERE srp_pmt_plan_id  =   x_srp_pmt_plan_id ;

Line: 533


  END Update_row;

Line: 541


  PROCEDURE Delete_row( x_srp_pmt_plan_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_srp_pmt_plans
       WHERE  srp_pmt_plan_id = x_srp_pmt_plan_id;

Line: 550


  END Delete_row;