APPS.HR_PUMP_META_MAPPER SQL Statements

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

Line: 362

  select upper(hrpmp.api_parameter_name),
         upper(hrpmp.mapping_type),
         upper(hrpmp.mapping_definition),
         hrpmp.default_value
  from   hr_api_modules ham,
         hr_pump_module_parameters hrpmp
  where  upper(ham.module_package) = upper(p_module_package)
  and    upper(ham.module_name) = upper(p_module_name)
  and    upper(ham.api_module_type) in ( 'AI', 'BP','DM' )
  and    upper(hrpmp.module_name) = upper(p_module_name)
  and    upper(hrpmp.api_module_type) = upper(ham.api_module_type);

Line: 438

  select mp.mapping_package
  from   hr_pump_mapping_packages mp,
         hr_api_modules am
  where  (mp.module_name is not null and
          upper(mp.module_name) = upper(p_module_name) and
          upper(am.module_name) = upper(p_module_name) and
          upper(am.api_module_type) = upper(mp.api_module_type))
  or     (mp.module_package is not null and
          upper(mp.module_package) = upper(p_module_package))
  or     (mp.module_package is null and mp.module_name is null)
  order by checking_order asc;

Line: 468

    p_mapping_package_tbl.delete;

Line: 564

      l_distinct_overloads.delete(i);

Line: 629

    hr_utility.trace('Selected overload: ' || l_chosen_overload);

Line: 645

      p_overload.delete(i);

Line: 646

      p_position.delete(i);

Line: 647

      p_level.delete(i);

Line: 648

      p_argument_name.delete(i);

Line: 649

      p_datatype.delete(i);

Line: 650

      p_default_value.delete(i);

Line: 651

      p_in_out.delete(i);

Line: 652

      p_length.delete(i);

Line: 653

      p_precision.delete(i);

Line: 654

      p_scale.delete(i);

Line: 655

      p_radix.delete(i);

Line: 656

      p_spare.delete(i);

Line: 663

    hr_utility.trace('get_latest_api: deleted unwanted overloads');

Line: 1207

  p_function_tbl.delete;

Line: 1549

    l_mapping_package_tbl.delete;

Line: 1777

  select decode( count(0), 0, c_default_hr_api, c_default_null )
  from  hr_pump_default_exceptions hrpde,
        hr_api_modules ham
  where upper(ham.module_package) = upper(p_module_package)
  and   upper(ham.module_name) = upper(p_module_name)
  and   upper(ham.api_module_type) in ('AI', 'BP', 'DM')
  and   upper(hrpde.module_name) = upper(p_module_name)
  and   upper(hrpde.api_module_type) = upper(ham.api_module_type);

Line: 1828

    l_seed_parameter_tbl.delete;

Line: 1841

    l_mapping_package_tbl.delete;

Line: 1842

    l_distinct_parameter_tbl.delete;

Line: 2026

  select status
  from   user_objects
  where  upper(object_name) = upper(p_object_name)
  and    upper(object_type) = upper(p_object_type);

Line: 2058

  'select ';

Line: 2115

procedure generate_insert
(
  p_api_module_id    in     number,
  p_parameter_tbl    in     t_parameter_tbl,
  p_parameter_counts in     t_parameter_counts,
  p_header           in out nocopy varchar2,
  p_body             in out nocopy varchar2
)
is
  l_interface    varchar2(32767);

Line: 2125

  l_insert_part1 varchar2(32767);

Line: 2126

  l_insert_part2 varchar2(32767);

Line: 2128

  l_pre_insert   varchar2(32767) := null;

Line: 2141

  l_insert_part1 := c_newline ||
  'if blid is not null then' || c_newline ||
  'delete from hr_pump_batch_lines where batch_line_id = blid;' ||

Line: 2144

  c_newline || 'delete from hr_pump_batch_exceptions' ||
  c_newline || 'where source_type = ''BATCH_LINE'' and source_id = blid;' ||

Line: 2148

  'insert into hr_pump_batch_lines' || c_newline ||
  '(batch_id'                       || c_newline ||
  ',batch_line_id'                  || c_newline ||
  ',business_group_name'            || c_newline ||
  ',api_module_id'                  || c_newline ||
  ',line_status'                    || c_newline ||
  ',user_sequence'                  || c_newline ||
  ',link_value';

