APPS.AME_MIGRATION_PKG dependencies on AME_ITEM_CLASS_USAGES

Line 369: update ame_item_class_usages itu

365: --+
366: log_message('Item Class Usages Migration Started at '||
367: to_char(sysdate,'YYYY:MM:DD:HH24:MI:SS'));
368: --Set all par_mode for header from 'P' to 'S'
369: update ame_item_class_usages itu
370: set itu.item_class_par_mode = 'S'
371: where itu.item_class_par_mode = 'P'
372: and sysdate between itu.start_date
373: and nvl(itu.end_date - (1/86400), sysdate)

Line 384: update ame_item_class_usages itu

380: );
381: --+
382: --+Correct all item_id_queries
383: --+
384: update ame_item_class_usages itu
385: set itu.item_id_query = 'select :transactionId from dual'
386: where itu.item_id_query = 'select :transaction_id from dual'
387: and sysdate between itu.start_date
388: and nvl(itu.end_date - (1/86400), sysdate)