1 PACKAGE AZW_PROC AUTHID CURRENT_USER AS
2 /* $Header: AZWPROCS.pls 115.12 99/08/13 11:20:03 porting shi $ */
3
4 TYPE context_rec_t IS RECORD (
5 context_id az_processes.context_id%TYPE,
6 context_name az_processes.context_name%TYPE);
7
8 TYPE context_tbl_t IS TABLE OF context_rec_t INDEX BY BINARY_INTEGER;
9
10 --
11 -- Name: get_application_name
12 -- Description: given an application id, find the corresponding application
13 -- name. Called by AZW_HIER and AZW_GROUP package.
14 -- Parameters: none
15 --
16 FUNCTION get_application_name(appl_id NUMBER) RETURN VARCHAR2;
17
18
19 --
20 -- Name: get_context
21 -- Description: given a context type, return all context instances belonging
22 -- to that type. Called by AZW_PROC and AZW_HIER package.
23 -- Parameters:
24 -- ctx_type: context type of BG, SOB, OU, or IO.
25 --
26 PROCEDURE get_context(ctx_type IN VARCHAR2, ctx_table OUT context_tbl_t);
27
28 --
29 -- Name: get_lookup_meaning
30 -- Description: given a lookup code, find the corresponding meaning.
31 -- Called by AZW_HIER and AZW_GROUP package.
32 -- Parameters: none
33 --
34 FUNCTION get_lookup_meaning(code VARCHAR2) RETURN VARCHAR2;
35
36 --
37 -- Name: parse_application_ids
38 -- Description: parses a string of app ids, returning one appl_id at a time.
39 -- Called by AZW_FLOW and AZW_REPORT package.
40 -- Parameters:
41 -- p_application_ids - string of application ids delimited by commas
42 -- id_cnt
43 --
44 FUNCTION parse_application_ids(p_application_ids IN VARCHAR2,
45 id_cnt IN NUMBER) RETURN NUMBER;
46 --
47 -- Name: az_start_task
48 -- Description: starts a new task and passes its display string.
49 -- Called by AZWIZARD.fmb.
50 -- Parameters:
51 -- item_type - first part of the process identification
52 -- process_name - second part of the process identification
53 -- context_id - third/last part of the process identification
54 -- role - role assigned to the task
55 --
56 FUNCTION az_start_task(node_id IN VARCHAR2, role IN VARCHAR2) RETURN VARCHAR2;
57
58 --
59 -- Name: populate_az_processes
60 -- Description: updates AZ_PROCESSES table
61 -- Called by AZW_HIER package.
62 -- Parameters:
63 -- None
64 --
65 PROCEDURE populate_az_processes;
66
67 --
68 -- Name: az_reassign_task
69 -- Description: reassigns a task and returns the new label.
70 -- Called by AZWIZARD.fmb.
71 -- Parameters:
72 -- node_id - concatenated task identifier: item_type, process_name
73 -- context_id, item_key
74 --
75 FUNCTION az_reassign_task(node_id IN VARCHAR2, p_role IN VARCHAR2)
76 RETURN VARCHAR2;
77
78 --
79 -- Name: az_abort_task
80 -- Description: aborts a task and returns its label.
81 -- Called by AZWIZARD.fmb.
82 -- Parameters:
83 -- node_id - concatenated task identifier: item_type, process_name
84 -- context_id, item_key
85 --
86 FUNCTION az_abort_task(node_id IN VARCHAR2) RETURN VARCHAR2;
87
88 --
89 -- Name: update_process_comments
90 -- Description: updates comments for a given process.
91 -- Called by AZWIZARD.fmb.
92 -- Parameters:
93 -- item_type - first part of the process identification
94 -- process_name - second part of the process identification
95 -- context_id - third/last part of the process identification
96 -- value - the new value to be updated
97 --
98 PROCEDURE update_process_comments(node_id IN VARCHAR2, value IN VARCHAR2);
99
100 --
101 -- Name: update_process_status
102 -- Description: updates status information for a given process.
103 -- Called by AZWIZARD.fmb.
104 -- Parameters:
105 -- item_type - first part of the process identification
106 -- process_name - second part of the process identification
107 -- context_id - third/last part of the process identification
108 -- value - the new value to be updated
109 --
110 PROCEDURE update_process_status(node_id IN VARCHAR2, value IN VARCHAR2);
111
112 --
113 -- Name: get_group_color
114 -- Description: gets color for a task.
115 -- Called by AZWIZARD.fmb.
116 -- Parameters:
117 -- node_id - concatenated task identifier: item_type, process_name
118 -- context_id, item_key
119 --
120 FUNCTION get_group_color(node_id IN VARCHAR2) RETURN VARCHAR2;
121
122 --
123 -- Name: parse_item_type
124 -- Description: returns item_type for a task/process.
125 -- Called by AZWIZARD.fmb.
126 -- Parameters:
127 -- task node id
128 --
129 FUNCTION parse_item_type(node_id IN VARCHAR2) RETURN VARCHAR2;
130
131 --
132 -- Name: parse_item_key
133 -- Description: returns item_key for a task.
134 -- Called by AZWIZARD.fmb.
135 -- Parameters:
136 -- task node id
137 --
138 FUNCTION parse_item_key(node_id IN VARCHAR2) RETURN VARCHAR2;
139
140 --
141 -- Name: parse_process_name
142 -- Description: returns process_name for a process.
143 -- Called by AZWIZARD.fmb.
144 -- Parameters:
145 -- node_id - Node id for a process (Item_Type.Process_Name.Ctxt_Id)
146 --
147 FUNCTION parse_process_name(node_id IN VARCHAR2) RETURN VARCHAR2;
148
149 --
150 -- Name: parse_process_name_task
151 -- Description: returns process name for a task.
152 -- Called by AZWIZARD.fmb.
153 -- Parameters:
154 -- node_id - Node id for task: Item_Type.Process_Name.Ctxt_I.item_key
155 --
156 FUNCTION parse_process_name_task(node_id IN VARCHAR2) RETURN VARCHAR2;
157
158 --
159 -- Name: parse_context_id
160 -- Description: returns context id.
161 -- Called by AZWIZARD.fmb.
162 -- Parameters:
163 -- node id for process
164 --
165 FUNCTION parse_context_id(node_id IN VARCHAR2) RETURN VARCHAR2;
166
167 --
168 -- Name: parse_ctxt_id_task
169 -- Description: returns context id.
170 -- Called by AZWIZARD.fmb.
171 -- Parameters:
172 -- node id for task
173 --
174 FUNCTION parse_ctxt_id_task(node_id IN VARCHAR2) RETURN NUMBER;
175
176 --
177 -- Name: get_task_label
178 -- Description: given a task node id for a task return it's display label.
179 -- Called by AZWIZARD.fmb.
180 -- Parameters:
181 -- node id for task
182 --
183 FUNCTION get_task_label(node_id IN VARCHAR2) RETURN VARCHAR2;
184
185 --
186 -- Name: get_task_status
187 -- Description: given a task node id for a task return it's status.
188 -- Called by AZWIZARD.fmb.
189 -- Parameters:
190 -- node id for task
191 --
192 FUNCTION get_task_status(node_id IN VARCHAR2) RETURN VARCHAR2;
193
194 --
195 -- Name: abort_running_tasks
196 -- Description: abort all tasks without an end_date.
197 -- Called by azwpdt.sql during upgrade from 11.0 to 11.5.
198 -- Parameters:
199 -- none
200 --
201 PROCEDURE abort_running_tasks;
202
203 --
204 -- Name: populate_process_status
205 -- Description: insert value of 'A', 'C', or 'N' into the status_code column
206 -- of AZ_PROCESSES
207 -- Called by azwpdt.sql during upgrade from 11.0 to 11.5.
208 -- Parameters:
209 -- none
210 --
211 PROCEDURE populate_process_status;
212
213 --
214 --
215 -- Name: process_has_active_tasks
216 -- Description:
217 -- This function checks if the specified process has any
218 -- active tasks.
219 -- Called by AZWIZARD.fmb when a process is marked complete.
220 -- Parameters:
221 -- node_id - concatenated task identifier: item_type, process_name
222 -- context_id, item_key
223 FUNCTION process_has_active_tasks(node_id IN VARCHAR2) RETURN BOOLEAN;
224
225 END AZW_PROC;