APPS.PA_GANTT_CONFIG_PUB SQL Statements

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

Line: 199

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: 239

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

Line: 302

     PA_GANTT_CONFIG_PVT.UPDATE_GANTT_CONFIG (
             P_COMMIT                     =>   P_COMMIT
            ,P_CALLING_MODULE             =>   P_CALLING_MODULE
            ,P_GANTT_CONFIG_ID            =>   P_GANTT_CONFIG_ID
            ,P_GANTT_VIEW_ID              =>   P_GANTT_VIEW_ID
            ,P_GANTT_CONFIG_USAGE         =>   P_GANTT_CONFIG_USAGE
            ,P_FILTER_CODE                =>   P_FILTER_CODE
            ,P_TIME_SCALE_CODE            =>   P_TIME_SCALE_CODE
            ,P_EXPAND_COLLAPSE_FLAG       =>   P_EXPAND_COLLAPSE_FLAG
            ,P_NUMBER_OF_DISPLAYED_ROWS   =>   P_NUMBER_OF_DISPLAYED_ROWS
            ,P_SHOW_ADDITIONAL_COL_FLAG   =>   P_SHOW_ADDITIONAL_COL_FLAG
            ,P_FOCUS_ENABLED_FLAG         =>   P_FOCUS_ENABLED_FLAG
            ,P_SHOW_HEADER_UI_FLAG        =>   P_SHOW_HEADER_UI_FLAG
            ,P_RECORD_VERSION_NUMBER      =>   P_RECORD_VERSION_NUMBER
            ,P_NAME                       =>   P_NAME
            ,P_DESCRIPTION                =>   P_DESCRIPTION
            ,X_RETURN_STATUS              =>   X_RETURN_STATUS
            ,X_MSG_COUNT                  =>   X_MSG_COUNT
            ,X_MSG_DATA                   =>   X_MSG_DATA
          );

Line: 331

          pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';

Line: 370

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

Line: 380

END UPDATE_GANTT_CONFIG;

Line: 383

procedure DELETE_GANTT_CONFIG (
  P_COMMIT                    in VARCHAR2 := 'N',
  P_CALLING_MODULE            in VARCHAR2 := 'SELF_SERVICE',
  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: 412

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

Line: 435

     PA_GANTT_CONFIG_PVT.DELETE_GANTT_CONFIG (
             P_COMMIT                  => P_COMMIT
            ,P_CALLING_MODULE          => P_CALLING_MODULE
            ,P_GANTT_CONFIG_ID         => P_GANTT_CONFIG_ID
            ,P_RECORD_VERSION_NUMBER   => P_RECORD_VERSION_NUMBER
            ,X_RETURN_STATUS           => X_RETURN_STATUS
            ,X_MSG_COUNT               => X_MSG_COUNT
            ,X_MSG_DATA                => X_MSG_DATA
          );

Line: 454

          pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';

Line: 493

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

Line: 503

END DELETE_GANTT_CONFIG;