eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_TARGET_PVT SQL Statements

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

Line: 25


REM |                       condition in Update_db_Target for owners and    |
REM |                       tolerance ranges as user might want to update   |
REM |                       them to NULL.                                   |
REM | 23-JAN-03 sugopal For having different local variables for IN and OUT |
REM |                   parameters (bug#2758428)              	            |
REM | 23-JUL-03 sashaik For bug 3064592: related to computing function id   |
REM |                     and setting targets dynamically.                  |
REM | 26-JUL-04 ankgoel Bug#3756093 Returned role_id for role_short_names in|
REM |                   retrieve_targets API                                |
REM | 13-JAN-05 vtulasi Bug#4102897 - Change in size of variables           |
REM | 21-MAR-05 ankagarw Bug#4235732 - changing count(*) to count(1)        |
REM | 10-APR-05 psomesul Bug#5140269 - PERFORMANCE ISSUE WITH TARGET OWNER  |
REM |              LOV IN PMF PAGES - replaced WF_ROLES with WF_ROLE_LOV_VL |
REM +=======================================================================+
*/

--
--
-- queries database to retrieve the target from the database
-- updates the record with the changes sent in
PROCEDURE Update_db_Target
( p_Target_Rec    BIS_TARGET_PUB.Target_Rec_Type
, x_Target_Rec    IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
);

Line: 158


  SELECT COUNT(1)
  INTO l_count
  FROM BISBV_TARGETS bisbv_targets
  WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
   AND  bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
   AND  NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
   AND  NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
        = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');

Line: 205


  INSERT INTO bis_target_values
  ( TARGET_ID
  , TARGET_LEVEL_ID
  , PLAN_ID
  , ORG_LEVEL_VALUE
  , TIME_LEVEL_VALUE
  , DIMENSION1_LEVEL_VALUE
  , DIMENSION2_LEVEL_VALUE
  , DIMENSION3_LEVEL_VALUE
  , DIMENSION4_LEVEL_VALUE
  , DIMENSION5_LEVEL_VALUE
  , DIMENSION6_LEVEL_VALUE
  , DIMENSION7_LEVEL_VALUE
  , TARGET
  , RANGE1_LOW
  , RANGE1_HIGH
  , RANGE2_LOW
  , RANGE2_HIGH
  , RANGE3_LOW
  , RANGE3_HIGH
  , ROLE1_ID
  , ROLE1
  , ROLE2_ID
  , ROLE2
  , ROLE3_ID
  , ROLE3
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  )
  VALUES
  ( bis_target_values_s.NEXTVAL
  , l_Target_Rec.Target_Level_ID
  , l_Target_Rec.Plan_ID
  , l_Target_Rec.Org_Level_Value_ID
  , l_Target_Rec.Time_Level_Value_ID
  , l_Target_Rec.Dim1_Level_Value_ID
  , l_Target_Rec.Dim2_Level_Value_ID
  , l_Target_Rec.Dim3_Level_Value_ID
  , l_Target_Rec.Dim4_Level_Value_ID
  , l_Target_Rec.Dim5_Level_Value_ID
  , l_Target_Rec.Dim6_Level_Value_ID
  , l_Target_Rec.Dim7_Level_Value_ID
  , l_Target_Rec.Target
  , l_Target_Rec.Range1_low
  , l_Target_Rec.Range1_high
  , l_Target_Rec.Range2_low
  , l_Target_Rec.Range2_high
  , l_Target_Rec.Range3_low
  , l_Target_Rec.Range3_high
  , l_Target_Rec.Notify_Resp1_ID
  , l_Target_Rec.Notify_Resp1_Short_Name
  , l_Target_Rec.Notify_Resp2_ID
  , l_Target_Rec.Notify_Resp2_Short_Name
  , l_Target_Rec.Notify_Resp3_ID
  , l_Target_Rec.Notify_Resp3_Short_Name
  , SYSDATE
  , l_user_id
  , SYSDATE
  , l_user_id
  , l_login_id
  );

Line: 411


SELECT *
FROM bisfv_targets bisfv_targets
WHERE bisfv_targets.TARGET_LEVEL_ID =  p_Target_Level_ID;

Line: 587


    SELECT *
    INTO l_bisfv_targets_rec
    FROM bisfv_targets bisfv_targets
    WHERE bisfv_targets.TARGET_ID = p_Target_Rec.Target_ID;

Line: 597


    SELECT *
    INTO l_bisbv_target_levels_rec
    FROM bisbv_target_levels bisbv_target_levels
    WHERE bisbv_target_levels.TARGET_LEVEL_ID
          = p_Target_Rec.Target_Level_ID;

Line: 906


    SELECT *
    INTO l_bisfv_targets_rec
    FROM bisfv_targets bisfv_targets
    WHERE bisfv_targets.TARGET_LEVEL_ID  = p_Target_Rec.Target_Level_ID
     -- used to be  p_Target_Rec.Plan_ID
      AND bisfv_targets.PLAN_ID             = l_plan_id

     ---changed org and time logic
      AND (l_org_level_value_id IS NULL
         OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T')   = NVL(l_org_level_value_id, 'T'))

      AND (l_time_level_value_id IS NULL
         OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T')   = NVL(l_time_level_value_id, 'T'))

      AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim1_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim1_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim2_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim2_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim3_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim3_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim4_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim4_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim5_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim5_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim6_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim6_Level_Value_ID, 'T')
                  )
      AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')
          = DECODE( p_Target_Rec.Dim7_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(p_Target_Rec.Dim7_Level_Value_ID, 'T')
                  )
      ;

Line: 1181


PROCEDURE Update_Target
( p_api_version      IN  NUMBER
, p_is_dbimeasure    IN  NUMBER := 0 --gbhaloti #3148615
, p_commit           IN  VARCHAR2 := FND_API.G_FALSE
, p_validation_level IN  NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_Target_Rec       IN  BIS_TARGET_PUB.Target_Rec_Type
, x_return_status    OUT NOCOPY VARCHAR2
, x_error_Tbl        OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
--
l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;

Line: 1215


  Update_db_Target
  ( p_Target_Rec    => l_Target_Rec_p
  , x_Target_Rec    => l_Target_Rec
  , x_return_status => x_return_status
  , x_error_Tbl     => x_error_Tbl
  );

Line: 1240


    SELECT bisbv_targets.TARGET_ID
    INTO l_target_id
    FROM BISBV_TARGETS bisbv_targets
    WHERE bisbv_targets.TARGET_LEVEL_ID = l_Target_Rec.Target_Level_ID
     AND  bisbv_targets.PLAN_ID = l_Target_Rec.Plan_ID
     AND  NVL(bisbv_targets.ORG_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Org_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.TIME_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Time_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM1_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim1_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM2_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim2_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM3_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim3_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM4_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim4_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM5_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim5_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM6_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim6_Level_Value_ID, 'Y')
     AND  NVL(bisbv_targets.DIM7_LEVEL_VALUE_ID, 'Y')
          = NVL(l_Target_Rec.Dim7_Level_Value_ID, 'Y');

Line: 1272


       , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
       , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
       , p_error_table       => l_error_tbl
       , x_error_table       => x_error_tbl
      );

Line: 1287


       , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
       , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
       , p_error_table       => l_error_tbl
       , x_error_table       => x_error_tbl
      );

