Ok, here we go with the implementations.
I commited some packages implementations for this. In the case of Faq, File Storage, CR and basic information of other packages that are based on ACS Objects, the merge is easy because we just need to update the acs_objects table and check the permissions (these stuffs are done by um core).
The other case is when we have to update 'specific data' of the package, for example : Calendar items, .LRN memberships, etc. I've been writing the implementations for Calendar, Notifications, Photo Album, Wimpy Point, Auth LDAP, Forums, News, Lars Blogger, .lrn, lors, evaluation, assessments.
In all of those cases the queries are just a 'select' or 'update' (without pl/sql calls), so I added that in the generic .xql files and this means that it works for ora & pg :).
