APPS.HZ_DSS_UTIL_PUB dependencies on FND_PROFILE

Line 179: IF NVL(FND_PROFILE.VALUE('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

175: --- initialize API return status to success.
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: --Check if security is on
179: IF NVL(FND_PROFILE.VALUE('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
180:
181: /* in R12, the fnd api won't accept user name.
182: it will raise a runtime error user_name contains
183: anything other than null or fnd_global.user_name

Line 899: l_returned_dss_group := FND_PROFILE.VALUE('HZ_DEFAULT_DSS_GROUP');

895: CLOSE c_get_dss_groups;
896:
897: IF l_returned_dss_group IS NULL THEN
898: print('l_returned_dss_group is NULL, so get profile value for HZ_DEFAULT_DSS_GROUP');
899: l_returned_dss_group := FND_PROFILE.VALUE('HZ_DEFAULT_DSS_GROUP');
900: END IF;
901:
902: print('Finally Return Value l_returned_dss_group:'||l_returned_dss_group);
903: RETURN l_returned_dss_group;

Line 1424: 'NVL(fnd_profile.value(''HZ_CREATED_BY_MODULE''), ''-222'')' ||

1420:
1421: IF p_dss_group_code = 'HR_SHARED' THEN
1422: ---get the user's module
1423: l_sql := l_sql || ' AND '||
1424: 'NVL(fnd_profile.value(''HZ_CREATED_BY_MODULE''), ''-222'')' ||
1425: ' = ''HR API'' ';
1426: END IF;
1427:
1428: -- Build and test the sql statement to make sure generated predicate