APPS.HR_DM_SEED_DP SQL Statements

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

Line: 29

   insert into hr_api_modules (
          api_module_id,
          api_module_type,
          module_name,
          data_within_business_group,
          legislation_code,
          module_package)
   select hr_api_modules_s.nextval,
          p_module_type,
          p_module_name,
          p_data_within_business_group,
          p_legislation_code,
          p_module_package
   from   sys.dual
   where  not exists (
          select null
          from   hr_api_modules m
          where  m.module_name     = p_module_name
          and    m.api_module_type = p_module_type);

Line: 69

procedure insert_dp_parameters
(
   p_module_name    in varchar2,
   p_module_type    in varchar2,
   p_parameter_name in varchar2,
   p_mapping_type   in varchar2   default 'NORMAL',
   p_mapping_def    in varchar2   default null,
   p_default_value  in varchar2   default null
) is
begin
  hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.insert_dp_parameters', 5);

Line: 89

   insert into hr_pump_module_parameters (
          module_name,
          api_module_type,
          api_parameter_name,
          mapping_type,
          mapping_definition,
          default_value)
   select p_module_name,
          p_module_type,
          ltrim(lpad(p_parameter_name,30)),
          p_mapping_type,
          p_mapping_def,
          p_default_value
   from   sys.dual
   where  not exists (
          select null
          from   hr_pump_module_parameters p
          where  p.module_name        = p_module_name
          and    p.api_module_type    = p_module_type
          and    p.api_parameter_name = p_parameter_name);

Line: 109

  hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.insert_dp_parameters', 25);

Line: 113

    hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.insert_dp_parameters',
                       '(p_module_name - ' || p_module_name ||
                       ')(p_module_type - ' || p_module_type ||
                       ')(p_parameter_name - ' || p_parameter_name ||
                       ')(p_mapping_type - ' || p_mapping_type ||
                       ')(p_mapping_def - ' || p_mapping_def ||
                       ')(p_default_value - ' || p_default_value ||
                       ')','R');

Line: 122

end insert_dp_parameters;

Line: 165

      insert_dp_parameters ( p_module_name    => p_module_name,
                             p_module_type    => p_module_type,
                             p_parameter_name => 'P_' || l_column_name);