APPS.HR_TIM_BUS SQL Statements

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

Line: 50

    select tmp.legislation_code
      from hr_form_templates_b tmp
          ,hr_template_items_b tim
     where tmp.form_template_id = tim.form_template_id
       and tim.template_item_id = p_template_item_id;

Line: 138

Procedure chk_non_updateable_args
  (p_rec in hr_tim_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 182

End chk_non_updateable_args;

Line: 247

    select fim.application_id
          ,fim.form_id
      from hr_form_items_b fim
     where fim.form_item_id = p_form_item_id;

Line: 253

    select tmp.application_id
          ,tmp.form_id
      from hr_form_templates_b tmp
     where tmp.form_template_id = p_form_template_id;

Line: 335

  select fim.full_item_name
  from   hr_form_items_b fim
  where  fim.form_item_id = p_form_item_id;

Line: 340

  select 1
  from hr_template_items_b tim, hr_form_items_b fim
  where tim.form_item_id = fim.form_item_id
  and   tim.form_template_id = p_form_template_id
  and   fim.full_item_name = p_block||'.'||p_flex_name;

Line: 347

  select 1
  from hr_template_items_b tim, hr_form_items_b fim
  where tim.form_item_id = fim.form_item_id
  and   tim.form_template_id = p_form_template_id
  and   fim.full_item_name like p_block||'.'||p_segment||'%';

Line: 359

  select 1
  from hr_template_items_b tim, hr_form_items_b fim
  where tim.form_item_id = fim.form_item_id
  and   tim.form_template_id = p_form_template_id
  and  ((fim.full_item_name like p_block||'.ADDRESS_LINE%'
     or fim.full_item_name like p_block||'.REGION_%'
     or fim.full_item_name like p_block||'.POSTAL_CODE%'
     or fim.full_item_name like p_block||'.TOWN_OR_CITY%'
     or fim.full_item_name like p_block||'.COUNTRY%'
     or fim.full_item_name like p_block||'.TELEPHONE_NUMBER_%'
     or fim.full_item_name like p_block||'.ADD_INFORMATION%')
    and fim.full_item_name not like p_block||'.%OF_BIRTH%'
    and fim.full_item_name not like p_block||'.COUNTRY%_MEANING');

Line: 513

Procedure chk_delete
  (p_rec                          in hr_tim_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'chk_delete';

Line: 527

End chk_delete;

Line: 532

Procedure insert_validate
  (p_rec                          in hr_tim_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 564

End insert_validate;

Line: 569

Procedure update_validate
  (p_rec                          in hr_tim_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 581

  chk_non_updateable_args
    (p_rec                          => p_rec
    );

Line: 605

End update_validate;

Line: 610

Procedure delete_validate
  (p_rec                          in hr_tim_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 621

  chk_delete
    (p_rec                          => p_rec
    );

Line: 626

End delete_validate;