APPS.HR_HNM_BUS SQL Statements

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

Line: 42

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

Line: 66

End chk_non_updateable_args;

Line: 100

  select
   'found'
  From
    hr_ki_hierarchies  hrc
  where
    hrc.hierarchy_id = p_hierarchy_id;

Line: 176

  select
   'found'
  From
    hr_ki_topics  tpc
  where
    tpc.topic_id = p_topic_id;

Line: 253

  select
   'found'
  From
    hr_ki_user_interfaces  itf
  where
    itf.user_interface_id = p_user_interface_id;

Line: 435

select
 distinct 'found'
From
 hr_ki_hierarchy_node_maps hnm
where
 hnm.topic_id = p_topic_id
 and hnm.hierarchy_id in
 (
   select hrc.hierarchy_id
   from
   hr_ki_hierarchies hrc
   connect by prior hrc.parent_hierarchy_id = hrc.hierarchy_id
   start with hrc.hierarchy_id = p_hierarchy_id
  );

Line: 452

 select
  distinct 'found'
 From
  hr_ki_hierarchy_node_maps hnm
 where
  hnm.hierarchy_id = p_hierarchy_id and
  hnm.user_interface_id = p_user_interface_id;

Line: 462

 select
 distinct 'found'
 from
  hr_ki_hierarchy_node_maps hnm
 where
 (
   hnm.topic_id = p_topic_id
   and hnm.user_interface_id = p_user_interface_id
 )
 OR
 (
   hnm.topic_id = p_topic_id
   and hnm.hierarchy_id in
   (
    select
     hierarchy_id
    from
     hr_ki_hierarchies hrc
    connect by prior hrc.parent_hierarchy_id = hrc.hierarchy_id
    start with hrc.hierarchy_id in (
                                 select
                                  hierarchy_id
                                 from
                                  hr_ki_hierarchy_node_maps hnm1
                                 where
                                  hnm1.user_interface_id=p_user_interface_id
				  and hnm1.hierarchy_id is not null
                                 )
    )
   );

Line: 597

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

Line: 630

End insert_validate;

Line: 635

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

Line: 650

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 670

End update_validate;

Line: 675

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

Line: 687

End delete_validate;