APPS.CN_SRP_PRD_QUOTA_PUB SQL Statements

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

Line: 56

     G_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 57

     G_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 60

     G_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 73

      SELECT *
      from cn_quotas
      where name = p_quota_name AND delete_flag = 'N';

Line: 79

      SELECT *
      from cn_salesreps
	where name = p_salesrep_name
	and employee_number = p_employee_number
	AND org_id = l_org_id;

Line: 86

      SELECT *
      from cn_roles
      where name = p_role_name;

Line: 91

      SELECT *
      from cn_comp_plans
	where name = p_comp_plan_name
	  AND org_id = l_org_id;

Line: 101

      SELECT *
      from cn_srp_plan_assigns
      where salesrep_id = p_salesrep_id
        and role_id = p_role_id
        and comp_plan_id = p_comp_plan_id
        and start_date =  p_srp_plan_sd
        and end_date = p_srp_plan_ed
	AND org_id   = l_org_id;

Line: 112

      SELECT *
      from cn_srp_quota_assigns
	where srp_plan_assign_id = p_srp_plan_assign_id
	and quota_id = p_quota_id;

Line: 118

	  SELECT *
	  FROM cn_srp_period_quotas_v
	  WHERE srp_quota_assign_id = p_srp_quota_assign_id;

Line: 123

      SELECT *
      from cn_quotas
      where quota_id = p_quota_id AND delete_flag = 'N';

Line: 129

      select *
	from cn_srp_period_quotas_v
	where srp_quota_assign_id = p_srp_quota_assign_id
	and period_id = p_period_id;

Line: 135

       select *
	 from cn_period_statuses
	 where period_name = p_period_name
	   AND org_id = l_org_id;

Line: 350

   select nvl(target, 0)
     into f_target_amount
     from cn_srp_quota_assigns
     where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 363

      select nvl(target, 0)
	into f_target_amount
	from cn_srp_quota_assigns
	where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 378

   select nvl(payment_amount, 0)
     into f_fixed_amount
     from cn_srp_quota_assigns
     where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 386

      select nvl(payment_amount, 0)
	into f_fixed_amount
	from cn_srp_quota_assigns
	where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 401

   select nvl(performance_goal, 0)
     into f_performance_goal
     from cn_srp_quota_assigns
     where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 410

       select nvl(performance_goal, 0)
	 into f_performance_goal
	 from cn_srp_quota_assigns
	 where srp_quota_assign_id = l_srp_quota_assign_id;

Line: 428

      CN_SRP_CUSTOMIZE_PUB.update_srp_quota_assign
	(p_api_version           	=> 1.0,
	 p_init_msg_list		        => 'T',
	 p_commit	    		    => 'F',
	 p_validation_level	     	=> 100,
	 p_srp_quota_assign_id       => l_srp_quota_assign_id,
	 p_customized_flag           => l_customized_flag,
	 p_quota                     => f_target_amount,
	 p_fixed_amount              => f_fixed_amount,
	 p_goal                      => f_performance_goal,
	 x_return_status		        => l_return_status,
	 x_msg_count			=> l_msg_count,
	 x_msg_data			=> l_msg_data,
	 x_loading_status		=> l_loading_status,
	 x_status                => l_status);

Line: 459

	-- 4. IF not evenly distributed, we update the cn_period_quotas using the values in the table.
    ELSE --IF p_even_distribute = 'Y' THEN

      IF p_srp_prd_quota_tbl.COUNT > 0 THEN

	 FOR i IN 1 .. p_srp_prd_quota_tbl.COUNT  LOOP

	    IF  p_srp_prd_quota_tbl(i).period_name IS NULL
	      THEN
	       IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
		  FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

Line: 509

	    select commission_payed_ptd
	      into l_commission_payed_ptd
	      from cn_srp_period_quotas
	      where srp_period_quota_id =  tbl_srp_period_quota_id;

Line: 515

	      (x_operation  	     	=> 'UPDATE'
	       ,x_period_target_unit_code	=> f_srp_quota_assign_id_rec.period_target_unit_code
	       ,x_srp_period_quota_id 	=> tbl_srp_period_quota_id
	       ,x_srp_quota_assign_id 	=> l_srp_quota_assign_id
	       ,x_srp_plan_assign_id  	=> l_srp_plan_assign_id
	       ,x_quota_id            	=> l_quota_id
	       ,x_period_id           	=> tbl_period_id
	       ,x_target_amount       	=> p_srp_prd_quota_tbl(i).PERIOD_TARGET
	       ,x_period_payment		=>p_srp_prd_quota_tbl(i).PERIOD_PAYMENT
	       ,x_performance_goal          => p_srp_prd_quota_tbl(i).PERFORMANCE_GOAL
	       ,x_quarter_num	     	=> tbl_quarter_num
	       ,x_period_year 	    => tbl_period_year
	       ,x_quota_type_code     => f_srp_quota_assign_id_rec.quota_type_code
	       ,x_salesrep_id            => l_salesrep_id
	       ,x_end_date               => NULL
	       ,x_commission_payed_ptd   => l_commission_payed_ptd
	       ,x_creation_date		=> sysdate
	       ,x_created_by			=> fnd_global.user_id
	      ,x_last_update_date	=> sysdate
	      ,x_last_updated_by		=> fnd_global.user_id
	      ,x_last_update_login	=> fnd_global.login_id);