The following lines contain the word 'select', 'insert', 'update' or 'delete':
select round(ceil(max(bld_blk_info_type_id)/1000),0)*1000
from hxc_bld_blk_info_types;
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;
g_mappings.delete;
g_deposit_map.delete;
g_deposit_bbit_map.delete;
g_retrieval_map.delete;
g_retrieval_bbit_map.delete;
select ascv.application_set_id
,ascv.time_recipient_id
from hxc_application_Set_comps_v ascv;
select deposit_process_id
from hxc_deposit_processes
where name = 'OTL Deposit Process';
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');
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;
End update_value;
p_app_attributes(l_index).updated := 'Y';
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;
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
);
p_app_attributes(l_index).updated := 'Y';
End update_attributes;