394: SELECT trunc(sysdate)
395: INTO today
396: FROM dual;
397:
398: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_LOGINS_DATA(timezone_offset);
399: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_RESP_DATA(timezone_offset);
400: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_FORMS_DATA(timezone_offset);
401: migrate_data_raw;
402: migrate_data_stats(today);
395: INTO today
396: FROM dual;
397:
398: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_LOGINS_DATA(timezone_offset);
399: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_RESP_DATA(timezone_offset);
400: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_FORMS_DATA(timezone_offset);
401: migrate_data_raw;
402: migrate_data_stats(today);
403: migrated_data(1,sysdate);
396: FROM dual;
397:
398: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_LOGINS_DATA(timezone_offset);
399: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_RESP_DATA(timezone_offset);
400: JTF_PF_SOA_MIGRATE_PKG.MIGRATE_FORMS_DATA(timezone_offset);
401: migrate_data_raw;
402: migrate_data_stats(today);
403: migrated_data(1,sysdate);
404: COMMIT;