APPS.BIS_COMPUTED_ACTUAL_PVT SQL Statements

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

Line: 65

, x_select_clause            OUT NOCOPY VARCHAR2
, x_from_clause              OUT NOCOPY VARCHAR2
, x_where_clause             OUT NOCOPY VARCHAR2
, x_group_by_clause          OUT NOCOPY VARCHAR2
, x_return_status            OUT NOCOPY VARCHAR2
);

Line: 72

PROCEDURE Build_select_clause
( p_Measure_Instance_Obj_tbl IN Measure_Instance_DB_Obj_Tbl
, p_measure_short_name       IN VARCHAR2
, p_compare_region_item   IN VARCHAR2
, p_compare_region_code   IN VARCHAR2
, x_select_clause            OUT NOCOPY VARCHAR2
, x_return_status            OUT NOCOPY VARCHAR2
);

Line: 102

( p_select_clause            IN VARCHAR2
, p_from_clause              IN VARCHAR2
, p_where_clause             IN VARCHAR2
, p_group_by_clause          IN VARCHAR2
, x_Actual_value             OUT NOCOPY NUMBER
, x_compare_value            OUT NOCOPY NUMBER
, x_return_status            OUT NOCOPY VARCHAR2
);

Line: 296

     SELECT comparison_source, ACTUAL_DATA_SOURCE
      FROM bisbv_performance_measures
      WHERE measure_short_name = pi_measure_short_name;

Line: 592

  l_select_clause        VARCHAR2(32000);

Line: 608

        SELECT comparison_source
          FROM bisbv_performance_measures
         WHERE measure_short_name = pi_measure_short_name;

Line: 733

  , x_select_clause            => l_select_clause
  , x_from_clause              => l_from_clause
  , x_where_clause             => l_where_clause
  , x_group_by_clause          => l_group_by_clause
  , x_return_status            => l_return_status
  );

Line: 746

    ( p_select_clause            => l_select_clause
    , p_from_clause              => l_from_clause
    , p_where_clause             => l_where_clause
    , p_group_by_clause          => l_group_by_clause
    , x_Actual_value             => l_Actual_value
    , x_compare_value            => l_compare_value
    , x_return_status            => l_return_status
    );

Line: 800

        SELECT actual_data_source
          FROM bisbv_performance_measures
         WHERE measure_short_name = pi_measure_short_name;

Line: 806

        SELECT region_application_id
        FROM   ak_region_items
        WHERE  attribute_code   = pi_actual_region_item
        AND    region_code = pi_actual_region_code;

Line: 815

        SELECT *
        FROM  ak_regions
        WHERE region_code = pi_region_code
        AND    region_application_id = pi_region_application_id
        ORDER BY CREATION_DATE asc;

Line: 845

            l_object_tbl.DELETE(l_object_tbl.COUNT);

Line: 884

    SELECT *
    FROM ak_regions r
    WHERE r.region_code = p_region_code
    AND r.region_application_id = p_region_application_id
    ORDER BY CREATION_DATE asc;

Line: 891

    SELECT region_code, region_application_id
    FROM ak_region_items i
    WHERE i.ATTRIBUTE1 = 'MEASURE'
    AND i.ATTRIBUTE2 = p_measure_short_name;

Line: 912

        l_object_tbl.DELETE(l_object_tbl.COUNT);

Line: 1003

    SELECT *
    FROM ak_region_items
    WHERE REGION_CODE = p_region_code
    AND REGION_APPLICATION_ID = p_region_application_id
    AND ATTRIBUTE1 = 'DIMENSION LEVEL'
    AND get_dim_level_short_name(ATTRIBUTE2)
        = p_dimension_level_short_name;

Line: 1055

      Select *
      INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1)
      FROM ak_region_items
      WHERE REGION_CODE = p_object_tbl(1).region_code
      AND REGION_APPLICATION_ID = p_object_tbl(1).region_application_id
      AND ATTRIBUTE1 = 'MEASURE'
      AND ATTRIBUTE2 = p_measure_short_name;

Line: 1071

      Select *
      INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1)
      FROM ak_region_items
      WHERE REGION_CODE = p_object_tbl(1).region_code
      AND REGION_APPLICATION_ID = p_object_tbl(1).region_application_id
      AND ATTRIBUTE1 = 'MEASURE'
      AND ATTRIBUTE_CODE = p_compare_region_item;

Line: 1121

          l_dim_level_value_Tbl.DELETE(j);

