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

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

Line: 6


PROCEDURE Update_srp_quota_assign(
        p_api_version           	IN	NUMBER,
  	p_init_msg_list		        IN	VARCHAR2,
	p_commit	    		IN  	VARCHAR2,
	p_validation_level		IN  	NUMBER,
        p_srp_quota_assign_id           IN      NUMBER,
        p_customized_flag               IN      VARCHAR2,
        p_quota                         IN      NUMBER,
        p_fixed_amount                  IN      NUMBER,
        p_goal                          IN      NUMBER,
	x_return_status		        OUT NOCOPY VARCHAR2,
	x_msg_count		        OUT NOCOPY NUMBER,
	x_msg_data		        OUT NOCOPY VARCHAR2,
        x_loading_status	        OUT NOCOPY     VARCHAR2,
	x_status                        OUT NOCOPY     VARCHAR2
        ) IS

   l_api_name		CONSTANT VARCHAR2(30) := 'Update_srp_quota_assign';

Line: 41


   SAVEPOINT    update_srp_quota_assign;

Line: 65


   x_loading_status := 'CN_UPDATED';

Line: 67


   select customized_flag
          ,target
          ,period_target_dist_rule_code
          ,period_target_unit_code
          ,payment_amount
          ,performance_goal
          ,quota_id
          ,org_id
         into
          l_customized_flag_old
         ,l_target_old
         ,l_ptdr_code_old
         ,l_ptu_code_old
         ,l_payment_amount_old
         ,l_performance_goal_old
         ,l_quota_id
         ,l_org_id
   from cn_srp_quota_assigns_all
  where srp_quota_assign_id = p_srp_quota_assign_id;

Line: 94


		     'cn.plsql.cn_srp_customize_pub.update_srp_quota_assign.org_validate',
                     'Validated org_id = ' || l_org_id || ' status = ' || l_status);

Line: 99


   cn_srp_quota_assigns_pkg.update_record(
                  p_srp_quota_assign_id
 	         ,p_quota
 		 ,l_target_old
 		 ,null       --x_start_period_id
 		 ,null       --x_salesrep_id NUMBER
 		 ,p_customized_flag
 		 ,l_customized_flag_old
 		 ,l_quota_id
 		 ,null       --x_rate_schedule_id
 		 ,l_ptdr_code_old
 		 ,null       --x_attributes_changed		 VARCHAR2
 		 ,null       --x_distribute_target_flag
 		 ,p_fixed_amount  --x_payment_amount		 NUMBER
 		 ,l_payment_amount_old
                 ,p_goal
 		 ,l_performance_goal_old
 	         ,l_ptu_code_old
 	         ,l_ptu_code_old
 		 ,Sysdate            --g_last_update_date
 		 ,fnd_global.user_id --g_last_updated_by
 		 ,fnd_global.login_id); -- g_last_update_login);

Line: 139


    ROLLBACK TO update_srp_quota_assign;

Line: 148


    ROLLBACK TO update_srp_quota_assign;

Line: 158


     ROLLBACK TO update_srp_quota_assign;

Line: 171


END Update_srp_quota_assign;

Line: 228


   x_loading_status := 'CN_UPDATED';

Line: 233


  select customized_flag
         ,quota_id
         ,target
         ,period_target_dist_rule_code
         ,period_target_unit_code
         ,payment_amount
         ,performance_goal
         ,org_id
      into l_customized_flag_old
          ,l_quota_id
          ,l_target_old
          ,l_ptdr_code_old
          ,l_ptu_code_old
          ,l_payment_amount_old
          ,l_performance_goal_old
          ,l_org_id
     from cn_srp_quota_assigns_all
    where srp_quota_assign_id = p_srp_quota_assign_id;

Line: 263


   cn_srp_quota_assigns_pkg.update_record(
                 p_srp_quota_assign_id
 	         ,nvl(l_target_old,0)
 		 ,nvl(l_target_old,0)
 		 ,null       --x_start_period_id
 		 ,null       --x_salesrep_id NUMBER
 		 ,p_customized_flag
 		 ,l_customized_flag_old
 		 ,l_quota_id
 		 ,null       --x_rate_schedule_id
 		 ,l_ptdr_code_old
 		 ,null       --x_attributes_changed		 VARCHAR2
 		 ,null       --x_distribute_target_flag
 		 ,l_payment_amount_old
 		 ,l_payment_amount_old
                 ,l_performance_goal_old
 		 ,l_performance_goal_old
 	         ,l_ptu_code_old
 	         ,l_ptu_code_old
 		 ,Sysdate --g_last_update_date
 		 ,fnd_global.user_id --g_last_updated_by
 		 ,fnd_global.login_id); --g_last_update_login);

