eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_MULTI_TENANT_INSTALLER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52


  SELECT  fou.oracle_username
    INTO  l_schema_name
    FROM  fnd_oracle_userid  fou
         ,fnd_product_installations  fpi
         ,fnd_application            fap
   WHERE  fou.oracle_id             = fpi.oracle_id
     AND  fpi.application_id        = fap.application_id
     AND  fap.application_short_name = p_app_short_name;

Line: 89


  SELECT fou.oracle_username
    INTO l_schema_name
    FROM fnd_oracle_userid    fou
   WHERE fou.oracle_id     =  p_oracle_id;

Line: 197


		  SELECT 1
		    INTO policy_exists
		    FROM all_sa_users
		   WHERE policy_name=''HR_ENTERPRISE_POLICY''
		     AND user_name = ''C::ENT'';

Line: 229


      add_body_line('SELECT to_data_label(''HR_ENTERPRISE_POLICY'',''C::ENT'') INTO dummy FROM dual;');

Line: 292


   add_header_line('PROCEDURE insert_hr_name_formats ( p_enterprise_code IN varchar2);');

Line: 386


   add_header_line('--   p_person_id => id of the selected person');

Line: 401


   add_header_line('--   p_person_id         => id of the selected person');

Line: 402


   add_header_line('--   p_business_group_id => id of the selected business group.');

Line: 416


   add_header_line('--   p_business_group_id => id of the selected business group.');

Line: 429


   add_header_line(' --   p_business_group_id => id of the selected business group.');

Line: 444


   add_header_line('--   p_business_group_id => id of the selected business group.');

Line: 454


   add_header_line(' --   Updates TL table');

Line: 468


   add_body_line('      SELECT security_group_key');

Line: 480


   add_body_line('      SELECT enterprise_label');

Line: 513


   add_body_line('--     p_business_group_id => id of the selected business group.');

Line: 520


   add_body_line('      SELECT   enterprise_label');

Line: 554


   add_body_line('     SELECT   description, meaning');

Line: 650


   add_body_line('     SELECT    enterprise_label');

Line: 664


   add_body_line('          SELECT    enterprise_label');

Line: 751


   add_body_line('PROCEDURE insert_hr_name_formats ( p_enterprise_code IN varchar2)');

Line: 768


   add_body_line('  SELECT format_name');

Line: 784


   add_body_line('     -- And we want smooth insertions without any exceptions due to colliding');

Line: 787


   add_body_line('     select max(name_format_id)');

Line: 790


   add_body_line('      select hr_name_formats_s.nextval into next_id from dual;');

Line: 795


   add_body_line('         select hr_name_formats_s.nextval into next_id from dual;');

Line: 798


   add_body_line('execute immediate ''insert into hr_name_formats (name_format_id');

Line: 843


   add_body_line('    SELECT ''Y'' ');

Line: 890


   add_body_line('        ''SELECT   LABEL_TO_CHAR(HR_ENTERPRISE) ENT_LABEL, BUSINESS_GROUP_ID '' ||');

Line: 910


   add_body_line('             SELECT enabled_flag');

Line: 952


   add_body_line('      SELECT enterprise_label');

Line: 962


   add_body_line('     SELECT count(*)');

Line: 986


   add_body_line('--   p_business_group_id => id of the selected business group.');

Line: 999


   add_body_line('    SELECT  ''Y''');

Line: 1022


   add_body_line('--   p_person_id => id of the selected person');

Line: 1028


   add_body_line('      ''SELECT   LABEL_TO_CHAR(HR_ENTERPRISE) ENT_LABEL, BUSINESS_GROUP_ID '' ||');

Line: 1046


   add_body_line('          SELECT business_group_id ');

Line: 1057


   add_body_line('      SELECT      organization_id');

Line: 1079


   add_body_line('   --  Get OrganizationId FROM LoginPersonId AND SelectedBusinessGroupId');

Line: 1082


   add_body_line('   --   p_person_id => id of the selected person');

Line: 1089


   add_body_line('     ''SELECT LABEL_TO_CHAR(HR_ENTERPRISE) ENT_LABEL '' ||');

Line: 1109


   add_body_line('        SELECT organization_id');

Line: 1133


   add_body_line('--   p_business_group_id => id of the selected business group.');

Line: 1141


   add_body_line('    SELECT organization_id');

Line: 1176


   add_body_line('      SELECT description ');

Line: 1189


   add_body_line('    SELECT  security_group_id ');

Line: 1223


   add_body_line('  SELECT business_group_id');

