APPS.BSC_COLOR_RANGE_PVT SQL Statements

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

Line: 41

  l_user_id             bsc_color_type_props.last_updated_by%TYPE;

Line: 57

    SELECT COUNT(1)
    INTO   l_count
    FROM   bsc_color_type_props
    WHERE  indicator = p_objective_id
    AND    kpi_measure_id IS NULL;

Line: 63

    SELECT COUNT(1)
    INTO   l_count
    FROM   bsc_color_type_props
    WHERE  indicator = p_objective_id
    AND    kpi_measure_id = p_kpi_measure_id
    AND    NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);

Line: 79

  INSERT INTO bsc_color_type_props(indicator
                                  ,kpi_measure_id
                                  ,color_type
                                  ,color_range_id
                                  ,property_value
                                  ,creation_date
                                  ,created_by
                                  ,last_update_date
                                  ,last_updated_by
                                  ,last_update_login)
                            VALUES(p_objective_id
                                  ,p_kpi_measure_id
                                  ,p_color_type
                                  ,p_color_range_id
                                  ,p_property_value
                                  ,sysdate
                                  ,l_user_id
                                  ,sysdate
                                  ,l_user_id
                                  ,l_user_id);

Line: 158

      INSERT INTO bsc_color_ranges(color_range_id
                                  ,color_range_sequence
                                  ,low
                                  ,high
                                  ,color_id)
                            VALUES(p_range_id
                                  ,p_Bsc_Kpi_Color_Range_Rec(l_th_count).color_range_sequence
                                  ,p_Bsc_Kpi_Color_Range_Rec(l_th_count).low
                                  ,p_Bsc_Kpi_Color_Range_Rec(l_th_count).high
                                  ,p_Bsc_Kpi_Color_Range_Rec(l_th_count).color_id);

Line: 208

PROCEDURE Delete_Color_Ranges (
  p_commit              IN             VARCHAR2 := FND_API.G_FALSE
 ,p_color_range_id      IN             NUMBER
 ,x_return_status       OUT NOCOPY     VARCHAR2
 ,x_msg_count           OUT NOCOPY     NUMBER
 ,x_msg_data            OUT NOCOPY     VARCHAR2
) IS
l_color_id         NUMBER;

Line: 228

  DELETE bsc_color_ranges
  WHERE  color_range_id = p_color_range_id;

Line: 243

END Delete_Color_Ranges;

Line: 247

PROCEDURE Delete_Color_Prop_Ranges (
  p_commit              IN             VARCHAR2:= FND_API.G_FALSE
 ,p_color_range_id      IN             NUMBER
 ,x_return_status       OUT NOCOPY     VARCHAR2
 ,x_msg_count           OUT NOCOPY     NUMBER
 ,x_msg_data            OUT NOCOPY     VARCHAR2
) IS
BEGIN
  FND_MSG_PUB.Initialize;

Line: 266

  DELETE bsc_color_type_props
  WHERE  color_range_id = p_color_range_id;

Line: 269

  Delete_Color_Ranges(p_color_range_id => p_color_range_id
                     ,x_return_status  => x_return_status
                     ,x_msg_count      => x_msg_count
                     ,x_msg_data       => x_msg_data);

Line: 289

END Delete_Color_Prop_Ranges;