APPS.BIS_PMF_REG_SERVICE_PVT SQL Statements

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

Line: 193

Procedure update_total_time
( p_Target_tbl           IN BIS_TARGET_PUB.Target_Tbl_type
, p_target_level_rec     IN BIS_Target_Level_PUB.Target_Level_rec_Type
--, p_alert_based_on       IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
, x_target_tbl           IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
, x_return_status        OUT NOCOPY VARCHAR2
);

Line: 1815

      BIS_UTILITIES_PUB.put_line(p_text => ' Begin Retrieving targets from bis_user_ind_selections ' );

Line: 1817

      BIS_ACTUAL_PVT.Retrieve_tl_selections
      (   p_Target_Level_Rec     => l_Target_Level_tbl(i)
        , x_Indicator_Region_Tbl => l_Indicator_Region_Tbl
        , x_return_status        => x_return_status
        , x_error_Tbl            => x_error_Tbl
      );

Line: 1867

      BIS_UTILITIES_PUB.put_line(p_text => ' End Retrieving targets from bis_user_ind_selections ' );

Line: 1917

        update_total_time
        ( p_Target_tbl           => l_Target_tbl_tmp_p
        , p_target_level_rec     => l_target_level_tbl(i)
        , x_target_tbl           => l_target_tbl_tmp
        , x_return_status        => x_return_status
        );

Line: 2164

    l_Target_tbl_tmp.delete;

Line: 2486

Procedure update_total_time
( p_Target_tbl           IN BIS_TARGET_PUB.Target_Tbl_type
, p_target_level_rec     IN BIS_Target_Level_PUB.Target_Level_rec_Type
--, p_alert_based_on       IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
, x_target_tbl           IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
, x_return_status        OUT NOCOPY VARCHAR2
)
IS

 l_target_tbl        BIS_TARGET_PUB.Target_Tbl_type;

Line: 2578

END update_total_time;

Line: 2603

    select LEVEL_VALUES_VIEW_NAME
    into l_view_name
    from bisbv_dimension_levels
    where DIMENSION_LEVEL_ID = p_time_dimension_level_id;

Line: 2608

    l_sql_stmnt := 'select distinct start_date, end_date from '
    || l_view_name
    ||'  where sysdate between nvl(start_date,sysdate) '
    ||'  and nvl(end_date,sysdate) ';

Line: 2979

    l_target_tbl_tmp.delete;

Line: 3788

  SELECT source, short_name,DIMENSION_ID
  FROM  bis_levels
  WHERE level_id = p_DimLevelId;

Line: 3793

   SELECT short_name
   FROM   bis_dimensions
   WHERE  dimension_id = p_dim_level_id;