3:
4: procedure CREATE_GANTT_CONFIG (
5: P_COMMIT in VARCHAR2,
6: P_CALLING_MODULE in VARCHAR2,
7: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
4: procedure CREATE_GANTT_CONFIG (
5: P_COMMIT in VARCHAR2,
6: P_CALLING_MODULE in VARCHAR2,
7: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
5: P_COMMIT in VARCHAR2,
6: P_CALLING_MODULE in VARCHAR2,
7: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
6: P_CALLING_MODULE in VARCHAR2,
7: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
7: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
8: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
16: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
9: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
16: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
17: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
10: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
16: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
17: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
18: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
11: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
12: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
13: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
16: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
17: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
18: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
15: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
16: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
17: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
18: PX_GANTT_CONFIG_ID in OUT NOCOPY PA_GANTT_CONFIG_B.gantt_config_id%TYPE, --File.Sql.39 bug 4440895
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: );
24:
25: procedure UPDATE_GANTT_CONFIG (
26: P_COMMIT in VARCHAR2,
27: P_CALLING_MODULE in VARCHAR2,
28: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
25: procedure UPDATE_GANTT_CONFIG (
26: P_COMMIT in VARCHAR2,
27: P_CALLING_MODULE in VARCHAR2,
28: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
26: P_COMMIT in VARCHAR2,
27: P_CALLING_MODULE in VARCHAR2,
28: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
27: P_CALLING_MODULE in VARCHAR2,
28: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
28: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
29: P_GANTT_VIEW_ID in PA_GANTT_CONFIG_B.gantt_view_id%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
30: P_GANTT_CONFIG_USAGE in PA_GANTT_CONFIG_B.gantt_config_usage%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
38: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
31: P_FILTER_CODE in PA_GANTT_CONFIG_B.filter_code%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
38: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
39: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
32: P_TIME_SCALE_CODE in PA_GANTT_CONFIG_B.time_scale_code%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
38: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
39: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
40: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
33: P_EXPAND_COLLAPSE_FLAG in PA_GANTT_CONFIG_B.expand_collapse_flag%TYPE,
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
38: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
39: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
40: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34: P_NUMBER_OF_DISPLAYED_ROWS in PA_GANTT_CONFIG_B.number_of_displayed_rows%TYPE,
35: P_SHOW_ADDITIONAL_COL_FLAG in PA_GANTT_CONFIG_B.show_additional_col_flag%TYPE,
36: P_FOCUS_ENABLED_FLAG in PA_GANTT_CONFIG_B.focus_enabled_flag%TYPE,
37: P_SHOW_HEADER_UI_FLAG in PA_GANTT_CONFIG_B.show_header_ui_flag%TYPE,
38: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
39: P_NAME in PA_GANTT_CONFIG_TL.name%TYPE,
40: P_DESCRIPTION in PA_GANTT_CONFIG_TL.description%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
42: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45:
46: procedure DELETE_GANTT_CONFIG (
47: P_COMMIT in VARCHAR2,
48: P_CALLING_MODULE in VARCHAR2,
49: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
50: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: procedure DELETE_GANTT_CONFIG (
47: P_COMMIT in VARCHAR2,
48: P_CALLING_MODULE in VARCHAR2,
49: P_GANTT_CONFIG_ID in PA_GANTT_CONFIG_B.gantt_config_id%TYPE,
50: P_RECORD_VERSION_NUMBER in PA_GANTT_CONFIG_B.RECORD_VERSION_NUMBER%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
54: );