8445: l_date_range_text VARCHAR2(240);
8446: l_date_format VARCHAR2(80);
8447:
8448: BEGIN
8449: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8450: -- in the new session.
8451: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8452: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8453:
8447:
8448: BEGIN
8449: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8450: -- in the new session.
8451: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8452: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8453:
8454: IF p_start_date IS NOT null THEN
8455: l_start_date := to_char(p_start_date, l_date_format);
8448: BEGIN
8449: -- don't remove this, for some reason, icx_sec.getID doesn't work first time
8450: -- in the new session.
8451: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8452: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);
8453:
8454: IF p_start_date IS NOT null THEN
8455: l_start_date := to_char(p_start_date, l_date_format);
8456: ELSE