Line: 338


PROCEDURE Update_Srp_Quota_Rules(
        p_api_version           	IN	NUMBER,
  	p_init_msg_list		        IN	VARCHAR2,
	p_commit	    		IN  	VARCHAR2,
	p_validation_level		IN  	NUMBER,
        p_quota_rule_id                 IN      NUMBER,
        p_srp_quota_rule_id             IN      NUMBER,
        p_target                        IN      NUMBER,
        p_payment_amount                IN      NUMBER,
        p_performance_goal              IN      NUMBER,
	x_return_status		        OUT NOCOPY VARCHAR2,
	x_msg_count		 OUT NOCOPY NUMBER,
	x_msg_data		 OUT NOCOPY VARCHAR2,
        x_loading_status	 OUT NOCOPY     VARCHAR2
        ) IS
   l_api_name		CONSTANT VARCHAR2(30) := 'Update_srp_quota_rules';

Line: 363


   SAVEPOINT    update_srp_quota_rules;

Line: 387


   x_loading_status := 'CN_UPDATED';

Line: 389


   SELECT org_id INTO l_org_id
     FROM cn_srp_quota_rules_all
    WHERE srp_quota_rule_id = p_srp_quota_rule_id;

Line: 400


		     'cn.plsql.cn_srp_customize_pub.update_srp_quota_rules.org_validate',
		     'Validated org_id = ' || l_org_id || ' status = ' || l_status);

Line: 404


   cn_srp_quota_rules_pkg.update_record(
              x_quota_rule_id => p_quota_rule_id,
              x_srp_quota_rule_id => p_srp_quota_rule_id,
              x_target => p_target,
              x_payment_amount => p_payment_amount,
              x_performance_goal => p_performance_goal);

Line: 428


    ROLLBACK TO Update_Srp_Quota_Rules;

Line: 437


    ROLLBACK TO Update_Srp_Quota_Rules;

Line: 447


     ROLLBACK TO Update_Srp_Quota_Rules;

Line: 461


END Update_Srp_Quota_Rules;

Line: 464


PROCEDURE Update_Srp_Rule_Uplifts
  (p_api_version           	IN	NUMBER,
   p_init_msg_list		        IN	VARCHAR2,
   p_commit	    		IN  	VARCHAR2,
   p_validation_level		IN  	NUMBER,

   p_srp_rule_uplift_id             IN      NUMBER,
   p_payment_factor                 IN      NUMBER,
   p_quota_factor                   IN      NUMBER,

   x_return_status		        OUT NOCOPY VARCHAR2,
   x_msg_count		 OUT NOCOPY NUMBER,
   x_msg_data		 OUT NOCOPY VARCHAR2,
   x_loading_status	 OUT NOCOPY     VARCHAR2
   ) IS

   l_api_name		CONSTANT VARCHAR2(30) := 'Update_Srp_Rule_Uplifts';

Line: 490


   SAVEPOINT    update_srp_rule_uplifts;

Line: 514


   x_loading_status := 'CN_UPDATED';

Line: 516


   SELECT org_id INTO l_org_id
     FROM cn_srp_rule_uplifts_all
    WHERE srp_rule_uplift_id = p_srp_rule_uplift_id;

Line: 527


		     'cn.plsql.cn_srp_customize_pub.update_srp_rule_uplifts.org_validate',
		     'Validated org_id = ' || l_org_id || ' status = ' || l_status);

Line: 532


   cn_srp_rule_uplifts_pkg.update_record
     (p_srp_rule_uplift_id         => p_srp_rule_uplift_id
      ,p_payment_factor            => p_payment_factor
      ,p_quota_factor              => p_quota_factor
      ,p_last_update_date	   => sysdate
      ,p_last_updated_by	   => fnd_global.user_id
      ,p_last_update_login	   => fnd_global.login_id);

Line: 558


    ROLLBACK TO Update_Srp_Rule_Uplifts;

Line: 567


    ROLLBACK TO Update_Srp_Rule_Uplifts;

Line: 577


     ROLLBACK TO Update_Srp_Rule_Uplifts;

Line: 591


END Update_Srp_Rule_Uplifts;