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 900: l_returned_dss_group := FND_PROFILE.VALUE('HZ_DEFAULT_DSS_GROUP');

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

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

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