APPS.CN_QUOTA_ASSIGN_PUB SQL Statements

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

Line: 5

G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 6

G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 9

G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 33

     SELECT comp_plan_id
       FROM cn_comp_plans
       WHERE name = p_plan_name
       and org_id = p_org_id;

Line: 56

     SELECT quota_id
       FROM cn_quotas_v
       WHERE name = p_element_name and org_id = p_org_id;

Line: 252

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_rec          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)
     := 'Update_Quota_Assign';

Line: 276

     SELECT quota_assign_id, object_version_number, org_id
       FROM cn_quota_assigns
       WHERE comp_plan_id = p_cp_id
       AND quota_id = p_pe_id;

Line: 288

   SAVEPOINT   Update_Quota_Assign_Pub;

Line: 312

                      'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.org_validate',
                        'Validated org_id = ' || l_org_id || ' status = '|| l_status);

Line: 346

       FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 349

                         'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.error',
                         true);

Line: 354

         FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 387

   cn_quota_assign_pvt.update_quota_assign
     ( p_api_version           =>1.0,
     p_init_msg_list         => FND_API.G_FALSE,
     p_commit                => FND_API.G_FALSE,
     p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
     p_quota_assign          => l_pvt_quota_assign_rec,
     x_return_status         => l_return_status,
     x_msg_count             => l_msg_count,
     x_msg_data              => l_msg_data);

Line: 421

     ROLLBACK TO Update_Quota_Assign_Pub;

Line: 428

     ROLLBACK TO Update_Quota_Assign_Pub;

Line: 435

     ROLLBACK TO Update_Quota_Assign_Pub;

Line: 448

END Update_Quota_Assign;

Line: 473

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_rec            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: 496

     SELECT quota_assign_id, object_version_number, org_id
       FROM cn_quota_assigns
       WHERE comp_plan_id = p_cp_id
       AND quota_id = p_pe_id;

Line: 507

   SAVEPOINT   Delete_Quota_Assign_Pub;

Line: 530

                      'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.org_validate',
                        'Validated org_id = ' || l_org_id || ' status = '|| l_status);

Line: 551

	  FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 554

			    'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.error',
			    true);

Line: 559

	    FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 582

   cn_quota_assign_pvt.delete_quota_assign
     ( p_api_version           =>1.0,
     p_init_msg_list         => FND_API.G_FALSE,
     p_commit                => FND_API.G_FALSE,
     p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
     p_quota_assign          => l_pvt_quota_assign_rec,
     x_return_status         => l_return_status,
     x_msg_count             => l_msg_count,
     x_msg_data              => l_msg_data);

Line: 616

     ROLLBACK TO Delete_Quota_Assign_Pub;

Line: 623

     ROLLBACK TO Delete_Quota_Assign_Pub;

Line: 630

     ROLLBACK TO Delete_Quota_Assign_Pub;

Line: 643

END Delete_Quota_Assign;