APPS.HR_MULTI_TENANT_INSTALLER dependencies on FND_PROFILE

Line 175: IF fnd_profile.value('HR_ENABLE_MULTI_TENANCY') IS NULL

171: -- If value is null or N then this is not a multi tenancy should not be
172: -- installed.
173: --
174:
175: IF fnd_profile.value('HR_ENABLE_MULTI_TENANCY') IS NULL
176: OR fnd_profile.value('HR_ENABLE_MULTI_TENANCY') = 'N' THEN
177:
178: fnd_file.put_line(fnd_file.output
179: ,'Set HR Enable Multi Tenancy System profile and submit the request');

Line 176: OR fnd_profile.value('HR_ENABLE_MULTI_TENANCY') = 'N' THEN

172: -- installed.
173: --
174:
175: IF fnd_profile.value('HR_ENABLE_MULTI_TENANCY') IS NULL
176: OR fnd_profile.value('HR_ENABLE_MULTI_TENANCY') = 'N' THEN
177:
178: fnd_file.put_line(fnd_file.output
179: ,'Set HR Enable Multi Tenancy System profile and submit the request');
180:

Line 590: add_body_line(' fnd_profile.put(rec.meaning, rec.description);');

586: add_body_line(' AND security_group_id = fnd_global.lookup_security_group(lookup_type');
587: add_body_line(' ,view_application_id);');
588: add_body_line('BEGIN');
589: add_body_line(' FOR rec IN csr_profile_value LOOP');
590: add_body_line(' fnd_profile.put(rec.meaning, rec.description);');
591: add_body_line(' END LOOP;');
592: add_body_line('END init_profiles;');
593: add_body_line('');
594: add_body_line('--');

Line 757: add_body_line(' l_profile_value := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');

753: add_body_line('--');
754: add_body_line('FUNCTION is_multi_tenant_system RETURN BOOLEAN AS');
755: add_body_line(' l_profile_value VARCHAR2 (255);');
756: add_body_line('BEGIN');
757: add_body_line(' l_profile_value := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');
758: add_body_line('');
759: add_body_line(' IF l_profile_value = ''P'' OR');
760: add_body_line(' l_profile_value = ''B'' THEN');
761: add_body_line(' RETURN true;');

Line 780: add_body_line(' l_system_model := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');

776: add_body_line('--');
777: add_body_line(' FUNCTION get_system_model RETURN VARCHAR2 AS');
778: add_body_line(' l_system_model VARCHAR2(255);');
779: add_body_line(' BEGIN');
780: add_body_line(' l_system_model := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');
781: add_body_line(' ');
782: add_body_line(' IF l_system_model IS NULL THEN');
783: add_body_line(' RETURN ''N'';');
784: add_body_line(' ELSE');

Line 1733: add_body_line(' FROM fnd_profile_options fpo');

1729: add_body_line(' ,p_enterprise_id IN NUMBER ) IS');
1730: add_body_line('');
1731: add_body_line(' CURSOR c_sg_enabled IS');
1732: add_body_line(' SELECT ''Y''');
1733: add_body_line(' FROM fnd_profile_options fpo');
1734: add_body_line(' ,fnd_profile_option_values pov');
1735: add_body_line(' WHERE fpo.profile_option_name = ''ENABLE_SECURITY_GROUPS'' AND');
1736: add_body_line(' fpo.profile_option_id = pov.profile_option_id AND');
1737: add_body_line(' fpo.application_id = pov.application_id AND');

Line 1734: add_body_line(' ,fnd_profile_option_values pov');

1730: add_body_line('');
1731: add_body_line(' CURSOR c_sg_enabled IS');
1732: add_body_line(' SELECT ''Y''');
1733: add_body_line(' FROM fnd_profile_options fpo');
1734: add_body_line(' ,fnd_profile_option_values pov');
1735: add_body_line(' WHERE fpo.profile_option_name = ''ENABLE_SECURITY_GROUPS'' AND');
1736: add_body_line(' fpo.profile_option_id = pov.profile_option_id AND');
1737: add_body_line(' fpo.application_id = pov.application_id AND');
1738: add_body_line(' pov.level_id = 10002 AND');

Line 2959: add_body_line(' if fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' then');

2955: add_body_line(' if install_mode =''SCHEMA'' then');
2956: add_body_line('--');
2957: add_body_line('-- Schema mode is not a valid option for Model 2 ');
2958: add_body_line('--');
2959: add_body_line(' if fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' then');
2960: add_body_line(' return;');
2961: add_body_line(' end if;');
2962: add_body_line(' ');
2963: add_body_line('--');

Line 3123: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');

3119: add_body_line(' ,table_name => l_table_name);');
3120: add_body_line(' --');
3121: add_body_line(' -- In PEO mode change the table indexes');
3122: add_body_line(' --');
3123: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');
3124: add_body_line(' IF l_table_name = ''HR_LOCATIONS_ALL'' THEN ');
3125: add_body_line(' execute_statement( ''ALTER TABLE '' || l_schema_name || ');
3126: add_body_line(' ''.hr_locations_all DROP CONSTRAINT hr_locations_uk2 CASCADE''');
3127: add_body_line(' ,''DROP INDEX '' || l_schema_name || ''.hr_locations_uk2''');

Line 3224: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');

3220: add_body_line(' END IF;');
3221: add_body_line(' END IF; ');
3222: add_body_line(' ELSIF l_enabled THEN');
3223: add_body_line(' IF (UPPER(l_table_enabled_value) = ''N'') AND l_status= ''ENABLED'' THEN ');
3224: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');
3225: add_body_line(' --');
3226: add_body_line(' -- Check if disable is allowed for this table');
3227: add_body_line(' --');
3228: add_body_line(' FOR t_index IN 1 .. allowed_table.COUNT LOOP');

Line 3242: add_body_line(' ELSIF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''B'' THEN ');

3238: add_body_line(' ,schema_name => l_schema_name');
3239: add_body_line(' ,table_name => l_table_name');
3240: add_body_line(' );');
3241: add_body_line(' END IF; ');
3242: add_body_line(' ELSIF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''B'' THEN ');
3243: add_body_line(' sa_policy_admin.disable_table_policy');
3244: add_body_line(' (policy_name => ''HR_ENTERPRISE_POLICY''');
3245: add_body_line(' ,schema_name => l_schema_name');
3246: add_body_line(' ,table_name => l_table_name');