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 164: FROM per_security_profiles

160: , view_all_organizations_flag
161: INTO l_sp_name
162: , l_bg_id
163: , p_view_all_org
164: FROM per_security_profiles
165: WHERE security_profile_id = to_number(p_sp_id_char);
166:
167: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
168: FND_LOG.STRING(

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

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

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

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

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

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