Line: 1303


  UPDATE BIS_TARGET_VALUES SET
    TARGET                 = l_Target_Rec.TARGET
  , TARGET_LEVEL_ID        = l_Target_Rec.TARGET_LEVEL_ID
  , PLAN_ID                = l_Target_Rec.PLAN_ID
  , ORG_LEVEL_VALUE        = l_Target_Rec.ORG_LEVEL_VALUE_ID
  , TIME_LEVEL_VALUE       = l_Target_Rec.TIME_LEVEL_VALUE_ID
  , DIMENSION1_LEVEL_VALUE = l_Target_Rec.DIM1_LEVEL_VALUE_ID
  , DIMENSION2_LEVEL_VALUE = l_Target_Rec.DIM2_LEVEL_VALUE_ID
  , DIMENSION3_LEVEL_VALUE = l_Target_Rec.DIM3_LEVEL_VALUE_ID
  , DIMENSION4_LEVEL_VALUE = l_Target_Rec.DIM4_LEVEL_VALUE_ID
  , DIMENSION5_LEVEL_VALUE = l_Target_Rec.DIM5_LEVEL_VALUE_ID
  , DIMENSION6_LEVEL_VALUE = l_Target_Rec.DIM6_LEVEL_VALUE_ID
  , DIMENSION7_LEVEL_VALUE = l_Target_Rec.DIM7_LEVEL_VALUE_ID
  , RANGE1_LOW             = l_Target_Rec.RANGE1_LOW
  , RANGE1_HIGH            = l_Target_Rec.RANGE1_HIGH
  , RANGE2_LOW             = l_Target_Rec.RANGE2_LOW
  , RANGE2_HIGH            = l_Target_Rec.RANGE2_HIGH
  , RANGE3_LOW             = l_Target_Rec.RANGE3_LOW
  , RANGE3_HIGH            = l_Target_Rec.RANGE3_HIGH
  , ROLE1_ID               = l_Target_Rec.NOTIFY_RESP1_ID
  , ROLE1                  = l_Target_Rec.NOTIFY_RESP1_SHORT_NAME
  , ROLE2_ID               = l_Target_Rec.NOTIFY_RESP2_ID
  , ROLE2                  = l_Target_Rec.NOTIFY_RESP2_SHORT_NAME
  , ROLE3_ID               = l_Target_Rec.NOTIFY_RESP3_ID
  , ROLE3                  = l_Target_Rec.NOTIFY_RESP3_SHORT_NAME
  , LAST_UPDATE_DATE       = SYSDATE
  , LAST_UPDATED_BY        = l_user_id
  , LAST_UPDATE_LOGIN      = l_login_id
  WHERE TARGET_ID = l_Target_Rec.TARGET_ID;

