68: l_date_format := l_date_format||' HH24:MI:SS';
69:
70: SELECT to_char(MAX(period_start_date_time),l_date_format)
71: INTO l_max_date
72: FROM bix_dm_agent_outcome_sum;
73:
74: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
75:
76: EXCEPTION
93: l_date_format := l_date_format||' HH24:MI:SS';
94:
95: SELECT to_char(MAX(period_start_date_time),l_date_format)
96: INTO l_max_date
97: FROM bix_dm_agent_outcome_sum;
98:
99: RETURN l_max_date;
100:
101: EXCEPTION