16: l_date_format := l_date_format||' HH24:MI:SS';
17:
18: SELECT to_char(MAX(period_start_date_time),l_date_format)
19: INTO l_max_date
20: FROM bix_dm_advanced_outbound_sum;
21:
22: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
23:
24: EXCEPTION
43: l_date_format := l_date_format||' HH24:MI:SS';
44:
45: SELECT to_char(MAX(period_start_date_time),l_date_format)
46: INTO l_max_date
47: FROM bix_dm_advanced_outbound_sum;
48:
49: RETURN l_max_date;
50:
51: EXCEPTION