1 PACKAGE pa_client_extn_status AUTHID CURRENT_USER as
2 /* $Header: PAXVPS2S.pls 120.2 2006/07/21 09:15:52 ajdas noship $ */
3 /*#
4 * You can use a PSI client extension to derive an alternate column value, even if you have entered a column definition in the PSI Columns
5 * window. You can also use the extension to override the totals fields in the Project window.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Project Status inquiry(PSI)
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_PERF_REPORTING
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16 --=======================================================
17 --
18 -------------------------------------------------------------------------------------------------
19 -- Function to determine if the corresponding body should be used by the
20 -- Post-Query trigger in Project Status Inquiry form.
21 --------------------------------------------------------------------------------------------------
22 --
23
24 FUNCTION ProjCustomExtn RETURN VARCHAR2;
25 pragma RESTRICT_REFERENCES (ProjCustomExtn, WNDS, WNPS );
26
27 FUNCTION TaskCustomExtn RETURN VARCHAR2;
28 pragma RESTRICT_REFERENCES (TaskCustomExtn, WNDS, WNPS );
29
30 FUNCTION RsrcCustomExtn RETURN VARCHAR2;
31 pragma RESTRICT_REFERENCES (RsrcCustomExtn, WNDS, WNPS );
32
33 --------------------------------------------------------------------------------------------
34 -- 14-JUL-99, jwhite: Added Functions for PSI Project Status Totals Functionality
35
36 FUNCTION Hide_Totals RETURN VARCHAR2;
37 pragma RESTRICT_REFERENCES (Hide_Totals, WNDS, WNPS );
38
39 FUNCTION Proj_Tot_Custom_Extn RETURN VARCHAR2;
40 pragma RESTRICT_REFERENCES (Proj_Tot_Custom_Extn, WNDS, WNPS );
41 --
42 --------------------------------------------------------------------------------------------
43
44
45 --
46 -------------------------------------------------------------------------------
47 -- Generic Procedure to Process Derived Columns in Oracle Forms'
48 -- Project Status Inquiry
49 -------------------------------------------------------------------------------
50 --
51
52
53
54
55 /*#
56 * If you enable the Get Columns procedure, the Project Status window display the column prompts defined in the PSI Columns window and
57 * the values calculated by the extension.Because the values calculated by the extension override values defined values defined in the
58 * PSI Columns window ,you do not need to enter a definition for a column whose value is Calculated by a client extension.
59 * @param x_project_id The identifier of the project.
60 * @rep:paraminfo {@rep:required}
61 * @param x_task_id The identifier of the task. This value is set to 0 if called for the project level columns.
62 * @rep:paraminfo {@rep:required}
63 * @param x_resource_list_member_id The identifier for the resource. This value is set to 0 if called for project or task level columns.
64 * @rep:paraminfo {@rep:required}
65 * @param x_cost_budget_type_code The identifier of the cost budget type displayed in PSI.
66 * @rep:paraminfo {@rep:required}
67 * @param x_rev_budget_type_code The identifier of the revenue budget type displayed in PSI.
68 * @rep:paraminfo {@rep:required}
69 * @param x_status_view The identifier of the status folder: PROJECTS, TASKS, or RESOURCES
70 * @rep:paraminfo {@rep:required}
71 * @param x_pa_install The identifier of the Oracle Projects product installed:BILLING or COSTING.
72 * BILLING includes all default PSI columns. COSTING includes all but the actual revenue and revenue budget columns.
73 * @rep:paraminfo {@rep:required}
74 * @param x_derived_col_1 Three alphanumeric derived columns. Each can have up to 255 characters. Note: Column 1
75 * refers to the first column in both the PSI Columns and the Project Status windows, Column 2 refers to the second
76 * column in each window, etc.
77 * @rep:paraminfo {@rep:required}
78 * @param x_derived_col_2 Three alphanumeric derived columns. Each can have up to 255 characters. Note: Column 1
79 * refers to the first column in both the PSI Columns and the Project Status windows, Column 2 refers to the second
80 * column in each window, etc.
81 * @rep:paraminfo {@rep:required}
82 * @param x_derived_col_3 Three alphanumeric derived columns. Each can have up to 255 characters. Note: Column 1
83 * refers to the first column in both the PSI Columns and the Project Status windows, Column 2 refers to the second
84 * column in each window, etc.
85 * @rep:paraminfo {@rep:required}
86 * @param x_derived_col_4 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
87 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
88 * @rep:paraminfo {@rep:required}
89 * @param x_derived_col_5 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
90 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
91 * @rep:paraminfo {@rep:required}
92 * @param x_derived_col_6 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
93 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
94 * @rep:paraminfo {@rep:required}
95 * @param x_derived_col_7 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
96 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
97 * @rep:paraminfo {@rep:required}
98 * @param x_derived_col_8 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
99 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
100 * @rep:paraminfo {@rep:required}
101 * @param x_derived_col_9 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
102 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
103 * @rep:paraminfo {@rep:required}
104 * @param x_derived_col_10 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
105 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
106 * @rep:paraminfo {@rep:required}
107 * @param x_derived_col_11 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
108 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
109 * @rep:paraminfo {@rep:required}
110 * @param x_derived_col_12 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
111 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
112 * @rep:paraminfo {@rep:required}
113 * @param x_derived_col_13 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
114 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
115 * @rep:paraminfo {@rep:required}
116 * @param x_derived_col_14 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
117 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
118 * @rep:paraminfo {@rep:required}
119 * @param x_derived_col_15 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
120 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
121 * @rep:paraminfo {@rep:required}
122 * @param x_derived_col_16 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
123 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
124 * @rep:paraminfo {@rep:required}
125 * @param x_derived_col_17 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
126 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
127 * @rep:paraminfo {@rep:required}
128 * @param x_derived_col_18 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
129 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
130 * @rep:paraminfo {@rep:required}
131 * @param x_derived_col_19 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
132 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
133 * @rep:paraminfo {@rep:required}
134 * @param x_derived_col_20 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
135 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
136 * @rep:paraminfo {@rep:required}
137 * @param x_derived_col_21 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
138 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
139 * @rep:paraminfo {@rep:required}
140 * @param x_derived_col_22 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
141 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
142 * @rep:paraminfo {@rep:required}
143 * @param x_derived_col_23 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
144 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
145 * @rep:paraminfo {@rep:required}
146 * @param x_derived_col_24 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
147 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
148 * @rep:paraminfo {@rep:required}
149 * @param x_derived_col_25 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
150 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
151 * @rep:paraminfo {@rep:required}
152 * @param x_derived_col_26 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
153 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
154 * @rep:paraminfo {@rep:required}
155 * @param x_derived_col_27 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
156 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
157 * @rep:paraminfo {@rep:required}
158 * @param x_derived_col_28 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
159 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
160 * @rep:paraminfo {@rep:required}
161 * @param x_derived_col_29 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
162 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
163 * @rep:paraminfo {@rep:required}
164 * @param x_derived_col_30 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
165 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
166 * @rep:paraminfo {@rep:required}
167 * @param x_derived_col_31 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
168 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
169 * @rep:paraminfo {@rep:required}
170 * @param x_derived_col_32 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
171 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
172 * @rep:paraminfo {@rep:required}
173 * @param x_derived_col_33 30 numeric derived columns.Note: Column 4 refers to the fourth column in both the PSI
174 * Columns and the Project Status windows, Column 5 refers to the fifth column in each window, etc.
175 * @rep:paraminfo {@rep:required}
176 * @rep:scope public
177 * @rep:lifecycle active
178 * @rep:displayname Get Columns.
179 * @rep:compatibility S
180 */
181
182
183
184
185
186
187 PROCEDURE getcols
188 (x_project_id IN NUMBER
189 , x_task_id IN NUMBER
190 , x_resource_list_member_id IN NUMBER
191 , x_cost_budget_type_code IN VARCHAR2
192 , x_rev_budget_type_code IN VARCHAR2
193 , x_status_view IN VARCHAR2
194 , x_pa_install IN VARCHAR2
195 , x_derived_col_1 OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
196 , x_derived_col_2 OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
197 , x_derived_col_3 OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
198 , x_derived_col_4 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
199 , x_derived_col_5 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
200 , x_derived_col_6 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
201 , x_derived_col_7 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
202 , x_derived_col_8 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203 , x_derived_col_9 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
204 , x_derived_col_10 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
205 , x_derived_col_11 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
206 , x_derived_col_12 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
207 , x_derived_col_13 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
208 , x_derived_col_14 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
209 , x_derived_col_15 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
210 , x_derived_col_16 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
211 , x_derived_col_17 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
212 , x_derived_col_18 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
213 , x_derived_col_19 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
214 , x_derived_col_20 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
215 , x_derived_col_21 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
216 , x_derived_col_22 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
217 , x_derived_col_23 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
218 , x_derived_col_24 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219 , x_derived_col_25 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
220 , x_derived_col_26 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
221 , x_derived_col_27 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
222 , x_derived_col_28 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
223 , x_derived_col_29 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
224 , x_derived_col_30 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
225 , x_derived_col_31 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
226 , x_derived_col_32 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
227 , x_derived_col_33 OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
228
229 --
230 -------------------------------------------------------------------------------
231 -- 03-AUG-99, jwhite
232 -- Generic Procedure to Process Totals
233 -------------------------------------------------------------------------------
234 --
235
236 /*#
237 * If you enable the PSI Totals client extension, you can override the total fields for all thirty numeric columns on the project window
238 * for which you assign values to the OUT-parameters.The project window displays NULL for any OUT-parameter that is not assigned a value.
239 * @param x_where_clause The where clause of the totals query statement.
240 * @rep:paraminfo {@rep:required}
241 * @param x_in_tot_column4 30 totals columns. The totals query assigns the totals that it returns to these columns.
242 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
243 * @rep:paraminfo {@rep:required}
244 * @param x_in_tot_column5 30 totals columns. The totals query assigns the totals that it returns to these columns.
245 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
246 * @rep:paraminfo {@rep:required}
247 * @param x_in_tot_column6 30 totals columns. The totals query assigns the totals that it returns to these columns.
248 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
249 * @rep:paraminfo {@rep:required}
250 * @param x_in_tot_column7 30 totals columns. The totals query assigns the totals that it returns to these columns.
251 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
252 * @rep:paraminfo {@rep:required}
253 * @param x_in_tot_column8 30 totals columns. The totals query assigns the totals that it returns to these columns.
254 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
255 * @rep:paraminfo {@rep:required}
256 * @param x_in_tot_column9 30 totals columns. The totals query assigns the totals that it returns to these columns.
257 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
258 * @rep:paraminfo {@rep:required}
259 * @param x_in_tot_column10 30 totals columns. The totals query assigns the totals that it returns to these columns.
260 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
261 * @rep:paraminfo {@rep:required}
262 * @param x_in_tot_column11 30 totals columns. The totals query assigns the totals that it returns to these columns.
266 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
263 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
264 * @rep:paraminfo {@rep:required}
265 * @param x_in_tot_column12 30 totals columns. The totals query assigns the totals that it returns to these columns.
267 * @rep:paraminfo {@rep:required}
268 * @param x_in_tot_column13 30 totals columns. The totals query assigns the totals that it returns to these columns.
269 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
270 * @rep:paraminfo {@rep:required}
271 * @param x_in_tot_column14 30 totals columns. The totals query assigns the totals that it returns to these columns.
272 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
273 * @rep:paraminfo {@rep:required}
274 * @param x_in_tot_column15 30 totals columns. The totals query assigns the totals that it returns to these columns.
275 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
276 * @rep:paraminfo {@rep:required}
277 * @param x_in_tot_column16 30 totals columns. The totals query assigns the totals that it returns to these columns.
278 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
279 * @rep:paraminfo {@rep:required}
280 * @param x_in_tot_column17 30 totals columns. The totals query assigns the totals that it returns to these columns.
281 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
282 * @rep:paraminfo {@rep:required}
283 * @param x_in_tot_column18 30 totals columns. The totals query assigns the totals that it returns to these columns.
284 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
285 * @rep:paraminfo {@rep:required}
286 * @param x_in_tot_column19 30 totals columns. The totals query assigns the totals that it returns to these columns.
287 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
288 * @rep:paraminfo {@rep:required}
289 * @param x_in_tot_column20 30 totals columns. The totals query assigns the totals that it returns to these columns.
290 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
291 * @rep:paraminfo {@rep:required}
292 * @param x_in_tot_column21 30 totals columns. The totals query assigns the totals that it returns to these columns.
293 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
294 * @rep:paraminfo {@rep:required}
295 * @param x_in_tot_column22 30 totals columns. The totals query assigns the totals that it returns to these columns.
296 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
297 * @rep:paraminfo {@rep:required}
298 * @param x_in_tot_column23 30 totals columns. The totals query assigns the totals that it returns to these columns.
299 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
300 * @rep:paraminfo {@rep:required}
301 * @param x_in_tot_column24 30 totals columns. The totals query assigns the totals that it returns to these columns.
302 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
303 * @rep:paraminfo {@rep:required}
304 * @param x_in_tot_column25 30 totals columns. The totals query assigns the totals that it returns to these columns.
305 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
306 * @rep:paraminfo {@rep:required}
307 * @param x_in_tot_column26 30 totals columns. The totals query assigns the totals that it returns to these columns.
308 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
309 * @rep:paraminfo {@rep:required}
310 * @param x_in_tot_column27 30 totals columns. The totals query assigns the totals that it returns to these columns.
311 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
312 * @rep:paraminfo {@rep:required}
313 * @param x_in_tot_column28 30 totals columns. The totals query assigns the totals that it returns to these columns.
314 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
315 * @rep:paraminfo {@rep:required}
316 * @param x_in_tot_column29 30 totals columns. The totals query assigns the totals that it returns to these columns.
317 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
318 * @rep:paraminfo {@rep:required}
319 * @param x_in_tot_column30 30 totals columns. The totals query assigns the totals that it returns to these columns.
320 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
321 * @rep:paraminfo {@rep:required}
322 * @param x_in_tot_column31 30 totals columns. The totals query assigns the totals that it returns to these columns.
323 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
324 * @rep:paraminfo {@rep:required}
325 * @param x_in_tot_column32 30 totals columns. The totals query assigns the totals that it returns to these columns.
326 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
327 * @rep:paraminfo {@rep:required}
328 * @param x_in_tot_column33 30 totals columns. The totals query assigns the totals that it returns to these columns.
329 * Column 4 refers to the fourth column in the PSI columns and the Project Status Inquiry windows.
330 * @rep:paraminfo {@rep:required}
331 * @param x_out_tot_column4 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
332 * the fourth column in the PSI columns and the Project Status Inquiry windows.
333 * @rep:paraminfo {@rep:required}
334 * @param x_out_tot_column5 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
338 * the fourth column in the PSI columns and the Project Status Inquiry windows.
335 * the fourth column in the PSI columns and the Project Status Inquiry windows.
336 * @rep:paraminfo {@rep:required}
337 * @param x_out_tot_column6 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
339 * @rep:paraminfo {@rep:required}
340 * @param x_out_tot_column7 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
341 * the fourth column in the PSI columns and the Project Status Inquiry windows.
342 * @rep:paraminfo {@rep:required}
343 * @param x_out_tot_column8 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
344 * the fourth column in the PSI columns and the Project Status Inquiry windows.
345 * @rep:paraminfo {@rep:required}
346 * @param x_out_tot_column9 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
347 * the fourth column in the PSI columns and the Project Status Inquiry windows.
348 * @rep:paraminfo {@rep:required}
349 * @param x_out_tot_column10 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
350 * the fourth column in the PSI columns and the Project Status Inquiry windows.
351 * @rep:paraminfo {@rep:required}
352 * @param x_out_tot_column11 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
353 * the fourth column in the PSI columns and the Project Status Inquiry windows.
354 * @rep:paraminfo {@rep:required}
355 * @param x_out_tot_column12 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
356 * the fourth column in the PSI columns and the Project Status Inquiry windows.
357 * @rep:paraminfo {@rep:required}
358 * @param x_out_tot_column13 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
359 * the fourth column in the PSI columns and the Project Status Inquiry windows.
360 * @rep:paraminfo {@rep:required}
361 * @param x_out_tot_column14 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
362 * the fourth column in the PSI columns and the Project Status Inquiry windows.
363 * @rep:paraminfo {@rep:required}
364 * @param x_out_tot_column15 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
365 * the fourth column in the PSI columns and the Project Status Inquiry windows.
366 * @rep:paraminfo {@rep:required}
367 * @param x_out_tot_column16 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
368 * the fourth column in the PSI columns and the Project Status Inquiry windows.
369 * @rep:paraminfo {@rep:required}
370 * @param x_out_tot_column17 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
371 * the fourth column in the PSI columns and the Project Status Inquiry windows.
372 * @rep:paraminfo {@rep:required}
373 * @param x_out_tot_column18 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
374 * the fourth column in the PSI columns and the Project Status Inquiry windows.
375 * @rep:paraminfo {@rep:required}
376 * @param x_out_tot_column19 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
377 * the fourth column in the PSI columns and the Project Status Inquiry windows.
378 * @rep:paraminfo {@rep:required}
379 * @param x_out_tot_column20 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
380 * the fourth column in the PSI columns and the Project Status Inquiry windows.
381 * @rep:paraminfo {@rep:required}
382 * @param x_out_tot_column21 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
383 * the fourth column in the PSI columns and the Project Status Inquiry windows.
384 * @rep:paraminfo {@rep:required}
385 * @param x_out_tot_column22 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
386 * the fourth column in the PSI columns and the Project Status Inquiry windows.
387 * @rep:paraminfo {@rep:required}
388 * @param x_out_tot_column23 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
389 * the fourth column in the PSI columns and the Project Status Inquiry windows.
390 * @rep:paraminfo {@rep:required}
391 * @param x_out_tot_column24 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
392 * the fourth column in the PSI columns and the Project Status Inquiry windows.
393 * @rep:paraminfo {@rep:required}
394 * @param x_out_tot_column25 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
395 * the fourth column in the PSI columns and the Project Status Inquiry windows.
396 * @rep:paraminfo {@rep:required}
397 * @param x_out_tot_column26 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
398 * the fourth column in the PSI columns and the Project Status Inquiry windows.
399 * @rep:paraminfo {@rep:required}
400 * @param x_out_tot_column27 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
401 * the fourth column in the PSI columns and the Project Status Inquiry windows.
402 * @rep:paraminfo {@rep:required}
403 * @param x_out_tot_column28 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
404 * the fourth column in the PSI columns and the Project Status Inquiry windows.
405 * @rep:paraminfo {@rep:required}
406 * @param x_out_tot_column29 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
407 * the fourth column in the PSI columns and the Project Status Inquiry windows.
408 * @rep:paraminfo {@rep:required}
409 * @param x_out_tot_column30 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
410 * the fourth column in the PSI columns and the Project Status Inquiry windows.
411 * @rep:paraminfo {@rep:required}
412 * @param x_out_tot_column31 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
416 * the fourth column in the PSI columns and the Project Status Inquiry windows.
413 * the fourth column in the PSI columns and the Project Status Inquiry windows.
414 * @rep:paraminfo {@rep:required}
415 * @param x_out_tot_column32 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
417 * @rep:paraminfo {@rep:required}
418 * @param x_out_tot_column33 30 totals columns.The totals assigned by the Get_Totals procedure. Column 4 refers to
419 * the fourth column in the PSI columns and the Project Status Inquiry windows.
420 * @rep:paraminfo {@rep:required}
421 * @param x_error_code Error handling code. NOTE: A non-zero number invokes error
422 * processing by the PSI Project window and terminates totals processing.
423 * @rep:paraminfo {@rep:required}
424 * @param x_error_message User-defined error message.The non-zero error handling
425 * code and the user-defined message are displayed to the user in the event of an error.
426 * To facilitate debugging, the PSI Project window displays the totals returned by the totals
427 * query from PA_STATUS_PROJ_TOTALS_V.
428 * @rep:paraminfo {@rep:required}
429 * @rep:scope public
430 * @rep:lifecycle active
431 * @rep:displayname Get Totals.
432 * @rep:compatibility S
433 */
434
435
436 PROCEDURE Get_Totals
437 (x_where_clause IN VARCHAR2
438 , x_in_tot_column4 IN NUMBER
439 , x_in_tot_column5 IN NUMBER
440 , x_in_tot_column6 IN NUMBER
441 , x_in_tot_column7 IN NUMBER
442 , x_in_tot_column8 IN NUMBER
443 , x_in_tot_column9 IN NUMBER
444 , x_in_tot_column10 IN NUMBER
445 , x_in_tot_column11 IN NUMBER
446 , x_in_tot_column12 IN NUMBER
447 , x_in_tot_column13 IN NUMBER
448 , x_in_tot_column14 IN NUMBER
449 , x_in_tot_column15 IN NUMBER
450 , x_in_tot_column16 IN NUMBER
451 , x_in_tot_column17 IN NUMBER
452 , x_in_tot_column18 IN NUMBER
453 , x_in_tot_column19 IN NUMBER
454 , x_in_tot_column20 IN NUMBER
455 , x_in_tot_column21 IN NUMBER
456 , x_in_tot_column22 IN NUMBER
457 , x_in_tot_column23 IN NUMBER
458 , x_in_tot_column24 IN NUMBER
459 , x_in_tot_column25 IN NUMBER
460 , x_in_tot_column26 IN NUMBER
461 , x_in_tot_column27 IN NUMBER
462 , x_in_tot_column28 IN NUMBER
463 , x_in_tot_column29 IN NUMBER
464 , x_in_tot_column30 IN NUMBER
465 , x_in_tot_column31 IN NUMBER
466 , x_in_tot_column32 IN NUMBER
467 , x_in_tot_column33 IN NUMBER
468 , x_out_tot_column4 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
469 , x_out_tot_column5 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
470 , x_out_tot_column6 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
471 , x_out_tot_column7 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
472 , x_out_tot_column8 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
473 , x_out_tot_column9 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
474 , x_out_tot_column10 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
475 , x_out_tot_column11 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
476 , x_out_tot_column12 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
477 , x_out_tot_column13 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
481 , x_out_tot_column17 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478 , x_out_tot_column14 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
479 , x_out_tot_column15 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
480 , x_out_tot_column16 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
482 , x_out_tot_column18 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
483 , x_out_tot_column19 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
484 , x_out_tot_column20 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
485 , x_out_tot_column21 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
486 , x_out_tot_column22 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
487 , x_out_tot_column23 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
488 , x_out_tot_column24 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
489 , x_out_tot_column25 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
490 , x_out_tot_column26 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
491 , x_out_tot_column27 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
492 , x_out_tot_column28 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
493 , x_out_tot_column29 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
494 , x_out_tot_column30 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
495 , x_out_tot_column31 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
496 , x_out_tot_column32 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
497 , x_out_tot_column33 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
498 , x_error_code OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499 , x_error_message OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500 );
501
502 END pa_client_extn_status;