APPS.HR_PUMP_META_MAPPER SQL Statements

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

Line: 361

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

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

    p_mapping_package_tbl.delete;

Line: 563

      l_distinct_overloads.delete(i);

Line: 628

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

Line: 644

      p_overload.delete(i);

Line: 645

      p_position.delete(i);

Line: 646

      p_level.delete(i);

Line: 647

      p_argument_name.delete(i);

Line: 648

      p_datatype.delete(i);

Line: 649

      p_default_value.delete(i);

Line: 650

      p_in_out.delete(i);

Line: 651

      p_length.delete(i);

Line: 652

      p_precision.delete(i);

Line: 653

      p_scale.delete(i);

Line: 654

      p_radix.delete(i);

Line: 655

      p_spare.delete(i);

Line: 662

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

Line: 1205

  p_function_tbl.delete;

Line: 1546

    l_mapping_package_tbl.delete;

Line: 1774

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

    l_seed_parameter_tbl.delete;

Line: 1838

    l_mapping_package_tbl.delete;

Line: 1839

    l_distinct_parameter_tbl.delete;

Line: 2023

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

Line: 2055

  'select ';

Line: 2112

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

  l_insert_part1 varchar2(32767);

Line: 2123

  l_insert_part2 varchar2(32767);

Line: 2125

  l_pre_insert   varchar2(32767) := null;

Line: 2138

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

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

Line: 2145

  '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: 2154

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

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

Line: 2216

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

Line: 2224

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

Line: 2231

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

Line: 2242

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

        l_insert_part2 := l_insert_part2 || l_local_var;

Line: 2261

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

Line: 2265

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

Line: 2270

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

Line: 2271

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

Line: 2273

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

Line: 2275

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

Line: 2281

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

Line: 2285

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

Line: 2286

end generate_insert;

Line: 2427

  '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: 3239

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

    if p_first_update then
      p_first_update := false;

Line: 3259

      p_update := p_update || ',';

Line: 3271

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

Line: 3275

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

Line: 3277

      p_update := p_update || l_cursor_field;

Line: 3279

    p_update := p_update || ')';

Line: 3281

end add_to_update;

Line: 3309

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

Line: 3313

  l_first_update    boolean := true;

Line: 3365

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

Line: 3377

  l_update     := 'update hr_pump_batch_lines l set';

Line: 3398

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

Line: 3416

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

Line: 3421

    l_update := null;

Line: 3522

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

Line: 3605

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

Line: 3682

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

  l_parameter_tbl.delete;

Line: 3733

  l_function_tbl.delete;

Line: 3734

  l_function_call_tbl.delete;

Line: 3751

  generate( 'hr_assignment_api', 'update_emp_asg' );

Line: 3752

  generate( 'hr_assignment_api', 'update_emp_asg_criteria' );

Line: 3755

  generate( 'hr_position_api', 'update_position' );

Line: 3761

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_PERSON_ADDRESS' );

Line: 3762

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_US_PERSON_ADDRESS' );

Line: 3763

  generate( 'HR_PERSON_ADDRESS_API', 'UPDATE_GB_PERSON_ADDRESS' );

Line: 3767

  generate( 'PY_ELEMENT_ENTRY_API', 'UPDATE_ELEMENT_ENTRY' );

Line: 3768

  generate( 'PY_ELEMENT_ENTRY_API', 'DELETE_ELEMENT_ENTRY' );

Line: 3777

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_PERSONAL_PAY_METHOD' );

Line: 3778

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_GB_PERSONAL_PAY_METHOD' );

Line: 3779

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_US_PERSONAL_PAY_METHOD' );

Line: 3780

  generate( 'HR_PERSONAL_PAY_METHOD_API', 'DELETE_PERSONAL_PAY_METHOD' );

Line: 3787

  generate( 'HR_PERSON_API', 'UPDATE_PERSON' );

Line: 3788

  generate( 'HR_PERSON_API', 'UPDATE_GB_PERSON' );

Line: 3789

  generate( 'HR_PERSON_API', 'UPDATE_US_PERSON' );

Line: 3799

  generate( 'HR_ASSIGNMENT_API', 'UPDATE_US_EMP_ASG' );

Line: 3800

  generate( 'HR_ASSIGNMENT_API', 'UPDATE_GB_EMP_ASG' );

Line: 3829

  purge( 'hr_assignment_api', 'update_emp_asg' );

Line: 3830

  purge( 'hr_assignment_api', 'update_emp_asg_criteria' );

Line: 3833

  purge( 'hr_position_api', 'update_position' );

Line: 3839

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_PERSON_ADDRESS' );

Line: 3840

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_US_PERSON_ADDRESS' );

Line: 3841

  purge( 'HR_PERSON_ADDRESS_API', 'UPDATE_GB_PERSON_ADDRESS' );

Line: 3845

  purge( 'PY_ELEMENT_ENTRY_API', 'UPDATE_ELEMENT_ENTRY' );

Line: 3846

  purge( 'PY_ELEMENT_ENTRY_API', 'DELETE_ELEMENT_ENTRY' );

Line: 3855

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_PERSONAL_PAY_METHOD' );

Line: 3856

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_GB_PERSONAL_PAY_METHOD' );

Line: 3857

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'UPDATE_US_PERSONAL_PAY_METHOD' );

Line: 3858

  purge( 'HR_PERSONAL_PAY_METHOD_API', 'DELETE_PERSONAL_PAY_METHOD' );

Line: 3865

  purge( 'HR_PERSON_API', 'UPDATE_PERSON' );

Line: 3866

  purge( 'HR_PERSON_API', 'UPDATE_GB_PERSON' );

Line: 3867

  purge( 'HR_PERSON_API', 'UPDATE_US_PERSON' );

Line: 3877

  purge( 'HR_ASSIGNMENT_API', 'UPDATE_US_EMP_ASG' );

Line: 3878

  purge( 'HR_ASSIGNMENT_API', 'UPDATE_GB_EMP_ASG' );

Line: 4001

  l_parameter_tbl.delete;

Line: 4002

  l_function_tbl.delete;

Line: 4003

  l_function_call_tbl.delete;

Line: 4015

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

Line: 4019

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

Line: 4096

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