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: 230


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

Line: 231


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

Line: 412


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

Line: 427


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

Line: 428


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

Line: 442


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

Line: 455


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

Line: 470


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

Line: 480


   add_header_line(' --   Updates TL table');

Line: 494


   add_body_line('      SELECT security_group_key');

Line: 506


   add_body_line('      SELECT enterprise_label');

Line: 539


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

Line: 546


   add_body_line('      SELECT   enterprise_label');

Line: 580


   add_body_line('     SELECT   description, meaning');

Line: 676


   add_body_line('     SELECT    enterprise_label');

Line: 690


   add_body_line('          SELECT    enterprise_label');

Line: 790


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

Line: 807


   add_body_line('  SELECT format_name');

Line: 823


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

Line: 826


   add_body_line('     select max(name_format_id)');

Line: 829


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

Line: 834


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

Line: 837


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

Line: 873


   add_body_line('  -- This procedure called from PerEnterprisesTlEOImpl post insert. ');

Line: 890


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

Line: 903


   add_body_line('        select max(group_num) + 1');

Line: 919


   add_body_line('      select to_data_label(''HR_ENTERPRISE_POLICY'', l_enterprise_label)');

Line: 925


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

Line: 945


   add_body_line('      update per_enterprises');

Line: 951


   add_body_line('        insert_hr_name_formats(l_enterprise_label);');

Line: 960


   add_body_line('      select label_to_char(HR_ENTERPRISE) into l_enterprise_label ');

Line: 964


   add_body_line('      select enterprise_label into l_label1 ');

Line: 968


   add_body_line('      update per_enterprises_tl');

Line: 985


   add_body_line('    select ent.enterprise_short_code into l_ent_short_code');

Line: 1006


   add_body_line('    select business_group_id into l_bg_id');

Line: 1033


   add_body_line('select sa_session.sa_user_name(''HR_ENTERPRISE_POLICY'') into user_name from dual;');

Line: 1037


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

Line: 1085


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

Line: 1105


   add_body_line('             SELECT enabled_flag');

Line: 1147


   add_body_line('      SELECT enterprise_label');

Line: 1157


   add_body_line('     SELECT count(*)');

Line: 1181


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

Line: 1194


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

Line: 1217


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

Line: 1223


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

Line: 1241


   add_body_line('          SELECT business_group_id ');

Line: 1252


   add_body_line('      SELECT      organization_id');

Line: 1274


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

Line: 1277


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

Line: 1284


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

Line: 1304


   add_body_line('        SELECT organization_id');

Line: 1328


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

Line: 1336


   add_body_line('    SELECT organization_id');

Line: 1371


   add_body_line('      SELECT description ');

Line: 1384


   add_body_line('    SELECT  security_group_id ');

Line: 1418


   add_body_line('  SELECT business_group_id');

Line: 1448


   add_body_line('      SELECT security_group_id');

Line: 1460


   add_body_line('  SELECT business_group_id');

Line: 1498


   add_body_line('--     Updates TL table');

Line: 1505


   add_body_line('    SELECT pet.enterprise_id');

Line: 1515


   add_body_line('    SELECT l.language_code');

Line: 1518


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

Line: 1525


   add_body_line('   DELETE FROM per_enterprises_tl t');

Line: 1527


   add_body_line('     (  SELECT NULL');

Line: 1532


   add_body_line('   UPDATE per_enterprises_tl t');

Line: 1535


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

Line: 1543


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

Line: 1558


   add_body_line('       INSERT INTO per_enterprises_tl');

Line: 1566


   add_body_line('           ,last_updated_by');

Line: 1567


   add_body_line('           ,last_update_date');

Line: 1732


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

Line: 1743


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

Line: 1774


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

Line: 1813


   add_body_line('             EXECUTE IMMEDIATE ''INSERT INTO per_ent_security_groups ');

Line: 1897


   add_body_line('       SELECT  business_group_id');

Line: 1903


   add_body_line('        SELECT 1');

Line: 1917


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

Line: 1920


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

Line: 1952


   add_body_line('       ''INSERT INTO per_number_generation_controls ');

Line: 1965


   add_body_line('        ''INSERT INTO per_number_generation_controls ');

Line: 1979


   add_body_line('        ''INSERT INTO per_number_generation_controls ');

Line: 2011


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

Line: 2055


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

Line: 2058


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

Line: 2074


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

Line: 2076


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

Line: 2082


   add_body_line('             UPDATE hr_organization_information');

Line: 2088


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

Line: 2090


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

Line: 2097


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

Line: 2100


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

Line: 2120


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

Line: 2122


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

Line: 2144


   add_body_line('      select fou.oracle_username');

Line: 2201


   add_body_line('      select count(*) ');

Line: 2236


   add_body_line('      SELECT count(*) ');

Line: 2239


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

Line: 2405


   add_body_line('      select owner, table_name ');

Line: 2406


   add_body_line('        from (select owner, ');

Line: 2416


   add_body_line('      select row_low_range_or_name, ');

Line: 2418


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

Line: 2474


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

Line: 2598


   add_body_line('    seeddata_table(111) := ''PAY_EVENT_UPDATES'';');

Line: 2953


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

Line: 3011


   add_body_line('                     l_table_options := ''READ_CONTROL, UPDATE_CONTROL, DELETE_CONTROL, LABEL_DEFAULT, HIDE'';');

Line: 3037


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

Line: 3097


   add_body_line('          SELECT status');

Line: 3182


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

Line: 3203


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