Line: 1343


      htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_ERROR'); htp.para;

Line: 1349


      htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line: 1362


      htp.p('BIS_TARGET_PVT.Update_Target:OTHERS'); htp.para;

Line: 1366


END Update_Target;

Line: 1386


    SELECT TARGET_ID
    INTO x_Target_Rec.TARGET_ID
    FROM BISBV_TARGETS BISBV_TARGETS
    WHERE BISBV_TARGETS.TARGET_LEVEL_ID  = x_Target_Rec.Target_Level_ID
      AND BISBV_TARGETS.PLAN_ID             = x_Target_Rec.Plan_ID
      AND NVL(BISBV_TARGETS.ORG_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Org_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Org_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.TIME_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Time_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Time_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM1_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim1_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim1_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM2_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim2_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim2_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM3_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim3_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim3_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM4_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim4_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim4_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM5_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim5_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim5_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM6_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim6_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim6_Level_Value_ID, 'T')
                  )
      AND NVL(BISBV_TARGETS.DIM7_LEVEL_VALUE_ID, 'T')
          = DECODE( x_Target_Rec.Dim7_Level_Value_ID
                  , FND_API.G_MISS_CHAR
                  , 'T'
                  , NVL(x_Target_Rec.Dim7_Level_Value_ID, 'T')
                  )
      ;

Line: 1499


PROCEDURE Delete_Target
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2 := FND_API.G_FALSE
, p_Target_Rec    IN  BIS_TARGET_PUB.Target_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
--
l_Target_Rec      BIS_TARGET_PUB.Target_Rec_Type;

Line: 1527


  DELETE FROM BIS_TARGET_VALUES
  WHERE TARGET_ID = l_Target_Rec.TARGET_ID;

Line: 1544


    , p_error_proc_name => 'BIS_TARGET_PVT.Delete_Target'
    , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
    , p_error_table       => l_error_tbl
    , x_error_table       => x_error_tbl
    );

Line: 1552


      htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_ERROR'); htp.para;

Line: 1558


      htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

Line: 1571


      htp.p('BIS_TARGET_PVT.Delete_Target:OTHERS'); htp.para;

Line: 1575


END Delete_Target;

Line: 2193


