APPS.BIS_PMF_GET_DIMLEVELS_PUB SQL Statements

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

Line: 14

REM |     Public  API for getting the Select String for DimensionLevelValues|
REM |     This API will get the Select String from either EDW or BIS        |
REM |     depending on the profile option BIS_SOURCE                        |
REM |                                                                       |
REM | HISTORY                                                               |
REM | December-2000 amkulkar Creation                                       |
REM +=======================================================================+
*/
--
PROCEDURE GET_DIMLEVEL_SELECT_STRING
(
 p_DimLevelShortName         IN     VARCHAR2
,p_bis_source                IN     VARCHAR2
,x_Select_String             OUT NOCOPY    VARCHAR2
,x_table_name                OUT NOCOPY    VARCHAR2
,x_id_name                   OUT NOCOPY    VARCHAR2
,x_value_name                OUT NOCOPY    VARCHAR2
,x_return_status             OUT NOCOPY    VARCHAR2
,x_msg_count                 OUT NOCOPY    NUMBER
,x_msg_data                  OUT NOCOPY    VARCHAR2
)
IS
   l_time_level             VARCHAR2(2000);

Line: 39

  BIS_PMF_GET_DIMLEVELS_PVT.GET_DIMLEVEL_SELECT_STRING(
          p_DimLevelName  => p_DimLevelShortName
         ,p_bis_source    => p_bis_source
         ,x_Select_String => x_Select_String
         ,x_table_name    => x_table_name
         ,x_id_name       => x_id_name
         ,x_value_name    => x_value_name
         ,x_time_level    => l_time_level
         ,x_return_Status => x_return_Status
         ,x_msg_count     => x_msg_count
         ,x_msg_data      => x_msg_data
        );

Line: 51

END GET_DIMLEVEL_SELECT_STRING;

Line: 53

PROCEDURE GET_SORTED_SELECT_STRING
(
 p_DimLevelShortName         IN     VARCHAR2
,p_bis_source                IN     VARCHAR2
,x_Select_String             OUT NOCOPY    VARCHAR2
,x_table_name                OUT NOCOPY    VARCHAR2
,x_id_name                   OUT NOCOPY    VARCHAR2
,x_value_name                OUT NOCOPY    VARCHAR2
,x_return_status             OUT NOCOPY    VARCHAR2
,x_msg_count                 OUT NOCOPY    NUMBER
,x_msg_data                  OUT NOCOPY    VARCHAR2
)
IS
   l_time_level      varchar2(2000);

Line: 70

  BIS_PMF_GET_DIMLEVELS_PVT.GET_DIMLEVEL_SELECT_STRING(
          p_DimLevelName  => p_DimLevelShortName
         ,p_bis_source    => p_bis_source
         ,x_Select_String => x_Select_String
         ,x_table_name    => x_table_name
         ,x_id_name       => x_id_name
         ,x_value_name    => x_value_name
         ,x_time_level    => l_time_level
         ,x_return_Status => x_return_Status
         ,x_msg_count     => x_msg_count
         ,x_msg_data      => x_msg_data
        );

Line: 88

   x_select_string := x_select_string || l_order_by;

Line: 90

END GET_SORTED_SELECT_STRING;