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
25: WHEN OTHERS THEN
26: RETURN NULL;
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
77: WHEN OTHERS THEN
78: RETURN NULL;