APPS.CN_MULTI_RATE_SCHEDULES_PUB SQL Statements

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

Line: 14

   select RATE_SCHEDULE_ID into l_rate_schedule_id
     from CN_RATE_SCHEDULES
    where name = p_name;

Line: 33

   select RATE_DIMENSION_ID into l_rate_dimension_id
     from CN_RATE_DIMENSIONS
    where name = p_name;

Line: 52

   select rate_sch_dim_id into l_rate_sch_dim_id
     from cn_rate_sch_dims
    where rate_schedule_id  = p_rate_schedule_id
      and rate_dimension_id = p_rate_dimension_id;

Line: 71

   select CALC_SQL_EXP_ID into l_calc_sql_exp_id
     from CN_CALC_SQL_EXPS
    where name = p_name;

Line: 90

   select rate_dim_tier_id into l_rate_dim_tier_id
     from cn_rate_dim_tiers
    where rate_dimension_id = p_rate_dimension_id
      and tier_sequence     = p_tier_sequence;

Line: 111

   select rdt.rate_dim_tier_id into l_rate_dim_tier_id
     from cn_rate_sch_dims rsd, cn_rate_dim_tiers rdt
     where rsd.rate_schedule_id  = p_rate_schedule_id
       and rsd.rate_dim_sequence = p_rate_dim_sequence
       and rdt.rate_dimension_id = rsd.rate_dimension_id
       and rdt.tier_sequence     = p_tier_sequence;

Line: 346

PROCEDURE Update_Schedule
  (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_original_name              IN      CN_RATE_SCHEDULES.NAME%TYPE,
   p_new_name                   IN      CN_RATE_SCHEDULES.NAME%TYPE :=
                                        cn_api.g_miss_char,
   p_commission_unit_code       IN      CN_RATE_SCHEDULES.COMMISSION_UNIT_CODE%TYPE :=
                                        cn_api.g_miss_char,
   p_object_version_number      IN OUT NOCOPY      CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE,
   p_dims_tbl                   IN      dim_assign_tbl_type := g_miss_dim_assign_tbl,
   -- Start - MOAC Change
   p_org_id                     IN      CN_RATE_SCHEDULES.ORG_ID%TYPE,
   -- End  - MOAC Change
   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_Schedule';

Line: 377

   SAVEPOINT    Update_Schedule;

Line: 399

   SELECT org_id INTO l_org_id
   FROM   cn_rate_schedules
   WHERE  rate_schedule_id = l_rate_schedule_id;

Line: 405

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

Line: 409

                         'cn.plsql.cn_multi_rate_schedule_pub.update_schedule.error',
                         true);

Line: 414

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

Line: 423

   select commission_unit_code into l_original_comm_unit_code
     from cn_rate_schedules
    where rate_schedule_id = l_rate_schedule_id;

Line: 427

   select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
          decode(p_commission_unit_code, cn_api.g_miss_char,
		 l_original_comm_unit_code, p_commission_unit_code)
     into l_name, l_comm_unit_code from dual;

Line: 442

				'UPDATE_SCHEDULE', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_PRE
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_commission_unit_code     => p_commission_unit_code,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 456

				'UPDATE_SCHEDULE', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_SCHEDULE_PRE
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_commission_unit_code     => p_commission_unit_code,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 469

   CN_MULTI_RATE_SCHEDULES_PVT.Update_Schedule
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_schedule_id           => l_rate_schedule_id,
      p_name                       => l_name,
      p_commission_unit_code       => l_comm_unit_code,
      p_number_dim                 => null, -- not used
      -- Start - R12 MOAC Changes
      p_org_id                     => p_org_id,
      -- End  - R12 MOAC Changes
      p_object_version_number      => p_object_version_number,
      p_dims_tbl                   => l_dims_tbl,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 490

				'UPDATE_SCHEDULE', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_SCHEDULE_POST
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_commission_unit_code     => p_commission_unit_code,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 504

				'UPDATE_SCHEDULE', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_SCHEDULE_POST
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_commission_unit_code     => p_commission_unit_code,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 530

      ROLLBACK TO Update_Schedule;

Line: 537

      ROLLBACK TO Update_Schedule;

Line: 544

      ROLLBACK TO Update_Schedule;

Line: 557

END Update_Schedule;

Line: 560

