APPS.PA_REPORT_UTIL dependencies on ICX_SEC

Line 313: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

309: pa_debug.reset_err_stack;
310: return;
311: END IF;
312:
313: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
314: x_def_show_percentages_by := l_def_show_percentages_by;
315:
316: /*NPE changes ends */
317:

Line 493: /* -- NPE Changes, it is shifted to above in the code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT); */

489: /* NPE Changes Ends */
490:
491: -- Populating period name
492: /** Fix for bug 2387429 and 2091182 starts here **/
493: /* -- NPE Changes, it is shifted to above in the code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT); */
494:
495: SELECT
496: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
497: INTO x_def_period_name

Line 1281: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1277: pa_debug.reset_err_stack;
1278: return;
1279: END IF;
1280:
1281: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1282:
1283: /*NPE changes ends */
1284:
1285: l_default_date := trunc(l_default_date);

Line 1475: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/

1471: INTO x_def_period_name
1472: FROM sys.dual;
1473: */
1474:
1475: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1476:
1477: SELECT
1478: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1479: INTO x_def_period_name

Line 1585: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1581:
1582: ELSIF ( l_period_type = 'GE') THEN
1583:
1584: -- Populating Mon or Qtr
1585: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1586: l_mon := TO_CHAR(to_date(x_def_period_name, l_date_format),'MM');
1587:
1588: x_def_mon_or_qtr := l_mon;
1589: x_def_period_num := 0;

Line 1640: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1636: BEGIN
1637:
1638: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call
1639:
1640: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1641: --dbms_output.put_line('Date Format ---- ' || l_date_format);
1642:
1643: l_gedate := to_date(p_periodname, l_date_format);
1644: