DBA Data[Home] [Help]

APPS.BIS_DIM_LEVEL_VALUE_PVT SQL Statements

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

Line: 78

l_select_stmt VARCHAR2(32000);
Line: 90

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 127

        l_select_stmt := 'SELECT DISTINCT'
                         || '  ID '
                         || ', VALUE '
                         || ' FROM '
                         || l_view_name
                         || ' WHERE '
                         || l_resp_clause
                         || ' ORDER BY VALUE';
Line: 136

        l_select_stmt := 'SELECT DISTINCT'
                         || '  ID '
                         || ', VALUE '
                         || ' FROM '
                         || l_view_name
                         || ' ORDER BY VALUE';
Line: 144

                    , statement     => l_select_stmt
                    , language_flag => DBMS_SQL.NATIVE
                    );
Line: 257

l_select_stmt VARCHAR2(2000);
Line: 268

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 286

        l_select_stmt := 'SELECT '
                         || '  ID '
                         || ', VALUE '
                         || ' FROM '
                         || l_view_name
                         || ' WHERE '
                         || ' RESPONSIBILITY_ID = :p_Responsibility_ID '
                         || ' ORDER BY VALUE';
Line: 295

        l_select_stmt := 'SELECT DISTINCT'
                         || '  ID '
                         || ', VALUE '
                         || ' FROM '
                         || l_view_name
                         || ' ORDER BY VALUE';
Line: 304

                    , statement     => l_select_stmt
                    , language_flag => DBMS_SQL.NATIVE
                    );
Line: 413

l_select_stmt VARCHAR2(2000);
Line: 424

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 441

    l_select_stmt := 'SELECT DISTINCT'
                     || '  ID '
                     || ', VALUE '
                     || ' FROM '
                     || l_view_name
                     || ' ORDER BY VALUE';
Line: 449

                  , statement     => l_select_stmt
                  , language_flag => DBMS_SQL.NATIVE
                  );
Line: 553

l_select_stmt VARCHAR2(2000);
Line: 564

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 581

    l_select_stmt := 'SELECT DISTINCT '
                     || '  ID '
                     || ', VALUE '
                     || ' FROM '
                     || l_view_name
                     || ' ORDER BY VALUE';
Line: 590

                  , statement     => l_select_stmt
                  , language_flag => DBMS_SQL.NATIVE
                  );
Line: 699

l_select_stmt VARCHAR2(2000) := NULL;
Line: 712

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 727

        l_select_stmt := 'SELECT '
                       || '  ID '
                       || ', VALUE '
                       || ', START_DATE '
                       || ' FROM '
                       || l_view_name
                       || ' WHERE '
                       || ' ORGANIZATION_ID = :org_id'
                       || ' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :org_type '
                       || ' ORDER BY START_DATE';
Line: 739

      l_select_stmt := 'SELECT '
                       || '  ID '
                       || ', VALUE '
                       || ', START_DATE '
                       || ' FROM '
                       || l_view_name
                       || ' ORDER BY START_DATE';
Line: 752

                  , statement     => l_select_stmt
                  , language_flag => DBMS_SQL.NATIVE
                  );
Line: 922

l_select_stmt     VARCHAR2(2000);
Line: 929

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 944

  l_select_stmt := 'SELECT DISTINCT '
                   || '  START_DATE '
                   || ' FROM '
                   || l_view_name
                   || ' WHERE '
                   || ' ID = :p_start_period ';
Line: 952

                , statement     => l_select_stmt
                , language_flag => DBMS_SQL.NATIVE
                );
Line: 1026

l_select_stmt     VARCHAR2(2000);
Line: 1033

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
Line: 1048

  l_select_stmt := 'SELECT DISTINCT '
                   || '  END_DATE '
                   || ' FROM '
                   || l_view_name
                   || ' WHERE '
                   || ' ID = :p_end_period ';
Line: 1056

                , statement     => l_select_stmt
                , language_flag => DBMS_SQL.NATIVE
                );
Line: 1129

l_select_stmt VARCHAR2(2000);
Line: 1135

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
Line: 1148

    l_select_stmt := 'SELECT DISTINCT '
                     || '  ID '
                     || ', VALUE '
                     || ' FROM '
                     || l_view_name
                     || ' WHERE ID = :1';
Line: 1155

    EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_ID;
Line: 1230

l_select_stmt VARCHAR2(2000);
Line: 1236

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
Line: 1249

    l_select_stmt := 'SELECT DISTINCT '
                     || '  ID '
                     || ', VALUE '
                     || ' FROM '
                     || l_view_name
                     || ' WHERE VALUE = :1 ';
Line: 1256

    EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
Line: 1334

