APPS.CN_QUOTA_ASSIGN_PVT SQL Statements

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

Line: 55

      SELECT object_version_number
      FROM   cn_quota_assigns
      WHERE  quota_assign_id = p_quota_assign.quota_assign_id;

Line: 102

      SELECT COUNT (1)
        INTO l_temp_count
        FROM cn_quota_assigns
       WHERE comp_plan_id = p_quota_assign.comp_plan_id
         AND quota_id = p_quota_assign.quota_id
         AND ROWNUM = 1;

Line: 126

      SELECT COUNT (1)
        INTO l_temp_count
        FROM cn_comp_plans c, cn_quotas_v q
       WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
         AND q.quota_id = p_quota_assign.quota_id
         AND GREATEST (c.start_date, q.start_date) <=
                LEAST (NVL (c.end_date, g_end_of_time),
                       NVL (q.end_date, g_end_of_time)
                      );

Line: 165

         SELECT COUNT (1)
           INTO l_temp_count
           FROM cn_quota_assigns
          WHERE comp_plan_id = p_quota_assign.comp_plan_id
            AND quota_id = l_quota_tbl (i)
            AND quota_sequence < p_quota_assign.quota_sequence;

Line: 187

      SELECT DECODE (p_quota_assign.quota_id,
                     fnd_api.g_miss_num, NULL,
                     p_quota_assign.quota_id
                    ),
             DECODE (p_quota_assign.comp_plan_id,
                     fnd_api.g_miss_num, NULL,
                     p_quota_assign.comp_plan_id
                    ),
             DECODE (p_quota_assign.org_id,
                     fnd_api.g_miss_num, NULL,
                     p_quota_assign.org_id
                    )
        INTO l_quota_id,
             l_comp_plan_id,
             l_org_id
        FROM DUAL;

Line: 205

                           (x_operation            => 'INSERT',
                            x_quota_id             => l_quota_id,
                            x_comp_plan_id         => l_comp_plan_id,
                            x_quota_assign_id      => p_quota_assign.quota_assign_id,
                            x_quota_sequence       => p_quota_assign.quota_sequence,
                            x_quota_id_old         => NULL,
                            x_org_id               => l_org_id
                           );

Line: 223

         SELECT NAME
           INTO l_pe_name
           FROM cn_quotas_all
          WHERE quota_id = l_quota_id;

Line: 228

         SELECT NAME
           INTO l_cp_name
           FROM cn_comp_plans
          WHERE comp_plan_id = l_comp_plan_id;

