Adding package_id to pa_insert_image and its call to image.new. Fixed and tested on both Oracle and PG. This was just to get things working again. Other parts of this package will need updating for the new acs_objects.package_id column. For example, the pa_photo object itself is not currently storing the package_id.
Fix for but 1599. Resetting the default for title pa_photo.new so that the specification and body match. We set to 'photo' because cr_revisions.title must be non null.
Modified the date type's "to_sql" property to return to_timestamp if theformat includes minutes and seconds, to_date otherwise. In reality we shouldprobably move to having both date and timestamp template types but for nowthis should work for both Oracle and PG.
This is just a comment on the previous commit. Oracle was refusing to compile the package because the specification and body were not declaring the type in an identical way. The specification says that the package_id column is of type acs_objects.package_id%TYPE but the body previously was declaring it cr_folders.package_id%TYPE. That wasn't good enough for Oracle. Now the two are declaring the type the same way.