[Home] [Help]
PACKAGE: APPS.AZW_REPORT
Source
1 PACKAGE AZW_REPORT AUTHID CURRENT_USER AS
2 /* $Header: AZWREPTS.pls 115.5 2000/03/08 11:22:52 pkm ship $ */
3
4 /*
5 **
6 ** Exceptions
7 **
8 */
9 application_exception exception;
10
11 /*
12 **
13 ** Exception Pragmas
14 **
15 */
16 pragma exception_init(application_exception, -20001);
17
18 /*
19 * Name:
20 * start_page
21 *
22 * Description:
23 * Entry point for inquiry reports.
24 *
25 * Parameters:
26 * None.
27 *
28 * Notes:
29 * It dynamically generates an html page for links to different reports.
30 */
31 PROCEDURE start_page;
32
33 /*
34 * Name:
35 * implementation_param_page
36 *
37 * Description:
38 * Generates parameter entry page for implementation processes report.
39 *
40 * Parameters:
41 * None.
42 *
43 * Notes:
44 * Linked from start_page.
45 */
46 PROCEDURE implementation_param_page;
47
48 /*
49 * Name:
50 * context_param_page
51 *
52 * Description:
53 * Generates parameter entry page for context processes report.
54 *
55 * Parameters:
56 * None.
57 *
58 * Notes:
59 * Linked from start_page.
60 */
61 PROCEDURE context_param_page;
62
63 /*
64 * Name:
65 * product_param_page
66 *
67 * Description:
68 * Generates parameter entry page for product processes report.
69 *
70 * Parameters:
71 * None.
72 *
73 * Notes:
74 * Linked from start_page.
75 */
76 PROCEDURE product_param_page;
77
78 /*
79 * Name:
80 * user_param_page
81 *
82 * Description:
83 * Generates parameter entry page for user performance report.
84 *
85 * Parameters:
86 * None.
87 *
88 * Notes:
89 * Linked from start_page.
90 */
91 PROCEDURE user_param_page;
92
93 /*
94 * Name:
95 * status_param_page
96 *
97 * Description:
98 * Generates parameter entry page for implementation status report.
99 *
100 * Parameters:
101 * None.
102 *
103 * Notes:
104 * Linked from start_page.
105 */
106 PROCEDURE status_param_page;
107
108 /*
109 * Name:
110 * implementation_report
111 *
112 * Description:
113 * Generates implementation processes report based on selected phases.
114 *
115 * Parameters:
116 * p_phase - selection criteria passed from paramter entry page.
117 * default is for all phases.
118 *
119 * Notes:
120 * Linked from implementation_param_page.
121 */
122 PROCEDURE implementation_report(p_phase IN VARCHAR2 DEFAULT NULL);
123
124 /*
125 * Name:
126 * context_report
127 *
128 * Description:
129 * Generates context processes report based on selected context type.
130 *
131 * Parameters:
132 * p_context - selection criteria passed from paramter entry page.
133 * default is for BG context.
134 *
135 * Notes:
136 * Linked from context_param_page. Possible values for p_context are
137 * BG, SOB, IO, OU, and NONE.
138 */
139 PROCEDURE context_report(p_context IN VARCHAR2);
140
141 /*
142 * Name:
143 * product_report
144 *
145 * Description:
146 * Generates product processes report based on selected product(s).
147 *
148 * Parameters:
149 * p_product_list - list of application ids for the products selected,
150 * concatenated with ",".
151 * p_artificial - see the notes below.
152 *
153 * Notes:
154 * Linked from product_param_page.
155 *
156 * Due to a possible bug in HTML forms, an extra parameter is used in
157 * the product parameter page in order to force the HTML page to display
158 * the 'Cancel' button. Since the extra parameter in the HTML page is
159 * sent to the product_report procedure, a second parameter is required
160 * (called p_artificial) as a workaround.
161 *
162 */
163 PROCEDURE product_report(p_product_list IN VARCHAR2,
164 p_artificial IN VARCHAR2 DEFAULT NULL);
165
166 /*
167 * Name:
168 * status_report
169 *
170 * Description:
171 * Generates processes report based on selected status(es).
172 *
173 * Parameters:
174 * p_status - status of the processes. default is for all statuses.
175 *
176 * Notes:
177 * Linked from status_param_page.
178 */
179 PROCEDURE status_report(p_status IN VARCHAR2 DEFAULT NULL);
180
181 /*
182 * Name:
183 * user_report
184 *
185 * Description:
186 * Generates processes report based on parameters.
187 *
188 * Parameters:
189 * p_user - users working on the processes of interest.
190 * default null for al users.
191 * p_status - status of the processes of interest.
192 * default null for all statuses.
193 * p_time_or_period - execution time (days) or period (dates) of the
194 * processes of interest. Possible values: T, P.
195 * default is 'T'.
196 * p_operator - used when p_time_or_period is T."<=" or ">=".
197 * default is '>='.
198 * p_days - used when p_time_or_period is T. number of days.
199 * default is 0 days.
200 * p_start - used when p_time_or_period is P. start date.
201 * p_end - used when p_time_or_period is P. end date.
202 *
203 * Notes:
204 * Linked from user_param_page.
205 */
206 PROCEDURE user_report(p_user IN VARCHAR2 DEFAULT NULL,
207 p_status IN VARCHAR2 DEFAULT NULL,
208 p_time_or_period IN VARCHAR2 DEFAULT 'T',
209 p_operator IN VARCHAR2 DEFAULT '>=',
210 p_days IN VARCHAR2 DEFAULT '0',
211 p_start IN VARCHAR2 DEFAULT NULL,
212 p_end IN VARCHAR2 DEFAULT NULL);
213
214
215 /*
216 * Name:
217 * task_details
218 *
219 * Description:
220 * Generates step details report for the specified task parameters.
221 *
222 * Parameters:
223 * p_process_groups
224 * p_ctx_type
225 * p_status
226 * p_start
227 * p_end
228 * p_time_elapsed
229 * p_item_type
230 * p_item_key
231 *
232 * Notes:
233 * Linked from status reports. Each task has a hyperlink that links.
234 * to this report.
235 */
236 PROCEDURE task_details (
237 p_process_groups IN VARCHAR2,
238 p_ctx_type IN VARCHAR2,
239 p_status IN VARCHAR2,
240 p_start IN VARCHAR2,
241 p_end IN VARCHAR2,
242 p_time_elapsed IN VARCHAR2,
243 p_item_type IN VARCHAR2,
244 p_item_key IN VARCHAR2);
245
246 /*
247 * Name:
248 * show_all_steps
249 *
250 * Description:
251 * Generates step details report for all the processes.
252 * available for the selected products.
253 *
254 * Parameters:
255 * p_selected_products
256 *
257 * Notes:
258 * Linked from product planning reports.
259 */
260 PROCEDURE show_all_steps(p_selected_products IN VARCHAR2);
261
262 /*
263 * Name:
264 * display_process_steps
265 *
266 * Description:
267 * It displays all the available steps for the specified
268 * process. It displays the activities in the same order
269 * of the work flow activities if the selected products
270 * are installed.
271 * It can be called as an an external procedure that
272 * displays the available steps for the specified process.
273 * It can be called from show_all_steps.
274 * And it can be called to display a subprocess, from
275 * print_activity.
276 *
277 * Parameters:
278 * p_selected_products
279 * p_item_type
280 * p_process_name
281 * p_process_groups
282 * p_new_call
283 * p_external_call
284 *
285 * Notes:
286 *
287 */
288 PROCEDURE display_process_steps (
289 p_selected_products IN VARCHAR2,
290 p_item_type IN VARCHAR2,
291 p_process_name IN VARCHAR2,
292 p_context_type_name IN VARCHAR2,
293 p_process_groups IN VARCHAR2,
294 p_new_call IN VARCHAR2 DEFAULT NULL,
295 p_external_call IN VARCHAR2 DEFAULT NULL);
296
297 END AZW_REPORT;