[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select fte_mile_dlf_file_s.nextval
from dual;
select flm.origin_id,
flm.destination_id
from fte_location_mileages flm;
select wr.region_id,
wr.state_code,
wr.country_code
from wsh_regions wr
where region_id = cp_region_id;
select wrtl.region_id,
wrtl.postal_code_from,
wrtl.city,
wrtl.state,
null,
wrtl.country
from wsh_regions_v wrtl
where wrtl.region_id = cp_region_id;
select count(origin_id)
from fte_location_mileages;
select flp.location_id
from fte_location_parameters flp
where flp.include_mileage_flag = cp_enabled_flag_y;
select wrl.location_id,
wrl.region_id
from wsh_region_locations wrl
where wrl.location_id = cp_location_id
and wrl.region_type = cp_region_type;
select fmtc.column_id,
fmtc.column_type,
fmtc.start_position,
fmtc.length,
fmtc.column_delimiter,
fmtc.column_sequence
from fte_mile_template_columns fmtc
where fmtc.template_id = cp_template_id
order by fmtc.column_sequence;
select fmca.column_attribute_id,
fmca.code,
fmca.attribute_delimiter,
fmca.space_padding,
fmca.sequence_id,
fmca.length
from fte_mile_column_attributes fmca
where fmca.column_id = cp_column_id
and fmca.enabled_flag = cp_enabled_flag
order by fmca.sequence_id;
select fmca.column_attribute_id,
fmca.code,
fmca.attribute_delimiter,
fmca.space_padding,
fmca.sequence_id,
fmca.length
from fte_mile_column_attributes fmca
where fmca.column_id = cp_column_id
and fmca.enabled_flag = cp_enabled_flag
and fmca.sequence_id = cp_seq_id;
select region_type
from wsh_regions
where region_id = cp_region_id;
select region_id,
region_type
from wsh_regions
where parent_region_id = cp_region_id;
select location_id
from wsh_region_locations
where region_id = cp_region_id;
select include_mileage_flag
from fte_location_parameters
where location_id = cp_location_id;
l_column_id_tab.DELETE;
l_column_type_tab.DELETE;
l_column_start_position_tab.DELETE;
l_column_length_tab.DELETE;
l_column_delimiter_tab.DELETE;
l_column_sequence_id_tab.DELETE;
l_odattr_column_attr_id_tab.DELETE;
l_odattr_code_tab.DELETE;
l_odattr_attr_delimiter_tab.DELETE;
l_odattr_space_padding_tab.DELETE;
l_odattr_sequence_id_tab.DELETE;
l_odattr_length_tab.DELETE;
l_retdis_column_attr_id_tab.DELETE;
l_retdis_code_tab.DELETE;
l_retdis_attr_delimiter_tab.DELETE;
l_retdis_space_padding_tab.DELETE;
l_retdis_sequence_id_tab.DELETE;
l_retdis_length_tab.DELETE;
l_rettim_column_attr_id_tab.DELETE;
l_rettim_code_tab.DELETE;
l_rettim_attr_delimiter_tab.DELETE;
l_rettim_space_padding_tab.DELETE;
l_rettim_sequence_id_tab.DELETE;
l_rettim_length_tab.DELETE;
l_sub_regions_tab.DELETE;
l_sub_region_type_tab.DELETE;
l_parent_sub_regions_tab.DELETE;
l_sub_par_cont_tab.DELETE;
l_match_locations_tab.DELETE;
l_origin_region_id.DELETE;
l_origin_location_id.DELETE;
l_tmp_orig_reg.DELETE;
l_tmp_orig_loc.DELETE;
l_parent_regions_tab.DELETE;
l_match_region_id.DELETE;
l_sub_par_cont_tab.DELETE;
l_match_locations_tab.DELETE;
l_destination_region_id.DELETE;
l_destination_location_id.DELETE;
l_tmp_dest_reg.DELETE;
l_tmp_dest_loc.DELETE;
l_sub_regions_tab.DELETE;
l_sub_region_type_tab.DELETE;
l_parent_sub_regions_tab.DELETE;
l_sub_par_cont_tab.DELETE;
l_match_locations_tab.DELETE;
l_destination_region_id.DELETE;
l_destination_location_id.DELETE;
l_tmp_dest_reg.DELETE;
l_tmp_dest_loc.DELETE;
l_reg_code_region_id_tab.DELETE;
l_reg_code_state_tab.DELETE;
l_reg_code_country_tab.DELETE;
l_reg_code_region_id_tab.DELETE;
l_reg_code_state_tab.DELETE;
l_reg_code_country_tab.DELETE;
l_origin_region_id.DELETE;
l_destination_region_id.DELETE;
l_od_check_tab.DELETE;
l_remove_idx_tab.DELETE;
l_distance_tab_origin_id_tab.DELETE;
l_distance_tab_distance_id_tab.DELETE;
l_od_pair_tab.DELETE(l_remove_idx_tab(jjk));
insert into fte_mile_download_files(DOWNLOAD_FILE_ID,
FILE_NAME,
DOWNLOAD_FILE_EXTENSION,
TEMPLATE_ID,
DOWNLOAD_DATE,
UPLOAD_ID,
UPLOAD_DATE,
IDENTIFIER_TYPE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID)
values(FTE_MILE_DOWNLOAD_FILES_S.NEXTVAL,
substr(p_file_name,1,8),
p_file_extension,
p_template_id,
null,
null,
null,
p_distance_profile,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
null,
null,
null,
null)
RETURNING DOWNLOAD_FILE_ID INTO l_download_file_id;
WSH_DEBUG_SV.log(l_module_name,'insert into fte_mile_download_lines - line number = ',l_line_ctr);
insert into fte_mile_download_lines(DOWNLOAD_FILE_ID,
LINE_NUMBER,
ORIGIN_ID,
DESTINATION_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID)
values(l_download_file_id,
l_line_ctr,
l_od_pair_tab(axe1).origin_id,
l_od_pair_tab(axe1).destination_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
null,
null,
null,
null);
WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');
update fte_mile_download_files
set download_date = sysdate
where download_file_id = l_download_file_id;