8152: l_date_range_text VARCHAR2(240);
8153: l_date_format VARCHAR2(80);
8154:
8155: BEGIN
8156: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8157: -- in the new session.
8158: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8159: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8160:
8154:
8155: BEGIN
8156: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8157: -- in the new session.
8158: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8159: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8160:
8161: IF p_start_date IS NOT null THEN
8162: l_start_date := to_char(p_start_date, l_date_format);
8155: BEGIN
8156: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8157: -- in the new session.
8158: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8159: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8160:
8161: IF p_start_date IS NOT null THEN
8162: l_start_date := to_char(p_start_date, l_date_format);
8163: ELSE