APPS.BIS_PMV_QUERY_PVT dependencies on FND_PROFILE

Line 1045: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT');

1041: fetch base_col_cursor bulk collect into l_base_Column_tbl, l_aggregation_tbl;
1042: close base_col_cursor;
1043:
1044: -- nbarik 19-SEP-2002 NLS Sort for VARCHAR2
1045: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT');
1046:
1047: open ak_region_item_cursor(l_user_session_rec.region_code);
1048: loop
1049: fetch ak_region_item_cursor into l_ak_region_item_rec;

Line 3281: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT');

3277: if (p_disable_viewby <> 'Y' and rtrim(ltrim(nvl(p_sort_attribute, l_sort_attribute))) = 'VIEWBY') then
3278: if p_viewby_dimension in ('TIME', 'EDW_TIME_M') and p_viewby_dimension_level <> 'EDW_TIME_A' then
3279: l_sort_attribute := 'VBT.start_date '|| l_sort_direction;
3280: else --NLS Sort for VIEWBY
3281: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT');
3282: IF l_nls_sort_type IS NOT NULL THEN
3283: l_sort_attribute := ' NLSSORT('||'VIEWBY'||', ''NLS_SORT = ' || l_nls_sort_type ||''') ' || l_sort_direction;
3284: END IF;
3285: end if;

Line 3485: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT'); -- nbarik 19-SEP-2002 NLS Sort for VARCHAR2

3481: ORDER BY display_sequence;
3482:
3483: BEGIN
3484:
3485: l_nls_sort_type := fnd_profile.value('ICX_NLS_SORT'); -- nbarik 19-SEP-2002 NLS Sort for VARCHAR2
3486:
3487: --serao - 2622281 - adding a new cursor which will select if non-view-by
3488: IF nvl(pAKRegionRec.disable_viewby,'N') <> 'Y' THEN
3489: IF ak_region_item_cursor%ISOPEN THEN