PROCEDURE Delete_Schedule
  (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_name                       IN      CN_RATE_SCHEDULES.NAME%TYPE,
   -- Start - R12 MOAC Changes
   p_object_version_number      IN      CN_RATE_SCHEDULES.OBJECT_VERSION_NUMBER%TYPE, -- new
   -- End  - R12 MOAC Changes
   x_return_status              OUT NOCOPY     VARCHAR2,
   x_msg_count                  OUT NOCOPY     NUMBER,
   x_msg_data                   OUT NOCOPY     VARCHAR2) IS

   l_rate_schedule_id      CN_RATE_SCHEDULES.RATE_SCHEDULE_ID%TYPE := 0;

Line: 574

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

Line: 578

   SAVEPOINT   Delete_Schedule;

Line: 601

				'DELETE_SCHEDULE', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_PRE
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 612

				'DELETE_SCHEDULE', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_SCHEDULE_PRE
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 622

   CN_MULTI_RATE_SCHEDULES_PVT.Delete_Schedule
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_schedule_id           => l_rate_schedule_id,
      -- Start - R12 MOAC Changes
      p_object_version_number      => p_object_version_number,
      -- End  - R12 MOAC Changes
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 638

				'DELETE_SCHEDULE', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_SCHEDULE_POST
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 649

				'DELETE_SCHEDULE', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_SCHEDULE_POST
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 672

      ROLLBACK TO Delete_Schedule;

Line: 679

      ROLLBACK TO Delete_Schedule;

Line: 686

      ROLLBACK TO Delete_Schedule;

Line: 699

END Delete_Schedule;

Line: 875

PROCEDURE Update_Dimension_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_rate_schedule_name         IN      CN_RATE_SCHEDULES.NAME%TYPE,
   p_orig_rate_dim_name         IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   p_new_rate_dim_name          IN      CN_RATE_DIMENSIONS.NAME%TYPE := cn_api.g_miss_char,
   p_rate_dim_sequence          IN      CN_RATE_SCH_DIMS.RATE_DIM_SEQUENCE%TYPE :=
                                        cn_api.g_miss_num,
   p_object_version_number      IN OUT NOCOPY     CN_RATE_SCH_DIMS.OBJECT_VERSION_NUMBER%TYPE,
   -- Start - MOAC Change
   p_org_id                     IN      CN_RATE_DIMENSIONS.ORG_ID%TYPE,
   -- End  - MOAC Change
   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_Dimension_Assign';

Line: 904

   SAVEPOINT   Update_Dimension_Assign;

Line: 929

   SELECT org_id INTO l_org_id
   FROM   cn_rate_sch_dims
   WHERE  rate_sch_dim_id = l_rate_sch_dim_id;

Line: 935

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

Line: 939

                         'cn.plsql.cn_multi_rate_schedule_pub.update_dimension_assign.error',
                         true);

Line: 944

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

Line: 952

   select rate_dim_sequence into l_rate_dim_sequence
     from cn_rate_sch_dims
    where rate_sch_dim_id = l_rate_sch_dim_id;

Line: 966

				'UPDATE_DIMENSION_ASSIGN', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_orig_rate_dim_name       => p_orig_rate_dim_name,
	 p_new_rate_dim_name        => p_new_rate_dim_name,
	 p_rate_dim_sequence        => p_rate_dim_sequence,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 981

				'UPDATE_DIMENSION_ASSIGN', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_ASSIGN_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_orig_rate_dim_name       => p_orig_rate_dim_name,
	 p_new_rate_dim_name        => p_new_rate_dim_name,
	 p_rate_dim_sequence        => p_rate_dim_sequence,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 995

   CN_MULTI_RATE_SCHEDULES_PVT.update_dimension_assign
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_sch_dim_id            => l_rate_sch_dim_id,
      p_rate_schedule_id           => l_rate_schedule_id,
      p_rate_dimension_id          => l_rate_dimension_id,
      p_rate_dim_sequence          => l_rate_dim_sequence,
      -- Start - MOAC Change
      p_org_id                     => p_org_id,
      -- End  - MOAC Change
      p_object_version_number      => p_object_version_number,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 1015

				'UPDATE_DIMENSION_ASSIGN', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_ASSIGN_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_orig_rate_dim_name       => p_orig_rate_dim_name,
	 p_new_rate_dim_name        => p_new_rate_dim_name,
	 p_rate_dim_sequence        => p_rate_dim_sequence,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1030

				'UPDATE_DIMENSION_ASSIGN', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_ASSIGN_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_orig_rate_dim_name       => p_orig_rate_dim_name,
	 p_new_rate_dim_name        => p_new_rate_dim_name,
	 p_rate_dim_sequence        => p_rate_dim_sequence,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1057

      ROLLBACK TO Update_Dimension_Assign;

