APPS.AME_MIGRATE_PARALLEL_CONFIG dependencies on AME_ACTION_TYPE_CONFIG

Line 147: from ame_action_type_config aatc

143:
144: cursor unused_atype_config_cursor is
145: select aatc.application_id,
146: aatc.action_type_id
147: from ame_action_type_config aatc
148: where sysdate between aatc.start_date
149: and nvl(aatc.end_date - (1/86400),sysdate)
150: and not exists
151: (select /*+ use_nl (aa aru) */ null

Line 192: update ame_action_type_config master_cfg

188: l_action_type_id;
189:
190: exit when unused_atype_config_cursor%notfound;
191:
192: update ame_action_type_config master_cfg
193: set master_cfg.end_date = l_migration_date
194: where sysdate between master_cfg.start_date
195: and nvl(master_cfg.end_date - (1/86400),sysdate)
196: and master_cfg.application_id = l_application_id

Line 228: update ame_action_type_config acf

224: ,'migrate_action_type_config'
225: ,'Migration completion date:' || to_char(sysdate,'RRRR:MM:DD:HH24:MI:SS'));
226: -- Set the chain ordering mode for the action type configurations of
227: -- those action types for which it is not applicable.
228: update ame_action_type_config acf
229: set chain_ordering_mode = null
230: ,voting_regime = null
231: where (chain_ordering_mode is not null or
232: voting_regime is not null)