Line: 325

   PROCEDURE update_quota_assign (
      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_quota_assign       IN OUT NOCOPY   quota_assign_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_Quota_Assign';

Line: 342

         SELECT *
           FROM cn_quota_assigns
          WHERE quota_assign_id = p_quota_assign.quota_assign_id;

Line: 347

      SELECT object_version_number
      FROM   cn_quota_assigns
      WHERE  quota_assign_id = p_quota_assign.quota_assign_id;

Line: 370

      SAVEPOINT update_quota_assign;

Line: 407

    select count(1) into l_temp_count from cn_quota_assigns  where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

Line: 411

        select QUOTA_SEQUENCE into old_seq from cn_quota_assigns  where quota_id = p_quota_assign.quota_id and comp_plan_id = p_quota_assign.comp_plan_id;

Line: 418

      SELECT COUNT (1)
        INTO l_temp_count
        FROM cn_quota_assigns
       WHERE comp_plan_id = p_quota_assign.comp_plan_id
         AND quota_id = p_quota_assign.quota_id
         AND quota_assign_id <> p_quota_assign.quota_assign_id
         AND ROWNUM = 1;

Line: 449

      SELECT DECODE (p_quota_assign.comp_plan_id,
                     fnd_api.g_miss_num, l_old_quota_assign.comp_plan_id,
                     p_quota_assign.comp_plan_id
                    ),
             DECODE (p_quota_assign.quota_id,
                     fnd_api.g_miss_num, l_old_quota_assign.quota_id,
                     p_quota_assign.quota_id
                    ),
             p_quota_assign.quota_assign_id,
             DECODE (p_quota_assign.org_id,
                     fnd_api.g_miss_num, l_old_quota_assign.org_id,
                     p_quota_assign.org_id
                    )
        INTO l_comp_plan_id,
             l_quota_id,
             l_quota_assign_id,
             l_org_id
        FROM DUAL;

Line: 469

      SELECT COUNT (1)
        INTO l_temp_count
        FROM cn_comp_plans c, cn_quotas_v q
       WHERE c.comp_plan_id = p_quota_assign.comp_plan_id
         AND q.quota_id = p_quota_assign.quota_id
         AND GREATEST (c.start_date, q.start_date) <=
                LEAST (NVL (c.end_date, g_end_of_time),
                       NVL (q.end_date, g_end_of_time)
                      );

Line: 509

         SELECT COUNT (1)
           INTO l_temp_count
           FROM cn_quota_assigns
          WHERE comp_plan_id = p_quota_assign.comp_plan_id
            AND quota_id = l_quota_tbl (i)
            AND quota_sequence < p_quota_assign.quota_sequence;

Line: 540

                           (x_operation            => 'UPDATE',
                            x_quota_id             => l_quota_id,
                            x_comp_plan_id         => l_comp_plan_id,
                            x_quota_assign_id      => p_quota_assign.quota_assign_id,
                            x_quota_sequence       => p_quota_assign.quota_sequence,
                            x_quota_id_old         => l_old_quota_assign.quota_id,
                            x_org_id               => l_org_id
                           );

Line: 559

           SELECT NAME
           INTO l_pe_name
           FROM cn_quotas_all
          WHERE quota_id = l_quota_id;

Line: 564

         SELECT NAME
           INTO l_cp_name
           FROM cn_comp_plans
          WHERE comp_plan_id = l_comp_plan_id;

Line: 578

         SELECT NAME
           INTO l_pe_name
           FROM cn_quotas_all
          WHERE quota_id = l_quota_id;

Line: 583

         SELECT NAME
           INTO l_cp_name
           FROM cn_comp_plans
          WHERE comp_plan_id = l_comp_plan_id;

Line: 609

         SELECT NAME
           INTO l_pe_name
           FROM cn_quotas_all
          WHERE quota_id = l_old_quota_assign.quota_id;

Line: 670

         ROLLBACK TO update_quota_assign;

Line: 678

         ROLLBACK TO update_quota_assign;

Line: 686

         ROLLBACK TO update_quota_assign;

Line: 698

   END update_quota_assign;

Line: 721

   PROCEDURE delete_quota_assign (
      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_quota_assign       IN              quota_assign_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)         := 'Delete_Quota_Assign';

Line: 746

      SAVEPOINT delete_quota_assign;

Line: 771

         SELECT quota_assign_id, quota_id, comp_plan_id, org_id
           INTO l_quota_assign_id, l_quota_id, l_comp_plan_id, l_org_id
           FROM cn_quota_assigns
          WHERE quota_assign_id = p_quota_assign.quota_assign_id;

Line: 778

            fnd_message.set_name ('CN', 'CN_RECORD_DELETED');

Line: 784

                                      (x_operation            => 'DELETE',
                                       x_quota_id             => l_quota_id,
                                       x_comp_plan_id         => l_comp_plan_id,
                                       x_quota_assign_id      => l_quota_assign_id,
                                       x_quota_sequence       => NULL,
                                       x_quota_id_old         => NULL,
                                       x_org_id               => l_org_id
                                      );

Line: 802

         SELECT NAME
           INTO l_pe_name
           FROM cn_quotas_all
          WHERE quota_id = l_quota_id;

Line: 807

         SELECT NAME
           INTO l_cp_name
           FROM cn_comp_plans
          WHERE comp_plan_id = l_comp_plan_id;

Line: 846

         ROLLBACK TO delete_quota_assign;

Line: 854

         ROLLBACK TO delete_quota_assign;

Line: 862

         ROLLBACK TO delete_quota_assign;

Line: 874

   END delete_quota_assign;

Line: 917

         SELECT   q.NAME, q.description, q.start_date, q.end_date,
                  qa.quota_assign_id, qa.quota_id, qa.comp_plan_id,
                  NVL (qa.quota_sequence, 0) quota_sequence,
                  qa.object_version_number, qa.org_id
             FROM cn_quota_assigns qa, cn_quotas_v q
            WHERE qa.comp_plan_id = p_comp_plan_id
              AND qa.quota_id = q.quota_id
         ORDER BY quota_sequence;