[Home] [Help]
71: where uniq <> 0;
72: --+
73: cursor chkActionTypeNonSerialPar(applicationIdIn in number) is
74: select 'Y'
75: from ame_action_type_config
76: where application_id = applicationIdIn
77: and (chain_ordering_mode <> ame_util.serialChainsMode
78: or ( voting_regime is not null and
79: voting_regime <> ame_util.serializedVoting
84: --+
85: cursor chkActionTypeNonUniqueOrder(applicationIdIn in number) is
86: select 'Y'
87: from (select distinct (count(order_number) - count(distinct order_number)) uniq
88: from ame_action_type_config acf,
89: ame_action_type_usages axu
90: where acf.application_id = applicationIdIn
91: and acf.action_type_id = axu.action_type_id
92: and sysdate between acf.start_date and
184: raise parallelizationFoundException;
185: end if;
186: close chkItemClassNonUniqueOrder;
187: --+
188: --Check if parallelization is induced into ame_action_type_config
189: --by checking the columns chain_ordering_mode and voting_regime.
190: --Throw error if any of them has non serial value.
191: --+
192: tempAMEObject := 'Action type non serail mode';
197: raise parallelizationFoundException;
198: end if;
199: close chkActionTypeNonSerialPar;
200: --+
201: --Check if parallelization is induced into ame_action_type_config
202: --by ensuring that no two action types belonging to a rule type
203: --have same order number.
204: --+
205: tempAMEObject := 'Action type non serial order number';