Line: 2157

  l_insert_part2 := 'values'        || c_newline ||
  '(p_batch_id'                     || c_newline ||
  ',nvl(blid,hr_pump_batch_lines_s.nextval)'  || c_newline ||
  ',p_data_pump_business_grp_name'  || c_newline ||
  ',' || to_char(p_api_module_id)   || c_newline ||
  ',''U'''                          || c_newline ||
  ',p_user_sequence'                || c_newline ||
  ',p_link_value';

Line: 2215

      l_insert_part1 :=
      l_insert_part1 || c_newline || ',' ||
      p_parameter_tbl(i).batch_lines_column;

Line: 2219

      l_insert_part2 :=
      l_insert_part2 || c_newline || ',';

Line: 2227

        l_insert_part2 :=
        l_insert_part2 || 'dd(' || p_parameter_tbl(i).parameter_name ||
        ',' || l_indicator || ')';

Line: 2234

        l_insert_part2 :=
        l_insert_part2 || 'dc(' || p_parameter_tbl(i).parameter_name || ')';

Line: 2245

        l_pre_insert :=
        l_pre_insert || c_newline ||
        'if ' || p_parameter_tbl(i).parameter_name || ' is null then' ||
        c_newline ||
        ' ' || l_local_var || ' := null;' || c_newline ||

Line: 2257

        l_insert_part2 := l_insert_part2 || l_local_var;

Line: 2264

        l_insert_part2 :=
        l_insert_part2 || 'nd(' || p_parameter_tbl(i).parameter_name ||
        ',' || l_indicator || ')';

Line: 2268

        l_insert_part2 := l_insert_part2 || p_parameter_tbl(i).parameter_name;

Line: 2273

  l_insert_part1 := l_insert_part1 || ')' || c_newline;

Line: 2274

  l_insert_part2 := l_insert_part2 || ');' || c_newline;

Line: 2276

  p_header := p_header || 'procedure insert_batch_lines' || l_interface || ';';

Line: 2278

  p_body || 'procedure insert_batch_lines' || l_interface || ' is';

Line: 2284

  if l_pre_insert is not null then
    p_body := p_body || l_pre_insert;

Line: 2288

  p_body || l_insert_part1 || l_insert_part2 || 'end insert_batch_lines;';

Line: 2289

end generate_insert;

Line: 2430

  'insert into hr_pump_batch_line_user_keys'  || c_newline ||
  '(user_key_id, batch_line_id,user_key_value,unique_key_id)' ||
  c_newline ||
  'values' || c_newline ||
  '(hr_pump_batch_line_user_keys_s.nextval,' || c_newline ||
  'p_batch_line_id,'                         || c_newline ||
  'p_user_key_value,'                        || c_newline ||
  'p_unique_key_id);'                        || c_newline ||

Line: 3242

procedure add_to_update
(
  p_update         in out nocopy varchar2,
  p_parameter      in     t_parameter,
  p_local_variable in     varchar2,
  p_first_update   in out nocopy boolean
)
is
  l_cursor_field varchar2(64);

Line: 3259

    if p_first_update then
      p_first_update := false;

Line: 3262

      p_update := p_update || ',';

Line: 3274

    p_update :=
    p_update || c_newline ||
    l_column || ' = decode(' || l_cursor_field || ',null,cn,';

Line: 3278

      p_update := p_update || 'dc(' || l_cursor_field || ')';

Line: 3280

      p_update := p_update || l_cursor_field;

Line: 3282

    p_update := p_update || ')';

Line: 3284

end add_to_update;

Line: 3312

  l_update          varchar2(32767); -- Update batch lines with output data.

Line: 3316

  l_first_update    boolean := true;

Line: 3368

  l_cursor     := 'cursor cr is' || c_newline || 'select l.rowid myrowid';

Line: 3380

  l_update     := 'update hr_pump_batch_lines l set';

Line: 3401

    add_to_update( l_update, p_parameter_tbl(i), l_local_variable,
                   l_first_update );

Line: 3419

  if not l_first_update then
    l_update :=
    l_update || c_newline ||
    'where l.rowid = c.myrowid;';

Line: 3424

    l_update := null;

