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.PA_GANTT_CONFIG_PVT SQL Statements

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

Line: 56


     PA_GANTT_CONFIG_PKG.INSERT_ROW (
           X_ROWID                         =>  l_rowid
          ,X_GANTT_CONFIG_ID               =>  PX_GANTT_CONFIG_ID
          ,X_GANTT_VIEW_ID                 =>  P_GANTT_VIEW_ID
          ,X_GANTT_CONFIG_USAGE            =>  P_GANTT_CONFIG_USAGE
          ,X_FILTER_CODE                   =>  P_FILTER_CODE
          ,X_TIME_SCALE_CODE               =>  P_TIME_SCALE_CODE
          ,X_EXPAND_COLLAPSE_FLAG          =>  P_EXPAND_COLLAPSE_FLAG
          ,X_NUMBER_OF_DISPLAYED_ROWS      =>  P_NUMBER_OF_DISPLAYED_ROWS
          ,X_SHOW_ADDITIONAL_COL_FLAG      =>  P_SHOW_ADDITIONAL_COL_FLAG
          ,X_FOCUS_ENABLED_FLAG            =>  P_FOCUS_ENABLED_FLAG
          ,X_SHOW_HEADER_UI_FLAG           =>  P_SHOW_HEADER_UI_FLAG
          ,X_RECORD_VERSION_NUMBER         =>  1
          ,X_ATTRIBUTE_CATEGORY            =>  NULL
          ,X_ATTRIBUTE1                    =>  NULL
          ,X_ATTRIBUTE2                    =>  NULL
          ,X_ATTRIBUTE3                    =>  NULL
          ,X_ATTRIBUTE4                    =>  NULL
          ,X_ATTRIBUTE5                    =>  NULL
          ,X_ATTRIBUTE6                    =>  NULL
          ,X_ATTRIBUTE7                    =>  NULL
          ,X_ATTRIBUTE8                    =>  NULL
          ,X_ATTRIBUTE9                    =>  NULL
          ,X_ATTRIBUTE10                   =>  NULL
          ,X_ATTRIBUTE11                   =>  NULL
          ,X_ATTRIBUTE12                   =>  NULL
          ,X_ATTRIBUTE13                   =>  NULL
          ,X_ATTRIBUTE14                   =>  NULL
          ,X_ATTRIBUTE15                   =>  NULL
          ,X_NAME                          =>  P_NAME
          ,X_DESCRIPTION                   =>  P_DESCRIPTION
          ,X_CREATION_DATE                 =>  sysdate
          ,X_CREATED_BY                    =>  fnd_global.user_id
          ,X_LAST_UPDATE_DATE              =>  sysdate
          ,X_LAST_UPDATED_BY               =>  fnd_global.user_id
          ,X_LAST_UPDATE_LOGIN             =>  fnd_global.login_id
     );

Line: 157


procedure UPDATE_GANTT_CONFIG (
  P_COMMIT                    in VARCHAR2 ,
  P_CALLING_MODULE            in VARCHAR2 ,
  P_GANTT_CONFIG_ID           in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
  P_GANTT_VIEW_ID             in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
  P_GANTT_CONFIG_USAGE        in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
  P_FILTER_CODE               in PA_GANTT_CONFIG_B.filter_code%TYPE,
  P_TIME_SCALE_CODE           in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
  P_EXPAND_COLLAPSE_FLAG      in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
  P_NUMBER_OF_DISPLAYED_ROWS  in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
  P_SHOW_ADDITIONAL_COL_FLAG  in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
  P_FOCUS_ENABLED_FLAG        in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
  P_SHOW_HEADER_UI_FLAG       in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
  P_RECORD_VERSION_NUMBER     in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
  P_NAME                      in PA_GANTT_CONFIG_TL.name%TYPE,
  P_DESCRIPTION               in PA_GANTT_CONFIG_TL.description%TYPE,
  X_RETURN_STATUS             OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT                 OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
AS

l_msg_count                     NUMBER := 0;

Line: 192


   select record_version_number
   from pa_gantt_config_b
   where gantt_config_id = c_gantt_config_id;

Line: 200


          savepoint update_gantt_config;

Line: 208


          pa_debug.set_curr_function( p_function   => 'UPDATE_GANTT_CONFIG',
                                      p_debug_mode => l_debug_mode );

Line: 224


     PA_GANTT_CONFIG_PKG.UPDATE_ROW (
           X_GANTT_CONFIG_ID                 => P_GANTT_CONFIG_ID
          ,X_GANTT_VIEW_ID                   => P_GANTT_VIEW_ID
          ,X_GANTT_CONFIG_USAGE              => P_GANTT_CONFIG_USAGE
          ,X_FILTER_CODE                     => P_FILTER_CODE
          ,X_TIME_SCALE_CODE                 => P_TIME_SCALE_CODE
          ,X_EXPAND_COLLAPSE_FLAG            => P_EXPAND_COLLAPSE_FLAG
          ,X_NUMBER_OF_DISPLAYED_ROWS        => P_NUMBER_OF_DISPLAYED_ROWS
          ,X_SHOW_ADDITIONAL_COL_FLAG        => P_SHOW_ADDITIONAL_COL_FLAG
          ,X_FOCUS_ENABLED_FLAG              => P_FOCUS_ENABLED_FLAG
          ,X_SHOW_HEADER_UI_FLAG             => P_SHOW_HEADER_UI_FLAG
          ,X_RECORD_VERSION_NUMBER           => P_RECORD_VERSION_NUMBER
          ,X_ATTRIBUTE_CATEGORY              => NULL
          ,X_ATTRIBUTE1                      => NULL
          ,X_ATTRIBUTE2                      => NULL
          ,X_ATTRIBUTE3                      => NULL
          ,X_ATTRIBUTE4                      => NULL
          ,X_ATTRIBUTE5                      => NULL
          ,X_ATTRIBUTE6                      => NULL
          ,X_ATTRIBUTE7                      => NULL
          ,X_ATTRIBUTE8                      => NULL
          ,X_ATTRIBUTE9                      => NULL
          ,X_ATTRIBUTE10                     => NULL
          ,X_ATTRIBUTE11                     => NULL
          ,X_ATTRIBUTE12                     => NULL
          ,X_ATTRIBUTE13                     => NULL
          ,X_ATTRIBUTE14                     => NULL
          ,X_ATTRIBUTE15                     => NULL
          ,X_NAME                            => P_NAME
          ,X_DESCRIPTION                     => P_DESCRIPTION
          ,X_LAST_UPDATE_DATE                => sysdate
          ,X_LAST_UPDATED_BY                 => fnd_global.user_id
          ,X_LAST_UPDATE_LOGIN               => fnd_global.login_id
     );

Line: 261


          pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';

Line: 291


          rollback to update_gantt_config;

Line: 304


                    ,p_procedure_name  => 'UPDATE_GANTT_CONFIG'
                    ,p_error_text      => x_msg_data);

Line: 315


          rollback to update_gantt_config;

Line: 319


END UPDATE_GANTT_CONFIG;

Line: 322


procedure DELETE_GANTT_CONFIG (
  P_COMMIT                    in VARCHAR2 ,
  P_CALLING_MODULE            in VARCHAR2 ,
  P_GANTT_CONFIG_ID           in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
  P_RECORD_VERSION_NUMBER     in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
  X_RETURN_STATUS             OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT                 OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
AS

l_msg_count                     NUMBER := 0;

Line: 346


   select record_version_number
   from pa_gantt_config_b
   where gantt_config_id = c_gantt_config_id;

Line: 354


          savepoint delete_gantt_config;

Line: 362


          pa_debug.set_curr_function( p_function   => 'DELETE_GANTT_CONFIG',
                                      p_debug_mode => l_debug_mode );

Line: 378


     PA_GANTT_CONFIG_PKG.DELETE_ROW(
          X_GANTT_CONFIG_ID   =>   p_gantt_config_id
     );

Line: 383


          pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';

Line: 413


          rollback to delete_gantt_config;

Line: 426


                    ,p_procedure_name  => 'DELETE_GANTT_CONFIG'
                    ,p_error_text      => x_msg_data);

Line: 437


          rollback to delete_gantt_config;

Line: 441


END DELETE_GANTT_CONFIG;