APPS.HR_KFLEX_UTILITY SQL Statements

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

Line: 45

    select application_id
    from   fnd_application
    where  application_short_name = p_appl_short_name;

Line: 108

    select count(*)
    from   fnd_id_flex_segments
    where  id_flex_code = p_flex_code
    and    id_flex_num  = p_flex_num
    and    application_id = p_application_id
    and    enabled_flag = 'Y';

Line: 329

     select EFFECTIVE_DATE from fnd_sessions
     where session_id=userenv('sessionid');

Line: 570

     select EFFECTIVE_DATE from fnd_sessions
     where session_id=userenv('sessionid');

Line: 949

    select substr(application_column_name,8,2)
    from   fnd_id_flex_segments_vl
    where  id_flex_code = p_flex_code
    and    id_flex_num  = p_flex_num
    and    enabled_flag='Y'
    and    application_id = p_application_id
    order by to_number(substr(application_column_name,8,2));

Line: 958

    select substr(application_column_name,8,2)
    from   fnd_id_flex_segments_vl
    where  id_flex_code = p_flex_code
    and    id_flex_num  = p_flex_num
    and    enabled_flag = 'Y'
    and    application_id = p_application_id
    order by segment_num;

Line: 1255

   g_kfcode_structure.delete;

Line: 1641

  l_parameter_updated  fnd_flex_ext.SegmentArray;

Line: 1647

    select substr(application_column_name,8,2)
    from   fnd_id_flex_segments_vl
    where  id_flex_code = p_flex_code
    and    id_flex_num  = p_flex_num
    and    enabled_flag='Y'
    and    application_id = l_application_id  --3456567 to avoid FTS
    order by to_number(substr(application_column_name,8,2));

Line: 1804

            l_parameter_updated(i) := hr_api.g_varchar2;

Line: 1873

             l_parameter_updated(l_seg_num) :=
             l_parameter_original(array_counter);

Line: 1881

               l_parameter_updated(l_seg_num) := nvl(l_parameter_new(l_seg_num), NULL);

Line: 1923

           ,p_parameter           => l_parameter_updated
           ,p_too_many_segs       => l_too_many_segs
           ,p_ccid                => p_ccid
           ,p_concat_segments_out => p_concat_segments_out
           );

Line: 2280

  select 1 from fnd_sessions
  where session_id=userenv('sessionid');

Line: 2336

    delete from fnd_sessions
    where session_id=p_session_id;