l_select_stmt VARCHAR2(2000);
Line: 1340

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
Line: 1355

        l_select_stmt := 'SELECT '
                       || '  PERIOD_SET_NAME '
                       || ', PERIOD_NAME '
                       || ' FROM '
                       || l_view_name
                       || ' WHERE '
                       || ' ORGANIZATION_ID = :1 '
                       || ' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :2 '
                       || ' AND '
                       || ' PERIOD_SET_NAME || ''+'' || PERIOD_NAME = :3 ';
Line: 1365

        EXECUTE IMMEDIATE l_select_stmt INTO l_period_set, l_value
          USING p_Org_Level_Value_Rec.Dimension_Level_Value_ID
              , p_Org_Level_Value_Rec.Dimension_Level_Short_Name
     	      , p_Dim_Level_Value_Rec.Dimension_Level_Value_ID;
Line: 1370

      l_select_stmt := 'SELECT '
                       || '  PERIOD_SET_NAME '
                       || ', PERIOD_NAME '
                       || ' FROM '
                       || l_view_name
                       || ' WHERE '
                       || ' PERIOD_SET_NAME || ''+'' || PERIOD_NAME = :1';
Line: 1377

      EXECUTE IMMEDIATE l_select_stmt INTO l_period_set, l_value
        USING p_Dim_Level_Value_Rec.Dimension_Level_Value_ID;
Line: 1457

l_select_stmt VARCHAR2(2000);
Line: 1463

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
Line: 1478

        l_select_stmt := 'SELECT '
                       || '  ID '
                       || ', VALUE '
                       || ' FROM '
                       || l_view_name
                       || ' WHERE '
                       || ' ORGANIZATION_ID = :1 '
                       || ' AND NVL(ORGANIZATION_TYPE, ''%'') LIKE :2 '
                       || ' AND '
                       || ' VALUE = :3 ';
Line: 1488

        EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value
          USING p_Org_Level_Value_Rec.Dimension_Level_Value_ID
              , p_Org_Level_Value_Rec.Dimension_Level_Short_Name
  	      , p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
Line: 1493

      l_select_stmt := 'SELECT '
                       || '  ID '
                       || ', VALUE '
                       || ' FROM '
                       || l_view_name
                       || ' WHERE '
                       || ' VALUE = :1 '
                       || ' AND rownum < 2 '; -- take the first row
Line: 1501

      EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value
        USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
Line: 1585

l_select_stmt VARCHAR2(2000);
Line: 1604

   ,x_select_String =>  l_select_stmt
   ,x_table_name => l_view_name
   ,x_value_name => l_value_name
   ,x_id_name =>  l_id_name
   ,x_level_name => l_name
   ,x_description => l_description
   ,x_return_status =>  x_return_status
   ,x_msg_count => l_msg_count
   ,x_msg_data  =>  l_msg_data
  );
Line: 1635

      l_select_stmt := l_select_stmt || ' WHERE ' ||l_id_name ||' = :1';
Line: 1637

      l_select_stmt := l_select_stmt || ' AND ROWNUM < 2 ';
Line: 1642

        l_select_stmt := l_select_stmt || ' AND SET_OF_BOOKS_ID = :2';
Line: 1643

        EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id, p_set_of_books_id;
Line: 1645

	    	EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value, l_start_date, l_end_date USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id;
Line: 1647

        EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id;
Line: 1738

l_select_stmt VARCHAR2(2000);
Line: 1745

  SELECT
    DIMENSION_LEVEL_SHORT_NAME
  , DIMENSION_LEVEL_NAME
  , LEVEL_VALUES_VIEW_NAME
  INTO
    l_short_name
  , l_name
  , l_view_name
  FROM BISBV_DIMENSION_LEVELS
  WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
Line: 1757

     l_select_stmt := 'SELECT DISTINCT ID, VALUE FROM '|| l_view_name
                     || ' WHERE Value = :1';
Line: 1760

     EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
Line: 1844

  l_select_stmt VARCHAR2(2000);
Line: 1874

   ,x_select_String 	=> l_select_stmt
   ,x_table_name 	=> l_view_name
   ,x_value_name 	=> l_value_name
   ,x_id_name 		=> l_id_name
   ,x_level_name 	=> l_name
   ,x_description 	=> l_description
   ,x_return_status 	=> l_return_status
   ,x_msg_count 	=> l_msg_count
   ,x_msg_data  	=> l_msg_data
  );
Line: 1981

  l_select_stmt VARCHAR2(2000);
Line: 2014

   ,x_select_String =>  l_select_stmt
   ,x_table_name => l_view_name
   ,x_value_name => l_value_name
   ,x_id_name =>  l_id_name
   ,x_level_name => l_name
   ,x_description => l_description
   ,x_return_status =>  l_return_status
   ,x_msg_count => l_msg_count
   ,x_msg_data  =>  l_msg_data
  );