APPS.CN_PRD_QUOTA_PVT SQL Statements

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

Line: 26

   PROCEDURE update_period_quota (
      p_api_version              IN       NUMBER,
      p_init_msg_list            IN       VARCHAR2 := fnd_api.g_false,
      p_commit                   IN       VARCHAR2 := fnd_api.g_false,
      p_validation_level         IN       NUMBER := fnd_api.g_valid_level_full,
      p_prd_quota                IN OUT NOCOPY prd_quota_rec_type,
      x_return_status            OUT NOCOPY VARCHAR2,
      x_msg_count                OUT NOCOPY NUMBER,
      x_msg_data                 OUT NOCOPY VARCHAR2
   )
   IS
      l_api_name           CONSTANT VARCHAR2 (30) := 'update_period_quota';

Line: 42

         SELECT *
           FROM cn_period_quotas cpq
          WHERE cpq.period_quota_id = p_prd_quota.period_quota_id;

Line: 61

      SAVEPOINT update_prd_quota;

Line: 78

      SELECT COUNT (*)
        INTO l_temp_count
        FROM cn_period_quotas
       WHERE period_quota_id = p_prd_quota.period_quota_id
         AND quota_id = p_prd_quota.quota_id
         AND period_id = p_prd_quota.period_id
         AND org_id = p_prd_quota.org_id;

Line: 129

      p_prd_quota.last_update_date := SYSDATE;

Line: 130

      p_prd_quota.last_update_login := fnd_global.login_id;

Line: 131

      p_prd_quota.last_updated_by := fnd_global.user_id;

Line: 133

      cn_period_quotas_pkg.UPDATE_RECORD (p_period_quota_id             => p_prd_quota.period_quota_id,
                                          p_quota_id                    => p_prd_quota.quota_id,
                                          p_period_id                   => p_prd_quota.period_id,
                                          p_period_target               => p_prd_quota.period_target,
                                          p_period_payment              => p_prd_quota.period_payment,
                                          p_performance_goal            => p_prd_quota.performance_goal,
                                          p_last_update_date            => p_prd_quota.last_update_date,
                                          p_last_update_login           => p_prd_quota.last_update_login,
                                          p_last_updated_by             => p_prd_quota.last_updated_by,
                                          x_itd_target                  => p_prd_quota.itd_target,
                                          x_itd_payment_amount          => p_prd_quota.itd_payment,
                                          x_itd_performance_amount      => p_prd_quota.performance_goal_itd,
                                          x_object_version_number       => p_prd_quota.object_version_number
                                         );

Line: 163

         ROLLBACK TO update_prd_quota;

Line: 168

         ROLLBACK TO update_prd_quota;

Line: 173

         ROLLBACK TO update_prd_quota;

Line: 182

   END update_period_quota;