Line: 1399

, x_select_clause            OUT NOCOPY VARCHAR2
, x_from_clause              OUT NOCOPY VARCHAR2
, x_where_clause             OUT NOCOPY VARCHAR2
, x_group_by_clause          OUT NOCOPY VARCHAR2
, x_return_status            OUT NOCOPY VARCHAR2
)
IS

  l_select_clause     VARCHAR2(32000);

Line: 1417

  Build_select_clause
  ( p_Measure_Instance_Obj_tbl => p_Measure_Instance_Obj_tbl
  , p_measure_short_name       => p_measure_short_name
  , p_compare_region_item      => p_compare_region_item
  , p_compare_region_code      => p_compare_region_code
  , x_select_clause            => l_select_clause
  , x_return_status            => l_return_status
  );

Line: 1427

    l_select_clause := G_ERROR_CLAUSE;

Line: 1462

  IF l_select_clause = G_ERROR_CLAUSE
  OR l_from_clause = G_ERROR_CLAUSE
  OR l_where_clause = G_ERROR_CLAUSE
  OR l_group_by_clause = G_ERROR_CLAUSE
  THEN
    x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1470

   BIS_UTILITIES_PUB.put_line(p_text =>'select: '  ||l_select_clause);

Line: 1475

  x_select_clause    := l_select_clause;

Line: 1487

PROCEDURE Build_select_clause
( p_Measure_Instance_Obj_tbl IN Measure_Instance_DB_Obj_Tbl
, p_measure_short_name       IN VARCHAR2
, p_compare_region_item   IN VARCHAR2
, p_compare_region_code   IN VARCHAR2
, x_select_clause            OUT NOCOPY VARCHAR2
, x_return_status            OUT NOCOPY VARCHAR2
)
IS

 l_select_clause VARCHAR2(32000) := NULL;

Line: 1547

  l_select_clause := ' SELECT  '|| l_actual_clause;

Line: 1552

    l_select_clause :=  l_select_clause || ' , ' || l_compare_clause ;

Line: 1556

    l_select_clause :=  l_select_clause || ' , ' || 'NULL'  ;

Line: 1560

  x_select_clause := l_select_clause;

Line: 1565

    BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_select_clause: '||sqlerrm);

Line: 1567

END Build_select_clause;

Line: 1698

( p_select_clause            IN VARCHAR2
, p_from_clause              IN VARCHAR2
, p_where_clause             IN VARCHAR2
, p_group_by_clause          IN VARCHAR2
, x_Actual_value             OUT NOCOPY NUMBER
, x_compare_value             OUT NOCOPY NUMBER
, x_return_status            OUT NOCOPY VARCHAR2
)
IS

    l_stmt         VARCHAR2(32000);

Line: 1716

  l_stmt := p_select_clause||' '||p_from_clause||' '|| p_where_clause||' '||p_group_by_clause;

Line: 1776

  l_select_String       VARCHAR2(32000);

Line: 1877

         , x_select_String            => l_select_String
         , x_table_name               => l_table_name
         , x_value_name               => l_value_name
         , x_id_name                  => l_id_name
         , x_level_name               => l_level_name
         , x_description              => l_description
         , x_return_Status            => l_return_Status
         , x_msg_Count                => l_msg_Count
         , x_msg_data                 => l_msg_data
         );

Line: 2114

  SELECT parameters, web_html_call
  INTO l_params, l_web_html_call
  FROM fnd_form_functions
  WHERE function_name = p_Function_name -- 'PMIUSGVR' -- 'BIS_FIIFANB1' -- 'BIS_FIIGLEPS' -- 'BIS_REOPENED_BUGS_SSWA' -- 'BIS_FIIARDSO'
      AND
  	 ( upper(parameters) like '%'||c_region_in_params||'%' OR
  	   upper(web_html_call) like c_region_in_webhtmlcall||'%');

Line: 2177

  SELECT ATTRIBUTE9 into l_function
  FROM ak_region_items
  WHERE region_code = p_Measure_Instance_Obj_rec.region_code
  AND ATTRIBUTE_CODE = p_Measure_Instance_Obj_rec.attribute_code;

Line: 2948

  SELECT DIMENSION_SHORT_NAME, DIMENSION_LEVEL_SHORT_NAME
  FROM  bisfv_dimension_levels
  WHERE DIMENSION_LEVEL_ID = p_DimLevelId ;