The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- call the insert of pvt
OKL_AM_ASSET_RELOCATION_PVT.Relocate_Installed_Item(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list ,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_ialo_tbl => lp_ialo_tbl);
-- call the insert of pvt
OKL_AM_ASSET_RELOCATION_PVT.Relocate_Fixed_Asset(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list ,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_falo_tbl => lp_falo_tbl);
-- call the insert of pvt
OKL_AM_ASSET_RELOCATION_PVT.Change_FA_Location (
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status ,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_assets_tbl => lp_assets_tbl);
-- call the insert of pvt
OKL_AM_ASSET_RELOCATION_PVT.Change_Item_Location(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list ,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_return_status => l_return_status,
p_instance_id => lp_instance_id,
p_location_id => lp_location_id,
p_install_location_id => lp_install_location_id);