DBA Data[Home] [Help]

APPS.AMS_ACT_MARKET_SEGMENTS_PVT SQL Statements

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

Line: 37

    SELECT AMS_ACT_MARKET_SEGMENTS_S.NEXTVAL
    FROM DUAL;
Line: 41

    SELECT COUNT(*)
    FROM AMS_ACT_MARKET_SEGMENTS
    WHERE activity_market_segment_id = mks_id;
Line: 96

  AMS_Utility_PVT.debug_message(l_full_name || ': insert');
Line: 112

  INSERT INTO AMS_ACT_MARKET_SEGMENTS
  (
    activity_market_segment_id,
    last_update_date,
    last_updated_by,
    creation_date,
    created_by,
    market_segment_id,
    act_market_segment_used_by_id,
    arc_act_market_segment_used_by,
    segment_type,
    last_update_login,
    object_version_number,
    attribute_category,
    attribute1,
    attribute2,
    attribute3,
    attribute4,
    attribute5,
    attribute6,
    attribute7,
    attribute8,
    attribute9,
    attribute10,
    attribute11,
    attribute12,
    attribute13,
    attribute14,
    attribute15,
    group_code,
    exclude_flag
  )
  VALUES
  (
    l_mks_rec.activity_market_segment_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    l_mks_rec.market_segment_id,
    l_mks_rec.act_market_segment_used_by_id,
    l_mks_rec.arc_act_market_segment_used_by,
    l_mks_rec.segment_type,
    FND_GLOBAL.conc_login_id,
    1,
    l_mks_rec.attribute_category,
    l_mks_rec.attribute1,
    l_mks_rec.attribute2,
    l_mks_rec.attribute3,
    l_mks_rec.attribute4,
    l_mks_rec.attribute5,
    l_mks_rec.attribute6,
    l_mks_rec.attribute7,
    l_mks_rec.attribute8,
    l_mks_rec.attribute9,
    l_mks_rec.attribute10,
    l_mks_rec.attribute11,
    l_mks_rec.attribute12,
    l_mks_rec.attribute13,
    l_mks_rec.attribute14,
    l_mks_rec.attribute15,
    l_mks_rec.group_code,
    l_mks_rec.exclude_flag
  );
Line: 263

PROCEDURE update_market_segments
(
  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,
  x_return_status         OUT NOCOPY     VARCHAR2,
  x_msg_count             OUT NOCOPY     NUMBER,
  x_msg_data              OUT NOCOPY     VARCHAR2,

  p_mks_rec               IN      mks_rec_type
)
IS

  l_api_version   CONSTANT NUMBER := 1.0;
Line: 278

  l_api_name      CONSTANT VARCHAR2(30) := 'update_market_segments';
Line: 286

  SAVEPOINT update_market_segments;
Line: 313

         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );
Line: 335

         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );
Line: 365

  AMS_Utility_PVT.debug_message(l_full_name||': update');
Line: 367

  UPDATE AMS_ACT_MARKET_SEGMENTS SET
    last_update_date = SYSDATE,
    last_updated_by = FND_GLOBAL.user_id,
    market_segment_id = l_mks_rec.market_segment_id,
    act_market_segment_used_by_id = l_mks_rec.act_market_segment_used_by_id,
    arc_act_market_segment_used_by = l_mks_rec.arc_act_market_segment_used_by,
    segment_type = l_mks_rec.segment_type,
    last_update_login = FND_GLOBAL.conc_login_id,
    object_version_number = l_mks_rec.object_version_number + 1,
    attribute_category = l_mks_rec.attribute_category,
    attribute1 = l_mks_rec.attribute1,
    attribute2 = l_mks_rec.attribute2,
    attribute3 = l_mks_rec.attribute3,
    attribute4 = l_mks_rec.attribute4,
    attribute5 = l_mks_rec.attribute5,
    attribute6 = l_mks_rec.attribute6,
    attribute7 = l_mks_rec.attribute7,
    attribute8 = l_mks_rec.attribute8,
    attribute9 = l_mks_rec.attribute9,
    attribute10 = l_mks_rec.attribute10,
    attribute11 = l_mks_rec.attribute11,
    attribute12 = l_mks_rec.attribute12,
    attribute13 = l_mks_rec.attribute13,
    attribute14 = l_mks_rec.attribute14,
    attribute15 = l_mks_rec.attribute15,
    group_code = l_mks_rec.group_code,
    exclude_flag        = l_mks_rec.exclude_flag
  WHERE activity_market_segment_id = l_mks_rec.activity_market_segment_id
  AND object_version_number = l_mks_rec.object_version_number;
Line: 422

      ROLLBACK TO update_market_segments;
Line: 432

      ROLLBACK TO update_market_segments;
Line: 442

      ROLLBACK TO update_market_segments;
Line: 454

END update_market_segments;
Line: 463

PROCEDURE delete_market_segments
(
  p_api_version      IN      NUMBER,
  p_init_msg_list    IN      VARCHAR2 := FND_API.g_false,
  p_commit           IN      VARCHAR2 := FND_API.g_false,

  x_return_status    OUT NOCOPY     VARCHAR2,
  x_msg_count        OUT NOCOPY     NUMBER,
  x_msg_data         OUT NOCOPY     VARCHAR2,

  p_act_mks_id       IN      NUMBER,
  p_object_version   IN      NUMBER
)
IS

  l_api_version   CONSTANT NUMBER := 1.0;
Line: 479

  l_api_name      CONSTANT VARCHAR2(30) := 'delete_market_segments';
Line: 483

   SELECT act_market_segment_used_by_id ,
          arc_act_market_segment_used_by
     FROM ams_act_market_segments
    WHERE activity_market_segment_id = p_act_mks_id;
Line: 492

   SELECT 1
     FROM ams_act_market_segments
    WHERE act_market_segment_used_by_id = l_act_id
      AND arc_act_market_segment_used_by = l_arc_act ;
Line: 499

  SAVEPOINT delete_market_segments;
Line: 521

  AMS_Utility_PVT.debug_message(l_full_name || ': delete');
Line: 531

  DELETE FROM AMS_ACT_MARKET_SEGMENTS
  WHERE activity_market_segment_id = p_act_mks_id
  AND object_version_number = p_object_version;
Line: 593

      ROLLBACK TO delete_market_segments;
Line: 603

      ROLLBACK TO delete_market_segments;
Line: 613

      ROLLBACK TO delete_market_segments;
Line: 625

END delete_market_segments;
Line: 649

  l_api_name      CONSTANT VARCHAR2(30) := 'delete_market_segments';
Line: 654

    SELECT activity_market_segment_id
    FROM AMS_ACT_MARKET_SEGMENTS
    WHERE activity_market_segment_id = p_act_mks_id
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;
Line: 1375

  SELECT COUNT(1)
    FROM qp_qualifiers
   WHERE qualifier_id = l_id;
Line: 1534

    SELECT * FROM AMS_ACT_MARKET_SEGMENTS
    WHERE activity_market_segment_id = p_mks_rec.activity_market_segment_id;
Line: 1678

    x_mks_rec.last_update_date               :=  FND_API.G_MISS_DATE ;
Line: 1679

    x_mks_rec.last_updated_by                :=  FND_API.G_MISS_NUM ;
Line: 1682

    x_mks_rec.last_update_login              :=  FND_API.G_MISS_NUM ;