PROCEDURE Update_db_Target
( p_Target_Rec    BIS_TARGET_PUB.Target_Rec_Type
, x_Target_Rec    IN OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
--
l_Target_Rec    BIS_TARGET_PUB.Target_Rec_Type;

Line: 2307


      htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_ERROR'); htp.para;

Line: 2313


      htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_UNEXPECTED_ERROR');

Line: 2327


      htp.p('BIS_TARGET_PVT.Update_db_Target:OTHERS'); htp.para;

Line: 2331


END Update_db_Target;

Line: 2334


PROCEDURE Retrieve_Last_Update_Date
( p_api_version      IN  NUMBER
, p_Target_Rec       IN  BIS_TARGET_PUB.Target_Rec_Type
, x_last_update_date OUT NOCOPY DATE
, x_return_status    OUT NOCOPY VARCHAR2
, x_error_Tbl        OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line: 2351


    SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
    INTO x_last_update_date
    FROM BIS_TARGET_VALUES bis_target_values
    WHERE bis_target_values.TARGET_ID = p_Target_Rec.Target_ID;

Line: 2368


      , p_error_proc_name   => G_PKG_NAME||'.Retrieve_Last_Update_Date'
      , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
    );

Line: 2375


      htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:NO_DATA_FOUND');

Line: 2382


      htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_ERROR');

Line: 2390


      ('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_UNEXPECTED_ERROR');

Line: 2404


      htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:OTHERS'); htp.para;

Line: 2408


END Retrieve_Last_Update_Date;

Line: 2422


l_last_update_date DATE;

Line: 2430


  BIS_TARGET_PVT.Retrieve_Last_Update_Date
                 ( p_api_version      => 1.0
                 , p_Target_Rec       => l_Target_Rec
                 , x_last_update_date => l_last_update_date
                 , x_return_status    => x_return_status
                 , x_error_Tbl        => x_error_Tbl
                 );

Line: 2439


    IF(l_form_date = l_last_update_date) THEN
      x_result := FND_API.G_TRUE;

Line: 2511


    SELECT user_id
    INTO l_user_id
    FROM FND_USER
    WHERE user_name = p_User_Name;

Line: 2601


( p_Select_clause   IN  VARCHAR2
, p_from_clause     IN  VARCHAR2
, p_where_clause    IN  VARCHAR2
, p_order_by_clause IN  VARCHAR2
, x_query_statement OUT NOCOPY VARCHAR2
)
IS
BEGIN
  x_query_statement := p_select_clause
                       || p_from_clause
                       || p_where_clause
                       || p_order_by_clause;

Line: 2643


  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS
  WHERE TARGET_LEVEL_ID = TO_NUMBER(p_target_level_id);

Line: 2650


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_org_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.ORG_LEVEL_ID;

Line: 2660


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_time_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.TIME_LEVEL_ID;

Line: 2670


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim1_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;

Line: 2680


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim2_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;

Line: 2690


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim3_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;

Line: 2700


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim4_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;

Line: 2710


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim5_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;

Line: 2719


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim6_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;

Line: 2728


    SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
    INTO x_dim7_view_name
    FROM
      BISBV_DIMENSION_LEVELS bisbv_dimension_levels
    WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
          = l_bisbv_target_levels.DIMENSION7_LEVEL_ID;

Line: 2760


      SELECT fnd_form_functions_tl.USER_FUNCTION_NAME
      INTO l_user_function_name
      FROM FND_FORM_FUNCTIONS_TL fnd_form_functions_tl
      WHERE fnd_form_functions_tl.FUNCTION_ID = p_computing_function_id
        AND fnd_form_functions_tl.LANGUAGE    = USERENV('LANG');

Line: 2797


    SELECT wf_roles.DISPLAY_NAME
    INTO l_resp_name
    FROM WF_ROLE_LOV_VL wf_roles
    WHERE wf_roles.NAME = p_responsibility_short_name;

Line: 2864


  Select FUNCTION_NAME
  into l_computed_target_short_name
  from fnd_form_functions_vl
  where function_id = p_computing_function_id;

Line: 3075


  l_query := 'select distinct id, value from '||p_view_name||' '||p_where_clause || ' order by id';

Line: 3139


  l_query := 'select start_date from '|| p_view_name;

Line: 3153


  l_query := 'select end_date from '|| p_view_name;

Line: 3180


    select
      dim1_level_value_id,
      dim2_level_value_id,
      dim3_level_value_id,
      dim4_level_value_id,
      dim5_level_value_id,
      dim6_level_value_id,
      dim7_level_value_id
    from bisbv_targets
    where target_id = p_target_id;

Line: 3496


SELECT level_id , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(level_id),name)
FROM bis_levels_vl
WHERE short_name=p_dim_level_short_name;