APPS.FII_PMV_UTIL dependencies on FND_PROFILE

Line 6: g_sec_profile NUMBER := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

2: /* $Header: FIIPMVUB.pls 120.10 2006/09/15 05:24:17 sajgeo ship $ */
3:
4: g_prim_global_currency_code VARCHAR2(15) := get_prim_global_currency_code;
5: g_sec_global_currency_code VARCHAR2(15) := get_sec_global_currency_code;
6: g_sec_profile NUMBER := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
7:
8: g_all_operating_unit VARCHAR2(240) ;
9: g_operating_unit VARCHAR2(240);
10: g_common_functional_currency VARCHAR2(3) ;

Line 88: stmt := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

84:
85: FUNCTION get_sec_profile RETURN NUMBER IS
86: stmt NUMBER;
87: BEGIN
88: stmt := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
89: RETURN stmt;
90: END get_sec_profile;
91:
92: FUNCTION get_prim_global_currency_code RETURN VARCHAR2 IS

Line 105: g_sec_profile := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

101:
102: FUNCTION get_display_currency(p_selected_operating_unit IN VARCHAR2) RETURN VARCHAR2 IS
103: BEGIN
104: IF g_sec_profile is null then
105: g_sec_profile := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
106: END IF;
107:
108: IF g_det_ou_lov IS NULL THEN
109: g_det_ou_lov := determine_OU_LOV;

Line 168: g_det_ou_lov=4 AND fsp.org_id = nvl(fnd_profile.value('ORG_ID'), -1)

164: WHERE security_profile_id = g_sec_profile
165: )
166: )
167: OR(
168: g_det_ou_lov=4 AND fsp.org_id = nvl(fnd_profile.value('ORG_ID'), -1)
169: )
170: );
171:
172: END IF;

Line 300: g_security_org_id := fnd_profile.value('ORG_ID');

296: g_security_profile_id := fii_pmv_util.get_sec_profile;
297: END IF;
298:
299: IF g_security_org_id IS NULL THEN
300: g_security_org_id := fnd_profile.value('ORG_ID');
301: END IF;
302:
303: IF g_business_group_id IS NULL THEN
304: g_business_group_id := fii_pmv_util.get_business_group;

Line 942: g_security_org_id := fnd_profile.value('ORG_ID');

938: g_security_profile_id := fii_pmv_util.get_sec_profile;
939: END IF;
940:
941: IF g_security_org_id IS NULL THEN
942: g_security_org_id := fnd_profile.value('ORG_ID');
943: END IF;
944:
945: -- Bug 5527135: Added the condition to also handle g_security_profile_id <> -1
946: IF g_security_profile_id is NOT NULL AND g_security_profile_id <> -1 THEN