Line: 1064

      ROLLBACK TO Update_Dimension_Assign;

Line: 1071

      ROLLBACK TO Update_Dimension_Assign;

Line: 1084

END Update_Dimension_Assign;

Line: 1086

PROCEDURE Delete_Dimension_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_rate_schedule_name         IN      CN_RATE_SCHEDULES.NAME%TYPE,
   p_rate_dimension_name        IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   -- Start - R12 MOAC Changes
   p_object_version_number      IN      CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
   -- End  - R12 MOAC Changes
   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_Dimension_Assign';

Line: 1107

   SAVEPOINT   Delete_Dimension_Assign;

Line: 1131

				'DELETE_DIMENSION_ASSIGN', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_rate_dimension_name      => p_rate_dimension_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1143

				'DELETE_DIMENSION_ASSIGN', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_ASSIGN_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_rate_dimension_name      => p_rate_dimension_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1154

   CN_MULTI_RATE_SCHEDULES_PVT.delete_dimension_assign
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_sch_dim_id            => l_rate_sch_dim_id,
      p_rate_schedule_id           => l_rate_schedule_id,
      -- Start - R12 MOAC Changes
      p_object_version_number      => p_object_version_number,
      -- End  - R12 MOAC Changes
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 1171

				'DELETE_DIMENSION_ASSIGN', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_ASSIGN_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_rate_dimension_name      => p_rate_dimension_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1183

				'DELETE_DIMENSION_ASSIGN', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_ASSIGN_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_rate_dimension_name      => p_rate_dimension_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1207

      ROLLBACK TO Delete_Dimension_Assign;

Line: 1214

      ROLLBACK TO Delete_Dimension_Assign;

Line: 1221

      ROLLBACK TO Delete_Dimension_Assign;

Line: 1234

END Delete_Dimension_Assign;

Line: 1236

PROCEDURE Update_Rate
  (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_rate_schedule_name         IN      CN_RATE_SCHEDULES.NAME%TYPE,
   p_tier_coordinates_tbl       IN      tier_coordinates_tbl,
   p_commission_amount          IN      CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
   p_object_version_number      IN OUT NOCOPY     CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
   -- Start - MOAC Change
   p_org_id                     IN      CN_RATE_TIERS.ORG_ID%TYPE,
   -- End  - MOAC Change
   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_Rate';

Line: 1266

   SAVEPOINT   Update_Rate;

Line: 1288

   SELECT org_id INTO l_org_id
   FROM   cn_rate_tiers
   WHERE  rate_schedule_id = l_rate_schedule_id;

Line: 1294

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

Line: 1298

                         'cn.plsql.cn_multi_rate_schedule_pub.update_rate.error',
                         true);

Line: 1303

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

Line: 1325

				'UPDATE_RATE', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_tier_coordinates_tbl     => p_tier_coordinates_tbl,
	 p_commission_amount        => p_commission_amount,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1339

				'UPDATE_RATE', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_RATE_PRE
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_tier_coordinates_tbl     => p_tier_coordinates_tbl,
	 p_commission_amount        => p_commission_amount,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1352

   CN_MULTI_RATE_SCHEDULES_PVT.update_rate
     (p_rate_schedule_id           => l_rate_schedule_id,
      p_rate_sequence              => l_rate_sequence,
      p_commission_amount          => p_commission_amount,
      p_object_version_number      => p_object_version_number,
      -- Start - MOAC Change
      p_org_id                     => p_org_id);

