1 package PA_GANTT_VIEWS_PKG as
2 /* $Header: PAGCGVTS.pls 120.1 2005/08/19 16:33:15 mwasowic noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY ROWID --File.Sql.39 bug 4440895
6 ,X_GANTT_VIEW_ID in NUMBER
7 ,X_GANTT_VIEW_USAGE in VARCHAR2
8 ,X_ENABLE_FLAG in VARCHAR2
9 ,X_SHOW_SUMMARY_ROOT_FLAG in VARCHAR2
10 ,X_SHOW_DEPENDENCIES_FLAG in VARCHAR2
11 ,X_SHOW_SPLIT_TASK_FLAG in VARCHAR2
12 ,X_BAR_HEIGHT in NUMBER
13 ,X_TABLE_BACKGROUND in NUMBER
14 ,X_TABLE_FOREGROUND in NUMBER
15 ,X_CHART_BACKGROUND in NUMBER
16 ,X_COMPARISON_FLAG in VARCHAR2
17 ,X_GANTT_BAR_TEXT_LEFT in VARCHAR2
18 ,X_GANTT_BAR_TEXT_RIGHT in VARCHAR2
19 ,X_GANTT_BAR_TEXT_TOP in VARCHAR2
20 ,X_GANTT_BAR_TEXT_BOTTOM in VARCHAR2
21 ,X_GANTT_BAR_TEXT_INSIDE in VARCHAR2
22 ,X_RECORD_VERSION_NUMBER in NUMBER
23 ,X_ATTRIBUTE_CATEGORY in VARCHAR2
24 ,X_ATTRIBUTE1 in VARCHAR2
25 ,X_ATTRIBUTE2 in VARCHAR2
26 ,X_ATTRIBUTE3 in VARCHAR2
27 ,X_ATTRIBUTE4 in VARCHAR2
28 ,X_ATTRIBUTE5 in VARCHAR2
29 ,X_ATTRIBUTE6 in VARCHAR2
30 ,X_ATTRIBUTE7 in VARCHAR2
31 ,X_ATTRIBUTE8 in VARCHAR2
32 ,X_ATTRIBUTE9 in VARCHAR2
33 ,X_ATTRIBUTE10 in VARCHAR2
34 ,X_ATTRIBUTE11 in VARCHAR2
35 ,X_ATTRIBUTE12 in VARCHAR2
36 ,X_ATTRIBUTE13 in VARCHAR2
37 ,X_ATTRIBUTE14 in VARCHAR2
38 ,X_ATTRIBUTE15 in VARCHAR2
39 ,X_NAME in VARCHAR2
40 ,X_DESCRIPTION in VARCHAR2
41 ,X_CREATION_DATE in DATE
42 ,X_CREATED_BY in NUMBER
43 ,X_LAST_UPDATE_DATE in DATE
44 ,X_LAST_UPDATED_BY in NUMBER
45 ,X_LAST_UPDATE_LOGIN in NUMBER
46 );
47
48 procedure LOCK_ROW (
49 X_GANTT_VIEW_ID in NUMBER,
50 X_GANTT_VIEW_USAGE in VARCHAR2,
51 X_ENABLE_FLAG in VARCHAR2,
52 X_SHOW_SUMMARY_ROOT_FLAG in VARCHAR2,
53 X_SHOW_DEPENDENCIES_FLAG in VARCHAR2,
54 X_SHOW_SPLIT_TASK_FLAG in VARCHAR2,
55 X_BAR_HEIGHT in NUMBER,
56 X_TABLE_BACKGROUND in NUMBER,
57 X_TABLE_FOREGROUND in NUMBER,
58 X_CHART_BACKGROUND in NUMBER,
59 X_COMPARISON_FLAG in VARCHAR2,
60 X_GANTT_BAR_TEXT_LEFT in VARCHAR2,
61 X_GANTT_BAR_TEXT_RIGHT in VARCHAR2,
62 X_GANTT_BAR_TEXT_TOP in VARCHAR2,
63 X_GANTT_BAR_TEXT_BOTTOM in VARCHAR2,
64 X_GANTT_BAR_TEXT_INSIDE in VARCHAR2,
65 X_RECORD_VERSION_NUMBER in NUMBER,
66 X_ATTRIBUTE_CATEGORY in VARCHAR2,
67 X_ATTRIBUTE1 in VARCHAR2,
68 X_ATTRIBUTE2 in VARCHAR2,
69 X_ATTRIBUTE3 in VARCHAR2,
70 X_ATTRIBUTE4 in VARCHAR2,
71 X_ATTRIBUTE5 in VARCHAR2,
72 X_ATTRIBUTE6 in VARCHAR2,
73 X_ATTRIBUTE7 in VARCHAR2,
74 X_ATTRIBUTE8 in VARCHAR2,
75 X_ATTRIBUTE9 in VARCHAR2,
76 X_ATTRIBUTE10 in VARCHAR2,
77 X_ATTRIBUTE11 in VARCHAR2,
78 X_ATTRIBUTE12 in VARCHAR2,
79 X_ATTRIBUTE13 in VARCHAR2,
80 X_ATTRIBUTE14 in VARCHAR2,
81 X_ATTRIBUTE15 in VARCHAR2,
82 X_NAME in VARCHAR2,
83 X_DESCRIPTION in VARCHAR2
84 );
85
86 procedure UPDATE_ROW (
87 X_GANTT_VIEW_ID in NUMBER,
88 X_GANTT_VIEW_USAGE in VARCHAR2,
89 X_ENABLE_FLAG in VARCHAR2,
90 X_SHOW_SUMMARY_ROOT_FLAG in VARCHAR2,
91 X_SHOW_DEPENDENCIES_FLAG in VARCHAR2,
92 X_SHOW_SPLIT_TASK_FLAG in VARCHAR2,
93 X_BAR_HEIGHT in NUMBER,
94 X_TABLE_BACKGROUND in NUMBER,
95 X_TABLE_FOREGROUND in NUMBER,
96 X_CHART_BACKGROUND in NUMBER,
97 X_COMPARISON_FLAG in VARCHAR2,
98 X_GANTT_BAR_TEXT_LEFT in VARCHAR2,
99 X_GANTT_BAR_TEXT_RIGHT in VARCHAR2,
100 X_GANTT_BAR_TEXT_TOP in VARCHAR2,
101 X_GANTT_BAR_TEXT_BOTTOM in VARCHAR2,
102 X_GANTT_BAR_TEXT_INSIDE in VARCHAR2,
103 X_RECORD_VERSION_NUMBER in NUMBER,
104 X_ATTRIBUTE_CATEGORY in VARCHAR2,
105 X_ATTRIBUTE1 in VARCHAR2,
106 X_ATTRIBUTE2 in VARCHAR2,
107 X_ATTRIBUTE3 in VARCHAR2,
108 X_ATTRIBUTE4 in VARCHAR2,
109 X_ATTRIBUTE5 in VARCHAR2,
110 X_ATTRIBUTE6 in VARCHAR2,
111 X_ATTRIBUTE7 in VARCHAR2,
112 X_ATTRIBUTE8 in VARCHAR2,
113 X_ATTRIBUTE9 in VARCHAR2,
114 X_ATTRIBUTE10 in VARCHAR2,
115 X_ATTRIBUTE11 in VARCHAR2,
116 X_ATTRIBUTE12 in VARCHAR2,
117 X_ATTRIBUTE13 in VARCHAR2,
118 X_ATTRIBUTE14 in VARCHAR2,
119 X_ATTRIBUTE15 in VARCHAR2,
120 X_NAME in VARCHAR2,
121 X_DESCRIPTION in VARCHAR2,
122 X_LAST_UPDATE_DATE in DATE,
123 X_LAST_UPDATED_BY in NUMBER,
124 X_LAST_UPDATE_LOGIN in NUMBER
125 );
126
127 procedure DELETE_ROW (
128 X_GANTT_VIEW_ID in NUMBER
129 );
130
131 procedure ADD_LANGUAGE;
132
133 procedure TRANSLATE_ROW(
134 X_GANTT_VIEW_ID in NUMBER
135 ,X_OWNER in VARCHAR2
136 ,X_NAME in VARCHAR2
137 ,X_DESCRIPTION in VARCHAR2
138 );
139
140 procedure LOAD_ROW(
141 X_GANTT_VIEW_ID in NUMBER
142 ,X_GANTT_VIEW_USAGE in VARCHAR2
143 ,X_COMPARISON_FLAG in VARCHAR2
144 ,X_ENABLE_FLAG in VARCHAR2
145 ,X_SHOW_SUMMARY_ROOT_FLAG in VARCHAR2
146 ,X_SHOW_DEPENDENCIES_FLAG in VARCHAR2
147 ,X_SHOW_SPLIT_TASK_FLAG in VARCHAR2
148 ,X_BAR_HEIGHT in NUMBER
149 ,X_TABLE_BACKGROUND in NUMBER
150 ,X_TABLE_FOREGROUND in NUMBER
151 ,X_CHART_BACKGROUND in NUMBER
152 ,X_GANTT_BAR_TEXT_LEFT in VARCHAR2
153 ,X_GANTT_BAR_TEXT_RIGHT in VARCHAR2
154 ,X_GANTT_BAR_TEXT_TOP in VARCHAR2
155 ,X_GANTT_BAR_TEXT_BOTTOM in VARCHAR2
156 ,X_GANTT_BAR_TEXT_INSIDE in VARCHAR2
157 ,X_RECORD_VERSION_NUMBER in NUMBER
158 ,X_ATTRIBUTE_CATEGORY in VARCHAR2
159 ,X_ATTRIBUTE1 in VARCHAR2
160 ,X_ATTRIBUTE2 in VARCHAR2
161 ,X_ATTRIBUTE3 in VARCHAR2
162 ,X_ATTRIBUTE4 in VARCHAR2
163 ,X_ATTRIBUTE5 in VARCHAR2
164 ,X_ATTRIBUTE6 in VARCHAR2
165 ,X_ATTRIBUTE7 in VARCHAR2
166 ,X_ATTRIBUTE8 in VARCHAR2
167 ,X_ATTRIBUTE9 in VARCHAR2
168 ,X_ATTRIBUTE10 in VARCHAR2
169 ,X_ATTRIBUTE11 in VARCHAR2
170 ,X_ATTRIBUTE12 in VARCHAR2
171 ,X_ATTRIBUTE13 in VARCHAR2
172 ,X_ATTRIBUTE14 in VARCHAR2
173 ,X_ATTRIBUTE15 in VARCHAR2
174 ,X_OWNER in VARCHAR2
175 ,X_NAME in VARCHAR2
176 ,X_DESCRIPTION in VARCHAR2
177 );
178
179 end PA_GANTT_VIEWS_PKG;