APPS.HXC_APP_ATTRIBUTE_UTILS SQL Statements

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

Line: 20

     select round(ceil(max(bld_blk_info_type_id)/1000),0)*1000
       from hxc_bld_blk_info_types;

Line: 40

select mc.segment
      ,mc.field_name
      ,bbui.building_block_category category
      ,bbit.bld_blk_info_type info_type
      ,rp.retrieval_process_id
      ,dp.deposit_process_id
      ,mc.mapping_component_id
      ,bbit.bld_blk_info_type_id
      ,to_number(nvl(replace(replace(mc.segment,'ATTRIBUTE'),'_CATEGORY'),0))
from hxc_mapping_components mc
    ,hxc_mapping_comp_usages mcu
    ,hxc_mappings m1
    ,hxc_mappings m2
    ,hxc_retrieval_processes rp
    ,hxc_deposit_processes dp
    ,hxc_bld_blk_info_types bbit
    ,hxc_bld_blk_info_type_usages bbui
where rp.mapping_id (+) = m1.mapping_id
  and dp.mapping_id (+) = m2.mapping_id
  and m1.mapping_id = mcu.mapping_id
  and m2.mapping_id = mcu.mapping_id
  and mcu.mapping_component_id = mc.mapping_component_id
  and mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
  AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
  order by 6,5,8,9;

Line: 206

    g_mappings.delete;

Line: 207

    g_deposit_map.delete;

Line: 208

    g_deposit_bbit_map.delete;

Line: 209

    g_retrieval_map.delete;

Line: 210

    g_retrieval_bbit_map.delete;

Line: 257

   select ascv.application_set_id
         ,ascv.time_recipient_id
     from hxc_application_Set_comps_v ascv;

Line: 291

  select deposit_process_id
    from hxc_deposit_processes
   where name = 'OTL Deposit Process';

Line: 296

select substr(fcu.form_left_prompt,1,30) prompt
from hxc_mapping_components mc
    ,hxc_bld_blk_info_types bbit
    ,fnd_descr_flex_col_usage_tl fcu
where mc.mapping_component_id = p_comp_id
  and mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
  and fcu.application_column_name = mc.segment
  and fcu.descriptive_flex_context_code = bbit.bld_blk_info_type
  and fcu.descriptive_flexfield_name = 'OTC Information Types'
  and fcu.application_id = 809
  and fcu.language = userenv('LANG');

Line: 1684

Procedure update_value
           (p_attributes in out nocopy hxc_attribute_table_type
           ,p_index      in            number
           ,p_segment    in            hxc_mapping_components.segment%type
           ,p_value      in            hxc_time_attributes.attribute1%type
           ) is

Begin

if(p_segment = 'ATTRIBUTE1') then
  p_attributes(p_index).attribute1 := p_value;

Line: 1759

End update_value;

Line: 1915

    p_app_attributes(l_index).updated := 'Y';

Line: 1927

Procedure update_attributes
           (p_attributes     in out nocopy hxc_attribute_table_type
           ,p_app_attributes in out nocopy hxc_self_service_time_deposit.app_attributes_info
           ) is

l_index number;

Line: 1939

  if (NVL(p_app_attributes(l_index).updated,'N') = 'N') then
    if (p_app_attributes(l_index).attribute_index is not null) then
      update_value
        (p_attributes => p_attributes
        ,p_index      => p_app_attributes(l_index).attribute_index
        ,p_segment    => p_app_attributes(l_index).segment
        ,p_value      => p_app_attributes(l_index).attribute_value
        );

Line: 1954

    p_app_attributes(l_index).updated := 'Y';

Line: 1960

End update_attributes;