APPS.MO_GLOBAL dependencies on PER_SECURITY_PROFILES

Line 68: l_sp_name per_security_profiles.security_profile_name%TYPE;

64: k BINARY_INTEGER := 1;
65: l BINARY_INTEGER := 1;
66:
67: is_view_all_org VARCHAR2(1);
68: l_sp_name per_security_profiles.security_profile_name%TYPE;
69: l_bg_id per_security_profiles.business_group_id%TYPE;
70:
71:
72: CURSOR c1 IS

Line 69: l_bg_id per_security_profiles.business_group_id%TYPE;

65: l BINARY_INTEGER := 1;
66:
67: is_view_all_org VARCHAR2(1);
68: l_sp_name per_security_profiles.security_profile_name%TYPE;
69: l_bg_id per_security_profiles.business_group_id%TYPE;
70:
71:
72: CURSOR c1 IS
73: SELECT per.organization_id organization_id

Line 168: FROM per_security_profiles

164: , view_all_organizations_flag
165: INTO l_sp_name
166: , l_bg_id
167: , p_view_all_org
168: FROM per_security_profiles
169: WHERE security_profile_id = to_number(p_sp_id_char);
170:
171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(

Line 175: 'per_security_profiles.security_profile_name=>'||l_sp_name||

171: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(
173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||
176: ', per_security_profiles.business_group_id=>'||l_bg_id||
177: ', per_security_profiles.view_all_organizations_flag=>'||is_view_all_org);
178: END IF;
179:

Line 176: ', per_security_profiles.business_group_id=>'||l_bg_id||

172: FND_LOG.STRING(
173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||
176: ', per_security_profiles.business_group_id=>'||l_bg_id||
177: ', per_security_profiles.view_all_organizations_flag=>'||is_view_all_org);
178: END IF;
179:
180: IF (p_view_all_org = 'Y') THEN

Line 177: ', per_security_profiles.view_all_organizations_flag=>'||is_view_all_org);

173: FND_LOG.LEVEL_EVENT,
174: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.config',
175: 'per_security_profiles.security_profile_name=>'||l_sp_name||
176: ', per_security_profiles.business_group_id=>'||l_bg_id||
177: ', per_security_profiles.view_all_organizations_flag=>'||is_view_all_org);
178: END IF;
179:
180: IF (p_view_all_org = 'Y') THEN
181: IF (l_bg_id IS NOT NULL) THEN