DBA Data[Home] [Help]

PACKAGE: APPS.PA_GANTT_CONFIG_PUB

Source


1 package PA_GANTT_CONFIG_PUB AUTHID CURRENT_USER as
2 /* $Header: PAGCGCPS.pls 120.1 2005/08/19 16:32:50 mwasowic noship $ */
3 
4 procedure CREATE_GANTT_CONFIG (
5   P_COMMIT                    in VARCHAR2 := 'N',
6   P_CALLING_MODULE            in VARCHAR2 := 'SELF_SERVICE',
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,
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   );
23 
24 
25 procedure UPDATE_GANTT_CONFIG (
26   P_COMMIT                    in VARCHAR2 := 'N',
27   P_CALLING_MODULE            in VARCHAR2 := 'SELF_SERVICE',
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,
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
43   X_MSG_DATA                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44 );
45 
46 procedure DELETE_GANTT_CONFIG (
47   P_COMMIT                    in VARCHAR2 := 'N',
48   P_CALLING_MODULE            in VARCHAR2 := 'SELF_SERVICE',
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 );
55 
56 end PA_GANTT_CONFIG_PUB;