DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on ICX_SEC

Line 8156: -- don't remove this, for some reason, icx_sec.getID doesn't work first time

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:

Line 8158: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_DATE_FORMAT);

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);

Line 8159: l_date_format := icx_sec.getID(n_param =>icx_sec.PV_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