1 PACKAGE GCS_CONS_ENGINE_PKG as
2 /* $Header: gcs_eng_wfs.pls 120.1 2005/06/07 21:50:53 skamdar noship $ */
3
4 --
5 -- Procedure
6 -- prepare_immediate_children()
7 -- Purpose
8 -- Prepares Immediate Children (Operating and Consolidation Entities)
9 -- Arguments
10 -- item_type type of the current item
11 -- item_key key of the current item
12 -- actid process activity instance id
13 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
14 -- result
15 -- COMPLETE
16 -- Notes
17 --
18
19 PROCEDURE prepare_immediate_children( itemtype IN VARCHAR2,
20 itemkey IN VARCHAR2,
21 actid IN NUMBER,
22 funcmode IN varchar2,
23 result IN OUT NOCOPY varchar2);
24
25 --
26 -- Procedure
27 -- spawn_oper_entity_process()
28 -- Purpose
29 -- Spawns the operating entity process for all immediate children of the Consolidation Entity
30 -- Arguments
31 -- item_type type of the current item
32 -- item_key key of the current item
33 -- actid process activity instance id
34 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
35 -- result
36 -- COMPLETE[:T or :F]
37 -- Notes
38 --
39
40 PROCEDURE spawn_oper_entity_process( itemtype IN VARCHAR2,
41 itemkey IN VARCHAR2,
42 actid IN NUMBER,
43 funcmode IN varchar2,
44 result IN OUT NOCOPY varchar2);
45
46
47 --
48 -- Procedure
49 -- execute_data_preparation()
50 -- Purpose
51 -- Execute Data Preparation for a specific entity
52 -- Arguments
53 -- item_type type of the current item
54 -- item_key key of the current item
55 -- actid process activity instance id
56 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
57 -- result
58 -- COMPLETE[:T or :F]
59 -- Notes
60 --
61
62 PROCEDURE execute_data_preparation( itemtype IN VARCHAR2,
63 itemkey IN VARCHAR2,
64 actid IN NUMBER,
65 funcmode IN varchar2,
66 result IN OUT NOCOPY varchar2);
67
68
69 --
70 -- Procedure
71 -- check_aggregation_required()
72 -- Purpose
73 -- Checks if Aggregation is Required
74 -- Arguments
75 -- item_type type of the current item
76 -- item_key key of the current item
77 -- actid process activity instance id
78 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
79 -- result
80 -- COMPLETE[:T or :F]
81 -- Notes
82 --
83 PROCEDURE check_aggregation_required( itemtype IN VARCHAR2,
84 itemkey IN VARCHAR2,
85 actid IN NUMBER,
86 funcmode IN varchar2,
87 result IN OUT NOCOPY varchar2);
88
89 --
90 -- Procedure
91 -- execute_aggregation()
92 -- Purpose
93 -- Executes Aggregation for a Consolidation Entity
94 -- Arguments
95 -- item_type type of the current item
96 -- item_key key of the current item
97 -- actid process activity instance id
98 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
99 -- result
100 -- COMPLETE
101 -- WAITING
102 -- DEFERRED
103 -- NOTIFIED
104 -- ERROR
105 -- Notes
106 --
107
108 PROCEDURE execute_aggregation( itemtype IN VARCHAR2,
109 itemkey IN VARCHAR2,
110 actid IN NUMBER,
111 funcmode IN varchar2,
112 result IN OUT NOCOPY varchar2);
113
114 --
115 -- Procedure
116 -- raise_completion_event()
117 -- Purpose
118 -- Raises Completion Event for a Consolidation
119 -- Arguments
120 -- item_type type of the current item
121 -- item_key key of the current item
122 -- actid process activity instance id
123 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
124 -- result
125 -- COMPLETE
126 -- Notes
127 --
128 PROCEDURE raise_completion_event( itemtype IN VARCHAR2,
129 itemkey IN VARCHAR2,
130 actid IN NUMBER,
131 funcmode IN varchar2,
132 result IN OUT NOCOPY varchar2);
133
134 --
135 -- Procedure
136 -- spawn_cons_entity_process()
137 -- Purpose
138 -- Spawns consolidation entity process for all immediate children of the Consolidation Entity
139 -- Arguments
140 -- item_type type of the current item
141 -- item_key key of the current item
142 -- actid process activity instance id
143 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
144 -- result
145 -- COMPLETE[:T or :F]
146 -- Notes
147 --
148
149 PROCEDURE spawn_cons_entity_process( itemtype IN VARCHAR2,
150 itemkey IN VARCHAR2,
151 actid IN NUMBER,
152 funcmode IN varchar2,
153 result IN OUT NOCOPY varchar2);
154
155 --
156 -- Procedure
157 -- init_oper_entity_process()
158 -- Purpose
159 -- Checks which mode of data prep needs to be executed
160 -- Arguments
161 -- item_type type of the current item
162 -- item_key key of the current item
163 -- actid process activity instance id
164 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
165 -- result
166 -- COMPLETE[:FULL or :INCREMENTAL]
167 -- WAITING
168 -- DEFERRED
169 -- NOTIFIED
170 -- ERROR
171 -- Notes
172 --
173 PROCEDURE init_oper_entity_process( itemtype IN VARCHAR2,
174 itemkey IN VARCHAR2,
175 actid IN NUMBER,
176 funcmode IN varchar2,
177 result IN OUT NOCOPY varchar2);
178
179 --
180 -- Procedure
181 -- initialize_cons_process()
182 -- Purpose
183 -- Inserts all Categories into RUN_DETAILS for a Consolidation Entity
184 -- Arguments
185 -- item_type type of the current item
186 -- item_key key of the current item
187 -- actid process activity instance id
188 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
189 -- result
190 -- COMPLETE[]
191 -- Notes
192 --
193 PROCEDURE initialize_cons_process( itemtype IN VARCHAR2,
194 itemkey IN VARCHAR2,
195 actid IN NUMBER,
196 funcmode IN varchar2,
197 result IN OUT NOCOPY varchar2);
198
199 --
200 -- Procedure
201 -- check_cons_entity_status()
202 -- Purpose
203 -- Checks if a Consolidation Entity requires a rerun
204 -- Arguments
205 -- item_type type of the current item
206 -- item_key key of the current item
207 -- actid process activity instance id
208 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
209 -- result
210 -- COMPLETE[:T or :F]
211 -- Notes
212 --
213 PROCEDURE check_cons_entity_status( itemtype IN VARCHAR2,
214 itemkey IN VARCHAR2,
215 actid IN NUMBER,
216 funcmode IN varchar2,
217 result IN OUT NOCOPY varchar2);
218
219 --
220 -- Procedure
221 -- retrieve_prior_runs()
222 -- Purpose
223 -- Copies data for a prior run
224 -- Arguments
225 -- item_type type of the current item
226 -- item_key key of the current item
227 -- actid process activity instance id
228 -- funcmode function execution mode ('RUN', 'CANCEL', 'TIMEOUT')
229 -- result
230 -- COMPLETE[]
231 -- Notes
232 --
233 PROCEDURE retrieve_prior_runs( itemtype IN VARCHAR2,
234 itemkey IN VARCHAR2,
235 actid IN NUMBER,
236 funcmode IN varchar2,
237 result IN OUT NOCOPY varchar2);
238
239 END GCS_CONS_ENGINE_PKG;