The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
);
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;
select record_version_number
from pa_gantt_config_b
where gantt_config_id = c_gantt_config_id;
savepoint update_gantt_config;
pa_debug.set_curr_function( p_function => 'UPDATE_GANTT_CONFIG',
p_debug_mode => l_debug_mode );
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
);
pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';
rollback to update_gantt_config;
,p_procedure_name => 'UPDATE_GANTT_CONFIG'
,p_error_text => x_msg_data);
rollback to update_gantt_config;
END UPDATE_GANTT_CONFIG;
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;
select record_version_number
from pa_gantt_config_b
where gantt_config_id = c_gantt_config_id;
savepoint delete_gantt_config;
pa_debug.set_curr_function( p_function => 'DELETE_GANTT_CONFIG',
p_debug_mode => l_debug_mode );
PA_GANTT_CONFIG_PKG.DELETE_ROW(
X_GANTT_CONFIG_ID => p_gantt_config_id
);
pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';
rollback to delete_gantt_config;
,p_procedure_name => 'DELETE_GANTT_CONFIG'
,p_error_text => x_msg_data);
rollback to delete_gantt_config;
END DELETE_GANTT_CONFIG;