DBA Data[Home] [Help]

APPS.POA_DBI_UTIL_PKG dependencies on FND_PROFILE

Line 217: ---Call to fnd_profile is made conditionally.

213: FUNCTION get_sec_profile RETURN NUMBER
214: IS
215: BEGIN
216: ---Begin MOAC change
217: ---Call to fnd_profile is made conditionally.
218: -- IF NVL(g_sec_profile_id,-1) = -1
219: -- THEN
220: -- g_sec_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
221: -- END IF ;

Line 220: -- g_sec_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

216: ---Begin MOAC change
217: ---Call to fnd_profile is made conditionally.
218: -- IF NVL(g_sec_profile_id,-1) = -1
219: -- THEN
220: -- g_sec_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
221: -- END IF ;
222: ---End MOAC change
223:
224: RETURN nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1) ;

Line 224: RETURN nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1) ;

220: -- g_sec_profile_id := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);
221: -- END IF ;
222: ---End MOAC change
223:
224: RETURN nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1) ;
225: END get_sec_profile;
226:
227:
228: Function get_fnd_user_profile RETURN NUMBER

Line 1453: -- g_org_id := NVL(fnd_profile.value('ORG_ID'), -1);

1449: IS
1450: BEGIN
1451: -- IF NVL(g_org_id , -1) = -1
1452: -- THEN
1453: -- g_org_id := NVL(fnd_profile.value('ORG_ID'), -1);
1454: -- END IF ;
1455: RETURN NVL(fnd_profile.value('ORG_ID'), -1);
1456: END get_ou_org_id;
1457:

Line 1455: RETURN NVL(fnd_profile.value('ORG_ID'), -1);

1451: -- IF NVL(g_org_id , -1) = -1
1452: -- THEN
1453: -- g_org_id := NVL(fnd_profile.value('ORG_ID'), -1);
1454: -- END IF ;
1455: RETURN NVL(fnd_profile.value('ORG_ID'), -1);
1456: END get_ou_org_id;
1457:
1458: ---End MOAC changes
1459: