APPS.BIS_PMF_PORTLET_UTIL dependencies on FND_PROFILE

Line 203: FUNCTION get_fnd_profile_value(

199:
200:
201: --===========================================================
202:
203: FUNCTION get_fnd_profile_value(
204: p_fnd_profile_name IN VARCHAR2
205: ,p_default IN VARCHAR2 := NULL
206: ) RETURN VARCHAR2
207: IS

Line 204: p_fnd_profile_name IN VARCHAR2

200:
201: --===========================================================
202:
203: FUNCTION get_fnd_profile_value(
204: p_fnd_profile_name IN VARCHAR2
205: ,p_default IN VARCHAR2 := NULL
206: ) RETURN VARCHAR2
207: IS
208:

Line 210: RETURN NVL(FND_PROFILE.Value_Specific(p_fnd_profile_name), p_default);

206: ) RETURN VARCHAR2
207: IS
208:
209: BEGIN
210: RETURN NVL(FND_PROFILE.Value_Specific(p_fnd_profile_name), p_default);
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: RETURN p_default;

Line 215: END get_fnd_profile_value;

211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: RETURN p_default;
215: END get_fnd_profile_value;
216:
217: --===========================================================
218: FUNCTION get_nls_numeric_format(
219: p_val IN NUMBER

Line 227: RETURN ( TO_CHAR(p_val, TRANSLATE(p_format_mask, c_dc_number_format, c_dec_group_sep), 'NLS_NUMERIC_CHARACTERS = ' || get_fnd_profile_value('ICX_NUMERIC_CHARACTERS', c_dc_number_format)) );

223:
224: BEGIN
225: -- TRANSLATE() - If , and . are used in ak region flex field, it is replaced with G and D, so that nls numeric format
226: -- takes effect.
227: RETURN ( TO_CHAR(p_val, TRANSLATE(p_format_mask, c_dc_number_format, c_dec_group_sep), 'NLS_NUMERIC_CHARACTERS = ' || get_fnd_profile_value('ICX_NUMERIC_CHARACTERS', c_dc_number_format)) );
228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: RETURN TO_CHAR(p_val);

Line 459: l_bis_env_val := FND_PROFILE.Value('BIS_ENVIRONMENT');

455:
456: l_bis_env_val VARCHAR2(60);
457: BEGIN
458:
459: l_bis_env_val := FND_PROFILE.Value('BIS_ENVIRONMENT');
460: IF ( l_bis_env_val IS NULL) THEN
461: RETURN TRUE;
462: ELSIF ( UPPER(l_bis_env_val) = 'DEMO') THEN
463: RETURN TRUE;

Line 987: IF ( (NVL(p_enable_auto_scaling,'Y') = 'Y') AND (is_get_fnd_profile(p_fnd_profile_name => 'BIS_AUTO_FACTOR', p_default => 'Y')) ) THEN

983: p_format_mask => NVL(p_display_format, getFormatMask(p_val, TRUE))) || c_percent;
984:
985: ELSIF (p_display_type = c_AS) THEN -- No auto scaling for rollover (p_enable_auto_scaling = 'N'). Also,auto scaling, when enabled by user. default is YES
986:
987: IF ( (NVL(p_enable_auto_scaling,'Y') = 'Y') AND (is_get_fnd_profile(p_fnd_profile_name => 'BIS_AUTO_FACTOR', p_default => 'Y')) ) THEN
988:
989: RETURN getAutoScaleValue(
990: p_val => p_val
991: ,p_number_scale_rec => p_number_scale_rec

Line 1011: FUNCTION is_get_fnd_profile(

1007:
1008:
1009: --===========================================================
1010:
1011: FUNCTION is_get_fnd_profile(
1012: p_fnd_profile_name IN VARCHAR2
1013: ,p_default IN VARCHAR2
1014: ) RETURN BOOLEAN
1015: IS

Line 1012: p_fnd_profile_name IN VARCHAR2

1008:
1009: --===========================================================
1010:
1011: FUNCTION is_get_fnd_profile(
1012: p_fnd_profile_name IN VARCHAR2
1013: ,p_default IN VARCHAR2
1014: ) RETURN BOOLEAN
1015: IS
1016:

Line 1018: IF ( UPPER(NVL(FND_PROFILE.Value_Specific(p_fnd_profile_name),NVL(p_default,'N'))) = 'Y' ) THEN

1014: ) RETURN BOOLEAN
1015: IS
1016:
1017: BEGIN
1018: IF ( UPPER(NVL(FND_PROFILE.Value_Specific(p_fnd_profile_name),NVL(p_default,'N'))) = 'Y' ) THEN
1019: RETURN TRUE;
1020: ELSE
1021: RETURN FALSE;
1022: END IF;

Line 1030: END is_get_fnd_profile;

1026: RETURN TRUE;
1027: ELSE
1028: RETURN FALSE;
1029: END IF;
1030: END is_get_fnd_profile;
1031:
1032: --============================================================
1033: -- PROCEDURE
1034: -- get_ak_display_format