DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on ICX_SEC

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

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:

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

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

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