Line: 1252


   add_body_line('      SELECT security_group_id');

Line: 1257


   add_body_line('  SELECT business_group_id');

Line: 1288


   add_body_line('--     Updates TL table');

Line: 1295


   add_body_line('    SELECT pet.enterprise_id');

Line: 1305


   add_body_line('    SELECT l.language_code');

Line: 1308


   add_body_line('       AND NOT EXISTS (SELECT NULL');

Line: 1315


   add_body_line('   DELETE FROM per_enterprises_tl t');

Line: 1317


   add_body_line('     (  SELECT NULL');

Line: 1322


   add_body_line('   UPDATE per_enterprises_tl t');

Line: 1325


   add_body_line('             ( SELECT b.enterprise_name,');

Line: 1333


   add_body_line('        ( SELECT subt.enterprise_id,');

Line: 1348


   add_body_line('       INSERT INTO per_enterprises_tl');

Line: 1356


   add_body_line('           ,last_updated_by');

Line: 1357


   add_body_line('           ,last_update_date');

Line: 1522


   add_body_line('     SELECT ''Y''');

Line: 1533


   add_body_line('      SELECT substrb(security_group_name, 1, 80), security_group_id');

Line: 1564


   add_body_line('       SELECT substrb(hou.name,1,80)');

Line: 1603


   add_body_line('           INSERT INTO per_ent_security_groups ');

Line: 1685


   add_body_line('       SELECT  business_group_id');

Line: 1691


   add_body_line('        SELECT 1');

Line: 1705


   add_body_line('-- Select the long name and the company label for this enterprise id');

Line: 1708


   add_body_line('        SELECT substr(enterprise_short_code,   1,   80)');

Line: 1740


   add_body_line('       ''INSERT INTO per_number_generation_controls ');

Line: 1753


   add_body_line('        ''INSERT INTO per_number_generation_controls ');

Line: 1767


   add_body_line('        ''INSERT INTO per_number_generation_controls ');

Line: 1799


   add_body_line('              EXECUTE IMMEDIATE ''UPDATE ''||init_table_name||''    ');

Line: 1843


   add_body_line('              EXECUTE IMMEDIATE ''UPDATE '' || init_child_tables(t_index).table_name ||');

Line: 1846


   add_body_line('                                           '' (SELECT '' || init_child_tables(t_index).master_key_name || ');

Line: 1862


   add_body_line('-- In model 1 update entries in the hr_all_organization_units for this enterprise');

Line: 1864


   add_body_line('EXECUTE IMMEDIATE ''UPDATE hr_all_organization_units');

Line: 1870


   add_body_line('             UPDATE hr_organization_information');

Line: 1876


   add_body_line('-- In model 1 update entries in the hr_organization_information for this enterprise');

Line: 1878


   add_body_line('EXECUTE IMMEDIATE ''UPDATE hr_organization_information');

Line: 1885


   add_body_line('-- In model 1 update entries in the hr_all_organization_units_tl for this enterprise');

Line: 1888


   add_body_line('   EXECUTE IMMEDIATE ''UPDATE hr_all_organization_units_tl');

Line: 1908


   add_body_line('                       ,''No organization selected :'');');

Line: 1910


   add_body_line('                       ,''No organization selected : '');');

Line: 1932


   add_body_line('      select fou.oracle_username');

Line: 1989


   add_body_line('      select count(*) ');

Line: 1994


   add_body_line('      SELECT count(*) ');

Line: 1997


   add_body_line('       WHERE user_table_id = (SELECT user_table_id');

Line: 2159


   add_body_line('      select owner, table_name ');

Line: 2160


   add_body_line('        from (select owner, ');

Line: 2170


   add_body_line('      select row_low_range_or_name, ');

Line: 2172


   add_body_line('        from (select f.row_low_range_or_name');

Line: 2228


   add_body_line('    predicate_table(22) :=''AME_TEMP_INSERTIONS'';');

Line: 2255


   add_body_line('-- Based on the install mode selectively enable policy on tables ');

Line: 2291


   add_body_line('          select ''Y''');

Line: 2338


   add_body_line('                -- Update null to C::ENT');

Line: 2340


   add_body_line('                execute immediate ''UPDATE '' || l_schema_name || ''.'' || l_table_name ||');

Line: 2411


   add_body_line('          SELECT status');

Line: 2497


   add_body_line('                 execute immediate ''UPDATE '' || l_schema_name || ''.'' || l_table_name ||');

Line: 2518


   add_body_line('              -- Update null to C::ENT');