7:
8: procedure CREATE_GANTT_CONFIG (
9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
8: procedure CREATE_GANTT_CONFIG (
9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
9: P_COMMIT in VARCHAR2,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
10: P_CALLING_MODULE in VARCHAR2,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
11: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
12: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
13: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
14: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
15: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
16: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
17: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
23: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
19: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
20: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
21: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
22: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
23: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: )
156:
157: procedure UPDATE_GANTT_CONFIG (
158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
157: procedure UPDATE_GANTT_CONFIG (
158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
158: P_COMMIT in VARCHAR2 ,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
159: P_CALLING_MODULE in VARCHAR2 ,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
160: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
161: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
162: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
163: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
164: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
165: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
173: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
166: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
167: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
168: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
169: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
170: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
171: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
172: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
173: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
174: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
186: l_debug_level3 CONSTANT NUMBER := 3;
187: l_debug_level4 CONSTANT NUMBER := 4;
188: l_debug_level5 CONSTANT NUMBER := 5;
189:
190: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
191: is
192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;
189:
190: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
191: is
192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;
195:
196: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
197:
192: select record_version_number
193: from pa_gantt_config_b
194: where gantt_config_id = c_gantt_config_id;
195:
196: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
197:
198: BEGIN
199: IF p_commit = 'Y' THEN
200: savepoint update_gantt_config;
321:
322: procedure DELETE_GANTT_CONFIG (
323: P_COMMIT in VARCHAR2 ,
324: P_CALLING_MODULE in VARCHAR2 ,
325: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
326: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
327: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
329: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
322: procedure DELETE_GANTT_CONFIG (
323: P_COMMIT in VARCHAR2 ,
324: P_CALLING_MODULE in VARCHAR2 ,
325: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
326: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
327: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
329: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
330: )
340: l_debug_level3 CONSTANT NUMBER := 3;
341: l_debug_level4 CONSTANT NUMBER := 4;
342: l_debug_level5 CONSTANT NUMBER := 5;
343:
344: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
345: is
346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;
343:
344: CURSOR cur_gantt_config_rvn(c_gantt_config_id pa_gantt_config_b.gantt_config_id%TYPE)
345: is
346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;
349:
350: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
351:
346: select record_version_number
347: from pa_gantt_config_b
348: where gantt_config_id = c_gantt_config_id;
349:
350: l_gantt_config_rvn pa_gantt_config_b.record_version_number%TYPE;
351:
352: BEGIN
353: IF p_commit = 'Y' THEN
354: savepoint delete_gantt_config;