APPS.PA_REPORT_UTIL dependencies on ICX_SEC

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

286: pa_debug.reset_err_stack;
287: return;
288: END IF;
289:
290: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
291: x_def_show_percentages_by := l_def_show_percentages_by;
292:
293: /*NPE changes ends */
294:

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

456: /* NPE Changes Ends */
457:
458: -- Populating period name
459: /** Fix for bug 2387429 and 2091182 starts here **/
460: /* -- NPE Changes, it is shifted to above in the code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT); */
461:
462: SELECT
463: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
464: INTO x_def_period_name

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

1241: pa_debug.reset_err_stack;
1242: return;
1243: END IF;
1244:
1245: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1246:
1247: /*NPE changes ends */
1248:
1249: l_default_date := trunc(l_default_date);

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

1423: INTO x_def_period_name
1424: FROM sys.dual;
1425: */
1426:
1427: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1428:
1429: SELECT
1430: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1431: INTO x_def_period_name

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

1518:
1519: ELSIF ( l_period_type = 'GE') THEN
1520:
1521: -- Populating Mon or Qtr
1522: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1523: l_mon := TO_CHAR(to_date(x_def_period_name, l_date_format),'MM');
1524:
1525: x_def_mon_or_qtr := l_mon;
1526: x_def_period_num := 0;

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

1573: BEGIN
1574:
1575: PA_REP_UTIL_GLOB.update_util_cache; -- Bug 2447797 added this call
1576:
1577: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1578: --dbms_output.put_line('Date Format ---- ' || l_date_format);
1579:
1580: l_gedate := to_date(p_periodname, l_date_format);
1581: