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 564: add_body_line(' fnd_profile.put(rec.meaning, rec.description);');

560: add_body_line(' AND security_group_id = fnd_global.lookup_security_group(lookup_type');
561: add_body_line(' ,view_application_id);');
562: add_body_line('BEGIN');
563: add_body_line(' FOR rec IN csr_profile_value LOOP');
564: add_body_line(' fnd_profile.put(rec.meaning, rec.description);');
565: add_body_line(' END LOOP;');
566: add_body_line('END init_profiles;');
567: add_body_line('');
568: add_body_line('--');

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

714: add_body_line('--');
715: add_body_line('FUNCTION is_multi_tenant_system RETURN BOOLEAN AS');
716: add_body_line(' l_profile_value VARCHAR2 (255);');
717: add_body_line('BEGIN');
718: add_body_line(' l_profile_value := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');
719: add_body_line('');
720: add_body_line(' IF l_profile_value = ''P'' OR');
721: add_body_line(' l_profile_value = ''B'' THEN');
722: add_body_line(' RETURN true;');

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

737: add_body_line('--');
738: add_body_line(' FUNCTION get_system_model RETURN VARCHAR2 AS');
739: add_body_line(' l_system_model VARCHAR2(255);');
740: add_body_line(' BEGIN');
741: add_body_line(' l_system_model := fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'');');
742: add_body_line(' ');
743: add_body_line(' IF l_system_model IS NULL THEN');
744: add_body_line(' RETURN ''N'';');
745: add_body_line(' ELSE');

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

1519: add_body_line(' ,p_enterprise_id IN NUMBER ) IS');
1520: add_body_line('');
1521: add_body_line(' CURSOR c_sg_enabled IS');
1522: add_body_line(' SELECT ''Y''');
1523: add_body_line(' FROM fnd_profile_options fpo');
1524: add_body_line(' ,fnd_profile_option_values pov');
1525: add_body_line(' WHERE fpo.profile_option_name = ''ENABLE_SECURITY_GROUPS'' AND');
1526: add_body_line(' fpo.profile_option_id = pov.profile_option_id AND');
1527: add_body_line(' fpo.application_id = pov.application_id AND');

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

1520: add_body_line('');
1521: add_body_line(' CURSOR c_sg_enabled IS');
1522: add_body_line(' SELECT ''Y''');
1523: add_body_line(' FROM fnd_profile_options fpo');
1524: add_body_line(' ,fnd_profile_option_values pov');
1525: add_body_line(' WHERE fpo.profile_option_name = ''ENABLE_SECURITY_GROUPS'' AND');
1526: add_body_line(' fpo.profile_option_id = pov.profile_option_id AND');
1527: add_body_line(' fpo.application_id = pov.application_id AND');
1528: add_body_line(' pov.level_id = 10002 AND');

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

2257: add_body_line(' if install_mode =''SCHEMA'' then');
2258: add_body_line('--');
2259: add_body_line('-- Schema mode is not a valid option for Model 2 ');
2260: add_body_line('--');
2261: add_body_line(' if fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' then');
2262: add_body_line(' return;');
2263: add_body_line(' end if;');
2264: add_body_line(' ');
2265: add_body_line('--');

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

2434: add_body_line(' ,predicate => l_predicate);');
2435: add_body_line(' --');
2436: add_body_line(' -- In PEO mode change the table indexes');
2437: add_body_line(' --');
2438: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');
2439: add_body_line(' IF l_table_name = ''HR_LOCATIONS_ALL'' THEN ');
2440: add_body_line(' execute_statement( ''ALTER TABLE '' || l_schema_name || ');
2441: add_body_line(' ''.hr_locations_all DROP CONSTRAINT hr_locations_uk2 CASCADE''');
2442: add_body_line(' ,''DROP INDEX '' || l_schema_name || ''.hr_locations_uk2''');

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

2535: add_body_line(' END IF;');
2536: add_body_line(' END IF; ');
2537: add_body_line(' ELSIF l_enabled THEN');
2538: add_body_line(' IF (UPPER(l_table_enabled_value) = ''N'') AND l_status= ''ENABLED'' THEN ');
2539: add_body_line(' IF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''P'' THEN');
2540: add_body_line(' --');
2541: add_body_line(' -- Check if disable is allowed for this table');
2542: add_body_line(' --');
2543: add_body_line(' FOR t_index IN 1 .. allowed_table.COUNT LOOP');

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

2553: add_body_line(' ,schema_name => l_schema_name');
2554: add_body_line(' ,table_name => l_table_name');
2555: add_body_line(' );');
2556: add_body_line(' END IF; ');
2557: add_body_line(' ELSIF fnd_profile.value(''HR_ENABLE_MULTI_TENANCY'')=''B'' THEN ');
2558: add_body_line(' sa_policy_admin.disable_table_policy');
2559: add_body_line(' (policy_name => ''HR_ENTERPRISE_POLICY''');
2560: add_body_line(' ,schema_name => l_schema_name');
2561: add_body_line(' ,table_name => l_table_name');