APPS.HR_LEG_INSTALLATION_PKG SQL Statements

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

Line: 24

 procedure insert_row(p_application_short_name varchar2,
                      p_legislation_code varchar2,
                      p_status varchar2,
                      p_action varchar2,
                      p_pi_steps_exist varchar2,
                      p_view_name varchar2,
                      p_created_by varchar2,
                      p_creation_date date,
                      p_last_update_login varchar2,
                      p_last_update_date date,
                      p_last_updated_by varchar2) is
 begin
 INSERT INTO  hr_legislation_installations
   (application_short_name,
   legislation_code,
   status,
   action,
   pi_steps_exist,
   view_name,
   created_by,
   creation_date,
   last_update_login,
   last_update_date,
   last_updated_by)
  SELECT
   p_application_short_name,
   p_legislation_code,
   p_status,
   p_action,
   p_pi_steps_exist,
   p_view_name,
   p_created_by,
   p_creation_date,
   p_last_update_login,
   p_last_update_date,
   p_last_updated_by
 from dual
 WHERE not exists (select 1 from hr_legislation_installations
	           where application_short_name=p_application_short_name
		   and nvl(p_legislation_code,'x')=nvl(legislation_code,'x'));

Line: 66

 procedure update_row(p_application_short_name varchar2,
		      p_legislation_code varchar2,
		      p_status varchar2,
		      p_action varchar2,
                      p_created_by varchar2,
                      p_creation_date date,
                      p_last_update_login varchar2,
                      p_last_update_date date,
                      p_last_updated_by varchar2) is
 begin

 UPDATE hr_legislation_installations
 SET status=p_status,
     action=p_action,
     created_by=p_created_by,
     creation_date=p_creation_date,
     last_update_login=p_last_update_login,
     last_update_date=p_last_update_date,
     last_updated_by=p_last_updated_by
 WHERE application_short_name=p_application_short_name
 and nvl(p_legislation_code,'x')=nvl(legislation_code,'x');

Line: 98

  select view_name
  into l_view_name
  from hr_legislation_installations
  where application_short_name=p_product
  and nvl(p_legislation,'x')=nvl(legislation_code,'x');

Line: 106

  select view_name
  into view_exists
  from user_views
  where view_name = l_view_name
  and rownum=1;

Line: 134

  select view_name
  into l_view_name
  from hr_legislation_installations
  where application_short_name=p_product
  and nvl(p_legislation,'x')=nvl(legislation_code,'x');

Line: 140

  statem := 'CREATE OR REPLACE FORCE VIEW ' || l_view_name ||'(product_implemented) AS SELECT ''product_implemented'' from dual';

Line: 161

  select distinct legislation_code
  from pay_element_classifications
  where legislation_code in ('GB','US','JP');

Line: 166

   select count(*)
   into hr_installed
   from fnd_product_installations
   where  application_id=800 and status='I';

Line: 171

   select  count(*)
   into pay_installed
   from fnd_product_installations
   where  application_id=801 and status='I';

Line: 176

   select  count(*)
   into ghr_installed
   from fnd_product_installations
   where  application_id=8301 and status='I';

Line: 183

     update_row('GHR', 'US', 'I', NULL,NULL,NULL,NULL,NULL,NULL);

Line: 186

   update_row('PER',NULL,'I',NULL,NULL,NULL,NULL,NULL,NULL);

Line: 188

     update_row('PER',leg_codes.legislation_code,'I',NULL,NULL,NULL,NULL,NULL,NULL);

Line: 191

     update_row('PAY',leg_codes.legislation_code,'I',NULL,NULL,NULL,NULL,NULL,NULL);

Line: 195

      select  count(*)
      into school_data_installed
      from per_establishments
      where rownum=1;

Line: 200

        update_row('CM',leg_codes.legislation_code,'I',NULL,NULL,NULL,NULL,NULL,NULL);

Line: 209

  select application_short_name,legislation_code
  from hr_legislation_installations
  where status='I' ;