Line: 3525

  p_body := p_body || l_update || c_newline || '--' || c_newline;

Line: 3608

    generate_insert( p_api_module_id, p_parameter_tbl, p_parameter_counts,
                     l_header, l_body );

Line: 3685

  select api_module_id
  from   hr_api_modules
  where  upper(module_name) = upper(p_module_name)
  and    upper(module_package) = upper(p_module_package)
  and    upper(api_module_type) in ('AI', 'BP', 'DM');

Line: 3735

  l_parameter_tbl.delete;

Line: 3736

  l_function_tbl.delete;

Line: 3737

  l_function_call_tbl.delete;

Line: 3755

  generate( 'hr_assignment_api', 'update_emp_asg' );

Line: 3756

  generate( 'hr_assignment_api', 'update_emp_asg_criteria' );

Line: 3759

  generate( 'hr_position_api', 'update_position' );

Line: 3765

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_PERSON_ADDRESS' );

Line: 3766

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_US_PERSON_ADDRESS' );

Line: 3767

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_GB_PERSON_ADDRESS' );

Line: 3771

  generate( 'PY_ELEMENT_ENTRY_API', 'UPDATE_ELEMENT_ENTRY' );

Line: 3772

  generate( 'PY_ELEMENT_ENTRY_API', 'DELETE_ELEMENT_ENTRY' );

Line: 3781

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_PERSONAL_PAY_METHOD' );

Line: 3782

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_GB_PERSONAL_PAY_METHOD' );

Line: 3783

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_US_PERSONAL_PAY_METHOD' );

Line: 3784

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'DELETE_PERSONAL_PAY_METHOD' );

Line: 3791

  generate( 'HR_PERSON_API', 'UPDATE_PERSON' );

Line: 3792

  generate( 'HR_PERSON_API', 'UPDATE_GB_PERSON' );

Line: 3793

  generate( 'HR_PERSON_API', 'UPDATE_US_PERSON' );

Line: 3803

  generate( 'HR_ASSIGNMENT_API', 'UPDATE_US_EMP_ASG' );

Line: 3804

  generate( 'HR_ASSIGNMENT_API', 'UPDATE_GB_EMP_ASG' );

Line: 3833

  purge( 'hr_assignment_api', 'update_emp_asg' );

Line: 3834

  purge( 'hr_assignment_api', 'update_emp_asg_criteria' );

Line: 3837

  purge( 'hr_position_api', 'update_position' );

Line: 3843

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_PERSON_ADDRESS' );

Line: 3844

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_US_PERSON_ADDRESS' );

Line: 3845

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_GB_PERSON_ADDRESS' );

Line: 3849

  purge( 'PY_ELEMENT_ENTRY_API', 'UPDATE_ELEMENT_ENTRY' );

Line: 3850

  purge( 'PY_ELEMENT_ENTRY_API', 'DELETE_ELEMENT_ENTRY' );

Line: 3859

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_PERSONAL_PAY_METHOD' );

Line: 3860

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_GB_PERSONAL_PAY_METHOD' );

Line: 3861

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_US_PERSONAL_PAY_METHOD' );

Line: 3862

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'DELETE_PERSONAL_PAY_METHOD' );

Line: 3869

  purge( 'HR_PERSON_API', 'UPDATE_PERSON' );

Line: 3870

  purge( 'HR_PERSON_API', 'UPDATE_GB_PERSON' );

Line: 3871

  purge( 'HR_PERSON_API', 'UPDATE_US_PERSON' );

Line: 3881

  purge( 'HR_ASSIGNMENT_API', 'UPDATE_US_EMP_ASG' );

Line: 3882

  purge( 'HR_ASSIGNMENT_API', 'UPDATE_GB_EMP_ASG' );

Line: 4005

  l_parameter_tbl.delete;

Line: 4006

  l_function_tbl.delete;

Line: 4007

  l_function_call_tbl.delete;

Line: 4019

  select 1 from user_views
  where  upper(view_name) = upper(p_view_name);

Line: 4023

  select 1 from user_objects
  where  upper(object_name) = upper(p_pkg_name)
  and    object_type = 'PACKAGE';

Line: 4100

    select module_package,module_name
    into l_module_package,l_module_name
    from hr_api_modules
    where api_module_id = p_api_id;