Line: 1363

				'UPDATE_RATE', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_RATE_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_tier_coordinates_tbl     => p_tier_coordinates_tbl,
	 p_commission_amount        => p_commission_amount,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1377

				'UPDATE_RATE', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_RATE_POST
	(p_rate_schedule_name       => p_rate_schedule_name,
	 p_tier_coordinates_tbl     => p_tier_coordinates_tbl,
	 p_commission_amount        => p_commission_amount,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1403

      ROLLBACK TO Update_Rate;

Line: 1410

      ROLLBACK TO Update_Rate;

Line: 1417

      ROLLBACK TO Update_Rate;

Line: 1430

END Update_Rate;

Line: 1619

PROCEDURE Update_Dimension
  (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_original_name              IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   p_new_name                   IN      CN_RATE_DIMENSIONS.NAME%TYPE :=
                                        cn_api.g_miss_char,
   p_description                IN      CN_RATE_DIMENSIONS.DESCRIPTION%TYPE :=
                                        cn_api.g_miss_char,
   p_dim_unit_code              IN      CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE :=
                                        cn_api.g_miss_char,
   p_tiers_tbl                  IN      rate_tier_tbl_type :=
                                        g_miss_rate_tier_tbl,
   p_object_version_number      IN OUT NOCOPY     CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
   -- Start - MOAC Change
   p_org_id                     IN      CN_RATE_DIMENSIONS.ORG_ID%TYPE,
   -- End  - MOAC Change
   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_Dimension';

Line: 1653

   select rate_dim_tier_id from cn_rate_dim_tiers
    where rate_dimension_id = p_rate_dimension_id
      and tier_sequence     = p_tier_sequence;

Line: 1659

   SAVEPOINT   Update_Dimension;

Line: 1681

   SELECT org_id INTO l_org_id
   FROM   cn_rate_dimensions
   WHERE  rate_dimension_id = l_rate_dimension_id;

Line: 1687

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

Line: 1691

                         'cn.plsql.cn_multi_rate_schedule_pub.update_dimenstion.error',
                         true);

Line: 1696

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

Line: 1704

   select description into l_description from cn_rate_dimensions
    where rate_dimension_id = l_rate_dimension_id;

Line: 1707

   select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
          decode(p_description, cn_api.g_miss_char, l_description, p_description)
     into l_name, l_description from dual;

Line: 1728

				'UPDATE_DIMENSION', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_PRE
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_description              => p_description,
	 p_dim_unit_code            => p_dim_unit_code,
	 p_tiers_tbl                => p_tiers_tbl,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1744

				'UPDATE_DIMENSION', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_PRE
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_description              => p_description,
	 p_dim_unit_code            => p_dim_unit_code,
	 p_tiers_tbl                => p_tiers_tbl,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1759

   CN_RATE_DIMENSIONS_PVT.Update_Dimension
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_dimension_id          => l_rate_dimension_id,
      p_name                       => l_name,
      p_description                => l_description,
      p_dim_unit_code              => p_dim_unit_code,
      p_number_tier                => l_tiers_tbl.count,
      p_tiers_tbl                  => l_tiers_tbl,
      -- Start - MOAC Change
      p_org_id                     => p_org_id,
      -- End  - MOAC Change
      p_object_version_number      => p_object_version_number,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 1781

				'UPDATE_DIMENSION', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_DIMENSION_POST
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_description              => p_description,
	 p_dim_unit_code            => p_dim_unit_code,
	 p_tiers_tbl                => p_tiers_tbl,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1797

				'UPDATE_DIMENSION', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_DIMENSION_POST
	(p_original_name            => p_original_name,
	 p_new_name                 => p_new_name,
	 p_description              => p_description,
	 p_dim_unit_code            => p_dim_unit_code,
	 p_tiers_tbl                => p_tiers_tbl,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1825

      ROLLBACK TO Update_Dimension;

Line: 1832

      ROLLBACK TO Update_Dimension;

Line: 1839

      ROLLBACK TO Update_Dimension;

Line: 1852

END Update_Dimension;

Line: 1854

PROCEDURE Delete_Dimension
  (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_name                       IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   -- Start - R12 MOAC Changes
   p_object_version_number      IN      CN_RATE_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE, -- new
   -- End  - R12 MOAC Changes
   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_Dimension';

Line: 1873

   SAVEPOINT   Delete_Dimension;

Line: 1895

				'DELETE_DIMENSION', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_PRE
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1906

				'DELETE_DIMENSION', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_PRE
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1916

   CN_RATE_DIMENSIONS_PVT.Delete_Dimension
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_dimension_id          => l_rate_dimension_id,
      -- Start - MOAC Change
      p_object_version_number      => p_object_version_number,
      -- End  - MOAC Change
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 1932

				'DELETE_DIMENSION', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_DIMENSION_POST
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1943

				'DELETE_DIMENSION', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_DIMENSION_POST
	(p_name                     => p_name,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 1966

      ROLLBACK TO Delete_Dimension;

Line: 1973

      ROLLBACK TO Delete_Dimension;

Line: 1980

      ROLLBACK TO Delete_Dimension;

Line: 1993

END Delete_Dimension;

Line: 2061

   select dim_unit_code into l_dim_unit_code from cn_rate_dimensions
    where rate_dimension_id = l_rate_dimension_id;

Line: 2188

PROCEDURE Update_Tier
  (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_dimension_name             IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   p_tier_sequence              IN      CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
   p_value1                     IN      VARCHAR2,
   p_value2                     IN      VARCHAR2,
   p_object_version_number      IN OUT NOCOPY     CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE,
   -- Start - MOAC Change
   p_org_id                     IN      CN_RATE_TIERS.ORG_ID%TYPE,
   -- End  - MOAC Change
   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_Tier';

Line: 2220

   SAVEPOINT   Update_tier;

Line: 2243

   SELECT org_id INTO l_org_id
   FROM   cn_rate_dim_tiers
   WHERE  rate_dim_tier_id = l_rate_dim_tier_id;

Line: 2249

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

Line: 2253

                         'cn.plsql.cn_multi_rate_schedule_pub.update_tier.error',
                         true);

Line: 2258

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

Line: 2267

   select dim_unit_code into l_dim_unit_code from cn_rate_dimensions
    where rate_dimension_id = l_rate_dimension_id;

Line: 2274

				'UPDATE_TIER', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_PRE
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 p_value1                   => p_value1,
	 p_value2                   => p_value2,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2289

				'UPDATE_TIER', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_TIER_PRE
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 p_value1                   => p_value1,
	 p_value2                   => p_value2,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2303

   CN_RATE_DIMENSIONS_PVT.update_tier
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_dim_tier_id           => l_rate_dim_tier_id,
      p_rate_dimension_id          => l_rate_dimension_id,
      p_dim_unit_code              => l_dim_unit_code,
      p_minimum_amount             => l_minimum_amount,
      p_maximum_amount             => l_maximum_amount,
      p_min_exp_id                 => l_min_exp_id,
      p_max_exp_id                 => l_max_exp_id,
      p_string_value               => l_string_value,
      p_tier_sequence              => p_tier_sequence,
      p_object_version_number      => p_object_version_number,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 2325

				'UPDATE_TIER', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.UPDATE_TIER_POST
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 p_value1                   => p_value1,
	 p_value2                   => p_value2,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2340

				'UPDATE_TIER', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.UPDATE_TIER_POST
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 p_value1                   => p_value1,
	 p_value2                   => p_value2,
	 p_object_version_number    => p_object_version_number,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2367

      ROLLBACK TO Update_tier;

Line: 2374

      ROLLBACK TO Update_tier;

Line: 2381

      ROLLBACK TO Update_tier;

Line: 2394

END Update_tier;

Line: 2396

PROCEDURE Delete_Tier
  (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_dimension_name             IN      CN_RATE_DIMENSIONS.NAME%TYPE,
   p_tier_sequence              IN      CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE,
   -- Start - R12 MOAC Changes
   p_object_version_number      IN      CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- new
   -- End  - R12 MOAC Changes
   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_Tier';

Line: 2416

   SAVEPOINT   Delete_Tier;

Line: 2439

				'DELETE_TIER', 'B', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_PRE
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2451

				'DELETE_TIER', 'B', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_TIER_PRE
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2462

   CN_RATE_DIMENSIONS_PVT.delete_tier
     (p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_rate_dim_tier_id           => l_rate_dim_tier_id,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data);

Line: 2475

				'DELETE_TIER', 'A', 'V') then
      CN_MULTI_RATE_SCHEDULES_VUHK.DELETE_TIER_POST
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2487

				'DELETE_TIER', 'A', 'C') then
      CN_MULTI_RATE_SCHEDULES_CUHK.DELETE_TIER_POST
	(p_dimension_name           => p_dimension_name,
	 p_tier_sequence            => p_tier_sequence,
	 x_return_status            => x_return_status,
	 x_msg_count                => x_msg_count,
	 x_msg_data                 => x_msg_data);

Line: 2511

      ROLLBACK TO Delete_Tier;

Line: 2518

      ROLLBACK TO Delete_Tier;

Line: 2525

      ROLLBACK TO Delete_Tier;

Line: 2538

END Delete_Tier;