APPS.HR_SUMMARY_API SQL Statements

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

Line: 5

update_allowed exception;

Line: 40

  select id_value,
         object_version_number
  from   hr_summary
  where  (type = p_type
          and p_type in ('TEMPLATE','ITEM_TYPE','KEY_TYPE','RESTRICTION_TYPE')
          and text_value1 = p_text_value1
          and business_group_id = p_business_group_id
         )
  or
         (type = p_type
          and p_type IN ('RESTRICTION_USAGE','VALID_KEY_TYPE','KEY_TYPE_USAGE','VALID_RESTRICTION')
          and fk_value1 = p_fk_value1
          and fk_value2 = p_fk_value2
          and business_group_id = p_business_group_id
         )
  or     (type = p_type
          and p_type = 'ITEM_TYPE_USAGE'
          and fk_value1 = p_fk_value1
          and business_group_id = p_business_group_id
          and text_value1 = p_text_value1
         )
  or     (type = p_type
          and p_type = 'PROCESS_RUN'
          and text_value2 = p_text_value2
          and text_value1 = p_text_value1
          and business_group_id = p_business_group_id
         )
  or     (type = p_type
          and p_type = 'RESTRICTION_VALUE'
          and fk_value1 = p_fk_value1
          and text_value1 = p_text_value1
          and business_group_id = p_business_group_id
         );

Line: 98

  select id_value
  from   hr_summary
  where  text_value1 = p_name
  and    type        = p_type
  and    business_group_id = p_business_group_id;

Line: 122

  select itu.id_value
  from   hr_summary itu,
         hr_summary t,
         hr_summary it
  where  it.id_value = itu.fk_value2
  and    t.id_value = itu.fk_value1
  and    itu.text_value1 = p_itu_name
  and    it.business_group_id = p_business_group_id
  and    it.text_value1 = p_item_type_name
  and    it.type = 'ITEM_TYPE'
  and    t.business_group_id  = p_business_group_id
  and    t.text_value1 = p_template_name
  and    t.type = 'TEMPLATE';

Line: 153

  select itu.id_value
  from   hr_summary itu,
         hr_summary t
  where  t.id_value = itu.fk_value1
  and    itu.num_value1 = p_sequence_number
  and    itu.type = 'ITEM_TYPE_USAGE'
  and    t.business_group_id  = p_business_group_id
  and    t.text_value1 = p_template_name
  and    t.type = 'TEMPLATE';

Line: 180

  select vkt.id_value
  from   hr_summary  vkt,
         hr_summary  kt,
         hr_summary  it
  where  kt.id_value = vkt.fk_value2
  and    it.id_value = vkt.fk_value1
  and    kt.business_group_id = p_business_group_id
  and    kt.text_value1 = p_key_type_name
  and    kt.type = 'KEY_TYPE'
  and    it.business_group_id = p_business_group_id
  and    it.text_value1 = p_item_type_name
  and    it.type = 'ITEM_TYPE';

Line: 208

  select vr.id_value
  from   hr_summary vr,
         hr_summary it,
         hr_summary rt
  where  it.id_value = vr.fk_value1
  and    vr.fk_value2 = rt.id_value
  and    it.business_group_id = p_business_group_id
  and    it.type = 'ITEM_TYPE'
  and    it.text_value1 = p_item_type_name
  and    rt.business_group_id = p_business_group_id
  and    rt.type = 'RESTRICTION_TYPE'
  and    rt.text_value1 = p_restriction_name;

Line: 238

  select restriction_usage_id
  from   hr_summary_restriction_usage
  where  item_type_usage_id   = hr_summary_api.get_itu_id(p_template,p_item,p_itu_name,p_business_group_id)
  and    valid_restriction_id = hr_summary_api.get_ru_id(p_restriction,p_item,p_business_group_id)
  and    business_group_id = p_business_group_id;

Line: 261

  select restriction_usage_id
  from   hr_summary_restriction_usage
  where  item_type_usage_id   = hr_summary_api.get_itu_id(p_template,p_itu_seq_num,p_business_group_id)
  and    valid_restriction_id = hr_summary_api.get_ru_id(p_restriction,p_item,p_business_group_id)
  and    business_group_id = p_business_group_id;

Line: 836

procedure delete_hr_summary (p_validate              in boolean
                            ,p_id_value              in number
                            ,p_object_version_number in number) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := 'hr_summary_api.delete_hr_summary';

Line: 851

  savepoint delete_hr_summary;

Line: 880

    ROLLBACK TO delete_hr_summary;

Line: 891

    ROLLBACK TO delete_hr_summary;

Line: 893

end delete_hr_summary;