DBA Data[Home] [Help]

APPS.HR_REGISTER_EITS SQL Statements

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

Line: 31

   l_insert     varchar2(2000):= 'The Information Type: ' || v_info_type_name  || ' has been inserted into the table: ' || v_table_name;
Line: 40

   l_updated_by     number := fnd_profile.value('USER_ID');
Line: 41

   l_update_login   number := fnd_profile.value('USER_ID');
Line: 43

   l_update_date    date   := trunc(sysdate);
Line: 71

     INSERT INTO PER_PEOPLE_INFO_TYPES
     (INFORMATION_TYPE
     ,ACTIVE_INACTIVE_FLAG
     ,MULTIPLE_OCCURENCES_FLAG
     ,DESCRIPTION
     ,LEGISLATION_CODE
     ,OBJECT_VERSION_NUMBER)
     VALUES
     (v_info_type_name
     ,v_active_flag
     ,v_multi_row
     ,v_desc
     ,v_leg_code
     ,1);
Line: 86

     fnd_file.put_line(fnd_file.log,l_insert);
Line: 93

      INSERT INTO PER_ASSIGNMENT_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 108

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 110

      insert into PER_ASSIGNMENT_INFO_TYPES_TL
      (INFORMATION_TYPE
      ,LANGUAGE
      ,SOURCE_LANG
      ,DESCRIPTION
      ,LAST_UPDATE_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_LOGIN
      ,CREATED_BY
      ,CREATION_DATE
      )
      select M.INFORMATION_TYPE
      ,L.LANGUAGE_CODE
      ,B.LANGUAGE_CODE
      ,M.DESCRIPTION
      ,M.LAST_UPDATE_DATE
      ,M.LAST_UPDATED_BY
      ,M.LAST_UPDATE_LOGIN
      ,M.CREATED_BY
      ,M.CREATION_DATE
      from PER_ASSIGNMENT_INFO_TYPES M
          ,FND_LANGUAGES L
          ,FND_LANGUAGES B
      where M.INFORMATION_TYPE = v_info_type_name
      and   L.INSTALLED_FLAG in ('I', 'B')
      and   B.INSTALLED_FLAG   = 'B'
      and   not exists (select '1'
                       from  per_assignment_info_types_tl pait
                       where pait.information_type = m.information_type
                       and   pait.language         = l.language_code);
Line: 141

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 146

      INSERT INTO PER_POSITION_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 161

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 166

      INSERT INTO PQP_VEH_ALLOC_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 181

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 186

      INSERT INTO PQP_VEH_REPOS_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 201

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 205

      INSERT INTO HR_LOCATION_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 220

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 225

      INSERT INTO PER_JOB_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 240

       fnd_file.put_line(fnd_file.log,l_insert);
Line: 245

      INSERT INTO PER_CONTACT_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_leg_code
      ,1);
Line: 258

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 260

      insert into PER_CONTACT_INFO_TYPES_TL
      (INFORMATION_TYPE
      , LANGUAGE
      , SOURCE_LANG
      , DESCRIPTION
      , LAST_UPDATE_DATE
      , LAST_UPDATED_BY
      , LAST_UPDATE_LOGIN
      , CREATED_BY
      , CREATION_DATE
   )
   select M.INFORMATION_TYPE
      , L.LANGUAGE_CODE
      , B.LANGUAGE_CODE
      , v_desc
      , M.LAST_UPDATE_DATE
      , M.LAST_UPDATED_BY
      , M.LAST_UPDATE_LOGIN
      , M.CREATED_BY
      , M.CREATION_DATE
   from PER_CONTACT_INFO_TYPES M
      , FND_LANGUAGES L
      , FND_LANGUAGES B
   where  M.INFORMATION_TYPE = v_info_type_name
   and    L.INSTALLED_FLAG in ('I', 'B')
   and    B.INSTALLED_FLAG   = 'B'
   and not exists ( select '1'
                    from per_contact_info_types_tl pcit
                    where pcit.information_type = m.information_type
                    and pcit.language           = l.language_code);
Line: 291

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 297

      INSERT INTO PER_PREV_JOB_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURANCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 312

       fnd_file.put_line(fnd_file.log,l_insert);
Line: 316

      INSERT INTO PAY_ELEMENT_TYPE_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 331

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 337

      INSERT INTO  BEN_OPT_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 351

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 356

      INSERT INTO BEN_ABR_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 370

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 374

      INSERT INTO BEN_PL_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 388

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 392

      INSERT INTO BEN_ELP_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 406

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 410

      INSERT INTO BEN_LER_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 424

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 428

      INSERT INTO BEN_PGM_INFO_TYPES
      (INFORMATION_TYPE
      ,ACTIVE_INACTIVE_FLAG
      ,MULTIPLE_OCCURENCES_FLAG
      ,DESCRIPTION
      ,LEGISLATION_CODE
      ,OBJECT_VERSION_NUMBER)
      VALUES
      (v_info_type_name
      ,v_active_flag
      ,v_multi_row
      ,v_desc
      ,v_leg_code
      ,1);
Line: 442

   fnd_file.put_line(fnd_file.log,l_insert);
Line: 462

	hr_org_information_types_pkg.insert_row
						(v_info_type_name
						 ,null
						 ,v_leg_code
						 ,l_navig_method
						 ,l_application_id
						 ,v_desc
						 ,v_desc
						 ,l_creation_date
						 ,l_created_by
						 ,l_update_date
						 ,l_updated_by
						 ,l_update_login);
Line: 476

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 482

      INSERT INTO HR_ORG_INFO_TYPES_BY_CLASS
 	 (ORG_CLASSIFICATION
	 ,ORG_INFORMATION_TYPE
	 ,MANDATORY_FLAG
         ,ENABLED_FLAG )
	 SELECT
	  v_org_class
	 ,v_info_type_name
	 ,'N'
         ,'Y'
	 FROM sys.dual
	 WHERE not exists (SELECT 1
	 FROM HR_ORG_INFO_TYPES_BY_CLASS
	 WHERE ORG_INFORMATION_TYPE =v_info_type_name
	 and ORG_CLASSIFICATION = v_org_class);
Line: 498

      l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;
Line: 500

      fnd_file.put_line(fnd_file.log,l_insert);
Line: 527

  l_insert                 := 'The Document Type : "' || p_info_type_name || '" has been created';
Line: 548

   fnd_file.put_line(fnd_file.log,l_insert);